VIEW: MSC.MSC_ST_SUPPLIES_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, SUPPLIER_ID SUPPLIER_ID, SUPPLIER_SITE_ID SUPPLIER_SITE_ID, REGION_ID REGION_ID, PROJECT_ID PROJECT_ID, TASK_ID TASK_ID, ORGANIZATION_CODE ORGANIZATION_CODE, ITEM_NAME ITEM_NAME, SUPPLIER_NAME SUPPLIER_NAME, SUPPLIER_SITE_CODE SUPPLIER_SITE_CODE, ZONE ZONE, PROJECT_NUMBER PROJECT_NUMBER, TASK_NUMBER TASK_NUMBER, SHIP_METHOD SHIP_METHOD, SUPPLY_TYPE SUPPLY_TYPE, PART_CONDITION PART_CONDITION, VMI_FLAG VMI_FLAG, SUPPLY_DATE SUPPLY_DATE, 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, 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, RETURN_ORDER_QTY RETURN_ORDER_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, SUPPLY_VOLUME SUPPLY_VOLUME, SOURCE_ORG_INSTANCE_ID SOURCE_ORG_INSTANCE_ID, SOURCE_ORGANIZATION_ID SOURCE_ORGANIZATION_ID, SOURCE_ORG_CODE SOURCE_ORG_CODE, RETURN_FCST RETURN_FCST, OWNING_INST_ID OWNING_INST_ID, OWNING_ORG_ID OWNING_ORG_ID, OWNING_ORG_CODE OWNING_ORG_CODE, CUSTOMER_REGION_ID CUSTOMER_REGION_ID, CUSTOMER_ZONE CUSTOMER_ZONE, 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_ORG_CODE END_ITEM_ORG_CODE, END_ITEM_NAME END_ITEM_NAME, PARENT_MODEL_ITEM_NAME PARENT_MODEL_ITEM_NAME, 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_ST_SUPPLIES_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
, SUPPLIER_ID SUPPLIER_ID
, SUPPLIER_SITE_ID SUPPLIER_SITE_ID
, REGION_ID REGION_ID
, PROJECT_ID PROJECT_ID
, TASK_ID TASK_ID
, ORGANIZATION_CODE ORGANIZATION_CODE
, ITEM_NAME ITEM_NAME
, SUPPLIER_NAME SUPPLIER_NAME
, SUPPLIER_SITE_CODE SUPPLIER_SITE_CODE
, ZONE ZONE
, PROJECT_NUMBER PROJECT_NUMBER
, TASK_NUMBER TASK_NUMBER
, SHIP_METHOD SHIP_METHOD
, SUPPLY_TYPE SUPPLY_TYPE
, PART_CONDITION PART_CONDITION
, VMI_FLAG VMI_FLAG
, SUPPLY_DATE SUPPLY_DATE
, 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
, 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
, RETURN_ORDER_QTY RETURN_ORDER_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
, SUPPLY_VOLUME SUPPLY_VOLUME
, SOURCE_ORG_INSTANCE_ID SOURCE_ORG_INSTANCE_ID
, SOURCE_ORGANIZATION_ID SOURCE_ORGANIZATION_ID
, SOURCE_ORG_CODE SOURCE_ORG_CODE
, RETURN_FCST RETURN_FCST
, OWNING_INST_ID OWNING_INST_ID
, OWNING_ORG_ID OWNING_ORG_ID
, OWNING_ORG_CODE OWNING_ORG_CODE
, CUSTOMER_REGION_ID CUSTOMER_REGION_ID
, CUSTOMER_ZONE CUSTOMER_ZONE
, 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_ORG_CODE END_ITEM_ORG_CODE
, END_ITEM_NAME END_ITEM_NAME
, PARENT_MODEL_ITEM_NAME PARENT_MODEL_ITEM_NAME
, 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_ST_SUPPLIES_F"