[Home] [Help] [Dependency Information]
Object Name: | MRP_BIS_FORECAST_WB |
---|---|
Object Type: | TABLE |
Owner: | MRP |
FND Design Data: | MRP.MRP_BIS_FORECAST_WB |
Subobject Name: | |
Status: | VALID |
Summary table stores forecast and actual values for use in the Discoverer workbook.
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
MRP_BIS_FORECAST_WB_N1 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY |
ORGANIZATION_ID
INVENTORY_ITEM_ID FORECAST_DATE |
MRP_BIS_FORECAST_WB_N2 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY |
ORGANIZATION_NAME
FORECAST_SET |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ORGANIZATION_ID | NUMBER | Organization identifier | ||
ORGANIZATION_CODE | VARCHAR2 | (3) | Organization code | |
ORGANIZATION_NAME | VARCHAR2 | (240) | Organization name | |
FORECAST_SET | VARCHAR2 | (10) | Forecast set | |
FORECAST | VARCHAR2 | (10) | Forecast name | |
FORECAST_DESCRIPTION | VARCHAR2 | (240) | Forecast description | |
UPDATE_TYPE | NUMBER | Forecast update type code | ||
DEMAND_CLASS | VARCHAR2 | (30) | Demand class | |
CATEGORY_SET_ID | NUMBER | Category set identifier | ||
CATEGORY_SET | VARCHAR2 | (30) | Category set name | |
CATEGORY_ID | NUMBER | Category identifier | ||
CATEGORY | VARCHAR2 | (2000) | Category name | |
CATEGORY_DESCRIPTION | VARCHAR2 | (240) | Category description | |
PRODUCT_FAMILY_ID | NUMBER | Product family identifier | ||
PRODUCT_FAMILY_NUMBER | VARCHAR2 | (2000) | Product family number | |
PRODUCT_FAMILY_DESC | VARCHAR2 | (240) | Product family description | |
INVENTORY_ITEM_ID | NUMBER | Item identifier | ||
ITEM_NUMBER | VARCHAR2 | (2000) | Item number | |
ITEM_DESCRIPTION | VARCHAR2 | (240) | Item description | |
CUSTOMER_CLASS | VARCHAR2 | (30) | Customer class | |
CUSTOMER_ID | NUMBER | Customer identifier | ||
CUSTOMER | VARCHAR2 | (50) | Customer name | |
SHIP_ID | NUMBER | Ship to address identifier | ||
SHIP_TO_ADDRESS | VARCHAR2 | (240) | Ship to address | |
SHIP_TO_CITY | VARCHAR2 | (60) | Ship to city | |
SHIP_TO_STATE | VARCHAR2 | (60) | Ship to state | |
SHIP_TO_ZIP | VARCHAR2 | (60) | Ship to zip code | |
BILL_ID | NUMBER | Bill to address identifier | ||
BILL_TO_ADDRESS | VARCHAR2 | (240) | Bill to address | |
BILL_TO_CITY | VARCHAR2 | (60) | Bill to city | |
BILL_TO_STATE | VARCHAR2 | (60) | Bill to state | |
BILL_TO_ZIP | VARCHAR2 | (60) | Bill to zip code | |
FORECAST_DATE | DATE | Forecast date | ||
FORECAST_QUANTITY | NUMBER | Forecasted quantity | ||
ORDER_QUANTITY | NUMBER | Actual sales order quantity | ||
SHIPPED_QUANTITY | NUMBER | Actual shipped quantity | ||
FORECAST_AMOUNT | NUMBER | Dollar amount of forecasted quantity | ||
ORDER_AMOUNT | NUMBER | Dollar amount of actual sales order quantity | ||
SHIPPED_AMOUNT | NUMBER | Dollar amount of actual shipped quantity | ||
CONFIDENCE_PERCENTAGE | NUMBER | Confidence percentage | ||
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 | ||
LAST_UPDATE_LOGIN | NUMBER | Standard who column | ||
REQUEST_ID | NUMBER | Extended who column | ||
PROGRAM_APPLICATION_ID | NUMBER | Extended who column | ||
PROGRAM_UPDATE_DATE | DATE | Extended who column |
Cut, paste (and edit) the following text to query this object:
SELECT ORGANIZATION_ID
, ORGANIZATION_CODE
, ORGANIZATION_NAME
, FORECAST_SET
, FORECAST
, FORECAST_DESCRIPTION
, UPDATE_TYPE
, DEMAND_CLASS
, CATEGORY_SET_ID
, CATEGORY_SET
, CATEGORY_ID
, CATEGORY
, CATEGORY_DESCRIPTION
, PRODUCT_FAMILY_ID
, PRODUCT_FAMILY_NUMBER
, PRODUCT_FAMILY_DESC
, INVENTORY_ITEM_ID
, ITEM_NUMBER
, ITEM_DESCRIPTION
, CUSTOMER_CLASS
, CUSTOMER_ID
, CUSTOMER
, SHIP_ID
, SHIP_TO_ADDRESS
, SHIP_TO_CITY
, SHIP_TO_STATE
, SHIP_TO_ZIP
, BILL_ID
, BILL_TO_ADDRESS
, BILL_TO_CITY
, BILL_TO_STATE
, BILL_TO_ZIP
, FORECAST_DATE
, FORECAST_QUANTITY
, ORDER_QUANTITY
, SHIPPED_QUANTITY
, FORECAST_AMOUNT
, ORDER_AMOUNT
, SHIPPED_AMOUNT
, CONFIDENCE_PERCENTAGE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_UPDATE_DATE
FROM MRP.MRP_BIS_FORECAST_WB;
MRP.MRP_BIS_FORECAST_WB does not reference any database object
MRP.MRP_BIS_FORECAST_WB is referenced by following:
|
|
|