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_PROPAGATION_MAPS

Object Details

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

This table is used to store Change propagation mapping betwen source and destination entities.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
ENG_CHANGE_PROPAGATION_MAPS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	CHANGE_PROPAGATION_MAP_ID
ENG_CHANGE_PROPAGATION_MAPS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CHANGE_ID LOCAL_ORGANIZATION_ID REVISED_LINE_TYPE REVISED_LINE_ID1 REVISED_LINE_ID2 REVISED_LINE_ID3 REVISED_LINE_ID4 REVISED_LINE_ID5
ENG_CHANGE_PROPAGATION_MAPS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CHANGE_ID LOCAL_ORGANIZATION_ID REVISED_LINE_TYPE LOCAL_REVISED_LINE_ID1 LOCAL_REVISED_LINE_ID2 LOCAL_REVISED_LINE_ID3 LOCAL_REVISED_LINE_ID4 LOCAL_REVISED_LINE_ID5

Columns

Name	Datatype	Length	Mandatory	Comments
CHANGE_PROPAGATION_MAP_ID	NUMBER		Yes	Change propagation entity identifier
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
CHANGE_ID	NUMBER		Yes	Change Identifier
REVISED_ITEM_SEQUENCE_ID	NUMBER			Revised Item Identifier
REVISED_LINE_TYPE	VARCHAR2	(20)		Revised Line Type
REVISED_LINE_ID1	NUMBER			Revised Line Identifier 1
REVISED_LINE_ID2	NUMBER			Revised Line Identifier 2
REVISED_LINE_ID3	NUMBER			Revised Line Identifier 3
REVISED_LINE_ID4	NUMBER			Revised Line Identifier 4
REVISED_LINE_ID5	NUMBER			Revised Line Identifier 5
LOCAL_ORGANIZATION_ID	NUMBER			Destination Organization Identifier
LOCAL_CHANGE_ID	NUMBER			Destination Change Identifier
LOCAL_REVISED_ITEM_SEQUENCE_ID	NUMBER			Destination Revised Item Identifier
LOCAL_REVISED_LINE_ID1	NUMBER			Destination Revised Line Identifier 1
LOCAL_REVISED_LINE_ID2	NUMBER			Destination Revised Line Identifier 2
LOCAL_REVISED_LINE_ID3	NUMBER			Destination Revised Line Identifier 3
LOCAL_REVISED_LINE_ID4	NUMBER			Destination Revised Line Identifier 4
LOCAL_REVISED_LINE_ID5	NUMBER			Destination Revised Line Identifier 5
ENTITY_NAME	VARCHAR2	(20)		Entity Name. like ENG_CHANGE
ENTITY_ACTION_STATUS	NUMBER			Propagation Action Status of the Entity
PROGRAM_ID	NUMBER			Concurrent request who column
PROGRAM_APPLICATION_ID	NUMBER			Concurrent request who column
PROGRAM_UPDATE_DATE	DATE			Concurrent request who column
REQUEST_ID	NUMBER			Concurrent request who column

Query Text

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


SELECT CHANGE_PROPAGATION_MAP_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CHANGE_ID
,      REVISED_ITEM_SEQUENCE_ID
,      REVISED_LINE_TYPE
,      REVISED_LINE_ID1
,      REVISED_LINE_ID2
,      REVISED_LINE_ID3
,      REVISED_LINE_ID4
,      REVISED_LINE_ID5
,      LOCAL_ORGANIZATION_ID
,      LOCAL_CHANGE_ID
,      LOCAL_REVISED_ITEM_SEQUENCE_ID
,      LOCAL_REVISED_LINE_ID1
,      LOCAL_REVISED_LINE_ID2
,      LOCAL_REVISED_LINE_ID3
,      LOCAL_REVISED_LINE_ID4
,      LOCAL_REVISED_LINE_ID5
,      ENTITY_NAME
,      ENTITY_ACTION_STATUS
,      PROGRAM_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
FROM ENG.ENG_CHANGE_PROPAGATION_MAPS;

Dependencies

[top of page]

ENG.ENG_CHANGE_PROPAGATION_MAPS does not reference any database object

ENG.ENG_CHANGE_PROPAGATION_MAPS is referenced by following:

APPS: ENG_CHANGE_PROPAGATION_MAPS