352: and (exists
353: ( SELECT 'PO/REQ Linked'
354: FROM PO_RELEASES_ALL PR,
355: PO_HEADERS_ALL PH,
356: PO_DISTRIBUTIONS_ALL PD,
357: PO_LINE_LOCATIONS_ALL PLL
358: WHERE pd.po_line_id IS NOT NULL
359: AND pd.line_location_id IS NOT NULL
360: AND PD.WIP_ENTITY_ID = p_wip_entity_id
468: and (exists
469: ( SELECT 'PO/REQ Linked'
470: FROM PO_RELEASES_ALL PR,
471: PO_HEADERS_ALL PH,
472: PO_DISTRIBUTIONS_ALL PD,
473: PO_LINE_LOCATIONS_ALL PLL
474: WHERE pd.po_line_id IS NOT NULL
475: AND pd.line_location_id IS NOT NULL
476: AND PD.WIP_ENTITY_ID = p_wip_entity_id