VIEW: APPS.EAM_SAF_WO_CONCAT_STATUSES_VL

Source

View Text - Preformatted

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

View Text - HTML Formatted

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