APPS.ISC_DEPOT_MARGIN_RPT_PKG dependencies on POA_DBI_TEMPLATE_PKG

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

107:
108: -- construct the query
109: l_query := get_ro_mrg_tbl_sel_clause (l_view_by, l_view_by_col)
110: || ' from
111: ' || poa_dbi_template_pkg.status_sql (p_fact_name => l_mv,
112: p_where_clause => l_where_clause,
113: p_join_tables => l_join_tbl,
114: p_use_windowing => 'Y',
115: p_col_name => l_col_tbl,

Line 342: poa_dbi_template_pkg.trend_sql (p_xtd => l_xtd,

338:
339: -- Joining Outer and Inner Query
340: l_query := get_ro_mrg_trd_sel_clause (l_view_by) ||
341: ' from ' ||
342: poa_dbi_template_pkg.trend_sql (p_xtd => l_xtd,
343: p_comparison_type => l_comparison_type,
344: p_fact_name => l_mv,
345: p_where_clause => l_where_clause,
346: p_col_name => l_col_tbl,

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

491:
492: -- construct the query
493: l_query := get_chg_summ_tbl_sel_clause (l_view_by, l_view_by_col)
494: || ' from
495: ' || poa_dbi_template_pkg.status_sql (p_fact_name => l_mv,
496: p_where_clause => l_where_clause,
497: p_join_tables => l_join_tbl,
498: p_use_windowing => 'Y',
499: p_col_name => l_col_tbl,

Line 700: poa_dbi_template_pkg.trend_sql (p_xtd => l_xtd,

696:
697: -- Joining Outer and Inner Query
698: l_query := get_chg_summ_trd_sel_clause (l_view_by) ||
699: ' from ' ||
700: poa_dbi_template_pkg.trend_sql (p_xtd => l_xtd,
701: p_comparison_type => l_comparison_type,
702: p_fact_name => l_mv,
703: p_where_clause => l_where_clause,
704: p_col_name => l_col_tbl,

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

844:
845: -- construct the query
846: l_query := get_cst_summ_tbl_sel_clause (l_view_by, l_view_by_col)
847: || ' from '
848: || poa_dbi_template_pkg.status_sql (p_fact_name => l_mv,
849: p_where_clause => l_where_clause,
850: p_join_tables => l_join_tbl,
851: p_use_windowing => 'Y',
852: p_col_name => l_col_tbl,

Line 1052: poa_dbi_template_pkg.trend_sql (p_xtd => l_xtd,

1048:
1049: -- Joining Outer and Inner Query
1050: l_query := get_cst_summ_trd_sel_clause (l_view_by) ||
1051: ' from ' ||
1052: poa_dbi_template_pkg.trend_sql (p_xtd => l_xtd,
1053: p_comparison_type => l_comparison_type,
1054: p_fact_name => l_mv,
1055: p_where_clause => l_where_clause,
1056: p_col_name => l_col_tbl,

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

1204: || 'OR nvl(labor_cost_' || l_cur_suffix || ', 0) > 0 OR nvl(expense_cost_' || l_cur_suffix || ', 0) > 0) ';
1205:
1206: l_query := get_mrg_summ_tbl_sel_clause (l_view_by, l_view_by_col)
1207: || ' from
1208: ' || poa_dbi_template_pkg.status_sql (p_fact_name => l_mv,
1209: p_where_clause => l_where_clause || l_supress,
1210: p_join_tables => l_join_tbl,
1211: p_use_windowing => 'Y',
1212: p_col_name => l_col_tbl,

Line 1417: poa_dbi_template_pkg.trend_sql (p_xtd => l_xtd,

1413:
1414: -- Joining Outer and Inner Query
1415: l_query := get_mrg_summ_trd_sel_clause (l_view_by) ||
1416: ' from ' ||
1417: poa_dbi_template_pkg.trend_sql (p_xtd => l_xtd,
1418: p_comparison_type => l_comparison_type,
1419: p_fact_name => l_mv,
1420: p_where_clause => l_where_clause,
1421: p_col_name => l_col_tbl,