APPS.ENG_CANCEL_ECO dependencies on BOM_OPERATION_SEQUENCES

Line 55: from BOM_OPERATION_SEQUENCES bos

51: from bom_operational_routings bor
52: WHERE bor.pending_from_ecn IS NOT NULL
53: And bor.routing_sequence_id = p_routing_sequence_id
54: and not exists (select null
55: from BOM_OPERATION_SEQUENCES bos
56: where bos.routing_sequence_id = bor.routing_sequence_id
57: and (bos.change_notice is null
58: or
59: bos.change_notice <> change_order))

Line 344: FROM BOM_OPERATION_SEQUENCES bos

340:
341: -- Delete substitute operation resources of all pending revised items on ECO
342: DELETE FROM BOM_SUB_OPERATION_RESOURCES sor
343: WHERE EXISTS (SELECT NULL
344: FROM BOM_OPERATION_SEQUENCES bos
345: , ENG_REVISED_ITEMS ri
346: WHERE sor.operation_sequence_id = bos.operation_sequence_id
347: AND bos.implementation_date IS NULL
348: AND bos.revised_item_sequence_id = ri.revised_item_sequence_id

Line 357: FROM BOM_OPERATION_SEQUENCES bos

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
360: AND bos.implementation_date IS NULL
361: AND bos.revised_item_sequence_id = ri.revised_item_sequence_id

Line 489: FROM BOM_OPERATION_SEQUENCES bos

485: , bos.OLD_OPERATION_SEQUENCE_ID
486: , bos.ACD_TYPE
487: , bos.REVISED_ITEM_SEQUENCE_ID
488: , SYSDATE /* Cancellation Date */
489: FROM BOM_OPERATION_SEQUENCES bos
490: , ENG_REVISED_ITEMS ri
491: WHERE bos.implementation_date IS NULL
492: AND bos.revised_item_sequence_id = ri.revised_item_sequence_id
493: AND ri.status_type = 5 -- Cancelled

Line 496: -- Delete the rows from bom_operation_sequences

492: AND bos.revised_item_sequence_id = ri.revised_item_sequence_id
493: AND ri.status_type = 5 -- Cancelled
494: AND ri.organization_id = org_id
495: AND ri.change_notice = change_order;
496: -- Delete the rows from bom_operation_sequences
497: DELETE FROM BOM_OPERATION_SEQUENCES bos
498: WHERE EXISTS (SELECT NULL
499: FROM ENG_REVISED_ITEMS ri
500: WHERE bos.implementation_date IS NULL

Line 497: DELETE FROM BOM_OPERATION_SEQUENCES bos

493: AND ri.status_type = 5 -- Cancelled
494: AND ri.organization_id = org_id
495: AND ri.change_notice = change_order;
496: -- Delete the rows from bom_operation_sequences
497: DELETE FROM BOM_OPERATION_SEQUENCES bos
498: WHERE EXISTS (SELECT NULL
499: FROM ENG_REVISED_ITEMS ri
500: WHERE bos.implementation_date IS NULL
501: AND bos.revised_item_sequence_id = ri.revised_item_sequence_id

Line 596: FROM BOM_OPERATION_SEQUENCES bos

592: AND ri.organization_id = org_id
593: AND ri.change_notice = change_order
594: )
595: AND NOT EXISTS (SELECT NULL
596: FROM BOM_OPERATION_SEQUENCES bos
597: WHERE bos.routing_sequence_id = bor.routing_sequence_id
598: AND (bos.change_notice IS NULL
599: OR bos.change_notice <> change_notice)
600: )