DBA Data[Home] [Help]

APPS.BOMPECOD dependencies on BOM_SUBSTITUTE_COMPONENTS

Line 29: DELETE FROM BOM_SUBSTITUTE_COMPONENTS S

25: AND RI.ORGANIZATION_ID = P_ORGANIZATION_ID
26: AND RI.CHANGE_NOTICE = P_CHANGE_NOTICE
27: AND C.IMPLEMENTATION_DATE IS NULL);
28:
29: DELETE FROM BOM_SUBSTITUTE_COMPONENTS S
30: WHERE S.COMPONENT_SEQUENCE_ID IN
31: (SELECT C.COMPONENT_SEQUENCE_ID
32: FROM BOM_INVENTORY_COMPONENTS C,
33: ENG_REVISED_ITEMS RI