DBA Data[Home] [Help]

APPS.FA_XLA_EXTRACT_TRX_PKG dependencies on FA_ADJUSTMENTS

Line 679: select /*+ leading(stg) index(adj, FA_ADJUSTMENTS_U1) */ stg.EVENT_ID ,

675: CIP_COST_ACCT,
676: DEPRN_RESERVE_ACCT,
677: REVAL_RESERVE_ACCT,
678: TRANSACTION_HEADER_ID )
679: select /*+ leading(stg) index(adj, FA_ADJUSTMENTS_U1) */ stg.EVENT_ID ,
680: adj.adjustment_line_id ,
681: adj.distribution_id ,
682: stg.distribution_type_code ,
683: stg.ledger_id ,

Line 765: fa_adjustments adj,

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 ,
769: FA_ASSET_INVOICES ai

Line 1052: select /*+ leading(stg) index(adj, FA_ADJUSTMENTS_U1) */ stg.EVENT_ID ,

1048: CIP_COST_ACCT,
1049: DEPRN_RESERVE_ACCT,
1050: REVAL_RESERVE_ACCT,
1051: TRANSACTION_HEADER_ID )
1052: select /*+ leading(stg) index(adj, FA_ADJUSTMENTS_U1) */ stg.EVENT_ID ,
1053: adj.adjustment_line_id ,
1054: adj.distribution_id ,
1055: stg.distribution_type_code ,
1056: stg.ledger_id ,

Line 1124: fa_adjustments adj,

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 ,
1128: FA_ASSET_INVOICES ai

Line 1385: select /*+ leading(stg) index(adj, FA_ADJUSTMENTS_U1) */ stg.EVENT_ID ,

1381: CIP_COST_ACCT,
1382: DEPRN_RESERVE_ACCT,
1383: REVAL_RESERVE_ACCT,
1384: TRANSACTION_HEADER_ID )
1385: select /*+ leading(stg) index(adj, FA_ADJUSTMENTS_U1) */ stg.EVENT_ID ,
1386: adj.adjustment_line_id ,
1387: adj.distribution_id ,
1388: stg.distribution_type_code ,
1389: stg.ledger_id ,

Line 1454: fa_adjustments adj,

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
1458: WHERE adj.transaction_header_id = stg.transaction_header_id

Line 1700: select /*+ leading(stg) index(adj, FA_ADJUSTMENTS_U1) */ stg.EVENT_ID ,

1696: DEPRN_RESERVE_ACCT,
1697: REVAL_RESERVE_ACCT,
1698: EXPENSE_ACCOUNT_CCID,
1699: TRANSACTION_HEADER_ID )
1700: select /*+ leading(stg) index(adj, FA_ADJUSTMENTS_U1) */ stg.EVENT_ID ,
1701: adj.adjustment_line_id ,
1702: adj.distribution_id ,
1703: stg.distribution_type_code ,
1704: stg.ledger_id ,

Line 1751: fa_adjustments adj,

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 ,
1755: fa_asset_history ah,

Line 1955: select /*+ leading(stg) index(adj, FA_ADJUSTMENTS_U1) */ stg.EVENT_ID ,

1951: CIP_COST_ACCT,
1952: DEPRN_RESERVE_ACCT,
1953: REVAL_RESERVE_ACCT,
1954: TRANSACTION_HEADER_ID )
1955: select /*+ leading(stg) index(adj, FA_ADJUSTMENTS_U1) */ stg.EVENT_ID ,
1956: adj.adjustment_line_id ,
1957: adj.distribution_id ,
1958: stg.distribution_type_code ,
1959: stg.ledger_id ,

Line 2006: fa_adjustments adj,

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
2010: WHERE adj.transaction_header_id = stg.transaction_header_id

Line 2238: select /*+ leading(stg) index(adj, FA_ADJUSTMENTS_U1) */ stg.EVENT_ID ,

2234: CIP_COST_ACCT,
2235: DEPRN_RESERVE_ACCT,
2236: REVAL_RESERVE_ACCT,
2237: TRANSACTION_HEADER_ID )
2238: select /*+ leading(stg) index(adj, FA_ADJUSTMENTS_U1) */ stg.EVENT_ID ,
2239: adj.adjustment_line_id ,
2240: adj.distribution_id ,
2241: stg.distribution_type_code ,
2242: stg.ledger_id ,

Line 2301: fa_adjustments adj,

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 ,
2305: fa_retirements ret

Line 2545: select /*+ leading(stg) index(adj, FA_ADJUSTMENTS_U1) */ stg.EVENT_ID ,

2541: CIP_COST_ACCT,
2542: DEPRN_RESERVE_ACCT,
2543: REVAL_RESERVE_ACCT,
2544: TRANSACTION_HEADER_ID )
2545: select /*+ leading(stg) index(adj, FA_ADJUSTMENTS_U1) */ stg.EVENT_ID ,
2546: adj.adjustment_line_id ,
2547: adj.distribution_id ,
2548: stg.distribution_type_code ,
2549: stg.ledger_id ,

Line 2608: fa_adjustments adj,

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 ,
2612: fa_retirements ret