DBA Data[Home] [Help] [Dependency Information]

TABLE: ENG.ENG_LIFECYCLE_STATUSES

Object Details
Object Name: ENG_LIFECYCLE_STATUSES
Object Type: TABLE
Owner: ENG
FND Design Data: TableENG.ENG_LIFECYCLE_STATUSES
Subobject Name:
Status: VALID


Stores the statuses of lifecycle.Lifecycle phases can have multiple item statuses.Status_code column refers to ENG_CHANGE_STATUSES.STATUS_CODE.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
ENG_LIFECYCLE_STATUSES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnCHANGE_LIFECYCLE_STATUS_ID
ColumnZD_EDITION_NAME
ENG_LIFECYCLE_STATUSES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnENTITY_NAME
ColumnENTITY_ID1
Columns
Name Datatype Length Mandatory Comments
CHANGE_LIFECYCLE_STATUS_ID NUMBER
Yes Change lifecycle status internal id
ENTITY_NAME VARCHAR2 (30) Yes Name of the entity
ENTITY_ID1 NUMBER

Primary key of the entity
ENTITY_ID2 NUMBER

Primary key of the entity
ENTITY_ID3 NUMBER

Primary key of the entity
ENTITY_ID4 NUMBER

Primary key of the entity
ENTITY_ID5 NUMBER

Primary key of the entity
SEQUENCE_NUMBER NUMBER

Sequence number of the lifecycle status
STATUS_CODE NUMBER

Status code
START_DATE DATE

Start date
COMPLETION_DATE DATE

End date
CHANGE_WF_ROUTE_ID NUMBER

Change workflow route internal id
AUTO_PROMOTE_STATUS NUMBER

Flag to indicate if the status should be automatically promoted to the next status
AUTO_DEMOTE_STATUS NUMBER

Flag to indicate if the status should be automatically demoted to the next status
WORKFLOW_STATUS VARCHAR2 (30)
Status of the workflow
CHANGE_EDITABLE_FLAG VARCHAR2 (1)
Change editable flag
CREATION_DATE DATE
Yes Standard WHO column
CREATED_BY NUMBER
Yes Standard WHO column
LAST_UPDATE_DATE DATE
Yes Standard WHO column
LAST_UPDATED_BY NUMBER
Yes Standard WHO column
LAST_UPDATE_LOGIN NUMBER

Standard WHO column
ITERATION_NUMBER NUMBER
Yes ITERATION_NUMBER
ACTIVE_FLAG VARCHAR2 (1) Yes Flag to indicate if the status is active
WF_SIG_POLICY VARCHAR2 (30)
WF_SIG_FLAG
CHANGE_WF_ROUTE_TEMPLATE_ID NUMBER

Workflow Route template internal id
ZD_EDITION_NAME VARCHAR2 (30) Yes
Query Text

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;

Dependencies

[top of page]

ENG.ENG_LIFECYCLE_STATUSES does not reference any database object

ENG.ENG_LIFECYCLE_STATUSES is referenced by following:

SchemaENG
ViewENG_LIFECYCLE_STATUSES#