Introduction
This post is about How to Extract All the Asset Categories Book Wise with all Code Combinations in Oracle EBS R12.
Script to Extract All the Asset Categories Book Wise with all Code Combinations
gl3.segment1||’-‘||gl3.SEGMENT2||’-‘||gl3.SEGMENT3||’-‘||gl3.SEGMENT4||’-‘||gl3.SEGMENT5 DEPRN_RESERVE_ACCOUNT,
deprn_method, life_in_months, (life_in_months/12) lIFE, prorate_convention_code
FROM apps.fa_categories a,
apps.FA_CATEGORY_BOOK_DEFAULTS b,
apps.fa_category_books c,
apps.gl_code_combinations gl1,
apps.gl_code_combinations gl2,
apps.gl_code_combinations gl3
WHERE a.category_id = b.category_id
AND c.category_id = b.category_id
AND c.category_id = a.category_id
AND a.ENABLED_FLAG = ‘Y’
AND c.ASSET_COST_ACCOUNT_CCID = gl1.CODE_COMBINATION_ID
AND c.ASSET_CLEARING_ACCOUNT_CCID = gl2.CODE_COMBINATION_ID
AND c.RESERVE_ACCOUNT_CCID = gl3.CODE_COMBINATION_ID
–AND c.WIP_COST_ACCOUNT_CCID = gl4.CODE_COMBINATION_ID
–AND c.WIP_CLEARING_ACCOUNT_CCID = gl5.CODE_COMBINATION_ID
AND b.book_type_code = c.book_type_code
AND c.book_type_code = ‘CY_TAX_GAAP’
Summary
This post described the script How to Extract All the Asset Categories Book Wise with all Code Combination in Oracle EBS R12. Couple of Tables which is being used in the script are.
apps.fa_categories,apps.fa_category_book_defaults,apps.fa_category_books
,apps.gl_code_combinations,apps.gl_code_combinations,
apps.gl_code_combinations gl3
Got any queries?
Do drop a note by writing us at doyen.ebiz@gmail.com or use the comment section below to ask your questions.
