DBA Data[Home] [Help]

APPS.WIP_COMPONENT dependencies on MTL_SECONDARY_LOCATORS

Line 297: FROM MTL_SECONDARY_LOCATORS msl

293: SELECT decode(count(*),0,valid_flag,'N') INTO valid_flag
294: FROM DUAL
295: WHERE NOT EXISTS
296: (SELECT 1
297: FROM MTL_SECONDARY_LOCATORS msl
298: WHERE msl.inventory_item_id = p_item_id
299: AND msl.secondary_locator = p_locator_id
300: AND msl.organization_id = p_org_id);
301: END IF;