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

Line 81: OKI_DBI_UTIL_PVT.Process_Parameters (p_param => p_param

77: l_comparison_type := 'Y';
78: l_join_tbl := POA_DBI_UTIL_PKG.Poa_Dbi_Join_Tbl ();
79:
80:
81: OKI_DBI_UTIL_PVT.Process_Parameters (p_param => p_param
82: , p_view_by => l_view_by
83: , p_view_by_col_name => l_view_by_col
84: , p_comparison_type => l_comparison_type
85: , p_xtd => l_xtd

Line 123: oki_dbi_util_pvt.get_custom_status_binds (x_custom_output);

119: || poa_dbi_template_pkg.get_viewby_rank_clause ( p_join_tables => l_join_tbl
120: , p_use_windowing => 'Y' );
121:
122: x_custom_sql := '/* OKI_DBI_SCM_BAL_SUM_RPT */ '||l_query;
123: oki_dbi_util_pvt.get_custom_status_binds (x_custom_output);
124:
125: END get_balance_sql;
126: --------------------------------------------------------------------
127:

Line 185: OKI_DBI_UTIL_PVT.Process_Parameters (p_param => p_param

181: l_balance_logic := nvl(fnd_profile.value('OKI_BAL_IDENT'),'CONTRDATE');
182:
183: IF (l_balance_logic = 'CONTRDATE') THEN
184: --{
185: OKI_DBI_UTIL_PVT.Process_Parameters (p_param => p_param
186: , p_view_by => l_view_by
187: , p_view_by_col_name => l_view_by_col
188: , p_comparison_type => l_comparison_type
189: , p_xtd => l_xtd1

Line 218: OKI_DBI_UTIL_PVT.Process_Parameters (p_param => p_param

214: , p_grand_total => 'N'
215: , p_to_date_type => p_ptd);
216:
217:
218: OKI_DBI_UTIL_PVT.Process_Parameters (p_param => p_param
219: , p_view_by => l_view_by
220: , p_view_by_col_name => l_view_by_col
221: , p_comparison_type => l_comparison_type
222: , p_xtd => l_xtd1

Line 245: OKI_DBI_UTIL_PVT.Process_Parameters (p_param => p_param

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

Line 298: OKI_DBI_UTIL_PVT.Process_Parameters (p_param => p_param

294: ELSE
295:
296: --{
297:
298: OKI_DBI_UTIL_PVT.Process_Parameters (p_param => p_param
299: , p_view_by => l_view_by
300: , p_view_by_col_name => l_view_by_col
301: , p_comparison_type => l_comparison_type
302: , p_xtd => l_xtd1

Line 331: OKI_DBI_UTIL_PVT.Process_Parameters (p_param => p_param

327: , p_grand_total => 'N'
328: , p_to_date_type => p_ptd);
329:
330:
331: OKI_DBI_UTIL_PVT.Process_Parameters (p_param => p_param
332: , p_view_by => l_view_by
333: , p_view_by_col_name => l_view_by_col
334: , p_comparison_type => l_comparison_type
335: , p_xtd => l_xtd1

Line 358: OKI_DBI_UTIL_PVT.Process_Parameters (p_param => p_param

354: , p_alias_name => 'xtd2'
355: , p_grand_total => 'N'
356: , p_to_date_type => p_ptd);
357:
358: OKI_DBI_UTIL_PVT.Process_Parameters (p_param => p_param
359: , p_view_by => l_view_by
360: , p_view_by_col_name => l_view_by_col
361: , p_comparison_type => l_comparison_type
362: , p_xtd => l_xtd1

Line 405: OKI_DBI_UTIL_PVT.Process_Parameters (p_param => p_param

401: l_mv_tbl(3).mv_where := l_where_clause3;
402: l_mv_tbl(3).in_join_tbls := NULL;
403: l_mv_tbl(3).use_grp_id := 'N';
404:
405: OKI_DBI_UTIL_PVT.Process_Parameters (p_param => p_param
406: , p_view_by => l_view_by
407: , p_view_by_col_name => l_view_by_col
408: , p_comparison_type => l_comparison_type
409: , p_xtd => l_xtd1

Line 468: || oki_dbi_util_pvt.get_nested_cols(l_col_tbl1,'YTD',p_trend_flag)

464:
465:
466: IF (p_ptd = 'YTD' ) THEN
467: l_sql1 := 'Select 1'
468: || oki_dbi_util_pvt.get_nested_cols(l_col_tbl1,'YTD',p_trend_flag)
469: || oki_dbi_util_pvt.get_xtd_where(l_mv1,'N','YTD','119')
470: || l_where_clause1;
471:
472:

Line 469: || oki_dbi_util_pvt.get_xtd_where(l_mv1,'N','YTD','119')

465:
466: IF (p_ptd = 'YTD' ) THEN
467: l_sql1 := 'Select 1'
468: || oki_dbi_util_pvt.get_nested_cols(l_col_tbl1,'YTD',p_trend_flag)
469: || oki_dbi_util_pvt.get_xtd_where(l_mv1,'N','YTD','119')
470: || l_where_clause1;
471:
472:
473: l_sql2 := 'Select 1'

Line 474: || oki_dbi_util_pvt.get_nested_cols(l_col_tbl2,'YTD',p_trend_flag)

470: || l_where_clause1;
471:
472:
473: l_sql2 := 'Select 1'
474: || oki_dbi_util_pvt.get_nested_cols(l_col_tbl2,'YTD',p_trend_flag)
475: || oki_dbi_util_pvt.get_xtd_where(l_mv2,'N','YTD','119')
476: || l_where_clause2;
477:
478: l_sql3 := 'Select 1'

Line 475: || oki_dbi_util_pvt.get_xtd_where(l_mv2,'N','YTD','119')

471:
472:
473: l_sql2 := 'Select 1'
474: || oki_dbi_util_pvt.get_nested_cols(l_col_tbl2,'YTD',p_trend_flag)
475: || oki_dbi_util_pvt.get_xtd_where(l_mv2,'N','YTD','119')
476: || l_where_clause2;
477:
478: l_sql3 := 'Select 1'
479: || oki_dbi_util_pvt.get_nested_cols(l_col_tbl3,'YTD',p_trend_flag)

Line 479: || oki_dbi_util_pvt.get_nested_cols(l_col_tbl3,'YTD',p_trend_flag)

475: || oki_dbi_util_pvt.get_xtd_where(l_mv2,'N','YTD','119')
476: || l_where_clause2;
477:
478: l_sql3 := 'Select 1'
479: || oki_dbi_util_pvt.get_nested_cols(l_col_tbl3,'YTD',p_trend_flag)
480: || oki_dbi_util_pvt.get_xtd_where(l_mv3,'N','YTD','119')
481: || l_where_clause3;
482:
483: l_sql := get_xtd_sel_clause (p_ptd, l_view_by_col, 'Y') || '('

Line 480: || oki_dbi_util_pvt.get_xtd_where(l_mv3,'N','YTD','119')

476: || l_where_clause2;
477:
478: l_sql3 := 'Select 1'
479: || oki_dbi_util_pvt.get_nested_cols(l_col_tbl3,'YTD',p_trend_flag)
480: || oki_dbi_util_pvt.get_xtd_where(l_mv3,'N','YTD','119')
481: || l_where_clause3;
482:
483: l_sql := get_xtd_sel_clause (p_ptd, l_view_by_col, 'Y') || '('
484: || l_sql1

Line 493: || oki_dbi_util_pvt.get_nested_cols(l_col_tbl4,'YTD',p_trend_flag)

489:
490: IF (l_balance_logic = 'EVENTDATE') THEN
491: --{
492: l_sql4 := 'Select 1'
493: || oki_dbi_util_pvt.get_nested_cols(l_col_tbl4,'YTD',p_trend_flag)
494: || oki_dbi_util_pvt.get_xtd_where(l_mv4,'N','YTD','119')
495: || l_where_clause4;
496:
497: l_sql := get_xtd_sel_clause (p_ptd, l_view_by_col, 'Y') || '('

Line 494: || oki_dbi_util_pvt.get_xtd_where(l_mv4,'N','YTD','119')

490: IF (l_balance_logic = 'EVENTDATE') THEN
491: --{
492: l_sql4 := 'Select 1'
493: || oki_dbi_util_pvt.get_nested_cols(l_col_tbl4,'YTD',p_trend_flag)
494: || oki_dbi_util_pvt.get_xtd_where(l_mv4,'N','YTD','119')
495: || l_where_clause4;
496:
497: l_sql := get_xtd_sel_clause (p_ptd, l_view_by_col, 'Y') || '('
498: || l_sql1

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

605: l_viewby_select VARCHAR2(32767);
606: l_url_select VARCHAR2(32767);
607: BEGIN
608:
609: l_viewby_select := oki_dbi_util_pvt.get_viewby_select_clause(p_view_by_dim, 'SRM', '6.0');
610: -- Drill Across URL when view by is Salesrep and Product
611: l_Cbal_url := '''pFunctionName=OKI_DBI_SCM_BAL_DTL_RPT&VIEW_BY_NAME=VIEW_BY_ID&pParamIds=Y''';
612:
613: l_viewby_select := l_viewby_select ||

Line 678: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset15.c_cur','oset15.p_cur','NP') || ' cur_chg '||

674: ' , oset20.ptd_chg OKI_CHANGE_3, oset20.ptd_chg_tot OKI_TCHANGE_3 '||
675: ' from ( select '|| p_view_by_col ||', oset15.c_cur c_cur '||
676: ' , oset15.p_cur p_cur, oset15.c_cur_tot c_cur_tot '||
677: ' , oset15.p_cur_tot p_cur_tot '||
678: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset15.c_cur','oset15.p_cur','NP') || ' cur_chg '||
679: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset15.c_cur_tot','oset15.p_cur_tot','NP') || ' cur_chg_tot '||
680: ' , oset15.c_cur_per, oset15.p_cur_per '||
681: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset15.c_cur_per','oset15.p_cur_per','P') || ' cur_per_chg '||
682: ' , oset15.c_beg c_beg, oset15.p_beg p_beg, oset15.c_beg_tot c_beg_tot '||

Line 679: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset15.c_cur_tot','oset15.p_cur_tot','NP') || ' cur_chg_tot '||

675: ' from ( select '|| p_view_by_col ||', oset15.c_cur c_cur '||
676: ' , oset15.p_cur p_cur, oset15.c_cur_tot c_cur_tot '||
677: ' , oset15.p_cur_tot p_cur_tot '||
678: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset15.c_cur','oset15.p_cur','NP') || ' cur_chg '||
679: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset15.c_cur_tot','oset15.p_cur_tot','NP') || ' cur_chg_tot '||
680: ' , oset15.c_cur_per, oset15.p_cur_per '||
681: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset15.c_cur_per','oset15.p_cur_per','P') || ' cur_per_chg '||
682: ' , oset15.c_beg c_beg, oset15.p_beg p_beg, oset15.c_beg_tot c_beg_tot '||
683: ' , oset15.p_beg_tot p_beg_tot '||

Line 681: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset15.c_cur_per','oset15.p_cur_per','P') || ' cur_per_chg '||

677: ' , oset15.p_cur_tot p_cur_tot '||
678: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset15.c_cur','oset15.p_cur','NP') || ' cur_chg '||
679: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset15.c_cur_tot','oset15.p_cur_tot','NP') || ' cur_chg_tot '||
680: ' , oset15.c_cur_per, oset15.p_cur_per '||
681: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset15.c_cur_per','oset15.p_cur_per','P') || ' cur_per_chg '||
682: ' , oset15.c_beg c_beg, oset15.p_beg p_beg, oset15.c_beg_tot c_beg_tot '||
683: ' , oset15.p_beg_tot p_beg_tot '||
684: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset15.c_beg','oset15.p_beg','NP') || ' beg_chg '||
685: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset15.c_beg_tot','oset15.p_beg_tot','NP') || ' beg_chg_tot '||

Line 684: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset15.c_beg','oset15.p_beg','NP') || ' beg_chg '||

680: ' , oset15.c_cur_per, oset15.p_cur_per '||
681: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset15.c_cur_per','oset15.p_cur_per','P') || ' cur_per_chg '||
682: ' , oset15.c_beg c_beg, oset15.p_beg p_beg, oset15.c_beg_tot c_beg_tot '||
683: ' , oset15.p_beg_tot p_beg_tot '||
684: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset15.c_beg','oset15.p_beg','NP') || ' beg_chg '||
685: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset15.c_beg_tot','oset15.p_beg_tot','NP') || ' beg_chg_tot '||
686: ' , oset15.c_beg_per, oset15.p_beg_per '||
687: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset15.c_beg_per','oset15.p_beg_per','P') || ' beg_per_chg '||
688: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset15.c_cur','oset15.c_beg','NP') || ' ptd_chg '||

Line 685: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset15.c_beg_tot','oset15.p_beg_tot','NP') || ' beg_chg_tot '||

681: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset15.c_cur_per','oset15.p_cur_per','P') || ' cur_per_chg '||
682: ' , oset15.c_beg c_beg, oset15.p_beg p_beg, oset15.c_beg_tot c_beg_tot '||
683: ' , oset15.p_beg_tot p_beg_tot '||
684: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset15.c_beg','oset15.p_beg','NP') || ' beg_chg '||
685: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset15.c_beg_tot','oset15.p_beg_tot','NP') || ' beg_chg_tot '||
686: ' , oset15.c_beg_per, oset15.p_beg_per '||
687: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset15.c_beg_per','oset15.p_beg_per','P') || ' beg_per_chg '||
688: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset15.c_cur','oset15.c_beg','NP') || ' ptd_chg '||
689: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset15.c_cur_tot','oset15.c_beg_tot','NP') || ' ptd_chg_tot '||

Line 687: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset15.c_beg_per','oset15.p_beg_per','P') || ' beg_per_chg '||

683: ' , oset15.p_beg_tot p_beg_tot '||
684: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset15.c_beg','oset15.p_beg','NP') || ' beg_chg '||
685: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset15.c_beg_tot','oset15.p_beg_tot','NP') || ' beg_chg_tot '||
686: ' , oset15.c_beg_per, oset15.p_beg_per '||
687: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset15.c_beg_per','oset15.p_beg_per','P') || ' beg_per_chg '||
688: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset15.c_cur','oset15.c_beg','NP') || ' ptd_chg '||
689: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset15.c_cur_tot','oset15.c_beg_tot','NP') || ' ptd_chg_tot '||
690: ' from (select '|| p_view_by_col ||', oset13.c_cur , oset13.c_cur_tot '||
691: ' , oset13.p_cur , oset13.p_cur_tot '||

Line 688: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset15.c_cur','oset15.c_beg','NP') || ' ptd_chg '||

684: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset15.c_beg','oset15.p_beg','NP') || ' beg_chg '||
685: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset15.c_beg_tot','oset15.p_beg_tot','NP') || ' beg_chg_tot '||
686: ' , oset15.c_beg_per, oset15.p_beg_per '||
687: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset15.c_beg_per','oset15.p_beg_per','P') || ' beg_per_chg '||
688: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset15.c_cur','oset15.c_beg','NP') || ' ptd_chg '||
689: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset15.c_cur_tot','oset15.c_beg_tot','NP') || ' ptd_chg_tot '||
690: ' from (select '|| p_view_by_col ||', oset13.c_cur , oset13.c_cur_tot '||
691: ' , oset13.p_cur , oset13.p_cur_tot '||
692: ' ,'||POA_DBI_UTIL_PKG.rate_clause('oset13.c_cur','oset13.c_cur_tot') || ' c_cur_per '||

Line 689: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset15.c_cur_tot','oset15.c_beg_tot','NP') || ' ptd_chg_tot '||

685: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset15.c_beg_tot','oset15.p_beg_tot','NP') || ' beg_chg_tot '||
686: ' , oset15.c_beg_per, oset15.p_beg_per '||
687: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset15.c_beg_per','oset15.p_beg_per','P') || ' beg_per_chg '||
688: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset15.c_cur','oset15.c_beg','NP') || ' ptd_chg '||
689: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset15.c_cur_tot','oset15.c_beg_tot','NP') || ' ptd_chg_tot '||
690: ' from (select '|| p_view_by_col ||', oset13.c_cur , oset13.c_cur_tot '||
691: ' , oset13.p_cur , oset13.p_cur_tot '||
692: ' ,'||POA_DBI_UTIL_PKG.rate_clause('oset13.c_cur','oset13.c_cur_tot') || ' c_cur_per '||
693: ' ,'||POA_DBI_UTIL_PKG.rate_clause('oset13.p_cur','oset13.p_cur_tot') || ' p_cur_per '||

Line 755: oki_dbi_util_pvt.process_parameters (p_param => p_param

751: l_comparison_type := 'Y';
752: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl ();
753: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl ();
754:
755: oki_dbi_util_pvt.process_parameters (p_param => p_param
756: , p_view_by => l_view_by
757: , p_view_by_col_name => l_view_by_col
758: , p_comparison_type => l_comparison_type
759: , p_xtd => l_xtd

Line 795: || oki_dbi_util_pvt.get_nested_cols(l_col_tbl,'ITD',p_trend_flag)

791: , p_to_date_type => l_to_date_ytd);
792:
793: if (p_trend_flag = 'Y') then
794: l_sql := 'Select 1'
795: || oki_dbi_util_pvt.get_nested_cols(l_col_tbl,'ITD',p_trend_flag)
796: || oki_dbi_util_pvt.get_itd_where(l_mv,p_trend_flag)
797: || l_where_clause;
798: else
799: l_sql := 'Select ' || l_view_by_col

Line 796: || oki_dbi_util_pvt.get_itd_where(l_mv,p_trend_flag)

792:
793: if (p_trend_flag = 'Y') then
794: l_sql := 'Select 1'
795: || oki_dbi_util_pvt.get_nested_cols(l_col_tbl,'ITD',p_trend_flag)
796: || oki_dbi_util_pvt.get_itd_where(l_mv,p_trend_flag)
797: || l_where_clause;
798: else
799: l_sql := 'Select ' || l_view_by_col
800: || oki_dbi_util_pvt.get_nested_cols(l_col_tbl,'ITD',p_trend_flag)

Line 800: || oki_dbi_util_pvt.get_nested_cols(l_col_tbl,'ITD',p_trend_flag)

796: || oki_dbi_util_pvt.get_itd_where(l_mv,p_trend_flag)
797: || l_where_clause;
798: else
799: l_sql := 'Select ' || l_view_by_col
800: || oki_dbi_util_pvt.get_nested_cols(l_col_tbl,'ITD',p_trend_flag)
801: || oki_dbi_util_pvt.get_itd_where(l_mv,p_trend_flag)
802: || l_where_clause
803: || ' GROUP BY ' || l_view_by_col;
804: END IF;

Line 801: || oki_dbi_util_pvt.get_itd_where(l_mv,p_trend_flag)

797: || l_where_clause;
798: else
799: l_sql := 'Select ' || l_view_by_col
800: || oki_dbi_util_pvt.get_nested_cols(l_col_tbl,'ITD',p_trend_flag)
801: || oki_dbi_util_pvt.get_itd_where(l_mv,p_trend_flag)
802: || l_where_clause
803: || ' GROUP BY ' || l_view_by_col;
804: END IF;
805:

Line 843: oki_dbi_util_pvt.process_parameters (p_param => p_param

839: l_comparison_type := 'Y';
840: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl ();
841: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl ();
842:
843: oki_dbi_util_pvt.process_parameters (p_param => p_param
844: , p_view_by => l_view_by
845: , p_view_by_col_name => l_view_by_col
846: , p_comparison_type => l_comparison_type
847: , p_xtd => l_xtd

Line 886: || oki_dbi_util_pvt.get_nested_cols(l_col_tbl,'YTD',p_trend_flag)

882: if (p_trend_flag = 'Y') then
883: -- NOte: Currently chnaged implementation to use same dates for trend and status.
884: -- hence get_xtd_where trend flag = N for both cases.
885: l_sql := 'Select 1'
886: || oki_dbi_util_pvt.get_nested_cols(l_col_tbl,'YTD',p_trend_flag)
887: || oki_dbi_util_pvt.get_xtd_where(l_mv,'N','YTD','119')
888: || l_where_clause;
889: else
890: l_sql := 'Select ' || l_view_by_col

Line 887: || oki_dbi_util_pvt.get_xtd_where(l_mv,'N','YTD','119')

883: -- NOte: Currently chnaged implementation to use same dates for trend and status.
884: -- hence get_xtd_where trend flag = N for both cases.
885: l_sql := 'Select 1'
886: || oki_dbi_util_pvt.get_nested_cols(l_col_tbl,'YTD',p_trend_flag)
887: || oki_dbi_util_pvt.get_xtd_where(l_mv,'N','YTD','119')
888: || l_where_clause;
889: else
890: l_sql := 'Select ' || l_view_by_col
891: || oki_dbi_util_pvt.get_nested_cols(l_col_tbl,'YTD',p_trend_flag)

Line 891: || oki_dbi_util_pvt.get_nested_cols(l_col_tbl,'YTD',p_trend_flag)

887: || oki_dbi_util_pvt.get_xtd_where(l_mv,'N','YTD','119')
888: || l_where_clause;
889: else
890: l_sql := 'Select ' || l_view_by_col
891: || oki_dbi_util_pvt.get_nested_cols(l_col_tbl,'YTD',p_trend_flag)
892: || oki_dbi_util_pvt.get_xtd_where(l_mv,'N','YTD','119')
893: || l_where_clause
894: || ' GROUP BY ' || l_view_by_col;
895: END IF;

Line 892: || oki_dbi_util_pvt.get_xtd_where(l_mv,'N','YTD','119')

888: || l_where_clause;
889: else
890: l_sql := 'Select ' || l_view_by_col
891: || oki_dbi_util_pvt.get_nested_cols(l_col_tbl,'YTD',p_trend_flag)
892: || oki_dbi_util_pvt.get_xtd_where(l_mv,'N','YTD','119')
893: || l_where_clause
894: || ' GROUP BY ' || l_view_by_col;
895: END IF;
896:

Line 949: OKI_DBI_UTIL_PVT.Process_Parameters (p_param => p_param

945: l_comparison_type := 'Y';
946: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl ();
947: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl ();
948:
949: OKI_DBI_UTIL_PVT.Process_Parameters (p_param => p_param
950: , p_view_by => l_view_by
951: , p_view_by_col_name => l_view_by_col
952: , p_comparison_type => l_comparison_type
953: , p_xtd => l_xtd

Line 993: oki_dbi_util_pvt.get_custom_trend_binds (l_xtd

989:
990: l_query := get_trend_query(l_itd_sql,l_ytd_sql,l_xtd_sql,l_cur_suffix);
991: */
992: x_custom_sql := '/* OKI_DBI_SCM_BAL_GPH_RPT */ '||l_query;
993: oki_dbi_util_pvt.get_custom_trend_binds (l_xtd
994: , l_comparison_type
995: , x_custom_output);
996:
997: END get_balance_trend_sql ;

Line 1044: ' ,'||OKI_DBI_UTIL_PVT.change_clause('curr_bal','p_curr_bal','NP') || ' OKI_CHANGE_1 '||

1040:
1041: l_sql := 'Select VIEWBY, '||
1042: ' curr_bal OKI_MEASURE_1, '||
1043: ' p_curr_bal OKI_PMEASURE_1' ||
1044: ' ,'||OKI_DBI_UTIL_PVT.change_clause('curr_bal','p_curr_bal','NP') || ' OKI_CHANGE_1 '||
1045: ' FROM ( ' ||
1046: 'Select cal_start_date, VIEWBY, '||
1047: ' nvl(bal.c_bal,0) - nvl(xtd.c_xtd,0) curr_bal '||
1048: ' ,nvl(bal.p_bal,0) - nvl(xtd.p_xtd,0) p_curr_bal '||

Line 1050: ' Select ' || OKI_DBI_UTIL_PVT.add_measures('itd.c_itd','ytd.c_ytd') ||' c_bal '||

1046: 'Select cal_start_date, VIEWBY, '||
1047: ' nvl(bal.c_bal,0) - nvl(xtd.c_xtd,0) curr_bal '||
1048: ' ,nvl(bal.p_bal,0) - nvl(xtd.p_xtd,0) p_curr_bal '||
1049: ' FROM ( '||
1050: ' Select ' || OKI_DBI_UTIL_PVT.add_measures('itd.c_itd','ytd.c_ytd') ||' c_bal '||
1051: ' ,'|| OKI_DBI_UTIL_PVT.add_measures('itd.p_itd','ytd.p_ytd') ||' p_bal '||
1052: ' FROM ( '|| p_itd ||') itd, ( '|| p_ytd || ') ytd ) bal , ('|| p_xtd || '))) xtd' ||
1053: ' ) ' ;
1054: -- ORDER BY cal_start_date

Line 1051: ' ,'|| OKI_DBI_UTIL_PVT.add_measures('itd.p_itd','ytd.p_ytd') ||' p_bal '||

1047: ' nvl(bal.c_bal,0) - nvl(xtd.c_xtd,0) curr_bal '||
1048: ' ,nvl(bal.p_bal,0) - nvl(xtd.p_xtd,0) p_curr_bal '||
1049: ' FROM ( '||
1050: ' Select ' || OKI_DBI_UTIL_PVT.add_measures('itd.c_itd','ytd.c_ytd') ||' c_bal '||
1051: ' ,'|| OKI_DBI_UTIL_PVT.add_measures('itd.p_itd','ytd.p_ytd') ||' p_bal '||
1052: ' FROM ( '|| p_itd ||') itd, ( '|| p_ytd || ') ytd ) bal , ('|| p_xtd || '))) xtd' ||
1053: ' ) ' ;
1054: -- ORDER BY cal_start_date
1055:

Line 1106: OKI_DBI_UTIL_PVT.process_parameters ( p_param => p_param

1102: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl ();
1103: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl ();
1104:
1105:
1106: OKI_DBI_UTIL_PVT.process_parameters ( p_param => p_param
1107: , p_view_by => l_view_by
1108: , p_view_by_col_name => l_view_by_col
1109: , p_comparison_type => l_comparison_type
1110: , p_xtd => l_xtd

Line 1142: OKI_DBI_UTIL_PVT.join_rpt_where (p_join_tbl => l_join_tbl

1138: , p_prior_code => poa_dbi_util_pkg.no_priors);
1139:
1140: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl ();
1141:
1142: OKI_DBI_UTIL_PVT.join_rpt_where (p_join_tbl => l_join_tbl
1143: , p_func_area => 'SRM'
1144: , p_version => '6.0'
1145: , p_role => NULL
1146: , p_mv_set => 'SRM_CDTL_RPT');

Line 1170: oki_dbi_util_pvt.get_custom_status_binds (x_custom_output);

1166: , p_from_clause => 'from '||l_mv ||' fact ');
1167:
1168:
1169: x_custom_sql := '/* OKI_DBI_SCM_BAL_DTL_RPT */'||l_query;
1170: oki_dbi_util_pvt.get_custom_status_binds (x_custom_output);
1171:
1172: END get_balance_detail_sql;
1173:
1174: FUNCTION get_bal_detail_sel_clause (