DBA Data[Home] [Help]

APPS.WIP_COMPONENT dependencies on MTL_SUBINVENTORIES_VAL_V

Line 234: FROM MTL_SUBINVENTORIES_VAL_V MSVV,

230: FROM DUAL
231: WHERE
232: NOT EXISTS
233: (SELECT 1
234: FROM MTL_SUBINVENTORIES_VAL_V MSVV,
235: MTL_SYSTEM_ITEMS MSI
236: WHERE MSVV.ORGANIZATION_ID = p_org_id
237: AND MSVV.SECONDARY_INVENTORY_NAME = p_subinventory
238: AND MSI.INVENTORY_ITEM_ID = p_item_id