VIEW: MSC.MSC_ST_ITEM_ORDERS_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, ORGANIZATION_CODE ORGANIZATION_CODE, OWNING_ORG_CODE OWNING_ORG_CODE, ITEM_NAME ITEM_NAME, VMI_FLAG VMI_FLAG, ORDER_DATE ORDER_DATE, DEMAND_QTY DEMAND_QTY, PEGGED_TO_EXCESS_QTY PEGGED_TO_EXCESS_QTY, SUPPLY_QTY SUPPLY_QTY, PLANNED_ORDER_QTY PLANNED_ORDER_QTY, INDEP_DEMAND_QTY INDEP_DEMAND_QTY, DEP_DEMAND_QTY DEP_DEMAND_QTY, SALES_ORDER_VALUE SALES_ORDER_VALUE, RETURN_ORDER_VALUE RETURN_ORDER_VALUE, MAKE_ORDER_QTY MAKE_ORDER_QTY, MAKE_ORDER_LEADTIME MAKE_ORDER_LEADTIME, MAKE_ORDER_COUNT MAKE_ORDER_COUNT, STOCK_OUTS_COUNT STOCK_OUTS_COUNT, NO_ACTIVITY_ITEM_COUNT NO_ACTIVITY_ITEM_COUNT, ITEM_LEADTIME ITEM_LEADTIME, AVG_DAILY_DEMAND AVG_DAILY_DEMAND, DAYS_IN_BKT DAYS_IN_BKT, INDEP_DEMAND_VALUE INDEP_DEMAND_VALUE, SCHEDULED_REPT_QTY SCHEDULED_REPT_QTY, ONHAND_QTY ONHAND_QTY, FORECAST_QTY FORECAST_QTY, 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, ONHAND_USABLE ONHAND_USABLE, INTRANSIT_USABLE INTRANSIT_USABLE, PLND_XFER_USABLE PLND_XFER_USABLE, ONHAND_DEFECTIVE ONHAND_DEFECTIVE, INTRANSIT_DEFECTIVE INTRANSIT_DEFECTIVE, PLND_XFER_DEFECTIVE PLND_XFER_DEFECTIVE, DMD_PGD_TO_SCHD_RECP DMD_PGD_TO_SCHD_RECP, DMD_PGD_TO_PLND_ORDER DMD_PGD_TO_PLND_ORDER, DMD_PGD_TO_ONHAND DMD_PGD_TO_ONHAND, SUP_END_PGD_TO_FCST SUP_END_PGD_TO_FCST, SUP_END_PGD_TO_SO SUP_END_PGD_TO_SO, SUP_END_PGD_TO_SS SUP_END_PGD_TO_SS, SUP_END_PGD_TO_EXCESS SUP_END_PGD_TO_EXCESS, DMD_PGD_TO_SCHD_RECP_VALUE DMD_PGD_TO_SCHD_RECP_VALUE, DMD_PGD_TO_PLND_ORDER_VALUE DMD_PGD_TO_PLND_ORDER_VALUE, DMD_PGD_TO_ONHAND_VALUE DMD_PGD_TO_ONHAND_VALUE, SUP_END_PGD_TO_FCST_VALUE SUP_END_PGD_TO_FCST_VALUE, SUP_END_PGD_TO_SO_VALUE SUP_END_PGD_TO_SO_VALUE, SUP_END_PGD_TO_SS_VALUE SUP_END_PGD_TO_SS_VALUE, SUP_END_PGD_TO_EXCESS_VALUE SUP_END_PGD_TO_EXCESS_VALUE, DMD_PGD_TO_SCHD_RECP_VALUE2 DMD_PGD_TO_SCHD_RECP_VALUE2, DMD_PGD_TO_PLND_ORDER_VALUE2 DMD_PGD_TO_PLND_ORDER_VALUE2, DMD_PGD_TO_ONHAND_VALUE2 DMD_PGD_TO_ONHAND_VALUE2, SUP_END_PGD_TO_FCST_VALUE2 SUP_END_PGD_TO_FCST_VALUE2, SUP_END_PGD_TO_SO_VALUE2 SUP_END_PGD_TO_SO_VALUE2, SUP_END_PGD_TO_SS_VALUE2 SUP_END_PGD_TO_SS_VALUE2, SUP_END_PGD_TO_EXCESS_VALUE2 SUP_END_PGD_TO_EXCESS_VALUE2, SUPPLY_QTY_USABLE SUPPLY_QTY_USABLE, SUPPLY_QTY_DEFECTIVE SUPPLY_QTY_DEFECTIVE, ONHAND_VALUE ONHAND_VALUE, ONHAND_VALUE2 ONHAND_VALUE2, SCHEDULED_REPT_VALUE SCHEDULED_REPT_VALUE, SCHEDULED_REPT_VALUE2 SCHEDULED_REPT_VALUE2, SALES_ORDER_VALUE2 SALES_ORDER_VALUE2, SUBINVENTORY_CODE SUBINVENTORY_CODE from "MSC"."MSC_ST_ITEM_ORDERS_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
, ORGANIZATION_CODE ORGANIZATION_CODE
, OWNING_ORG_CODE OWNING_ORG_CODE
, ITEM_NAME ITEM_NAME
, VMI_FLAG VMI_FLAG
, ORDER_DATE ORDER_DATE
, DEMAND_QTY DEMAND_QTY
, PEGGED_TO_EXCESS_QTY PEGGED_TO_EXCESS_QTY
, SUPPLY_QTY SUPPLY_QTY
, PLANNED_ORDER_QTY PLANNED_ORDER_QTY
, INDEP_DEMAND_QTY INDEP_DEMAND_QTY
, DEP_DEMAND_QTY DEP_DEMAND_QTY
, SALES_ORDER_VALUE SALES_ORDER_VALUE
, RETURN_ORDER_VALUE RETURN_ORDER_VALUE
, MAKE_ORDER_QTY MAKE_ORDER_QTY
, MAKE_ORDER_LEADTIME MAKE_ORDER_LEADTIME
, MAKE_ORDER_COUNT MAKE_ORDER_COUNT
, STOCK_OUTS_COUNT STOCK_OUTS_COUNT
, NO_ACTIVITY_ITEM_COUNT NO_ACTIVITY_ITEM_COUNT
, ITEM_LEADTIME ITEM_LEADTIME
, AVG_DAILY_DEMAND AVG_DAILY_DEMAND
, DAYS_IN_BKT DAYS_IN_BKT
, INDEP_DEMAND_VALUE INDEP_DEMAND_VALUE
, SCHEDULED_REPT_QTY SCHEDULED_REPT_QTY
, ONHAND_QTY ONHAND_QTY
, FORECAST_QTY FORECAST_QTY
, 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
, ONHAND_USABLE ONHAND_USABLE
, INTRANSIT_USABLE INTRANSIT_USABLE
, PLND_XFER_USABLE PLND_XFER_USABLE
, ONHAND_DEFECTIVE ONHAND_DEFECTIVE
, INTRANSIT_DEFECTIVE INTRANSIT_DEFECTIVE
, PLND_XFER_DEFECTIVE PLND_XFER_DEFECTIVE
, DMD_PGD_TO_SCHD_RECP DMD_PGD_TO_SCHD_RECP
, DMD_PGD_TO_PLND_ORDER DMD_PGD_TO_PLND_ORDER
, DMD_PGD_TO_ONHAND DMD_PGD_TO_ONHAND
, SUP_END_PGD_TO_FCST SUP_END_PGD_TO_FCST
, SUP_END_PGD_TO_SO SUP_END_PGD_TO_SO
, SUP_END_PGD_TO_SS SUP_END_PGD_TO_SS
, SUP_END_PGD_TO_EXCESS SUP_END_PGD_TO_EXCESS
, DMD_PGD_TO_SCHD_RECP_VALUE DMD_PGD_TO_SCHD_RECP_VALUE
, DMD_PGD_TO_PLND_ORDER_VALUE DMD_PGD_TO_PLND_ORDER_VALUE
, DMD_PGD_TO_ONHAND_VALUE DMD_PGD_TO_ONHAND_VALUE
, SUP_END_PGD_TO_FCST_VALUE SUP_END_PGD_TO_FCST_VALUE
, SUP_END_PGD_TO_SO_VALUE SUP_END_PGD_TO_SO_VALUE
, SUP_END_PGD_TO_SS_VALUE SUP_END_PGD_TO_SS_VALUE
, SUP_END_PGD_TO_EXCESS_VALUE SUP_END_PGD_TO_EXCESS_VALUE
, DMD_PGD_TO_SCHD_RECP_VALUE2 DMD_PGD_TO_SCHD_RECP_VALUE2
, DMD_PGD_TO_PLND_ORDER_VALUE2 DMD_PGD_TO_PLND_ORDER_VALUE2
, DMD_PGD_TO_ONHAND_VALUE2 DMD_PGD_TO_ONHAND_VALUE2
, SUP_END_PGD_TO_FCST_VALUE2 SUP_END_PGD_TO_FCST_VALUE2
, SUP_END_PGD_TO_SO_VALUE2 SUP_END_PGD_TO_SO_VALUE2
, SUP_END_PGD_TO_SS_VALUE2 SUP_END_PGD_TO_SS_VALUE2
, SUP_END_PGD_TO_EXCESS_VALUE2 SUP_END_PGD_TO_EXCESS_VALUE2
, SUPPLY_QTY_USABLE SUPPLY_QTY_USABLE
, SUPPLY_QTY_DEFECTIVE SUPPLY_QTY_DEFECTIVE
, ONHAND_VALUE ONHAND_VALUE
, ONHAND_VALUE2 ONHAND_VALUE2
, SCHEDULED_REPT_VALUE SCHEDULED_REPT_VALUE
, SCHEDULED_REPT_VALUE2 SCHEDULED_REPT_VALUE2
, SALES_ORDER_VALUE2 SALES_ORDER_VALUE2
, SUBINVENTORY_CODE SUBINVENTORY_CODE
FROM "MSC"."MSC_ST_ITEM_ORDERS_F"