APPS.FA_XLA_EXTRACT_TRX_PKG dependencies on XLA_EVENTS_GT

Line 110: FROM xla_events_gt ctlgd,

106: bc.PROCEEDS_OF_SALE_GAIN_ACCT,
107: bc.PROCEEDS_OF_SALE_LOSS_ACCT,
108: bc.REVAL_RSV_RETIRED_GAIN_ACCT,
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'

Line 181: FROM xla_events_gt ctlgd,

177: bc.PROCEEDS_OF_SALE_GAIN_ACCT,
178: bc.PROCEEDS_OF_SALE_LOSS_ACCT,
179: bc.REVAL_RSV_RETIRED_GAIN_ACCT,
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 ,

Line 274: FROM xla_events_gt ctlgd,

270: decode(bc.GL_POSTING_ALLOWED_FLAG ,
271: 'YES', 'Y','N') ,
272: bc.AP_INTERCOMPANY_ACCT,
273: bc.AR_INTERCOMPANY_ACCT
274: FROM xla_events_gt ctlgd,
275: fa_deprn_periods dp,
276: fa_book_controls bc ,
277: FA_TRX_REFERENCES trx
278: WHERE ctlgd.entity_code = 'INTER_ASSET_TRANSACTIONS'

Line 324: FROM xla_events_gt ctlgd,

320: decode(mcbc.GL_POSTING_ALLOWED_FLAG ,
321: 'YES', 'Y','N') ,
322: bc.AP_INTERCOMPANY_ACCT,
323: bc.AR_INTERCOMPANY_ACCT
324: FROM xla_events_gt ctlgd,
325: fa_deprn_periods dp,
326: fa_book_controls bc ,
327: FA_TRX_REFERENCES trx ,
328: fa_mc_book_controls mcbc ,

Line 477: xla_events_gt ctlgd

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
481: AND ad.asset_id = th.asset_id

Line 583: xla_events_gt ctlgd

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
587: AND ad.asset_id = th.asset_id

Line 733: xla_events_gt ctlgd

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
736: AND bc.book_type_code = ctlgd.valuation_method
737: AND le.ledger_id = bc.set_of_books_id

Line 841: xla_events_gt ctlgd

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
844: AND bc.book_type_code = ctlgd.valuation_method
845: AND le.ledger_id = bc.set_of_books_id

Line 947: xla_events_gt ctlgd

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
950: AND bc.book_type_code = ctlgd.valuation_method
951: AND le.ledger_id = bc.set_of_books_id

Line 1055: xla_events_gt ctlgd

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
1058: AND bc.book_type_code = ctlgd.valuation_method
1059: AND le.ledger_id = bc.set_of_books_id

Line 4116: from xla_events_gt xg,

4112: -- Bug 6962827 : counter_offset_account_segment
4113: decode(xl.adjustment_type,
4114: 'BONUS EXPENSE', xl.DEPRN_RESERVE_ACCT,
4115: NULL)
4116: from xla_events_gt xg,
4117: fa_xla_ext_headers_b_gt xb,
4118: fa_xla_ext_lines_b_gt xl,
4119: fa_distribution_accounts da
4120: where xg.event_class_code not in ('DEPRECIATION', 'DEFERRED')