APPS.INVPVDR5 dependencies on MTL_ITEM_SUB_INVENTORIES

Line 1261: from MTL_SECONDARY_INVENTORIES s, MTL_ITEM_SUB_INVENTORIES i

1257:
1258: if ( l_source_restrict_sub = 1 ) then
1259: begin
1260: select 'x' into temp
1261: from MTL_SECONDARY_INVENTORIES s, MTL_ITEM_SUB_INVENTORIES i
1262: where s.SECONDARY_INVENTORY_NAME = cr.SOURCE_SUBINVENTORY
1263: and s.ORGANIZATION_ID = cr.SOURCE_ORGANIZATION_ID
1264: and nvl(s.DISABLE_DATE, sysdate + 1 ) > sysdate
1265: and i.INVENTORY_ITEM_ID = cr.INVENTORY_ITEM_ID

Line 1460: FROM MTL_ITEM_SUB_INVENTORIES i

1456: l_message_name := 'INV_IOI_WIP_SUP_SUB';
1457: ELSIF cr.RESTRICT_SUBINVENTORIES_CODE = 1 AND cr.TRANSACTION_TYPE ='UPDATE' THEN
1458: BEGIN
1459: SELECT 'x' INTO temp
1460: FROM MTL_ITEM_SUB_INVENTORIES i
1461: WHERE i.inventory_item_id = cr.inventory_item_id
1462: AND i.ORGANIZATION_ID = cr.ORGANIZATION_ID
1463: AND i.SECONDARY_INVENTORY = cr.WIP_SUPPLY_SUBINVENTORY;
1464: EXCEPTION