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 159: UPDATE ENG_REVISED_ITEMS

155: /*
156: ** set cancellation date of all pending revised items on ECO
157: */
158: stmt_num := 10;
159: UPDATE ENG_REVISED_ITEMS
160: SET CANCELLATION_DATE = SYSDATE,
161: STATUS_TYPE = 5,
162: LAST_UPDATED_BY = user_id,
163: LAST_UPDATE_LOGIN = login

Line 176: FROM BOM_INVENTORY_COMPONENTS IC, ENG_REVISED_ITEMS RI

172: stmt_num := 20;
173: DELETE FROM BOM_SUBSTITUTE_COMPONENTS SC
174: WHERE SC.COMPONENT_SEQUENCE_ID IN
175: (SELECT IC.COMPONENT_SEQUENCE_ID
176: FROM BOM_INVENTORY_COMPONENTS IC, ENG_REVISED_ITEMS RI
177: WHERE RI.ORGANIZATION_ID = org_id
178: AND RI.CHANGE_NOTICE = change_order
179: AND IC.REVISED_ITEM_SEQUENCE_ID = RI.REVISED_ITEM_SEQUENCE_ID
180: AND IC.IMPLEMENTATION_DATE IS NULL);

Line 190: FROM BOM_INVENTORY_COMPONENTS IC, ENG_REVISED_ITEMS RI

186: stmt_num := 30;
187: DELETE FROM BOM_REFERENCE_DESIGNATORS RD
188: WHERE RD.COMPONENT_SEQUENCE_ID IN
189: (SELECT IC.COMPONENT_SEQUENCE_ID
190: FROM BOM_INVENTORY_COMPONENTS IC, ENG_REVISED_ITEMS RI
191: WHERE RI.ORGANIZATION_ID = org_id
192: AND RI.CHANGE_NOTICE = change_order
193: AND IC.REVISED_ITEM_SEQUENCE_ID = RI.REVISED_ITEM_SEQUENCE_ID
194: AND IC.IMPLEMENTATION_DATE IS NULL);

Line 309: FROM BOM_INVENTORY_COMPONENTS IC, ENG_REVISED_ITEMS RI

305: IC.ATTRIBUTE13,
306: IC.ATTRIBUTE14,
307: IC.ATTRIBUTE15,
308: IC.BASIS_TYPE
309: FROM BOM_INVENTORY_COMPONENTS IC, ENG_REVISED_ITEMS RI
310: WHERE RI.ORGANIZATION_ID = org_id
311: AND RI.CHANGE_NOTICE = change_order
312: AND IC.CHANGE_NOTICE = RI.CHANGE_NOTICE
313: AND IC.REVISED_ITEM_SEQUENCE_ID = RI.REVISED_ITEM_SEQUENCE_ID

Line 326: FROM ENG_REVISED_ITEMS ERI

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

Line 350: , ENG_REVISED_ITEMS ri

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

Line 362: , ENG_REVISED_ITEMS ri

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
366: AND bos.change_notice = ri.change_notice

Line 501: , ENG_REVISED_ITEMS ri

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)*/
505: AND ri.status_type = 5 -- Cancelled

Line 511: FROM ENG_REVISED_ITEMS ri

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

Line 525: FROM ENG_REVISED_ITEMS ri

