View: BIM_DIMV_USER_STATUSES

Product:	BIM - Marketing Intelligence
Description:	Shows all user-defined statuses.
Implementation/DBA Data:	APPS.BIM_DIMV_USER_STATUSES

View Text

SELECT AUS.USER_STATUS_ID USER_STATUS_ID
, AUS.SYSTEM_STATUS_TYPE SYSTEM_STATUS_TYPE
, AUS.SYSTEM_STATUS_CODE SYSTEM_STATUS_CODE
, AUS.ENABLED_FLAG ENABLED_FLAG
, AUS.START_DATE_ACTIVE START_DATE_ACTIVE
, AUS.END_DATE_ACTIVE END_DATE_ACTIVE
, AUS.NAME STATUS_NAME
, AUS.DESCRIPTION DESCRIPTION
FROM AMS_USER_STATUSES_VL AUS WITH READ ONLY

Columns