[Home] [Help]
View: WSH_ITM_RESPONSE_RULES_V
View Text
SELECT WRR.ROWID
, WRR.VENDOR_ID
, WIV.SERVICE_PROVIDER
, WRR.ERROR_TYPE
, WRR.ERROR_CODE
, WRR.INTERPRETED_VALUE_CODE
, WL.MEANING
, WRR.LAST_UPDATE_DATE
, WRR.LAST_UPDATED_BY
, WRR.CREATION_DATE
, WRR.CREATED_BY
, WRR.LAST_UPDATE_LOGIN
FROM WSH_ITM_RESPONSE_RULES WRR
, WSH_ITM_VENDORS WIV
, WSH_LOOKUPS WL
WHERE WIV.VENDOR_ID = WRR.VENDOR_ID
AND WL.LOOKUP_TYPE = 'WSH_ITM_ERROR_INTERPRETATION'
AND WL.LOOKUP_CODE = WRR.INTERPRETED_VALUE_CODE
Columns
Name |
ROW_ID |
VENDOR_ID |
VENDOR |
ERROR_TYPE |
ERROR_CODE |
INTERPRETED_VALUE_CODE |
INTERPRETED_VALUE_MEANING |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
CREATION_DATE |
CREATED_BY |
LAST_UPDATE_LOGIN |