[Home] [Help]
393: l_secondary := 1;
394: END IF;
395:
396:
397: insert into fa_xla_ext_lines_stg_gt (
398: EVENT_ID ,
399: EVENT_TYPE_CODE ,
400: TRANSACTION_HEADER_ID ,
401: MEMBER_TRANSACTION_HEADER_ID ,
499: if (fa_xla_extract_util_pkg.G_group_enabled) then
500:
501:
502:
503: insert into fa_xla_ext_lines_stg_gt (
504: EVENT_ID ,
505: EVENT_TYPE_CODE ,
506: TRANSACTION_HEADER_ID ,
507: MEMBER_TRANSACTION_HEADER_ID ,
648: l_secondary := 1;
649: END IF;
650:
651:
652: insert into fa_xla_ext_lines_stg_gt (
653: EVENT_ID ,
654: EVENT_TYPE_CODE ,
655: TRANSACTION_HEADER_ID ,
656: MEMBER_TRANSACTION_HEADER_ID ,
756: if (fa_xla_extract_util_pkg.G_group_enabled) then
757:
758:
759:
760: insert into fa_xla_ext_lines_stg_gt (
761: EVENT_ID ,
762: EVENT_TYPE_CODE ,
763: TRANSACTION_HEADER_ID ,
764: MEMBER_TRANSACTION_HEADER_ID ,
862:
863:
864: end if;
865:
866: insert into fa_xla_ext_lines_stg_gt (
867: EVENT_ID ,
868: EVENT_TYPE_CODE ,
869: TRANSACTION_HEADER_ID ,
870: MEMBER_TRANSACTION_HEADER_ID ,
970: if (fa_xla_extract_util_pkg.G_group_enabled) then
971:
972:
973:
974: insert into fa_xla_ext_lines_stg_gt (
975: EVENT_ID ,
976: EVENT_TYPE_CODE ,
977: TRANSACTION_HEADER_ID ,
978: MEMBER_TRANSACTION_HEADER_ID ,
1300: stg.CIP_COST_ACCT,
1301: stg.DEPRN_RESERVE_ACCT,
1302: stg.REVAL_RESERVE_ACCT,
1303: stg.TRANSACTION_HEADER_ID
1304: from fa_xla_ext_lines_stg_gt stg,
1305: fa_adjustments adj,
1306: fa_distribution_history dh,
1307: fa_locations loc,
1308: fa_lookups lu ,
1521: stg.CIP_COST_ACCT,
1522: stg.DEPRN_RESERVE_ACCT,
1523: stg.REVAL_RESERVE_ACCT,
1524: stg.TRANSACTION_HEADER_ID
1525: from fa_xla_ext_lines_stg_gt stg,
1526: fa_mc_adjustments adj,
1527: fa_distribution_history dh,
1528: fa_locations loc,
1529: fa_lookups lu ,
1766: stg.CIP_COST_ACCT,
1767: stg.DEPRN_RESERVE_ACCT,
1768: stg.REVAL_RESERVE_ACCT,
1769: stg.TRANSACTION_HEADER_ID
1770: from fa_xla_ext_lines_stg_gt stg,
1771: fa_adjustments adj,
1772: fa_distribution_history dh,
1773: fa_locations loc,
1774: fa_lookups lu ,
1951: stg.CIP_COST_ACCT,
1952: stg.DEPRN_RESERVE_ACCT,
1953: stg.REVAL_RESERVE_ACCT,
1954: stg.TRANSACTION_HEADER_ID
1955: from fa_xla_ext_lines_stg_gt stg,
1956: fa_mc_adjustments adj,
1957: fa_distribution_history dh,
1958: fa_locations loc,
1959: fa_lookups lu ,
2183: stg.CIP_COST_ACCT,
2184: stg.DEPRN_RESERVE_ACCT,
2185: stg.REVAL_RESERVE_ACCT,
2186: stg.TRANSACTION_HEADER_ID
2187: from fa_xla_ext_lines_stg_gt stg,
2188: fa_adjustments adj,
2189: fa_distribution_history dh,
2190: fa_locations loc,
2191: fa_lookups lu
2358: stg.CIP_COST_ACCT,
2359: stg.DEPRN_RESERVE_ACCT,
2360: stg.REVAL_RESERVE_ACCT,
2361: stg.TRANSACTION_HEADER_ID
2362: from fa_xla_ext_lines_stg_gt stg,
2363: fa_mc_adjustments adj,
2364: fa_distribution_history dh,
2365: fa_locations loc,
2366: fa_lookups lu ,
2555: cb.DEPRN_RESERVE_ACCT,
2556: cb.REVAL_RESERVE_ACCT,
2557: dh.CODE_COMBINATION_ID,
2558: stg.TRANSACTION_HEADER_ID
2559: from fa_xla_ext_lines_stg_gt stg,
2560: fa_adjustments adj,
2561: fa_distribution_history dh,
2562: fa_locations loc,
2563: fa_lookups lu ,
2708: cb.DEPRN_RESERVE_ACCT,
2709: cb.REVAL_RESERVE_ACCT,
2710: dh.CODE_COMBINATION_ID,
2711: stg.TRANSACTION_HEADER_ID
2712: from fa_xla_ext_lines_stg_gt stg,
2713: fa_mc_adjustments adj,
2714: fa_distribution_history dh,
2715: fa_locations loc,
2716: fa_lookups lu ,
2868: stg.CIP_COST_ACCT,
2869: stg.DEPRN_RESERVE_ACCT,
2870: stg.REVAL_RESERVE_ACCT,
2871: stg.TRANSACTION_HEADER_ID
2872: from fa_xla_ext_lines_stg_gt stg,
2873: fa_adjustments adj,
2874: fa_distribution_history dh,
2875: fa_locations loc,
2876: fa_lookups lu
3015: stg.CIP_COST_ACCT,
3016: stg.DEPRN_RESERVE_ACCT,
3017: stg.REVAL_RESERVE_ACCT,
3018: stg.TRANSACTION_HEADER_ID
3019: from fa_xla_ext_lines_stg_gt stg,
3020: fa_mc_adjustments adj,
3021: fa_distribution_history dh,
3022: fa_locations loc,
3023: fa_lookups lu ,
3226: stg.CIP_COST_ACCT,
3227: stg.DEPRN_RESERVE_ACCT,
3228: stg.REVAL_RESERVE_ACCT,
3229: stg.TRANSACTION_HEADER_ID
3230: from fa_xla_ext_lines_stg_gt stg,
3231: fa_adjustments adj,
3232: fa_distribution_history dh,
3233: fa_locations loc,
3234: fa_lookups lu ,
3385: stg.CIP_COST_ACCT,
3386: stg.DEPRN_RESERVE_ACCT,
3387: stg.REVAL_RESERVE_ACCT,
3388: stg.TRANSACTION_HEADER_ID
3389: from fa_xla_ext_lines_stg_gt stg,
3390: fa_mc_adjustments adj,
3391: fa_distribution_history dh,
3392: fa_locations loc,
3393: fa_lookups lu ,
3597: stg.CIP_COST_ACCT,
3598: stg.DEPRN_RESERVE_ACCT,
3599: stg.REVAL_RESERVE_ACCT,
3600: stg.TRANSACTION_HEADER_ID
3601: from fa_xla_ext_lines_stg_gt stg,
3602: fa_adjustments adj,
3603: fa_distribution_history dh,
3604: fa_locations loc,
3605: fa_lookups lu ,
3756: stg.CIP_COST_ACCT,
3757: stg.DEPRN_RESERVE_ACCT,
3758: stg.REVAL_RESERVE_ACCT,
3759: stg.TRANSACTION_HEADER_ID
3760: from fa_xla_ext_lines_stg_gt stg,
3761: fa_mc_adjustments adj,
3762: fa_distribution_history dh,
3763: fa_locations loc,
3764: fa_lookups lu ,