APPS.WSH_BOLS_UTIL_PKG dependencies on WSH_DELIVERY_ASSIGNMENTS_V

Line 314: wsh_delivery_assignments_v wda

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

Line 322: wsh_delivery_assignments_v wda

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

Line 327: FROM wsh_delivery_assignments_v wda1

323: WHERE wda.delivery_detail_id = wdd.delivery_detail_id
324: AND wdd.container_flag = 'Y'
325: AND wda.delivery_assignment_id IN
326: (SELECT wda1.delivery_assignment_id
327: FROM wsh_delivery_assignments_v wda1
328: START WITH wda1.parent_delivery_detail_id = x_container_id
329: CONNECT BY PRIOR wda1.delivery_detail_id = wda1.parent_delivery_detail_id);
330:
331: CURSOR c_get_container_items(x_cont_inst_id NUMBER) IS

Line 339: wsh_delivery_assignments_v wda

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

Line 346: FROM wsh_delivery_assignments_v wda,

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