DBA Data[Home] [Help]

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