View: MSC_SUPPLIERS_LOV_V

Product:	MSC - Advanced Supply Chain Planning
Description:
Implementation/DBA Data:	APPS.MSC_SUPPLIERS_LOV_V

View Text

SELECT DISTINCT MIS.PLAN_ID
, MIS.ORGANIZATION_ID
, MTP2.ORGANIZATION_CODE
, MIS.SR_INSTANCE_ID
, MIS.SUPPLIER_ID
, MTP.PARTNER_NAME
, MIS.INVENTORY_ITEM_ID
, I.ITEM_NAME
, MIS.PROCESSING_LEAD_TIME
, MIS.MINIMUM_ORDER_QUANTITY
, MIS.FIXED_LOT_MULTIPLIER
, MIS.DELIVERY_CALENDAR_CODE
, MIS.SUPPLIER_CAP_OVER_UTIL_COST/100
FROM MSC_TRADING_PARTNERS MTP
, MSC_TRADING_PARTNERS MTP2
, MSC_ITEMS I
, MSC_ITEM_SUPPLIERS MIS
WHERE I.INVENTORY_ITEM_ID = MIS.INVENTORY_ITEM_ID
AND MTP2.SR_TP_ID = MIS.ORGANIZATION_ID
AND MTP2.SR_INSTANCE_ID = MIS.SR_INSTANCE_ID
AND MIS.USING_ORGANIZATION_ID = -1
AND MTP2.PARTNER_TYPE = 3
AND MTP.PARTNER_ID = MIS.SUPPLIER_ID
AND MTP.PARTNER_TYPE =1

Columns