APPS.OPI_DBI_CC_RPT_PKG dependencies on POA_DBI_TEMPLATE_PKG

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

129:
130: -- construct the query
131: l_query := get_cc_rpt_sel_clause (l_view_by, l_join_tbl)
132: || ' from
133: ' || poa_dbi_template_pkg.status_sql (p_fact_name => l_mv,
134: p_where_clause => l_where_clause,
135: p_join_tables => l_join_tbl,
136: p_use_windowing => 'Y',
137: p_col_name => l_col_tbl,

Line 557: poa_dbi_template_pkg.trend_sql (

553:
554: -- Merge Outer and Inner Query
555: l_query := get_cc_trd_sel_clause(l_view_by) ||
556: ' from ' ||
557: poa_dbi_template_pkg.trend_sql (
558: p_xtd => l_xtd,
559: p_comparison_type => l_comparison_type,
560: p_fact_name => l_mv,
561: p_where_clause => l_where_clause,

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

741:
742: -- construct the query
743: l_query := get_hitmiss_sel_clause (l_view_by, l_join_tbl)
744: || ' from
745: ' || poa_dbi_template_pkg.status_sql (p_fact_name => l_mv,
746: p_where_clause => l_where_clause,
747: p_join_tables => l_join_tbl,
748: p_use_windowing => 'Y',
749: p_col_name => l_col_tbl,

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

1080:
1081: -- construct the query
1082: l_query := get_adj_rpt_sel_clause (l_view_by, l_join_tbl)
1083: || ' from
1084: ' || poa_dbi_template_pkg.status_sql (p_fact_name => l_mv,
1085: p_where_clause => l_where_clause,
1086: p_join_tables => l_join_tbl,
1087: p_use_windowing => 'Y',
1088: p_col_name => l_col_tbl,

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

1430:
1431: -- construct the query
1432: l_query := get_adj_dtl_sel_clause (l_view_by, l_join_tbl)
1433: || ' from
1434: ' || poa_dbi_template_pkg.status_sql (p_fact_name => l_mv,
1435: p_where_clause => l_where_clause,
1436: p_join_tables => l_join_tbl,
1437: p_use_windowing => 'Y',
1438: p_col_name => l_col_tbl,