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