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_PENDING_CHANGE_CTX

Object Details

Object Name:	ENG_PENDING_CHANGE_CTX
Object Type:	TABLE
Owner:	ENG
FND Design Data:	ENG.ENG_PENDING_CHANGE_CTX
Subobject Name:
Status:	VALID

ENG_PENDING_CHANGE_CTX stores related change information of attribute group types. Records in the table are identified by object_id, application_id, change_attribute_group_type.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
ENG_PENDING_CHANGE_CTX_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	OBJECT_ID APPLICATION_ID CHANGE_ATTRIBUTE_GROUP_TYPE

Columns

Name	Datatype	Length	Mandatory	Comments
OBJECT_ID	NUMBER		Yes	Object id
APPLICATION_ID	NUMBER		Yes	Application internal id
CHANGE_ATTRIBUTE_GROUP_TYPE	VARCHAR2	(40)	Yes	Attribute group type
SEQUENCE_NUM	NUMBER			Sequence number
CHANGE_B_TABLE_NAME	VARCHAR2	(30)		Table name of the pending changes
CHANGE_TL_TABLE_NAME	VARCHAR2	(30)		TL table name where the pending changes are stored
CHANGE_VL_TABLE_NAME	VARCHAR2	(30)		VL table name of the pending changes
CHANGE_VO_DEF_NAME	VARCHAR2	(240)		View object definition name
CHANGE_VO_INST_NAME	VARCHAR2	(240)		View object instance name
CHANGE_VO_ROW_CLASS_NAME	VARCHAR2	(240)		View object row class name
CHANGE_EO_DEF_NAME	VARCHAR2	(240)		Entity object name
DEFALT_VALUE_API_NAME	VARCHAR2	(240)		Default value API name
VALIDATION_API_NAME	VARCHAR2	(240)		Validation API name
IMPL_API_NAME	VARCHAR2	(240)		Implementation API name
PARENT_ATTRIBUTE_GROUP_TYPE	VARCHAR2	(40)		Parent attribute group name
CREATED_BY	NUMBER		Yes	Standard WHO column
CREATION_DATE	DATE		Yes	Standard WHO column
LAST_UPDATED_BY	NUMBER		Yes	Standard WHO column
LAST_UPDATE_DATE	DATE		Yes	Standard WHO column
LAST_UPDATE_LOGIN	NUMBER			Standard WHO column

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT OBJECT_ID
,      APPLICATION_ID
,      CHANGE_ATTRIBUTE_GROUP_TYPE
,      SEQUENCE_NUM
,      CHANGE_B_TABLE_NAME
,      CHANGE_TL_TABLE_NAME
,      CHANGE_VL_TABLE_NAME
,      CHANGE_VO_DEF_NAME
,      CHANGE_VO_INST_NAME
,      CHANGE_VO_ROW_CLASS_NAME
,      CHANGE_EO_DEF_NAME
,      DEFALT_VALUE_API_NAME
,      VALIDATION_API_NAME
,      IMPL_API_NAME
,      PARENT_ATTRIBUTE_GROUP_TYPE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM ENG.ENG_PENDING_CHANGE_CTX;

Dependencies

[top of page]

ENG.ENG_PENDING_CHANGE_CTX does not reference any database object

ENG.ENG_PENDING_CHANGE_CTX is referenced by following:

APPS: ENG_PENDING_CHANGE_CTX