[Home] [Help]
2437: AND STATUS_TYPE NOT IN (5,6);
2438:
2439: -- Delete substitute components of all pending revised items on ECO
2440:
2441: DELETE FROM BOM_SUBSTITUTE_COMPONENTS SC
2442: WHERE SC.COMPONENT_SEQUENCE_ID IN
2443: (SELECT IC.COMPONENT_SEQUENCE_ID
2444: FROM BOM_INVENTORY_COMPONENTS IC, ENG_REVISED_ITEMS RI
2445: WHERE RI.ORGANIZATION_ID = org_id