[Home] [Help]
View: AST_IH_CAMPAIGNS_RESULTS_VL
View Text
SELECT CR.ROWID
, CR.RESULT_ID
, CR.OBJECT_TYPE
, CR.OBJECT_ID
, 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
, R.RESULT_CODE
, R.SHORT_DESCRIPTION
, R.RESULT_REQUIRED
FROM JTF_IH_CAMPAIGNS_RESULTS CR
, JTF_IH_RESULTS_VL R
WHERE CR.RESULT_ID = R.RESULT_ID
Columns
Name |
ROW_ID |
RESULT_ID |
OBJECT_TYPE |
OBJECT_ID |
SOURCE_CODE_ID |
SOURCE_CODE |
OBJECT_VERSION_NUMBER |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATE_LOGIN |
RESULT_CODE |
SHORT_DESCRIPTION |
RESULT_REQUIRED |