Product: | AHL - Complex Maintenance Repair and Overhaul |
---|---|
Description: | This view stores user status information |
Implementation/DBA Data: | APPS.AHL_USER_STATUSES_VL |
SELECT USB.ROWID ROW_ID
, USB.USER_STATUS_ID
, USB.LAST_UPDATE_DATE
, USB.LAST_UPDATED_BY
, USB.CREATION_DATE
, USB.CREATED_BY
, USB.LAST_UPDATE_LOGIN
, USB.SYSTEM_STATUS_TYPE
, USB.SYSTEM_STATUS_CODE
, USB.ACTIVE_FLAG
, USB.DEFAULT_FLAG
, USB.SEEDED_FLAG
, USB.START_DATE_ACTIVE
, USB.END_DATE_ACTIVE
, UST.NAME
, UST.DESCRIPTION
, USB.OBJECT_VERSION_NUMBER
, USB.SECURITY_GROUP_ID
, USB.ATTRIBUTE_CATEGORY
, USB.ATTRIBUTE1
, USB.ATTRIBUTE2
, USB.ATTRIBUTE3
, USB.ATTRIBUTE4
, USB.ATTRIBUTE5
, USB.ATTRIBUTE6
, USB.ATTRIBUTE7
, USB.ATTRIBUTE8
, USB.ATTRIBUTE9
, USB.ATTRIBUTE10
, USB.ATTRIBUTE11
, USB.ATTRIBUTE12
, USB.ATTRIBUTE13
, USB.ATTRIBUTE14
, USB.ATTRIBUTE15
FROM AHL_USER_STATUSES_B USB
, AHL_USER_STATUSES_TL UST
WHERE USB.USER_STATUS_ID = UST.USER_STATUS_ID
AND UST.LANGUAGE = USERENV('LANG')