APPS.WIP_WS_SHORTAGE dependencies on WIP_WS_CRITICAL_COMP_TEMP

Line 446: insert into wip_ws_critical_comp_temp

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

Line 1747: from wip_ws_critical_comp_temp

1743: */
1744: PROCEDURE calc_expected_receipts(p_org_id NUMBER, p_rcpt_date DATE) IS
1745: CURSOR comp IS
1746: select inventory_item_id
1747: from wip_ws_critical_comp_temp
1748: where organization_id = p_org_id
1749: and supply_subinventory is null;
1750: l_rcpt NUMBER;
1751:

Line 1757: update wip_ws_critical_comp_temp

1753: wip_ws_util.trace_log('WIP_WS_SHORTAGE:calc_expected_receipts:Entered');
1754: for c_comp in comp LOOP
1755: l_rcpt := calc_expected_receipts(p_org_id, c_comp.inventory_item_id, p_rcpt_date);
1756: if(nvl(l_rcpt, -1) < 0) then l_rcpt := 0; end if;
1757: update wip_ws_critical_comp_temp
1758: set PROJECTED_AVAIL_QTY = PROJECTED_AVAIL_QTY + l_rcpt
1759: where organization_id = p_org_id
1760: and inventory_item_id = c_comp.inventory_item_id
1761: and supply_subinventory is null;

Line 2152: from wip_ws_critical_comp_temp

2148: inventory_item_id,
2149: supply_subinventory,
2150: nvl(onhand_qty,0) onhand_qty,
2151: nvl(projected_avail_qty,0) projected_avail_qty
2152: from wip_ws_critical_comp_temp
2153: where organization_id = p_org_id
2154: and inventory_item_id = l_inv_item_id
2155: and nvl(supply_subinventory, 'NULL') = nvl(l_supply_subinv, 'NULL');
2156:

Line 2244: update wip_ws_critical_comp_temp

2240: end if;
2241: end if;
2242: 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);
2243:
2244: update wip_ws_critical_comp_temp
2245: set projected_avail_qty = l_item_project_avail_qty
2246: where organization_id = p_org_id
2247: and inventory_item_id = l_inv_item_id
2248: and nvl(supply_subinventory, 'NULL') = nvl(l_supply_subinv, 'NULL');