APPS.WIP_COMPONENT dependencies on MTL_ITEM_SUB_VAL_V

Line 186: -- If restricted sub, non-asset item, must be in MTL_ITEM_SUB_VAL_V

182: IF p_subinventory IS NULL THEN
183: valid_flag := 'N';
184: END IF;
185:
186: -- If restricted sub, non-asset item, must be in MTL_ITEM_SUB_VAL_V
187:
188: SELECT decode(count(*),0,valid_flag,'N')
189: INTO VALID_FLAG
190: FROM DUAL

Line 201: FROM MTL_ITEM_SUB_VAL_V MSVV

197: AND MSI.RESTRICT_SUBINVENTORIES_CODE = 1
198: AND MSI.INVENTORY_ASSET_FLAG = 'N')
199: AND NOT EXISTS
200: (SELECT 1
201: FROM MTL_ITEM_SUB_VAL_V MSVV
202: WHERE MSVV.ORGANIZATION_ID = p_org_id
203: AND MSVV.INVENTORY_ITEM_ID = p_item_id
204: AND MSVV.SECONDARY_INVENTORY_NAME = p_subinventory));
205: