[Home] [Help] [Dependency Information]
Object Name: | MRP_ATP_SUPPLY_DEMAND# |
---|---|
Object Type: | VIEW |
Owner: | MRP |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SOURCE_IDENTIFIER1 | NUMBER | |||
SOURCE_IDENTIFIER2 | NUMBER | |||
SOURCE_IDENTIFIER3 | NUMBER | |||
SOURCE_IDENTIFIER4 | NUMBER | |||
ORGANIZATION_ID | NUMBER | Yes | ||
PLAN_ID | NUMBER | Yes | ||
INVENTORY_ITEM_ID | NUMBER | |||
RESOURCE_ID | NUMBER | |||
DEPARTMENT_ID | NUMBER | |||
SUPPLIER_ID | NUMBER | |||
SUPPLIER_SITE_ID | NUMBER | |||
FROM_ORGANIZATION_ID | NUMBER | |||
TO_ORGANIZATION_ID | NUMBER | |||
FROM_LOCATION_ID | NUMBER | |||
TO_LOCATION_ID | NUMBER | |||
SHIP_METHOD | VARCHAR2 | (30) | ||
UOM | VARCHAR2 | (3) | ||
SUPPLY_DEMAND_DATE | DATE | |||
SUPPLY_DEMAND_SOURCE_TYPE | NUMBER | Yes | ||
SUPPLY_DEMAND_QUANTITY | NUMBER | |||
RESERVATION_QUANTITY | NUMBER | |||
LAST_UPDATE_DATE | DATE | |||
LAST_UPDATED_BY | NUMBER | |||
CREATION_DATE | DATE | |||
CREATED_BY | NUMBER | |||
DEMAND_CLASS | VARCHAR2 | (30) | ||
SUPPLY_DEMAND_TYPE | NUMBER | Yes | ||
PRODUCT_FAMILY_ITEM_ID | NUMBER | |||
WEIGHT_CAPACITY | NUMBER | |||
VOLUME_CAPACITY | NUMBER | |||
WEIGHT_UOM | VARCHAR2 | (3) | ||
VOLUME_UOM | VARCHAR2 | (3) | ||
REFRESH_NUMBER | 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#;
|
|
|