APPS.WMS_TASK_LOAD dependencies on WSH_DELIVERY_ASSIGNMENTS

Line 12965: FROM wsh_delivery_assignments_v wda

12961: lpn_pjm_prj_tsk_rec pjm_rectype;
12962:
12963: CURSOR others_in_mmtt_delivery_cursor(l_lpn_id IN NUMBER) IS
12964: SELECT wda.delivery_id
12965: FROM wsh_delivery_assignments_v wda
12966: , wsh_delivery_details_ob_grp_v wdd
12967: , mtl_material_transactions_temp mmtt
12968: WHERE mmtt.transfer_lpn_id = l_lpn_id
12969: AND wda.delivery_detail_id = wdd.delivery_detail_id

Line 12984: FROM wsh_delivery_assignments_v wda

12980: child_lpns_rec child_lpns_cursor%ROWTYPE;
12981:
12982: CURSOR current_delivery_cursor IS
12983: SELECT wda.delivery_id
12984: FROM wsh_delivery_assignments_v wda
12985: , wsh_delivery_details_ob_grp_v wdd
12986: , mtl_material_transactions_temp mmtt
12987: WHERE wda.delivery_detail_id = wdd.delivery_detail_id
12988: AND wdd.move_order_line_id = mmtt.move_order_line_id

Line 12995: FROM wsh_delivery_assignments_v wda

12991: AND mmtt.organization_id = p_organization_id;
12992:
12993: CURSOR drop_delivery_cursor(l_lpn_id IN NUMBER) IS
12994: SELECT wda.delivery_id
12995: FROM wsh_delivery_assignments_v wda
12996: , wsh_delivery_details_ob_grp_v wdd
12997: WHERE wda.parent_delivery_detail_id = wdd.delivery_detail_id
12998: AND wdd.lpn_id = l_lpn_id
12999: AND wdd.organization_id = p_organization_id

Line 13046: FROM wsh_delivery_details wdd, wsh_delivery_assignments wda

13042: -- Bug 6168447 : Cursot to check if there are any wdd present for the LPN
13043:
13044: CURSOR c_wdd_exists(p_lpn_id NUMBER,p_organization_id NUMBER) is
13045: SELECT distinct wda.delivery_id
13046: FROM wsh_delivery_details wdd, wsh_delivery_assignments wda
13047: WHERE wdd.lpn_id IN (select lpn_id from wms_license_plate_numbers
13048: where organization_id = p_organization_id
13049: and (lpn_id = p_lpn_id
13050: or parent_lpn_id = p_lpn_id