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…
Read More