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

Line 72: oki_dbi_util_pvt.process_parameters ( p_param => p_param

68: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl ();
69: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl ();
70:
71:
72: oki_dbi_util_pvt.process_parameters ( p_param => p_param
73: , p_view_by => l_view_by
74: , p_view_by_col_name => l_view_by_col
75: , p_comparison_type => l_comparison_type
76: , p_xtd => l_xtd

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

88: , p_role => NULL
89: , p_mv_set => 'SRM_DET'
90: , p_rg_where => 'Y');
91:
92: l_view_by_table := oki_dbi_util_pvt.get_table(dim_name => l_view_by
93: ,p_func_area => 'SRM'
94: ,p_version => '6.0' );
95:
96: IF(l_view_by = 'ITEM+ENI_ITEM_VBH_CAT')

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

102: ELSE
103: l_prodcat_url := ''''' OKI_DYNAMIC_URL_4 ';
104: END IF;
105:
106: l_viewby_select := oki_dbi_util_pvt.get_viewby_select_clause(l_view_by, 'SRM', '6.0');
107:
108:
109: /* Additional filter needed to avoid displaying records queried due to total values at node */
110:

Line 259: oki_dbi_util_pvt.get_custom_status_binds (x_custom_output);

255: l_cur_suffix )
256: || l_VIEWBY_RANK_ORDER;
257:
258: x_custom_sql := '/* OKI_DBI_SRM_BTS_RATE_DRPT */'||l_query;
259: oki_dbi_util_pvt.get_custom_status_binds (x_custom_output);
260:
261: END get_rates_table_sql;
262: -----------------------------------------------------------
263:

Line 328: l_query := oki_dbi_util_pvt.two_way_join (l_select, l_query1, l_query2,l_join_column1, l_join_column1);

324:
325: l_join_column1 := l_view_by_col;
326: l_join_column2 := l_view_by_col;
327:
328: l_query := oki_dbi_util_pvt.two_way_join (l_select, l_query1, l_query2,l_join_column1, l_join_column1);
329: RETURN l_query;
330:
331: END get_book_start_2way_sql;
332:

Line 385: oki_dbi_util_pvt.process_parameters (p_param => p_param

381: l_col_tbl1 := poa_dbi_util_pkg.poa_dbi_col_tbl ();
382: l_col_tbl2 := poa_dbi_util_pkg.poa_dbi_col_tbl ();
383: l_mv_tbl := poa_dbi_util_pkg.poa_dbi_mv_tbl ();
384:
385: oki_dbi_util_pvt.process_parameters (p_param => p_param
386: , p_view_by => l_view_by
387: , p_view_by_col_name => l_view_by_col
388: , p_comparison_type => l_comparison_type
389: , p_xtd => l_xtd1

Line 416: oki_dbi_util_pvt.process_parameters (p_param => p_param

412: l_mv_tbl(1).mv_where := l_where_clause;
413: l_mv_tbl(1).in_join_tbls := NULL;
414: l_mv_tbl(1).use_grp_id := 'N';
415:
416: oki_dbi_util_pvt.process_parameters (p_param => p_param
417: , p_view_by => l_view_by
418: , p_view_by_col_name => l_view_by_col
419: , p_comparison_type => l_comparison_type
420: , p_xtd => l_xtd2

Line 505: oki_dbi_util_pvt.get_custom_status_binds(x_custom_output);

501: , p_use_grpid => 'N'
502: , p_paren_count => 6);
503: */
504: x_custom_sql := '/* OKI_DBI_SRM_BTS_RATIO_RPT */' || l_query;
505: oki_dbi_util_pvt.get_custom_status_binds(x_custom_output);
506: /* DEBUG - brrao added */
507: -- OKI_DBIDEBUG_PVT.check_portal_value('OKI_DBI_SRM_KAPILT','SQL',x_custom_sql);
508: -- COMMIT;
509:

Line 558: oki_dbi_util_pvt.process_parameters ( p_param => p_param

554: l_col_tbl2 := poa_dbi_util_pkg.poa_dbi_col_tbl ();
555:
556: l_mv_tbl := poa_dbi_util_pkg.poa_dbi_mv_tbl ();
557:
558: oki_dbi_util_pvt.process_parameters ( p_param => p_param
559: , p_view_by => l_view_by
560: , p_view_by_col_name => l_view_by_col
561: , p_comparison_type => l_comparison_type
562: , p_xtd => l_xtd1

Line 595: oki_dbi_util_pvt.process_parameters ( p_param => p_param

591: l_mv_tbl(1).in_join_tbls := NULL;
592: l_mv_tbl(1).use_grp_id := 'N';
593: l_mv_tbl(1).mv_xtd := l_xtd1;
594:
595: oki_dbi_util_pvt.process_parameters ( p_param => p_param
596: , p_view_by => l_view_by
597: , p_view_by_col_name => l_view_by_col
598: , p_comparison_type => l_comparison_type
599: , p_xtd => l_xtd2

Line 647: oki_dbi_util_pvt.get_custom_trend_binds (l_xtd1

643: , l_prev_as_of_date
644: , l_nested_pattern);*/
645: x_custom_sql := '/* OKI_DBI_SRM_BTS_RATIO_G */'||l_query;
646: -- x_custom_sql := 'select 1 VIEWBY, 1 OKI_MEASURE_1, 2 OKI_MEASURE_2, 2 OKI_MEASURE_3 from dual';
647: oki_dbi_util_pvt.get_custom_trend_binds (l_xtd1
648: , l_comparison_type
649: , x_custom_output);
650:
651: END get_trend_sql;

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

699: l_viewby_select VARCHAR2(10000);
700: l_url_select VARCHAR2(10000);
701: BEGIN
702:
703: l_viewby_select := oki_dbi_util_pvt.get_viewby_select_clause(p_view_by_dim, 'SRM', '6.0');
704: l_bookings_url := '''pFunctionName=OKI_DBI_SRM_RSBK_DTL_DRPT&VIEW_BY_NAME=VIEW_BY_ID&pParamIds=Y&VIEW_BY=ORGANIZATION+JTF_ORG_SALES_GROUP''';
705:
706: -- l_rate_url := '''pFunctionName=OKI_DBI_SRM_BTS_RATE_DRPT&VIEW_BY_NAME=VIEW_BY_ID&pParamIds=Y&VIEW_BY=ORGANIZATION+JTF_ORG_SALES_GROUP''';
707:

Line 815: ,'||OKI_DBI_UTIL_PVT.change_clause('oset10.c_rnwl_Rate',

811: , oset10.c_rnwl_booked rnwl_booked
812: , oset10.c_rnwl_started rnwl_started
813: , oset10.c_rnwl_rate c_rnwl_rate
814: , oset10.p_rnwl_rate p_rnwl_rate
815: ,'||OKI_DBI_UTIL_PVT.change_clause('oset10.c_rnwl_Rate',
816: 'oset10.p_rnwl_Rate','P') || 'rnwl_rate_chg
817: , oset10.c_rnwl_booked_tot rnwl_booked_tot
818: , oset10.c_rnwl_started_tot rnwl_started_tot
819: , oset10.c_rnwl_Rate_total rnwl_rate_tot

Line 821: ,'||OKI_DBI_UTIL_PVT.change_clause('oset10.c_rnwl_Rate_total',

817: , oset10.c_rnwl_booked_tot rnwl_booked_tot
818: , oset10.c_rnwl_started_tot rnwl_started_tot
819: , oset10.c_rnwl_Rate_total rnwl_rate_tot
820: , oset10.p_rnwl_Rate_total p_rnwl_rate_tot
821: ,'||OKI_DBI_UTIL_PVT.change_clause('oset10.c_rnwl_Rate_total',
822: 'oset10.p_rnwl_Rate_total','P') || 'rnwl_rate_chg_tot
823: FROM
824: (SELECT oset05.' || p_view_by_col || '
825: , nvl(oset05.c_started,0) c_rnwl_started