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 715: corresponding row from bom_bill_of_materials. Deletion will be done by

711: ** delete the bom header if bill was created by this revised item and
712: ** nothing else references this
713: */
714: /* This is to fix bug 1522704. Now cancellation of ECO won't delete
715: corresponding row from bom_bill_of_materials. Deletion will be done by
716: delete groups only. Here two line of code is added update BOM_BILL_OF_MATERIALS B
717: set pending_from_ecn = null*/
718: stmt_num := 80;
719: DELETE FROM BOM_BILL_OF_MATERIALS B

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

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

Line 719: DELETE FROM BOM_BILL_OF_MATERIALS B

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

Line 734: FROM BOM_BILL_OF_MATERIALS B2

730: AND (C.CHANGE_NOTICE IS NULL
731: OR C.CHANGE_NOTICE <> change_order))
732: AND ((B.ALTERNATE_BOM_DESIGNATOR IS NULL
733: AND NOT EXISTS (SELECT NULL
734: FROM BOM_BILL_OF_MATERIALS B2
735: WHERE B2.ORGANIZATION_ID = B.ORGANIZATION_ID
736: AND B2.ASSEMBLY_ITEM_ID = B.ASSEMBLY_ITEM_ID
737: AND B2.ALTERNATE_BOM_DESIGNATOR IS NOT NULL))
738: OR

Line 758: FROM BOM_BILL_OF_MATERIALS BOM

754: WHERE R.ORGANIZATION_ID = org_id
755: AND R.CHANGE_NOTICE = change_order
756: AND R.STATUS_TYPE = 5
757: AND NOT EXISTS (SELECT 'NO SUCH BILL'
758: FROM BOM_BILL_OF_MATERIALS BOM
759: WHERE BOM.BILL_SEQUENCE_ID = R.BILL_SEQUENCE_ID);
760: -- dbms_output.put_line(SQL%ROWCOUNT || ' rows updated in eri for bsi');
761: end if;
762:

Line 800: from BOM_BILL_OF_MATERIALS

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

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

1041: ** delete the bom header if bill was created by this revised item and
1042: ** nothing else references this
1043: */
1044: /* This is to fix bug 1522704. Now cancellation of ECO won't delete
1045: corresponding row from bom_bill_of_materials. Deletion will be done by
1046: delete groups only. Here two line of code is added update BOM_BILL_OF_MATERIALS B
1047: set pending_from_ecn = null*/
1048: stmt_num := 70;
1049: DELETE FROM BOM_BILL_OF_MATERIALS B

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

1042: ** nothing else references this
1043: */
1044: /* This is to fix bug 1522704. Now cancellation of ECO won't delete
1045: corresponding row from bom_bill_of_materials. Deletion will be done by
1046: delete groups only. Here two line of code is added update BOM_BILL_OF_MATERIALS B
1047: set pending_from_ecn = null*/
1048: stmt_num := 70;
1049: DELETE FROM BOM_BILL_OF_MATERIALS B
1050: WHERE B.BILL_SEQUENCE_ID = bill_seq_id

Line 1049: DELETE FROM BOM_BILL_OF_MATERIALS B

1045: corresponding row from bom_bill_of_materials. Deletion will be done by
1046: delete groups only. Here two line of code is added update BOM_BILL_OF_MATERIALS B
1047: set pending_from_ecn = null*/
1048: stmt_num := 70;
1049: DELETE FROM BOM_BILL_OF_MATERIALS B
1050: WHERE B.BILL_SEQUENCE_ID = bill_seq_id
1051: AND B.PENDING_FROM_ECN = change_order
1052: AND NOT EXISTS (SELECT NULL
1053: FROM BOM_INVENTORY_COMPONENTS C

Line 1059: FROM BOM_BILL_OF_MATERIALS B2

1055: AND (C.REVISED_ITEM_SEQUENCE_ID IS NULL
1056: OR C.REVISED_ITEM_SEQUENCE_ID <> rev_item_seq))
1057: AND ((B.ALTERNATE_BOM_DESIGNATOR IS NULL
1058: AND NOT EXISTS (SELECT NULL
1059: FROM BOM_BILL_OF_MATERIALS B2
1060: WHERE B2.ORGANIZATION_ID = B.ORGANIZATION_ID
1061: AND B2.ASSEMBLY_ITEM_ID = B.ASSEMBLY_ITEM_ID
1062: AND B2.ALTERNATE_BOM_DESIGNATOR IS NOT NULL))
1063: OR