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.PSA_FUNDS_CHECKER_PKG dependencies on GL_LOOKUPS

Line 276: /* GL_LOOKUPS */

272: /* GL_BC_DUAL */
273: /* GL_BC_DUAL2 */
274: /* GL_CONCURRENCY_CONTROL */
275: /* GL_PERIOD_STATUSES */
276: /* GL_LOOKUPS */
277: /* GL_USSGL_TRANSACTION_CODES */
278: /* GL_USSGL_ACCOUNT_PAIRS */
279: /* GL_BALANCES */
280: /* GL_BUDGETS */

Line 2147: 'from gl_lookups lu, ' ||

2143:
2144: if g_reverse_tc_flag = 'N' then
2145:
2146: sql_ussgl := sql_ussgl ||
2147: 'from gl_lookups lu, ' ||
2148: 'gl_ussgl_transaction_codes uc, ' ||
2149: 'gl_ussgl_account_pairs guap, ' ||
2150: 'gl_code_combinations ccg, ' ||
2151: 'gl_code_combinations cco, ' ||

Line 2183: 'from gl_lookups lu, ' ||

2179: else
2180:
2181: sql_ussgl := sql_ussgl ||
2182:
2183: 'from gl_lookups lu, ' ||
2184: 'gl_ussgl_transaction_codes uc, ' ||
2185: 'gl_ussgl_account_pairs guap, ' ||
2186: 'gl_code_combinations ccg, ' ||
2187: 'gl_code_combinations cco, ' ||

Line 7760: l_line_description gl_lookups.description%TYPE;

7756: l_je_header_id gl_je_headers.je_header_id%TYPE;
7757: l_je_line_num gl_je_lines.je_line_num%TYPE;
7758: l_entered_dr gl_je_lines.entered_dr%TYPE;
7759: l_entered_cr gl_je_lines.entered_cr%TYPE;
7760: l_line_description gl_lookups.description%TYPE;
7761: l_line_result_code gl_bc_packets.result_code%TYPE;
7762: l_ccid gl_je_lines.code_combination_id%TYPE;
7763: l_rowid varchar2(100);
7764: l_priority gl_lookups.meaning%TYPE;

Line 7764: l_priority gl_lookups.meaning%TYPE;

7760: l_line_description gl_lookups.description%TYPE;
7761: l_line_result_code gl_bc_packets.result_code%TYPE;
7762: l_ccid gl_je_lines.code_combination_id%TYPE;
7763: l_rowid varchar2(100);
7764: l_priority gl_lookups.meaning%TYPE;
7765: l_je_seg_stmt varchar2(4000);
7766: l_je_sum_flex varchar2(4000);
7767: l_je_bud_stmt varchar2(4000);
7768: l_je_bud_flex varchar2(4000);

Line 7772: l_je_bud_desc gl_lookups.description%TYPE;

7768: l_je_bud_flex varchar2(4000);
7769: l_je_bud_dr gl_bc_packets.entered_dr%TYPE;
7770: l_je_bud_cr gl_bc_packets.entered_cr%TYPE;
7771: l_je_bud_result_code gl_bc_packets.result_code%TYPE;
7772: l_je_bud_desc gl_lookups.description%TYPE;
7773: l_je_bud_ccid gl_code_combinations.code_combination_id%TYPE;
7774: l_ussgl_parent_id gl_bc_packets.ussgl_parent_id%TYPE;
7775: l_je_bud_seg_stmt varchar2(4000);
7776: l_je_bud_sum_flex varchar2(4000);

Line 8229: gl_lookups

8225: meaning
8226: INTO
8227: l_fmeaning
8228: FROM
8229: gl_lookups
8230: WHERE
8231: lookup_code = l_glxfck_return_code
8232: AND lookup_type = 'FUNDS_CHECK_RETURN_CODE';
8233: EXCEPTION

Line 8237: 'Funds C/R: Failed to fetch meaning from gl_lookups');

8233: EXCEPTION
8234: WHEN OTHERS THEN
8235: -- =========================== FND LOG ===========================
8236: psa_utils.debug_other_string(g_excep_level,l_full_path,
8237: 'Funds C/R: Failed to fetch meaning from gl_lookups');
8238: fnd_file.put_line(fnd_file.log,
8239: 'Funds C/R: Failed to fetch meaning from gl_lookups');
8240: -- ========================= FND LOG =============================
8241: END;

