[Home] [Help]
839: CIP_COST_ACCT,
840: DEPRN_RESERVE_ACCT,
841: REVAL_RESERVE_ACCT,
842: TRANSACTION_HEADER_ID )
843: select /*+ leading(stg) index(adj, FA_MC_ADJUSTMENTS_U1) */ stg.EVENT_ID ,
844: adj.adjustment_line_id ,
845: adj.distribution_id ,
846: stg.distribution_type_code ,
847: bc.set_of_books_id ,
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 ,
933: fa_mc_asset_invoices ai,
1194: CIP_COST_ACCT,
1195: DEPRN_RESERVE_ACCT,
1196: REVAL_RESERVE_ACCT,
1197: TRANSACTION_HEADER_ID )
1198: select /*+ leading(stg) index(adj, FA_MC_ADJUSTMENTS_U1) */ stg.EVENT_ID ,
1199: adj.adjustment_line_id ,
1200: adj.distribution_id ,
1201: stg.distribution_type_code ,
1202: bc.set_of_books_id ,
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 ,
1274: fa_mc_asset_invoices ai,
1517: CIP_COST_ACCT,
1518: DEPRN_RESERVE_ACCT,
1519: REVAL_RESERVE_ACCT,
1520: TRANSACTION_HEADER_ID )
1521: select /*+ leading(stg) index(adj, FA_MC_ADJUSTMENTS_U1) */ stg.EVENT_ID ,
1522: adj.adjustment_line_id ,
1523: adj.distribution_id ,
1524: stg.distribution_type_code ,
1525: bc.set_of_books_id ,
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 ,
1594: fa_mc_book_controls bc ,
1822: DEPRN_RESERVE_ACCT,
1823: REVAL_RESERVE_ACCT,
1824: EXPENSE_ACCOUNT_CCID,
1825: TRANSACTION_HEADER_ID )
1826: select /*+ leading(stg) index(adj, FA_MC_ADJUSTMENTS_U1) */ stg.EVENT_ID ,
1827: adj.adjustment_line_id ,
1828: adj.distribution_id ,
1829: stg.distribution_type_code ,
1830: bc.set_of_books_id ,
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 ,
1881: fa_asset_history ah,
2071: CIP_COST_ACCT,
2072: DEPRN_RESERVE_ACCT,
2073: REVAL_RESERVE_ACCT,
2074: TRANSACTION_HEADER_ID )
2075: select /*+ leading(stg) index(adj, FA_MC_ADJUSTMENTS_U1) */ stg.EVENT_ID ,
2076: adj.adjustment_line_id ,
2077: adj.distribution_id ,
2078: stg.distribution_type_code ,
2079: bc.set_of_books_id ,
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 ,
2130: fa_mc_book_controls bc ,
2366: CIP_COST_ACCT,
2367: DEPRN_RESERVE_ACCT,
2368: REVAL_RESERVE_ACCT,
2369: TRANSACTION_HEADER_ID )
2370: select /*+ leading(stg) index(adj, FA_MC_ADJUSTMENTS_U1) */ stg.EVENT_ID ,
2371: adj.adjustment_line_id ,
2372: adj.distribution_id ,
2373: stg.distribution_type_code ,
2374: bc.set_of_books_id ,
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 ,
2437: fa_retirements ret ,
2673: CIP_COST_ACCT,
2674: DEPRN_RESERVE_ACCT,
2675: REVAL_RESERVE_ACCT,
2676: TRANSACTION_HEADER_ID )
2677: select /*+ leading(stg) index(adj, FA_MC_ADJUSTMENTS_U1) */ stg.EVENT_ID ,
2678: adj.adjustment_line_id ,
2679: adj.distribution_id ,
2680: stg.distribution_type_code ,
2681: bc.set_of_books_id ,
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 ,
2744: fa_retirements ret ,