DBA Data[Home] [Help]

APPS.WSH_ITM_RESPONSE_PKG dependencies on WSH_ITM_RESPONSE_HEADERS

Line 63: WSH_ITM_RESPONSE_HEADERS WRH,

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

Line 242: WSH_ITM_RESPONSE_HEADERS wrh,

238: SELECT
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

Line 255: WSH_ITM_RESPONSE_HEADERS wrh,

251: SELECT
252: DISTINCT wrc.request_control_id
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