VIEW: APPS.WSH_ITM_RESPONSE_V

Source

View Text - Preformatted

SELECT wrc.original_system_reference, wrc.original_system_line_reference, wrc.process_flag, wrc.ship_from_country_code, wrc.transaction_date, wrc.application_id, h.response_header_id, h.request_control_id, h.vendor_id, h.message_id, h.response_date Response_Date, h.error_type H_Error_Type, h.error_code H_Error_Code, h.error_text H_Error_Text, h.export_compliance_status, l.export_compliance_success, l.export_compliance_type, l.export_compliance_description, l.response_line_id, l.error_type L_Error_Type, l.error_code L_Error_Code, l.error_text L_Error_Text, l.party_id, nvl(l.service_type_code,h.service_type_code) Service_Type_Code, l.denied_party_flag Denied_Party_Flag, l.Embargo_flag Embargo_Flag, l.Red_Flag_words FROM WSH_ITM_REQUEST_CONTROL wrc, WSH_ITM_RESPONSE_HEADERS h, WSH_ITM_RESPONSE_LINES l WHERE wrc.response_header_id = h.response_header_id and h.response_header_id = l.response_header_id(+)

View Text - HTML Formatted

SELECT WRC.ORIGINAL_SYSTEM_REFERENCE
, WRC.ORIGINAL_SYSTEM_LINE_REFERENCE
, WRC.PROCESS_FLAG
, WRC.SHIP_FROM_COUNTRY_CODE
, WRC.TRANSACTION_DATE
, WRC.APPLICATION_ID
, H.RESPONSE_HEADER_ID
, H.REQUEST_CONTROL_ID
, H.VENDOR_ID
, H.MESSAGE_ID
, H.RESPONSE_DATE RESPONSE_DATE
, H.ERROR_TYPE H_ERROR_TYPE
, H.ERROR_CODE H_ERROR_CODE
, H.ERROR_TEXT H_ERROR_TEXT
, H.EXPORT_COMPLIANCE_STATUS
, L.EXPORT_COMPLIANCE_SUCCESS
, L.EXPORT_COMPLIANCE_TYPE
, L.EXPORT_COMPLIANCE_DESCRIPTION
, L.RESPONSE_LINE_ID
, L.ERROR_TYPE L_ERROR_TYPE
, L.ERROR_CODE L_ERROR_CODE
, L.ERROR_TEXT L_ERROR_TEXT
, L.PARTY_ID
, NVL(L.SERVICE_TYPE_CODE
, H.SERVICE_TYPE_CODE) SERVICE_TYPE_CODE
, L.DENIED_PARTY_FLAG DENIED_PARTY_FLAG
, L.EMBARGO_FLAG EMBARGO_FLAG
, L.RED_FLAG_WORDS
FROM WSH_ITM_REQUEST_CONTROL WRC
, WSH_ITM_RESPONSE_HEADERS H
, WSH_ITM_RESPONSE_LINES L
WHERE WRC.RESPONSE_HEADER_ID = H.RESPONSE_HEADER_ID
AND H.RESPONSE_HEADER_ID = L.RESPONSE_HEADER_ID(+)