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 349: FROM BOM_OPERATION_SEQUENCES bos

345:
346: -- Delete substitute operation resources of all pending revised items on ECO
347: DELETE FROM BOM_SUB_OPERATION_RESOURCES sor
348: WHERE EXISTS (SELECT NULL
349: FROM BOM_OPERATION_SEQUENCES bos
350: , ENG_REVISED_ITEMS ri
351: WHERE sor.operation_sequence_id = bos.operation_sequence_id
352: AND bos.implementation_date IS NULL
353: AND bos.revised_item_sequence_id = ri.revised_item_sequence_id

Line 361: FROM BOM_OPERATION_SEQUENCES bos

357: ) ;
358: /*Start - Bug 8221477 (FP of 7557368): Changed the delete logic for operation resources*/
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

Line 500: FROM BOM_OPERATION_SEQUENCES bos

496: , bos.OLD_OPERATION_SEQUENCE_ID
497: , bos.ACD_TYPE
498: , bos.REVISED_ITEM_SEQUENCE_ID
499: , SYSDATE /* Cancellation Date */
500: FROM BOM_OPERATION_SEQUENCES bos
501: , ENG_REVISED_ITEMS ri
502: WHERE bos.implementation_date IS NULL
503: AND bos.revised_item_sequence_id = ri.revised_item_sequence_id
504: AND bos.change_notice = ri.change_notice /*Added for bug 8221477 (FP of 7557368)*/

Line 508: -- Delete the rows from bom_operation_sequences

504: AND bos.change_notice = ri.change_notice /*Added for bug 8221477 (FP of 7557368)*/
505: AND ri.status_type = 5 -- Cancelled
506: AND ri.organization_id = org_id
507: AND ri.change_notice = change_order;
508: -- Delete the rows from bom_operation_sequences
509: DELETE FROM BOM_OPERATION_SEQUENCES bos
510: WHERE EXISTS (SELECT NULL
511: FROM ENG_REVISED_ITEMS ri
512: WHERE 1=1 /*bos.implementation_date IS NULL Commented for bug 8583280 (FP of 6908447)*/

Line 509: DELETE FROM BOM_OPERATION_SEQUENCES bos

505: AND ri.status_type = 5 -- Cancelled
506: AND ri.organization_id = org_id
507: AND ri.change_notice = change_order;
508: -- Delete the rows from bom_operation_sequences
509: DELETE FROM BOM_OPERATION_SEQUENCES bos
510: WHERE EXISTS (SELECT NULL
511: FROM ENG_REVISED_ITEMS ri
512: WHERE 1=1 /*bos.implementation_date IS NULL Commented for bug 8583280 (FP of 6908447)*/
513: AND bos.revised_item_sequence_id = ri.revised_item_sequence_id

Line 612: FROM BOM_OPERATION_SEQUENCES bos

608: AND ri.organization_id = org_id
609: AND ri.change_notice = change_order
610: )
611: AND NOT EXISTS (SELECT NULL
612: FROM BOM_OPERATION_SEQUENCES bos
613: WHERE bos.routing_sequence_id = bor.routing_sequence_id
614: AND (bos.change_notice IS NULL
615: OR bos.change_notice <> change_notice)
616: )