VIEW: ENG.ENG_LIFECYCLE_STATUSES#

Source

View Text - Preformatted

select CHANGE_LIFECYCLE_STATUS_ID CHANGE_LIFECYCLE_STATUS_ID, ENTITY_NAME ENTITY_NAME, ENTITY_ID1 ENTITY_ID1, ENTITY_ID2 ENTITY_ID2, ENTITY_ID3 ENTITY_ID3, ENTITY_ID4 ENTITY_ID4, ENTITY_ID5 ENTITY_ID5, SEQUENCE_NUMBER SEQUENCE_NUMBER, STATUS_CODE STATUS_CODE, START_DATE START_DATE, COMPLETION_DATE COMPLETION_DATE, CHANGE_WF_ROUTE_ID CHANGE_WF_ROUTE_ID, AUTO_PROMOTE_STATUS AUTO_PROMOTE_STATUS, AUTO_DEMOTE_STATUS AUTO_DEMOTE_STATUS, WORKFLOW_STATUS WORKFLOW_STATUS, CHANGE_EDITABLE_FLAG CHANGE_EDITABLE_FLAG, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, ITERATION_NUMBER ITERATION_NUMBER, ACTIVE_FLAG ACTIVE_FLAG, WF_SIG_POLICY WF_SIG_POLICY, CHANGE_WF_ROUTE_TEMPLATE_ID CHANGE_WF_ROUTE_TEMPLATE_ID, ZD_EDITION_NAME ZD_EDITION_NAME from "ENG"."ENG_LIFECYCLE_STATUSES"

View Text - HTML Formatted

SELECT CHANGE_LIFECYCLE_STATUS_ID CHANGE_LIFECYCLE_STATUS_ID
, ENTITY_NAME ENTITY_NAME
, ENTITY_ID1 ENTITY_ID1
, ENTITY_ID2 ENTITY_ID2
, ENTITY_ID3 ENTITY_ID3
, ENTITY_ID4 ENTITY_ID4
, ENTITY_ID5 ENTITY_ID5
, SEQUENCE_NUMBER SEQUENCE_NUMBER
, STATUS_CODE STATUS_CODE
, START_DATE START_DATE
, COMPLETION_DATE COMPLETION_DATE
, CHANGE_WF_ROUTE_ID CHANGE_WF_ROUTE_ID
, AUTO_PROMOTE_STATUS AUTO_PROMOTE_STATUS
, AUTO_DEMOTE_STATUS AUTO_DEMOTE_STATUS
, WORKFLOW_STATUS WORKFLOW_STATUS
, CHANGE_EDITABLE_FLAG CHANGE_EDITABLE_FLAG
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, ITERATION_NUMBER ITERATION_NUMBER
, ACTIVE_FLAG ACTIVE_FLAG
, WF_SIG_POLICY WF_SIG_POLICY
, CHANGE_WF_ROUTE_TEMPLATE_ID CHANGE_WF_ROUTE_TEMPLATE_ID
, ZD_EDITION_NAME ZD_EDITION_NAME
FROM "ENG"."ENG_LIFECYCLE_STATUSES"