eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FA_XLA_EXTRACT_TRX_PKG dependencies on FA_ADJUSTMENTS

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

1169: CIP_COST_ACCT,
1170: DEPRN_RESERVE_ACCT,
1171: REVAL_RESERVE_ACCT,
1172: TRANSACTION_HEADER_ID )
1173: select /*+ leading(stg) index(adj, FA_ADJUSTMENTS_U1) */ stg.EVENT_ID ,
1174: adj.adjustment_line_id ,
1175: adj.distribution_id ,
1176: stg.distribution_type_code ,
1177: stg.ledger_id ,

Line 1305: fa_adjustments adj,

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

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

1665: CIP_COST_ACCT,
1666: DEPRN_RESERVE_ACCT,
1667: REVAL_RESERVE_ACCT,
1668: TRANSACTION_HEADER_ID )
1669: select /*+ leading(stg) index(adj, FA_ADJUSTMENTS_U1) */ stg.EVENT_ID ,
1670: adj.adjustment_line_id ,
1671: adj.distribution_id ,
1672: stg.distribution_type_code ,
1673: stg.ledger_id ,

Line 1771: fa_adjustments adj,

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

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

2085: CIP_COST_ACCT,
2086: DEPRN_RESERVE_ACCT,
2087: REVAL_RESERVE_ACCT,
2088: TRANSACTION_HEADER_ID )
2089: select /*+ leading(stg) index(adj, FA_ADJUSTMENTS_U1) */ stg.EVENT_ID ,
2090: adj.adjustment_line_id ,
2091: adj.distribution_id ,
2092: stg.distribution_type_code ,
2093: stg.ledger_id ,

Line 2188: fa_adjustments adj,

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

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

2487: DEPRN_RESERVE_ACCT,
2488: REVAL_RESERVE_ACCT,
2489: EXPENSE_ACCOUNT_CCID,
2490: TRANSACTION_HEADER_ID )
2491: select /*+ leading(stg) index(adj, FA_ADJUSTMENTS_U1) */ stg.EVENT_ID ,
2492: adj.adjustment_line_id ,
2493: adj.distribution_id ,
2494: stg.distribution_type_code ,
2495: stg.ledger_id ,

Line 2560: fa_adjustments adj,

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

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

2800: CIP_COST_ACCT,
2801: DEPRN_RESERVE_ACCT,
2802: REVAL_RESERVE_ACCT,
2803: TRANSACTION_HEADER_ID )
2804: select /*+ leading(stg) index(adj, FA_ADJUSTMENTS_U1) */ stg.EVENT_ID ,
2805: adj.adjustment_line_id ,
2806: adj.distribution_id ,
2807: stg.distribution_type_code ,
2808: stg.ledger_id ,

Line 2873: fa_adjustments adj,

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

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

3146: CIP_COST_ACCT,
3147: DEPRN_RESERVE_ACCT,
3148: REVAL_RESERVE_ACCT,
3149: TRANSACTION_HEADER_ID )
3150: select /*+ leading(stg) index(adj, FA_ADJUSTMENTS_U1) */ stg.EVENT_ID ,
3151: adj.adjustment_line_id ,
3152: adj.distribution_id ,
3153: stg.distribution_type_code ,
3154: stg.ledger_id ,

Line 3231: fa_adjustments adj,

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

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

3517: CIP_COST_ACCT,
3518: DEPRN_RESERVE_ACCT,
3519: REVAL_RESERVE_ACCT,
3520: TRANSACTION_HEADER_ID )
3521: select /*+ leading(stg) index(adj, FA_ADJUSTMENTS_U1) */ stg.EVENT_ID ,
3522: adj.adjustment_line_id ,
3523: adj.distribution_id ,
3524: stg.distribution_type_code ,
3525: stg.ledger_id ,

Line 3602: fa_adjustments adj,

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

APPS.FA_XLA_EXTRACT_TRX_PKG dependencies on FA_ADJUSTMENTS

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