VIEW: MSC.MSC_ST_ITEM_INVENTORY_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, PAB_QTY PAB_QTY, PAB_VALUE PAB_VALUE, PAB_VALUE2 PAB_VALUE2, SAFETY_STOCK_QTY SAFETY_STOCK_QTY, MIN_INVENTORY_LEVEL MIN_INVENTORY_LEVEL, MAX_INVENTORY_LEVEL MAX_INVENTORY_LEVEL, AVG_DAILY_DEMAND AVG_DAILY_DEMAND, INV_BUILD_TARGET INV_BUILD_TARGET, 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, DEMAND_VAR_SS_QTY DEMAND_VAR_SS_QTY, SUP_LTVAR_SS_QTY SUP_LTVAR_SS_QTY, TRANSIT_LTVAR_SS_QTY TRANSIT_LTVAR_SS_QTY, MFG_LTVAR_SS_QTY MFG_LTVAR_SS_QTY, TOTAL_UNPOOLED_SAFETY_STOCK TOTAL_UNPOOLED_SAFETY_STOCK, INVENTORY_COST_POST INVENTORY_COST_POST, INVENTORY_COST_NO_POST2 INVENTORY_COST_NO_POST2, INVENTORY_COST_NO_POST INVENTORY_COST_NO_POST, INVENTORY_VALUE_NO_POST INVENTORY_VALUE_NO_POST, INVENTORY_VALUE_POST INVENTORY_VALUE_POST, INVENTORY_COST_POST2 INVENTORY_COST_POST2, INVENTORY_VALUE_NO_POST2 INVENTORY_VALUE_NO_POST2, INVENTORY_VALUE_POST2 INVENTORY_VALUE_POST2, SAFETY_STOCK_VALUE SAFETY_STOCK_VALUE, SAFETY_STOCK_VALUE2 SAFETY_STOCK_VALUE2, SAFETY_STOCK_DAYS SAFETY_STOCK_DAYS, INVENTORY_VALUE INVENTORY_VALUE, INVENTORY_VALUE2 INVENTORY_VALUE2, MAX_INVENTORY_LEVEL_DOS MAX_INVENTORY_LEVEL_DOS, TARGET_INVENTORY_LEVEL TARGET_INVENTORY_LEVEL, TARGET_INVENTORY_LEVEL_DOS TARGET_INVENTORY_LEVEL_DOS, WH_REQUIRED_CAPACITY WH_REQUIRED_CAPACITY, AVG_CYCLE_STOCK AVG_CYCLE_STOCK, AVG_CYCLE_STOCK_VOLUME AVG_CYCLE_STOCK_VOLUME, IQI_VALUE IQI_VALUE, IQI_VOLUME IQI_VOLUME, AVG_DAILY_DEMAND_VOLUME AVG_DAILY_DEMAND_VOLUME, PAB_VOLUME PAB_VOLUME, SAFETY_STOCK_VOLUME SAFETY_STOCK_VOLUME from "MSC"."MSC_ST_ITEM_INVENTORY_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
, PAB_QTY PAB_QTY
, PAB_VALUE PAB_VALUE
, PAB_VALUE2 PAB_VALUE2
, SAFETY_STOCK_QTY SAFETY_STOCK_QTY
, MIN_INVENTORY_LEVEL MIN_INVENTORY_LEVEL
, MAX_INVENTORY_LEVEL MAX_INVENTORY_LEVEL
, AVG_DAILY_DEMAND AVG_DAILY_DEMAND
, INV_BUILD_TARGET INV_BUILD_TARGET
, 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
, DEMAND_VAR_SS_QTY DEMAND_VAR_SS_QTY
, SUP_LTVAR_SS_QTY SUP_LTVAR_SS_QTY
, TRANSIT_LTVAR_SS_QTY TRANSIT_LTVAR_SS_QTY
, MFG_LTVAR_SS_QTY MFG_LTVAR_SS_QTY
, TOTAL_UNPOOLED_SAFETY_STOCK TOTAL_UNPOOLED_SAFETY_STOCK
, INVENTORY_COST_POST INVENTORY_COST_POST
, INVENTORY_COST_NO_POST2 INVENTORY_COST_NO_POST2
, INVENTORY_COST_NO_POST INVENTORY_COST_NO_POST
, INVENTORY_VALUE_NO_POST INVENTORY_VALUE_NO_POST
, INVENTORY_VALUE_POST INVENTORY_VALUE_POST
, INVENTORY_COST_POST2 INVENTORY_COST_POST2
, INVENTORY_VALUE_NO_POST2 INVENTORY_VALUE_NO_POST2
, INVENTORY_VALUE_POST2 INVENTORY_VALUE_POST2
, SAFETY_STOCK_VALUE SAFETY_STOCK_VALUE
, SAFETY_STOCK_VALUE2 SAFETY_STOCK_VALUE2
, SAFETY_STOCK_DAYS SAFETY_STOCK_DAYS
, INVENTORY_VALUE INVENTORY_VALUE
, INVENTORY_VALUE2 INVENTORY_VALUE2
, MAX_INVENTORY_LEVEL_DOS MAX_INVENTORY_LEVEL_DOS
, TARGET_INVENTORY_LEVEL TARGET_INVENTORY_LEVEL
, TARGET_INVENTORY_LEVEL_DOS TARGET_INVENTORY_LEVEL_DOS
, WH_REQUIRED_CAPACITY WH_REQUIRED_CAPACITY
, AVG_CYCLE_STOCK AVG_CYCLE_STOCK
, AVG_CYCLE_STOCK_VOLUME AVG_CYCLE_STOCK_VOLUME
, IQI_VALUE IQI_VALUE
, IQI_VOLUME IQI_VOLUME
, AVG_DAILY_DEMAND_VOLUME AVG_DAILY_DEMAND_VOLUME
, PAB_VOLUME PAB_VOLUME
, SAFETY_STOCK_VOLUME SAFETY_STOCK_VOLUME
FROM "MSC"."MSC_ST_ITEM_INVENTORY_F"