eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.MSC_ITEMS_TREE_V

Source

View Text - Preformatted


SELECT msi.sr_instance_id, msi.plan_id, msi.organization_id, msi.organization_code, tp.partner_name, msi.inventory_item_id, msi.item_name, msi.description, mic.category_set_id, mic.sr_category_id, NVL(msi.product_family_id,msi.base_item_id), msi.base_item_id, msi.abc_class, msi.abc_class_name, msi.buyer_id, msi.buyer_name, msi.planner_code, mic.category_name, tp.modeled_supplier_id, tp.modeled_supplier_site_id FROM msc_trading_partners tp, msc_item_categories mic, msc_system_items msi WHERE tp.sr_instance_id = msi.sr_instance_id AND tp.sr_tp_id = msi.organization_id AND tp.partner_type = 3 AND mic.sr_instance_id = msi.sr_instance_id AND mic.organization_id = msi.organization_id AND mic.inventory_item_id = msi.inventory_item_id UNION ALL SELECT mbc.sr_instance_id, mbc.plan_id, mbc.organization_id, tp.organization_code, tp.partner_name, mbc.inventory_item_id, msi.item_name, msi.description, mic.category_set_id, mic.sr_category_id, mbc.using_assembly_id, mbc.using_assembly_id, msi.abc_class, msi.abc_class_name, msi.buyer_id, msi.buyer_name, msi.planner_code, mic.category_name, tp.modeled_supplier_id, tp.modeled_supplier_site_id FROM msc_trading_partners tp, msc_item_categories mic, msc_system_items msi, msc_bom_components mbc WHERE tp.sr_instance_id = msi.sr_instance_id AND tp.sr_tp_id = msi.organization_id AND tp.partner_type = 3 AND mic.sr_instance_id = msi.sr_instance_id AND mic.organization_id = msi.organization_id AND mic.inventory_item_id = msi.inventory_item_id AND msi.inventory_item_id = mbc.inventory_item_id AND msi.sr_instance_id = mbc.sr_instance_id AND msi.organization_id = mbc.organization_id AND msi.plan_id = mbc.plan_id

View Text - HTML Formatted

SELECT MSI.SR_INSTANCE_ID
, MSI.PLAN_ID
, MSI.ORGANIZATION_ID
, MSI.ORGANIZATION_CODE
, TP.PARTNER_NAME
, MSI.INVENTORY_ITEM_ID
, MSI.ITEM_NAME
, MSI.DESCRIPTION
, MIC.CATEGORY_SET_ID
, MIC.SR_CATEGORY_ID
, NVL(MSI.PRODUCT_FAMILY_ID
, MSI.BASE_ITEM_ID)
, MSI.BASE_ITEM_ID
, MSI.ABC_CLASS
, MSI.ABC_CLASS_NAME
, MSI.BUYER_ID
, MSI.BUYER_NAME
, MSI.PLANNER_CODE
, MIC.CATEGORY_NAME
, TP.MODELED_SUPPLIER_ID
, TP.MODELED_SUPPLIER_SITE_ID
FROM MSC_TRADING_PARTNERS TP
, MSC_ITEM_CATEGORIES MIC
, MSC_SYSTEM_ITEMS MSI
WHERE TP.SR_INSTANCE_ID = MSI.SR_INSTANCE_ID
AND TP.SR_TP_ID = MSI.ORGANIZATION_ID
AND TP.PARTNER_TYPE = 3
AND MIC.SR_INSTANCE_ID = MSI.SR_INSTANCE_ID
AND MIC.ORGANIZATION_ID = MSI.ORGANIZATION_ID
AND MIC.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID UNION ALL SELECT MBC.SR_INSTANCE_ID
, MBC.PLAN_ID
, MBC.ORGANIZATION_ID
, TP.ORGANIZATION_CODE
, TP.PARTNER_NAME
, MBC.INVENTORY_ITEM_ID
, MSI.ITEM_NAME
, MSI.DESCRIPTION
, MIC.CATEGORY_SET_ID
, MIC.SR_CATEGORY_ID
, MBC.USING_ASSEMBLY_ID
, MBC.USING_ASSEMBLY_ID
, MSI.ABC_CLASS
, MSI.ABC_CLASS_NAME
, MSI.BUYER_ID
, MSI.BUYER_NAME
, MSI.PLANNER_CODE
, MIC.CATEGORY_NAME
, TP.MODELED_SUPPLIER_ID
, TP.MODELED_SUPPLIER_SITE_ID
FROM MSC_TRADING_PARTNERS TP
, MSC_ITEM_CATEGORIES MIC
, MSC_SYSTEM_ITEMS MSI
, MSC_BOM_COMPONENTS MBC
WHERE TP.SR_INSTANCE_ID = MSI.SR_INSTANCE_ID
AND TP.SR_TP_ID = MSI.ORGANIZATION_ID
AND TP.PARTNER_TYPE = 3
AND MIC.SR_INSTANCE_ID = MSI.SR_INSTANCE_ID
AND MIC.ORGANIZATION_ID = MSI.ORGANIZATION_ID
AND MIC.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID
AND MSI.INVENTORY_ITEM_ID = MBC.INVENTORY_ITEM_ID
AND MSI.SR_INSTANCE_ID = MBC.SR_INSTANCE_ID
AND MSI.ORGANIZATION_ID = MBC.ORGANIZATION_ID
AND MSI.PLAN_ID = MBC.PLAN_ID