VIEW: MSC.MSC_ST_DEMANDS_F#

Source

View Text - Preformatted

select ST_TRANSACTION_ID ST_TRANSACTION_ID, ERROR_CODE ERROR_CODE, SR_INSTANCE_ID SR_INSTANCE_ID, ORGANIZATION_ID ORGANIZATION_ID, OWNING_INST_ID OWNING_INST_ID, OWNING_ORG_ID OWNING_ORG_ID, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, ORIGINAL_ITEM_ID ORIGINAL_ITEM_ID, CUSTOMER_ID CUSTOMER_ID, CUSTOMER_SITE_ID CUSTOMER_SITE_ID, REGION_ID REGION_ID, PROJECT_ID PROJECT_ID, TASK_ID TASK_ID, ORGANIZATION_CODE ORGANIZATION_CODE, OWNING_ORG_CODE OWNING_ORG_CODE, ITEM_NAME ITEM_NAME, ORIGINAL_ITEM_NAME ORIGINAL_ITEM_NAME, CUSTOMER_NAME CUSTOMER_NAME, CUSTOMER_SITE_CODE CUSTOMER_SITE_CODE, ZONE ZONE, PROJECT_NUMBER PROJECT_NUMBER, TASK_NUMBER TASK_NUMBER, DEMAND_CLASS DEMAND_CLASS, ORDER_TYPE ORDER_TYPE, PART_CONDITION PART_CONDITION, VMI_FLAG VMI_FLAG, ORDER_DATE ORDER_DATE, DEMAND_QTY DEMAND_QTY, QTY_BY_DUE_DATE QTY_BY_DUE_DATE, INDEP_DEMAND_COUNT INDEP_DEMAND_COUNT, INDEP_MET_ONTIME_COUNT INDEP_MET_ONTIME_COUNT, INDEP_MET_FULL_COUNT INDEP_MET_FULL_COUNT, INDEP_DEMAND_VALUE INDEP_DEMAND_VALUE, INDEP_DEMAND_VALUE2 INDEP_DEMAND_VALUE2, INDEP_DEMAND_QTY INDEP_DEMAND_QTY, INDEP_BY_DUE_DATE_QTY INDEP_BY_DUE_DATE_QTY, SALES_ORDER_QTY SALES_ORDER_QTY, SALES_ORDER_COUNT SALES_ORDER_COUNT, SALES_ORDER_METR_COUNT SALES_ORDER_METR_COUNT, SALES_ORDER_META_COUNT SALES_ORDER_META_COUNT, FORECAST_QTY FORECAST_QTY, LATE_DMD_STF_FACTOR LATE_DMD_STF_FACTOR, LATE_ORDER_COUNT LATE_ORDER_COUNT, LATE_ORDER_VALUE LATE_ORDER_VALUE, LATE_ORDER_VALUE2 LATE_ORDER_VALUE2, QTY_BY_DUE_DATE_VALUE QTY_BY_DUE_DATE_VALUE, QTY_BY_DUE_DATE_VALUE2 QTY_BY_DUE_DATE_VALUE2, IO_DELIVERED_QTY IO_DELIVERED_QTY, IO_REQUIRED_QTY IO_REQUIRED_QTY, NET_DEMAND NET_DEMAND, CONSTRAINED_FCST CONSTRAINED_FCST, CONSTRAINED_FCST_VALUE CONSTRAINED_FCST_VALUE, CONSTRAINED_FCST_VALUE2 CONSTRAINED_FCST_VALUE2, SERVICE_LEVEL SERVICE_LEVEL, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, PROGRAM_ID PROGRAM_ID, PROGRAM_LOGIN_ID PROGRAM_LOGIN_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, REQUEST_ID REQUEST_ID, ITEM_PARENT_DEMAND ITEM_PARENT_DEMAND, ITEM_PARENT_DEMAND_VALUE ITEM_PARENT_DEMAND_VALUE, DEMAND_FULFILLMENT_LEAD_TIME DEMAND_FULFILLMENT_LEAD_TIME, ANNUALIZED_COGS ANNUALIZED_COGS, SALES_ORDER_RD SALES_ORDER_RD, SALES_ORDER_RD_VALUE SALES_ORDER_RD_VALUE, SALES_ORDER_RD_VALUE2 SALES_ORDER_RD_VALUE2, SALES_ORDER_PD SALES_ORDER_PD, SALES_ORDER_PD_VALUE SALES_ORDER_PD_VALUE, SALES_ORDER_PD_VALUE2 SALES_ORDER_PD_VALUE2, SALES_ORDER_SD SALES_ORDER_SD, SALES_ORDER_SD_VALUE SALES_ORDER_SD_VALUE, SALES_ORDER_SD_VALUE2 SALES_ORDER_SD_VALUE2, LATE_ORDER_QTY LATE_ORDER_QTY from "MSC"."MSC_ST_DEMANDS_F"

View Text - HTML Formatted

