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]

VIEW: MSD.MSD_DEM_BIEO_OBI_MV_DUMMY#

Object Details

Object Name:	MSD_DEM_BIEO_OBI_MV_DUMMY#
Object Type:	VIEW
Owner:	MSD
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length
SDATE	DATE
LEVEL1	VARCHAR2	(240)
LEVEL2	VARCHAR2	(240)
LEVEL3	VARCHAR2	(240)
LEVEL4	VARCHAR2	(240)
EBS_BH_BOOK_QTY_BD	NUMBER
EBS_SH_SHIP_QTY_SD	NUMBER
ACRY_MAPE_PCT_ERR	NUMBER
PRTY_DEMAND	NUMBER
WEEK4_ABS_PCT_ERR	NUMBER
WEEK8_ABS_PCT_ERR	NUMBER
WEEK13_ABS_PCT_ERR	NUMBER
DKEY_ITEM	NUMBER
DKEY_SITE	NUMBER
ACTUAL_PROD	NUMBER
TOTAL_BACKLOG	NUMBER
FCST_CONSENSUS	NUMBER
BUDGET	NUMBER
SALES_FCST	NUMBER
MKTG_FCST	NUMBER
FCST_BOOKING	NUMBER
FCST_SHIPMENT	NUMBER
PROJ_BACKLOG	NUMBER
RECORD_TYPE	NUMBER
EBS_RETURN_HISTORY	NUMBER
FCST_HYP_ANNUAL_PLAN	NUMBER
FCST_HYP_FINANCIAL	NUMBER
C_PRED	NUMBER
ACTUAL_ON_HAND	NUMBER
EBS_BH_BOOK_QTY_RD	NUMBER

Query Text

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


SELECT SDATE
,      LEVEL1
,      LEVEL2
,      LEVEL3
,      LEVEL4
,      EBS_BH_BOOK_QTY_BD
,      EBS_SH_SHIP_QTY_SD
,      ACRY_MAPE_PCT_ERR
,      PRTY_DEMAND
,      WEEK4_ABS_PCT_ERR
,      WEEK8_ABS_PCT_ERR
,      WEEK13_ABS_PCT_ERR
,      DKEY_ITEM
,      DKEY_SITE
,      ACTUAL_PROD
,      TOTAL_BACKLOG
,      FCST_CONSENSUS
,      BUDGET
,      SALES_FCST
,      MKTG_FCST
,      FCST_BOOKING
,      FCST_SHIPMENT
,      PROJ_BACKLOG
,      RECORD_TYPE
,      EBS_RETURN_HISTORY
,      FCST_HYP_ANNUAL_PLAN
,      FCST_HYP_FINANCIAL
,      C_PRED
,      ACTUAL_ON_HAND
,      EBS_BH_BOOK_QTY_RD
FROM MSD.MSD_DEM_BIEO_OBI_MV_DUMMY#;

Dependencies

[top of page]

MSD.MSD_DEM_BIEO_OBI_MV_DUMMY# references the following:

MSD: MSD_DEM_BIEO_OBI_MV_DUMMY

MSD.MSD_DEM_BIEO_OBI_MV_DUMMY# is referenced by following:

APPS: MSD_DEM_BIEO_OBI_MV_DUMMY; MSD_DEM_BIEO_OBI_MV_SYN