View: MSC_COMPONENTS_TREE_V

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

View Text

SELECT COMP.PLAN_ID
, COMP.SR_INSTANCE_ID
, COMP.ORGANIZATION_ID
, COMP.INVENTORY_ITEM_ID
, ITEM.ITEM_NAME
, ITEM.DESCRIPTION
, COMP.USING_ASSEMBLY_ID
, ITEM1.ITEM_NAME
, ITEM1.DESCRIPTION
, 2
FROM MSC_ITEMS ITEM1
, MSC_ITEMS ITEM
, MSC_BOM_COMPONENTS COMP
WHERE ITEM.INVENTORY_ITEM_ID = COMP.INVENTORY_ITEM_ID
AND ITEM1.INVENTORY_ITEM_ID = COMP.USING_ASSEMBLY_ID
AND SYSDATE BETWEEN TRUNC(COMP.EFFECTIVITY_DATE)
AND NVL(TRUNC(COMP.DISABLE_DATE)
, TO_DATE(2634525
, 'J'))
AND NVL(COMP.COMPONENT_TYPE
, -1) <> 10 UNION ALL SELECT SUB.PLAN_ID
, SUB.SR_INSTANCE_ID
, SUB.ORGANIZATION_ID
, SUB.SUBSTITUTE_ITEM_ID
, ITEM.ITEM_NAME
, ITEM.DESCRIPTION
, COMP.USING_ASSEMBLY_ID
, ITEM1.ITEM_NAME
, ITEM1.DESCRIPTION
, 1
FROM MSC_ITEMS ITEM1
, MSC_ITEMS ITEM
, MSC_BOM_COMPONENTS COMP
, MSC_COMPONENT_SUBSTITUTES SUB
WHERE ITEM.INVENTORY_ITEM_ID = SUB.SUBSTITUTE_ITEM_ID
AND ITEM1.INVENTORY_ITEM_ID = COMP.USING_ASSEMBLY_ID
AND COMP.BILL_SEQUENCE_ID = SUB.BILL_SEQUENCE_ID
AND COMP.COMPONENT_SEQUENCE_ID = SUB.COMPONENT_SEQUENCE_ID
AND COMP.PLAN_ID = SUB.PLAN_ID
AND COMP.SR_INSTANCE_ID = SUB.SR_INSTANCE_ID
AND COMP.ORGANIZATION_ID = SUB.ORGANIZATION_ID
AND SYSDATE BETWEEN TRUNC(COMP.EFFECTIVITY_DATE)
AND NVL(TRUNC(COMP.DISABLE_DATE)
, TO_DATE(2634525
, 'J'))
AND NVL(COMP.COMPONENT_TYPE
, -1) <> 10

Columns