DBA Data[Home] [Help]

APPS.INV_COPY_ORGANIZATION_REPORT dependencies on BOM_COMPONENT_OPERATIONS

Line 1881: FROM BOM_COMPONENT_OPERATIONS bco

1877: , p_organization_id NUMBER
1878: )
1879: IS
1880: SELECT msi.CONCATENATED_SEGMENTS, COUNT(bco.COMPONENT_SEQUENCE_ID)
1881: FROM BOM_COMPONENT_OPERATIONS bco
1882: , BOM_INVENTORY_COMPONENTS bic
1883: , BOM_BILL_OF_MATERIALS bom
1884: , MTL_SYSTEM_ITEMS_KFV msi
1885: WHERE bom.ORGANIZATION_ID = p_model_org_id

Line 1895: , BOM_COMPONENT_OPERATIONS bco1

1891: (
1892: SELECT 'x'
1893: FROM BOM_INVENTORY_COMPONENTS bic1
1894: , BOM_BILL_OF_MATERIALS bom1
1895: , BOM_COMPONENT_OPERATIONS bco1
1896: WHERE bom1.ORGANIZATION_ID = p_organization_id
1897: AND bic1.BILL_SEQUENCE_ID = bom1.BILL_SEQUENCE_ID
1898: AND bco1.COMPONENT_SEQUENCE_ID = bic1.COMPONENT_SEQUENCE_ID
1899: AND bom1.ASSEMBLY_ITEM_ID = bom.ASSEMBLY_ITEM_ID

Line 1911: , BOM_COMPONENT_OPERATIONS bco

1907: IS
1908: SELECT COUNT(bco.COMP_OPERATION_SEQ_ID)
1909: FROM BOM_INVENTORY_COMPONENTS bic
1910: , BOM_BILL_OF_MATERIALS bom
1911: , BOM_COMPONENT_OPERATIONS bco
1912: WHERE bom.ORGANIZATION_ID = p_org_id
1913: AND bic.BILL_SEQUENCE_ID = bom.BILL_SEQUENCE_ID
1914: AND bco.COMPONENT_SEQUENCE_ID = bic.COMPONENT_SEQUENCE_ID;
1915: