View: AS_INTEREST_STATUSES_V

Product:	AS - Sales Foundation
Description:	Interest statuses view
Implementation/DBA Data:	APPS.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