78: UNION ALL
79: SELECT
80: PD.WIP_ENTITY_ID
81: FROM
82: PO_RELEASES_ALL PR,
83: PO_HEADERS_ALL PH,
84: PO_DISTRIBUTIONS_ALL PD,
85: PO_LINE_LOCATIONS_ALL PL
86: WHERE PD.DESTINATION_ORGANIZATION_ID = P_ORGANIZATION_ID
334: WHERE exists (
335: SELECT
336: 1
337: FROM
338: PO_RELEASES_ALL PR,
339: PO_HEADERS_ALL PH,
340: PO_DISTRIBUTIONS_ALL PD,
341: PO_LINE_LOCATIONS_ALL PL
342: WHERE PD.DESTINATION_ORGANIZATION_ID = P_ORGANIZATION_ID