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: MSD.MSD_ST_ITEM_RELATIONSHIPS

Object Details

Object Name:	MSD_ST_ITEM_RELATIONSHIPS
Object Type:	TABLE
Owner:	MSD
Subobject Name:
Status:	VALID

Staging table for item relationships

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Comments
INSTANCE_ID	VARCHAR2	(40)	Instance
INVENTORY_ITEM_ID	VARCHAR2	(240)	Inventory Item Id
INVENTORY_ITEM	VARCHAR2	(240)	Inventory Item
RELATED_ITEM_ID	VARCHAR2	(240)	Related Item Id
RELATED_ITEM	VARCHAR2	(240)	Related Item
RELATIONSHIP_TYPE_ID	VARCHAR2	(30)	Relationship Type Id
LAST_UPDATE_DATE	DATE		WHO column
LAST_UPDATED_BY	NUMBER		WHO column
CREATION_DATE	DATE		WHO column
CREATED_BY	NUMBER		WHO column
LAST_UPDATE_LOGIN	NUMBER		WHO column
REQUEST_ID	NUMBER		WHO column
PROGRAM_APPLICATION_ID	NUMBER		WHO column
PROGRAM_ID	NUMBER		WHO column
PROGRAM_UPDATE_DATE	DATE		WHO column
SR_INSTANCE_CODE	VARCHAR2	(3)	Source Instance Code
RELATIONSHIP_TYPE	VARCHAR2	(240)	Relationship Type
BATCH_ID	NUMBER		This is an internal column. It is pouplate and used by Legacy Collection process.
ST_TRANSACTION_ID	NUMBER		This is an internal column. It is pouplate and used by Legacy Collection process.
PROCESS_FLAG	NUMBER		This is an internal column. It is pouplate and used by Legacy Collection process.
DATA_SOURCE_TYPE	VARCHAR2	(15)	This is an internal column. It is pouplate and used by Legacy Collection process.
ERROR_TEXT	VARCHAR2	(2000)	This is an internal column. It is pouplate and used by Legacy Collection process.
MESSAGE_ID	NUMBER		This is an internal column. It is pouplate and used by Legacy Collection process.
START_DATE	DATE		For date effectivity.
END_DATE	DATE		For date effectivity.

Query Text

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


SELECT INSTANCE_ID
,      INVENTORY_ITEM_ID
,      INVENTORY_ITEM
,      RELATED_ITEM_ID
,      RELATED_ITEM
,      RELATIONSHIP_TYPE_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      SR_INSTANCE_CODE
,      RELATIONSHIP_TYPE
,      BATCH_ID
,      ST_TRANSACTION_ID
,      PROCESS_FLAG
,      DATA_SOURCE_TYPE
,      ERROR_TEXT
,      MESSAGE_ID
,      START_DATE
,      END_DATE
FROM MSD.MSD_ST_ITEM_RELATIONSHIPS;

Dependencies

[top of page]

MSD.MSD_ST_ITEM_RELATIONSHIPS does not reference any database object

MSD.MSD_ST_ITEM_RELATIONSHIPS is referenced by following:

MSD: MSD_ST_ITEM_RELATIONSHIPS#