Line 8239: 'Funds C/R: Failed to fetch meaning from gl_lookups');

8235: -- =========================== FND LOG ===========================
8236: psa_utils.debug_other_string(g_excep_level,l_full_path,
8237: 'Funds C/R: Failed to fetch meaning from gl_lookups');
8238: fnd_file.put_line(fnd_file.log,
8239: 'Funds C/R: Failed to fetch meaning from gl_lookups');
8240: -- ========================= FND LOG =============================
8241: END;
8242:
8243: -- =========================== FND LOG ===========================

Line 8254: gl_lookups l, gl_je_batches b

8250: l.meaning
8251: INTO
8252: l_jmeaning
8253: FROM
8254: gl_lookups l, gl_je_batches b
8255: WHERE
8256: l.lookup_code = b.budgetary_control_status
8257: AND l.lookup_type = 'JE_BATCH_BC_STATUS'
8258: AND b.je_batch_id = l_bc_pkts(x).je_batch_id;

Line 8342: 'gl_lookups lk, gl_bc_packets p '||

8338: l_je_stmt := l_je_stmt||', SUBSTRB(h.name,1,20), h.je_header_id, l.je_line_num, l.entered_dr, '||
8339: 'l.entered_cr, lk.description, p.result_code, l.code_combination_id, '||
8340: 'p.rowid '||
8341: 'FROM gl_je_lines l, gl_je_headers h, gl_code_combinations c, '||
8342: 'gl_lookups lk, gl_bc_packets p '||
8343: 'WHERE p.je_batch_id = '||l_failed_bc_pkts(x).je_batch_id||
8344: ' and p.packet_id = '||l_failed_bc_pkts(x).packet_id||
8345: ' and p.ledger_id = '||l_ledger_id||
8346: ' and p.je_header_id = h.je_header_id'||

Line 8381: gl_lookups l

8377: l.meaning
8378: INTO
8379: l_priority
8380: FROM
8381: gl_lookups l
8382: WHERE
8383: l.lookup_type = 'BC_SEVERITY_FLAG'
8384: AND l.lookup_code = upper(substr(l_line_result_code,1,1));
8385:

Line 8389: psa_utils.debug_other_string(g_excep_level,l_full_path, 'Funds C/R: Failed to fetch meaning from gl_lookups');

8385:
8386: EXCEPTION
8387: WHEN OTHERS THEN
8388: -- =========================== FND LOG ===========================
8389: psa_utils.debug_other_string(g_excep_level,l_full_path, 'Funds C/R: Failed to fetch meaning from gl_lookups');
8390: fnd_file.put_line(fnd_file.log, 'Funds C/R: Failed to fetch meaning from gl_lookups');
8391: -- ========================= FND LOG =============================
8392: END;
8393:

Line 8390: fnd_file.put_line(fnd_file.log, 'Funds C/R: Failed to fetch meaning from gl_lookups');

8386: EXCEPTION
8387: WHEN OTHERS THEN
8388: -- =========================== FND LOG ===========================
8389: psa_utils.debug_other_string(g_excep_level,l_full_path, 'Funds C/R: Failed to fetch meaning from gl_lookups');
8390: fnd_file.put_line(fnd_file.log, 'Funds C/R: Failed to fetch meaning from gl_lookups');
8391: -- ========================= FND LOG =============================
8392: END;
8393:
8394:

Line 8521: ' gl_lookups l WHERE p.ussgl_link_to_parent_id = '||l_ussgl_parent_id||

8517: END;
8518:
8519: l_je_bud_stmt := l_je_bud_stmt||' , p.entered_dr, p.entered_cr, p.result_code, l.description, '||
8520: ' c.code_combination_id FROM gl_code_combinations c, gl_bc_packets p, '||
8521: ' gl_lookups l WHERE p.ussgl_link_to_parent_id = '||l_ussgl_parent_id||
8522: ' and p.packet_id = '||l_failed_bc_pkts(x).packet_id||
8523: ' and c.code_combination_id = p.code_combination_id'||
8524: ' and p.result_code between ''F00'' AND ''F30'' and '||
8525: ' p.result_code = l.lookup_code and l.lookup_type = ''FUNDS_CHECK_RESULT_CODE'' '||