521:
522: -- Delete routing revisions created by revised items on ECO
523: DELETE FROM MTL_RTG_ITEM_REVISIONS rev
524: WHERE EXISTS (SELECT NULL
525: FROM ENG_REVISED_ITEMS ri
526: WHERE 1=1 /*rev.implementation_date IS NULL Commented for bug 8583280*/
527: AND rev.revised_item_sequence_id = ri.revised_item_sequence_id
528: AND ri.status_type = 5 -- Cancelled
529: AND ri.organization_id = org_id

Line 575: UPDATE ENG_REVISED_ITEMS ri

571: DELETE FROM BOM_OPERATIONAL_ROUTINGS
572: WHERE routing_sequence_id = l_routing_sequence_id;
573:
574: -- If routing was deleted, then unset the routing_sequence_id on the revised items
575: UPDATE ENG_REVISED_ITEMS ri
576: SET routing_sequence_id = ''
577: , last_updated_by = user_id
578: , last_update_login = login
579: WHERE ri.organization_id = org_id

Line 603: FROM ENG_REVISED_ITEMS ri

599:
600:
601: /*DELETE FROM BOM_OPERATIONAL_ROUTINGS bor
602: WHERE EXISTS ( SELECT NULL
603: FROM ENG_REVISED_ITEMS ri
604: WHERE
605: bor.routing_sequence_id = ri.routing_sequence_id
606: AND TRUNC(ri.last_update_date) = TRUNC(SYSDATE)
607: AND ri.status_type = 5 -- Cancelled

Line 627: FROM ENG_REVISED_ITEMS ri2

623: )
624: OR
625: ( bor.alternate_routing_designator IS NOT NULL
626: AND NOT EXISTS( SELECT NULL
627: FROM ENG_REVISED_ITEMS ri2
628: WHERE ri2.organization_id = bor.organization_id
629: AND ri2.routing_sequence_id = bor.routing_sequence_id
630: AND ri2.change_notice <> change_order)
631: )) ;

Line 635: UPDATE ENG_REVISED_ITEMS ri

631: )) ;
632: -- If routing was deleted, then unset the routing_sequence_id on the revised items
633: IF SQL%FOUND THEN
634:
635: UPDATE ENG_REVISED_ITEMS ri
636: SET routing_sequence_id = ''
637: , last_updated_by = user_id
638: , last_update_login =login
639: WHERE ri.organization_id = org_id

Line 664: FROM ENG_REVISED_ITEMS R

660: AND ORGANIZATION_ID = org_id
661: AND IMPLEMENTATION_DATE IS NULL
662: AND INVENTORY_ITEM_ID IN
663: (SELECT REVISED_ITEM_ID
664: FROM ENG_REVISED_ITEMS R
665: WHERE R.CHANGE_NOTICE = change_order
666: AND R.ORGANIZATION_ID = org_id
667: AND R.REVISED_ITEM_SEQUENCE_ID = I.REVISED_ITEM_SEQUENCE_ID
668: AND R.CANCELLATION_DATE IS NOT NULL));

Line 675: FROM ENG_REVISED_ITEMS R

671: WHERE CHANGE_NOTICE = change_order
672: AND ORGANIZATION_ID = org_id
673: AND IMPLEMENTATION_DATE IS NULL
674: AND INVENTORY_ITEM_ID IN (SELECT REVISED_ITEM_ID
675: FROM ENG_REVISED_ITEMS R
676: WHERE R.CHANGE_NOTICE = change_order
677: AND R.ORGANIZATION_ID = org_id
678: AND R.REVISED_ITEM_SEQUENCE_ID = I.REVISED_ITEM_SEQUENCE_ID
679: AND R.CANCELLATION_DATE IS NOT NULL);

Line 691: FROM ENG_REVISED_ITEMS

687: stmt_num := 70;
688:
689: DELETE FROM EGO_MTL_SY_ITEMS_EXT_TL A
690: WHERE A.REVISION_ID IN (SELECT NEW_ITEM_REVISION_ID
691: FROM ENG_REVISED_ITEMS
692: WHERE NEW_ITEM_REVISION_ID IS NOT NULL
693: AND CHANGE_NOTICE = change_order
694: AND ORGANIZATION_ID = org_id);
695:

Line 701: FROM ENG_REVISED_ITEMS

697: -- Fixed by Gabriel on 10/29/2008.
698:
699: /* DELETE FROM EGO_MTL_SY_ITEMS_EXT_B A
700: WHERE A.REVISION_ID IN (SELECT NEW_ITEM_REVISION_ID
701: FROM ENG_REVISED_ITEMS
702: WHERE NEW_ITEM_REVISION_ID IS NOT NULL
703: AND CHANGE_NOTICE = change_order
704: AND ORGANIZATION_ID = org_id); */
705:

Line 716: FROM ENG_REVISED_ITEMS

712: WHERE (A.ORGANIZATION_ID, A.INVENTORY_ITEM_ID, A.REVISION_ID) IN
713: (SELECT ORGANIZATION_ID,
714: REVISED_ITEM_ID ,
715: NEW_ITEM_REVISION_ID
716: FROM ENG_REVISED_ITEMS
717: WHERE NEW_ITEM_REVISION_ID IS NOT NULL
718: AND CHANGE_NOTICE = change_order
719: AND ORGANIZATION_ID = org_id
720: );

Line 737: FROM ENG_REVISED_ITEMS ERI

733: set pending_from_ecn = null*/
734: stmt_num := 80;
735: DELETE FROM BOM_BILL_OF_MATERIALS B
736: WHERE B.BILL_SEQUENCE_ID in (SELECT BILL_SEQUENCE_ID
737: FROM ENG_REVISED_ITEMS ERI
738: WHERE ORGANIZATION_ID = org_id
739: AND CHANGE_NOTICE = change_order
740: AND STATUS_TYPE = 5)
741: /* AND TRUNC(LAST_UPDATE_DATE) = trunc(sysdate)) for bug 10042748 */

Line 756: FROM ENG_REVISED_ITEMS R

752: AND B2.ASSEMBLY_ITEM_ID = B.ASSEMBLY_ITEM_ID
753: AND B2.ALTERNATE_BOM_DESIGNATOR IS NOT NULL))
754: OR B.ALTERNATE_BOM_DESIGNATOR IS NOT NULL) /* Fix for bug 10042748*/
755: AND NOT EXISTS (SELECT NULL
756: FROM ENG_REVISED_ITEMS R
757: WHERE R.ORGANIZATION_ID = B.ORGANIZATION_ID
758: AND R.BILL_SEQUENCE_ID = B.BILL_SEQUENCE_ID
759: AND R.CHANGE_NOTICE <> change_order
760: AND R.STATUS_TYPE <> 5);

