View: MSC_ITEMS_TREE_V

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

View Text

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
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
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

Columns