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_BIS_FORECAST_WB

Object Details

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.

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

Indexes

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

Columns

Name	Datatype	Length	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

Query Text

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;

Dependencies

[top of page]

MRP.MRP_BIS_FORECAST_WB does not reference any database object

MRP.MRP_BIS_FORECAST_WB is referenced by following:

MRP: MRP_BIS_FORECAST_WB#