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 GL_LEDGERS

Line 186: gl_ledgers le

182: fa_deprn_periods dp,
183: fa_book_controls bc ,
184: FA_TRANSACTION_HEADERS th ,
185: fa_mc_book_controls mcbc ,
186: gl_ledgers le
187: WHERE ctlgd.entity_code = 'TRANSACTIONS'
188: AND ctlgd.event_type_code <> 'INFLATION_REVALUATION'
189: AND th.transaction_header_id = ctlgd.source_id_int_1
190: AND ctlgd.valuation_method = dp.book_type_code

Line 329: gl_ledgers le

325: fa_deprn_periods dp,
326: fa_book_controls bc ,
327: FA_TRX_REFERENCES trx ,
328: fa_mc_book_controls mcbc ,
329: gl_ledgers le
330: WHERE ctlgd.entity_code = 'INTER_ASSET_TRANSACTIONS'
331: AND trx.trx_reference_id = ctlgd.source_id_int_1
332: AND trx.event_id = ctlgd.event_id
333: AND trx.book_type_code = dp.book_type_code

Line 475: gl_ledgers le,

471: from fa_additions_b ad,
472: fa_asset_history ah,
473: fa_book_controls bc,
474: fa_category_books cb,
475: gl_ledgers le,
476: fa_transaction_headers th,
477: xla_events_gt ctlgd
478: where ctlgd.entity_code = 'TRANSACTIONS'
479: AND bc.book_type_code = ctlgd.valuation_method

Line 581: gl_ledgers le,

577: from fa_additions_b ad,
578: fa_asset_history ah,
579: fa_book_controls bc,
580: fa_category_books cb,
581: gl_ledgers le,
582: fa_transaction_headers th,
583: xla_events_gt ctlgd
584: where ctlgd.entity_code = 'TRANSACTIONS'
585: AND bc.book_type_code = ctlgd.valuation_method

Line 730: gl_ledgers le,

726: from fa_additions_b ad,
727: fa_asset_history ah,
728: fa_book_controls bc,
729: fa_category_books cb,
730: gl_ledgers le,
731: fa_transaction_headers th,
732: fa_trx_references trx,
733: xla_events_gt ctlgd
734: where ctlgd.entity_code = 'INTER_ASSET_TRANSACTIONS'

Line 838: gl_ledgers le,

834: from fa_additions_b ad,
835: fa_asset_history ah,
836: fa_book_controls bc,
837: fa_category_books cb,
838: gl_ledgers le,
839: fa_transaction_headers th,
840: fa_trx_references trx,
841: xla_events_gt ctlgd
842: where ctlgd.entity_code = 'INTER_ASSET_TRANSACTIONS'

Line 944: gl_ledgers le,

940: from fa_additions_b ad,
941: fa_asset_history ah,
942: fa_book_controls bc,
943: fa_category_books cb,
944: gl_ledgers le,
945: fa_transaction_headers th,
946: fa_trx_references trx,
947: xla_events_gt ctlgd
948: where ctlgd.entity_code = 'INTER_ASSET_TRANSACTIONS'

Line 1052: gl_ledgers le,

1048: from fa_additions_b ad,
1049: fa_asset_history ah,
1050: fa_book_controls bc,
1051: fa_category_books cb,
1052: gl_ledgers le,
1053: fa_transaction_headers th,
1054: fa_trx_references trx,
1055: xla_events_gt ctlgd
1056: where ctlgd.entity_code = 'INTER_ASSET_TRANSACTIONS'

Line 1532: gl_ledgers le

1528: fa_locations loc,
1529: fa_lookups lu ,
1530: fa_mc_asset_invoices ai,
1531: fa_mc_book_controls bc ,
1532: gl_ledgers le
1533: WHERE adj.transaction_header_id = stg.transaction_header_id
1534: AND adj.book_type_code = stg.book_type_code
1535: AND adj.distribution_id = dh.distribution_id
1536: AND dh.location_id = loc.location_id

Line 1962: gl_ledgers le

1958: fa_locations loc,
1959: fa_lookups lu ,
1960: fa_mc_asset_invoices ai,
1961: fa_mc_book_controls bc ,
1962: gl_ledgers le
1963: WHERE adj.transaction_header_id = stg.transaction_header_id
1964: AND adj.book_type_code = stg.book_type_code
1965: AND adj.distribution_id = dh.distribution_id
1966: AND dh.location_id = loc.location_id

Line 2368: gl_ledgers le

2364: fa_distribution_history dh,
2365: fa_locations loc,
2366: fa_lookups lu ,
2367: fa_mc_book_controls bc ,
2368: gl_ledgers le
2369: WHERE adj.transaction_header_id = stg.transaction_header_id
2370: AND adj.book_type_code = stg.book_type_code
2371: AND adj.distribution_id = dh.distribution_id
2372: AND dh.location_id = loc.location_id

Line 2720: gl_ledgers le

2716: fa_lookups lu ,
2717: fa_asset_history ah,
2718: fa_category_books cb ,
2719: fa_mc_book_controls bc ,
2720: gl_ledgers le
2721: WHERE adj.transaction_header_id = stg.transaction_header_id
2722: AND adj.book_type_code = stg.book_type_code
2723: AND adj.distribution_id = dh.distribution_id
2724: AND dh.location_id = loc.location_id

Line 3025: gl_ledgers le

3021: fa_distribution_history dh,
3022: fa_locations loc,
3023: fa_lookups lu ,
3024: fa_mc_book_controls bc ,
3025: gl_ledgers le
3026: WHERE adj.transaction_header_id = stg.transaction_header_id
3027: AND adj.book_type_code = stg.book_type_code
3028: AND adj.distribution_id = dh.distribution_id
3029: AND dh.location_id = loc.location_id

Line 3396: gl_ledgers le

3392: fa_locations loc,
3393: fa_lookups lu ,
3394: fa_mc_retirements ret ,
3395: fa_mc_book_controls bc ,
3396: gl_ledgers le
3397: WHERE adj.transaction_header_id = stg.transaction_header_id
3398: AND adj.book_type_code = stg.book_type_code
3399: AND adj.distribution_id = dh.distribution_id
3400: AND dh.location_id = loc.location_id

Line 3767: gl_ledgers le

3763: fa_locations loc,
3764: fa_lookups lu ,
3765: fa_mc_retirements ret ,
3766: fa_mc_book_controls bc ,
3767: gl_ledgers le
3768: WHERE adj.transaction_header_id = stg.transaction_header_id
3769: AND adj.book_type_code = stg.book_type_code
3770: AND adj.distribution_id = dh.distribution_id
3771: AND dh.location_id = loc.location_id