DBA Data[Home] [Help]

APPS.WIP_WS_UTIL dependencies on WIP_WS_COMP_SHORTAGE

Line 1409: from wip_ws_comp_shortage

1405: for all components not only the first component*/
1406: IF (l_shortage_calc_level = ORG_CALCULATION_LEVEL) THEN
1407: select decode(nvl(sum(shortage_qty),-1),-1,3,0,2,1)
1408: into l_comp_shortage
1409: from wip_ws_comp_shortage
1410: where wip_entity_id = p_wip_entity_id
1411: and organization_id = p_org_id
1412: and SUPPLY_SUBINVENOTRY is null;
1413:

Line 1419: from wip_ws_comp_shortage

1415: /* Bug 9221212 , remove rownum =1 as we should consider the shortage_qty
1416: for all components not only the first component*/
1417: select decode(nvl(sum(shortage_qty),-1),-1,3,0,2,1)
1418: into l_comp_shortage
1419: from wip_ws_comp_shortage
1420: where wip_entity_id = p_wip_entity_id
1421: and organization_id = p_org_id
1422: and SUPPLY_SUBINVENOTRY is not null;
1423: