eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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:	ENG.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:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
ENG_LIFECYCLE_STATUSES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	CHANGE_LIFECYCLE_STATUS_ID
ENG_LIFECYCLE_STATUSES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ENTITY_NAME ENTITY_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

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
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:

APPS: ENG_LIFECYCLE_STATUSES