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: GMP.MR_UBKT_DTL

Object Details

Object Name:	MR_UBKT_DTL
Object Type:	TABLE
Owner:	GMP
FND Design Data:	GMP.MR_UBKT_DTL
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
MATL_REP_ID	NUMBER	(10)	Yes	Surrogate id for the report
ITEM_ID	NUMBER	(10)	Yes	Surrogate id of the item in the report.
DOC_TYPE	VARCHAR2	(4)	Yes	Doc type of the transaction/action
ORGN_CODE	VARCHAR2	(4)	Yes	Organization code of the organization under which the transaction falls
DOC_ID	NUMBER	(10)	Yes	Surrogate id of the document (if any) for the transaction
DOC_NO	VARCHAR2	(32)		Document number of the document of the transaction (if any)
PLANNING_CLASS	VARCHAR2	(8)		Planning class of the item
WHSE_CODE	VARCHAR2	(4)		Warehouse code of the warehouse under which the transaction/action falls
START_BALANCE	NUMBER			Starting quantity of the item in the warehouse
PAST_DUE	VARCHAR2	(1)		Total past due quantity of the item in that warehouse
TRANS_DATE	DATE			Date of the transaction
TRANS_QTY	NUMBER			Quantity of the transaction
BALANCE	NUMBER			Balance left at the end of that period
CRITICAL_IND	VARCHAR2	(2)		Denotes whether the item has become critical - below safety stock
CUST_VEND	VARCHAR2	(32)		Customer or vendor code
PLANNING_CATEGORY_ID	NUMBER			Category Id for PLANNING_CLASS

Query Text

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


SELECT MATL_REP_ID
,      ITEM_ID
,      DOC_TYPE
,      ORGN_CODE
,      DOC_ID
,      DOC_NO
,      PLANNING_CLASS
,      WHSE_CODE
,      START_BALANCE
,      PAST_DUE
,      TRANS_DATE
,      TRANS_QTY
,      BALANCE
,      CRITICAL_IND
,      CUST_VEND
,      PLANNING_CATEGORY_ID
FROM GMP.MR_UBKT_DTL;

Dependencies

[top of page]

GMP.MR_UBKT_DTL does not reference any database object

GMP.MR_UBKT_DTL is referenced by following:

APPS: MR_UBKT_DTL