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: MSC.MSC_DEMANTRA_ODS_F

Object Details

Object Name:	MSC_DEMANTRA_ODS_F
Object Type:	TABLE
Owner:	MSC
Subobject Name:
Status:	VALID

This is APCC fact table for Demantra ODS measures.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
MSC_DEMANTRA_ODS_F_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CUSTOMER_ID CUSTOMER_SITE_ID REGION_ID SR_INSTANCE_ID END_DATE
MSC_DEMANTRA_ODS_F_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SR_INSTANCE_ID ORGANIZATION_ID END_DATE
MSC_DEMANTRA_ODS_F_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	OWNING_INST_ID OWNING_ORG_ID INVENTORY_ITEM_ID END_DATE

Columns

Name	Datatype	Length	Mandatory	Comments
SR_INSTANCE_ID	NUMBER			Source instance ID
ORGANIZATION_ID	NUMBER			Organization ID
INVENTORY_ITEM_ID	NUMBER			Inventory item ID
CUSTOMER_ID	NUMBER			Customer ID
CUSTOMER_SITE_ID	NUMBER			Customer site ID
REGION_ID	NUMBER			Customer region ID
DEMAND_CLASS	VARCHAR2	(30)		Demand class
END_DATE	DATE		Yes	Fact date
PRODUCTION_HISTORY	NUMBER			Production history quantity
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			Actual backlog
SHIPMENT_HISTORY	NUMBER			Shipment history quantity
SHIPMENT_HISTORY_VALUE	NUMBER			Shipment history value in functional currency
SHIPMENT_HISTORY_VALUE2	NUMBER			Shipment history value in reporting currency
SHIPMENT_HISTORY_CUM	NUMBER
BOOKING_HISTORY	NUMBER			Booking history quantity
BOOKING_HISTORY_VALUE	NUMBER			Booking history value in functional currency
BOOKING_HISTORY_VALUE2	NUMBER			Booking history value in reporting currency
BOOKING_HISTORY_CUM	NUMBER
CONSEN_FCST_ACCRCY_MAPE_4WEEK	NUMBER			Consensus forecast accuracy MAPE 4 weeks
CONSEN_FCST_ACCRCY_MAPE_8WEEK	NUMBER			Consensus forecast accuracy MAPE 8 weeks
CONSEN_FCST_ACCRCY_MAPE_13WEEK	NUMBER			Consensus forecast accuracy MAPE 13 weeks
RETURNS_HISTORY	NUMBER			Returns history quantity
ANNUAL_PLAN_VALUE	NUMBER
ANNUAL_PLAN_VALUE2	NUMBER
FINANCIAL_FCST_VALUE	NUMBER
FINANCIAL_FCST_VALUE2	NUMBER
FINAL_FCST	NUMBER
FINAL_FCST_VALUE	NUMBER
FINAL_FCST_VALUE2	NUMBER
FINAL_FCST_CUM	NUMBER
PROJECTED_BACKLOG_VALUE	NUMBER
PROJECTED_BACKLOG_VALUE2	NUMBER
ACTUAL_BACKLOG_VALUE	NUMBER			Actual backlog value in functional currency
ACTUAL_BACKLOG_VALUE2	NUMBER			Actual backlog value in reporting currency
INVENTORY_HISTORY	NUMBER			Inventory history quantity
INVENTORY_HISTORY_VALUE	NUMBER			Inventory history value in functional currency
INVENTORY_HISTORY_VALUE2	NUMBER			Inventory history value in reporting currency
BOOKING_HISTORY_RD	NUMBER			Booking history quantity on request date
BOOKING_HISTORY_RD_VALUE	NUMBER			Booking history value in functional currency on request date
BOOKING_HISTORY_RD_VALUE2	NUMBER			Booking history value in reporting currency on request date
CREATED_BY	NUMBER		Yes	Standard who column
CREATION_DATE	DATE		Yes	Standard who column
LAST_UPDATED_BY	NUMBER		Yes	Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard who column
LAST_UPDATE_LOGIN	NUMBER			Standard who column
PROGRAM_ID	NUMBER			Standard who column
PROGRAM_LOGIN_ID	NUMBER			Standard who column
PROGRAM_APPLICATION_ID	NUMBER			Standard who column
REQUEST_ID	NUMBER			Standard who column
OWNING_INST_ID	NUMBER			Owning Source instance ID
OWNING_ORG_ID	NUMBER			Owning Organization ID
ATTRIBUTE1	NUMBER			Custom column 1
ATTRIBUTE2	NUMBER			Custom column 2
ATTRIBUTE3	NUMBER			Custom column 3
ATTRIBUTE4	NUMBER			Custom column 4
ATTRIBUTE5	NUMBER			Custom column 5

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
,      RETURNS_HISTORY
,      ANNUAL_PLAN_VALUE
,      ANNUAL_PLAN_VALUE2
,      FINANCIAL_FCST_VALUE
,      FINANCIAL_FCST_VALUE2
,      FINAL_FCST
,      FINAL_FCST_VALUE
,      FINAL_FCST_VALUE2
,      FINAL_FCST_CUM
,      PROJECTED_BACKLOG_VALUE
,      PROJECTED_BACKLOG_VALUE2
,      ACTUAL_BACKLOG_VALUE
,      ACTUAL_BACKLOG_VALUE2
,      INVENTORY_HISTORY
,      INVENTORY_HISTORY_VALUE
,      INVENTORY_HISTORY_VALUE2
,      BOOKING_HISTORY_RD
,      BOOKING_HISTORY_RD_VALUE
,      BOOKING_HISTORY_RD_VALUE2
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      PROGRAM_ID
,      PROGRAM_LOGIN_ID
,      PROGRAM_APPLICATION_ID
,      REQUEST_ID
,      OWNING_INST_ID
,      OWNING_ORG_ID
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
FROM MSC.MSC_DEMANTRA_ODS_F;

Dependencies

[top of page]

MSC.MSC_DEMANTRA_ODS_F does not reference any database object

MSC.MSC_DEMANTRA_ODS_F is referenced by following:

MSC: MSC_DEMANTRA_ODS_F#