APPS.MRP_UPDATE_MRP_INFO_PK dependencies on MRP_RECOMMENDATIONS

Line 244: INDEX(recom MRP_RECOMMENDATIONS_N1)

240: );
241:
242: CURSOR recommendations_cursor IS
243: SELECT /* ORDERED
244: INDEX(recom MRP_RECOMMENDATIONS_N1)
245: INDEX(mrp MRP_RELIEF_INTERFACE_N1)
246: INDEX(plans MRP_PLANS_U1) */
247: recom.rowid
248: FROM mrp_recommendations recom

Line 248: FROM mrp_recommendations recom

244: INDEX(recom MRP_RECOMMENDATIONS_N1)
245: INDEX(mrp MRP_RELIEF_INTERFACE_N1)
246: INDEX(plans MRP_PLANS_U1) */
247: recom.rowid
248: FROM mrp_recommendations recom
249: WHERE recom.new_order_quantity >= 0
250: AND recom.firm_planned_type = SYS_NO
251: AND recom.disposition_status_type = NULL_VALUE
252: AND recom.order_type = PSEUDO_PLANNED_ORDER

Line 299: 'TABLE', 'mrp_recommendations', 'N');

295:
296:
297: var_watch_id := mrp_print_pk.start_watch(
298: 'GEN-deleted from table', arg_request_id, arg_user_id,
299: 'TABLE', 'mrp_recommendations', 'N');
300: var_row_count := 0;
301: OPEN recommendations_cursor;
302: LOOP
303:

Line 307: DELETE FROM mrp_recommendations recom

303:
304: FETCH recommendations_cursor INTO var_rowid;
305: exit when recommendations_cursor%notfound;
306:
307: DELETE FROM mrp_recommendations recom
308: WHERE rowid = var_rowid;
309:
310: var_row_count := var_row_count + NVL(SQL%ROWCOUNT, 0);
311: