How 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’

Thanks,
Nagaraju M
  • September 20, 2018 | 20 views
  • Comments