eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ENG_CANCEL_ECO dependencies on ENG_REVISED_ITEMS

Line 26: from eng_revised_items

22: l_cm_type_code varchar2(2000);
23:
24: cursor delete_attachments is
25: select change_id,revised_item_id,new_item_revision_id,revised_item_sequence_id
26: from eng_revised_items
27: where organization_id = org_id
28: and change_notice = change_order
29: and status_type not in (5,6);
30:

Line 41: FROM ENG_REVISED_ITEMS ri

37: -- Changes for Bug 3668603
38: -- Cursor to fetch the routing_sequence_id for cancelled revised items
39: CURSOR c_cancelled_RI IS
40: SELECT DISTINCT ri.routing_sequence_id
41: FROM ENG_REVISED_ITEMS ri
42: WHERE TRUNC(ri.last_update_date) = TRUNC(SYSDATE)
43: AND ri.status_type = 5 -- Cancelled
44: AND ri.organization_id = org_id
45: AND ri.change_notice = change_order

Line 75: from ENG_REVISED_ITEMS eri

71: and mriv.change_notice is null))
72: or
73: (bor.alternate_routing_designator is not null))
74: and not exists (select null
75: from ENG_REVISED_ITEMS eri
76: where eri.organization_id = bor.organization_id
77: and eri.routing_sequence_id = bor.routing_sequence_id
78: and eri.change_notice <> change_order
79: and eri.status_type <> 5);

Line 154: UPDATE ENG_REVISED_ITEMS

150: /*
151: ** set cancellation date of all pending revised items on ECO
152: */
153: stmt_num := 10;
154: UPDATE ENG_REVISED_ITEMS
155: SET CANCELLATION_DATE = SYSDATE,
156: STATUS_TYPE = 5,
157: LAST_UPDATED_BY = user_id,
158: LAST_UPDATE_LOGIN = login

Line 171: FROM BOM_INVENTORY_COMPONENTS IC, ENG_REVISED_ITEMS RI

167: stmt_num := 20;
168: DELETE FROM BOM_SUBSTITUTE_COMPONENTS SC
169: WHERE SC.COMPONENT_SEQUENCE_ID IN
170: (SELECT IC.COMPONENT_SEQUENCE_ID
171: FROM BOM_INVENTORY_COMPONENTS IC, ENG_REVISED_ITEMS RI
172: WHERE RI.ORGANIZATION_ID = org_id
173: AND RI.CHANGE_NOTICE = change_order
174: AND IC.REVISED_ITEM_SEQUENCE_ID = RI.REVISED_ITEM_SEQUENCE_ID
175: AND IC.IMPLEMENTATION_DATE IS NULL);

Line 185: FROM BOM_INVENTORY_COMPONENTS IC, ENG_REVISED_ITEMS RI

181: stmt_num := 30;
182: DELETE FROM BOM_REFERENCE_DESIGNATORS RD
183: WHERE RD.COMPONENT_SEQUENCE_ID IN
184: (SELECT IC.COMPONENT_SEQUENCE_ID
185: FROM BOM_INVENTORY_COMPONENTS IC, ENG_REVISED_ITEMS RI
186: WHERE RI.ORGANIZATION_ID = org_id
187: AND RI.CHANGE_NOTICE = change_order
188: AND IC.REVISED_ITEM_SEQUENCE_ID = RI.REVISED_ITEM_SEQUENCE_ID
189: AND IC.IMPLEMENTATION_DATE IS NULL);

Line 304: FROM BOM_INVENTORY_COMPONENTS IC, ENG_REVISED_ITEMS RI

300: IC.ATTRIBUTE13,
301: IC.ATTRIBUTE14,
302: IC.ATTRIBUTE15,
303: IC.BASIS_TYPE
304: FROM BOM_INVENTORY_COMPONENTS IC, ENG_REVISED_ITEMS RI
305: WHERE RI.ORGANIZATION_ID = org_id
306: AND RI.CHANGE_NOTICE = change_order
307: AND IC.CHANGE_NOTICE = RI.CHANGE_NOTICE
308: AND IC.REVISED_ITEM_SEQUENCE_ID = RI.REVISED_ITEM_SEQUENCE_ID

Line 321: FROM ENG_REVISED_ITEMS ERI

