[Home] [Help] [Dependency Information]
Object Name: | ENG_LIFECYCLE_STATUSES# |
---|---|
Object Type: | VIEW |
Owner: | ENG |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CHANGE_LIFECYCLE_STATUS_ID | NUMBER | Yes | ||
ENTITY_NAME | VARCHAR2 | (30) | Yes | |
ENTITY_ID1 | NUMBER | |||
ENTITY_ID2 | NUMBER | |||
ENTITY_ID3 | NUMBER | |||
ENTITY_ID4 | NUMBER | |||
ENTITY_ID5 | NUMBER | |||
SEQUENCE_NUMBER | NUMBER | |||
STATUS_CODE | NUMBER | |||
START_DATE | DATE | |||
COMPLETION_DATE | DATE | |||
CHANGE_WF_ROUTE_ID | NUMBER | |||
AUTO_PROMOTE_STATUS | NUMBER | |||
AUTO_DEMOTE_STATUS | NUMBER | |||
WORKFLOW_STATUS | VARCHAR2 | (30) | ||
CHANGE_EDITABLE_FLAG | VARCHAR2 | (1) | ||
CREATION_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | Yes | ||
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | |||
ITERATION_NUMBER | NUMBER | Yes | ||
ACTIVE_FLAG | VARCHAR2 | (1) | Yes | |
WF_SIG_POLICY | VARCHAR2 | (30) | ||
CHANGE_WF_ROUTE_TEMPLATE_ID | NUMBER | |||
ZD_EDITION_NAME | VARCHAR2 | (30) | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT CHANGE_LIFECYCLE_STATUS_ID
, ENTITY_NAME
, ENTITY_ID1
, ENTITY_ID2
, ENTITY_ID3
, ENTITY_ID4
, ENTITY_ID5
, SEQUENCE_NUMBER
, STATUS_CODE
, START_DATE
, COMPLETION_DATE
, CHANGE_WF_ROUTE_ID
, AUTO_PROMOTE_STATUS
, AUTO_DEMOTE_STATUS
, WORKFLOW_STATUS
, CHANGE_EDITABLE_FLAG
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, ITERATION_NUMBER
, ACTIVE_FLAG
, WF_SIG_POLICY
, CHANGE_WF_ROUTE_TEMPLATE_ID
, ZD_EDITION_NAME
FROM ENG.ENG_LIFECYCLE_STATUSES#;
|
|
|