DBA Data[Home] [Help]

APPS.ENG_CANCEL_ECO dependencies on BOM_OPERATION_RESOURCES

Line 355: DELETE FROM BOM_OPERATION_RESOURCES bor

351: AND ri.change_notice =change_order
352: ) ;
353:
354: -- Delete operation resources of all pending revised items on ECO
355: DELETE FROM BOM_OPERATION_RESOURCES bor
356: WHERE EXISTS (SELECT NULL
357: FROM BOM_OPERATION_SEQUENCES bos
358: , ENG_REVISED_ITEMS ri
359: WHERE bor.operation_sequence_id = bos.operation_sequence_id