APPS.WIP_WS_SHORTAGE dependencies on WIP_WS_CRITICAL_COMP_TEMP

Line 447: insert into wip_ws_critical_comp_temp

443: p_subinv_code VARCHAR2 ,
444: p_locator_id NUMBER,
445: p_avail_qty NUMBER) IS
446: BEGIN
447: insert into wip_ws_critical_comp_temp
448: (organization_id,
449: inventory_item_id,
450: supply_subinventory,
451: supply_locator_id,

Line 1818: from wip_ws_critical_comp_temp

1814: */
1815: PROCEDURE calc_expected_receipts(p_org_id NUMBER, p_rcpt_date DATE) IS
1816: CURSOR comp IS
1817: select inventory_item_id
1818: from wip_ws_critical_comp_temp
1819: where organization_id = p_org_id
1820: and supply_subinventory is null;
1821: l_rcpt NUMBER;
1822:

Line 1828: update wip_ws_critical_comp_temp

1824: wip_ws_util.trace_log('WIP_WS_SHORTAGE:calc_expected_receipts:Entered');
1825: for c_comp in comp LOOP
1826: l_rcpt := calc_expected_receipts(p_org_id, c_comp.inventory_item_id, p_rcpt_date);
1827: if(nvl(l_rcpt, -1) < 0) then l_rcpt := 0; end if;
1828: update wip_ws_critical_comp_temp
1829: set PROJECTED_AVAIL_QTY = PROJECTED_AVAIL_QTY + l_rcpt
1830: where organization_id = p_org_id
1831: and inventory_item_id = c_comp.inventory_item_id
1832: and supply_subinventory is null;

Line 2223: from wip_ws_critical_comp_temp

2219: inventory_item_id,
2220: supply_subinventory,
2221: nvl(onhand_qty,0) onhand_qty,
2222: nvl(projected_avail_qty,0) projected_avail_qty
2223: from wip_ws_critical_comp_temp
2224: where organization_id = p_org_id
2225: and inventory_item_id = l_inv_item_id
2226: and nvl(supply_subinventory, 'NULL') = nvl(l_supply_subinv, 'NULL');
2227:

Line 2315: update wip_ws_critical_comp_temp

2311: end if;
2312: end if;
2313: wip_ws_util.trace_log('WIP_WS_SHORTAGE:calc_comp_shortage: after consumption projected_avail='||l_item_project_avail_qty||', onhand='||l_item_onhand_qty);
2314:
2315: update wip_ws_critical_comp_temp
2316: set projected_avail_qty = l_item_project_avail_qty
2317: where organization_id = p_org_id
2318: and inventory_item_id = l_inv_item_id
2319: and nvl(supply_subinventory, 'NULL') = nvl(l_supply_subinv, 'NULL');