eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JL_BR_SPED_DATA_EXTRACT_PKG dependencies on GL_JE_LINES

Line 1197: p_je_line_num gl_je_lines.je_line_num%TYPE,

1193:
1194: END get_account_type;
1195:
1196: FUNCTION get_participant_code (p_je_header_id gl_je_headers.je_header_id%TYPE,
1197: p_je_line_num gl_je_lines.je_line_num%TYPE,
1198: p_journal_source gl_je_headers.je_source%TYPE,
1199: p_je_line_ccid gl_je_lines.code_combination_id%TYPE,
1200: p_third_party_id NUMBER,
1201: p_third_party_site_id NUMBER) RETURN VARCHAR2 AS

Line 1199: p_je_line_ccid gl_je_lines.code_combination_id%TYPE,

1195:
1196: FUNCTION get_participant_code (p_je_header_id gl_je_headers.je_header_id%TYPE,
1197: p_je_line_num gl_je_lines.je_line_num%TYPE,
1198: p_journal_source gl_je_headers.je_source%TYPE,
1199: p_je_line_ccid gl_je_lines.code_combination_id%TYPE,
1200: p_third_party_id NUMBER,
1201: p_third_party_site_id NUMBER) RETURN VARCHAR2 AS
1202: l_participant_code jl_br_sped_partic_codes.participant_code%TYPE := NULL;
1203: l_third_party_count NUMBER := 0;

Line 1239: ,gl_je_lines jl

1235:
1236: SELECT nvl(jl.global_attribute5,jh.global_attribute5)
1237: INTO l_participant_code
1238: FROM gl_je_headers jh
1239: ,gl_je_lines jl
1240: ,jl_br_sped_partic_codes pc
1241: WHERE jh.je_header_id = jl.je_header_id
1242: AND jh.je_header_id = p_je_header_id
1243: AND jl.je_line_num = p_je_line_num

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 3249: ,gl_je_lines jl

3245: ,'''||g_last_update_date||'''
3246: ,'||g_last_update_login||'
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

Line 4911: FROM gl_je_lines jl

4907: FROM fnd_lookups fl
4908: WHERE fl.lookup_type = 'JLBR_SPED_LEGACY_SOURCES'
4909: AND fl.ENABLED_FLAG = 'Y')
4910: AND EXISTS (SELECT 1
4911: FROM gl_je_lines jl
4912: WHERE jl.je_header_id= j.je_header_id
4913: AND jl.ledger_id=g_ledger_id
4914: AND (l_exclusive_mode = 'Y' OR
4915: (l_exclusive_mode = 'N' AND get_segment_value(jl.code_combination_id,g_bsv_segment) in (select jg_info_v1 from jg_zz_vat_trx_gt)))

Line 5094: FROM gl_je_lines jl

5090: ,g_creation_date
5091: ,g_last_updated_by
5092: ,g_last_update_date
5093: ,g_last_update_login
5094: FROM gl_je_lines jl
5095: WHERE jl.je_header_id = p_journal_header_id
5096: AND jl.accounted_dr is not null
5097: AND jl.ledger_id = g_ledger_id
5098: AND (l_exclusive_mode='Y' OR (l_exclusive_mode='N' AND get_segment_value(jl.code_combination_id,g_bsv_segment) in (SELECT jg_info_v1 FROM jg_zz_vat_trx_gt))); -- need to modify

Line 5157: FROM gl_je_lines jl

5153: ,g_creation_date
5154: ,g_last_updated_by
5155: ,g_last_update_date
5156: ,g_last_update_login
5157: FROM gl_je_lines jl
5158: WHERE jl.je_header_id = p_journal_header_id
5159: AND jl.accounted_cr is not null
5160: AND jl.ledger_id = g_ledger_id
5161: AND (l_exclusive_mode='Y' OR (l_exclusive_mode='N' AND get_segment_value(jl.code_combination_id,g_bsv_segment) in (SELECT jg_info_v1 FROM jg_zz_vat_trx_gt))); -- need to modify

Line 5339: gl_je_lines.effective_date%TYPE INDEX BY BINARY_INTEGER;

5335: l_api_name CONSTANT VARCHAR2(30) :='REGISTER_I300_I310';
5336: l_previous_date DATE := g_start_date-1;
5337:
5338: TYPE tab_effective_date IS TABLE OF
5339: gl_je_lines.effective_date%TYPE INDEX BY BINARY_INTEGER;
5340:
5341: TYPE tab_flex_value IS TABLE OF
5342: fnd_flex_values.flex_value%TYPE INDEX BY BINARY_INTEGER;
5343:

Line 5375: ,gl_je_lines jl

5371: ,decode('||l_cc_exists_flag||',0,null,glcc.'||g_cost_center_segment||') cost_center_acct
5372: ,NVL(SUM(jl.accounted_dr),0) accounted_dr
5373: ,NVL(SUM(jl.accounted_cr),0) accounted_cr
5374: FROM gl_je_headers jh
5375: ,gl_je_lines jl
5376: ,gl_code_combinations glcc
5377: WHERE jh.ledger_id = '||g_ledger_id||'
5378: AND jh.default_effective_date BETWEEN '''||g_start_date||''' AND '''||g_end_date||'''
5379: AND jh.je_header_id = jl.je_header_id

Line 7613: ,gl_je_lines jl

7609: SELECT COUNT(*) -- Payables invoices posted in Summary mode.
7610: INTO l_cnt
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

Line 7661: ,gl_je_lines jl

7657: SELECT COUNT(*) -- Receivables transactions posted in Summary mode.
7658: INTO l_cnt
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