250: SELECT 'No PO/REQ Linked'
251: FROM DUAL
252: WHERE NOT EXISTS
253: (SELECT '1'
254: FROM PO_DISTRIBUTIONS_ALL PD,
255: WIP_SUB_OPERATION_RESOURCES WOR
256: /* Fixed bug 3115844 */
257: WHERE pd.po_line_id IS NOT NULL
258: AND pd.line_location_id IS NOT NULL
293: SELECT 'No PO/REQ Linked'
294: FROM DUAL
295: WHERE NOT EXISTS
296: (SELECT '1'
297: FROM PO_DISTRIBUTIONS_ALL PD,
298: WIP_SUB_OPERATION_RESOURCES WOR
299: /* Fixed bug 3115844 */
300: WHERE pd.po_line_id IS NOT NULL
301: AND pd.line_location_id IS NOT NULL