APPS.OPI_DBI_WMS_RTP_PKG dependencies on POA_DBI_SUTIL_PKG

Line 449: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;

445: ---------------------------------------------------*/
446:
447: function get_tbl_filter_where1(p_view_by in VARCHAR2) return varchar2
448: is
449: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;
450: begin
451: l_col_tbl := poa_dbi_sutil_pkg.poa_dbi_filter_tbl();
452: l_col_tbl.extend;
453: l_col_tbl(1) := 'OPI_MEASURE2';

Line 451: l_col_tbl := poa_dbi_sutil_pkg.poa_dbi_filter_tbl();

447: function get_tbl_filter_where1(p_view_by in VARCHAR2) return varchar2
448: is
449: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;
450: begin
451: l_col_tbl := poa_dbi_sutil_pkg.poa_dbi_filter_tbl();
452: l_col_tbl.extend;
453: l_col_tbl(1) := 'OPI_MEASURE2';
454: l_col_tbl.extend;
455: l_col_tbl(2) := 'OPI_MEASURE3';

Line 470: return poa_dbi_sutil_pkg.get_filter_where(l_col_tbl);

466: l_col_tbl(10) := 'OPI_MEASURE1';
467: l_col_tbl.extend;
468: l_col_tbl(10) := 'OPI_MEASURE4';
469: end if;
470: return poa_dbi_sutil_pkg.get_filter_where(l_col_tbl);
471: end;
472:
473:
474:

Line 787: l_mv_tbl(1).mv_hint := poa_dbi_sutil_pkg.get_fact_hint(l_mv1);

783: l_mv_tbl(1).mv_col := l_col_tbl1;
784: l_mv_tbl(1).mv_where := l_where_clause;
785: l_mv_tbl(1).in_join_tbls := NULL;
786: l_mv_tbl(1).use_grp_id := 'N';
787: l_mv_tbl(1).mv_hint := poa_dbi_sutil_pkg.get_fact_hint(l_mv1);
788: l_mv_tbl(1).mv_xtd := l_xtd1;
789:
790: l_mv_tbl.extend;
791: l_mv_tbl(2).mv_name := l_mv2;

Line 796: l_mv_tbl(2).mv_hint := poa_dbi_sutil_pkg.get_fact_hint(l_mv2);

792: l_mv_tbl(2).mv_col := l_col_tbl2;
793: l_mv_tbl(2).mv_where := l_where_clause2;
794: l_mv_tbl(2).in_join_tbls := NULL;
795: l_mv_tbl(2).use_grp_id := 'N';
796: l_mv_tbl(2).mv_hint := poa_dbi_sutil_pkg.get_fact_hint(l_mv2);
797: l_mv_tbl(2).mv_xtd := l_xtd2;
798:
799: l_query := get_trd_sel_clause(l_view_by) ||
800: ' from ' ||

Line 819: p_fact_hint => poa_dbi_sutil_pkg.get_fact_hint(l_mv2)

815: p_where_clause => l_where_clause2,
816: p_col_name => l_col_tbl2,
817: p_use_grpid => 'N',
818: p_in_join_tables => NULL,
819: p_fact_hint => poa_dbi_sutil_pkg.get_fact_hint(l_mv2)
820:
821: );
822: END IF;
823: