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.JE_JENOGEIS_XMLP_PKG dependencies on GL_SETS_OF_BOOKS

Line 185: gl_balances gbs, gl_sets_of_books gso where gbs.code_combination_id = gcc.code_combination_id

181: ,'||');
182: V_DETAIL_TEMPLATE := FND_PROFILE.VALUE('JENO_GEI_DETAIL_TEMPL');
183: V_STRENG := 'create or replace view je_no_gei_sreport_v as select gcc.' || V_AUT_TYPE_SEGMENTS || ' authority_type ,gbs.period_name period,gbs.actual_flag,
184: ' || V_ACCOUNT_SEGMENTS || ' account_number,(gbs.period_net_dr - gbs.period_net_cr) balance,gbs.template_id, gbs.period_num, gbs.period_year from gl_code_combinations gcc,
185: gl_balances gbs, gl_sets_of_books gso where gbs.code_combination_id = gcc.code_combination_id
186: and gbs.ledger_id = gso.set_of_books_id and gso.currency_code = gbs.currency_code and gbs.template_id = ' || V_DETAIL_TEMPLATE;
187: EXECUTE IMMEDIATE
188: V_STRENG;
189: END;

Line 220: T_SET_OF_BOOKS GL_SETS_OF_BOOKS.SET_OF_BOOKS_ID%TYPE;

216: T_SUM_INCOME GL_BALANCES.PERIOD_NET_DR%TYPE;
217: T_SUM_EXPENSE GL_BALANCES.PERIOD_NET_DR%TYPE;
218: T_LINE_NUMBER JE_NO_GEI_ASCIIS_T.LINE_NUMBER%TYPE;
219: T_TEXT JE_NO_GEI_ASCIIS_T.TEXT%TYPE;
220: T_SET_OF_BOOKS GL_SETS_OF_BOOKS.SET_OF_BOOKS_ID%TYPE;
221: T_DETAIL_TEMPL GL_BALANCES.TEMPLATE_ID%TYPE;
222: T_INCOME_ACCOUNT GL_CODE_COMBINATIONS.SEGMENT1%TYPE;
223: T_EXPENSE_ACCOUNT GL_CODE_COMBINATIONS.SEGMENT1%TYPE;
224: PERIOD_NOT_GUILTY EXCEPTION;

Line 274: GL_SETS_OF_BOOKS

270: PERIOD_NUM
271: INTO T_CLOS,T_PERIOD_YEAR,T_PERIOD_NUM
272: FROM
273: GL_PERIOD_STATUSES,
274: GL_SETS_OF_BOOKS
275: WHERE GL_PERIOD_STATUSES.PERIOD_NAME = P_PERIOD_NAME
276: AND GL_PERIOD_STATUSES.APPLICATION_ID = '101'
277: AND GL_SETS_OF_BOOKS.SET_OF_BOOKS_ID = T_SET_OF_BOOKS
278: AND GL_SETS_OF_BOOKS.SET_OF_BOOKS_ID = GL_PERIOD_STATUSES.SET_OF_BOOKS_ID;

Line 277: AND GL_SETS_OF_BOOKS.SET_OF_BOOKS_ID = T_SET_OF_BOOKS

273: GL_PERIOD_STATUSES,
274: GL_SETS_OF_BOOKS
275: WHERE GL_PERIOD_STATUSES.PERIOD_NAME = P_PERIOD_NAME
276: AND GL_PERIOD_STATUSES.APPLICATION_ID = '101'
277: AND GL_SETS_OF_BOOKS.SET_OF_BOOKS_ID = T_SET_OF_BOOKS
278: AND GL_SETS_OF_BOOKS.SET_OF_BOOKS_ID = GL_PERIOD_STATUSES.SET_OF_BOOKS_ID;
279: IF T_PERIOD_NUM > 13 THEN
280: /*SRW.MESSAGE('100'
281: ,'Period is invalid.')*/NULL;

Line 278: AND GL_SETS_OF_BOOKS.SET_OF_BOOKS_ID = GL_PERIOD_STATUSES.SET_OF_BOOKS_ID;

274: GL_SETS_OF_BOOKS
275: WHERE GL_PERIOD_STATUSES.PERIOD_NAME = P_PERIOD_NAME
276: AND GL_PERIOD_STATUSES.APPLICATION_ID = '101'
277: AND GL_SETS_OF_BOOKS.SET_OF_BOOKS_ID = T_SET_OF_BOOKS
278: AND GL_SETS_OF_BOOKS.SET_OF_BOOKS_ID = GL_PERIOD_STATUSES.SET_OF_BOOKS_ID;
279: IF T_PERIOD_NUM > 13 THEN
280: /*SRW.MESSAGE('100'
281: ,'Period is invalid.')*/NULL;
282: /*RAISE SRW.PROGRAM_ABORT*/RAISE_APPLICATION_ERROR(-20101,null);