APPS.GML_MOBILE_SHIP_CONFIRM dependencies on WMS_LICENSE_PLATE_NUMBERS

Line 163: FROM WMS_LICENSE_PLATE_NUMBERS

159: and wda2.delivery_detail_id = wdd.delivery_detail_id;
160:
161: CURSOR nested_parent_lpn_cursor(l_inner_lpn_id NUMBER) is
162: SELECT lpn_id
163: FROM WMS_LICENSE_PLATE_NUMBERS
164: START WITH lpn_id = l_inner_lpn_id
165: CONNECT BY lpn_id = PRIOR parent_lpn_id;
166:
167: l_delivery_details_id_table WSH_UTIL_CORE.ID_TAB_TYPE;

Line 259: UPDATE wms_license_plate_numbers

255: WHERE delivery_detail_id = l_parent_delivery_detail_id;
256:
257: --update LPN(s) context to Resides in Inventory
258: FOR l_par_lpn_id IN nested_parent_lpn_cursor(l_lpn_id) LOOP
259: UPDATE wms_license_plate_numbers
260: SET lpn_context = 1,
261: last_update_date = SYSDATE,
262: last_updated_by = fnd_global.user_id
263: WHERE lpn_id = l_par_lpn_id.lpn_id;