APPS.INVPVDR5 dependencies on MTL_ITEM_SUB_INVENTORIES

Line 1232: from MTL_SECONDARY_INVENTORIES s, MTL_ITEM_SUB_INVENTORIES i

1228:
1229: if ( l_source_restrict_sub = 1 ) then
1230: begin
1231: select 'x' into temp
1232: from MTL_SECONDARY_INVENTORIES s, MTL_ITEM_SUB_INVENTORIES i
1233: where s.SECONDARY_INVENTORY_NAME = cr.SOURCE_SUBINVENTORY
1234: and s.ORGANIZATION_ID = cr.SOURCE_ORGANIZATION_ID
1235: and nvl(s.DISABLE_DATE, sysdate + 1 ) > sysdate
1236: and i.INVENTORY_ITEM_ID = cr.INVENTORY_ITEM_ID

Line 1431: FROM MTL_ITEM_SUB_INVENTORIES i

1427: l_message_name := 'INV_IOI_WIP_SUP_SUB';
1428: ELSIF cr.RESTRICT_SUBINVENTORIES_CODE = 1 AND cr.TRANSACTION_TYPE ='UPDATE' THEN
1429: BEGIN
1430: SELECT 'x' INTO temp
1431: FROM MTL_ITEM_SUB_INVENTORIES i
1432: WHERE i.inventory_item_id = cr.inventory_item_id
1433: AND i.ORGANIZATION_ID = cr.ORGANIZATION_ID
1434: AND i.SECONDARY_INVENTORY = cr.WIP_SUPPLY_SUBINVENTORY;
1435: EXCEPTION