[Home] [Help]
View: AST_IH_CAMP_RESULT_REASONS_VL
View Text
SELECT CR.ROWID
, CR.OBJECT_ID
, CR.OBJECT_TYPE
, CR.SOURCE_CODE_ID
, CR.SOURCE_CODE
, CR.OBJECT_VERSION_NUMBER
, CR.CREATED_BY
, CR.CREATION_DATE
, CR.LAST_UPDATED_BY
, CR.LAST_UPDATE_DATE
, CR.LAST_UPDATE_LOGIN
, CR.REASON_ID
, CR.RESULT_ID
, R.REASON_CODE
, R.SHORT_DESCRIPTION
FROM JTF_IH_CAMPAIGN_RESULT_REASONS CR
, JTF_IH_REASONS_VL R
WHERE CR.REASON_ID = R.REASON_ID
Columns
Name |
ROW_ID |
OBJECT_ID |
OBJECT_TYPE |
SOURCE_CODE_ID |
SOURCE_CODE |
OBJECT_VERSION_NUMBER |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATE_LOGIN |
REASON_ID |
RESULT_ID |
REASON_CODE |
SHORT_DESCRIPTION |