VIEW: MSC.MSC_ITEM_INVENTORY_F#

Source

View Text - Preformatted

select PLAN_ID PLAN_ID, PLAN_RUN_ID PLAN_RUN_ID, SR_INSTANCE_ID SR_INSTANCE_ID, ORGANIZATION_ID ORGANIZATION_ID, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, 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, 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, GROSS_MARGIN2 GROSS_MARGIN2, GROSS_MARGIN GROSS_MARGIN, CARRYING_COST2 CARRYING_COST2, CARRYING_COST CARRYING_COST, PURCHASING_COST PURCHASING_COST, PURCHASING_COST2 PURCHASING_COST2, TRANSPORTATION_COST2 TRANSPORTATION_COST2, TRANSPORTATION_COST TRANSPORTATION_COST, MANUFACTURING_COST MANUFACTURING_COST, MANUFACTURING_COST2 MANUFACTURING_COST2, REVENUE2 REVENUE2, REVENUE REVENUE, SUPPLY_CHAIN_COST SUPPLY_CHAIN_COST, SUPPLY_CHAIN_COST2 SUPPLY_CHAIN_COST2, SHIP_METHOD SHIP_METHOD, INV_BUILD_TARGET INV_BUILD_TARGET, IO_PLAN_FLAG IO_PLAN_FLAG, OWNING_ORG_ID OWNING_ORG_ID, OWNING_INST_ID OWNING_INST_ID, AGGR_TYPE AGGR_TYPE, CATEGORY_SET_ID CATEGORY_SET_ID, SR_CATEGORY_ID SR_CATEGORY_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_ITEM_INVENTORY_F"

View Text - HTML Formatted

SELECT PLAN_ID PLAN_ID
, PLAN_RUN_ID PLAN_RUN_ID
, SR_INSTANCE_ID SR_INSTANCE_ID
, ORGANIZATION_ID ORGANIZATION_ID
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, 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
, 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
, GROSS_MARGIN2 GROSS_MARGIN2
, GROSS_MARGIN GROSS_MARGIN
, CARRYING_COST2 CARRYING_COST2
, CARRYING_COST CARRYING_COST
, PURCHASING_COST PURCHASING_COST
, PURCHASING_COST2 PURCHASING_COST2
, TRANSPORTATION_COST2 TRANSPORTATION_COST2
, TRANSPORTATION_COST TRANSPORTATION_COST
, MANUFACTURING_COST MANUFACTURING_COST
, MANUFACTURING_COST2 MANUFACTURING_COST2
, REVENUE2 REVENUE2
, REVENUE REVENUE
, SUPPLY_CHAIN_COST SUPPLY_CHAIN_COST
, SUPPLY_CHAIN_COST2 SUPPLY_CHAIN_COST2
, SHIP_METHOD SHIP_METHOD
, INV_BUILD_TARGET INV_BUILD_TARGET
, IO_PLAN_FLAG IO_PLAN_FLAG
, OWNING_ORG_ID OWNING_ORG_ID
, OWNING_INST_ID OWNING_INST_ID
, AGGR_TYPE AGGR_TYPE
, CATEGORY_SET_ID CATEGORY_SET_ID
, SR_CATEGORY_ID SR_CATEGORY_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_ITEM_INVENTORY_F"