VIEW: APPS.MSC_SUPPLIERS_TREE_V

Source

View Text - Preformatted

SELECT sup.plan_id, sup.sr_instance_id, sup.organization_id, mtp.organization_code, NULL, mic.category_set_id, mic.sr_category_id, mic.category_name, mic.description, sup.supplier_id, msc_get_name.supplier(sup.supplier_id), sup.supplier_site_id, msc_get_name.supplier_site(sup.supplier_site_id), sup.inventory_item_id, msi.item_name, msi.description, mtp.modeled_supplier_id, mtp.modeled_supplier_site_id FROM msc_items msi, msc_item_categories mic, msc_item_suppliers sup, msc_trading_partners mtp WHERE sup.organization_id = mic.organization_id AND sup.sr_instance_id = mic.sr_instance_id AND sup.inventory_item_id = mic.inventory_item_id AND msi.inventory_item_id = sup.inventory_item_id and sup.using_organization_id = -1 and mtp.sr_instance_id =sup.sr_instance_id and mtp.sr_tp_id =sup.organization_id and mtp.partner_type=3

View Text - HTML Formatted

SELECT SUP.PLAN_ID
, SUP.SR_INSTANCE_ID
, SUP.ORGANIZATION_ID
, MTP.ORGANIZATION_CODE
, NULL
, MIC.CATEGORY_SET_ID
, MIC.SR_CATEGORY_ID
, MIC.CATEGORY_NAME
, MIC.DESCRIPTION
, SUP.SUPPLIER_ID
, MSC_GET_NAME.SUPPLIER(SUP.SUPPLIER_ID)
, SUP.SUPPLIER_SITE_ID
, MSC_GET_NAME.SUPPLIER_SITE(SUP.SUPPLIER_SITE_ID)
, SUP.INVENTORY_ITEM_ID
, MSI.ITEM_NAME
, MSI.DESCRIPTION
, MTP.MODELED_SUPPLIER_ID
, MTP.MODELED_SUPPLIER_SITE_ID
FROM MSC_ITEMS MSI
, MSC_ITEM_CATEGORIES MIC
, MSC_ITEM_SUPPLIERS SUP
, MSC_TRADING_PARTNERS MTP
WHERE SUP.ORGANIZATION_ID = MIC.ORGANIZATION_ID
AND SUP.SR_INSTANCE_ID = MIC.SR_INSTANCE_ID
AND SUP.INVENTORY_ITEM_ID = MIC.INVENTORY_ITEM_ID
AND MSI.INVENTORY_ITEM_ID = SUP.INVENTORY_ITEM_ID
AND SUP.USING_ORGANIZATION_ID = -1
AND MTP.SR_INSTANCE_ID =SUP.SR_INSTANCE_ID
AND MTP.SR_TP_ID =SUP.ORGANIZATION_ID
AND MTP.PARTNER_TYPE=3