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_TRANSACTION_HEADERS

Line 113: FA_TRANSACTION_HEADERS th

109: bc.REVAL_RSV_RETIRED_LOSS_ACCT
110: FROM xla_events_gt ctlgd,
111: fa_deprn_periods dp,
112: fa_book_controls bc ,
113: FA_TRANSACTION_HEADERS th
114: WHERE ctlgd.entity_code = 'TRANSACTIONS'
115: AND ctlgd.event_type_code <> 'INFLATION_REVALUATION'
116: AND th.transaction_header_id = ctlgd.source_id_int_1
117: AND ctlgd.valuation_method = dp.book_type_code

Line 184: FA_TRANSACTION_HEADERS th ,

180: bc.REVAL_RSV_RETIRED_LOSS_ACCT
181: FROM xla_events_gt ctlgd,
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'

Line 434: select /+ leading(ctgld) index(th, FA_TRANSACTION_HEADERS_U1) / ctlgd.EVENT_ID ,

430: CIP_CLEARING_ACCT,
431: CIP_COST_ACCT,
432: DEPRN_RESERVE_ACCT,
433: REVAL_RESERVE_ACCT )
434: select /*+ leading(ctgld) index(th, FA_TRANSACTION_HEADERS_U1) */ ctlgd.EVENT_ID ,
435: ctlgd.event_type_code ,
436: th.transaction_header_id ,
437: nvl(th.member_transaction_header_id,
438: th.transaction_header_id) ,

Line 476: fa_transaction_headers th,

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
480: AND le.ledger_id = bc.set_of_books_id

Line 540: select /+ leading(ctgld) index(th, FA_TRANSACTION_HEADERS_N7) / ctlgd.EVENT_ID ,

536: CIP_CLEARING_ACCT,
537: CIP_COST_ACCT,
538: DEPRN_RESERVE_ACCT,
539: REVAL_RESERVE_ACCT )
540: select /*+ leading(ctgld) index(th, FA_TRANSACTION_HEADERS_N7) */ ctlgd.EVENT_ID ,
541: ctlgd.event_type_code ,
542: th.transaction_header_id ,
543: nvl(th.member_transaction_header_id,
544: th.transaction_header_id) ,

Line 582: fa_transaction_headers th,

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
586: AND le.ledger_id = bc.set_of_books_id

Line 689: select /+ leading(ctgld) index(th, FA_TRANSACTION_HEADERS_U1) / ctlgd.EVENT_ID ,

685: CIP_CLEARING_ACCT,
686: CIP_COST_ACCT,
687: DEPRN_RESERVE_ACCT,
688: REVAL_RESERVE_ACCT )
689: select /*+ leading(ctgld) index(th, FA_TRANSACTION_HEADERS_U1) */ ctlgd.EVENT_ID ,
690: ctlgd.event_type_code ,
691: th.transaction_header_id ,
692: nvl(th.member_transaction_header_id,
693: th.transaction_header_id) ,

Line 731: fa_transaction_headers th,

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'
735: AND trx.trx_reference_id = ctlgd.source_id_int_1

Line 797: select /+ leading(ctgld) index(th, FA_TRANSACTION_HEADERS_N7) / ctlgd.EVENT_ID ,

793: CIP_CLEARING_ACCT,
794: CIP_COST_ACCT,
795: DEPRN_RESERVE_ACCT,
796: REVAL_RESERVE_ACCT )
797: select /*+ leading(ctgld) index(th, FA_TRANSACTION_HEADERS_N7) */ ctlgd.EVENT_ID ,
798: ctlgd.event_type_code ,
799: th.transaction_header_id ,
800: nvl(th.member_transaction_header_id,
801: th.transaction_header_id) ,

Line 839: fa_transaction_headers th,

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'
843: AND trx.trx_reference_id = ctlgd.source_id_int_1

Line 903: select /+ leading(ctgld) index(th, FA_TRANSACTION_HEADERS_U1) / ctlgd.EVENT_ID ,

899: CIP_CLEARING_ACCT,
900: CIP_COST_ACCT,
901: DEPRN_RESERVE_ACCT,
902: REVAL_RESERVE_ACCT )
903: select /*+ leading(ctgld) index(th, FA_TRANSACTION_HEADERS_U1) */ ctlgd.EVENT_ID ,
904: ctlgd.event_type_code ,
905: th.transaction_header_id ,
906: nvl(th.member_transaction_header_id,
907: th.transaction_header_id) ,

Line 945: fa_transaction_headers th,

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'
949: AND trx.trx_reference_id = ctlgd.source_id_int_1

Line 1011: select /+ leading(ctgld) index(th, FA_TRANSACTION_HEADERS_N7) / ctlgd.EVENT_ID ,

1007: CIP_CLEARING_ACCT,
1008: CIP_COST_ACCT,
1009: DEPRN_RESERVE_ACCT,
1010: REVAL_RESERVE_ACCT )
1011: select /*+ leading(ctgld) index(th, FA_TRANSACTION_HEADERS_N7) */ ctlgd.EVENT_ID ,
1012: ctlgd.event_type_code ,
1013: th.transaction_header_id ,
1014: nvl(th.member_transaction_header_id,
1015: th.transaction_header_id) ,

Line 1053: fa_transaction_headers th,

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'
1057: AND trx.trx_reference_id = ctlgd.source_id_int_1