APPS.WMS_TASK_MGMT_PUB dependencies on WMS_LICENSE_PLATE_NUMBERS

Line 241: FROM wms_license_plate_numbers wlpn

237: IS
238: SELECT lpn_context,
239: organization_id,
240: inventory_item_id
241: FROM wms_license_plate_numbers wlpn
242: WHERE wlpn.lpn_id=c_lpn_id;
243:
244: CURSOR carton_lpn_del_det (c_lpn_id NUMBER)
245: IS

Line 798: FROM wms_license_plate_numbers

794:
795: IF (P_new_carton_lpn_id IS NOT NULL) THEN
796: SELECT license_plate_number
797: INTO l_lpn
798: FROM wms_license_plate_numbers
799: WHERE lpn_id =P_new_carton_lpn_id;
800: p_output_task_rec.cartonization_lpn := l_lpn;
801: p_output_task_rec.cartonization_id := P_new_carton_lpn_id;
802: END IF;

Line 1215: FROM wms_license_plate_numbers wlpn

1211: CURSOR carton_lpn_csr(c_lpn_id NUMBER)
1212: IS
1213: SELECT lpn_context,
1214: organization_id
1215: FROM wms_license_plate_numbers wlpn
1216: WHERE wlpn.lpn_id=c_lpn_id;
1217: CURSOR carton_lpn_del_det (c_lpn_id NUMBER)
1218: IS
1219: SELECT wdd.delivery_detail_id,