DBA Data[Home] [Help]

APPS.FA_XLA_EXTRACT_TRX_PKG dependencies on GL_LEDGERS

Line 330: gl_ledgers le,

326: from fa_additions_b ad,
327: fa_asset_history ah,
328: fa_book_controls bc,
329: fa_category_books cb,
330: gl_ledgers le,
331: fa_transaction_headers th,
332: xla_events_gt ctlgd
333: where ctlgd.entity_code = 'TRANSACTIONS'
334: AND ctlgd.event_type_code in ('ADDITIONS', 'CIP_ADDITIONS',

Line 475: gl_ledgers le,

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: fa_trx_references trx,
478: xla_events_gt ctlgd
479: where ctlgd.entity_code = 'INTER_ASSET_TRANSACTIONS'

Line 571: gl_ledgers le,

567: from fa_additions_b ad,
568: fa_asset_history ah,
569: fa_book_controls bc,
570: fa_category_books cb,
571: gl_ledgers le,
572: fa_transaction_headers th,
573: fa_trx_references trx,
574: xla_events_gt ctlgd
575: where ctlgd.entity_code = 'INTER_ASSET_TRANSACTIONS'

Line 935: gl_ledgers le

931: fa_locations loc,
932: fa_lookups lu ,
933: fa_mc_asset_invoices ai,
934: fa_mc_book_controls bc ,
935: gl_ledgers le
936: WHERE adj.transaction_header_id = stg.transaction_header_id
937: AND adj.book_type_code = stg.book_type_code
938: AND adj.distribution_id = dh.distribution_id
939: AND dh.location_id = loc.location_id

Line 1276: gl_ledgers le

1272: fa_locations loc,
1273: fa_lookups lu ,
1274: fa_mc_asset_invoices ai,
1275: fa_mc_book_controls bc ,
1276: gl_ledgers le
1277: WHERE adj.transaction_header_id = stg.transaction_header_id
1278: AND adj.book_type_code = stg.book_type_code
1279: AND adj.distribution_id = dh.distribution_id
1280: AND dh.location_id = loc.location_id

Line 1595: gl_ledgers le

1591: fa_distribution_history dh,
1592: fa_locations loc,
1593: fa_lookups lu ,
1594: fa_mc_book_controls bc ,
1595: gl_ledgers le
1596: WHERE adj.transaction_header_id = stg.transaction_header_id
1597: AND adj.book_type_code = stg.book_type_code
1598: AND adj.distribution_id = dh.distribution_id
1599: AND dh.location_id = loc.location_id

Line 1884: gl_ledgers le

1880: fa_lookups lu ,
1881: fa_asset_history ah,
1882: fa_category_books cb ,
1883: fa_mc_book_controls bc ,
1884: gl_ledgers le
1885: WHERE adj.transaction_header_id = stg.transaction_header_id
1886: AND adj.book_type_code = stg.book_type_code
1887: AND adj.distribution_id = dh.distribution_id
1888: AND dh.location_id = loc.location_id

Line 2131: gl_ledgers le

2127: fa_distribution_history dh,
2128: fa_locations loc,
2129: fa_lookups lu ,
2130: fa_mc_book_controls bc ,
2131: gl_ledgers le
2132: WHERE adj.transaction_header_id = stg.transaction_header_id
2133: AND adj.book_type_code = stg.book_type_code
2134: AND adj.distribution_id = dh.distribution_id
2135: AND dh.location_id = loc.location_id

Line 2439: gl_ledgers le

2435: fa_locations loc,
2436: fa_lookups lu ,
2437: fa_retirements ret ,
2438: fa_mc_book_controls bc ,
2439: gl_ledgers le
2440: WHERE adj.transaction_header_id = stg.transaction_header_id
2441: AND adj.book_type_code = stg.book_type_code
2442: AND adj.distribution_id = dh.distribution_id
2443: AND dh.location_id = loc.location_id

Line 2746: gl_ledgers le

2742: fa_locations loc,
2743: fa_lookups lu ,
2744: fa_retirements ret ,
2745: fa_mc_book_controls bc ,
2746: gl_ledgers le
2747: WHERE adj.transaction_header_id = stg.transaction_header_id
2748: AND adj.book_type_code = stg.book_type_code
2749: AND adj.distribution_id = dh.distribution_id
2750: AND dh.location_id = loc.location_id