VIEW: APPS.MSC_ITEM_SUPPLIER_V

Source

View Text - Preformatted

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, MIC.CATEGORY_SET_ID, MIC.SR_CATEGORY_ID, MIC.CATEGORY_NAME, MSI.BUYER_NAME, MSI.PLANNER_CODE, MSI.STANDARD_COST, nvl(MIS.INCLUDE_LIABILITY_AGREEMENT,2), nvl(MIS.ASL_LIABILITY_AGREEMENT_BASIS,2), msc_get_name.lookup_meaning('SYS_YES_NO',nvl(MIS.INCLUDE_LIABILITY_AGREEMENT,2)) FROM msc_trading_partners mtp, msc_trading_partners mtp2, msc_trading_partner_sites mtps, msc_system_items msi, msc_item_categories mic, 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 mis.plan_id = msi.plan_id AND mis.organization_id = msi.organization_id AND mis.sr_instance_id = msi.sr_instance_id AND mis.inventory_item_id = msi.inventory_item_id and msi.sr_instance_id = mic.sr_instance_id and msi.inventory_item_id = mic.inventory_item_id and msi.organization_id = mic.organization_id AND mtp2.sr_tp_id = mis.organization_id AND mtp2.sr_instance_id = mis.sr_instance_id AND mtp2.partner_type = 3

View Text - HTML Formatted

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
, MIC.CATEGORY_SET_ID
, MIC.SR_CATEGORY_ID
, MIC.CATEGORY_NAME
, MSI.BUYER_NAME
, MSI.PLANNER_CODE
, MSI.STANDARD_COST
, NVL(MIS.INCLUDE_LIABILITY_AGREEMENT
, 2)
, NVL(MIS.ASL_LIABILITY_AGREEMENT_BASIS
, 2)
, MSC_GET_NAME.LOOKUP_MEANING('SYS_YES_NO'
, NVL(MIS.INCLUDE_LIABILITY_AGREEMENT
, 2))
FROM MSC_TRADING_PARTNERS MTP
, MSC_TRADING_PARTNERS MTP2
, MSC_TRADING_PARTNER_SITES MTPS
, MSC_SYSTEM_ITEMS MSI
, MSC_ITEM_CATEGORIES MIC
, 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 MIS.PLAN_ID = MSI.PLAN_ID
AND MIS.ORGANIZATION_ID = MSI.ORGANIZATION_ID
AND MIS.SR_INSTANCE_ID = MSI.SR_INSTANCE_ID
AND MIS.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID
AND MSI.SR_INSTANCE_ID = MIC.SR_INSTANCE_ID
AND MSI.INVENTORY_ITEM_ID = MIC.INVENTORY_ITEM_ID
AND MSI.ORGANIZATION_ID = MIC.ORGANIZATION_ID
AND MTP2.SR_TP_ID = MIS.ORGANIZATION_ID
AND MTP2.SR_INSTANCE_ID = MIS.SR_INSTANCE_ID
AND MTP2.PARTNER_TYPE = 3