317: DELETE FROM BOM_INVENTORY_COMPONENTS IC
318: WHERE CHANGE_NOTICE = change_order
319: AND IMPLEMENTATION_DATE IS NULL
320: AND REVISED_ITEM_SEQUENCE_ID IN (SELECT REVISED_ITEM_SEQUENCE_ID
321: FROM ENG_REVISED_ITEMS ERI
322: WHERE ERI.ORGANIZATION_ID = org_id
323: AND ERI.CHANGE_NOTICE = change_order
324: AND ERI.STATUS_TYPE = 5);
325: -- dbms_output.put_line(SQL%ROWCOUNT || ' rows deleted from bic');

Line 345: , ENG_REVISED_ITEMS ri

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
349: AND ri.status_type = 5 -- Cancelled

Line 358: , ENG_REVISED_ITEMS ri

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
362: AND ri.status_type = 5 -- Cancelled

Line 490: , ENG_REVISED_ITEMS ri

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
494: AND ri.organization_id = org_id

Line 499: FROM ENG_REVISED_ITEMS ri

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
502: AND ri.status_type = 5 -- Cancelled
503: AND ri.organization_id = org_id

Line 510: FROM ENG_REVISED_ITEMS ri

506:
507: -- Delete routing revisions created by revised items on ECO
508: DELETE FROM MTL_RTG_ITEM_REVISIONS rev
509: WHERE EXISTS (SELECT NULL
510: FROM ENG_REVISED_ITEMS ri
511: WHERE rev.implementation_date IS NULL
512: AND rev.revised_item_sequence_id = ri.revised_item_sequence_id
513: AND ri.status_type = 5 -- Cancelled
514: AND ri.organization_id = org_id

Line 559: UPDATE ENG_REVISED_ITEMS ri

555: DELETE FROM BOM_OPERATIONAL_ROUTINGS
556: WHERE routing_sequence_id = l_routing_sequence_id;
557:
558: -- If routing was deleted, then unset the routing_sequence_id on the revised items
559: UPDATE ENG_REVISED_ITEMS ri
560: SET routing_sequence_id = ''
561: , last_updated_by = user_id
562: , last_update_login = login
563: WHERE ri.organization_id = org_id

Line 587: FROM ENG_REVISED_ITEMS ri

583:
584:
585: /*DELETE FROM BOM_OPERATIONAL_ROUTINGS bor
586: WHERE EXISTS ( SELECT NULL
587: FROM ENG_REVISED_ITEMS ri
588: WHERE
589: bor.routing_sequence_id = ri.routing_sequence_id
590: AND TRUNC(ri.last_update_date) = TRUNC(SYSDATE)
591: AND ri.status_type = 5 -- Cancelled

Line 611: FROM ENG_REVISED_ITEMS ri2

607: )
608: OR
609: ( bor.alternate_routing_designator IS NOT NULL
610: AND NOT EXISTS( SELECT NULL
611: FROM ENG_REVISED_ITEMS ri2
612: WHERE ri2.organization_id = bor.organization_id
613: AND ri2.routing_sequence_id = bor.routing_sequence_id
614: AND ri2.change_notice <> change_order)
615: )) ;

Line 619: UPDATE ENG_REVISED_ITEMS ri

615: )) ;
616: -- If routing was deleted, then unset the routing_sequence_id on the revised items
617: IF SQL%FOUND THEN
618:
619: UPDATE ENG_REVISED_ITEMS ri
620: SET routing_sequence_id = ''
621: , last_updated_by = user_id
622: , last_update_login =login
623: WHERE ri.organization_id = org_id

Line 648: FROM ENG_REVISED_ITEMS R

644: AND ORGANIZATION_ID = org_id
645: AND IMPLEMENTATION_DATE IS NULL
646: AND INVENTORY_ITEM_ID IN
647: (SELECT REVISED_ITEM_ID
648: FROM ENG_REVISED_ITEMS R
649: WHERE R.CHANGE_NOTICE = change_order
650: AND R.ORGANIZATION_ID = org_id
651: AND R.REVISED_ITEM_SEQUENCE_ID = I.REVISED_ITEM_SEQUENCE_ID
652: AND R.CANCELLATION_DATE IS NOT NULL));

Line 659: FROM ENG_REVISED_ITEMS R

655: WHERE CHANGE_NOTICE = change_order
656: AND ORGANIZATION_ID = org_id
657: AND IMPLEMENTATION_DATE IS NULL
658: AND INVENTORY_ITEM_ID IN (SELECT REVISED_ITEM_ID
659: FROM ENG_REVISED_ITEMS R
660: WHERE R.CHANGE_NOTICE = change_order
661: AND R.ORGANIZATION_ID = org_id
662: AND R.REVISED_ITEM_SEQUENCE_ID = I.REVISED_ITEM_SEQUENCE_ID
663: AND R.CANCELLATION_DATE IS NOT NULL);

Line 675: FROM ENG_REVISED_ITEMS

671: stmt_num := 70;
672:
673: DELETE FROM EGO_MTL_SY_ITEMS_EXT_TL A
674: WHERE A.REVISION_ID IN (SELECT NEW_ITEM_REVISION_ID
675: FROM ENG_REVISED_ITEMS
676: WHERE NEW_ITEM_REVISION_ID IS NOT NULL
677: AND CHANGE_NOTICE = change_order
678: AND ORGANIZATION_ID = org_id);
679:

Line 685: FROM ENG_REVISED_ITEMS

681: -- Fixed by Gabriel on 10/29/2008.
682:
683: /* DELETE FROM EGO_MTL_SY_ITEMS_EXT_B A
684: WHERE A.REVISION_ID IN (SELECT NEW_ITEM_REVISION_ID
685: FROM ENG_REVISED_ITEMS
686: WHERE NEW_ITEM_REVISION_ID IS NOT NULL
687: AND CHANGE_NOTICE = change_order
688: AND ORGANIZATION_ID = org_id); */
689:

Line 700: FROM ENG_REVISED_ITEMS

696: WHERE (A.ORGANIZATION_ID, A.INVENTORY_ITEM_ID, A.REVISION_ID) IN
697: (SELECT ORGANIZATION_ID,
698: REVISED_ITEM_ID ,
699: NEW_ITEM_REVISION_ID
700: FROM ENG_REVISED_ITEMS
701: WHERE NEW_ITEM_REVISION_ID IS NOT NULL
702: AND CHANGE_NOTICE = change_order
703: AND ORGANIZATION_ID = org_id
704: );

Line 721: FROM ENG_REVISED_ITEMS ERI

717: set pending_from_ecn = null*/
718: stmt_num := 80;
719: DELETE FROM BOM_BILL_OF_MATERIALS B
720: WHERE B.BILL_SEQUENCE_ID in (SELECT BILL_SEQUENCE_ID
721: FROM ENG_REVISED_ITEMS ERI
722: WHERE ORGANIZATION_ID = org_id
723: AND CHANGE_NOTICE = change_order
724: AND STATUS_TYPE = 5
725: AND TRUNC(LAST_UPDATE_DATE) = trunc(sysdate))

Line 740: FROM ENG_REVISED_ITEMS R

736: AND B2.ASSEMBLY_ITEM_ID = B.ASSEMBLY_ITEM_ID
737: AND B2.ALTERNATE_BOM_DESIGNATOR IS NOT NULL))
738: OR
739: (NOT EXISTS (SELECT NULL
740: FROM ENG_REVISED_ITEMS R
741: WHERE R.ORGANIZATION_ID = B.ORGANIZATION_ID
742: AND R.BILL_SEQUENCE_ID = B.BILL_SEQUENCE_ID
743: AND R.CHANGE_NOTICE <> change_order
744: AND R.STATUS_TYPE <> 5)));

