[Home] [Help]
View: AS_INTEREST_STATUSES_V
View Text
SELECT INT.ROWID
, INT.INTEREST_TYPE_ID
, INT.INTEREST_STATUS_CODE
, INT.LAST_UPDATE_DATE
, INT.LAST_UPDATED_BY
, INT.CREATION_DATE
, INT.CREATED_BY
, INT.LAST_UPDATE_LOGIN
, INT.ENABLED_FLAG
, LOOK.MEANING
, LOOK.DESCRIPTION
FROM AS_LOOKUPS LOOK
, AS_INTEREST_STATUSES INT
WHERE INT.INTEREST_STATUS_CODE = LOOK.LOOKUP_CODE
AND LOOK.LOOKUP_TYPE = 'INTEREST_STATUS'
Columns
Name |
ROW_ID |
INTEREST_TYPE_ID |
INTEREST_STATUS_CODE |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
CREATION_DATE |
CREATED_BY |
LAST_UPDATE_LOGIN |
ENABLED_FLAG |
INTEREST_STATUS |
DESCRIPTION |