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

Line 96: OKI_DBI_UTIL_PVT.Process_Parameters (p_param => p_param

92: l_col_tbl2 := POA_DBI_UTIL_PKG.Poa_Dbi_Col_Tbl ();
93: l_mv_tbl := poa_dbi_util_pkg.poa_dbi_mv_tbl ();
94: l_ytd_sel_clause := '';
95:
96: OKI_DBI_UTIL_PVT.Process_Parameters (p_param => p_param
97: , p_view_by => l_view_by
98: , p_view_by_col_name => l_view_by_col
99: , p_comparison_type => l_comparison_type
100: , p_xtd => l_xtd1

Line 147: OKI_DBI_UTIL_PVT.Process_Parameters (p_param => p_param

143: , p_to_date_type => l_to_date_xed);
144:
145:
146:
147: OKI_DBI_UTIL_PVT.Process_Parameters (p_param => p_param
148: , p_view_by => l_view_by
149: , p_view_by_col_name => l_view_by_col
150: , p_comparison_type => l_comparison_type
151: , p_xtd => l_xtd1

Line 223: oki_dbi_util_pvt.get_custom_status_binds (x_custom_output);

219:
220:
221:
222: x_custom_sql := '/* New OKI_DBI_SRM_PRNWL_SUM_RPT */' || l_query;
223: oki_dbi_util_pvt.get_custom_status_binds (x_custom_output);
224:
225: END get_table_sql;
226:
227: /*

Line 252: l_viewby_select := oki_dbi_util_pvt.get_viewby_select_clause(p_view_by_dim, 'SRM', '6.0');

248:
249: BEGIN
250:
251:
252: l_viewby_select := oki_dbi_util_pvt.get_viewby_select_clause(p_view_by_dim, 'SRM', '6.0');
253:
254: -- Bookings URL when view by is Salesrep
255:
256: l_bookings_url := '''pFunctionName=OKI_DBI_SRM_PRNWL_BKING_RPT&VIEW_BY_NAME=VIEW_BY_ID&pParamIds=Y&VIEW_BY='||p_view_by_dim||'''';

Line 485: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset15.c_rnwl_Rate','oset15.p_rnwl_Rate','P') || ' rnwl_rate_chg '||

481: ' , oset15.c_rnwl_Rate c_rnwl_rate '||
482:
483: ' , oset15.p_rnwl_Rate p_rnwl_rate '||
484:
485: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset15.c_rnwl_Rate','oset15.p_rnwl_Rate','P') || ' rnwl_rate_chg '||
486:
487: ' , oset15.CScr Can '||
488:
489: ' , oset15.c_Upl c_Upl '||

Line 493: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset15.c_Upl','oset15.p_Upl','NP') || ' Upl_chg '||

489: ' , oset15.c_Upl c_Upl '||
490:
491: ' , oset15.p_Upl P_Upl '||
492:
493: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset15.c_Upl','oset15.p_Upl','NP') || ' Upl_chg '||
494:
495:
496: ' , oset15.c_Scr_tot C_Rnw_tot '||
497:

Line 509: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset15.c_rnwl_Rate_tot','oset15.p_rnwl_Rate_tot','P') || ' rnwl_rate_chg_tot '||

505:
506: ' , oset15.p_rnwl_Rate_tot P_rnwl_rate_tot '||
507:
508:
509: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset15.c_rnwl_Rate_tot','oset15.p_rnwl_Rate_tot','P') || ' rnwl_rate_chg_tot '||
510:
511: ' , oset15.CScr_tot Can_tot '||
512:
513: ' , oset15.c_Upl_tot C_Upl_tot '||

Line 517: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset15.c_Upl_tot','oset15.p_Upl_tot','NP') || ' Upl_chg_tot '||

513: ' , oset15.c_Upl_tot C_Upl_tot '||
514:
515: ' , oset15.p_Upl_tot P_Upl_tot '||
516:
517: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset15.c_Upl_tot','oset15.p_Upl_tot','NP') || ' Upl_chg_tot '||
518:
519: ' from '||
520:
521: ' (select '||

Line 565: ' ,'|| OKI_DBI_UTIL_PVT.subtract_measures('oset13.c_ScGpGr','oset13.c_ScGpGo') ||' c_Upl '||

561:
562: ' , oset13.CScr_tot '||
563:
564:
565: ' ,'|| OKI_DBI_UTIL_PVT.subtract_measures('oset13.c_ScGpGr','oset13.c_ScGpGo') ||' c_Upl '||
566:
567: ' ,'|| OKI_DBI_UTIL_PVT.subtract_measures('oset13.p_ScGpGr','oset13.p_ScGpGo') ||' p_Upl '||
568:
569: ' ,'|| OKI_DBI_UTIL_PVT.subtract_measures('oset13.c_ScGpGr_tot','oset13.c_ScGpGo_tot') ||' c_Upl_tot '||

Line 567: ' ,'|| OKI_DBI_UTIL_PVT.subtract_measures('oset13.p_ScGpGr','oset13.p_ScGpGo') ||' p_Upl '||

563:
564:
565: ' ,'|| OKI_DBI_UTIL_PVT.subtract_measures('oset13.c_ScGpGr','oset13.c_ScGpGo') ||' c_Upl '||
566:
567: ' ,'|| OKI_DBI_UTIL_PVT.subtract_measures('oset13.p_ScGpGr','oset13.p_ScGpGo') ||' p_Upl '||
568:
569: ' ,'|| OKI_DBI_UTIL_PVT.subtract_measures('oset13.c_ScGpGr_tot','oset13.c_ScGpGo_tot') ||' c_Upl_tot '||
570:
571: ' ,'|| OKI_DBI_UTIL_PVT.subtract_measures('oset13.p_ScGpGr_tot','oset13.p_ScGpGo_tot') ||' p_Upl_tot '||

Line 569: ' ,'|| OKI_DBI_UTIL_PVT.subtract_measures('oset13.c_ScGpGr_tot','oset13.c_ScGpGo_tot') ||' c_Upl_tot '||

565: ' ,'|| OKI_DBI_UTIL_PVT.subtract_measures('oset13.c_ScGpGr','oset13.c_ScGpGo') ||' c_Upl '||
566:
567: ' ,'|| OKI_DBI_UTIL_PVT.subtract_measures('oset13.p_ScGpGr','oset13.p_ScGpGo') ||' p_Upl '||
568:
569: ' ,'|| OKI_DBI_UTIL_PVT.subtract_measures('oset13.c_ScGpGr_tot','oset13.c_ScGpGo_tot') ||' c_Upl_tot '||
570:
571: ' ,'|| OKI_DBI_UTIL_PVT.subtract_measures('oset13.p_ScGpGr_tot','oset13.p_ScGpGo_tot') ||' p_Upl_tot '||
572:
573: ' from '||

Line 571: ' ,'|| OKI_DBI_UTIL_PVT.subtract_measures('oset13.p_ScGpGr_tot','oset13.p_ScGpGo_tot') ||' p_Upl_tot '||

567: ' ,'|| OKI_DBI_UTIL_PVT.subtract_measures('oset13.p_ScGpGr','oset13.p_ScGpGo') ||' p_Upl '||
568:
569: ' ,'|| OKI_DBI_UTIL_PVT.subtract_measures('oset13.c_ScGpGr_tot','oset13.c_ScGpGo_tot') ||' c_Upl_tot '||
570:
571: ' ,'|| OKI_DBI_UTIL_PVT.subtract_measures('oset13.p_ScGpGr_tot','oset13.p_ScGpGo_tot') ||' p_Upl_tot '||
572:
573: ' from '||
574:
575: ' (select '||

Line 586: ' ,'|| OKI_DBI_UTIL_PVT.add_measures('oset10.c_ScGpr','oset10.c_ScGr') ||' c_ScGpGr '||

582: ' , oset10.c_Scr c_Scr '||
583:
584: ' , oset10.p_Scr p_Scr '||
585:
586: ' ,'|| OKI_DBI_UTIL_PVT.add_measures('oset10.c_ScGpr','oset10.c_ScGr') ||' c_ScGpGr '||
587:
588: ' ,'|| OKI_DBI_UTIL_PVT.add_measures('oset10.c_ScGpo','oset10.c_ScGo') ||' c_ScGpGo '||
589:
590: ' ,'|| OKI_DBI_UTIL_PVT.add_measures('oset10.p_ScGpr','oset10.p_ScGr') ||' p_ScGpGr '||

Line 588: ' ,'|| OKI_DBI_UTIL_PVT.add_measures('oset10.c_ScGpo','oset10.c_ScGo') ||' c_ScGpGo '||

584: ' , oset10.p_Scr p_Scr '||
585:
586: ' ,'|| OKI_DBI_UTIL_PVT.add_measures('oset10.c_ScGpr','oset10.c_ScGr') ||' c_ScGpGr '||
587:
588: ' ,'|| OKI_DBI_UTIL_PVT.add_measures('oset10.c_ScGpo','oset10.c_ScGo') ||' c_ScGpGo '||
589:
590: ' ,'|| OKI_DBI_UTIL_PVT.add_measures('oset10.p_ScGpr','oset10.p_ScGr') ||' p_ScGpGr '||
591:
592:

Line 590: ' ,'|| OKI_DBI_UTIL_PVT.add_measures('oset10.p_ScGpr','oset10.p_ScGr') ||' p_ScGpGr '||

586: ' ,'|| OKI_DBI_UTIL_PVT.add_measures('oset10.c_ScGpr','oset10.c_ScGr') ||' c_ScGpGr '||
587:
588: ' ,'|| OKI_DBI_UTIL_PVT.add_measures('oset10.c_ScGpo','oset10.c_ScGo') ||' c_ScGpGo '||
589:
590: ' ,'|| OKI_DBI_UTIL_PVT.add_measures('oset10.p_ScGpr','oset10.p_ScGr') ||' p_ScGpGr '||
591:
592:
593: ' ,'|| OKI_DBI_UTIL_PVT.add_measures('oset10.p_ScGpo','oset10.p_ScGo') ||' p_ScGpGo '||
594:

Line 593: ' ,'|| OKI_DBI_UTIL_PVT.add_measures('oset10.p_ScGpo','oset10.p_ScGo') ||' p_ScGpGo '||

589:
590: ' ,'|| OKI_DBI_UTIL_PVT.add_measures('oset10.p_ScGpr','oset10.p_ScGr') ||' p_ScGpGr '||
591:
592:
593: ' ,'|| OKI_DBI_UTIL_PVT.add_measures('oset10.p_ScGpo','oset10.p_ScGo') ||' p_ScGpGo '||
594:
595: ' , oset10.c_CScr CScr '||
596:
597: ' , oset10.c_Scr_tot c_Scr_tot '||

Line 601: ' ,'|| OKI_DBI_UTIL_PVT.add_measures('oset10.c_ScGpr_tot','oset10.c_ScGr_tot') ||' c_ScGpGr_tot '||

597: ' , oset10.c_Scr_tot c_Scr_tot '||
598:
599: ' , oset10.p_Scr_tot p_Scr_tot '||
600:
601: ' ,'|| OKI_DBI_UTIL_PVT.add_measures('oset10.c_ScGpr_tot','oset10.c_ScGr_tot') ||' c_ScGpGr_tot '||
602:
603: ' ,'|| OKI_DBI_UTIL_PVT.add_measures('oset10.c_ScGpo_tot','oset10.c_ScGo_tot') ||' c_ScGpGo_tot '||
604:
605: ' ,'|| OKI_DBI_UTIL_PVT.add_measures('oset10.p_ScGpr_tot','oset10.p_ScGr_tot') ||' p_ScGpGr_tot '||

Line 603: ' ,'|| OKI_DBI_UTIL_PVT.add_measures('oset10.c_ScGpo_tot','oset10.c_ScGo_tot') ||' c_ScGpGo_tot '||

599: ' , oset10.p_Scr_tot p_Scr_tot '||
600:
601: ' ,'|| OKI_DBI_UTIL_PVT.add_measures('oset10.c_ScGpr_tot','oset10.c_ScGr_tot') ||' c_ScGpGr_tot '||
602:
603: ' ,'|| OKI_DBI_UTIL_PVT.add_measures('oset10.c_ScGpo_tot','oset10.c_ScGo_tot') ||' c_ScGpGo_tot '||
604:
605: ' ,'|| OKI_DBI_UTIL_PVT.add_measures('oset10.p_ScGpr_tot','oset10.p_ScGr_tot') ||' p_ScGpGr_tot '||
606:
607:

Line 605: ' ,'|| OKI_DBI_UTIL_PVT.add_measures('oset10.p_ScGpr_tot','oset10.p_ScGr_tot') ||' p_ScGpGr_tot '||

601: ' ,'|| OKI_DBI_UTIL_PVT.add_measures('oset10.c_ScGpr_tot','oset10.c_ScGr_tot') ||' c_ScGpGr_tot '||
602:
603: ' ,'|| OKI_DBI_UTIL_PVT.add_measures('oset10.c_ScGpo_tot','oset10.c_ScGo_tot') ||' c_ScGpGo_tot '||
604:
605: ' ,'|| OKI_DBI_UTIL_PVT.add_measures('oset10.p_ScGpr_tot','oset10.p_ScGr_tot') ||' p_ScGpGr_tot '||
606:
607:
608: ' ,'|| OKI_DBI_UTIL_PVT.add_measures('oset10.p_ScGpo_tot','oset10.p_ScGo_tot') ||' p_ScGpGo_tot '||
609:

Line 608: ' ,'|| OKI_DBI_UTIL_PVT.add_measures('oset10.p_ScGpo_tot','oset10.p_ScGo_tot') ||' p_ScGpGo_tot '||

604:
605: ' ,'|| OKI_DBI_UTIL_PVT.add_measures('oset10.p_ScGpr_tot','oset10.p_ScGr_tot') ||' p_ScGpGr_tot '||
606:
607:
608: ' ,'|| OKI_DBI_UTIL_PVT.add_measures('oset10.p_ScGpo_tot','oset10.p_ScGo_tot') ||' p_ScGpGo_tot '||
609:
610: ' , oset10.c_CScr_tot CScr_tot '||
611:
612: ' from '||

Line 719: oki_dbi_util_pvt.process_parameters ( p_param => p_param

715: l_comparison_type := 'Y';
716: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl ();
717: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl ();
718:
719: oki_dbi_util_pvt.process_parameters ( p_param => p_param
720: , p_view_by => l_view_by
721: , p_view_by_col_name => l_view_by_col
722: , p_comparison_type => l_comparison_type
723: , p_xtd => l_xtd

Line 754: oki_dbi_util_pvt.join_rpt_where (p_join_tbl => l_join_tbl

750: , p_prior_code => poa_dbi_util_pkg.no_priors);
751:
752: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl ();
753:
754: oki_dbi_util_pvt.join_rpt_where (p_join_tbl => l_join_tbl
755: , p_func_area => 'SRM'
756: , p_version => '6.0'
757: , p_role => NULL
758: , p_mv_set => 'SRM_CDTL_RPT');

Line 782: oki_dbi_util_pvt.get_custom_status_binds (x_custom_output);

778: x_custom_sql := '/* OKI_DBI_SRM_PRNWL_BKING_RPT */' || l_query;
779:
780:
781:
782: oki_dbi_util_pvt.get_custom_status_binds (x_custom_output);
783:
784: END get_bookings_sql;
785:
786:

Line 899: oki_dbi_util_pvt.get_custom_status_binds (x_custom_output);

895:
896:
897: x_custom_sql := '/* OKI_DBI_SRM_PRNWL_SUM_CRPT */' || l_query;
898:
899: oki_dbi_util_pvt.get_custom_status_binds (x_custom_output);
900:
901: END get_bkngs_by_cust_sql;
902: /*******************************************************************************
903: * FUNCTION get_bkngs_by_cust_sql () returns the select clause containing

Line 965: oki_dbi_util_pvt.process_parameters ( p_param => p_param

961: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl ();
962: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl ();
963:
964:
965: oki_dbi_util_pvt.process_parameters ( p_param => p_param
966:
967: , p_view_by => l_view_by
968: , p_view_by_col_name => l_view_by_col
969: , p_comparison_type => l_comparison_type

Line 988: l_view_by_table := oki_dbi_util_pvt.get_table(dim_name => l_view_by

984: , p_mv_set => 'SRM_DET'
985: , p_rg_where => 'Y');
986:
987:
988: l_view_by_table := oki_dbi_util_pvt.get_table(dim_name => l_view_by
989: ,p_func_area => 'SRM'
990: ,p_version => '6.0' );
991: IF(l_view_by = 'ITEM+ENI_ITEM_VBH_CAT')
992: THEN

Line 1002: l_viewby_select := oki_dbi_util_pvt.get_viewby_select_clause(l_view_by, 'SRM', '6.0');

998: ELSE
999: l_prodcat_url := ''''' OKI_DYNAMIC_URL_2 ';
1000: END IF;
1001:
1002: l_viewby_select := oki_dbi_util_pvt.get_viewby_select_clause(l_view_by, 'SRM', '6.0');
1003:
1004:
1005: /* Additional filter needed to avoid displaying records queried due to total values at node */
1006:

Line 1139: oki_dbi_util_pvt.get_custom_status_binds (x_custom_output);

1135: NVL(SUM(COUNT(distinct(case when date_signed <= &BIS_CURRENT_ASOF_DATE then fact.chr_id else null end))) over(),0) booked_hcount_tot,
1136: NVL(SUM(COUNT(distinct(case when date_signed <= &BIS_CURRENT_ASOF_DATE then fact.cle_id else null end))) over(),0) booked_lcount_tot '||
1137: l_FROM_WHERE || l_VIEWBY_RANK_ORDER ;
1138: x_custom_sql := '/* OKI_DBI_SRM_PRNWL_RATE_DRPT */ ' || l_query;
1139: oki_dbi_util_pvt.get_custom_status_binds (x_custom_output);
1140:
1141: END get_rrate_sql;
1142:
1143:

Line 1202: oki_dbi_util_pvt.process_parameters (p_param => p_param

1198: l_col_tbl2 := poa_dbi_util_pkg.poa_dbi_col_tbl ();
1199:
1200: l_mv_tbl := poa_dbi_util_pkg.poa_dbi_mv_tbl ();
1201:
1202: oki_dbi_util_pvt.process_parameters (p_param => p_param
1203: , p_view_by => l_view_by
1204: , p_view_by_col_name => l_view_by_col
1205: , p_comparison_type => l_comparison_type
1206: , p_xtd => l_xtd1

Line 1238: oki_dbi_util_pvt.process_parameters (p_param => p_param

1234: , p_alias_name => 's_gpo_amt_xed'
1235: , p_grand_total => 'N'
1236: , p_to_date_type => 'XED');
1237:
1238: oki_dbi_util_pvt.process_parameters (p_param => p_param
1239: , p_view_by => l_view_by
1240: , p_view_by_col_name => l_view_by_col
1241: , p_comparison_type => l_comparison_type
1242: , p_xtd => l_xtd2

Line 1300: oki_dbi_util_pvt.get_custom_trend_binds (l_xtd1

1296: p_filter_where => NULL);
1297:
1298:
1299: x_custom_sql := '/* OKI_DBI_SRM_PR_G */ ' || l_query;
1300: oki_dbi_util_pvt.get_custom_trend_binds (l_xtd1
1301: , l_comparison_type
1302: , x_custom_output);
1303:
1304: /* DEBUG

Line 1332: ,('||oki_dbi_util_pvt.add_measures('iset.c_s_gpr_amt_xed','iset.c_g_scr_amt_xtd') || '

1328: -- OKI_MEASURE_8 : Change Uplift
1329: -- OKI_MEASURE_10 : prior Uplift value
1330:
1331: /*-------------
1332: ,('||oki_dbi_util_pvt.add_measures('iset.c_s_gpr_amt_xed','iset.c_g_scr_amt_xtd') || '
1333: /decode(iset.c_s_r_amt_xed,0,NULL,iset.c_s_r_amt_xed)*100) -
1334: ('||oki_dbi_util_pvt.add_measures('iset.p_s_gpr_amt_xed','iset.p_g_scr_amt_xtd') || '
1335: /decode(iset.p_s_r_amt_xed,0,NULL,iset.p_s_r_amt_xed)*100) OKI_MEASURE_6
1336: */

Line 1334: ('||oki_dbi_util_pvt.add_measures('iset.p_s_gpr_amt_xed','iset.p_g_scr_amt_xtd') || '

1330:
1331: /*-------------
1332: ,('||oki_dbi_util_pvt.add_measures('iset.c_s_gpr_amt_xed','iset.c_g_scr_amt_xtd') || '
1333: /decode(iset.c_s_r_amt_xed,0,NULL,iset.c_s_r_amt_xed)*100) -
1334: ('||oki_dbi_util_pvt.add_measures('iset.p_s_gpr_amt_xed','iset.p_g_scr_amt_xtd') || '
1335: /decode(iset.p_s_r_amt_xed,0,NULL,iset.p_s_r_amt_xed)*100) OKI_MEASURE_6
1336: */
1337:
1338: l_sel_clause :=