APPS.ENG_ECO_UTIL dependencies on BOM_REFERENCE_DESIGNATORS
Line 2452: DELETE FROM BOM_REFERENCE_DESIGNATORS RD
2448: AND IC.IMPLEMENTATION_DATE IS NULL);
2449:
2450: -- Delete reference designators of all pending revised items on ECO
2451: 2452: DELETE FROM BOM_REFERENCE_DESIGNATORS RD 2453: WHERE RD.COMPONENT_SEQUENCE_ID IN
2454: (SELECT IC.COMPONENT_SEQUENCE_ID
2455: FROM BOM_INVENTORY_COMPONENTS IC, ENG_REVISED_ITEMS RI
2456: WHERE RI.ORGANIZATION_ID = org_id