Line 768: UPDATE ENG_REVISED_ITEMS R

764: */
765: if (SQL%ROWCOUNT > 0) then
766: -- dbms_output.put_line('Deleted BOM headers');
767: stmt_num := 90;
768: UPDATE ENG_REVISED_ITEMS R
769: SET BILL_SEQUENCE_ID = ''
770: WHERE R.ORGANIZATION_ID = org_id
771: AND R.CHANGE_NOTICE = change_order
772: AND R.STATUS_TYPE = 5

Line 820: from eng_revised_items

816: common number;
817:
818: cursor delete_attachments is
819: select change_id,revised_item_id,new_item_revision_id,revised_item_sequence_id,organization_id
820: from eng_revised_items
821: where revised_item_sequence_id = rev_item_seq;
822:
823: Cursor is_editable_common_bom1( rev_item_seq number ) is
824: select bill_sequence_id

Line 829: from eng_revised_items

825: from BOM_BILL_OF_MATERIALS
826: where common_bill_sequence_id <> source_bill_sequence_id
827: and bill_sequence_id = common_bill_sequence_id
828: and pending_from_ECN =(select change_notice
829: from eng_revised_items
830: where revised_item_sequence_id = rev_item_seq);
831:
832: Begin
833: --Bug : 3507992 Calling the following API on all cases, i.e. attachments made to new item revision,

Line 859: UPDATE ENG_REVISED_ITEMS

855: end;
856: /*
857: ** set cancellation date of all pending revised items on ECO
858: stmt_num := 10;
859: UPDATE ENG_REVISED_ITEMS
860: SET CANCELLATION_DATE = SYSDATE,
861: STATUS_TYPE = 5,
862: CANCEL_COMMENTS = comment,
863: LAST_UPDATED_BY = user_id,

Line 1030: from eng_revised_items I

1026: stmt_num := 50;
1027: -- Modified where clause for performance bug 4251776
1028: delete from MTL_ITEM_REVISIONS_TL
1029: WHERE revision_id IN (select new_item_revision_id
1030: from eng_revised_items I
1031: WHERE REVISED_ITEM_SEQUENCE_ID = rev_item_seq);
1032:
1033: /*where revision_id IN (select revision_id
1034: from MTL_ITEM_REVISIONS_B I

Line 1039: from eng_revised_items I

1035: WHERE REVISED_ITEM_SEQUENCE_ID = rev_item_seq);*/
1036: -- Modified where clause for performance bug 4251776
1037: DELETE FROM MTL_ITEM_REVISIONS_B I --Fix for bug 3215586
1038: WHERE revision_id IN (select new_item_revision_id
1039: from eng_revised_items I
1040: WHERE REVISED_ITEM_SEQUENCE_ID = rev_item_seq);
1041:
1042: /*WHERE REVISED_ITEM_SEQUENCE_ID = rev_item_seq;*/
1043:

Line 1054: FROM ENG_REVISED_ITEMS

1050: stmt_num := 60;
1051:
1052: DELETE FROM EGO_MTL_SY_ITEMS_EXT_TL A
1053: WHERE A.REVISION_ID IN (SELECT NEW_ITEM_REVISION_ID
1054: FROM ENG_REVISED_ITEMS
1055: WHERE NEW_ITEM_REVISION_ID IS NOT NULL
1056: AND REVISED_ITEM_SEQUENCE_ID = rev_item_seq);
1057:
1058: DELETE FROM EGO_MTL_SY_ITEMS_EXT_B A

