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.PS_UBKT_DTL

Object Details

Object Name:	PS_UBKT_DTL
Object Type:	TABLE
Owner:	GMP
FND Design Data:	GMP.PS_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:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PS_UBKT_DTL_I1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	MATL_REP_ID ITEM_ID

Columns

Name	Datatype	Length	Mandatory	Comments
LINE_ID	NUMBER	(10)	Yes	Surrogate for the line in the report
MATL_REP_ID	NUMBER	(10)	Yes	Surrogate id for the report
ITEM_ID	NUMBER	(10)		Surrogate id of the item being reported
DOC_TYPE	VARCHAR2	(4)	Yes	Doc type of the transaction
ORGN_CODE	VARCHAR2	(4)		Organization under which the transaction falls
DOC_NO	VARCHAR2	(32)		Document number (if any) of the document for the transaction
PLANNING_CLASS	VARCHAR2	(8)		Planning class of the item
WHSE_CODE	VARCHAR2	(4)		Warehouse code of the warehouse in the transaction
START_BALANCE	NUMBER			Satrting balance quantity for the item
PAST_DUE	VARCHAR2	(1)		Total past due quantity for the trans type
TRANS_DATE	DATE			Date of the transaction
TRANS_QTY	NUMBER			Quantity of the transaction
BALANCE	NUMBER			Balance = Starting balance + Replenishment - Demand
CRITICAL_IND	VARCHAR2	(2)		Whether the item has become critical
CUST_VEND	VARCHAR2	(32)		Customer - Vendor code
PLANNING_CATEGORY_ID	NUMBER			Category Id for PLANNING_CLASS
INVENTORY_ITEM_ID	NUMBER			Inventory Item ID
ORGANIZATION_ID	NUMBER			Organization ID

Query Text

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


SELECT LINE_ID
,      MATL_REP_ID
,      ITEM_ID
,      DOC_TYPE
,      ORGN_CODE
,      DOC_NO
,      PLANNING_CLASS
,      WHSE_CODE
,      START_BALANCE
,      PAST_DUE
,      TRANS_DATE
,      TRANS_QTY
,      BALANCE
,      CRITICAL_IND
,      CUST_VEND
,      PLANNING_CATEGORY_ID
,      INVENTORY_ITEM_ID
,      ORGANIZATION_ID
FROM GMP.PS_UBKT_DTL;

Dependencies

[top of page]

GMP.PS_UBKT_DTL does not reference any database object

GMP.PS_UBKT_DTL is referenced by following:

APPS: PS_UBKT_DTL