APPS.INV_LABEL_PVT8 dependencies on WMS_LABEL_REQUESTS

Line 3631: FROM WMS_LABEL_REQUESTS WLR

3627: trace(' WDD id:'||l_cur_wdd.delivery_id||',org:'||l_cur_wdd.organization_id||
3628: ',outer_lpn_id:'||l_cur_wdd.outer_lpn_id);
3629: END IF;
3630: SELECT COUNT(1) INTO l_wdd_already_printed
3631: FROM WMS_LABEL_REQUESTS WLR
3632: WHERE WLR.ORGANIZATION_ID = l_cur_wdd.organization_id
3633: AND WLR.LPN_ID = l_cur_wdd.outer_lpn_id
3634: AND WLR.DELIVERY_ID = l_cur_wdd.delivery_id
3635: AND WLR.INVENTORY_ITEM_ID = l_cur_wdd.inventory_item_id

Line 3645: DELETE FROM WMS_LABEL_REQUESTS WLR WHERE WLR.LABEL_REQUEST_ID = l_label_request_id;

3641: IF (l_wdd_already_printed > 0) THEN
3642: IF (l_debug = 1) THEN
3643: trace('Label for this WDD in this LPN was already printed, skipping..');
3644: END IF;
3645: DELETE FROM WMS_LABEL_REQUESTS WLR WHERE WLR.LABEL_REQUEST_ID = l_label_request_id;
3646: row_index_per_label := row_index_per_label - 1;
3647: l_wdd_loop_counter_start := i+1; -- Bug 16506369
3648: GOTO wdd_start_loop; -- Bug 16506369
3649: END IF;

Line 3685: UPDATE wms_label_requests

3681: END IF;
3682:
3683: -- 13985380 fix start
3684: IF l_printer IS NOT NULL THEN
3685: UPDATE wms_label_requests
3686: SET printer_name = l_printer
3687: WHERE label_request_id = l_label_request_id;
3688: END IF;
3689: -- 13985380 fix ends