APPS.ENG_ECO_UTIL dependencies on BOM_SUBSTITUTE_COMPONENTS
Line 2441: DELETE FROM BOM_SUBSTITUTE_COMPONENTS SC
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