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: APPS.MSD_DEM_OBI_DEMANTRA_MV_DUMMY

Object Details

Object Name:	MSD_DEM_OBI_DEMANTRA_MV_DUMMY
Object Type:	TABLE
Owner:	APPS
Subobject Name:
Status:	VALID

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory
SR_INSTANCE_ID	NUMBER		Yes
ORGANIZATION_ID	NUMBER
INVENTORY_ITEM_ID	NUMBER		Yes
CUSTOMER_ID	NUMBER
CUSTOMER_SITE_ID	NUMBER
REGION_ID	NUMBER
DEMAND_CLASS	VARCHAR2	(30)
END_DATE	DATE
PRODUCTION_HISTORY	NUMBER
SALES_FCST	NUMBER
SALES_FCST_VALUE	NUMBER
SALES_FCST_VALUE2	NUMBER
SALES_FCST_CUM	NUMBER
MKTG_FCST	NUMBER
MKTG_FCST_VALUE	NUMBER
MKTG_FCST_VALUE2	NUMBER
MKTG_FCST_CUM	NUMBER
BUDGET	NUMBER
BUDGET2	NUMBER
BUDGET_CUM	NUMBER
BUDGET2_CUM	NUMBER
BOOKING_FCST	NUMBER
BOOKING_FCST_VALUE	NUMBER
BOOKING_FCST_VALUE2	NUMBER
BOOKING_FCST_CUM	NUMBER
SHIPMENT_FCST	NUMBER
SHIPMENT_FCST_VALUE	NUMBER
SHIPMENT_FCST_VALUE2	NUMBER
SHIPMENT_FCST_CUM	NUMBER
PROJECTED_BACKLOG	NUMBER
ACTUAL_BACKLOG	NUMBER
SHIPMENT_HISTORY	NUMBER
SHIPMENT_HISTORY_VALUE	NUMBER
SHIPMENT_HISTORY_VALUE2	NUMBER
SHIPMENT_HISTORY_CUM	NUMBER
BOOKING_HISTORY	NUMBER
BOOKING_HISTORY_VALUE	NUMBER
BOOKING_HISTORY_VALUE2	NUMBER
BOOKING_HISTORY_CUM	NUMBER
CONSEN_FCST_ACCRCY_MAPE_4WEEK	NUMBER
CONSEN_FCST_ACCRCY_MAPE_8WEEK	NUMBER
CONSEN_FCST_ACCRCY_MAPE_13WEEK	NUMBER
PRICE	NUMBER
CURRENCY_CODE	VARCHAR2	(14)

Query Text

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


SELECT SR_INSTANCE_ID
,      ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      CUSTOMER_ID
,      CUSTOMER_SITE_ID
,      REGION_ID
,      DEMAND_CLASS
,      END_DATE
,      PRODUCTION_HISTORY
,      SALES_FCST
,      SALES_FCST_VALUE
,      SALES_FCST_VALUE2
,      SALES_FCST_CUM
,      MKTG_FCST
,      MKTG_FCST_VALUE
,      MKTG_FCST_VALUE2
,      MKTG_FCST_CUM
,      BUDGET
,      BUDGET2
,      BUDGET_CUM
,      BUDGET2_CUM
,      BOOKING_FCST
,      BOOKING_FCST_VALUE
,      BOOKING_FCST_VALUE2
,      BOOKING_FCST_CUM
,      SHIPMENT_FCST
,      SHIPMENT_FCST_VALUE
,      SHIPMENT_FCST_VALUE2
,      SHIPMENT_FCST_CUM
,      PROJECTED_BACKLOG
,      ACTUAL_BACKLOG
,      SHIPMENT_HISTORY
,      SHIPMENT_HISTORY_VALUE
,      SHIPMENT_HISTORY_VALUE2
,      SHIPMENT_HISTORY_CUM
,      BOOKING_HISTORY
,      BOOKING_HISTORY_VALUE
,      BOOKING_HISTORY_VALUE2
,      BOOKING_HISTORY_CUM
,      CONSEN_FCST_ACCRCY_MAPE_4WEEK
,      CONSEN_FCST_ACCRCY_MAPE_8WEEK
,      CONSEN_FCST_ACCRCY_MAPE_13WEEK
,      PRICE
,      CURRENCY_CODE
FROM APPS.MSD_DEM_OBI_DEMANTRA_MV_DUMMY;

Dependencies

[top of page]

APPS.MSD_DEM_OBI_DEMANTRA_MV_DUMMY does not reference any database object

APPS.MSD_DEM_OBI_DEMANTRA_MV_DUMMY is referenced by following:

APPS: MSD_DEM_OBI_DEMANTRA_SYN