APPS.WSH_BOLS_UTIL_PKG dependencies on WSH_DELIVERY_DETAILS

Line 313: FROM wsh_delivery_details

309: gross_weight,
310: weight_uom_code,
311: volume,
312: volume_uom_code
313: FROM wsh_delivery_details
314: WHERE delivery_detail_id = x_master_inst_id
315: AND container_flag = 'Y';
316:
317: CURSOR c_get_master_container_items(x_master_inst_id NUMBER) IS

Line 324: FROM wsh_delivery_details wdd,

320: wdd.hazard_class_id,
321: wdd.shipped_quantity,
322: wdd.requested_quantity_uom,
323: wdd.classification
324: FROM wsh_delivery_details wdd,
325: wsh_delivery_assignments_v wda
326: WHERE wda.parent_delivery_detail_id = x_master_inst_id
327: AND wda.delivery_detail_id = wdd.delivery_detail_id
328: AND wdd.container_flag = 'N';

Line 332: FROM wsh_delivery_details wdd,

328: AND wdd.container_flag = 'N';
329:
330: CURSOR c_get_inner_containers(x_container_id NUMBER) IS
331: SELECT wdd.delivery_detail_id
332: FROM wsh_delivery_details wdd,
333: wsh_delivery_assignments_v wda
334: WHERE wda.delivery_detail_id = wdd.delivery_detail_id
335: AND wdd.container_flag = 'Y'
336: AND wda.delivery_assignment_id IN

Line 349: FROM wsh_delivery_details wdd,

345: wdd.hazard_class_id,
346: wdd.shipped_quantity,
347: wdd.requested_quantity_uom,
348: wdd.classification
349: FROM wsh_delivery_details wdd,
350: wsh_delivery_assignments_v wda
351: WHERE wda.parent_delivery_detail_id = x_cont_inst_id
352: AND wda.delivery_detail_id = wdd.delivery_detail_id
353: AND wdd.container_flag = 'N';

Line 358: wsh_delivery_details wdd

354:
355: CURSOR c_get_sub_containers(x_master_inst_id NUMBER) IS
356: SELECT wdd.delivery_detail_id
357: FROM wsh_delivery_assignments_v wda,
358: wsh_delivery_details wdd
359: WHERE wda.parent_delivery_detail_id = x_master_inst_id
360: AND wda.delivery_detail_id = wdd.delivery_detail_id
361: AND wdd.container_flag = 'Y';
362:

Line 365: FROM wsh_delivery_details

361: AND wdd.container_flag = 'Y';
362:
363: CURSOR c_get_enclosed_containers(x_cont_id NUMBER) IS
364: SELECT container_name
365: FROM wsh_delivery_details
366: WHERE delivery_detail_id = x_cont_id
367: AND container_flag = 'Y';
368:
369: -- Bug# 3306781