DBA Data[Home] [Help]

APPS.ENG_CANCEL_ECO dependencies on BOM_REFERENCE_DESIGNATORS

Line 182: DELETE FROM BOM_REFERENCE_DESIGNATORS RD

178: /*
179: ** delete reference designators of all pending revised items on ECO
180: */
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

Line 859: DELETE FROM BOM_REFERENCE_DESIGNATORS RD

855: /*
856: ** delete reference designators of all pending revised items on ECO
857: */
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);

Line 1259: DELETE FROM BOM_REFERENCE_DESIGNATORS RD

1255: /*
1256: ** delete reference designators of all pending revised items on ECO
1257: */
1258: stmt_num := 30;
1259: DELETE FROM BOM_REFERENCE_DESIGNATORS RD
1260: WHERE RD.COMPONENT_SEQUENCE_ID = comp_seq_id;
1261: -- dbms_output.put_line(SQL%ROWCOUNT || ' rows deleted from rfd');
1262:
1263: stmt_num := 40;

Line 1277: DELETE FROM BOM_REFERENCE_DESIGNATORS RD

1273: DELETE FROM BOM_SUBSTITUTE_COMPONENTS SC
1274: WHERE SC.COMPONENT_SEQUENCE_ID = crc.COMPONENT_SEQUENCE_ID;
1275: /* Delete reference designators of all pending revised items on ECO */
1276: stmt_num := stmt_num+1;
1277: DELETE FROM BOM_REFERENCE_DESIGNATORS RD
1278: WHERE RD.COMPONENT_SEQUENCE_ID = crc.COMPONENT_SEQUENCE_ID;
1279: END LOOP;
1280: EXCEPTION
1281: WHEN OTHERS THEN