APPS.INV_COPY_ORGANIZATION_REPORT dependencies on BOM_SUBSTITUTE_COMPONENTS

Line 1797: FROM BOM_SUBSTITUTE_COMPONENTS bsc

1793: , p_organization_id NUMBER
1794: )
1795: IS
1796: SELECT msi.CONCATENATED_SEGMENTS, COUNT(bsc.COMPONENT_SEQUENCE_ID)
1797: FROM BOM_SUBSTITUTE_COMPONENTS bsc
1798: , BOM_INVENTORY_COMPONENTS bic
1799: , BOM_BILL_OF_MATERIALS bom
1800: , MTL_SYSTEM_ITEMS_KFV msi
1801: WHERE bom.ORGANIZATION_ID = p_model_org_id

Line 1811: , BOM_SUBSTITUTE_COMPONENTS bsc1

1807: (
1808: SELECT 'x'
1809: FROM BOM_INVENTORY_COMPONENTS bic1
1810: , BOM_BILL_OF_MATERIALS bom1
1811: , BOM_SUBSTITUTE_COMPONENTS bsc1
1812: WHERE bom1.ORGANIZATION_ID = p_organization_id
1813: AND bic1.BILL_SEQUENCE_ID = bom1.BILL_SEQUENCE_ID
1814: AND bsc1.COMPONENT_SEQUENCE_ID = bic1.COMPONENT_SEQUENCE_ID
1815: AND bom1.ASSEMBLY_ITEM_ID = bom.ASSEMBLY_ITEM_ID

Line 1829: , BOM_SUBSTITUTE_COMPONENTS bsc

1825: IS
1826: SELECT COUNT(bsc.SUBSTITUTE_COMPONENT_ID)
1827: FROM BOM_INVENTORY_COMPONENTS bic
1828: , BOM_BILL_OF_MATERIALS bom
1829: , BOM_SUBSTITUTE_COMPONENTS bsc
1830: WHERE bom.ORGANIZATION_ID = p_org_id
1831: AND bic.BILL_SEQUENCE_ID = bom.BILL_SEQUENCE_ID
1832: AND bsc.COMPONENT_SEQUENCE_ID = bic.COMPONENT_SEQUENCE_ID;
1833: