DBA Data[Home] [Help]

APPS.BOMPECOD dependencies on BOM_BILL_OF_MATERIALS

Line 94: DELETE FROM BOM_BILL_OF_MATERIALS B

90: DELETE FROM ENG_ENGINEERING_CHANGES
91: WHERE CHANGE_NOTICE = P_CHANGE_NOTICE
92: AND ORGANIZATION_ID = P_ORGANIZATION_ID;
93:
94: DELETE FROM BOM_BILL_OF_MATERIALS B
95: WHERE ORGANIZATION_ID = P_ORGANIZATION_ID
96: AND PENDING_FROM_ECN = P_CHANGE_NOTICE
97: AND NOT EXISTS (SELECT NULL
98: FROM BOM_INVENTORY_COMPONENTS C