APPS.CSP_SUPPLY_DEMAND_PVT dependencies on CSP_SUP_DEM_RH_TEMP

Line 1289: insert into csp_sup_dem_rh_temp(

1285: l_level number := 1;
1286: begin
1287: l_level := 1;
1288: --subinventories to parent
1289: insert into csp_sup_dem_rh_temp(
1290: level_id,
1291: organization_id,
1292: inventory_item_id,
1293: hierarchy_node_id,

Line 1327: insert into csp_sup_dem_rh_temp(

1323: inventory_item_id,
1324: hierarchy_node_id;
1325: loop
1326: -- node to parent
1327: insert into csp_sup_dem_rh_temp(
1328: level_id,
1329: organization_id,
1330: inventory_item_id,
1331: hierarchy_node_id,

Line 1358: from csp_sup_dem_rh_temp ctsd,

1354: sum(nvl(interorg_transf_out,0)),
1355: sum(nvl(move_orders_in,0)),
1356: sum(nvl(move_orders_out,0)),
1357: sum(nvl(work_orders,0))
1358: from csp_sup_dem_rh_temp ctsd,
1359: csp_rep_hierarchies crh
1360: where level_id = l_level
1361: and crh.hierarchy_node_id = ctsd.hierarchy_node_id
1362: and crh.parent_node_id > 0

Line 1405: from csp_sup_dem_rh_temp crsdt,

1401: sum(nvl(crsdt.interorg_transf_out,0)) interorg_transf_out,
1402: sum(nvl(crsdt.move_orders_in,0)) move_orders_in,
1403: sum(nvl(crsdt.move_orders_out,0)) move_orders_out,
1404: sum(nvl(crsdt.work_orders,0)) work_orders
1405: from csp_sup_dem_rh_temp crsdt,
1406: csp_rep_hierarchies crh
1407: where crh.hierarchy_node_id = crsdt.hierarchy_node_id
1408: group by
1409: crsdt.inventory_item_id,