VIEW: APPS.AHL_USER_STATUSES_VL

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')