APPS.OPI_DBI_WMS_STOR_UTZ_RPT_PKG dependencies on POA_DBI_TEMPLATE_PKG

Line 382: l_query := poa_dbi_template_pkg.status_sql (

378: -- Get the filtering clause
379: l_filter_clause := get_stor_tbl_filter_clause (l_view_by);
380:
381: -- The status query provided by POA
382: l_query := poa_dbi_template_pkg.status_sql (
383: p_fact_name => l_mv,
384: p_where_clause => l_where_clause,
385: p_join_tables => l_join_tbl,
386: p_use_windowing => 'Y',

Line 584: l_query := poa_dbi_template_pkg.trend_sql(

580: p_to_date_type => 'RLX');
581:
582:
583: -- The POA template central query
584: l_query := poa_dbi_template_pkg.trend_sql(
585: p_xtd => l_xtd,
586: p_comparison_type => l_comparison_type,
587: p_fact_name => l_mv,
588: p_where_clause => l_where_clause,

Line 1166: poa_dbi_template_pkg.status_sql (

1162: -- Get the item section of the status sql without the ranking
1163: -- clause. This inline view contains the utilization in
1164: -- each sub/org.
1165: l_item_inner_status_sql :=
1166: poa_dbi_template_pkg.status_sql (
1167: p_fact_name => l_item_mv,
1168: p_where_clause => l_item_where_clause,
1169: p_join_tables => l_join_tbl,
1170: p_use_windowing => 'Y',

Line 1183: poa_dbi_template_pkg.status_sql (

1179: -- Get the subinventory section of the status sql without
1180: -- the ranking clause. This inline view contains the
1181: -- capacity of each sub/org.
1182: l_sub_status_sql :=
1183: poa_dbi_template_pkg.status_sql (
1184: p_fact_name => l_sub_mv,
1185: p_where_clause => l_sub_where_clause,
1186: p_join_tables => l_join_tbl,
1187: p_use_windowing => 'Y',

Line 1198: poa_dbi_template_pkg.get_viewby_rank_clause (

1194:
1195: -- The outermost ranking/order by clause with
1196: -- the join to the dimension tables.
1197: l_viewby_rank_clause :=
1198: poa_dbi_template_pkg.get_viewby_rank_clause (
1199: p_join_tables => l_join_tbl,
1200: p_use_windowing => 'Y');
1201:
1202: -- Always outer join the item utilization inline view with the

Line 1305: poa_dbi_template_pkg.status_sql (

1301:
1302: -- The inner part of the query based only on the
1303: -- item fact
1304: l_item_inner_status_sql :=
1305: poa_dbi_template_pkg.status_sql (
1306: p_fact_name => l_item_mv,
1307: p_where_clause => l_item_where_clause,
1308: p_join_tables => l_join_tbl,
1309: p_use_windowing => 'Y',

Line 1319: poa_dbi_template_pkg.get_viewby_rank_clause (

1315: p_in_join_tables => NULL);
1316:
1317: -- The outer part of the join to the dimension tables
1318: l_viewby_rank_clause :=
1319: poa_dbi_template_pkg.get_viewby_rank_clause (
1320: p_join_tables => l_join_tbl,
1321: p_use_windowing => 'Y');
1322:
1323: