View: EAM_SAF_WO_CONCAT_STATUSES_VL

Product:	EAM - Enterprise Asset Management
Description:	This view unions the Permit statuses, work clearance statuses, isolation statuses and Work Order statuses
Implementation/DBA Data:	APPS.EAM_SAF_WO_CONCAT_STATUSES_VL

View Text

SELECT ROW_ID
, STATUS_ID
, SYSTEM_STATUS
, PERMIT_STATUS AS USER_DEFINED_STATUS
, SYSTEM_STATUS_DESC
, SEEDED_FLAG
, ENABLED_FLAG
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, 'PERMIT'
FROM EAM_PERMIT_STATUSES_VL UNION ALL SELECT ROW_ID
, STATUS_ID
, SYSTEM_STATUS
, WORK_CLEARANCE_STATUS AS USER_DEFINED_STATUS
, SYSTEM_STATUS_DESC
, SEEDED_FLAG
, ENABLED_FLAG
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, 'WORK_CLEARANCE' AS REF_TYPE
FROM EAM_WORK_CLEARANCE_STATUSES_VL UNION ALL SELECT ROW_ID
, STATUS_ID
, SYSTEM_STATUS
, ISOLATION_STATUS AS USER_DEFINED_STATUS
, SYSTEM_STATUS_DESC
, SEEDED_FLAG
, ENABLED_FLAG
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, 'ISOLATION' AS REF_TYPE
FROM EAM_ISOLATION_STATUSES_VL UNION ALL SELECT ROW_ID
, STATUS_ID
, SYSTEM_STATUS
, WORK_ORDER_STATUS AS USER_DEFINED_STATUS
, SYSTEM_STATUS_DESC
, SEEDED_FLAG
, ENABLED_FLAG
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, 'WORK_ORDER'
FROM EAM_WO_STATUSES_VL

Columns