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: INV.MTL_MGD_INVENTORY_POSITIONS

Object Details

Object Name:	MTL_MGD_INVENTORY_POSITIONS
Object Type:	TABLE
Owner:	INV
FND Design Data:	INV.MTL_MGD_INVENTORY_POSITIONS
Subobject Name:
Status:	VALID

MTL_MGD_INVENTORY_POSITIONS stores the data sets built for on line display or for export.
It should be considered a temporary table since its content is a denormalization of the
transactional data built for extraction purposes. This table contains a row for every
combination of data set name, bucket name, organization code and inventory item code.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
MTL_MGD_INVENTORY_POSITIONS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CREATED_BY
MTL_MGD_INVENTORY_POSITIONS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DATA_SET_NAME BUCKET_NAME ORGANIZATION_ID INVENTORY_ITEM_ID

Columns

Name	Datatype	Length	Mandatory	Comments
DATA_SET_NAME	VARCHAR2	(80)	Yes	Data Set Name
BUCKET_NAME	VARCHAR2	(30)	Yes	Bucket Name
ORGANIZATION_CODE	VARCHAR2	(3)	Yes	Organization Code
INVENTORY_ITEM_CODE	VARCHAR2	(2000)		Inventory Item Code
CREATION_DATE	DATE		Yes	Who Column
CREATED_BY	NUMBER		Yes	Who Column
LAST_UPDATE_DATE	DATE		Yes	Who Column
LAST_UPDATED_BY	NUMBER		Yes	Who Column
LAST_UPDATE_LOGIN	NUMBER			Who Column
REQUEST_ID	NUMBER			Request Id
PROGRAM_APPLICATION_ID	NUMBER			Program Application Id
PROGRAM_ID	NUMBER			Program Id
PROGRAM_UPDATE_DATE	DATE			Program Update Date
HIERARCHY_ID	NUMBER		Yes	Hierarchy Id
HIERARCHY_NAME	VARCHAR2	(30)	Yes	Hierarchy Name
PARENT_ORGANIZATION_CODE	VARCHAR2	(3)	Yes	PARENT_ORGANIZATION_CODE
PARENT_ORGANIZATION_ID	NUMBER		Yes	PARENT_ORGANIZATION_ID
BUCKET_SIZE_CODE	VARCHAR2	(30)		BUCKET_SIZE_CODE
BUCKET_START_DATE	DATE		Yes	BUCKET_START_DATE
BUCKET_END_DATE	DATE		Yes	BUCKET_END_DATE
INVENTORY_ITEM_ID	NUMBER		Yes	INVENTORY_ITEM_ID
ORGANIZATION_ID	NUMBER		Yes	ORGANIZATION_ID
HIERARCHY_DELTA_QTY	NUMBER		Yes	HIERARCHY_DELTA_QTY
HIERARCHY_END_ON_HAND_QTY	NUMBER		Yes	HIERARCHY_END_ON_HAND_QTY
ORG_RECEIVED_QTY	NUMBER		Yes	ORG_RECEIVED_QTY
ORG_ISSUED_QTY	NUMBER		Yes	ORG_ISSUED_QTY
ORG_DELTA_QTY	NUMBER		Yes	ORG_DELTA_QTY
ORG_END_ON_HAND_QTY	NUMBER		Yes	ORG_END_ON_HAND_QTY

Query Text

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


SELECT DATA_SET_NAME
,      BUCKET_NAME
,      ORGANIZATION_CODE
,      INVENTORY_ITEM_CODE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      HIERARCHY_ID
,      HIERARCHY_NAME
,      PARENT_ORGANIZATION_CODE
,      PARENT_ORGANIZATION_ID
,      BUCKET_SIZE_CODE
,      BUCKET_START_DATE
,      BUCKET_END_DATE
,      INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      HIERARCHY_DELTA_QTY
,      HIERARCHY_END_ON_HAND_QTY
,      ORG_RECEIVED_QTY
,      ORG_ISSUED_QTY
,      ORG_DELTA_QTY
,      ORG_END_ON_HAND_QTY
FROM INV.MTL_MGD_INVENTORY_POSITIONS;

Dependencies

[top of page]

INV.MTL_MGD_INVENTORY_POSITIONS does not reference any database object

INV.MTL_MGD_INVENTORY_POSITIONS is referenced by following:

INV: MTL_MGD_INVENTORY_POSITIONS#