APPS.WIP_COMPONENT dependencies on DUAL

Line 190: FROM DUAL

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
191: WHERE
192: (EXISTS
193: (SELECT 1
194: FROM MTL_SYSTEM_ITEMS MSI

Line 210: FROM DUAL

206: -- If restricted sub, asset item, must be in MTL_ITEM_AST_TRK_SUB_VAL_V
207:
208: SELECT decode(count(*),0,valid_flag,'N')
209: INTO VALID_FLAG
210: FROM DUAL
211: WHERE
212: (EXISTS
213: (SELECT 1
214: FROM MTL_SYSTEM_ITEMS MSI

Line 230: FROM DUAL

226: -- Test non-restricted items
227:
228: SELECT decode(count(*),0,valid_flag,'N')
229: INTO VALID_FLAG
230: FROM DUAL
231: WHERE
232: NOT EXISTS
233: (SELECT 1
234: FROM MTL_SUBINVENTORIES_VAL_V MSVV,

Line 294: FROM DUAL

290: END IF;
291:
292: IF p_restrict_locators_code = 1 THEN
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