260: 'Beginning of procedure');
261: END IF;
262:
263:
264: insert into fa_xla_ext_lines_stg_gt (
265: EVENT_ID ,
266: EVENT_TYPE_CODE ,
267: TRANSACTION_HEADER_ID ,
268: MEMBER_TRANSACTION_HEADER_ID ,
405: 'Beginning of procedure');
406: END IF;
407:
408:
409: insert into fa_xla_ext_lines_stg_gt (
410: EVENT_ID ,
411: EVENT_TYPE_CODE ,
412: TRANSACTION_HEADER_ID ,
413: MEMBER_TRANSACTION_HEADER_ID ,
501: 'Rows inserted into lines: ' || to_char(SQL%ROWCOUNT));
502: END IF;
503:
504:
505: insert into fa_xla_ext_lines_stg_gt (
506: EVENT_ID ,
507: EVENT_TYPE_CODE ,
508: TRANSACTION_HEADER_ID ,
509: MEMBER_TRANSACTION_HEADER_ID ,
760: stg.CIP_COST_ACCT,
761: stg.DEPRN_RESERVE_ACCT,
762: stg.REVAL_RESERVE_ACCT,
763: stg.TRANSACTION_HEADER_ID
764: from fa_xla_ext_lines_stg_gt stg,
765: fa_adjustments adj,
766: fa_distribution_history dh,
767: fa_locations loc,
768: fa_lookups lu ,
924: stg.CIP_COST_ACCT,
925: stg.DEPRN_RESERVE_ACCT,
926: stg.REVAL_RESERVE_ACCT,
927: stg.TRANSACTION_HEADER_ID
928: from fa_xla_ext_lines_stg_gt stg,
929: fa_mc_adjustments adj,
930: fa_distribution_history dh,
931: fa_locations loc,
932: fa_lookups lu ,
1119: stg.CIP_COST_ACCT,
1120: stg.DEPRN_RESERVE_ACCT,
1121: stg.REVAL_RESERVE_ACCT,
1122: stg.TRANSACTION_HEADER_ID
1123: from fa_xla_ext_lines_stg_gt stg,
1124: fa_adjustments adj,
1125: fa_distribution_history dh,
1126: fa_locations loc,
1127: fa_lookups lu ,
1265: stg.CIP_COST_ACCT,
1266: stg.DEPRN_RESERVE_ACCT,
1267: stg.REVAL_RESERVE_ACCT,
1268: stg.TRANSACTION_HEADER_ID
1269: from fa_xla_ext_lines_stg_gt stg,
1270: fa_mc_adjustments adj,
1271: fa_distribution_history dh,
1272: fa_locations loc,
1273: fa_lookups lu ,
1449: stg.CIP_COST_ACCT,
1450: stg.DEPRN_RESERVE_ACCT,
1451: stg.REVAL_RESERVE_ACCT,
1452: stg.TRANSACTION_HEADER_ID
1453: from fa_xla_ext_lines_stg_gt stg,
1454: fa_adjustments adj,
1455: fa_distribution_history dh,
1456: fa_locations loc,
1457: fa_lookups lu
1585: stg.CIP_COST_ACCT,
1586: stg.DEPRN_RESERVE_ACCT,
1587: stg.REVAL_RESERVE_ACCT,
1588: stg.TRANSACTION_HEADER_ID
1589: from fa_xla_ext_lines_stg_gt stg,
1590: fa_mc_adjustments adj,
1591: fa_distribution_history dh,
1592: fa_locations loc,
1593: fa_lookups lu ,
1746: cb.DEPRN_RESERVE_ACCT,
1747: cb.REVAL_RESERVE_ACCT,
1748: dh.CODE_COMBINATION_ID,
1749: stg.TRANSACTION_HEADER_ID
1750: from fa_xla_ext_lines_stg_gt stg,
1751: fa_adjustments adj,
1752: fa_distribution_history dh,
1753: fa_locations loc,
1754: fa_lookups lu ,
1872: cb.DEPRN_RESERVE_ACCT,
1873: cb.REVAL_RESERVE_ACCT,
1874: dh.CODE_COMBINATION_ID,
1875: stg.TRANSACTION_HEADER_ID
1876: from fa_xla_ext_lines_stg_gt stg,
1877: fa_mc_adjustments adj,
1878: fa_distribution_history dh,
1879: fa_locations loc,
1880: fa_lookups lu ,
2001: stg.CIP_COST_ACCT,
2002: stg.DEPRN_RESERVE_ACCT,
2003: stg.REVAL_RESERVE_ACCT,
2004: stg.TRANSACTION_HEADER_ID
2005: from fa_xla_ext_lines_stg_gt stg,
2006: fa_adjustments adj,
2007: fa_distribution_history dh,
2008: fa_locations loc,
2009: fa_lookups lu
2121: stg.CIP_COST_ACCT,
2122: stg.DEPRN_RESERVE_ACCT,
2123: stg.REVAL_RESERVE_ACCT,
2124: stg.TRANSACTION_HEADER_ID
2125: from fa_xla_ext_lines_stg_gt stg,
2126: fa_mc_adjustments adj,
2127: fa_distribution_history dh,
2128: fa_locations loc,
2129: fa_lookups lu ,
2296: stg.CIP_COST_ACCT,
2297: stg.DEPRN_RESERVE_ACCT,
2298: stg.REVAL_RESERVE_ACCT,
2299: stg.TRANSACTION_HEADER_ID
2300: from fa_xla_ext_lines_stg_gt stg,
2301: fa_adjustments adj,
2302: fa_distribution_history dh,
2303: fa_locations loc,
2304: fa_lookups lu ,
2428: stg.CIP_COST_ACCT,
2429: stg.DEPRN_RESERVE_ACCT,
2430: stg.REVAL_RESERVE_ACCT,
2431: stg.TRANSACTION_HEADER_ID
2432: from fa_xla_ext_lines_stg_gt stg,
2433: fa_mc_adjustments adj,
2434: fa_distribution_history dh,
2435: fa_locations loc,
2436: fa_lookups lu ,
2603: stg.CIP_COST_ACCT,
2604: stg.DEPRN_RESERVE_ACCT,
2605: stg.REVAL_RESERVE_ACCT,
2606: stg.TRANSACTION_HEADER_ID
2607: from fa_xla_ext_lines_stg_gt stg,
2608: fa_adjustments adj,
2609: fa_distribution_history dh,
2610: fa_locations loc,
2611: fa_lookups lu ,
2735: stg.CIP_COST_ACCT,
2736: stg.DEPRN_RESERVE_ACCT,
2737: stg.REVAL_RESERVE_ACCT,
2738: stg.TRANSACTION_HEADER_ID
2739: from fa_xla_ext_lines_stg_gt stg,
2740: fa_mc_adjustments adj,
2741: fa_distribution_history dh,
2742: fa_locations loc,
2743: fa_lookups lu ,