DBA Data[Home] [Help]

APPS.FA_XLA_EXTRACT_TRX_PKG dependencies on FA_MC_BOOK_CONTROLS

Line 185: fa_mc_book_controls mcbc ,

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'
189: AND th.transaction_header_id = ctlgd.source_id_int_1

Line 328: fa_mc_book_controls mcbc ,

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
332: AND trx.event_id = ctlgd.event_id

Line 1531: fa_mc_book_controls bc ,

1527: fa_distribution_history dh,
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

Line 1961: fa_mc_book_controls bc ,

1957: fa_distribution_history dh,
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

Line 2367: fa_mc_book_controls bc ,

2363: fa_mc_adjustments adj,
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

Line 2719: fa_mc_book_controls bc ,

2715: fa_locations loc,
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

Line 3024: fa_mc_book_controls bc ,

3020: fa_mc_adjustments adj,
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

Line 3395: fa_mc_book_controls bc ,

3391: fa_distribution_history dh,
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

Line 3766: fa_mc_book_controls bc ,

3762: fa_distribution_history dh,
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