APPS.ENG_ECO_UTIL dependencies on BOM_REFERENCE_DESIGNATORS
Line 2025: DELETE FROM BOM_REFERENCE_DESIGNATORS RD
2021: AND IC.IMPLEMENTATION_DATE IS NULL);
2022:
2023: -- Delete reference designators of all pending revised items on ECO
2024: 2025: DELETE FROM BOM_REFERENCE_DESIGNATORS RD 2026: WHERE RD.COMPONENT_SEQUENCE_ID IN
2027: (SELECT IC.COMPONENT_SEQUENCE_ID
2028: FROM BOM_INVENTORY_COMPONENTS IC, ENG_REVISED_ITEMS RI
2029: WHERE RI.ORGANIZATION_ID = org_id