DBA Data[Home] [Help]

APPS.FA_XLA_EXTRACT_TRX_PKG dependencies on FA_BOOK_CONTROLS

Line 112: fa_book_controls bc ,

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'
115: AND ctlgd.event_type_code <> 'INFLATION_REVALUATION'
116: AND th.transaction_header_id = ctlgd.source_id_int_1

Line 183: fa_book_controls bc ,

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 ,
186: gl_ledgers le
187: WHERE ctlgd.entity_code = 'TRANSACTIONS'

Line 276: fa_book_controls bc ,

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

Line 326: fa_book_controls bc ,

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

Line 473: fa_book_controls bc,

469: cb.DEPRN_RESERVE_ACCT,
470: cb.REVAL_RESERVE_ACCT
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

Line 579: fa_book_controls bc,

575: cb.DEPRN_RESERVE_ACCT,
576: cb.REVAL_RESERVE_ACCT
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

Line 728: fa_book_controls bc,

724: cb.DEPRN_RESERVE_ACCT,
725: cb.REVAL_RESERVE_ACCT
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,

Line 836: fa_book_controls bc,

832: cb.DEPRN_RESERVE_ACCT,
833: cb.REVAL_RESERVE_ACCT
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,

Line 942: fa_book_controls bc,

938: cb.DEPRN_RESERVE_ACCT,
939: cb.REVAL_RESERVE_ACCT
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,

Line 1050: fa_book_controls bc,

1046: cb.DEPRN_RESERVE_ACCT,
1047: cb.REVAL_RESERVE_ACCT
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,