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_TRM_PVT dependencies on OKI_DBI_UTIL_PVT

Line 40: oki_dbi_util_pvt.process_parameters (

36:
37: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl ();
38: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl();
39:
40: oki_dbi_util_pvt.process_parameters (
41: p_param => p_param,
42: p_view_by => l_view_by,
43: p_view_by_col_name => l_view_by_col,
44: p_comparison_type => l_comparison_type,

Line 102: oki_dbi_util_pvt.get_custom_status_binds (x_custom_output);

98:
99:
100: x_custom_sql := '/* OKI_DBI_SCM_TRM_SUM_RPT */ '||l_query;
101:
102: oki_dbi_util_pvt.get_custom_status_binds (x_custom_output);
103:
104: END get_terminations_sql;
105:
106: /**********************************************************

Line 123: l_viewby_select := OKI_DBI_UTIL_PVT.Get_Viewby_Select_Clause(p_view_by_dim, 'SRM', '7.0');

119:
120: BEGIN
121:
122:
123: l_viewby_select := OKI_DBI_UTIL_PVT.Get_Viewby_Select_Clause(p_view_by_dim, 'SRM', '7.0');
124:
125: -- when view by is Salesrep OKI_DBI_SCM_ACT_DTL_RPT
126:
127: l_terminated_url := '''pFunctionName=OKI_DBI_SCM_TRM_DTL_RPT&VIEW_BY_NAME=VIEW_BY_ID&pParamIds=Y''';

Line 167: ', '||OKI_DBI_UTIL_PVT.Change_Clause('oset20.c_t_rv_pot','oset20.p_t_rv_pot','P')||' OKI_PERCENT_CHANGE_1'||

163: ', oset20.c_t_rv_tot OKI_TKPI_MEASURE_1'||
164: ', oset20.p_t_rv_tot OKI_PTKPI_MEASURE_1'||
165: ', oset20.c_t_rv_pot OKI_PERCENT_1'||
166: ', oset20.c_t_rv_pot_tot OKI_TPERCENT_1'||
167: ', '||OKI_DBI_UTIL_PVT.Change_Clause('oset20.c_t_rv_pot','oset20.p_t_rv_pot','P')||' OKI_PERCENT_CHANGE_1'||
168: ', oset20.c_t_bv OKI_MEASURE_2'||
169: ', oset20.c_t_bv_tot OKI_TMEASURE_2'||
170: ', oset20.c_t_bv OKI_KPI_MEASURE_2'||
171: ', oset20.p_t_bv OKI_PKPI_MEASURE_2'||

Line 181: ', '||OKI_DBI_UTIL_PVT.Change_Clause('oset15.c_t_rv','oset15.p_t_rv','NP') || ' C_T_RV_CHG'||

177: -- Change Calculation
178: ' '||p_view_by_col||
179: ', oset15.c_t_rv C_T_RV'||
180: ', oset15.p_t_rv P_T_RV'||
181: ', '||OKI_DBI_UTIL_PVT.Change_Clause('oset15.c_t_rv','oset15.p_t_rv','NP') || ' C_T_RV_CHG'||
182: ', '||POA_DBI_UTIL_PKG.Rate_Clause('oset15.c_t_rv','oset15.c_t_rv_tot') || ' C_T_RV_POT'||
183: ', '||POA_DBI_UTIL_PKG.Rate_Clause('oset15.p_t_rv','oset15.p_t_rv_tot') || ' P_T_RV_POT'||
184: ', oset15.c_t_rv_tot C_T_RV_TOT'||
185: ', oset15.p_t_rv_tot P_T_RV_TOT'||

Line 186: ', '||OKI_DBI_UTIL_PVT.Change_Clause('oset15.c_t_rv_tot','oset15.p_t_rv_tot','NP') || ' C_T_RV_CHG_TOT'||

182: ', '||POA_DBI_UTIL_PKG.Rate_Clause('oset15.c_t_rv','oset15.c_t_rv_tot') || ' C_T_RV_POT'||
183: ', '||POA_DBI_UTIL_PKG.Rate_Clause('oset15.p_t_rv','oset15.p_t_rv_tot') || ' P_T_RV_POT'||
184: ', oset15.c_t_rv_tot C_T_RV_TOT'||
185: ', oset15.p_t_rv_tot P_T_RV_TOT'||
186: ', '||OKI_DBI_UTIL_PVT.Change_Clause('oset15.c_t_rv_tot','oset15.p_t_rv_tot','NP') || ' C_T_RV_CHG_TOT'||
187: ', '||poa_dbi_util_pkg.Rate_Clause('oset15.c_t_rv_tot','oset15.c_t_rv_tot')||' C_T_RV_POT_TOT'||
188: ', oset15.c_t_bv C_T_BV'||
189: ', oset15.p_t_bv P_T_BV'||
190: ', '||POA_DBI_UTIL_PKG.Rate_Clause('oset15.c_t_rv', (OKI_DBI_UTIL_PVT.add_measures('oset15.c_t_rv','oset15.c_t_bv')))||' C_T_BV_POT'||

Line 190: ', '||POA_DBI_UTIL_PKG.Rate_Clause('oset15.c_t_rv', (OKI_DBI_UTIL_PVT.add_measures('oset15.c_t_rv','oset15.c_t_bv')))||' C_T_BV_POT'||

186: ', '||OKI_DBI_UTIL_PVT.Change_Clause('oset15.c_t_rv_tot','oset15.p_t_rv_tot','NP') || ' C_T_RV_CHG_TOT'||
187: ', '||poa_dbi_util_pkg.Rate_Clause('oset15.c_t_rv_tot','oset15.c_t_rv_tot')||' C_T_RV_POT_TOT'||
188: ', oset15.c_t_bv C_T_BV'||
189: ', oset15.p_t_bv P_T_BV'||
190: ', '||POA_DBI_UTIL_PKG.Rate_Clause('oset15.c_t_rv', (OKI_DBI_UTIL_PVT.add_measures('oset15.c_t_rv','oset15.c_t_bv')))||' C_T_BV_POT'||
191: ', oset15.c_t_bv_tot C_T_BV_TOT'||
192: ', oset15.p_t_bv_tot P_T_BV_TOT'||
193: ', '||POA_DBI_UTIL_PKG.Rate_Clause('oset15.c_t_rv_tot', (OKI_DBI_UTIL_PVT.add_measures('oset15.c_t_rv_tot','oset15.c_t_bv_tot')))||' C_T_BV_POT_TOT'||
194: ' from (select '||

Line 193: ', '||POA_DBI_UTIL_PKG.Rate_Clause('oset15.c_t_rv_tot', (OKI_DBI_UTIL_PVT.add_measures('oset15.c_t_rv_tot','oset15.c_t_bv_tot')))||' C_T_BV_POT_TOT'||

189: ', oset15.p_t_bv P_T_BV'||
190: ', '||POA_DBI_UTIL_PKG.Rate_Clause('oset15.c_t_rv', (OKI_DBI_UTIL_PVT.add_measures('oset15.c_t_rv','oset15.c_t_bv')))||' C_T_BV_POT'||
191: ', oset15.c_t_bv_tot C_T_BV_TOT'||
192: ', oset15.p_t_bv_tot P_T_BV_TOT'||
193: ', '||POA_DBI_UTIL_PKG.Rate_Clause('oset15.c_t_rv_tot', (OKI_DBI_UTIL_PVT.add_measures('oset15.c_t_rv_tot','oset15.c_t_bv_tot')))||' C_T_BV_POT_TOT'||
194: ' from (select '||
195: --marker
196: -- Calculated Measures
197: p_view_by_col ||

Line 315: OKI_DBI_UTIL_PVT.Process_Parameters(

311: l_comparison_type := 'Y';
312: l_join_tbl := POA_DBI_UTIL_PKG.Poa_Dbi_Join_Tbl();
313: l_col_tbl := POA_DBI_UTIL_PKG.Poa_Dbi_Col_Tbl();
314:
315: OKI_DBI_UTIL_PVT.Process_Parameters(
316: p_param => p_param,
317: p_view_by => l_view_by,
318: p_view_by_col_name => l_view_by_col,
319: p_comparison_type => l_comparison_type,

Line 357: oki_dbi_util_pvt.join_rpt_where ( p_join_tbl => l_join_tbl

353: ,p_prior_code => poa_dbi_util_pkg.no_priors);
354:
355: l_join_tbl := POA_DBI_UTIL_PKG.Poa_Dbi_Join_Tbl();
356:
357: oki_dbi_util_pvt.join_rpt_where ( p_join_tbl => l_join_tbl
358: , p_func_area => 'SRM'
359: , p_version => '6.0'
360: , p_role => NULL
361: , p_mv_set => 'SRM_DTL_RPT');

Line 363: oki_dbi_util_pvt.add_join_table (p_join_tbl => l_join_tbl

359: , p_version => '6.0'
360: , p_role => NULL
361: , p_mv_set => 'SRM_DTL_RPT');
362:
363: oki_dbi_util_pvt.add_join_table (p_join_tbl => l_join_tbl
364: , p_column_name => 'id'
365: , p_table_name => 'OKI_TERM_REASONS_V'
366: , p_table_alias => 'v'
367: , p_fact_column => 'trn_code'

Line 389: OKI_DBI_UTIL_PVT.Get_Custom_Status_Binds(x_custom_output);

385: , p_from_clause => ' from '||l_mv ||' fact ');
386:
387: x_custom_sql := '/* OKI_DBI_SCM_TRM_DTL_RPT */ '||l_query;
388:
389: OKI_DBI_UTIL_PVT.Get_Custom_Status_Binds(x_custom_output);
390:
391: END Get_Terminations_Detail_Sql;
392:
393:

Line 429: OKI_DBI_UTIL_PVT.Process_Parameters(

425: l_comparison_type := 'Y';
426: l_join_tbl := POA_DBI_UTIL_PKG.Poa_Dbi_Join_Tbl();
427: l_col_tbl := POA_DBI_UTIL_PKG.Poa_Dbi_Col_Tbl();
428:
429: OKI_DBI_UTIL_PVT.Process_Parameters(
430: p_param => p_param,
431: p_view_by => l_view_by,
432: p_view_by_col_name => l_view_by_col,
433: p_comparison_type => l_comparison_type,

Line 467: OKI_DBI_UTIL_PVT.Get_Custom_Trend_Binds(

463: p_col_name => l_col_tbl,
464: p_use_grpid => 'N');
465:
466: x_custom_sql := '/* OKI_DBI_SCM_TRM_GPH_RPT */ '||l_query;
467: OKI_DBI_UTIL_PVT.Get_Custom_Trend_Binds(
468: l_xtd,
469: l_comparison_type,
470: x_custom_output);
471:

Line 488: '||OKI_DBI_UTIL_PVT.Change_Clause('nvl(iset.c_t_rv,0)','nvl(iset.p_t_rv,0)','NP')||' OKI_CHANGE_1';

484: l_sel_clause := '
485: SELECT cal.name VIEWBY,
486: nvl(iset.c_t_rv,0) OKI_MEASURE_1,
487: nvl(iset.p_t_rv,0) OKI_PMEASURE_1,
488: '||OKI_DBI_UTIL_PVT.Change_Clause('nvl(iset.c_t_rv,0)','nvl(iset.p_t_rv,0)','NP')||' OKI_CHANGE_1';
489:
490: RETURN l_sel_clause;
491: END Get_Trm_Trend_Sel_Clause;
492: