VIEW: MSC.MSC_SUPPLIES_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, PROJECT_ID PROJECT_ID, TASK_ID TASK_ID, SUPPLIER_ID SUPPLIER_ID, SUPPLIER_SITE_ID SUPPLIER_SITE_ID, SUPPLY_DATE SUPPLY_DATE, SUPPLY_TYPE SUPPLY_TYPE, VMI_FLAG VMI_FLAG, SUPPLY_QTY SUPPLY_QTY, PLANNED_ORDER_COUNT PLANNED_ORDER_COUNT, PLANNED_ORDER_ITF_COUNT PLANNED_ORDER_ITF_COUNT, PLANNED_ORDER_GMOD_COUNT PLANNED_ORDER_GMOD_COUNT, PLANNED_ORDER_BWO_COUNT PLANNED_ORDER_BWO_COUNT, WORK_ORDER_LEADTIME WORK_ORDER_LEADTIME, WORK_ORDER_COUNT WORK_ORDER_COUNT, 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, QTY_PEGGED_TO_EXCESS QTY_PEGGED_TO_EXCESS, STOCKOUT_DAYS STOCKOUT_DAYS, WORK_ORDER_QTY WORK_ORDER_QTY, DRP_SUPPLY_AS_DEMAND DRP_SUPPLY_AS_DEMAND, IO_PLAN_FLAG IO_PLAN_FLAG, RETURN_ORDER_QTY RETURN_ORDER_QTY, REGION_ID REGION_ID, AGGR_TYPE AGGR_TYPE, CATEGORY_SET_ID CATEGORY_SET_ID, SR_CATEGORY_ID SR_CATEGORY_ID, SHIP_METHOD SHIP_METHOD, PART_CONDITION PART_CONDITION, SUPPLY_VOLUME SUPPLY_VOLUME, SOURCE_ORG_INSTANCE_ID SOURCE_ORG_INSTANCE_ID, SOURCE_ORGANIZATION_ID SOURCE_ORGANIZATION_ID, RETURN_FCST RETURN_FCST, OWNING_INST_ID OWNING_INST_ID, OWNING_ORG_ID OWNING_ORG_ID, CUSTOMER_REGION_ID CUSTOMER_REGION_ID, END_ITEM_INST_ID END_ITEM_INST_ID, END_ITEM_ORG_ID END_ITEM_ORG_ID, END_ITEM_ID END_ITEM_ID, PARENT_MODEL_ITEM_ID PARENT_MODEL_ITEM_ID, END_ITEM_CAT_ID END_ITEM_CAT_ID, PARENT_MODEL_CAT_ID PARENT_MODEL_CAT_ID, SUBINVENTORY_CODE SUBINVENTORY_CODE, PO_RESCHEDULE_COUNT PO_RESCHEDULE_COUNT, PO_COUNT PO_COUNT, PO_CANCEL_COUNT PO_CANCEL_COUNT, BUY_ORDER_VALUE BUY_ORDER_VALUE, BUY_ORDER_VALUE2 BUY_ORDER_VALUE2, BUY_ORDER_COUNT BUY_ORDER_COUNT from "MSC"."MSC_SUPPLIES_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
, PROJECT_ID PROJECT_ID
, TASK_ID TASK_ID
, SUPPLIER_ID SUPPLIER_ID
, SUPPLIER_SITE_ID SUPPLIER_SITE_ID
, SUPPLY_DATE SUPPLY_DATE
, SUPPLY_TYPE SUPPLY_TYPE
, VMI_FLAG VMI_FLAG
, SUPPLY_QTY SUPPLY_QTY
, PLANNED_ORDER_COUNT PLANNED_ORDER_COUNT
, PLANNED_ORDER_ITF_COUNT PLANNED_ORDER_ITF_COUNT
, PLANNED_ORDER_GMOD_COUNT PLANNED_ORDER_GMOD_COUNT
, PLANNED_ORDER_BWO_COUNT PLANNED_ORDER_BWO_COUNT
, WORK_ORDER_LEADTIME WORK_ORDER_LEADTIME
, WORK_ORDER_COUNT WORK_ORDER_COUNT
, 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
, QTY_PEGGED_TO_EXCESS QTY_PEGGED_TO_EXCESS
, STOCKOUT_DAYS STOCKOUT_DAYS
, WORK_ORDER_QTY WORK_ORDER_QTY
, DRP_SUPPLY_AS_DEMAND DRP_SUPPLY_AS_DEMAND
, IO_PLAN_FLAG IO_PLAN_FLAG
, RETURN_ORDER_QTY RETURN_ORDER_QTY
, REGION_ID REGION_ID
, AGGR_TYPE AGGR_TYPE
, CATEGORY_SET_ID CATEGORY_SET_ID
, SR_CATEGORY_ID SR_CATEGORY_ID
, SHIP_METHOD SHIP_METHOD
, PART_CONDITION PART_CONDITION
, SUPPLY_VOLUME SUPPLY_VOLUME
, SOURCE_ORG_INSTANCE_ID SOURCE_ORG_INSTANCE_ID
, SOURCE_ORGANIZATION_ID SOURCE_ORGANIZATION_ID
, RETURN_FCST RETURN_FCST
, OWNING_INST_ID OWNING_INST_ID
, OWNING_ORG_ID OWNING_ORG_ID
, CUSTOMER_REGION_ID CUSTOMER_REGION_ID
, END_ITEM_INST_ID END_ITEM_INST_ID
, END_ITEM_ORG_ID END_ITEM_ORG_ID
, END_ITEM_ID END_ITEM_ID
, PARENT_MODEL_ITEM_ID PARENT_MODEL_ITEM_ID
, END_ITEM_CAT_ID END_ITEM_CAT_ID
, PARENT_MODEL_CAT_ID PARENT_MODEL_CAT_ID
, SUBINVENTORY_CODE SUBINVENTORY_CODE
, PO_RESCHEDULE_COUNT PO_RESCHEDULE_COUNT
, PO_COUNT PO_COUNT
, PO_CANCEL_COUNT PO_CANCEL_COUNT
, BUY_ORDER_VALUE BUY_ORDER_VALUE
, BUY_ORDER_VALUE2 BUY_ORDER_VALUE2
, BUY_ORDER_COUNT BUY_ORDER_COUNT
FROM "MSC"."MSC_SUPPLIES_F"