Line 752: UPDATE ENG_REVISED_ITEMS R

748: */
749: if (SQL%ROWCOUNT > 0) then
750: -- dbms_output.put_line('Deleted BOM headers');
751: stmt_num := 90;
752: UPDATE ENG_REVISED_ITEMS R
753: SET BILL_SEQUENCE_ID = ''
754: WHERE R.ORGANIZATION_ID = org_id
755: AND R.CHANGE_NOTICE = change_order
756: AND R.STATUS_TYPE = 5

Line 795: from eng_revised_items

791: common number;
792:
793: cursor delete_attachments is
794: select change_id,revised_item_id,new_item_revision_id,revised_item_sequence_id,organization_id
795: from eng_revised_items
796: where revised_item_sequence_id = rev_item_seq;
797:
798: Cursor is_editable_common_bom1( rev_item_seq number ) is
799: select bill_sequence_id

Line 804: from eng_revised_items

800: from BOM_BILL_OF_MATERIALS
801: where common_bill_sequence_id <> source_bill_sequence_id
802: and bill_sequence_id = common_bill_sequence_id
803: and pending_from_ECN =(select change_notice
804: from eng_revised_items
805: where revised_item_sequence_id = rev_item_seq);
806:
807: Begin
808: --Bug : 3507992 Calling the following API on all cases, i.e. attachments made to new item revision,

Line 834: UPDATE ENG_REVISED_ITEMS

830: end;
831: /*
832: ** set cancellation date of all pending revised items on ECO
833: stmt_num := 10;
834: UPDATE ENG_REVISED_ITEMS
835: SET CANCELLATION_DATE = SYSDATE,
836: STATUS_TYPE = 5,
837: CANCEL_COMMENTS = comment,
838: LAST_UPDATED_BY = user_id,

Line 1005: from eng_revised_items I

1001: stmt_num := 50;
1002: -- Modified where clause for performance bug 4251776
1003: delete from MTL_ITEM_REVISIONS_TL
1004: WHERE revision_id IN (select new_item_revision_id
1005: from eng_revised_items I
1006: WHERE REVISED_ITEM_SEQUENCE_ID = rev_item_seq);
1007:
1008: /*where revision_id IN (select revision_id
1009: from MTL_ITEM_REVISIONS_B I

Line 1014: from eng_revised_items I

1010: WHERE REVISED_ITEM_SEQUENCE_ID = rev_item_seq);*/
1011: -- Modified where clause for performance bug 4251776
1012: DELETE FROM MTL_ITEM_REVISIONS_B I --Fix for bug 3215586
1013: WHERE revision_id IN (select new_item_revision_id
1014: from eng_revised_items I
1015: WHERE REVISED_ITEM_SEQUENCE_ID = rev_item_seq);
1016:
1017: /*WHERE REVISED_ITEM_SEQUENCE_ID = rev_item_seq;*/
1018:

Line 1029: FROM ENG_REVISED_ITEMS

1025: stmt_num := 60;
1026:
1027: DELETE FROM EGO_MTL_SY_ITEMS_EXT_TL A
1028: WHERE A.REVISION_ID IN (SELECT NEW_ITEM_REVISION_ID
1029: FROM ENG_REVISED_ITEMS
1030: WHERE NEW_ITEM_REVISION_ID IS NOT NULL
1031: AND REVISED_ITEM_SEQUENCE_ID = rev_item_seq);
1032:
1033: DELETE FROM EGO_MTL_SY_ITEMS_EXT_B A

Line 1035: FROM ENG_REVISED_ITEMS

1031: AND REVISED_ITEM_SEQUENCE_ID = rev_item_seq);
1032:
1033: DELETE FROM EGO_MTL_SY_ITEMS_EXT_B A
1034: WHERE A.REVISION_ID IN (SELECT NEW_ITEM_REVISION_ID
1035: FROM ENG_REVISED_ITEMS
1036: WHERE NEW_ITEM_REVISION_ID IS NOT NULL
1037: AND REVISED_ITEM_SEQUENCE_ID = rev_item_seq);
1038: -- Syalaman - End of fix for bug 6469639.
1039:

Line 1065: FROM ENG_REVISED_ITEMS R

1061: AND B2.ASSEMBLY_ITEM_ID = B.ASSEMBLY_ITEM_ID
1062: AND B2.ALTERNATE_BOM_DESIGNATOR IS NOT NULL))
1063: OR
1064: (NOT EXISTS (SELECT NULL
1065: FROM ENG_REVISED_ITEMS R
1066: WHERE R.ORGANIZATION_ID = B.ORGANIZATION_ID
1067: AND R.BILL_SEQUENCE_ID = B.BILL_SEQUENCE_ID
1068: AND R.REVISED_ITEM_SEQUENCE_ID <> rev_item_seq
1069: AND R.STATUS_TYPE <> 5)));

Line 1077: UPDATE ENG_REVISED_ITEMS R

1073: */
1074: -- if (SQL%ROWCOUNT > 0) then
1075: --dbms_output.put_line('Deleted BOM header');
1076: stmt_num := 80;
1077: UPDATE ENG_REVISED_ITEMS R
1078: SET BILL_SEQUENCE_ID = ''
1079: WHERE R.REVISED_ITEM_SEQUENCE_ID = rev_item_seq;
1080: -- dbms_output.put_line(SQL%ROWCOUNT || ' rows updated in eri for bsi');
1081: -- end if;

Line 1089: UPDATE ENG_REVISED_ITEMS R

1085: */
1086: -- if (SQL%ROWCOUNT > 0) then
1087: --dbms_output.put_line('Deleted BOM header');
1088: stmt_num := 90;
1089: UPDATE ENG_REVISED_ITEMS R
1090: SET ALTERNATE_BOM_DESIGNATOR = ''
1091: WHERE R.REVISED_ITEM_SEQUENCE_ID = rev_item_seq
1092: AND ROUTING_SEQUENCE_ID IS NULL;
1093: -- dbms_output.put_line(SQL%ROWCOUNT || ' rows updated in eri for bsi');