APPS.OPI_DBI_INV_MGMT_RPT_PKG dependencies on POA_DBI_TEMPLATE_PKG

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

122:
123: -- construct the query
124: l_query := get_inv_val_status_sel_clause (l_view_by, l_join_tbl)
125: || ' from
126: ' || poa_dbi_template_pkg.status_sql (p_fact_name => l_mv,
127: p_where_clause => l_where_clause,
128: p_join_tables => l_join_tbl,
129: p_use_windowing => 'Y',
130: p_col_name => l_col_tbl,

Line 448: poa_dbi_template_pkg.trend_sql (

444:
445: -- Joining Outer and Inner Query
446: l_query := get_inv_val_trend_sel_clause(l_view_by) ||
447: ' from ' ||
448: poa_dbi_template_pkg.trend_sql (
449: l_xtd,
450: l_comparison_type,
451: l_mv,
452: l_where_clause,

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

600:
601: -- construct the query
602: l_query := get_onhand_sel_clause (l_view_by, l_join_tbl)
603: || ' from
604: ' || poa_dbi_template_pkg.status_sql (p_fact_name => l_mv,
605: p_where_clause => l_where_clause,
606: p_join_tables => l_join_tbl,
607: p_use_windowing => 'Y',
608: p_col_name => l_col_tbl,

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

808:
809: -- construct the query
810: l_query := get_intransit_sel_clause (l_view_by, l_join_tbl)
811: || ' from
812: ' || poa_dbi_template_pkg.status_sql (p_fact_name => l_mv,
813: p_where_clause => l_where_clause,
814: p_join_tables => l_join_tbl,
815: p_use_windowing => 'Y',
816: p_col_name => l_col_tbl,