SELECT ST_TRANSACTION_ID ST_TRANSACTION_ID
, ERROR_CODE ERROR_CODE
, SR_INSTANCE_ID SR_INSTANCE_ID
, ORGANIZATION_ID ORGANIZATION_ID
, OWNING_INST_ID OWNING_INST_ID
, OWNING_ORG_ID OWNING_ORG_ID
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, ORIGINAL_ITEM_ID ORIGINAL_ITEM_ID
, CUSTOMER_ID CUSTOMER_ID
, CUSTOMER_SITE_ID CUSTOMER_SITE_ID
, REGION_ID REGION_ID
, PROJECT_ID PROJECT_ID
, TASK_ID TASK_ID
, ORGANIZATION_CODE ORGANIZATION_CODE
, OWNING_ORG_CODE OWNING_ORG_CODE
, ITEM_NAME ITEM_NAME
, ORIGINAL_ITEM_NAME ORIGINAL_ITEM_NAME
, CUSTOMER_NAME CUSTOMER_NAME
, CUSTOMER_SITE_CODE CUSTOMER_SITE_CODE
, ZONE ZONE
, PROJECT_NUMBER PROJECT_NUMBER
, TASK_NUMBER TASK_NUMBER
, DEMAND_CLASS DEMAND_CLASS
, ORDER_TYPE ORDER_TYPE
, PART_CONDITION PART_CONDITION
, VMI_FLAG VMI_FLAG
, ORDER_DATE ORDER_DATE
, DEMAND_QTY DEMAND_QTY
, QTY_BY_DUE_DATE QTY_BY_DUE_DATE
, INDEP_DEMAND_COUNT INDEP_DEMAND_COUNT
, INDEP_MET_ONTIME_COUNT INDEP_MET_ONTIME_COUNT
, INDEP_MET_FULL_COUNT INDEP_MET_FULL_COUNT
, INDEP_DEMAND_VALUE INDEP_DEMAND_VALUE
, INDEP_DEMAND_VALUE2 INDEP_DEMAND_VALUE2
, INDEP_DEMAND_QTY INDEP_DEMAND_QTY
, INDEP_BY_DUE_DATE_QTY INDEP_BY_DUE_DATE_QTY
, SALES_ORDER_QTY SALES_ORDER_QTY
, SALES_ORDER_COUNT SALES_ORDER_COUNT
, SALES_ORDER_METR_COUNT SALES_ORDER_METR_COUNT
, SALES_ORDER_META_COUNT SALES_ORDER_META_COUNT
, FORECAST_QTY FORECAST_QTY
, LATE_DMD_STF_FACTOR LATE_DMD_STF_FACTOR
, LATE_ORDER_COUNT LATE_ORDER_COUNT
, LATE_ORDER_VALUE LATE_ORDER_VALUE
, LATE_ORDER_VALUE2 LATE_ORDER_VALUE2
, QTY_BY_DUE_DATE_VALUE QTY_BY_DUE_DATE_VALUE
, QTY_BY_DUE_DATE_VALUE2 QTY_BY_DUE_DATE_VALUE2
, IO_DELIVERED_QTY IO_DELIVERED_QTY
, IO_REQUIRED_QTY IO_REQUIRED_QTY
, NET_DEMAND NET_DEMAND
, CONSTRAINED_FCST CONSTRAINED_FCST
, CONSTRAINED_FCST_VALUE CONSTRAINED_FCST_VALUE
, CONSTRAINED_FCST_VALUE2 CONSTRAINED_FCST_VALUE2
, SERVICE_LEVEL SERVICE_LEVEL
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PROGRAM_ID PROGRAM_ID
, PROGRAM_LOGIN_ID PROGRAM_LOGIN_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, REQUEST_ID REQUEST_ID
, ITEM_PARENT_DEMAND ITEM_PARENT_DEMAND
, ITEM_PARENT_DEMAND_VALUE ITEM_PARENT_DEMAND_VALUE
, DEMAND_FULFILLMENT_LEAD_TIME DEMAND_FULFILLMENT_LEAD_TIME
, ANNUALIZED_COGS ANNUALIZED_COGS
, SALES_ORDER_RD SALES_ORDER_RD
, SALES_ORDER_RD_VALUE SALES_ORDER_RD_VALUE
, SALES_ORDER_RD_VALUE2 SALES_ORDER_RD_VALUE2
, SALES_ORDER_PD SALES_ORDER_PD
, SALES_ORDER_PD_VALUE SALES_ORDER_PD_VALUE
, SALES_ORDER_PD_VALUE2 SALES_ORDER_PD_VALUE2
, SALES_ORDER_SD SALES_ORDER_SD
, SALES_ORDER_SD_VALUE SALES_ORDER_SD_VALUE
, SALES_ORDER_SD_VALUE2 SALES_ORDER_SD_VALUE2
, LATE_ORDER_QTY LATE_ORDER_QTY
FROM "MSC"."MSC_ST_DEMANDS_F"