VIEW: MSC.MSC_ST_DEMANTRA_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, CUSTOMER_ID CUSTOMER_ID, CUSTOMER_SITE_ID CUSTOMER_SITE_ID, REGION_ID REGION_ID, ORGANIZATION_CODE ORGANIZATION_CODE, OWNING_ORG_CODE OWNING_ORG_CODE, ITEM_NAME ITEM_NAME, CUSTOMER_NAME CUSTOMER_NAME, CUSTOMER_SITE_CODE CUSTOMER_SITE_CODE, ZONE ZONE, DEMAND_CLASS DEMAND_CLASS, START_DATE START_DATE, CONSENSUS_FCST CONSENSUS_FCST, CONSENSUS_FCST_VALUE CONSENSUS_FCST_VALUE, CONSENSUS_FCST_VALUE2 CONSENSUS_FCST_VALUE2, CONSENSUS_FCST_CUM CONSENSUS_FCST_CUM, PRIORITY PRIORITY, 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, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ANNUAL_PLAN_VALUE ANNUAL_PLAN_VALUE, ANNUAL_PLAN_VALUE2 ANNUAL_PLAN_VALUE2, BOOKING_FCST BOOKING_FCST, BOOKING_FCST_CUM BOOKING_FCST_CUM, BOOKING_FCST_VALUE BOOKING_FCST_VALUE, BOOKING_FCST_VALUE2 BOOKING_FCST_VALUE2, BUDGET BUDGET, BUDGET2 BUDGET2, BUDGET2_CUM BUDGET2_CUM, BUDGET_CUM BUDGET_CUM, FINAL_FCST FINAL_FCST, FINAL_FCST_CUM FINAL_FCST_CUM, FINAL_FCST_VALUE FINAL_FCST_VALUE, FINAL_FCST_VALUE2 FINAL_FCST_VALUE2, FINANCIAL_FCST_VALUE FINANCIAL_FCST_VALUE, FINANCIAL_FCST_VALUE2 FINANCIAL_FCST_VALUE2, MKTG_FCST MKTG_FCST, MKTG_FCST_CUM MKTG_FCST_CUM, MKTG_FCST_VALUE MKTG_FCST_VALUE, MKTG_FCST_VALUE2 MKTG_FCST_VALUE2, PROJECTED_BACKLOG PROJECTED_BACKLOG, PROJECTED_BACKLOG_VALUE PROJECTED_BACKLOG_VALUE, PROJECTED_BACKLOG_VALUE2 PROJECTED_BACKLOG_VALUE2, SALES_FCST SALES_FCST, SALES_FCST_CUM SALES_FCST_CUM, SALES_FCST_VALUE SALES_FCST_VALUE, SALES_FCST_VALUE2 SALES_FCST_VALUE2, SHIPMENT_FCST SHIPMENT_FCST, SHIPMENT_FCST_CUM SHIPMENT_FCST_CUM, SHIPMENT_FCST_VALUE SHIPMENT_FCST_VALUE, SHIPMENT_FCST_VALUE2 SHIPMENT_FCST_VALUE2 from "MSC"."MSC_ST_DEMANTRA_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
, CUSTOMER_ID CUSTOMER_ID
, CUSTOMER_SITE_ID CUSTOMER_SITE_ID
, REGION_ID REGION_ID
, ORGANIZATION_CODE ORGANIZATION_CODE
, OWNING_ORG_CODE OWNING_ORG_CODE
, ITEM_NAME ITEM_NAME
, CUSTOMER_NAME CUSTOMER_NAME
, CUSTOMER_SITE_CODE CUSTOMER_SITE_CODE
, ZONE ZONE
, DEMAND_CLASS DEMAND_CLASS
, START_DATE START_DATE
, CONSENSUS_FCST CONSENSUS_FCST
, CONSENSUS_FCST_VALUE CONSENSUS_FCST_VALUE
, CONSENSUS_FCST_VALUE2 CONSENSUS_FCST_VALUE2
, CONSENSUS_FCST_CUM CONSENSUS_FCST_CUM
, PRIORITY PRIORITY
, 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
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ANNUAL_PLAN_VALUE ANNUAL_PLAN_VALUE
, ANNUAL_PLAN_VALUE2 ANNUAL_PLAN_VALUE2
, BOOKING_FCST BOOKING_FCST
, BOOKING_FCST_CUM BOOKING_FCST_CUM
, BOOKING_FCST_VALUE BOOKING_FCST_VALUE
, BOOKING_FCST_VALUE2 BOOKING_FCST_VALUE2
, BUDGET BUDGET
, BUDGET2 BUDGET2
, BUDGET2_CUM BUDGET2_CUM
, BUDGET_CUM BUDGET_CUM
, FINAL_FCST FINAL_FCST
, FINAL_FCST_CUM FINAL_FCST_CUM
, FINAL_FCST_VALUE FINAL_FCST_VALUE
, FINAL_FCST_VALUE2 FINAL_FCST_VALUE2
, FINANCIAL_FCST_VALUE FINANCIAL_FCST_VALUE
, FINANCIAL_FCST_VALUE2 FINANCIAL_FCST_VALUE2
, MKTG_FCST MKTG_FCST
, MKTG_FCST_CUM MKTG_FCST_CUM
, MKTG_FCST_VALUE MKTG_FCST_VALUE
, MKTG_FCST_VALUE2 MKTG_FCST_VALUE2
, PROJECTED_BACKLOG PROJECTED_BACKLOG
, PROJECTED_BACKLOG_VALUE PROJECTED_BACKLOG_VALUE
, PROJECTED_BACKLOG_VALUE2 PROJECTED_BACKLOG_VALUE2
, SALES_FCST SALES_FCST
, SALES_FCST_CUM SALES_FCST_CUM
, SALES_FCST_VALUE SALES_FCST_VALUE
, SALES_FCST_VALUE2 SALES_FCST_VALUE2
, SHIPMENT_FCST SHIPMENT_FCST
, SHIPMENT_FCST_CUM SHIPMENT_FCST_CUM
, SHIPMENT_FCST_VALUE SHIPMENT_FCST_VALUE
, SHIPMENT_FCST_VALUE2 SHIPMENT_FCST_VALUE2
FROM "MSC"."MSC_ST_DEMANTRA_F"