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: MRP.MRP_DERIVED_SO_DEMANDS

Object Details

Object Name:	MRP_DERIVED_SO_DEMANDS
Object Type:	TABLE
Owner:	MRP
FND Design Data:	MRP.MRP_DERIVED_SO_DEMANDS
Subobject Name:
Status:	VALID

This table contains the demands for Standard mandatory components.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
INVENTORY_ITEM_ID	NUMBER		Yes	Inventory item identifier
ORGANIZATION_ID	NUMBER		Yes	Organization identifier
PRIMARY_UOM_QUANTITY	NUMBER		Yes	Primary UOM Quantity
RESERVATION_TYPE	NUMBER		Yes	Reservation type
RESERVATION_QUANTITY	NUMBER		Yes	Quanity reserved
DEMAND_SOURCE_TYPE	NUMBER		Yes	Indicates demand source for which reservation is made
DEMAND_HEADER_ID	NUMBER		Yes	Header identifier for source of demand. For Sales Order: OE_ORDER_HEADERS.HEADER_ID
COMPLETED_QUANTITY	NUMBER		Yes	Quantity complited
SUBINVENTORY	VARCHAR2	(10)		Sub inventory
DEMAND_CLASS	VARCHAR2	(30)		Demand class
REQUIREMENT_DATE	DATE		Yes	Requirement Date
DEMAND_SOURCE_LINE	VARCHAR2	(40)		Line ID for demand source. For Sales Order: OE_ORDER_LINES.LINE_ID
DEMAND_SOURCE_DELIVERY	VARCHAR2	(30)		Delivery identifier for demand sources
PARENT_DEMAND_ID	NUMBER			Parent demand identifier
DEMAND_ID	NUMBER			Demand identifier
SALES_CONTACT	VARCHAR2	(30)		Sales contact
REFRESH_NUMBER	NUMBER			Refresh number

Query Text

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


SELECT INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      PRIMARY_UOM_QUANTITY
,      RESERVATION_TYPE
,      RESERVATION_QUANTITY
,      DEMAND_SOURCE_TYPE
,      DEMAND_HEADER_ID
,      COMPLETED_QUANTITY
,      SUBINVENTORY
,      DEMAND_CLASS
,      REQUIREMENT_DATE
,      DEMAND_SOURCE_LINE
,      DEMAND_SOURCE_DELIVERY
,      PARENT_DEMAND_ID
,      DEMAND_ID
,      SALES_CONTACT
,      REFRESH_NUMBER
FROM MRP.MRP_DERIVED_SO_DEMANDS;

Dependencies

[top of page]

MRP.MRP_DERIVED_SO_DEMANDS does not reference any database object

MRP.MRP_DERIVED_SO_DEMANDS is referenced by following:

APPS: MRP_DERIVED_SO_DEMANDS