APPS.OE_CANSRV dependencies on MTL_SYSTEM_ITEMS

Line 590: FROM MTL_SYSTEM_ITEMS MSI

586: AND (S4 + 0 IN (5, 7, 22, 8)
587: OR S29 + 0 IN (14, 16, 8))
588: AND EXISTS
589: (SELECT 'NON SHIPPABLE ITEM'
590: FROM MTL_SYSTEM_ITEMS MSI
591: WHERE MSI.ORGANIZATION_ID = l_org_id
592: AND MSI.INVENTORY_ITEM_ID = SO_LINES.INVENTORY_ITEM_ID
593: AND MSI.SHIPPABLE_ITEM_FLAG = 'N');
594: