APPS.INV_COPY_ORGANIZATION_REPORT dependencies on BOM_REFERENCE_DESIGNATORS

Line 1839: FROM BOM_REFERENCE_DESIGNATORS brd

1835: , p_organization_id NUMBER
1836: )
1837: IS
1838: SELECT msi.CONCATENATED_SEGMENTS, COUNT(brd.COMPONENT_SEQUENCE_ID)
1839: FROM BOM_REFERENCE_DESIGNATORS brd
1840: , BOM_INVENTORY_COMPONENTS bic
1841: , BOM_BILL_OF_MATERIALS bom
1842: , MTL_SYSTEM_ITEMS_KFV msi
1843: WHERE bom.ORGANIZATION_ID = p_model_org_id

Line 1853: , BOM_REFERENCE_DESIGNATORS brd1

1849: (
1850: SELECT 'x'
1851: FROM BOM_INVENTORY_COMPONENTS bic1
1852: , BOM_BILL_OF_MATERIALS bom1
1853: , BOM_REFERENCE_DESIGNATORS brd1
1854: WHERE bom1.ORGANIZATION_ID = p_organization_id
1855: AND bic1.BILL_SEQUENCE_ID = bom1.BILL_SEQUENCE_ID
1856: AND brd1.COMPONENT_SEQUENCE_ID = bic1.COMPONENT_SEQUENCE_ID
1857: AND bom1.ASSEMBLY_ITEM_ID = bom.ASSEMBLY_ITEM_ID

Line 1871: , BOM_REFERENCE_DESIGNATORS brd

1867: IS
1868: SELECT COUNT(brd.COMPONENT_REFERENCE_DESIGNATOR)
1869: FROM BOM_INVENTORY_COMPONENTS bic
1870: , BOM_BILL_OF_MATERIALS bom
1871: , BOM_REFERENCE_DESIGNATORS brd
1872: WHERE bom.ORGANIZATION_ID = p_org_id
1873: AND bic.BILL_SEQUENCE_ID = bom.BILL_SEQUENCE_ID
1874: AND brd.COMPONENT_SEQUENCE_ID = bic.COMPONENT_SEQUENCE_ID;
1875: