Product: | AMS - Marketing |
---|---|
Description: | This view returns information on User statuses defined for System Statuses for Marketing Objects(Event,Registration,Campaign etc..) |
Implementation/DBA Data: | APPS.AMS_USER_STATUSES_V |
SELECT AUS.USER_STATUS_ID
, AUS.OBJECT_VERSION_NUMBER
, AUS.SYSTEM_STATUS_TYPE
, LKT.MEANING
, AUS.SYSTEM_STATUS_CODE
, LKUP.MEANING
, AUS.NAME
, AUS.DESCRIPTION
, AUS.ENABLED_FLAG
, AUS.SEEDED_FLAG
, AUS.DEFAULT_FLAG
, AUS.START_DATE_ACTIVE
, AUS.END_DATE_ACTIVE
FROM AMS_USER_STATUSES_VL AUS
, AMS_LOOKUPS LKUP
, FND_LOOKUP_TYPES_VL LKT
WHERE AUS.SYSTEM_STATUS_TYPE=LKT.LOOKUP_TYPE
AND AUS.SYSTEM_STATUS_TYPE=LKUP.LOOKUP_TYPE
AND AUS.SYSTEM_STATUS_CODE=LKUP.LOOKUP_CODE