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: MSC.MSC_ST_DEMANTRA_ODS_F#

Object Details

Object Name:	MSC_ST_DEMANTRA_ODS_F#
Object Type:	VIEW
Owner:	MSC
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
ST_TRANSACTION_ID	NUMBER		Yes
ERROR_CODE	NUMBER
SR_INSTANCE_ID	NUMBER
ORGANIZATION_ID	NUMBER
INVENTORY_ITEM_ID	NUMBER
CUSTOMER_ID	NUMBER
CUSTOMER_SITE_ID	NUMBER
REGION_ID	NUMBER
ORGANIZATION_CODE	VARCHAR2	(20)
ITEM_NAME	VARCHAR2	(250)
CUSTOMER_NAME	VARCHAR2	(255)
CUSTOMER_SITE_CODE	VARCHAR2	(340)
ZONE	VARCHAR2	(400)
DEMAND_CLASS	VARCHAR2	(30)
END_DATE	DATE		Yes
PRODUCTION_HISTORY	VARCHAR2	(40)
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	VARCHAR2	(40)
SHIPMENT_HISTORY_VALUE	NUMBER
SHIPMENT_HISTORY_VALUE2	NUMBER
SHIPMENT_HISTORY_CUM	NUMBER
BOOKING_HISTORY	VARCHAR2	(40)
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
CREATED_BY	NUMBER		Yes
CREATION_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER		Yes
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATE_LOGIN	NUMBER
PROGRAM_ID	NUMBER
PROGRAM_LOGIN_ID	NUMBER
PROGRAM_APPLICATION_ID	NUMBER
REQUEST_ID	NUMBER
RETURNS_HISTORY	NUMBER
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_VALUE2	NUMBER
INVENTORY_HISTORY	NUMBER
INVENTORY_HISTORY_VALUE	NUMBER
INVENTORY_HISTORY_VALUE2	NUMBER
BOOKING_HISTORY_RD	NUMBER
BOOKING_HISTORY_RD_VALUE	NUMBER
BOOKING_HISTORY_RD_VALUE2	NUMBER
ATTRIBUTE1	NUMBER
ATTRIBUTE2	NUMBER
ATTRIBUTE3	NUMBER
ATTRIBUTE4	NUMBER
ATTRIBUTE5	NUMBER
OWNING_INST_ID	NUMBER
OWNING_ORG_CODE	VARCHAR2	(20)
OWNING_ORG_ID	NUMBER

Query Text

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


SELECT ST_TRANSACTION_ID
,      ERROR_CODE
,      SR_INSTANCE_ID
,      ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      CUSTOMER_ID
,      CUSTOMER_SITE_ID
,      REGION_ID
,      ORGANIZATION_CODE
,      ITEM_NAME
,      CUSTOMER_NAME
,      CUSTOMER_SITE_CODE
,      ZONE
,      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
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      PROGRAM_ID
,      PROGRAM_LOGIN_ID
,      PROGRAM_APPLICATION_ID
,      REQUEST_ID
,      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
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      OWNING_INST_ID
,      OWNING_ORG_CODE
,      OWNING_ORG_ID
FROM MSC.MSC_ST_DEMANTRA_ODS_F#;

Dependencies

[top of page]

MSC.MSC_ST_DEMANTRA_ODS_F# references the following:

MSC: MSC_ST_DEMANTRA_ODS_F

MSC.MSC_ST_DEMANTRA_ODS_F# is referenced by following:

APPS: MSC_ST_DEMANTRA_ODS_F