APPS.WSH_BOLS_UTIL_PKG dependencies on WSH_DELIVERY_ASSIGNMENTS_V

Line 325: wsh_delivery_assignments_v wda

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';
329:

Line 333: wsh_delivery_assignments_v wda

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
337: (SELECT wda1.delivery_assignment_id

Line 338: FROM wsh_delivery_assignments_v wda1

334: WHERE wda.delivery_detail_id = wdd.delivery_detail_id
335: AND wdd.container_flag = 'Y'
336: AND wda.delivery_assignment_id IN
337: (SELECT wda1.delivery_assignment_id
338: FROM wsh_delivery_assignments_v wda1
339: START WITH wda1.parent_delivery_detail_id = x_container_id
340: CONNECT BY PRIOR wda1.delivery_detail_id = wda1.parent_delivery_detail_id);
341:
342: CURSOR c_get_container_items(x_cont_inst_id NUMBER) IS

Line 350: wsh_delivery_assignments_v wda

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';
354:

Line 357: FROM wsh_delivery_assignments_v wda,

353: AND wdd.container_flag = 'N';
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';