[Home] [Help]
1390: CIP_COST_ACCT,
1391: DEPRN_RESERVE_ACCT,
1392: REVAL_RESERVE_ACCT,
1393: TRANSACTION_HEADER_ID )
1394: select /*+ leading(stg) index(adj, FA_MC_ADJUSTMENTS_U1) */ stg.EVENT_ID ,
1395: adj.adjustment_line_id ,
1396: adj.distribution_id ,
1397: stg.distribution_type_code ,
1398: bc.set_of_books_id ,
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 ,
1530: fa_mc_asset_invoices ai,
1850: CIP_COST_ACCT,
1851: DEPRN_RESERVE_ACCT,
1852: REVAL_RESERVE_ACCT,
1853: TRANSACTION_HEADER_ID )
1854: select /*+ leading(stg) index(adj, FA_MC_ADJUSTMENTS_U1) */ stg.EVENT_ID ,
1855: adj.adjustment_line_id ,
1856: adj.distribution_id ,
1857: stg.distribution_type_code ,
1858: bc.set_of_books_id ,
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 ,
1960: fa_mc_asset_invoices ai,
2260: CIP_COST_ACCT,
2261: DEPRN_RESERVE_ACCT,
2262: REVAL_RESERVE_ACCT,
2263: TRANSACTION_HEADER_ID )
2264: select /*+ leading(stg) index(adj, FA_MC_ADJUSTMENTS_U1) */ stg.EVENT_ID ,
2265: adj.adjustment_line_id ,
2266: adj.distribution_id ,
2267: stg.distribution_type_code ,
2268: bc.set_of_books_id ,
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 ,
2367: fa_mc_book_controls bc ,
2640: DEPRN_RESERVE_ACCT,
2641: REVAL_RESERVE_ACCT,
2642: EXPENSE_ACCOUNT_CCID,
2643: TRANSACTION_HEADER_ID )
2644: select /*+ leading(stg) index(adj, FA_MC_ADJUSTMENTS_U1) */ stg.EVENT_ID ,
2645: adj.adjustment_line_id ,
2646: adj.distribution_id ,
2647: stg.distribution_type_code ,
2648: bc.set_of_books_id ,
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 ,
2717: fa_asset_history ah,
2947: CIP_COST_ACCT,
2948: DEPRN_RESERVE_ACCT,
2949: REVAL_RESERVE_ACCT,
2950: TRANSACTION_HEADER_ID )
2951: select /*+ leading(stg) index(adj, FA_MC_ADJUSTMENTS_U1) */ stg.EVENT_ID ,
2952: adj.adjustment_line_id ,
2953: adj.distribution_id ,
2954: stg.distribution_type_code ,
2955: bc.set_of_books_id ,
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 ,
3024: fa_mc_book_controls bc ,
3305: CIP_COST_ACCT,
3306: DEPRN_RESERVE_ACCT,
3307: REVAL_RESERVE_ACCT,
3308: TRANSACTION_HEADER_ID )
3309: select /*+ leading(stg) index(adj, FA_MC_ADJUSTMENTS_U1) */ stg.EVENT_ID ,
3310: adj.adjustment_line_id ,
3311: adj.distribution_id ,
3312: stg.distribution_type_code ,
3313: bc.set_of_books_id ,
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 ,
3394: fa_mc_retirements ret ,
3676: CIP_COST_ACCT,
3677: DEPRN_RESERVE_ACCT,
3678: REVAL_RESERVE_ACCT,
3679: TRANSACTION_HEADER_ID )
3680: select /*+ leading(stg) index(adj, FA_MC_ADJUSTMENTS_U1) */ stg.EVENT_ID ,
3681: adj.adjustment_line_id ,
3682: adj.distribution_id ,
3683: stg.distribution_type_code ,
3684: bc.set_of_books_id ,
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 ,
3765: fa_mc_retirements ret ,