DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.MSC_DEMANTRA_ODS_V

Object Details
Object Name: MSC_DEMANTRA_ODS_V
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
PLAN_ID NUMBER

plan id
PLAN_RUN_ID NUMBER

plan run id
ODS_PLAN_ID NUMBER

ods plan id
SR_INSTANCE_ID NUMBER
Yes sr instance id
ORGANIZATION_ID NUMBER

organization id
INVENTORY_ITEM_ID NUMBER
Yes inventory item id
CUSTOMER_ID NUMBER

customer id
CUSTOMER_SITE_ID NUMBER

customer site id
REGION_ID NUMBER

region id
DEMAND_CLASS VARCHAR2 (30)
demand class
FORECAST_DATE DATE

forecast date
SALES_FCST NUMBER

sales forecast
SALES_FCST_VALUE NUMBER

sales forecast value
SALES_FCST_VALUE2 NUMBER

sales forecast value in reporting currency
SALES_FCST_CUM NUMBER

cumulative value sales forecast
MKTG_FCST NUMBER

marketing forecast
MKTG_FCST_VALUE NUMBER

marketing forecast value
MKTG_FCST_VALUE2 NUMBER

marketing forecast value in reporting currency
MKTG_FCST_CUM NUMBER

cumulative value of marketing forecast
BUDGET NUMBER

budget
BUDGET2 NUMBER

budget in reporting currency
BUDGET_CUM NUMBER

cumulative value of budget
BUDGET2_CUM NUMBER

cumulative budget in reporing currency
BOOKING_FCST NUMBER

booking forecast
BOOKING_FCST_VALUE NUMBER

booking forecast value
BOOKING_FCST_VALUE2 NUMBER

booking forecast value in reporting currency
BOOKING_FCST_CUM NUMBER

cumulative booking forecast
SHIPMENT_FCST NUMBER

shipment forecast
SHIPMENT_FCST_VALUE NUMBER

shipment forecast value
SHIPMENT_FCST_VALUE2 NUMBER

shipment forecast value in reporting currency
SHIPMENT_FCST_CUM NUMBER

cumulative shipment forecast
PROJECTED_BACKLOG NUMBER

projected backlog
ACTUAL_BACKLOG NUMBER

actual backlog
PRODUCTION_HISTORY NUMBER

product history
SHIPMENT_HISTORY NUMBER

shipment history
SHIPMENT_HISTORY_VALUE NUMBER

shipment history value
SHIPMENT_HISTORY_VALUE2 NUMBER

shipment history value in reporting currency
BOOKING_HISTORY NUMBER

booking history
BOOKING_HISTORY_VALUE NUMBER

booking history value
BOOKING_HISTORY_VALUE2 NUMBER

booking history value in reporting currency
CONSEN_FCST_ACCRCY_MAPE_4WEEK NUMBER

mape 4 week consensus forecast
CONSEN_FCST_ACCRCY_MAPE_8WEEK NUMBER

mape 8 week consensus forecast
CONSEN_FCST_ACCRCY_MAPE_13WEEK NUMBER

mape 13 week consensus forecast
PRICE NUMBER

price
Query Text

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


SELECT PLAN_ID
,      PLAN_RUN_ID
,      ODS_PLAN_ID
,      SR_INSTANCE_ID
,      ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      CUSTOMER_ID
,      CUSTOMER_SITE_ID
,      REGION_ID
,      DEMAND_CLASS
,      FORECAST_DATE
,      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
,      PRODUCTION_HISTORY
,      SHIPMENT_HISTORY
,      SHIPMENT_HISTORY_VALUE
,      SHIPMENT_HISTORY_VALUE2
,      BOOKING_HISTORY
,      BOOKING_HISTORY_VALUE
,      BOOKING_HISTORY_VALUE2
,      CONSEN_FCST_ACCRCY_MAPE_4WEEK
,      CONSEN_FCST_ACCRCY_MAPE_8WEEK
,      CONSEN_FCST_ACCRCY_MAPE_13WEEK
,      PRICE
FROM APPS.MSC_DEMANTRA_ODS_V;

Dependencies

[top of page]

APPS.MSC_DEMANTRA_ODS_V references the following:

SchemaAPPS
SynonymMSD_DEM_OBI_DEMANTRA_SYN

APPS.MSC_DEMANTRA_ODS_V is not referenced by any database object