DBA Data[Home] [Help]

APPS.ENG_CANCEL_ECO dependencies on BOM_OPERATION_RESOURCES

Line 363: , BOM_OPERATION_RESOURCES bor

359: -- Delete operation resources of all pending revised items on ECO
360: SELECT bor.ROWID BULK COLLECT INTO rowid_tab1
361: FROM BOM_OPERATION_SEQUENCES bos
362: , ENG_REVISED_ITEMS ri
363: , BOM_OPERATION_RESOURCES bor
364: WHERE bor.operation_sequence_id = bos.operation_sequence_id
365: AND bos.implementation_date IS NULL
366: AND bos.change_notice = ri.change_notice
367: AND bos.revised_item_sequence_id = ri.revised_item_sequence_id

Line 373: DELETE FROM BOM_OPERATION_RESOURCES

369: AND ri.organization_id = org_id
370: AND ri.change_notice = change_order;
371:
372: FORALL l_counter IN 1..rowid_tab1.count
373: DELETE FROM BOM_OPERATION_RESOURCES
374: WHERE rowid =rowid_tab1(l_counter);
375: /*End - Bug 8221477 (FP of 7557368): Changed the delete logic for operation resources */
376:
377: -- Insert the cancelled rev operations into eng_revised_operations