DBA Data[Home] [Help]

APPS.FA_XLA_EXTRACT_TRX_PKG dependencies on FA_TRX_REFERENCES

Line 277: FA_TRX_REFERENCES trx

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'
279: AND trx.trx_reference_id = ctlgd.source_id_int_1
280: AND trx.event_id = ctlgd.event_id
281: AND trx.book_type_code = dp.book_type_code

Line 327: FA_TRX_REFERENCES trx ,

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 ,
329: gl_ledgers le
330: WHERE ctlgd.entity_code = 'INTER_ASSET_TRANSACTIONS'
331: AND trx.trx_reference_id = ctlgd.source_id_int_1

Line 732: fa_trx_references trx,

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

Line 840: fa_trx_references trx,

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

Line 946: fa_trx_references trx,

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

Line 1054: fa_trx_references trx,

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