DBA Data[Home] [Help]

VIEW: APPS.VEA_RELEASE_EXCEPTION_V

Source

View Text - Preformatted

SELECT R.LAYER_PROVIDER_CODE, R.TP_LAYER_ID, R.RELEASE_ID, R.APPLICATION_SHORT_NAME, R.FILE_PATH, R.FILE_NAME, E.MESSAGE_TEXT FROM VEA_RELEASE_DETAILS R, VEA_EXCEPTIONS E WHERE R.RELEASE_ID = E.RELEASE_ID AND R.LAYER_PROVIDER_CODE = E.LAYER_PROVIDER_CODE
View Text - HTML Formatted

SELECT R.LAYER_PROVIDER_CODE
, R.TP_LAYER_ID
, R.RELEASE_ID
, R.APPLICATION_SHORT_NAME
, R.FILE_PATH
, R.FILE_NAME
, E.MESSAGE_TEXT
FROM VEA_RELEASE_DETAILS R
, VEA_EXCEPTIONS E
WHERE R.RELEASE_ID = E.RELEASE_ID
AND R.LAYER_PROVIDER_CODE = E.LAYER_PROVIDER_CODE