APPS.WSH_BOLS_UTIL_PKG dependencies on WSH_DELIVERY_DETAILS

Line 302: FROM wsh_delivery_details

298: gross_weight,
299: weight_uom_code,
300: volume,
301: volume_uom_code
302: FROM wsh_delivery_details
303: WHERE delivery_detail_id = x_master_inst_id
304: AND container_flag = 'Y';
305:
306: CURSOR c_get_master_container_items(x_master_inst_id NUMBER) IS

Line 313: FROM wsh_delivery_details wdd,

309: wdd.hazard_class_id,
310: wdd.shipped_quantity,
311: wdd.requested_quantity_uom,
312: wdd.classification
313: FROM wsh_delivery_details wdd,
314: wsh_delivery_assignments_v wda
315: WHERE wda.parent_delivery_detail_id = x_master_inst_id
316: AND wda.delivery_detail_id = wdd.delivery_detail_id
317: AND wdd.container_flag = 'N';

Line 321: FROM wsh_delivery_details wdd,

317: AND wdd.container_flag = 'N';
318:
319: CURSOR c_get_inner_containers(x_container_id NUMBER) IS
320: SELECT wdd.delivery_detail_id
321: FROM wsh_delivery_details wdd,
322: wsh_delivery_assignments_v wda
323: WHERE wda.delivery_detail_id = wdd.delivery_detail_id
324: AND wdd.container_flag = 'Y'
325: AND wda.delivery_assignment_id IN

Line 338: FROM wsh_delivery_details wdd,

334: wdd.hazard_class_id,
335: wdd.shipped_quantity,
336: wdd.requested_quantity_uom,
337: wdd.classification
338: FROM wsh_delivery_details wdd,
339: wsh_delivery_assignments_v wda
340: WHERE wda.parent_delivery_detail_id = x_cont_inst_id
341: AND wda.delivery_detail_id = wdd.delivery_detail_id
342: AND wdd.container_flag = 'N';

Line 347: wsh_delivery_details wdd

343:
344: CURSOR c_get_sub_containers(x_master_inst_id NUMBER) IS
345: SELECT wdd.delivery_detail_id
346: FROM wsh_delivery_assignments_v wda,
347: wsh_delivery_details wdd
348: WHERE wda.parent_delivery_detail_id = x_master_inst_id
349: AND wda.delivery_detail_id = wdd.delivery_detail_id
350: AND wdd.container_flag = 'Y';
351:

Line 354: FROM wsh_delivery_details

350: AND wdd.container_flag = 'Y';
351:
352: CURSOR c_get_enclosed_containers(x_cont_id NUMBER) IS
353: SELECT container_name
354: FROM wsh_delivery_details
355: WHERE delivery_detail_id = x_cont_id
356: AND container_flag = 'Y';
357:
358: -- Bug# 3306781