[Home] [Help] [Dependency Information]
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.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
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 |
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 |
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;
MRP.MRP_ATP_SUPPLY_DEMAND does not reference any database object
MRP.MRP_ATP_SUPPLY_DEMAND is referenced by following:
|
|
|