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_CHANGE_SUBJECTS

Object Details

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

ENG_CHANGE_SUBJECTS stores line information of NIR.Column: pk1_value is Inventory Id, Column: pk2_value is Organization Id. Records in the table are uniquely identified by entity_name,pk1_value, pk2_value, pk3_value

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
ENG_CHANGE_SUBJECTS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	CHANGE_SUBJECT_ID
ENG_CHANGE_SUBJECTS_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	CHANGE_ID CHANGE_LINE_ID SUBJECT_LEVEL
ENG_CHANGE_SUBJECTS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ENTITY_NAME PK1_VALUE PK2_VALUE PK3_VALUE
ENG_CHANGE_SUBJECTS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CHANGE_ID ENTITY_NAME

Columns

Name	Datatype	Length	Mandatory	Comments
CHANGE_SUBJECT_ID	NUMBER		Yes	Internal identifier of change subjects
CHANGE_ID	NUMBER		Yes	Internal identifier of change
CHANGE_LINE_ID	NUMBER			Internal identifier of change lines
ENTITY_NAME	VARCHAR2	(30)	Yes	Name of the entity
PK1_VALUE	VARCHAR2	(100)		Primary key of the entity
PK2_VALUE	VARCHAR2	(100)		Primary key of the entity
PK3_VALUE	VARCHAR2	(100)		Primary key of the entity
PK4_VALUE	VARCHAR2	(100)		Primary key of the entity
PK5_VALUE	VARCHAR2	(100)		Primary key of the entity
SUBJECT_LEVEL	NUMBER		Yes	Subject level
LIFECYCLE_STATE_ID	NUMBER			Lifecycle State internal identifier
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
REQUEST_ID	NUMBER			Concurrent WHO column
PROGRAM_ID	NUMBER			Concurrent WHO column
PROGRAM_APPLICATION_ID	NUMBER			Concurrent WHO column
PROGRAM_UPDATE_DATE	DATE			Concurrent WHO column

Query Text

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


SELECT CHANGE_SUBJECT_ID
,      CHANGE_ID
,      CHANGE_LINE_ID
,      ENTITY_NAME
,      PK1_VALUE
,      PK2_VALUE
,      PK3_VALUE
,      PK4_VALUE
,      PK5_VALUE
,      SUBJECT_LEVEL
,      LIFECYCLE_STATE_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_UPDATE_DATE
FROM ENG.ENG_CHANGE_SUBJECTS;

Dependencies

[top of page]

ENG.ENG_CHANGE_SUBJECTS does not reference any database object

ENG.ENG_CHANGE_SUBJECTS is referenced by following:

APPS: ENG_CHANGE_SUBJECTS; ENI_DBI_CO_ALL_MV