View: MSC_ITEM_SUPPLIER_V

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

View Text

SELECT MIS.ROWID
, MIS.PLAN_ID
, MIS.SUPPLIER_ID
, MTP.PARTNER_NAME
, MIS.SUPPLIER_SITE_ID
, MTPS.TP_SITE_CODE
, MIS.ORGANIZATION_ID
, MTP2.ORGANIZATION_CODE
, MIS.INVENTORY_ITEM_ID
, MSI.ITEM_NAME
, MIS.SR_INSTANCE_ID
, MIS.USING_ORGANIZATION_ID
, MSC_GET_NAME.ORG_CODE(MIS.USING_ORGANIZATION_ID
, MIS.SR_INSTANCE_ID)
, MIS.PROCESSING_LEAD_TIME
, MIS.MINIMUM_ORDER_QUANTITY
, MIS.FIXED_LOT_MULTIPLIER
, MIS.SUPPLIER_CAP_OVER_UTIL_COST/100
, MIS.DELIVERY_CALENDAR_CODE
, MIS.LAST_UPDATE_DATE
, MIS.LAST_UPDATED_BY
, MIS.CREATION_DATE
, MIS.CREATED_BY
, MIS.LAST_UPDATE_LOGIN
, MIS.COLLECTED_FLAG
, MIS.ITEM_PRICE
, MIS.SUPPLIER_LEAD_TIME_DATE
FROM MSC_TRADING_PARTNERS MTP
, MSC_TRADING_PARTNERS MTP2
, MSC_TRADING_PARTNER_SITES MTPS
, MSC_ITEMS MSI
, MSC_ITEM_SUPPLIERS MIS
WHERE MTP.PARTNER_ID = MIS.SUPPLIER_ID
AND MTP.PARTNER_TYPE = 1
AND MTPS.PARTNER_ID(+) = MIS.SUPPLIER_ID
AND MTPS.PARTNER_SITE_ID(+) = MIS.SUPPLIER_SITE_ID
AND MSI.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 MTP2.PARTNER_TYPE = 3

Columns