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_DEM_DPT_REP_USG_HISTORY

Object Details

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

Tables contains Depot repair usage history for items

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Comments
LEVEL1	VARCHAR2	(240)	Name of the inventory item
LEVEL1_SR_PK	NUMBER		Inventory item identifier in the source application instance
LEVEL2	VARCHAR2	(240)	The code includes instance code and organization code
LEVEL2_SR_PK	NUMBER		Unique partner(org) identifier in the source application instance
SDATE	DATE		Sales date
EBS_USG_QTY	NUMBER		Quantity of the item

Query Text

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


SELECT LEVEL1
,      LEVEL1_SR_PK
,      LEVEL2
,      LEVEL2_SR_PK
,      SDATE
,      EBS_USG_QTY
FROM MSD.MSD_DEM_DPT_REP_USG_HISTORY;

Dependencies

[top of page]

MSD.MSD_DEM_DPT_REP_USG_HISTORY does not reference any database object

MSD.MSD_DEM_DPT_REP_USG_HISTORY is referenced by following:

MSD: MSD_DEM_DPT_REP_USG_HISTORY#