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 BOM_BILL_OF_MATERIALS

Line 83: from BOM_BILL_OF_MATERIALS

79: and eri.status_type <> 5);
80:
81: Cursor is_editable_common_bom( org_id number , change_order varchar2) is
82: select bill_sequence_id
83: from BOM_BILL_OF_MATERIALS
84: where common_bill_sequence_id <> source_bill_sequence_id
85: and bill_sequence_id = common_bill_sequence_id
86: and pending_from_ECN = change_order
87: and organization_id = org_id;

Line 731: corresponding row from bom_bill_of_materials. Deletion will be done by

727: ** delete the bom header if bill was created by this revised item and
728: ** nothing else references this
729: */
730: /* This is to fix bug 1522704. Now cancellation of ECO won't delete
731: corresponding row from bom_bill_of_materials. Deletion will be done by
732: delete groups only. Here two line of code is added update BOM_BILL_OF_MATERIALS B
733: set pending_from_ecn = null*/
734: stmt_num := 80;
735: DELETE FROM BOM_BILL_OF_MATERIALS B

Line 732: delete groups only. Here two line of code is added update BOM_BILL_OF_MATERIALS B

728: ** nothing else references this
729: */
730: /* This is to fix bug 1522704. Now cancellation of ECO won't delete
731: corresponding row from bom_bill_of_materials. Deletion will be done by
732: delete groups only. Here two line of code is added update BOM_BILL_OF_MATERIALS B
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

Line 735: DELETE FROM BOM_BILL_OF_MATERIALS B

731: corresponding row from bom_bill_of_materials. Deletion will be done by
732: delete groups only. Here two line of code is added update BOM_BILL_OF_MATERIALS B
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

Line 750: FROM BOM_BILL_OF_MATERIALS B2

746: AND (C.CHANGE_NOTICE IS NULL
747: OR C.CHANGE_NOTICE <> change_order))
748: AND ((B.ALTERNATE_BOM_DESIGNATOR IS NULL
749: AND NOT EXISTS (SELECT NULL
750: FROM BOM_BILL_OF_MATERIALS B2
751: WHERE B2.ORGANIZATION_ID = B.ORGANIZATION_ID
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*/

Line 774: FROM BOM_BILL_OF_MATERIALS BOM

770: WHERE R.ORGANIZATION_ID = org_id
771: AND R.CHANGE_NOTICE = change_order
772: AND R.STATUS_TYPE = 5
773: AND NOT EXISTS (SELECT 'NO SUCH BILL'
774: FROM BOM_BILL_OF_MATERIALS BOM
775: WHERE BOM.BILL_SEQUENCE_ID = R.BILL_SEQUENCE_ID);
776: -- dbms_output.put_line(SQL%ROWCOUNT || ' rows updated in eri for bsi');
777: end if;
778:

Line 780: ** if bills was not deleted, then unset the PENDING_FROM_ECN on BOM_BILL_OF_MATERIALS table.

776: -- dbms_output.put_line(SQL%ROWCOUNT || ' rows updated in eri for bsi');
777: end if;
778:
779: /* Fix for bug 10042748
780: ** if bills was not deleted, then unset the PENDING_FROM_ECN on BOM_BILL_OF_MATERIALS table.
781: */
782: stmt_num := 100;
783: UPDATE BOM_BILL_OF_MATERIALS
784: SET PENDING_FROM_ECN = ''

Line 783: UPDATE BOM_BILL_OF_MATERIALS

779: /* Fix for bug 10042748
780: ** if bills was not deleted, then unset the PENDING_FROM_ECN on BOM_BILL_OF_MATERIALS table.
781: */
782: stmt_num := 100;
783: UPDATE BOM_BILL_OF_MATERIALS
784: SET PENDING_FROM_ECN = ''
785: WHERE ORGANIZATION_ID = org_id
786: AND PENDING_FROM_ECN = change_order;
787:

Line 825: from BOM_BILL_OF_MATERIALS

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
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

Line 1070: corresponding row from bom_bill_of_materials. Deletion will be done by

1066: ** delete the bom header if bill was created by this revised item and
1067: ** nothing else references this
1068: */
1069: /* This is to fix bug 1522704. Now cancellation of ECO won't delete
1070: corresponding row from bom_bill_of_materials. Deletion will be done by
1071: delete groups only. Here two line of code is added update BOM_BILL_OF_MATERIALS B
1072: set pending_from_ecn = null*/
1073: stmt_num := 70;
1074: DELETE FROM BOM_BILL_OF_MATERIALS B

Line 1071: delete groups only. Here two line of code is added update BOM_BILL_OF_MATERIALS B

1067: ** nothing else references this
1068: */
1069: /* This is to fix bug 1522704. Now cancellation of ECO won't delete
1070: corresponding row from bom_bill_of_materials. Deletion will be done by
1071: delete groups only. Here two line of code is added update BOM_BILL_OF_MATERIALS B
1072: set pending_from_ecn = null*/
1073: stmt_num := 70;
1074: DELETE FROM BOM_BILL_OF_MATERIALS B
1075: WHERE B.BILL_SEQUENCE_ID = bill_seq_id

Line 1074: DELETE FROM BOM_BILL_OF_MATERIALS B

1070: corresponding row from bom_bill_of_materials. Deletion will be done by
1071: delete groups only. Here two line of code is added update BOM_BILL_OF_MATERIALS B
1072: set pending_from_ecn = null*/
1073: stmt_num := 70;
1074: DELETE FROM BOM_BILL_OF_MATERIALS B
1075: WHERE B.BILL_SEQUENCE_ID = bill_seq_id
1076: AND B.PENDING_FROM_ECN = change_order
1077: AND NOT EXISTS (SELECT NULL
1078: FROM BOM_INVENTORY_COMPONENTS C

Line 1084: FROM BOM_BILL_OF_MATERIALS B2

1080: AND (C.REVISED_ITEM_SEQUENCE_ID IS NULL
1081: OR C.REVISED_ITEM_SEQUENCE_ID <> rev_item_seq))
1082: AND ((B.ALTERNATE_BOM_DESIGNATOR IS NULL
1083: AND NOT EXISTS (SELECT NULL
1084: FROM BOM_BILL_OF_MATERIALS B2
1085: WHERE B2.ORGANIZATION_ID = B.ORGANIZATION_ID
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*/

Line 1122: ** if bills was not deleted, then unset the PENDING_FROM_ECN on BOM_BILL_OF_MATERIALS table.

1118: -- dbms_output.put_line(SQL%ROWCOUNT || ' rows updated in eri for bsi');
1119: -- end if;
1120:
1121: /* Fix for bug 10042748
1122: ** if bills was not deleted, then unset the PENDING_FROM_ECN on BOM_BILL_OF_MATERIALS table.
1123: */
1124: UPDATE BOM_BILL_OF_MATERIALS
1125: SET PENDING_FROM_ECN = ''
1126: WHERE BILL_SEQUENCE_ID = bill_seq_id;

Line 1124: UPDATE BOM_BILL_OF_MATERIALS

1120:
1121: /* Fix for bug 10042748
1122: ** if bills was not deleted, then unset the PENDING_FROM_ECN on BOM_BILL_OF_MATERIALS table.
1123: */
1124: UPDATE BOM_BILL_OF_MATERIALS
1125: SET PENDING_FROM_ECN = ''
1126: WHERE BILL_SEQUENCE_ID = bill_seq_id;
1127:
1128: EXCEPTION