[Home] [Help]
View: AHL_USER_STATUSES_V
Product: | AHL - Complex Maintenance Repair and Overhaul |
Description: | This view stores user status information along with lookup type and meaning |
Implementation/DBA Data: |
APPS.AHL_USER_STATUSES_V
|
View Text
SELECT USVL.USER_STATUS_ID USER_STATUS_ID
, USVL.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, USVL.SYSTEM_STATUS_TYPE SYSTEM_STATUS_TYPE
, USVL.SYSTEM_STATUS_CODE SYSTEM_STATUS_CODE
, USVL.ACTIVE_FLAG ACTIVE_FLAG
, USVL.DEFAULT_FLAG DEFAULT_FLAG
, USVL.SEEDED_FLAG SEEDED_FLAG
, USVL.START_DATE_ACTIVE START_DATE_ACTIVE
, USVL.END_DATE_ACTIVE END_DATE_ACTIVE
, USVL.NAME NAME
, USVL.DESCRIPTION DESCRIPTION
, FNDL.MEANING MEANING
, FNDV.MEANING CODE_MEANING
FROM AHL_USER_STATUSES_VL USVL
, FND_LOOKUP_TYPES_VL FNDL
, FND_LOOKUP_VALUES_VL FNDV
WHERE USVL.SYSTEM_STATUS_TYPE = FNDL.LOOKUP_TYPE
AND USVL.SYSTEM_STATUS_TYPE = FNDV.LOOKUP_TYPE
AND USVL.SYSTEM_STATUS_CODE = FNDV.LOOKUP_CODE
Columns
Name |
USER_STATUS_ID |
OBJECT_VERSION_NUMBER |
SYSTEM_STATUS_TYPE |
SYSTEM_STATUS_CODE |
ACTIVE_FLAG |
DEFAULT_FLAG |
SEEDED_FLAG |
START_DATE_ACTIVE |
END_DATE_ACTIVE |
NAME |
DESCRIPTION |
MEANING |
CODE_MEANING |