DBA Data[Home] [Help]

APPS.FA_XLA_EXTRACT_TRX_PKG dependencies on FA_LOOKUPS

Line 768: fa_lookups lu ,

764: from fa_xla_ext_lines_stg_gt stg,
765: fa_adjustments adj,
766: fa_distribution_history dh,
767: fa_locations loc,
768: fa_lookups lu ,
769: FA_ASSET_INVOICES ai
770: WHERE adj.transaction_header_id = stg.transaction_header_id
771: AND adj.book_type_code = stg.book_type_code
772: AND adj.distribution_id = dh.distribution_id

Line 932: fa_lookups lu ,

928: from fa_xla_ext_lines_stg_gt stg,
929: fa_mc_adjustments adj,
930: fa_distribution_history dh,
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

Line 1127: fa_lookups lu ,

1123: from fa_xla_ext_lines_stg_gt stg,
1124: fa_adjustments adj,
1125: fa_distribution_history dh,
1126: fa_locations loc,
1127: fa_lookups lu ,
1128: FA_ASSET_INVOICES ai
1129: WHERE adj.transaction_header_id = stg.transaction_header_id
1130: AND adj.book_type_code = stg.book_type_code
1131: AND adj.distribution_id = dh.distribution_id

Line 1273: fa_lookups lu ,

1269: from fa_xla_ext_lines_stg_gt stg,
1270: fa_mc_adjustments adj,
1271: fa_distribution_history dh,
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

Line 1457: fa_lookups lu

1453: from fa_xla_ext_lines_stg_gt stg,
1454: fa_adjustments adj,
1455: fa_distribution_history dh,
1456: fa_locations loc,
1457: fa_lookups lu
1458: WHERE adj.transaction_header_id = stg.transaction_header_id
1459: AND adj.book_type_code = stg.book_type_code
1460: AND adj.distribution_id = dh.distribution_id
1461: AND dh.location_id = loc.location_id

Line 1593: fa_lookups lu ,

1589: from fa_xla_ext_lines_stg_gt stg,
1590: fa_mc_adjustments adj,
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

Line 1754: fa_lookups lu ,

1750: from fa_xla_ext_lines_stg_gt stg,
1751: fa_adjustments adj,
1752: fa_distribution_history dh,
1753: fa_locations loc,
1754: fa_lookups lu ,
1755: fa_asset_history ah,
1756: fa_category_books cb
1757: WHERE adj.transaction_header_id = stg.transaction_header_id
1758: AND adj.book_type_code = stg.book_type_code

Line 1880: fa_lookups lu ,

1876: from fa_xla_ext_lines_stg_gt stg,
1877: fa_mc_adjustments adj,
1878: fa_distribution_history dh,
1879: fa_locations loc,
1880: fa_lookups lu ,
1881: fa_asset_history ah,
1882: fa_category_books cb ,
1883: fa_mc_book_controls bc ,
1884: gl_ledgers le

Line 2009: fa_lookups lu

2005: from fa_xla_ext_lines_stg_gt stg,
2006: fa_adjustments adj,
2007: fa_distribution_history dh,
2008: fa_locations loc,
2009: fa_lookups lu
2010: WHERE adj.transaction_header_id = stg.transaction_header_id
2011: AND adj.book_type_code = stg.book_type_code
2012: AND adj.distribution_id = dh.distribution_id
2013: AND dh.location_id = loc.location_id

Line 2129: fa_lookups lu ,

2125: from fa_xla_ext_lines_stg_gt stg,
2126: fa_mc_adjustments adj,
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

Line 2304: fa_lookups lu ,

2300: from fa_xla_ext_lines_stg_gt stg,
2301: fa_adjustments adj,
2302: fa_distribution_history dh,
2303: fa_locations loc,
2304: fa_lookups lu ,
2305: fa_retirements ret
2306: WHERE adj.transaction_header_id = stg.transaction_header_id
2307: AND adj.book_type_code = stg.book_type_code
2308: AND adj.distribution_id = dh.distribution_id

Line 2436: fa_lookups lu ,

2432: from fa_xla_ext_lines_stg_gt stg,
2433: fa_mc_adjustments adj,
2434: fa_distribution_history dh,
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

Line 2611: fa_lookups lu ,

2607: from fa_xla_ext_lines_stg_gt stg,
2608: fa_adjustments adj,
2609: fa_distribution_history dh,
2610: fa_locations loc,
2611: fa_lookups lu ,
2612: fa_retirements ret
2613: WHERE adj.transaction_header_id = stg.transaction_header_id
2614: AND adj.book_type_code = stg.book_type_code
2615: AND adj.distribution_id = dh.distribution_id

Line 2743: fa_lookups lu ,

2739: from fa_xla_ext_lines_stg_gt stg,
2740: fa_mc_adjustments adj,
2741: fa_distribution_history dh,
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