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_FLOW_DEMANDS

Object Details

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

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
MRP_FLOW_DEMANDS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	WIP_ENTITY_ID
MRP_FLOW_DEMANDS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BILL_SEQUENCE_ID
MRP_FLOW_DEMANDS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RN

Columns

Name	Datatype	Comments
ORGANIZATION_ID	NUMBER	Organization identifier
PLANNED_QUANTITY	NUMBER	Planned quantity
PRIMARY_ITEM_ID	NUMBER	Item identifier
QUANTITY_COMPLETED	NUMBER	Quantity completed
SCHEDULED_COMPLETION_DATE	DATE	Scheduled completion date
SCHEDULED_START_DATE	DATE	Scheduled start date
WIP_ENTITY_ID	NUMBER	WIP job identifier
PLAN_LEVEL	NUMBER	Plan level
WIP_SUPPLY_TYPE	NUMBER	WIP supply type
BILL_SEQUENCE_ID	NUMBER	Bill sequence identifier
STATUS	NUMBER	Status
RN	NUMBER	Refresh number

Query Text

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


SELECT ORGANIZATION_ID
,      PLANNED_QUANTITY
,      PRIMARY_ITEM_ID
,      QUANTITY_COMPLETED
,      SCHEDULED_COMPLETION_DATE
,      SCHEDULED_START_DATE
,      WIP_ENTITY_ID
,      PLAN_LEVEL
,      WIP_SUPPLY_TYPE
,      BILL_SEQUENCE_ID
,      STATUS
,      RN
FROM MRP.MRP_FLOW_DEMANDS;

Dependencies

[top of page]

MRP.MRP_FLOW_DEMANDS does not reference any database object

MRP.MRP_FLOW_DEMANDS is referenced by following:

MRP: MRP_FLOW_DEMANDS#