[Home] [Help]
View: AS_INTEREST_STATUSES_ACTIVE_V
View Text
SELECT ISTAT.INTEREST_TYPE_ID
, ISTAT.INTEREST_STATUS_CODE
, ISTAT.LAST_UPDATE_DATE
, ISTAT.LAST_UPDATED_BY
, ISTAT.CREATION_DATE
, ISTAT.LAST_UPDATE_LOGIN
, ASLKP.MEANING
, ASLKP.DESCRIPTION
FROM AS_LOOKUPS ASLKP
, AS_INTEREST_STATUSES ISTAT
WHERE ISTAT.INTEREST_STATUS_CODE = ASLKP.LOOKUP_CODE
AND ASLKP.LOOKUP_TYPE = 'INTEREST_STATUS'
AND ISTAT.ENABLED_FLAG = 'Y'
Columns
Name |
INTEREST_TYPE_ID |
INTEREST_STATUS_CODE |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
CREATION_DATE |
LAST_UPDATE_LOGIN |
INTEREST_STATUS |
DESCRIPTION |