DBA Data[Home] [Help]

APPS.WIP_WS_UTIL dependencies on WIP_WS_COMP_SHORTAGE

Line 1366: from wip_ws_comp_shortage

1362: --Bug 6889755 - added IF condition and the ELSE block for subinv level check
1363: IF (l_shortage_calc_level = ORG_CALCULATION_LEVEL) THEN
1364: select decode(nvl(shortage_qty,-1),-1,3,0,2,1)
1365: into l_comp_shortage
1366: from wip_ws_comp_shortage
1367: where wip_entity_id = p_wip_entity_id
1368: and organization_id = p_org_id
1369: and SUPPLY_SUBINVENOTRY is null
1370: and rownum =1;

Line 1374: from wip_ws_comp_shortage

1370: and rownum =1;
1371: ELSIF (l_shortage_calc_level = SUBINV_CALCULATION_LEVEL) THEN
1372: select 1
1373: into l_comp_shortage
1374: from wip_ws_comp_shortage
1375: where wip_entity_id = p_wip_entity_id
1376: and organization_id = p_org_id
1377: and SUPPLY_SUBINVENOTRY is not null
1378: and shortage_qty > 0