APPS.JL_BR_SPED_DATA_EXTRACT_PKG dependencies on XLA_AE_LINES

Line 1347: FROM gl_import_references glimp, GL_JE_LINES JL , xla_ae_lines xll

1343: BEGIN
1344:
1345: SELECT DISTINCT xll.party_id , xll.party_site_id --- NEED TO CHECK IF SAME CUSTOMER WITH DIFFERENT CUST SITE ID
1346: INTO l_third_party_id, l_third_party_site_id
1347: FROM gl_import_references glimp, GL_JE_LINES JL , xla_ae_lines xll
1348: WHERE glimp.je_header_id = p_je_header_id
1349: AND glimp.je_header_id = jl.je_header_id
1350: AND glimp.je_line_num = p_je_line_num
1351: AND glimp.je_line_num = jl.je_line_num

Line 3251: ,xla_ae_lines xll

3247: FROM (SELECT DISTINCT glcc.'||g_account_segment||' natural_acct
3248: FROM gl_je_headers jh
3249: ,gl_je_lines jl
3250: ,gl_import_references glimp
3251: ,xla_ae_lines xll
3252: ,xla_ae_headers xlh
3253: ,xla_distribution_links xld
3254: ,gl_code_combinations glcc
3255: WHERE jh.ledger_id = '||g_ledger_id||'

Line 5174: --Extract the detail lines by drill down to xla_ae_lines_all and xla_distributions_links table.

5170: END;
5171: ELSE -- If g_bookkeeping_type = 'A/R' or 'A/B' and auxiliary book exists.
5172:
5173:
5174: --Extract the detail lines by drill down to xla_ae_lines_all and xla_distributions_links table.
5175:
5176: BEGIN
5177: INSERT INTO jl_br_sped_extr_data_t
5178: (request_id,

Line 5232: xla_ae_lines xll,

5228: , g_last_updated_by
5229: , g_last_update_date
5230: , g_last_update_login
5231: FROM gl_import_references glimp,
5232: xla_ae_lines xll,
5233: xla_ae_headers xlh,
5234: XLA_DISTRIBUTION_LINKS xld
5235: WHERE glimp.je_header_id = p_journal_header_id
5236: AND xlh.ledger_id = g_ledger_id

Line 5304: xla_ae_lines xll,

5300: , g_last_updated_by
5301: , g_last_update_date
5302: , g_last_update_login
5303: FROM gl_import_references glimp,
5304: xla_ae_lines xll,
5305: xla_ae_headers xlh,
5306: XLA_DISTRIBUTION_LINKS xld
5307: WHERE glimp.je_header_id = p_journal_header_id
5308: AND xlh.ledger_id = g_ledger_id

Line 7615: ,xla_ae_lines xll

7611: FROM (SELECT jl.code_combination_id
7612: FROM gl_je_headers jh
7613: ,gl_je_lines jl
7614: ,gl_import_references glimp
7615: ,xla_ae_lines xll
7616: ,xla_ae_headers xlh
7617: ,xla_distribution_links xld
7618: WHERE jh.ledger_id = g_ledger_id
7619: AND jh.je_source in ('Payables')

Line 7663: ,xla_ae_lines xll

7659: FROM (SELECT jl.code_combination_id
7660: FROM gl_je_headers jh
7661: ,gl_je_lines jl
7662: ,gl_import_references glimp
7663: ,xla_ae_lines xll
7664: ,xla_ae_headers xlh
7665: ,xla_distribution_links xld
7666: WHERE jh.ledger_id = g_ledger_id
7667: AND jh.je_source in ('Receivables')