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.OKI_DBI_NSCM_ACT_PVT dependencies on OKI_DBI_UTIL_PVT

Line 62: OKI_DBI_UTIL_PVT.process_parameters ( p_param => p_param

58:
59: IF (l_balance_logic = 'EVENTDATE') THEN
60: --{
61:
62: OKI_DBI_UTIL_PVT.process_parameters ( p_param => p_param
63: , p_view_by => l_view_by
64: , p_view_by_col_name => l_view_by_col
65: , p_comparison_type => l_comparison_type
66: , p_xtd => l_xtd1

Line 99: OKI_DBI_UTIL_PVT.process_parameters ( p_param => p_param

95: , p_alias_name => 'ARsro'
96: , p_to_date_type => l_to_date_xtd);
97:
98:
99: OKI_DBI_UTIL_PVT.process_parameters ( p_param => p_param
100: , p_view_by => l_view_by
101: , p_view_by_col_name => l_view_by_col
102: , p_comparison_type => l_comparison_type
103: , p_xtd => l_xtd2

Line 176: OKI_DBI_UTIL_PVT.process_parameters ( p_param => p_param

172: --}
173: ELSE
174: --{
175:
176: OKI_DBI_UTIL_PVT.process_parameters ( p_param => p_param
177: , p_view_by => l_view_by
178: , p_view_by_col_name => l_view_by_col
179: , p_comparison_type => l_comparison_type
180: , p_xtd => l_xtd

Line 228: OKI_DBI_UTIL_PVT.get_custom_status_binds (x_custom_output);

224: END IF;
225:
226: x_custom_sql := l_query;
227:
228: OKI_DBI_UTIL_PVT.get_custom_status_binds (x_custom_output);
229:
230: END get_activations_sql ;
231:
232: /******************************************************************

Line 253: l_viewby_select := OKI_DBI_UTIL_PVT.get_viewby_select_clause(p_view_by_dim, 'SRM', '6.0');

249:
250: /* Balance logic for OI */
251: l_balance_logic := nvl(fnd_profile.value('OKI_BAL_IDENT'),'CONTRDATE');
252:
253: l_viewby_select := OKI_DBI_UTIL_PVT.get_viewby_select_clause(p_view_by_dim, 'SRM', '6.0');
254:
255: -- when view by is Salesrep OKI_DBI_SCM_ACT_DTL_RPT
256: l_newbus_url := '''pFunctionName=OKI_DBI_SCM_ACT_DTL_RPT&VIEW_BY_NAME=VIEW_BY_ID&pParamIds=Y&OKI_STATUS+ACT_TYPE=1''';
257:

Line 316: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset20.tac_PoT','oset20.p_tac_PoT','P') || ' OKI_PERCENT_CHANGE_1 '||

312: ' , oset20.TAC_chg OKI_CHANGE_1 '||
313: ' , oset20.TAC_chg_tot OKI_TCHANGE_1 '||
314: ' , oset20.TAC_PoT OKI_PERCENT_1 '||
315: ' , oset20.TAC_PoT_tot OKI_TPERCENT_1 '||
316: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset20.tac_PoT','oset20.p_tac_PoT','P') || ' OKI_PERCENT_CHANGE_1 '||
317: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset20.c_NB','oset20.p_NB','NP') || ' OKI_PERCENT_CHANGE_2 '||
318: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset20.c_NB_tot','oset20.p_NB_tot','NP') || ' OKI_ATTRIBUTE_1'||
319: ' , oset20.C_NB OKI_MEASURE_2 '||
320: ' , oset20.C_NB_tot OKI_TMEASURE_2 '||

Line 317: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset20.c_NB','oset20.p_NB','NP') || ' OKI_PERCENT_CHANGE_2 '||

313: ' , oset20.TAC_chg_tot OKI_TCHANGE_1 '||
314: ' , oset20.TAC_PoT OKI_PERCENT_1 '||
315: ' , oset20.TAC_PoT_tot OKI_TPERCENT_1 '||
316: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset20.tac_PoT','oset20.p_tac_PoT','P') || ' OKI_PERCENT_CHANGE_1 '||
317: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset20.c_NB','oset20.p_NB','NP') || ' OKI_PERCENT_CHANGE_2 '||
318: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset20.c_NB_tot','oset20.p_NB_tot','NP') || ' OKI_ATTRIBUTE_1'||
319: ' , oset20.C_NB OKI_MEASURE_2 '||
320: ' , oset20.C_NB_tot OKI_TMEASURE_2 '||
321: ' , oset20.C_NB OKI_KPI_MEASURE_2 '||

Line 318: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset20.c_NB_tot','oset20.p_NB_tot','NP') || ' OKI_ATTRIBUTE_1'||

314: ' , oset20.TAC_PoT OKI_PERCENT_1 '||
315: ' , oset20.TAC_PoT_tot OKI_TPERCENT_1 '||
316: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset20.tac_PoT','oset20.p_tac_PoT','P') || ' OKI_PERCENT_CHANGE_1 '||
317: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset20.c_NB','oset20.p_NB','NP') || ' OKI_PERCENT_CHANGE_2 '||
318: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset20.c_NB_tot','oset20.p_NB_tot','NP') || ' OKI_ATTRIBUTE_1'||
319: ' , oset20.C_NB OKI_MEASURE_2 '||
320: ' , oset20.C_NB_tot OKI_TMEASURE_2 '||
321: ' , oset20.C_NB OKI_KPI_MEASURE_2 '||
322: ' , oset20.p_NB OKI_PKPI_MEASURE_2 '||

Line 328: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset20.c_AR','oset20.p_AR','NP') || ' OKI_ATTRIBUTE_5 '||

324: ' , oset20.p_NB_tot OKI_PTKPI_MEASURE_2 '||
325: ' , oset20.NB_PoT OKI_PERCENT_2 '||
326: ' , oset20.NB_PoT_tot OKI_TPERCENT_2 '||
327: ' , oset20.c_AE OKI_MEASURE_3 '||
328: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset20.c_AR','oset20.p_AR','NP') || ' OKI_ATTRIBUTE_5 '||
329: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset20.c_AR_tot','oset20.p_AR_tot','NP') || ' OKI_ATTRIBUTE_4 '||
330: ' , oset20.c_AE_tot OKI_TMEASURE_3 '||
331: ' , oset20.c_Upl OKI_MEASURE_4 '||
332: ' , oset20.c_Upl_tot OKI_TMEASURE_4 '||

Line 329: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset20.c_AR_tot','oset20.p_AR_tot','NP') || ' OKI_ATTRIBUTE_4 '||

325: ' , oset20.NB_PoT OKI_PERCENT_2 '||
326: ' , oset20.NB_PoT_tot OKI_TPERCENT_2 '||
327: ' , oset20.c_AE OKI_MEASURE_3 '||
328: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset20.c_AR','oset20.p_AR','NP') || ' OKI_ATTRIBUTE_5 '||
329: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset20.c_AR_tot','oset20.p_AR_tot','NP') || ' OKI_ATTRIBUTE_4 '||
330: ' , oset20.c_AE_tot OKI_TMEASURE_3 '||
331: ' , oset20.c_Upl OKI_MEASURE_4 '||
332: ' , oset20.c_Upl_tot OKI_TMEASURE_4 '||
333: ' , oset20.c_AR OKI_MEASURE_5 '||

Line 347: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset15.C_TAC','oset15.P_TAC','NP') || ' TAC_chg '||

343: -- Change Calculation
344: ' '|| p_view_by_col ||
345: ' , oset15.C_TAC C_TAC '||
346: ' , oset15.P_TAC P_TAC '||
347: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset15.C_TAC','oset15.P_TAC','NP') || ' TAC_chg '||
348: ' ,'||poa_dbi_util_pkg.rate_clause('oset15.c_TAC','oset15.c_TAC_tot') || 'tac_PoT '||
349: ' ,'||poa_dbi_util_pkg.rate_clause('oset15.p_TAC','oset15.p_TAC_tot') || 'p_tac_PoT '||
350: ' , oset15.C_TAC_tot C_TAC_tot '||
351: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset15.C_TAc_tot','oset15.P_TAC_tot','NP') || ' TAC_chg_tot '||

Line 351: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset15.C_TAc_tot','oset15.P_TAC_tot','NP') || ' TAC_chg_tot '||

347: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset15.C_TAC','oset15.P_TAC','NP') || ' TAC_chg '||
348: ' ,'||poa_dbi_util_pkg.rate_clause('oset15.c_TAC','oset15.c_TAC_tot') || 'tac_PoT '||
349: ' ,'||poa_dbi_util_pkg.rate_clause('oset15.p_TAC','oset15.p_TAC_tot') || 'p_tac_PoT '||
350: ' , oset15.C_TAC_tot C_TAC_tot '||
351: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset15.C_TAc_tot','oset15.P_TAC_tot','NP') || ' TAC_chg_tot '||
352: ' ,'||poa_dbi_util_pkg.rate_clause('oset15.c_TAC_tot','oset15.c_TAC_tot') || 'tac_PoT_tot '||
353: ' , oset15.c_NB '||
354: ' , oset15.p_NB '||
355: ' ,'||poa_dbi_util_pkg.rate_clause('oset15.c_NB','oset15.c_TAC') || ' NB_PoT '||

Line 382: ' ,'|| OKI_DBI_UTIL_PVT.add_measures('oset10.c_NB','oset10.c_AR') ||' c_TAC '||

378: ' , oset10.c_AE '||
379: ' , oset10.c_AR '||
380: ' , oset10.p_AR '||
381: ' , oset10.p_AE '||
382: ' ,'|| OKI_DBI_UTIL_PVT.add_measures('oset10.c_NB','oset10.c_AR') ||' c_TAC '||
383: ' ,'|| OKI_DBI_UTIL_PVT.add_measures('oset10.p_NB','oset10.p_AR') ||' p_TAC '||
384: ' ,'|| OKI_DBI_UTIL_PVT.subtract_measures('oset10.c_AR','oset10.c_AE') ||' c_Upl '||
385: ' , oset10.c_NB_tot '||
386: ' , oset10.p_NB_tot '||

Line 383: ' ,'|| OKI_DBI_UTIL_PVT.add_measures('oset10.p_NB','oset10.p_AR') ||' p_TAC '||

379: ' , oset10.c_AR '||
380: ' , oset10.p_AR '||
381: ' , oset10.p_AE '||
382: ' ,'|| OKI_DBI_UTIL_PVT.add_measures('oset10.c_NB','oset10.c_AR') ||' c_TAC '||
383: ' ,'|| OKI_DBI_UTIL_PVT.add_measures('oset10.p_NB','oset10.p_AR') ||' p_TAC '||
384: ' ,'|| OKI_DBI_UTIL_PVT.subtract_measures('oset10.c_AR','oset10.c_AE') ||' c_Upl '||
385: ' , oset10.c_NB_tot '||
386: ' , oset10.p_NB_tot '||
387: ' , oset10.c_AE_tot '||

Line 384: ' ,'|| OKI_DBI_UTIL_PVT.subtract_measures('oset10.c_AR','oset10.c_AE') ||' c_Upl '||

380: ' , oset10.p_AR '||
381: ' , oset10.p_AE '||
382: ' ,'|| OKI_DBI_UTIL_PVT.add_measures('oset10.c_NB','oset10.c_AR') ||' c_TAC '||
383: ' ,'|| OKI_DBI_UTIL_PVT.add_measures('oset10.p_NB','oset10.p_AR') ||' p_TAC '||
384: ' ,'|| OKI_DBI_UTIL_PVT.subtract_measures('oset10.c_AR','oset10.c_AE') ||' c_Upl '||
385: ' , oset10.c_NB_tot '||
386: ' , oset10.p_NB_tot '||
387: ' , oset10.c_AE_tot '||
388: ' , oset10.c_AR_tot '||

Line 390: ' ,'|| OKI_DBI_UTIL_PVT.add_measures('oset10.c_NB_tot','oset10.c_AR_tot') ||' c_TAC_tot '||

386: ' , oset10.p_NB_tot '||
387: ' , oset10.c_AE_tot '||
388: ' , oset10.c_AR_tot '||
389: ' , oset10.p_AR_tot '||
390: ' ,'|| OKI_DBI_UTIL_PVT.add_measures('oset10.c_NB_tot','oset10.c_AR_tot') ||' c_TAC_tot '||
391: ' ,'|| OKI_DBI_UTIL_PVT.subtract_measures('oset10.c_AR_tot','oset10.c_AE_tot') ||' c_Upl_tot '||
392: ' ,'|| OKI_DBI_UTIL_PVT.add_measures('oset10.p_NB_tot','oset10.p_AR_tot') ||' p_TAC_tot ';
393:
394: IF (l_balance_logic = 'EVENTDATE') THEN

Line 391: ' ,'|| OKI_DBI_UTIL_PVT.subtract_measures('oset10.c_AR_tot','oset10.c_AE_tot') ||' c_Upl_tot '||

387: ' , oset10.c_AE_tot '||
388: ' , oset10.c_AR_tot '||
389: ' , oset10.p_AR_tot '||
390: ' ,'|| OKI_DBI_UTIL_PVT.add_measures('oset10.c_NB_tot','oset10.c_AR_tot') ||' c_TAC_tot '||
391: ' ,'|| OKI_DBI_UTIL_PVT.subtract_measures('oset10.c_AR_tot','oset10.c_AE_tot') ||' c_Upl_tot '||
392: ' ,'|| OKI_DBI_UTIL_PVT.add_measures('oset10.p_NB_tot','oset10.p_AR_tot') ||' p_TAC_tot ';
393:
394: IF (l_balance_logic = 'EVENTDATE') THEN
395: --{

Line 392: ' ,'|| OKI_DBI_UTIL_PVT.add_measures('oset10.p_NB_tot','oset10.p_AR_tot') ||' p_TAC_tot ';

388: ' , oset10.c_AR_tot '||
389: ' , oset10.p_AR_tot '||
390: ' ,'|| OKI_DBI_UTIL_PVT.add_measures('oset10.c_NB_tot','oset10.c_AR_tot') ||' c_TAC_tot '||
391: ' ,'|| OKI_DBI_UTIL_PVT.subtract_measures('oset10.c_AR_tot','oset10.c_AE_tot') ||' c_Upl_tot '||
392: ' ,'|| OKI_DBI_UTIL_PVT.add_measures('oset10.p_NB_tot','oset10.p_AR_tot') ||' p_TAC_tot ';
393:
394: IF (l_balance_logic = 'EVENTDATE') THEN
395: --{
396: l_sel_clause := l_sel_clause ||

Line 488: OKI_DBI_UTIL_PVT.process_parameters (p_param => p_param

484: l_balance_logic := nvl(fnd_profile.value('OKI_BAL_IDENT'),'CONTRDATE');
485:
486: IF (l_balance_logic = 'EVENTDATE') THEN
487: --{
488: OKI_DBI_UTIL_PVT.process_parameters (p_param => p_param
489: , p_view_by => l_view_by
490: , p_view_by_col_name => l_view_by_col
491: , p_comparison_type => l_comparison_type
492: , p_xtd => l_xtd1

Line 520: OKI_DBI_UTIL_PVT.process_parameters (p_param => p_param

516: , p_alias_name => 'sgo_amt'
517: , p_grand_total => 'N'
518: , p_to_date_type => 'XTD');
519:
520: OKI_DBI_UTIL_PVT.process_parameters (p_param => p_param
521: , p_view_by => l_view_by
522: , p_view_by_col_name => l_view_by_col
523: , p_comparison_type => l_comparison_type
524: , p_xtd => l_xtd2

Line 580: OKI_DBI_UTIL_PVT.process_parameters (p_param => p_param

576: p_filter_where => NULL);
577: --}
578: ELSE
579: --{
580: OKI_DBI_UTIL_PVT.process_parameters (p_param => p_param
581: , p_view_by => l_view_by
582: , p_view_by_col_name => l_view_by_col
583: , p_comparison_type => l_comparison_type
584: , p_xtd => l_xtd

Line 627: OKI_DBI_UTIL_PVT.get_custom_trend_binds (l_xtd

623: END IF;
624:
625: x_custom_sql := l_query;
626:
627: OKI_DBI_UTIL_PVT.get_custom_trend_binds (l_xtd
628: , l_comparison_type
629: , x_custom_output);
630:
631: END get_activations_trend_sql ;

Line 656: ' ,'||OKI_DBI_UTIL_PVT.change_clause('(nvl(uset.c_sro_amt,0)+nvl(uset.c_sgo_amt,0)+nvl(uset.c_glr_amt,0)+

652: l_sel_clause :=
653: 'Select cal_NAME AS VIEWBY '||
654: ' , nvl(uset.c_sro_amt,0)+nvl(uset.c_sgo_amt,0)+nvl(uset.c_glr_amt,0)+nvl(uset.c_gls_amt,0) OKI_MEASURE_1 '||
655: ' , nvl(uset.p_sro_amt,0)+nvl(uset.p_sgo_amt,0)+nvl(uset.p_glr_amt,0)+nvl(uset.p_gls_amt,0) OKI_PMEASURE_1 '||
656: ' ,'||OKI_DBI_UTIL_PVT.change_clause('(nvl(uset.c_sro_amt,0)+nvl(uset.c_sgo_amt,0)+nvl(uset.c_glr_amt,0)+
657: nvl(uset.c_gls_amt,0))','(nvl(uset.p_sro_amt,0)+nvl(uset.p_sgo_amt,0)+
658: nvl(uset.p_glr_amt,0)+
659: nvl(uset.p_gls_amt,0))', 'NP' ) || ' OKI_CHANGE_1 ';
660: ELSE

Line 666: ' ,'||OKI_DBI_UTIL_PVT.change_clause('(nvl(iset.c_sro_amt,0)+nvl(iset.c_sgo_amt,0))','(nvl(iset.p_sro_amt,0)+nvl(iset.p_sgo_amt,0))', 'NP' ) || ' OKI_CHANGE_1 ';

662: l_sel_clause :=
663: 'Select cal.NAME AS VIEWBY '||
664: ' , nvl(iset.c_sro_amt,0)+nvl(iset.c_sgo_amt,0) OKI_MEASURE_1 '||
665: ' , nvl(iset.p_sro_amt,0)+nvl(iset.p_sgo_amt,0) OKI_PMEASURE_1 '||
666: ' ,'||OKI_DBI_UTIL_PVT.change_clause('(nvl(iset.c_sro_amt,0)+nvl(iset.c_sgo_amt,0))','(nvl(iset.p_sro_amt,0)+nvl(iset.p_sgo_amt,0))', 'NP' ) || ' OKI_CHANGE_1 ';
667: --}
668: END IF;
669:
670: /* ' ,'|| OKI_DBI_UTIL_PVT.add_measures('iset.c_sro_amt','iset.c_sgo_amt') ||' OKI_MEASURE_1 '||

Line 670: /* ' ,'|| OKI_DBI_UTIL_PVT.add_measures('iset.c_sro_amt','iset.c_sgo_amt') ||' OKI_MEASURE_1 '||

666: ' ,'||OKI_DBI_UTIL_PVT.change_clause('(nvl(iset.c_sro_amt,0)+nvl(iset.c_sgo_amt,0))','(nvl(iset.p_sro_amt,0)+nvl(iset.p_sgo_amt,0))', 'NP' ) || ' OKI_CHANGE_1 ';
667: --}
668: END IF;
669:
670: /* ' ,'|| OKI_DBI_UTIL_PVT.add_measures('iset.c_sro_amt','iset.c_sgo_amt') ||' OKI_MEASURE_1 '||
671: ' ,'|| OKI_DBI_UTIL_PVT.add_measures('iset.p_sro_amt','iset.p_sgo_amt') ||' OKI_PMEASURE_1 '||
672: ' ,'||OKI_DBI_UTIL_PVT.change_clause((OKI_DBI_UTIL_PVT.add_measures('iset.c_sro_amt','iset.c_sgo_amt')), (OKI_DBI_UTIL_PVT.add_measures('iset.p_sro_amt','iset.p_sgo_amt')),'NP') || ' OKI_CHANGE_1 '; */
673:
674: RETURN l_sel_clause;

Line 671: ' ,'|| OKI_DBI_UTIL_PVT.add_measures('iset.p_sro_amt','iset.p_sgo_amt') ||' OKI_PMEASURE_1 '||

667: --}
668: END IF;
669:
670: /* ' ,'|| OKI_DBI_UTIL_PVT.add_measures('iset.c_sro_amt','iset.c_sgo_amt') ||' OKI_MEASURE_1 '||
671: ' ,'|| OKI_DBI_UTIL_PVT.add_measures('iset.p_sro_amt','iset.p_sgo_amt') ||' OKI_PMEASURE_1 '||
672: ' ,'||OKI_DBI_UTIL_PVT.change_clause((OKI_DBI_UTIL_PVT.add_measures('iset.c_sro_amt','iset.c_sgo_amt')), (OKI_DBI_UTIL_PVT.add_measures('iset.p_sro_amt','iset.p_sgo_amt')),'NP') || ' OKI_CHANGE_1 '; */
673:
674: RETURN l_sel_clause;
675: END get_act_trend_sel_clause;

Line 672: ' ,'||OKI_DBI_UTIL_PVT.change_clause((OKI_DBI_UTIL_PVT.add_measures('iset.c_sro_amt','iset.c_sgo_amt')), (OKI_DBI_UTIL_PVT.add_measures('iset.p_sro_amt','iset.p_sgo_amt')),'NP') || ' OKI_CHANGE_1 '; */

668: END IF;
669:
670: /* ' ,'|| OKI_DBI_UTIL_PVT.add_measures('iset.c_sro_amt','iset.c_sgo_amt') ||' OKI_MEASURE_1 '||
671: ' ,'|| OKI_DBI_UTIL_PVT.add_measures('iset.p_sro_amt','iset.p_sgo_amt') ||' OKI_PMEASURE_1 '||
672: ' ,'||OKI_DBI_UTIL_PVT.change_clause((OKI_DBI_UTIL_PVT.add_measures('iset.c_sro_amt','iset.c_sgo_amt')), (OKI_DBI_UTIL_PVT.add_measures('iset.p_sro_amt','iset.p_sgo_amt')),'NP') || ' OKI_CHANGE_1 '; */
673:
674: RETURN l_sel_clause;
675: END get_act_trend_sel_clause;
676: /******************************************************************

Line 714: OKI_DBI_UTIL_PVT.process_parameters ( p_param => p_param

710:
711: l_comparison_type := 'Y';
712: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl ();
713: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl ();
714: OKI_DBI_UTIL_PVT.process_parameters ( p_param => p_param
715: , p_view_by => l_view_by
716: , p_view_by_col_name => l_view_by_col
717: , p_comparison_type => l_comparison_type
718: , p_xtd => l_xtd

Line 748: OKI_DBI_UTIL_PVT.join_rpt_where (p_join_tbl => l_join_tbl

744: , p_prior_code => poa_dbi_util_pkg.no_priors);
745:
746: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl ();
747:
748: OKI_DBI_UTIL_PVT.join_rpt_where (p_join_tbl => l_join_tbl
749: , p_func_area => 'SRM'
750: , p_version => '6.0'
751: , p_role => NULL
752: , p_mv_set => 'SRM_CDTL_RPT');

Line 761: l_status_id := NVL(OKI_DBI_UTIL_PVT.get_param_id(p_param,'OKI_STATUS+ACT_TYPE'),'''All''');

757: l_additional_mv := ' ) fact
758: , OKI_SCM_OCR_MV k
759: WHERE fact.chr_id = k.chr_id) ';
760:
761: l_status_id := NVL(OKI_DBI_UTIL_PVT.get_param_id(p_param,'OKI_STATUS+ACT_TYPE'),'''All''');
762:
763: if (l_status_id = '''All''' or l_status_id = '''ALL''' or l_status_id is NULL) THEN
764: l_where_clause := l_where_clause ||' ';
765: elsif (l_status_id = '''1''') THEN

Line 785: OKI_DBI_UTIL_PVT.get_custom_status_binds (x_custom_output);

781: , p_group_by => l_group_by
782: , p_from_clause => ' from '||l_mv ||' fact ');
783: x_custom_sql := l_query;
784:
785: OKI_DBI_UTIL_PVT.get_custom_status_binds (x_custom_output);
786:
787: END get_activations_detail_sql ;
788:
789: /*********************************************************************