VIEW: APPS.MSC_SUPPLIERS_LOV_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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