DBA Data[Home] [Help]

APPS.ISC_DEPOT_BACKLOG_PKG dependencies on POA_DBI_TEMPLATE_PKG

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

89:
90: l_query := GET_BACKLOG_TBL_SEL_CLAUSE ( p_view_by_dim => l_view_by
91: ,p_view_by_col => l_view_by_col)
92: || ' from
93: ' || poa_dbi_template_pkg.status_sql (p_fact_name => l_mv,
94: p_where_clause => l_where_clause,
95: p_join_tables => l_join_tbl,
96: p_use_windowing => 'Y',
97: p_col_name => l_col_tbl,

Line 378: ' || poa_dbi_template_pkg.trend_sql(p_xtd => l_xtd,

374: p_to_date_type => 'YTD');
375:
376: l_query := GET_BACKLOG_TRD_SEL_CLAUSE (l_view_by)
377: || ' from
378: ' || poa_dbi_template_pkg.trend_sql(p_xtd => l_xtd,
379: p_comparison_type => l_comparison_type,
380: p_fact_name => l_mv,
381: p_where_clause => l_where_clause,
382: p_col_name => l_col_tbl,

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

1099: l_where_clause := ' 1 = 1 ' || l_where_clause;
1100:
1101: l_query := GET_DAYS_UNTIL_PROM_SEL_CLAUSE (l_view_by,l_bucket_rec,l_view_by_col)
1102: || ' from
1103: ' || poa_dbi_template_pkg.status_sql (p_fact_name => l_mv,
1104: p_where_clause => l_where_clause,
1105: p_join_tables => l_join_tbl,
1106: p_use_windowing => 'Y',
1107: p_col_name => l_col_tbl,