View: MSC_SUBSTITUTE_COMPONENTS_V

Product:	MSC - Advanced Supply Chain Planning
Description:	Substitute component view
Implementation/DBA Data:	APPS.MSC_SUBSTITUTE_COMPONENTS_V

View Text

SELECT SUB.PLAN_ID
, SUB.ORGANIZATION_ID
, SUB.SR_INSTANCE_ID
, MSI.ORGANIZATION_CODE
, SUB.SUBSTITUTE_ITEM_ID
, MSI.ITEM_NAME
, SUB.COMPONENT_SEQUENCE_ID
, BOM.INVENTORY_ITEM_ID
, MI.ITEM_NAME
, SUB.USAGE_QUANTITY
, SUB.PRIORITY
, SUB.BILL_SEQUENCE_ID
FROM MSC_ITEMS MI
, MSC_SYSTEM_ITEMS MSI
, MSC_BOM_COMPONENTS BOM
, MSC_COMPONENT_SUBSTITUTES SUB
WHERE MI.INVENTORY_ITEM_ID = BOM.INVENTORY_ITEM_ID
AND BOM.COMPONENT_SEQUENCE_ID = SUB.COMPONENT_SEQUENCE_ID
AND BOM.BILL_SEQUENCE_ID = SUB.BILL_SEQUENCE_ID
AND BOM.PLAN_ID = SUB.PLAN_ID
AND BOM.SR_INSTANCE_ID = SUB.SR_INSTANCE_ID
AND BOM.ORGANIZATION_ID = SUB.ORGANIZATION_ID
AND MSI.PLAN_ID = SUB.PLAN_ID
AND MSI.ORGANIZATION_ID = SUB.ORGANIZATION_ID
AND MSI.SR_INSTANCE_ID = SUB.SR_INSTANCE_ID
AND MSI.INVENTORY_ITEM_ID = SUB.SUBSTITUTE_ITEM_ID

Columns