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

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

Line 322: DELETE FROM BOM_INVENTORY_COMPONENTS IC

318: /*
319: ** delete the rows from bom_inventory_components
320: */
321: stmt_num := 50;
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

Line 336: ** delete the rows from bom_inventory_components

332: /*Special handling for Editable common bom*/
333: for Common_bom in is_editable_common_bom(org_id,change_order) loop
334:
335: /*
336: ** delete the rows from bom_inventory_components
337: */
338: DELETE FROM BOM_INVENTORY_COMPONENTS IC
339: WHERE IC.BILL_SEQUENCE_ID =Common_bom.bill_sequence_id ;
340: END loop;

Line 338: DELETE FROM BOM_INVENTORY_COMPONENTS IC

334:
335: /*
336: ** delete the rows from bom_inventory_components
337: */
338: DELETE FROM BOM_INVENTORY_COMPONENTS IC
339: WHERE IC.BILL_SEQUENCE_ID =Common_bom.bill_sequence_id ;
340: END loop;
341:
342:

Line 744: FROM BOM_INVENTORY_COMPONENTS C

740: AND STATUS_TYPE = 5)
741: /* AND TRUNC(LAST_UPDATE_DATE) = trunc(sysdate)) for bug 10042748 */
742: AND B.PENDING_FROM_ECN = change_order
743: AND NOT EXISTS (SELECT NULL
744: FROM BOM_INVENTORY_COMPONENTS C
745: WHERE C.BILL_SEQUENCE_ID = B.BILL_SEQUENCE_ID
746: AND (C.CHANGE_NOTICE IS NULL
747: OR C.CHANGE_NOTICE <> change_order))
748: AND ((B.ALTERNATE_BOM_DESIGNATOR IS NULL

Line 876: FROM BOM_INVENTORY_COMPONENTS IC

872: stmt_num := 20;
873: DELETE FROM BOM_SUBSTITUTE_COMPONENTS SC
874: WHERE SC.COMPONENT_SEQUENCE_ID IN
875: (SELECT IC.COMPONENT_SEQUENCE_ID
876: FROM BOM_INVENTORY_COMPONENTS IC
877: WHERE IC.REVISED_ITEM_SEQUENCE_ID = rev_item_seq);
878: -- dbms_output.put_line(SQL%ROWCOUNT || ' rows deleted from bsc');
879:
880: /*

Line 887: FROM BOM_INVENTORY_COMPONENTS IC

883: stmt_num := 30;
884: DELETE FROM BOM_REFERENCE_DESIGNATORS RD
885: WHERE RD.COMPONENT_SEQUENCE_ID IN
886: (SELECT IC.COMPONENT_SEQUENCE_ID
887: FROM BOM_INVENTORY_COMPONENTS IC
888: WHERE IC.REVISED_ITEM_SEQUENCE_ID = rev_item_seq);
889: -- dbms_output.put_line(SQL%ROWCOUNT || ' rows deleted from brd');
890:
891: /*

Line 1001: FROM BOM_INVENTORY_COMPONENTS IC

997: IC.ATTRIBUTE12,
998: IC.ATTRIBUTE13,
999: IC.ATTRIBUTE14,
1000: IC.ATTRIBUTE15
1001: FROM BOM_INVENTORY_COMPONENTS IC
1002: WHERE IC.REVISED_ITEM_SEQUENCE_ID = rev_item_seq;
1003: -- dbms_output.put_line(SQL%ROWCOUNT || ' rows inserted into erc');
1004:
1005: /*

Line 1006: ** delete the rows from bom_inventory_components

1002: WHERE IC.REVISED_ITEM_SEQUENCE_ID = rev_item_seq;
1003: -- dbms_output.put_line(SQL%ROWCOUNT || ' rows inserted into erc');
1004:
1005: /*
1006: ** delete the rows from bom_inventory_components
1007: */
1008: stmt_num := 50;
1009: DELETE FROM BOM_INVENTORY_COMPONENTS IC
1010: WHERE REVISED_ITEM_SEQUENCE_ID = rev_item_seq;

Line 1009: DELETE FROM BOM_INVENTORY_COMPONENTS IC

1005: /*
1006: ** delete the rows from bom_inventory_components
1007: */
1008: stmt_num := 50;
1009: DELETE FROM BOM_INVENTORY_COMPONENTS IC
1010: WHERE REVISED_ITEM_SEQUENCE_ID = rev_item_seq;
1011: -- dbms_output.put_line(SQL%ROWCOUNT || ' rows deleted from bic');
1012:
1013: /*Special handling for Editable common bom*/

Line 1016: ** delete the rows from bom_inventory_components

1012:
1013: /*Special handling for Editable common bom*/
1014: for common in is_editable_common_bom1(rev_item_seq) loop
1015: /*
1016: ** delete the rows from bom_inventory_components
1017: */
1018:
1019: DELETE FROM BOM_INVENTORY_COMPONENTS IC
1020: WHERE IC.BILL_SEQUENCE_ID = common.bill_sequence_id ;

Line 1019: DELETE FROM BOM_INVENTORY_COMPONENTS IC

1015: /*
1016: ** delete the rows from bom_inventory_components
1017: */
1018:
1019: DELETE FROM BOM_INVENTORY_COMPONENTS IC
1020: WHERE IC.BILL_SEQUENCE_ID = common.bill_sequence_id ;
1021: end loop;
1022:
1023: /*

Line 1078: FROM BOM_INVENTORY_COMPONENTS C

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

Line 1264: FROM BOM_INVENTORY_COMPONENTS IC

1260: IC.ATTRIBUTE12,
1261: IC.ATTRIBUTE13,
1262: IC.ATTRIBUTE14,
1263: IC.ATTRIBUTE15
1264: FROM BOM_INVENTORY_COMPONENTS IC
1265: WHERE IC.COMPONENT_SEQUENCE_ID = comp_seq_id;
1266: -- dbms_output.put_line(SQL%ROWCOUNT || ' rows inserted into erc');
1267:
1268: /*

Line 1271: DELETE FROM BOM_INVENTORY_COMPONENTS

1267:
1268: /*
1269: ** delete from bom_inventory_comps
1270: */
1271: DELETE FROM BOM_INVENTORY_COMPONENTS
1272: WHERE COMPONENT_SEQUENCE_ID = comp_seq_id;
1273: -- dbms_output.put_line(SQL%ROWCOUNT || ' rows delete from bic');
1274:
1275: -- Fixed bug 618781.