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_GL_INTER_VALID_PKG dependencies on GL_JE_LINES

Line 141: l_cash_flow_item_from_GL gl_je_lines.attribute1%TYPE;

137: l_com_seg varchar2(150); --company segment of a line's account
138: l_com_seg_check number; --flag of an account's company segment belongs to current LE or not
139: l_account_check number; --flag of an account in cash related table or not
140: l_line_chk varchar2(20); --result of a line's validation
141: l_cash_flow_item_from_GL gl_je_lines.attribute1%TYPE;
142:
143: --Cursor to get FFV.Flex_Value and segment FSAV.APPLICATION_COLUMN_NAME of gcc
144: CURSOR c_ffv IS
145: SELECT FFV.Flex_Value ffv_flex_value

Line 285: FROM gl_je_lines jel

281: 'ATTRIBUTE15',jel.attribute15)
282: ) cash_related_item*/
283: SELECT global_attribute6 cash_related_item
284: INTO l_cash_flow_item_from_GL
285: FROM gl_je_lines jel
286: , fun_trx_headers trxh
287: , fun_trx_lines trxl
288: , fun_dist_lines distl
289: --,ja_cn_dff_assignments dffa

Line 690: l_je_line_num GL_JE_LINES.je_line_num%TYPE;

686: l_je_catg GL_JE_HEADERS.je_category%TYPE;
687: l_je_usr_catg gl_je_categories_tl.user_je_category_name%TYPE;
688: l_je_eff_date GL_JE_HEADERS.default_effective_date%TYPE;
689: l_je_desc GL_JE_HEADERS.description%TYPE;
690: l_je_line_num GL_JE_LINES.je_line_num%TYPE;
691: l_je_line_desc GL_JE_LINES.description%TYPE;
692: l_language VARCHAR(100):=userenv('LANG');
693: l_characterset varchar(245);
694:

Line 691: l_je_line_desc GL_JE_LINES.description%TYPE;

687: l_je_usr_catg gl_je_categories_tl.user_je_category_name%TYPE;
688: l_je_eff_date GL_JE_HEADERS.default_effective_date%TYPE;
689: l_je_desc GL_JE_HEADERS.description%TYPE;
690: l_je_line_num GL_JE_LINES.je_line_num%TYPE;
691: l_je_line_desc GL_JE_LINES.description%TYPE;
692: l_language VARCHAR(100):=userenv('LANG');
693: l_characterset varchar(245);
694:
695: --Cursor to get all periods between (P_START_PERIOD, P_END_PERIOD).

Line 790: FROM GL_JE_LINES jel

786: 'ATTRIBUTE9',jel.attribute9, 'ATTRIBUTE10',jel.attribute10, 'ATTRIBUTE11',jel.attribute11,
787: 'ATTRIBUTE12',jel.attribute12, 'ATTRIBUTE13',jel.attribute13, 'ATTRIBUTE14',jel.attribute14,
788: 'ATTRIBUTE15',jel.attribute15)
789: ) cash_related_item
790: FROM GL_JE_LINES jel
791: ,ja_cn_dff_assignments dffa
792: ,GL_CODE_COMBINATIONS codecmb --Added for CNAO Enhancement
793: ,FND_SEGMENT_ATTRIBUTE_VALUES fsav
794: WHERE jel.je_header_id = l_je_header_id --using variable l_je_header_id

Line 830: FROM GL_JE_LINES jel

826: jel.je_line_num line_num
827: ,jel.description line_desc
828: ,jel.code_combination_id account_ccid
829: ,jel.global_attribute6 cash_related_item
830: FROM GL_JE_LINES jel
831: ,GL_CODE_COMBINATIONS codecmb --Added for CNAO Enhancement
832: ,FND_SEGMENT_ATTRIBUTE_VALUES fsav
833: WHERE jel.je_header_id = l_je_header_id --using variable l_je_header_id
834: AND codecmb.code_combination_id = jel.code_combination_id