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_INVENTORY_COMPONENTS

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 314: ** delete the rows from bom_inventory_components

310: AND IC.IMPLEMENTATION_DATE IS NULL;
311: -- dbms_output.put_line(SQL%ROWCOUNT || ' rows inserted in erc');
312:
313: /*
314: ** delete the rows from bom_inventory_components
315: */
316: stmt_num := 50;
317: DELETE FROM BOM_INVENTORY_COMPONENTS IC
318: WHERE CHANGE_NOTICE = change_order

Line 317: DELETE FROM BOM_INVENTORY_COMPONENTS IC

313: /*
314: ** delete the rows from bom_inventory_components
315: */
316: stmt_num := 50;
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

Line 331: ** delete the rows from bom_inventory_components

327: /*Special handling for Editable common bom*/
328: for Common_bom in is_editable_common_bom(org_id,change_order) loop
329:
330: /*
331: ** delete the rows from bom_inventory_components
332: */
333: DELETE FROM BOM_INVENTORY_COMPONENTS IC
334: WHERE IC.BILL_SEQUENCE_ID =Common_bom.bill_sequence_id ;
335: END loop;

Line 333: DELETE FROM BOM_INVENTORY_COMPONENTS IC

329:
330: /*
331: ** delete the rows from bom_inventory_components
332: */
333: DELETE FROM BOM_INVENTORY_COMPONENTS IC
334: WHERE IC.BILL_SEQUENCE_ID =Common_bom.bill_sequence_id ;
335: END loop;
336:
337:

Line 728: FROM BOM_INVENTORY_COMPONENTS C

724: AND STATUS_TYPE = 5
725: AND TRUNC(LAST_UPDATE_DATE) = trunc(sysdate))
726: AND B.PENDING_FROM_ECN = change_order
727: AND NOT EXISTS (SELECT NULL
728: FROM BOM_INVENTORY_COMPONENTS C
729: WHERE C.BILL_SEQUENCE_ID = B.BILL_SEQUENCE_ID
730: AND (C.CHANGE_NOTICE IS NULL
731: OR C.CHANGE_NOTICE <> change_order))
732: AND ((B.ALTERNATE_BOM_DESIGNATOR IS NULL

Line 851: FROM BOM_INVENTORY_COMPONENTS IC

847: stmt_num := 20;
848: DELETE FROM BOM_SUBSTITUTE_COMPONENTS SC
849: WHERE SC.COMPONENT_SEQUENCE_ID IN
850: (SELECT IC.COMPONENT_SEQUENCE_ID
851: FROM BOM_INVENTORY_COMPONENTS IC
852: WHERE IC.REVISED_ITEM_SEQUENCE_ID = rev_item_seq);
853: -- dbms_output.put_line(SQL%ROWCOUNT || ' rows deleted from bsc');
854:
855: /*

Line 862: FROM BOM_INVENTORY_COMPONENTS IC

858: stmt_num := 30;
859: DELETE FROM BOM_REFERENCE_DESIGNATORS RD
860: WHERE RD.COMPONENT_SEQUENCE_ID IN
861: (SELECT IC.COMPONENT_SEQUENCE_ID
862: FROM BOM_INVENTORY_COMPONENTS IC
863: WHERE IC.REVISED_ITEM_SEQUENCE_ID = rev_item_seq);
864: -- dbms_output.put_line(SQL%ROWCOUNT || ' rows deleted from brd');
865:
866: /*

Line 976: FROM BOM_INVENTORY_COMPONENTS IC

972: IC.ATTRIBUTE12,
973: IC.ATTRIBUTE13,
974: IC.ATTRIBUTE14,
975: IC.ATTRIBUTE15
976: FROM BOM_INVENTORY_COMPONENTS IC
977: WHERE IC.REVISED_ITEM_SEQUENCE_ID = rev_item_seq;
978: -- dbms_output.put_line(SQL%ROWCOUNT || ' rows inserted into erc');
979:
980: /*

Line 981: ** delete the rows from bom_inventory_components

977: WHERE IC.REVISED_ITEM_SEQUENCE_ID = rev_item_seq;
978: -- dbms_output.put_line(SQL%ROWCOUNT || ' rows inserted into erc');
979:
980: /*
981: ** delete the rows from bom_inventory_components
982: */
983: stmt_num := 50;
984: DELETE FROM BOM_INVENTORY_COMPONENTS IC
985: WHERE REVISED_ITEM_SEQUENCE_ID = rev_item_seq;

Line 984: DELETE FROM BOM_INVENTORY_COMPONENTS IC

980: /*
981: ** delete the rows from bom_inventory_components
982: */
983: stmt_num := 50;
984: DELETE FROM BOM_INVENTORY_COMPONENTS IC
985: WHERE REVISED_ITEM_SEQUENCE_ID = rev_item_seq;
986: -- dbms_output.put_line(SQL%ROWCOUNT || ' rows deleted from bic');
987:
988: /*Special handling for Editable common bom*/

Line 991: ** delete the rows from bom_inventory_components

987:
988: /*Special handling for Editable common bom*/
989: for common in is_editable_common_bom1(rev_item_seq) loop
990: /*
991: ** delete the rows from bom_inventory_components
992: */
993:
994: DELETE FROM BOM_INVENTORY_COMPONENTS IC
995: WHERE IC.BILL_SEQUENCE_ID = common.bill_sequence_id ;

Line 994: DELETE FROM BOM_INVENTORY_COMPONENTS IC

990: /*
991: ** delete the rows from bom_inventory_components
992: */
993:
994: DELETE FROM BOM_INVENTORY_COMPONENTS IC
995: WHERE IC.BILL_SEQUENCE_ID = common.bill_sequence_id ;
996: end loop;
997:
998: /*

Line 1053: FROM BOM_INVENTORY_COMPONENTS C

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
1054: WHERE C.BILL_SEQUENCE_ID = B.BILL_SEQUENCE_ID
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

Line 1232: FROM BOM_INVENTORY_COMPONENTS IC

1228: IC.ATTRIBUTE12,
1229: IC.ATTRIBUTE13,
1230: IC.ATTRIBUTE14,
1231: IC.ATTRIBUTE15
1232: FROM BOM_INVENTORY_COMPONENTS IC
1233: WHERE IC.COMPONENT_SEQUENCE_ID = comp_seq_id;
1234: -- dbms_output.put_line(SQL%ROWCOUNT || ' rows inserted into erc');
1235:
1236: /*

Line 1239: DELETE FROM BOM_INVENTORY_COMPONENTS

1235:
1236: /*
1237: ** delete from bom_inventory_comps
1238: */
1239: DELETE FROM BOM_INVENTORY_COMPONENTS
1240: WHERE COMPONENT_SEQUENCE_ID = comp_seq_id;
1241: -- dbms_output.put_line(SQL%ROWCOUNT || ' rows delete from bic');
1242:
1243: -- Fixed bug 618781.