Line 1060: FROM ENG_REVISED_ITEMS

1056: AND REVISED_ITEM_SEQUENCE_ID = rev_item_seq);
1057:
1058: DELETE FROM EGO_MTL_SY_ITEMS_EXT_B A
1059: WHERE A.REVISION_ID IN (SELECT NEW_ITEM_REVISION_ID
1060: FROM ENG_REVISED_ITEMS
1061: WHERE NEW_ITEM_REVISION_ID IS NOT NULL
1062: AND REVISED_ITEM_SEQUENCE_ID = rev_item_seq);
1063: -- Syalaman - End of fix for bug 6469639.
1064:

Line 1090: FROM ENG_REVISED_ITEMS R

1086: AND B2.ASSEMBLY_ITEM_ID = B.ASSEMBLY_ITEM_ID
1087: AND B2.ALTERNATE_BOM_DESIGNATOR IS NOT NULL))
1088: OR B.ALTERNATE_BOM_DESIGNATOR IS NOT NULL) /* Fix for bug 10042748*/
1089: AND NOT EXISTS (SELECT NULL
1090: FROM ENG_REVISED_ITEMS R
1091: WHERE R.ORGANIZATION_ID = B.ORGANIZATION_ID
1092: AND R.BILL_SEQUENCE_ID = B.BILL_SEQUENCE_ID
1093: AND R.REVISED_ITEM_SEQUENCE_ID <> rev_item_seq
1094: AND R.STATUS_TYPE <> 5);

Line 1102: UPDATE ENG_REVISED_ITEMS R

1098: */
1099: -- if (SQL%ROWCOUNT > 0) then
1100: --dbms_output.put_line('Deleted BOM header');
1101: stmt_num := 80;
1102: UPDATE ENG_REVISED_ITEMS R
1103: SET BILL_SEQUENCE_ID = ''
1104: WHERE R.REVISED_ITEM_SEQUENCE_ID = rev_item_seq;
1105: -- dbms_output.put_line(SQL%ROWCOUNT || ' rows updated in eri for bsi');
1106: -- end if;

Line 1114: UPDATE ENG_REVISED_ITEMS R

1110: */
1111: -- if (SQL%ROWCOUNT > 0) then
1112: --dbms_output.put_line('Deleted BOM header');
1113: stmt_num := 90;
1114: UPDATE ENG_REVISED_ITEMS R
1115: SET ALTERNATE_BOM_DESIGNATOR = ''
1116: WHERE R.REVISED_ITEM_SEQUENCE_ID = rev_item_seq
1117: AND ROUTING_SEQUENCE_ID IS NULL;
1118: -- dbms_output.put_line(SQL%ROWCOUNT || ' rows updated in eri for bsi');

Line 1364: FROM ENG_REVISED_ITEMS

1360: Begin
1361: stmt_num := 10;
1362: DELETE FROM EGO_MTL_SY_ITEMS_EXT_TL A
1363: WHERE A.REVISION_ID IN (SELECT NEW_ITEM_REVISION_ID
1364: FROM ENG_REVISED_ITEMS
1365: WHERE NEW_ITEM_REVISION_ID IS NOT NULL
1366: AND REVISED_ITEM_SEQUENCE_ID = rev_item_seq);
1367: stmt_num := 20;
1368: DELETE FROM EGO_MTL_SY_ITEMS_EXT_B A

Line 1370: FROM ENG_REVISED_ITEMS

1366: AND REVISED_ITEM_SEQUENCE_ID = rev_item_seq);
1367: stmt_num := 20;
1368: DELETE FROM EGO_MTL_SY_ITEMS_EXT_B A
1369: WHERE A.REVISION_ID IN (SELECT NEW_ITEM_REVISION_ID
1370: FROM ENG_REVISED_ITEMS
1371: WHERE NEW_ITEM_REVISION_ID IS NOT NULL
1372: AND REVISED_ITEM_SEQUENCE_ID = rev_item_seq);
1373:
1374: EXCEPTION

Line 1396: from ENG_REVISED_ITEMS

1392: delete BOM_STRUCTURES_B
1393: where alternate_bom_designator is not null
1394: and (pending_from_ecn, organization_id, assembly_item_id) in
1395: (select change_notice, organization_id, revised_item_id
1396: from ENG_REVISED_ITEMS
1397: where REVISED_ITEM_SEQUENCE_ID = rev_item_seq);
1398: EXCEPTION
1399: WHEN OTHERS THEN
1400: rollback;