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

Line 148: OKI_DBI_UTIL_PVT.Process_Parameters (p_param => p_param

144: l_col_tbl4 := POA_DBI_UTIL_PKG.Poa_Dbi_Col_Tbl ();
145:
146: l_mv_tbl := poa_dbi_util_pkg.poa_dbi_mv_tbl ();
147:
148: OKI_DBI_UTIL_PVT.Process_Parameters (p_param => p_param
149: , p_view_by => l_view_by
150: , p_view_by_col_name => l_view_by_col
151: , p_comparison_type => l_comparison_type
152: , p_xtd => l_xtd1

Line 175: OKI_DBI_UTIL_PVT.Process_Parameters (p_param => p_param

171: , p_alias_name => 'Br1'
172: , p_grand_total => 'N'
173: , p_to_date_type => l_to_date_ytd);
174:
175: OKI_DBI_UTIL_PVT.Process_Parameters (p_param => p_param
176: , p_view_by => l_view_by
177: , p_view_by_col_name => l_view_by_col
178: , p_comparison_type => l_comparison_type
179: , p_xtd => l_xtd1

Line 212: OKI_DBI_UTIL_PVT.Process_Parameters (p_param => p_param

208: , p_grand_total => 'N'
209: , p_to_date_type => l_to_date_ytd);
210:
211:
212: OKI_DBI_UTIL_PVT.Process_Parameters (p_param => p_param
213: , p_view_by => l_view_by
214: , p_view_by_col_name => l_view_by_col
215: , p_comparison_type => l_comparison_type
216: , p_xtd => l_xtd1

Line 246: OKI_DBI_UTIL_PVT.Process_Parameters (p_param => p_param

242: , p_alias_name => 'Or2'
243: , p_grand_total => 'N'
244: , p_to_date_type => l_to_date_ytd);
245:
246: OKI_DBI_UTIL_PVT.Process_Parameters (p_param => p_param
247: , p_view_by => l_view_by
248: , p_view_by_col_name => l_view_by_col
249: , p_comparison_type => l_comparison_type
250: , p_xtd => l_xtd1

Line 340: oki_dbi_util_pvt.get_custom_status_binds (x_custom_output);

336: ||'/* END ITD YTD */'
337: || l_viewby_rank_where;
338:
339: x_custom_sql := '/* OKI_DBI_SRM_BLG_RPT */' || l_query;
340: oki_dbi_util_pvt.get_custom_status_binds (x_custom_output);
341: END get_table_sql;
342:
343:
344:

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

355: l_url_select VARCHAR2(32767);
356: BEGIN
357:
358:
359: l_viewby_select := oki_dbi_util_pvt.get_viewby_select_clause(p_view_by_dim, 'SRM', '6.0');
360:
361: l_pastdue_url := '''pFunctionName=OKI_DBI_SRM_PDUE_DTL_DRPT&VIEW_BY_NAME=VIEW_BY_ID&pParamIds=Y&VIEW_BY='||p_view_by_dim||'''';
362: -- l_pastdue_url := '''pFunctionName=OKI_DBI_SRM_PDUE_RNWL_CRPT''';
363:

Line 413: ' ,'||OKI_DBI_UTIL_PVT.change_clause(POA_DBI_UTIL_PKG.rate_clause('c_Br','c_Or'),

409: ' ,'|| p_view_by_col ||
410: ' , nvl(c_Or,0) oki_measure_1'||
411: ' , nvl(c_Br,0) oki_measure_2'||
412: ' ,'||POA_DBI_UTIL_PKG.rate_clause('c_Br','c_Or') || 'oki_measure_3 '||
413: ' ,'||OKI_DBI_UTIL_PVT.change_clause(POA_DBI_UTIL_PKG.rate_clause('c_Br','c_Or'),
414: POA_DBI_UTIL_PKG.rate_clause('p_Br','p_Or'),'P')||'oki_measure_4 '||
415: ' ,'||POA_DBI_UTIL_PKG.rate_clause('c_Br','c_Br_tot') || ' oki_measure_5 '||
416: ' ,'||OKI_DBI_UTIL_PVT.change_clause(POA_DBI_UTIL_PKG.rate_clause('c_Br','c_Br_tot'),
417: POA_DBI_UTIL_PKG.rate_clause('p_Br','p_Br_tot'),'P')||' oki_measure_6 '||

Line 416: ' ,'||OKI_DBI_UTIL_PVT.change_clause(POA_DBI_UTIL_PKG.rate_clause('c_Br','c_Br_tot'),

412: ' ,'||POA_DBI_UTIL_PKG.rate_clause('c_Br','c_Or') || 'oki_measure_3 '||
413: ' ,'||OKI_DBI_UTIL_PVT.change_clause(POA_DBI_UTIL_PKG.rate_clause('c_Br','c_Or'),
414: POA_DBI_UTIL_PKG.rate_clause('p_Br','p_Or'),'P')||'oki_measure_4 '||
415: ' ,'||POA_DBI_UTIL_PKG.rate_clause('c_Br','c_Br_tot') || ' oki_measure_5 '||
416: ' ,'||OKI_DBI_UTIL_PVT.change_clause(POA_DBI_UTIL_PKG.rate_clause('c_Br','c_Br_tot'),
417: POA_DBI_UTIL_PKG.rate_clause('p_Br','p_Br_tot'),'P')||' oki_measure_6 '||
418: ' , nvl(c_Or_tot,0) oki_measure_11'||
419: ' , nvl(c_Br_tot,0) oki_measure_12'||
420: ' ,'||POA_DBI_UTIL_PKG.rate_clause('c_Br_tot','c_Or_tot') || 'oki_measure_13 '||

Line 421: ' ,'||OKI_DBI_UTIL_PVT.change_clause(POA_DBI_UTIL_PKG.rate_clause('c_Br_tot','c_Or_tot'),

417: POA_DBI_UTIL_PKG.rate_clause('p_Br','p_Br_tot'),'P')||' oki_measure_6 '||
418: ' , nvl(c_Or_tot,0) oki_measure_11'||
419: ' , nvl(c_Br_tot,0) oki_measure_12'||
420: ' ,'||POA_DBI_UTIL_PKG.rate_clause('c_Br_tot','c_Or_tot') || 'oki_measure_13 '||
421: ' ,'||OKI_DBI_UTIL_PVT.change_clause(POA_DBI_UTIL_PKG.rate_clause('c_Br_tot','c_Or_tot'),
422: POA_DBI_UTIL_PKG.rate_clause('p_Br_tot','p_Or_tot'),'P')||'oki_measure_14 '||
423: ' ,'||POA_DBI_UTIL_PKG.rate_clause('p_Br','p_Or') || 'oki_measure_23 '||
424: ' ,'||POA_DBI_UTIL_PKG.rate_clause('c_Br','c_Or') || 'oki_calc_item1 '||
425: ' ,'||POA_DBI_UTIL_PKG.rate_clause('p_Br','p_Or') || 'oki_calc_item2 '||

Line 514: oki_dbi_util_pvt.process_parameters (p_param => p_param

510: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl ();
511: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl ();
512:
513:
514: oki_dbi_util_pvt.process_parameters (p_param => p_param
515: , p_view_by => l_view_by
516: , p_view_by_col_name => l_view_by_col
517: , p_comparison_type => l_comparison_type
518: , p_xtd => l_xtd

Line 537: oki_dbi_util_pvt.process_parameters (p_param => p_param

533:
534: l_blg_mv := l_mv;
535:
536: /* Open Where */
537: oki_dbi_util_pvt.process_parameters (p_param => p_param
538: , p_view_by => l_view_by
539: , p_view_by_col_name => l_view_by_col
540: , p_comparison_type => l_comparison_type
541: , p_xtd => l_xtd

Line 615: l_query := oki_dbi_util_pvt.two_way_join (l_select,

611: /*
612: END IF;
613: */
614:
615: l_query := oki_dbi_util_pvt.two_way_join (l_select,
616: '/* BLG ITD */'||l_blg_sql || '/* END BLG ITD */',
617: '/* OPN ITD */'||l_opn_sql || '/* END OPN ITD */',
618: l_join_column1,
619: l_join_column2);

Line 635: l_query := oki_dbi_util_pvt.two_way_join (l_select,

631: l_query VARCHAR2(32767);
632: BEGIN
633: l_select := 'SUM(c_br_itd) c_br_itd, SUM(c_or_itd) c_or_itd, SUM(p_br_itd) p_br_itd, SUM(p_or_itd) p_or_itd ,SUM(c_br_ytd) c_br_ytd, SUM(c_or_ytd) c_or_ytd, SUM(p_br_ytd) p_br_ytd, SUM(p_or_ytd) p_or_ytd ';
634:
635: l_query := oki_dbi_util_pvt.two_way_join (l_select,
636: p_blgopn_itd_sql,
637: p_blgopn_ytd_sql,
638: l_view_by_col,
639: l_view_by_col);

Line 697: oki_dbi_util_pvt.process_parameters ( p_param => p_param

693: l_to_date_xtd := 'XTD';
694: l_comparison_type := 'Y';
695: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl ();
696: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl ();
697: oki_dbi_util_pvt.process_parameters ( p_param => p_param
698: , p_view_by => l_view_by
699: , p_view_by_col_name => l_view_by_col
700: , p_comparison_type => l_comparison_type
701: , p_xtd => l_xtd

Line 736: oki_dbi_util_pvt.join_rpt_where (p_join_tbl => l_join_tbl

732: , p_prior_code => poa_dbi_util_pkg.no_priors);
733:
734: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl ();
735:
736: oki_dbi_util_pvt.join_rpt_where (p_join_tbl => l_join_tbl
737: , p_func_area => 'SRM'
738: , p_version => '6.0'
739: , p_role => NULL
740: , p_mv_set => 'SRM_CDTL_RPT');

Line 763: oki_dbi_util_pvt.get_custom_status_binds (x_custom_output);

759: , p_group_by => l_group_by
760: , p_from_clause => ' from '||l_mv ||' fact ');
761:
762: x_custom_sql := '/* OKI_DBI_SRM_PDUE_DTL_DRPT */' || l_query;
763: oki_dbi_util_pvt.get_custom_status_binds (x_custom_output);
764:
765: END get_pduernwldetail_sql;
766:
767:

Line 882: oki_dbi_util_pvt.process_parameters ( p_param => p_param

878: l_comparison_type := 'Y';
879: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl ();
880: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl ();
881:
882: oki_dbi_util_pvt.process_parameters ( p_param => p_param
883: , p_view_by => l_view_by
884: , p_view_by_col_name => l_view_by_col
885: , p_comparison_type => l_comparison_type
886: , p_xtd => l_xtd

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

898: , p_role => NULL
899: , p_mv_set => 'SRM_DET'
900: , p_rg_where => 'Y');
901:
902: l_view_by_table := oki_dbi_util_pvt.get_table(dim_name => l_view_by
903: ,p_func_area => 'SRM'
904: ,p_version => '6.0' );
905: IF(l_view_by = 'ITEM+ENI_ITEM_VBH_CAT')
906: THEN

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

912: l_prodcat_url := ''''' OKI_DYNAMIC_URL_4 ';
913: END IF;
914:
915:
916: l_viewby_select := oki_dbi_util_pvt.get_viewby_select_clause(l_view_by, 'SRM', '6.0');
917:
918: /* Additional filter needed to avoid displaying records queried due to total values at node */
919: l_filter_where := ' ( ABS(oki_measure_1) +
920: ABS(oki_measure_2) +

Line 1075: oki_dbi_util_pvt.get_custom_status_binds (x_custom_output);

1071:
1072:
1073: x_custom_sql := '/* OKI_DBI_SRM_PDUE_DRPT */ ' || l_query;
1074:
1075: oki_dbi_util_pvt.get_custom_status_binds (x_custom_output);
1076:
1077: END get_pastdue_percent_sql;
1078:
1079: FUNCTION get_pdue_open_2way_sql (

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

1139:
1140: l_join_column1 := l_view_by_col;
1141: l_join_column2 := l_view_by_col;
1142:
1143: l_query := oki_dbi_util_pvt.two_way_join (l_select, l_query1, l_query2,l_join_column1, l_join_column2);
1144:
1145: return l_query;
1146:
1147: END get_pdue_open_2way_sql;

Line 1218: OKI_DBI_UTIL_PVT.Process_Parameters (p_param => p_param

1214: l_col_tbl4 := POA_DBI_UTIL_PKG.Poa_Dbi_Col_Tbl ();
1215:
1216: l_mv_tbl := poa_dbi_util_pkg.poa_dbi_mv_tbl ();
1217:
1218: OKI_DBI_UTIL_PVT.Process_Parameters (p_param => p_param
1219: , p_view_by => l_view_by
1220: , p_view_by_col_name => l_view_by_col
1221: , p_comparison_type => l_comparison_type
1222: , p_xtd => l_xtd1

Line 1245: OKI_DBI_UTIL_PVT.Process_Parameters (p_param => p_param

1241: , p_alias_name => 'Br1'
1242: , p_grand_total => 'N'
1243: , p_to_date_type => l_to_date_ytd);
1244:
1245: OKI_DBI_UTIL_PVT.Process_Parameters (p_param => p_param
1246: , p_view_by => l_view_by
1247: , p_view_by_col_name => l_view_by_col
1248: , p_comparison_type => l_comparison_type
1249: , p_xtd => l_xtd2

Line 1282: OKI_DBI_UTIL_PVT.Process_Parameters ( p_param => p_param

1278: , p_grand_total => 'N'
1279: , p_to_date_type => l_to_date_ytd);
1280:
1281:
1282: OKI_DBI_UTIL_PVT.Process_Parameters ( p_param => p_param
1283: , p_view_by => l_view_by
1284: , p_view_by_col_name => l_view_by_col
1285: , p_comparison_type => l_comparison_type
1286: , p_xtd => l_xtd3

Line 1316: OKI_DBI_UTIL_PVT.Process_Parameters (p_param => p_param

1312: , p_alias_name => 'Or2'
1313: , p_grand_total => 'N'
1314: , p_to_date_type => l_to_date_ytd);
1315:
1316: OKI_DBI_UTIL_PVT.Process_Parameters (p_param => p_param
1317: , p_view_by => l_view_by
1318: , p_view_by_col_name => l_view_by_col
1319: , p_comparison_type => l_comparison_type
1320: , p_xtd => l_xtd4

Line 1478: oki_dbi_util_pvt.get_custom_trend_binds (l_xtd1

1474: l_sql_text:=replace(Replace(REplace(REPLACE(replace(replace(replace(replace(replace(l_query,' ',' '),' ',' '),' ',' '),' ',' '),' ',' '),' (','('),'( ','('),' )',')'),') ',')');
1475:
1476: x_custom_sql := '/* OKI_DBI_SRM_PDUE_G */' || l_sql_text;
1477:
1478: oki_dbi_util_pvt.get_custom_trend_binds (l_xtd1
1479: , l_comparison_type
1480: , x_custom_output);
1481:
1482: END get_trend_sql;

Line 1496: '||OKI_DBI_UTIL_PVT.change_clause('c_rate','p_rate','P') || ' OKI_MEASURE_3,

1492: 'SELECT
1493: VIEWBY,
1494: p_rate OKI_MEASURE_1,
1495: c_rate OKI_MEASURE_2,
1496: '||OKI_DBI_UTIL_PVT.change_clause('c_rate','p_rate','P') || ' OKI_MEASURE_3,
1497: c_Or OKI_MEASURE_4,
1498: c_Br OKI_MEASURE_5
1499: FROM(
1500: SELECT

Line 1638: oki_dbi_util_pvt.process_parameters (p_param => p_param

1634:
1635: BEGIN
1636: l_join_tbl := POA_DBI_UTIL_PKG.Poa_Dbi_Join_Tbl ();
1637:
1638: oki_dbi_util_pvt.process_parameters (p_param => p_param
1639: , p_view_by => l_view_by
1640: , p_view_by_col_name => l_view_by_col
1641: , p_comparison_type => l_comparison_type
1642: , p_xtd => l_xtd1

Line 1658: oki_dbi_util_pvt.process_parameters (p_param => p_param

1654: , p_role => NULL
1655: , p_mv_set => 'SRM_ST_71'
1656: , p_rg_where => 'Y');
1657:
1658: oki_dbi_util_pvt.process_parameters (p_param => p_param
1659: , p_view_by => l_view_by
1660: , p_view_by_col_name => l_view_by_col
1661: , p_comparison_type => l_comparison_type
1662: , p_xtd => l_xtd2

Line 1678: oki_dbi_util_pvt.process_parameters (p_param => p_param

1674: , p_role => NULL
1675: , p_mv_set => 'SRM_SG_71'
1676: , p_rg_where => 'Y');
1677:
1678: oki_dbi_util_pvt.process_parameters (p_param => p_param
1679: , p_view_by => l_view_by
1680: , p_view_by_col_name => l_view_by_col
1681: , p_comparison_type => l_comparison_type
1682: , p_xtd => l_xtd3

Line 1698: oki_dbi_util_pvt.process_parameters (p_param => p_param

1694: , p_role => NULL
1695: , p_mv_set => 'SRM_CN_71'
1696: , p_rg_where => 'Y');
1697:
1698: oki_dbi_util_pvt.process_parameters (p_param => p_param
1699: , p_view_by => l_view_by
1700: , p_view_by_col_name => l_view_by_col
1701: , p_comparison_type => l_comparison_type
1702: , p_xtd => l_xtd4

Line 1850: oki_dbi_util_pvt.process_parameters (p_param => p_param

1846: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl ();
1847: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl ();
1848:
1849:
1850: oki_dbi_util_pvt.process_parameters (p_param => p_param
1851: , p_view_by => l_view_by
1852: , p_view_by_col_name => l_view_by_col
1853: , p_comparison_type => l_comparison_type
1854: , p_xtd => l_xtd

Line 1917: oki_dbi_util_pvt.process_parameters (p_param => p_param

1913: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl ();
1914: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl ();
1915:
1916:
1917: oki_dbi_util_pvt.process_parameters (p_param => p_param
1918: , p_view_by => l_view_by
1919: , p_view_by_col_name => l_view_by_col
1920: , p_comparison_type => l_comparison_type
1921: , p_xtd => l_xtd

Line 1968: oki_dbi_util_pvt.get_custom_status_binds (x_custom_output);

1964: l_query:='Hello';
1965:
1966: x_custom_sql := '/* OKI_DBI_SRM_PDUE_CRPT */' || l_query;
1967:
1968: oki_dbi_util_pvt.get_custom_status_binds (x_custom_output);
1969:
1970: END get_pdueval_cust_sql;
1971:
1972: /*******************************************************************************