APPS.CSP_SUPPLY_DEMAND_PVT dependencies on CSP_SUP_DEM_SUBS

Line 1274: from csp_sup_dem_subs

1270: move_orders_in,
1271: move_orders_out,
1272: work_orders,
1273: excess_quantity
1274: from csp_sup_dem_subs
1275: where nvl(level_id,'a') not like g_level_id||'%';
1276: end mv_to_temp;
1277:
1278: --------------------------------------------------------------------

Line 1320: from csp_sup_dem_subs

1316: sum(nvl(interorg_transf_out,0)),
1317: sum(nvl(move_orders_in,0)),
1318: sum(nvl(move_orders_out,0)),
1319: sum(nvl(work_orders,0))
1320: from csp_sup_dem_subs
1321: where hierarchy_node_id > 0
1322: group by
1323: inventory_item_id,
1324: hierarchy_node_id;

Line 1418: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_oracle_schema||'.CSP_SUP_DEM_SUBS';

1414: end update_hierarchy;
1415:
1416: procedure summarize_information is
1417: begin
1418: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_oracle_schema||'.CSP_SUP_DEM_SUBS';
1419: insert into csp_sup_dem_subs(
1420: inventory_item_id,
1421: organization_id,
1422: parts_loop_id,

Line 1419: insert into csp_sup_dem_subs(

1415:
1416: procedure summarize_information is
1417: begin
1418: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_oracle_schema||'.CSP_SUP_DEM_SUBS';
1419: insert into csp_sup_dem_subs(
1420: inventory_item_id,
1421: organization_id,
1422: parts_loop_id,
1423: hierarchy_node_id,

Line 1503: from csp_sup_dem_subs

1499: sum(nvl(interorg_transf_out,0)) interorg_transf_out,
1500: sum(nvl(move_orders_in,0)) move_orders_in,
1501: sum(nvl(move_orders_out,0)) move_orders_out,
1502: sum(nvl(work_orders,0)) work_orders
1503: from csp_sup_dem_subs
1504: where parts_loop_id > 0
1505: group by
1506: inventory_item_id,
1507: parts_loop_id;

Line 1551: from csp_sup_dem_subs csdsm,

1547: sum(nvl(csdsm.move_orders_in,0)) move_orders_in,
1548: sum(nvl(csdsm.move_orders_out,0)) move_orders_out,
1549: sum(nvl(csdsm.work_orders,0)) work_orders,
1550: sum(nvl(csdsm.excess_quantity,0)) excess_quantity
1551: from csp_sup_dem_subs csdsm,
1552: csp_planning_parameters cpp
1553: where csdsm.level_id like cpp.level_id||'%'
1554: group by
1555: csdsm.inventory_item_id,