VIEW: MSC.MSC_ST_ITEM_SUPPLIERS#

Source

View Text - Preformatted

select INVENTORY_ITEM_ID INVENTORY_ITEM_ID, ORGANIZATION_ID ORGANIZATION_ID, SUPPLIER_ID SUPPLIER_ID, SUPPLIER_SITE_ID SUPPLIER_SITE_ID, USING_ORGANIZATION_ID USING_ORGANIZATION_ID, ASL_ID ASL_ID, PROCESSING_LEAD_TIME PROCESSING_LEAD_TIME, MINIMUM_ORDER_QUANTITY MINIMUM_ORDER_QUANTITY, FIXED_LOT_MULTIPLE FIXED_LOT_MULTIPLE, DELIVERY_CALENDAR_CODE DELIVERY_CALENDAR_CODE, VENDOR_NAME VENDOR_NAME, VENDOR_SITE_CODE VENDOR_SITE_CODE, SUPPLIER_CAP_OVER_UTIL_COST SUPPLIER_CAP_OVER_UTIL_COST, DELETED_FLAG DELETED_FLAG, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, SR_INSTANCE_ID SR_INSTANCE_ID, SR_INSTANCE_ID2 SR_INSTANCE_ID2, REFRESH_ID REFRESH_ID, PURCHASING_UNIT_OF_MEASURE PURCHASING_UNIT_OF_MEASURE, ITEM_PRICE ITEM_PRICE, COMPANY_ID COMPANY_ID, COMPANY_NAME COMPANY_NAME, ITEM_NAME ITEM_NAME, ORGANIZATION_CODE ORGANIZATION_CODE, SR_INSTANCE_CODE SR_INSTANCE_CODE, MESSAGE_ID MESSAGE_ID, PROCESS_FLAG PROCESS_FLAG, DATA_SOURCE_TYPE DATA_SOURCE_TYPE, ST_TRANSACTION_ID ST_TRANSACTION_ID, ERROR_TEXT ERROR_TEXT, BATCH_ID BATCH_ID, SUPPLIER_ITEM_NAME SUPPLIER_ITEM_NAME, PLANNER_CODE PLANNER_CODE, SUPPLIER_COMPANY_ID SUPPLIER_COMPANY_ID, SUPPLIER_COMPANY_SITE_ID SUPPLIER_COMPANY_SITE_ID, VMI_FLAG VMI_FLAG, MIN_MINMAX_QUANTITY MIN_MINMAX_QUANTITY, MAX_MINMAX_QUANTITY MAX_MINMAX_QUANTITY, MAXIMUM_ORDER_QUANTITY MAXIMUM_ORDER_QUANTITY, VMI_REPLENISHMENT_APPROVAL VMI_REPLENISHMENT_APPROVAL, ENABLE_VMI_AUTO_REPLENISH_FLAG ENABLE_VMI_AUTO_REPLENISH_FLAG, ASL_LEVEL ASL_LEVEL, USING_ORGANIZATION_CODE USING_ORGANIZATION_CODE, MIN_MINMAX_DAYS MIN_MINMAX_DAYS, MAX_MINMAX_DAYS MAX_MINMAX_DAYS, FIXED_ORDER_QUANTITY FIXED_ORDER_QUANTITY, FORECAST_HORIZON FORECAST_HORIZON, REPLENISHMENT_METHOD REPLENISHMENT_METHOD, ASL_ATTRIBUTE_CREATION_DATE ASL_ATTRIBUTE_CREATION_DATE from "MSC"."MSC_ST_ITEM_SUPPLIERS"

View Text - HTML Formatted

SELECT INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, ORGANIZATION_ID ORGANIZATION_ID
, SUPPLIER_ID SUPPLIER_ID
, SUPPLIER_SITE_ID SUPPLIER_SITE_ID
, USING_ORGANIZATION_ID USING_ORGANIZATION_ID
, ASL_ID ASL_ID
, PROCESSING_LEAD_TIME PROCESSING_LEAD_TIME
, MINIMUM_ORDER_QUANTITY MINIMUM_ORDER_QUANTITY
, FIXED_LOT_MULTIPLE FIXED_LOT_MULTIPLE
, DELIVERY_CALENDAR_CODE DELIVERY_CALENDAR_CODE
, VENDOR_NAME VENDOR_NAME
, VENDOR_SITE_CODE VENDOR_SITE_CODE
, SUPPLIER_CAP_OVER_UTIL_COST SUPPLIER_CAP_OVER_UTIL_COST
, DELETED_FLAG DELETED_FLAG
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, SR_INSTANCE_ID SR_INSTANCE_ID
, SR_INSTANCE_ID2 SR_INSTANCE_ID2
, REFRESH_ID REFRESH_ID
, PURCHASING_UNIT_OF_MEASURE PURCHASING_UNIT_OF_MEASURE
, ITEM_PRICE ITEM_PRICE
, COMPANY_ID COMPANY_ID
, COMPANY_NAME COMPANY_NAME
, ITEM_NAME ITEM_NAME
, ORGANIZATION_CODE ORGANIZATION_CODE
, SR_INSTANCE_CODE SR_INSTANCE_CODE
, MESSAGE_ID MESSAGE_ID
, PROCESS_FLAG PROCESS_FLAG
, DATA_SOURCE_TYPE DATA_SOURCE_TYPE
, ST_TRANSACTION_ID ST_TRANSACTION_ID
, ERROR_TEXT ERROR_TEXT
, BATCH_ID BATCH_ID
, SUPPLIER_ITEM_NAME SUPPLIER_ITEM_NAME
, PLANNER_CODE PLANNER_CODE
, SUPPLIER_COMPANY_ID SUPPLIER_COMPANY_ID
, SUPPLIER_COMPANY_SITE_ID SUPPLIER_COMPANY_SITE_ID
, VMI_FLAG VMI_FLAG
, MIN_MINMAX_QUANTITY MIN_MINMAX_QUANTITY
, MAX_MINMAX_QUANTITY MAX_MINMAX_QUANTITY
, MAXIMUM_ORDER_QUANTITY MAXIMUM_ORDER_QUANTITY
, VMI_REPLENISHMENT_APPROVAL VMI_REPLENISHMENT_APPROVAL
, ENABLE_VMI_AUTO_REPLENISH_FLAG ENABLE_VMI_AUTO_REPLENISH_FLAG
, ASL_LEVEL ASL_LEVEL
, USING_ORGANIZATION_CODE USING_ORGANIZATION_CODE
, MIN_MINMAX_DAYS MIN_MINMAX_DAYS
, MAX_MINMAX_DAYS MAX_MINMAX_DAYS
, FIXED_ORDER_QUANTITY FIXED_ORDER_QUANTITY
, FORECAST_HORIZON FORECAST_HORIZON
, REPLENISHMENT_METHOD REPLENISHMENT_METHOD
, ASL_ATTRIBUTE_CREATION_DATE ASL_ATTRIBUTE_CREATION_DATE
FROM "MSC"."MSC_ST_ITEM_SUPPLIERS"