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_MATL_DTL

Object Details

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

Temporary data about the report

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PS_MATL_DTL_PK	NORMAL	UNIQUE	APPS_TS_INTERFACE	MATL_REP_ID ITEM_ID PERD_END_DATE

Columns

Name	Datatype	Length	Mandatory	Comments
MATL_REP_ID	NUMBER	(10)	Yes	Surrogate id for the report
ITEM_ID	NUMBER	(10)		Surrogate id of the item in the report
PLANNING_CLASS	VARCHAR2	(8)		Planning class of the item
WHSE_CODE	VARCHAR2	(4)		Warehouse in which the transaction occurs
QTY_ON_HAND	NUMBER			Quantity of the item on hand as of now.
PERD_NAME	VARCHAR2	(20)		Name of the period - depending of the buckets defined.
PERD_END_DATE	DATE		Yes	End date of the period ( bucket )
SALES_ORDERS	NUMBER			Sum quantities of all sales orders in the period
FORE_CAST	NUMBER			Sum all forecasted quantities in the period
SCHED_INGRED	NUMBER			Quantities to be consumed in the scheduled batches as ingredient
FIRM_INGRED	NUMBER			Quantities to be consumed in the Firm Planned Orders as ingredient
PLND_INGRED	NUMBER			Quantities to be consumed in the Planned batches as ingredient
TOTAL_DEMAND	NUMBER			Total of all the demand quantities
PO_RECEIPTS	NUMBER			Quantity for the item to be received from the Purchase Order
REQ_RECEIPTS	NUMBER			Receipt quantity
SCHED_PROD	NUMBER			Quantity from the scheduled batches
FIRM_PROD	NUMBER			Quantity coming from the Firm Planned Orders
PLND_PROD	NUMBER			Quantity coming from the Planned Batches
ENDING_BAL	NUMBER			Net ending balance for that preiod EB=Starting qty + Total replenishment - Total demand
NET_SS_REQMT	NUMBER			Net Safety Stock requirement
PLND_TRANSFER_OUT	NUMBER			Schedule transfer quantity outgoing
PLND_TRANSFER_IN	NUMBER			Schedule transfer quantity incoming
PLANNING_CATEGORY_ID	NUMBER			Category Id for PLANNING_CLASS
SCHED_TRANSFER_IN	NUMBER			schedule transfer in
SCHED_TRANSFER_OUT	NUMBER			schedule transfer out
PREQ_SUPPLY	NUMBER			preq supply
PRCV_SUPPLY	NUMBER			prcv supply
SHMT_SUPPLY	NUMBER			MRP shortage suppoy
PLND_PURCHASE	NUMBER			Planned Purchase
OTHER_DEMAND	NUMBER			Stores demands not covered under the other specific columns - currently it stores the demand caused by expired lot
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 MATL_REP_ID
,      ITEM_ID
,      PLANNING_CLASS
,      WHSE_CODE
,      QTY_ON_HAND
,      PERD_NAME
,      PERD_END_DATE
,      SALES_ORDERS
,      FORE_CAST
,      SCHED_INGRED
,      FIRM_INGRED
,      PLND_INGRED
,      TOTAL_DEMAND
,      PO_RECEIPTS
,      REQ_RECEIPTS
,      SCHED_PROD
,      FIRM_PROD
,      PLND_PROD
,      ENDING_BAL
,      NET_SS_REQMT
,      PLND_TRANSFER_OUT
,      PLND_TRANSFER_IN
,      PLANNING_CATEGORY_ID
,      SCHED_TRANSFER_IN
,      SCHED_TRANSFER_OUT
,      PREQ_SUPPLY
,      PRCV_SUPPLY
,      SHMT_SUPPLY
,      PLND_PURCHASE
,      OTHER_DEMAND
,      INVENTORY_ITEM_ID
,      ORGANIZATION_ID
FROM GMP.PS_MATL_DTL;

Dependencies

[top of page]

GMP.PS_MATL_DTL does not reference any database object

GMP.PS_MATL_DTL is referenced by following:

APPS: PS_MATL_DTL