APPS.OPI_DBI_WMS_RPT_PKG dependencies on POA_DBI_TEMPLATE_PKG

Line 108: ' || poa_dbi_template_pkg.status_sql (

104:
105: --Generate Final Query
106: l_query := GET_PICK_EX_SEL_CLAUSE (l_view_by, l_join_tbl) || fnd_global.newline
107: || 'from
108: ' || poa_dbi_template_pkg.status_sql (
109: p_fact_name => l_mv,
110: p_where_clause => l_where_clause,
111: p_join_tables => l_join_tbl,
112: p_use_windowing => 'Y',

Line 411: ' || poa_dbi_template_pkg.status_sql (

407: p_to_date_type => 'RLX');
408:
409: l_query := GET_PICK_REASON_SEL_CLAUSE (l_view_by, l_join_tbl) || fnd_global.newline
410: || 'from
411: ' || poa_dbi_template_pkg.status_sql (
412: p_fact_name => l_mv,
413: p_where_clause => l_where_clause,
414: p_join_tables => l_join_tbl,
415: p_use_windowing => 'Y',

Line 596: poa_dbi_template_pkg.trend_sql(

592:
593: --Generate Final Query
594: l_query := GET_PICK_EX_TRD_SEL_CLAUSE(l_view_by) ||
595: ' from ' ||
596: poa_dbi_template_pkg.trend_sql(
597: p_xtd => l_xtd,
598: p_comparison_type => l_comparison_type,
599: p_fact_name => l_mv,
600: p_where_clause => l_where_clause,

Line 783: ' || poa_dbi_template_pkg.status_sql (

779: ' OR OPI_MEASURE15 > 0' ;
780:
781: l_query := GET_OPP_SEL_CLAUSE (l_view_by, l_join_tbl)
782: || ' from
783: ' || poa_dbi_template_pkg.status_sql (
784: p_fact_name => l_mv,
785: p_where_clause => l_where_clause,
786: p_join_tables => l_join_tbl,
787: p_use_windowing => 'Y',

Line 1039: ' || poa_dbi_template_pkg.status_sql (p_fact_name => l_mv,

1035:
1036: --Generate Final Query
1037: l_query := GET_OP_EX_REASON_SEL_CLAUSE (l_view_by, l_join_tbl)
1038: || ' from
1039: ' || poa_dbi_template_pkg.status_sql (p_fact_name => l_mv,
1040: p_where_clause => l_where_clause,
1041: p_join_tables => l_join_tbl,
1042: p_use_windowing => 'Y',
1043: p_col_name => l_col_tbl,