Product: | WSH - Shipping Execution |
---|---|
Description: | |
Implementation/DBA Data: | APPS.WSH_ITM_RESPONSE_V |
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(+)