[Home] [Help]
View: BIM_DIMV_USER_STATUSES
Product: | BIM - Marketing Intelligence(Obsolete) |
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
Name |
USER_STATUS_ID |
SYSTEM_STATUS_TYPE |
SYSTEM_STATUS_CODE |
ENABLED_FLAG |
START_DATE_ACTIVE |
END_DATE_ACTIVE |
STATUS_NAME |
DESCRIPTION |