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_ATP_SUPPLY_DEMAND

Object Details

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

Table not currently used.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
MRP_ATP_SUPPLY_DEMAND_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	SOURCE_IDENTIFIER1 SOURCE_IDENTIFIER2 SOURCE_IDENTIFIER3 SOURCE_IDENTIFIER4 ORGANIZATION_ID PLAN_ID INVENTORY_ITEM_ID RESOURCE_ID DEPARTMENT_ID SUPPLIER_ID SUPPLIER_SITE_ID FROM_ORGANIZATION_ID TO_ORGANIZATION_ID FROM_LOCATION_ID TO_LOCATION_ID SHIP_METHOD UOM SUPPLY_DEMAND_DATE SUPPLY_DEMAND_SOURCE_TYPE

Columns

Name	Datatype	Length	Mandatory	Comments
SOURCE_IDENTIFIER1	NUMBER			Source identifier1
SOURCE_IDENTIFIER2	NUMBER			Source identifier2
SOURCE_IDENTIFIER3	NUMBER			Source identifier3
SOURCE_IDENTIFIER4	NUMBER			Source identifier4
ORGANIZATION_ID	NUMBER		Yes	Organization identifier
PLAN_ID	NUMBER		Yes	Plan identifier
INVENTORY_ITEM_ID	NUMBER			Inventory item identifier
RESOURCE_ID	NUMBER			Resource identifier
DEPARTMENT_ID	NUMBER			Deoartment identifier
SUPPLIER_ID	NUMBER			Supplier identifier
SUPPLIER_SITE_ID	NUMBER			Supplier site identifier
FROM_ORGANIZATION_ID	NUMBER			From organization identifier
TO_ORGANIZATION_ID	NUMBER			To organization identifier
FROM_LOCATION_ID	NUMBER			From location identifier
TO_LOCATION_ID	NUMBER			To location identifier
SHIP_METHOD	VARCHAR2	(30)		Ship method
UOM	VARCHAR2	(3)		Unit of measure
SUPPLY_DEMAND_DATE	DATE			Supply demand date
SUPPLY_DEMAND_SOURCE_TYPE	NUMBER		Yes	Supply demand source type
SUPPLY_DEMAND_QUANTITY	NUMBER			Supply demand quantity
RESERVATION_QUANTITY	NUMBER			Reservation quantity
LAST_UPDATE_DATE	DATE			Standard who column
LAST_UPDATED_BY	NUMBER			Standard who column
CREATION_DATE	DATE			Standard who column
CREATED_BY	NUMBER			Standard who column
DEMAND_CLASS	VARCHAR2	(30)		Demand class
SUPPLY_DEMAND_TYPE	NUMBER		Yes	Supply demand type
PRODUCT_FAMILY_ITEM_ID	NUMBER			Product family item identifier
WEIGHT_CAPACITY	NUMBER			Weight capacity
VOLUME_CAPACITY	NUMBER			Volumn capacity
WEIGHT_UOM	VARCHAR2	(3)		Weight unit of measure
VOLUME_UOM	VARCHAR2	(3)		Volume unit of measure
REFRESH_NUMBER	NUMBER			Refresh number

Query Text

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


SELECT SOURCE_IDENTIFIER1
,      SOURCE_IDENTIFIER2
,      SOURCE_IDENTIFIER3
,      SOURCE_IDENTIFIER4
,      ORGANIZATION_ID
,      PLAN_ID
,      INVENTORY_ITEM_ID
,      RESOURCE_ID
,      DEPARTMENT_ID
,      SUPPLIER_ID
,      SUPPLIER_SITE_ID
,      FROM_ORGANIZATION_ID
,      TO_ORGANIZATION_ID
,      FROM_LOCATION_ID
,      TO_LOCATION_ID
,      SHIP_METHOD
,      UOM
,      SUPPLY_DEMAND_DATE
,      SUPPLY_DEMAND_SOURCE_TYPE
,      SUPPLY_DEMAND_QUANTITY
,      RESERVATION_QUANTITY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      DEMAND_CLASS
,      SUPPLY_DEMAND_TYPE
,      PRODUCT_FAMILY_ITEM_ID
,      WEIGHT_CAPACITY
,      VOLUME_CAPACITY
,      WEIGHT_UOM
,      VOLUME_UOM
,      REFRESH_NUMBER
FROM MRP.MRP_ATP_SUPPLY_DEMAND;

Dependencies

[top of page]

MRP.MRP_ATP_SUPPLY_DEMAND does not reference any database object

MRP.MRP_ATP_SUPPLY_DEMAND is referenced by following:

APPS: MRP_ATP_SUPPLY_DEMAND