DBA Data[Home] [Help]

APPS.OE_CANCEL dependencies on MTL_SYSTEM_ITEMS

Line 1144: FROM MTL_SYSTEM_ITEMS MSI

1140: AND (S4 + 0 IN (5, 7, 22, 8)
1141: OR S29 + 0 IN (14, 16, 8))
1142: AND EXISTS
1143: (SELECT 'NON SHIPPABLE ITEM'
1144: FROM MTL_SYSTEM_ITEMS MSI
1145: WHERE MSI.ORGANIZATION_ID = l_org_id
1146: AND MSI.INVENTORY_ITEM_ID = SO_LINES.INVENTORY_ITEM_ID
1147: AND MSI.SHIPPABLE_ITEM_FLAG = 'N');
1148: