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.JA_CN_CFS_DATA_CLT_PKG dependencies on GL_JE_LINES

Line 318: FROM gl_je_lines jel

314: 'ATTRIBUTE12',jel.attribute12, 'ATTRIBUTE13',jel.attribute13, 'ATTRIBUTE14',jel.attribute14,
315: 'ATTRIBUTE15',jel.attribute15)
316: ) cash_related_item
317: INTO l_tr_csi_check
318: FROM gl_je_lines jel
319: , fun_trx_headers trxh
320: , fun_trx_lines trxl
321: , fun_dist_lines distl
322: ,ja_cn_dff_assignments dffa --

Line 673: l_je_line_num GL_JE_LINES.je_line_num%TYPE;

669: l_je_curr_cov_type GL_JE_HEADERS.currency_conversion_type%TYPE;
670: l_je_curr_cov_date GL_JE_HEADERS.currency_conversion_date%TYPE;
671: l_je_inter_flag GL_JE_HEADERS.global_attribute1%TYPE;
672: l_je_effective_date GL_JE_HEADERS.DEFAULT_EFFECTIVE_DATE%TYPE;
673: l_je_line_num GL_JE_LINES.je_line_num%TYPE;
674: l_je_line_desc GL_JE_LINES.description%TYPE;
675: l_je_line_amount NUMBER;
676: l_je_line_func_amount NUMBER;
677: -- GL: Gl_JE_LINES

Line 674: l_je_line_desc GL_JE_LINES.description%TYPE;

670: l_je_curr_cov_date GL_JE_HEADERS.currency_conversion_date%TYPE;
671: l_je_inter_flag GL_JE_HEADERS.global_attribute1%TYPE;
672: l_je_effective_date GL_JE_HEADERS.DEFAULT_EFFECTIVE_DATE%TYPE;
673: l_je_line_num GL_JE_LINES.je_line_num%TYPE;
674: l_je_line_desc GL_JE_LINES.description%TYPE;
675: l_je_line_amount NUMBER;
676: l_je_line_func_amount NUMBER;
677: -- GL: Gl_JE_LINES
678: l_ccid GL_CODE_COMBINATIONS.Code_Combination_Id%TYPE;

Line 677: -- GL: Gl_JE_LINES

673: l_je_line_num GL_JE_LINES.je_line_num%TYPE;
674: l_je_line_desc GL_JE_LINES.description%TYPE;
675: l_je_line_amount NUMBER;
676: l_je_line_func_amount NUMBER;
677: -- GL: Gl_JE_LINES
678: l_ccid GL_CODE_COMBINATIONS.Code_Combination_Id%TYPE;
679: l_cash_related_item varchar2(150); --cash related item of a line
680: l_cash_related_item_1 varchar2(150); --copy of cash related item of a line
681: l_csi_check varchar2(2); --blank or not of cash related item

Line 820: FROM GL_JE_LINES jel

816: ,nvl(jel.ENTERED_DR, 0) -
817: nvl(jel.ENTERED_CR, 0) je_entered_amount
818: ,nvl(jel.ACCOUNTED_DR, 0) -
819: nvl(jel.ACCOUNTED_CR, 0) je_accounted_amount
820: FROM GL_JE_LINES jel
821: ,GL_JE_HEADERS jeh
822: ,ja_cn_dff_assignments dffa
823: WHERE jel.je_header_id = l_je_header_id --using variable l_je_header_id
824: AND jeh.je_header_id = jel.je_header_id