DBA Data[Home] [Help]

APPS.WSH_ITM_RESPONSE_PKG dependencies on WSH_ITM_RESPONSE_HEADERS

Line 65: WSH_ITM_RESPONSE_HEADERS WRH,

61: wrr.interpreted_value_code,
62: wrh.EXPORT_COMPLIANCE_STATUS,
63: wrh.SERVICE_TYPE_CODE
64: FROM WSH_ITM_REQUEST_CONTROL WRC,
65: WSH_ITM_RESPONSE_HEADERS WRH,
66: WSH_ITM_RESPONSE_RULES WRR
67: WHERE wrc.request_control_id = req_control_id
68: AND wrc.response_header_id = wrh.response_header_id
69: AND nvl(wrh.error_code,-99) = nvl(wrr.error_code,nvl(wrh.error_code,-99))

Line 251: WSH_ITM_RESPONSE_HEADERS wrh,

247: SELECT
248: DISTINCT wrc.request_control_id
249: FROM
250: WSH_ITM_REQUEST_CONTROL wrc,
251: WSH_ITM_RESPONSE_HEADERS wrh,
252: WSH_ITM_PARTIES wp
253: WHERE
254: wrc.response_header_id = wrh.response_header_id
255: AND wrc.request_control_id = wp.request_control_id

Line 264: WSH_ITM_RESPONSE_HEADERS wrh,

260: SELECT
261: DISTINCT wrc.request_control_id
262: FROM
263: WSH_ITM_REQUEST_CONTROL wrc,
264: WSH_ITM_RESPONSE_HEADERS wrh,
265: WSH_ITM_RESPONSE_LINES wrl,
266: WSH_ITM_PARTIES wp
267: WHERE
268: wrc.response_header_id = wrh.response_header_id