APPS.JE_JENOGEIS_XMLP_PKG dependencies on JE_NO_GEI_SREPORT_V

Line 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,

179: V_ACCOUNT_SEGMENTS := REPLACE(FND_PROFILE.VALUE('JENO_GEI_ACCOUNT_SEGMENT')
180: ,'-'
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

Line 232: JE_NO_GEI_SREPORT_V JUG

228: JUG.ACCOUNT_NUMBER ACCOUNT,
229: SUM(NVL(JUG.BALANCE
230: ,0)) BALANCE
231: FROM
232: JE_NO_GEI_SREPORT_V JUG
233: WHERE JUG.PERIOD_NUM <= T_PERIOD_NUM
234: AND JUG.PERIOD_YEAR = T_PERIOD_YEAR
235: AND NVL(JUG.BALANCE
236: ,0) <> 0

Line 250: JE_NO_GEI_SREPORT_V JUG

246: JUG.ACCOUNT_NUMBER ACCOUNT,
247: SUM(NVL(JUG.BALANCE
248: ,0)) BALANCE
249: FROM
250: JE_NO_GEI_SREPORT_V JUG
251: WHERE JUG.PERIOD_NUM > 12
252: AND JUG.PERIOD_YEAR = T_PERIOD_YEAR
253: AND NVL(JUG.BALANCE
254: ,0) <> 0

Line 476: JE_NO_GEI_SREPORT_V

472: SUM(NVL(BALANCE
473: ,0))
474: INTO BALANCE_SUM
475: FROM
476: JE_NO_GEI_SREPORT_V
477: WHERE PERIOD = P_PERIOD_NAME;
478: T_LINE_NUMBER := T_LINE_NUMBER + 1;
479: REF_NUM := 'S2 ';
480: T_TEXT := REF_NUM || TO_CHAR(BALANCE_SUM

Line 514: JE_NO_GEI_SREPORT_V JUG

510: NVL(SUM(BALANCE)
511: ,0)
512: INTO T_SUM_INCOME
513: FROM
514: JE_NO_GEI_SREPORT_V JUG
515: WHERE JUG.PERIOD_NUM <= T_PERIOD_NUM
516: AND JUG.PERIOD_YEAR = T_PERIOD_YEAR
517: AND JUG.ACCOUNT_NUMBER = T_INCOME_ACCOUNT
518: AND JUG.TEMPLATE_ID = T_DETAIL_TEMPL;

Line 569: JE_NO_GEI_SREPORT_V JUG

565: NVL(SUM(BALANCE)
566: ,0)
567: INTO T_SUM_EXPENSE
568: FROM
569: JE_NO_GEI_SREPORT_V JUG
570: WHERE JUG.PERIOD_NUM <= T_PERIOD_NUM
571: AND JUG.PERIOD_YEAR = T_PERIOD_YEAR
572: AND JUG.ACCOUNT_NUMBER = T_EXPENSE_ACCOUNT
573: AND JUG.TEMPLATE_ID = T_DETAIL_TEMPL;