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.

[Home] [Help]

VIEW: MSC.MSC_ST_DEMANTRA_ODS_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, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, CUSTOMER_ID CUSTOMER_ID, CUSTOMER_SITE_ID CUSTOMER_SITE_ID, REGION_ID REGION_ID, ORGANIZATION_CODE ORGANIZATION_CODE, ITEM_NAME ITEM_NAME, CUSTOMER_NAME CUSTOMER_NAME, CUSTOMER_SITE_CODE CUSTOMER_SITE_CODE, ZONE ZONE, DEMAND_CLASS DEMAND_CLASS, END_DATE END_DATE, PRODUCTION_HISTORY PRODUCTION_HISTORY, SALES_FCST SALES_FCST, SALES_FCST_VALUE SALES_FCST_VALUE, SALES_FCST_VALUE2 SALES_FCST_VALUE2, SALES_FCST_CUM SALES_FCST_CUM, MKTG_FCST MKTG_FCST, MKTG_FCST_VALUE MKTG_FCST_VALUE, MKTG_FCST_VALUE2 MKTG_FCST_VALUE2, MKTG_FCST_CUM MKTG_FCST_CUM, BUDGET BUDGET, BUDGET2 BUDGET2, BUDGET_CUM BUDGET_CUM, BUDGET2_CUM BUDGET2_CUM, BOOKING_FCST BOOKING_FCST, BOOKING_FCST_VALUE BOOKING_FCST_VALUE, BOOKING_FCST_VALUE2 BOOKING_FCST_VALUE2, BOOKING_FCST_CUM BOOKING_FCST_CUM, SHIPMENT_FCST SHIPMENT_FCST, SHIPMENT_FCST_VALUE SHIPMENT_FCST_VALUE, SHIPMENT_FCST_VALUE2 SHIPMENT_FCST_VALUE2, SHIPMENT_FCST_CUM SHIPMENT_FCST_CUM, PROJECTED_BACKLOG PROJECTED_BACKLOG, ACTUAL_BACKLOG ACTUAL_BACKLOG, SHIPMENT_HISTORY SHIPMENT_HISTORY, SHIPMENT_HISTORY_VALUE SHIPMENT_HISTORY_VALUE, SHIPMENT_HISTORY_VALUE2 SHIPMENT_HISTORY_VALUE2, SHIPMENT_HISTORY_CUM SHIPMENT_HISTORY_CUM, BOOKING_HISTORY BOOKING_HISTORY, BOOKING_HISTORY_VALUE BOOKING_HISTORY_VALUE, BOOKING_HISTORY_VALUE2 BOOKING_HISTORY_VALUE2, BOOKING_HISTORY_CUM BOOKING_HISTORY_CUM, CONSEN_FCST_ACCRCY_MAPE_4WEEK CONSEN_FCST_ACCRCY_MAPE_4WEEK, CONSEN_FCST_ACCRCY_MAPE_8WEEK CONSEN_FCST_ACCRCY_MAPE_8WEEK, CONSEN_FCST_ACCRCY_MAPE_13WEEK CONSEN_FCST_ACCRCY_MAPE_13WEEK, 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, RETURNS_HISTORY RETURNS_HISTORY, ANNUAL_PLAN_VALUE ANNUAL_PLAN_VALUE, ANNUAL_PLAN_VALUE2 ANNUAL_PLAN_VALUE2, FINANCIAL_FCST_VALUE FINANCIAL_FCST_VALUE, FINANCIAL_FCST_VALUE2 FINANCIAL_FCST_VALUE2, FINAL_FCST FINAL_FCST, FINAL_FCST_VALUE FINAL_FCST_VALUE, FINAL_FCST_VALUE2 FINAL_FCST_VALUE2, FINAL_FCST_CUM FINAL_FCST_CUM, PROJECTED_BACKLOG_VALUE PROJECTED_BACKLOG_VALUE, PROJECTED_BACKLOG_VALUE2 PROJECTED_BACKLOG_VALUE2, ACTUAL_BACKLOG_VALUE ACTUAL_BACKLOG_VALUE, ACTUAL_BACKLOG_VALUE2 ACTUAL_BACKLOG_VALUE2, INVENTORY_HISTORY INVENTORY_HISTORY, INVENTORY_HISTORY_VALUE INVENTORY_HISTORY_VALUE, INVENTORY_HISTORY_VALUE2 INVENTORY_HISTORY_VALUE2, BOOKING_HISTORY_RD BOOKING_HISTORY_RD, BOOKING_HISTORY_RD_VALUE BOOKING_HISTORY_RD_VALUE, BOOKING_HISTORY_RD_VALUE2 BOOKING_HISTORY_RD_VALUE2, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, OWNING_INST_ID OWNING_INST_ID, OWNING_ORG_CODE OWNING_ORG_CODE, OWNING_ORG_ID OWNING_ORG_ID from "MSC"."MSC_ST_DEMANTRA_ODS_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
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, CUSTOMER_ID CUSTOMER_ID
, CUSTOMER_SITE_ID CUSTOMER_SITE_ID
, REGION_ID REGION_ID
, ORGANIZATION_CODE ORGANIZATION_CODE
, ITEM_NAME ITEM_NAME
, CUSTOMER_NAME CUSTOMER_NAME
, CUSTOMER_SITE_CODE CUSTOMER_SITE_CODE
, ZONE ZONE
, DEMAND_CLASS DEMAND_CLASS
, END_DATE END_DATE
, PRODUCTION_HISTORY PRODUCTION_HISTORY
, SALES_FCST SALES_FCST
, SALES_FCST_VALUE SALES_FCST_VALUE
, SALES_FCST_VALUE2 SALES_FCST_VALUE2
, SALES_FCST_CUM SALES_FCST_CUM
, MKTG_FCST MKTG_FCST
, MKTG_FCST_VALUE MKTG_FCST_VALUE
, MKTG_FCST_VALUE2 MKTG_FCST_VALUE2
, MKTG_FCST_CUM MKTG_FCST_CUM
, BUDGET BUDGET
, BUDGET2 BUDGET2
, BUDGET_CUM BUDGET_CUM
, BUDGET2_CUM BUDGET2_CUM
, BOOKING_FCST BOOKING_FCST
, BOOKING_FCST_VALUE BOOKING_FCST_VALUE
, BOOKING_FCST_VALUE2 BOOKING_FCST_VALUE2
, BOOKING_FCST_CUM BOOKING_FCST_CUM
, SHIPMENT_FCST SHIPMENT_FCST
, SHIPMENT_FCST_VALUE SHIPMENT_FCST_VALUE
, SHIPMENT_FCST_VALUE2 SHIPMENT_FCST_VALUE2
, SHIPMENT_FCST_CUM SHIPMENT_FCST_CUM
, PROJECTED_BACKLOG PROJECTED_BACKLOG
, ACTUAL_BACKLOG ACTUAL_BACKLOG
, SHIPMENT_HISTORY SHIPMENT_HISTORY
, SHIPMENT_HISTORY_VALUE SHIPMENT_HISTORY_VALUE
, SHIPMENT_HISTORY_VALUE2 SHIPMENT_HISTORY_VALUE2
, SHIPMENT_HISTORY_CUM SHIPMENT_HISTORY_CUM
, BOOKING_HISTORY BOOKING_HISTORY
, BOOKING_HISTORY_VALUE BOOKING_HISTORY_VALUE
, BOOKING_HISTORY_VALUE2 BOOKING_HISTORY_VALUE2
, BOOKING_HISTORY_CUM BOOKING_HISTORY_CUM
, CONSEN_FCST_ACCRCY_MAPE_4WEEK CONSEN_FCST_ACCRCY_MAPE_4WEEK
, CONSEN_FCST_ACCRCY_MAPE_8WEEK CONSEN_FCST_ACCRCY_MAPE_8WEEK
, CONSEN_FCST_ACCRCY_MAPE_13WEEK CONSEN_FCST_ACCRCY_MAPE_13WEEK
, 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
, RETURNS_HISTORY RETURNS_HISTORY
, ANNUAL_PLAN_VALUE ANNUAL_PLAN_VALUE
, ANNUAL_PLAN_VALUE2 ANNUAL_PLAN_VALUE2
, FINANCIAL_FCST_VALUE FINANCIAL_FCST_VALUE
, FINANCIAL_FCST_VALUE2 FINANCIAL_FCST_VALUE2
, FINAL_FCST FINAL_FCST
, FINAL_FCST_VALUE FINAL_FCST_VALUE
, FINAL_FCST_VALUE2 FINAL_FCST_VALUE2
, FINAL_FCST_CUM FINAL_FCST_CUM
, PROJECTED_BACKLOG_VALUE PROJECTED_BACKLOG_VALUE
, PROJECTED_BACKLOG_VALUE2 PROJECTED_BACKLOG_VALUE2
, ACTUAL_BACKLOG_VALUE ACTUAL_BACKLOG_VALUE
, ACTUAL_BACKLOG_VALUE2 ACTUAL_BACKLOG_VALUE2
, INVENTORY_HISTORY INVENTORY_HISTORY
, INVENTORY_HISTORY_VALUE INVENTORY_HISTORY_VALUE
, INVENTORY_HISTORY_VALUE2 INVENTORY_HISTORY_VALUE2
, BOOKING_HISTORY_RD BOOKING_HISTORY_RD
, BOOKING_HISTORY_RD_VALUE BOOKING_HISTORY_RD_VALUE
, BOOKING_HISTORY_RD_VALUE2 BOOKING_HISTORY_RD_VALUE2
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, OWNING_INST_ID OWNING_INST_ID
, OWNING_ORG_CODE OWNING_ORG_CODE
, OWNING_ORG_ID OWNING_ORG_ID
FROM "MSC"."MSC_ST_DEMANTRA_ODS_F"