APPS.WMS_TASK_LOAD dependencies on WSH_DELIVERY_DETAILS_OB_GRP_V

Line 12966: , wsh_delivery_details_ob_grp_v wdd

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
12970: AND wdd.move_order_line_id = mmtt.move_order_line_id

Line 12985: , wsh_delivery_details_ob_grp_v wdd

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
12989: AND wdd.organization_id = mmtt.organization_id

Line 12996: , wsh_delivery_details_ob_grp_v wdd

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
13000: AND wdd.released_status = 'X'; -- For LPN reusability ER : 6845650

Line 13149: FROM wsh_delivery_details_ob_grp_v wdd

13145: or outermost_lpn_id = pick_to_lpn_rec.lpn_id);
13146:
13147: SELECT wdd.released_status,wdd.delivery_detail_id
13148: INTO l_status_code,l_delivery_detail_id
13149: FROM wsh_delivery_details_ob_grp_v wdd
13150: WHERE wdd.container_name = l_lpn_name
13151: AND wdd.released_status = 'X'; -- For LPN reusability ER : 6845650
13152:
13153: /* Release 12(K): LPN Synchronization