APPS.WMS_TASK_LOAD dependencies on WSH_DELIVERY_DETAILS_OB_GRP_V

Line 10670: , wsh_delivery_details_ob_grp_v wdd

10666:
10667: CURSOR others_in_mmtt_delivery_cursor(l_lpn_id IN NUMBER) IS
10668: SELECT wda.delivery_id
10669: FROM wsh_delivery_assignments_v wda
10670: , wsh_delivery_details_ob_grp_v wdd
10671: , mtl_material_transactions_temp mmtt
10672: WHERE mmtt.transfer_lpn_id = l_lpn_id
10673: AND wda.delivery_detail_id = wdd.delivery_detail_id
10674: AND wdd.move_order_line_id = mmtt.move_order_line_id

Line 10689: , wsh_delivery_details_ob_grp_v wdd

10685:
10686: CURSOR current_delivery_cursor IS
10687: SELECT wda.delivery_id
10688: FROM wsh_delivery_assignments_v wda
10689: , wsh_delivery_details_ob_grp_v wdd
10690: , mtl_material_transactions_temp mmtt
10691: WHERE wda.delivery_detail_id = wdd.delivery_detail_id
10692: AND wdd.move_order_line_id = mmtt.move_order_line_id
10693: AND wdd.organization_id = mmtt.organization_id

Line 10700: , wsh_delivery_details_ob_grp_v wdd

10696:
10697: CURSOR drop_delivery_cursor(l_lpn_id IN NUMBER) IS
10698: SELECT wda.delivery_id
10699: FROM wsh_delivery_assignments_v wda
10700: , wsh_delivery_details_ob_grp_v wdd
10701: WHERE wda.parent_delivery_detail_id = wdd.delivery_detail_id
10702: AND wdd.lpn_id = l_lpn_id
10703: AND wdd.organization_id = p_organization_id
10704: AND wdd.released_status = 'X'; -- For LPN reusability ER : 6845650

Line 10853: FROM wsh_delivery_details_ob_grp_v wdd

10849: or outermost_lpn_id = pick_to_lpn_rec.lpn_id);
10850:
10851: SELECT wdd.released_status,wdd.delivery_detail_id
10852: INTO l_status_code,l_delivery_detail_id
10853: FROM wsh_delivery_details_ob_grp_v wdd
10854: WHERE wdd.container_name = l_lpn_name
10855: AND wdd.released_status = 'X'; -- For LPN reusability ER : 6845650
10856:
10857: /* Release 12(K): LPN Synchronization