239: DISTINCT wrc.request_control_id
240: FROM
241: WSH_ITM_REQUEST_CONTROL wrc,
242: WSH_ITM_RESPONSE_HEADERS wrh,
243: WSH_ITM_PARTIES wp
244: WHERE
245: wrc.response_header_id = wrh.response_header_id
246: AND wrc.request_control_id = wp.request_control_id
247: AND wrc.original_system_reference = nvl(p_reference_id, wrc.original_system_reference)
253: FROM
254: WSH_ITM_REQUEST_CONTROL wrc,
255: WSH_ITM_RESPONSE_HEADERS wrh,
256: WSH_ITM_RESPONSE_LINES wrl,
257: WSH_ITM_PARTIES wp
258: WHERE
259: wrc.response_header_id = wrh.response_header_id
260: AND wrh.response_header_id = wrl.response_header_id
261: AND wrc.request_control_id = wp.request_control_id