MSC_ITEM_SUPPLIERSRC_V

Details

• Schema: FUSION

• Object owner: MSC

• Object type: VIEW

Columns

Name

PLAN_ID ASL_ID GLOBAL_ASL_FLAG ORGANIZATION_ID SUPPLIER_ID SUPPLIER_SITE_ID INVENTORY_ITEM_ID PROCESSING_LEAD_TIME MINIMUM_ORDER_QUANTITY FIXED_LOT_MULTIPLIER DELIVERY_CALENDAR_CODE SUPPLIER_CAP_OVER_UTIL_COST LAST_UPDATE_DATE LAST_UPDATED_BY CREATION_DATE CREATED_BY LAST_UPDATE_LOGIN ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 REFRESH_NUMBER PURCHASING_UNIT_OF_MEASURE COLLECTED_FLAG ITEM_PRICE SUPPLIER_ITEM_NAME PLANNER_CODE VMI_FLAG MIN_MINMAX_QUANTITY MAX_MINMAX_QUANTITY MAXIMUM_ORDER_QUANTITY UOM_CODE VMI_REPLENISHMENT_APPROVAL ENABLE_VMI_AUTO_REPLENISH_FLAG DESCRIPTION AVERAGE_DAILY_DEMAND SUPPLIER_LEAD_TIME_DATE REPLENISHMENT_METHOD MIN_MINMAX_DAYS MAX_MINMAX_DAYS FORECAST_HORIZON FIXED_ORDER_QUANTITY VMI_REFRESH_FLAG CAPACITY_TYPE INCLUDE_LIABILITY_AGREEMENT ASL_LIABILITY_AGREEMENT_BASIS ASL_ATTRIBUTE_CREATION_DATE OBJECT_VERSION_NUMBER

Query

SQL_Statement

SELECT PLAN_ID, ASL_ID, GLOBAL_ASL_FLAG, ORGANIZATION_ID, SUPPLIER_ID, SUPPLIER_SITE_ID, INVENTORY_ITEM_ID, PROCESSING_LEAD_TIME, MINIMUM_ORDER_QUANTITY, FIXED_LOT_MULTIPLIER, DELIVERY_CALENDAR_CODE, SUPPLIER_CAP_OVER_UTIL_COST, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, ATTRIBUTE_CATEGORY, ATTRIBUTE1, ATTRIBUTE2, ATTRIBUTE3, ATTRIBUTE4, ATTRIBUTE5, ATTRIBUTE6, ATTRIBUTE7, ATTRIBUTE8, ATTRIBUTE9, ATTRIBUTE10, ATTRIBUTE11, ATTRIBUTE12, ATTRIBUTE13, ATTRIBUTE14, ATTRIBUTE15, REFRESH_NUMBER, PURCHASING_UNIT_OF_MEASURE, COLLECTED_FLAG, ITEM_PRICE, SUPPLIER_ITEM_NAME, PLANNER_CODE, VMI_FLAG, MIN_MINMAX_QUANTITY, MAX_MINMAX_QUANTITY, MAXIMUM_ORDER_QUANTITY, UOM_CODE, VMI_REPLENISHMENT_APPROVAL, ENABLE_VMI_AUTO_REPLENISH_FLAG, DESCRIPTION, AVERAGE_DAILY_DEMAND, SUPPLIER_LEAD_TIME_DATE, REPLENISHMENT_METHOD, MIN_MINMAX_DAYS, MAX_MINMAX_DAYS, FORECAST_HORIZON, FIXED_ORDER_QUANTITY, VMI_REFRESH_FLAG, CAPACITY_TYPE, INCLUDE_LIABILITY_AGREEMENT, ASL_LIABILITY_AGREEMENT_BASIS, ASL_ATTRIBUTE_CREATION_DATE, OBJECT_VERSION_NUMBER FROM MSC_ITEM_SUPPLIERS