VIEW: APPS.MSC_SUBSTITUTE_COMPONENTS_V

Source

View Text - Preformatted

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, msi.description, mi.description FROM msc_system_items mi, msc_system_items msi, msc_bom_components bom, msc_component_substitutes sub WHERE mi.inventory_item_id = bom.inventory_item_id AND mi.plan_id = bom.plan_id AND mi.organization_id = bom.organization_id AND mi.sr_instance_id = bom.sr_instance_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

View Text - HTML Formatted

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
, MSI.DESCRIPTION
, MI.DESCRIPTION
FROM MSC_SYSTEM_ITEMS MI
, MSC_SYSTEM_ITEMS MSI
, MSC_BOM_COMPONENTS BOM
, MSC_COMPONENT_SUBSTITUTES SUB
WHERE MI.INVENTORY_ITEM_ID = BOM.INVENTORY_ITEM_ID
AND MI.PLAN_ID = BOM.PLAN_ID
AND MI.ORGANIZATION_ID = BOM.ORGANIZATION_ID
AND MI.SR_INSTANCE_ID = BOM.SR_INSTANCE_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