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

VIEW: MSC.MSC_DEMANDS_F#

Object Details
Object Name: MSC_DEMANDS_F#
Object Type: VIEW
Owner: MSC
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
PLAN_ID NUMBER
Yes
PLAN_RUN_ID NUMBER
Yes
SR_INSTANCE_ID NUMBER
Yes
ORGANIZATION_ID NUMBER
Yes
INVENTORY_ITEM_ID NUMBER
Yes
PROJECT_ID NUMBER
Yes
TASK_ID NUMBER
Yes
CUSTOMER_ID NUMBER
Yes
CUSTOMER_SITE_ID NUMBER
Yes
DEMAND_CLASS VARCHAR2 (30) Yes
ORDER_DATE DATE
Yes
ORDER_TYPE NUMBER
Yes
VMI_FLAG NUMBER

DEMAND_QTY NUMBER

QTY_BY_DUE_DATE NUMBER

INDEP_DEMAND_COUNT NUMBER

INDEP_MET_ONTIME_COUNT NUMBER

INDEP_MET_FULL_COUNT NUMBER

INDEP_DEMAND_VALUE NUMBER

INDEP_DEMAND_VALUE2 NUMBER

INDEP_DEMAND_QTY NUMBER

INDEP_BY_DUE_DATE_QTY NUMBER

SALES_ORDER_QTY NUMBER

SALES_ORDER_COUNT NUMBER

SALES_ORDER_METR_COUNT NUMBER

SALES_ORDER_META_COUNT NUMBER

FORECAST_QTY NUMBER

LATE_DMD_STF_FACTOR NUMBER

LATE_ORDER_COUNT NUMBER

LATE_ORDER_VALUE NUMBER

LATE_ORDER_VALUE2 NUMBER

CREATED_BY NUMBER
Yes
CREATION_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER
Yes
PROGRAM_ID NUMBER

PROGRAM_LOGIN_ID NUMBER

PROGRAM_APPLICATION_ID NUMBER

REQUEST_ID NUMBER

QTY_BY_DUE_DATE_VALUE NUMBER

QTY_BY_DUE_DATE_VALUE2 NUMBER

IO_DELIVERED_QTY NUMBER

IO_REQUIRED_QTY NUMBER

NET_DEMAND NUMBER

CONSTRAINED_FCST NUMBER

CONSTRAINED_FCST_VALUE NUMBER

CONSTRAINED_FCST_VALUE2 NUMBER

OWNING_ORG_ID NUMBER

OWNING_INST_ID NUMBER

IO_PLAN_FLAG NUMBER

REGION_ID NUMBER

AGGR_TYPE NUMBER

CATEGORY_SET_ID NUMBER

SR_CATEGORY_ID NUMBER

SERVICE_LEVEL NUMBER

PART_CONDITION NUMBER

ORIGINAL_ITEM_ID NUMBER

ITEM_PARENT_DEMAND NUMBER

ITEM_PARENT_DEMAND_VALUE NUMBER

DEMAND_FULFILLMENT_LEAD_TIME NUMBER

ANNUALIZED_COGS NUMBER

SALES_ORDER_RD NUMBER

SALES_ORDER_RD_VALUE NUMBER

SALES_ORDER_RD_VALUE2 NUMBER

SALES_ORDER_PD NUMBER

SALES_ORDER_PD_VALUE NUMBER

SALES_ORDER_PD_VALUE2 NUMBER

SALES_ORDER_SD NUMBER

SALES_ORDER_SD_VALUE NUMBER

SALES_ORDER_SD_VALUE2 NUMBER

LATE_ORDER_QTY NUMBER

Query Text

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


SELECT PLAN_ID
,      PLAN_RUN_ID
,      SR_INSTANCE_ID
,      ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      PROJECT_ID
,      TASK_ID
,      CUSTOMER_ID
,      CUSTOMER_SITE_ID
,      DEMAND_CLASS
,      ORDER_DATE
,      ORDER_TYPE
,      VMI_FLAG
,      DEMAND_QTY
,      QTY_BY_DUE_DATE
,      INDEP_DEMAND_COUNT
,      INDEP_MET_ONTIME_COUNT
,      INDEP_MET_FULL_COUNT
,      INDEP_DEMAND_VALUE
,      INDEP_DEMAND_VALUE2
,      INDEP_DEMAND_QTY
,      INDEP_BY_DUE_DATE_QTY
,      SALES_ORDER_QTY
,      SALES_ORDER_COUNT
,      SALES_ORDER_METR_COUNT
,      SALES_ORDER_META_COUNT
,      FORECAST_QTY
,      LATE_DMD_STF_FACTOR
,      LATE_ORDER_COUNT
,      LATE_ORDER_VALUE
,      LATE_ORDER_VALUE2
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      PROGRAM_ID
,      PROGRAM_LOGIN_ID
,      PROGRAM_APPLICATION_ID
,      REQUEST_ID
,      QTY_BY_DUE_DATE_VALUE
,      QTY_BY_DUE_DATE_VALUE2
,      IO_DELIVERED_QTY
,      IO_REQUIRED_QTY
,      NET_DEMAND
,      CONSTRAINED_FCST
,      CONSTRAINED_FCST_VALUE
,      CONSTRAINED_FCST_VALUE2
,      OWNING_ORG_ID
,      OWNING_INST_ID
,      IO_PLAN_FLAG
,      REGION_ID
,      AGGR_TYPE
,      CATEGORY_SET_ID
,      SR_CATEGORY_ID
,      SERVICE_LEVEL
,      PART_CONDITION
,      ORIGINAL_ITEM_ID
,      ITEM_PARENT_DEMAND
,      ITEM_PARENT_DEMAND_VALUE
,      DEMAND_FULFILLMENT_LEAD_TIME
,      ANNUALIZED_COGS
,      SALES_ORDER_RD
,      SALES_ORDER_RD_VALUE
,      SALES_ORDER_RD_VALUE2
,      SALES_ORDER_PD
,      SALES_ORDER_PD_VALUE
,      SALES_ORDER_PD_VALUE2
,      SALES_ORDER_SD
,      SALES_ORDER_SD_VALUE
,      SALES_ORDER_SD_VALUE2
,      LATE_ORDER_QTY
FROM MSC.MSC_DEMANDS_F#;

Dependencies

[top of page]

MSC.MSC_DEMANDS_F# references the following:

SchemaMSC
TableMSC_DEMANDS_F
MSC.MSC_DEMANDS_F# is referenced by following:

SchemaAPPS
SynonymMSC_DEMANDS_F