APPS.WMS_PACKING_WORKBENCH_PVT dependencies on WSH_NEW_DELIVERIES

Line 1944: FROM wsh_new_deliveries_ob_grp_v wnd

1940: -- Use this cursor when p_delivery_is is not null
1941: CURSOR l_delivery_cur_del IS
1942: SELECT wnd.delivery_id, wnd.name,
1943: nvl(p_delivery_state, wms_consolidation_pub.is_delivery_consolidated(wnd.delivery_id, p_organization_id, p_subinventory_code, p_locator_id))
1944: FROM wsh_new_deliveries_ob_grp_v wnd
1945: WHERE wnd.organization_id = p_organization_id
1946: AND wnd.delivery_id = p_delivery_id
1947: AND ((p_trip_id IS NULL) OR
1948: (p_trip_id IS NOT NULL AND wnd.delivery_id IN

Line 1960: FROM wsh_new_deliveries_ob_grp_v wnd

1956: -- Use this cursor when p_delivery_is is null but p_trip_id is not null
1957: CURSOR l_delivery_cur_trip IS
1958: SELECT wnd.delivery_id, wnd.name,
1959: nvl(p_delivery_state, wms_consolidation_pub.is_delivery_consolidated(wnd.delivery_id, p_organization_id, p_subinventory_code, p_locator_id))
1960: FROM wsh_new_deliveries_ob_grp_v wnd
1961: WHERE wnd.organization_id = p_organization_id
1962: AND wnd.delivery_id IN
1963: (select wdl.delivery_id from wsh_delivery_legs_ob_grp_v wdl, wsh_trip_stops_ob_grp_v wts
1964: where wdl.pick_up_stop_id = wts.stop_id

Line 1975: FROM wsh_new_deliveries_ob_grp_v wnd

1971: -- Then have to use this expensive cursor
1972: CURSOR l_delivery_cur_exp IS
1973: SELECT wnd.delivery_id, wnd.name,
1974: nvl(p_delivery_state, wms_consolidation_pub.is_delivery_consolidated(wnd.delivery_id, p_organization_id, p_subinventory_code, p_locator_id))
1975: FROM wsh_new_deliveries_ob_grp_v wnd
1976: WHERE wnd.organization_id = p_organization_id
1977: AND ((p_delivery_state IS NULL) OR
1978: (p_delivery_state IS NOT NULL AND
1979: wms_consolidation_pub.is_delivery_consolidated(wnd.delivery_id, p_organization_id, p_subinventory_code, p_locator_id) = p_delivery_state));

Line 2008: ,wsh_delivery_assignments_v wda, wsh_new_deliveries_ob_grp_v wnd

2004: ,wdd1.ship_to_location_id
2005: ,wdd1.ship_set_id
2006: ,wdd1.top_model_line_id
2007: FROM wsh_delivery_details_ob_grp_v wdd1, wsh_delivery_details_ob_grp_v wdd2
2008: ,wsh_delivery_assignments_v wda, wsh_new_deliveries_ob_grp_v wnd
2009: -- Bug 5121507
2010: , wsh_delivery_legs wdl
2011: , wsh_trip_stops wts
2012: , wsh_trips wt

Line 2323: FROM wsh_new_deliveries

2319: l_material_rec.delivery := l_delivery;
2320: ELSIF l_material_rec.delivery_id IS NOT NULL THEN
2321: BEGIN
2322: SELECT name INTO l_material_rec.delivery
2323: FROM wsh_new_deliveries
2324: WHERE delivery_id = l_material_rec.delivery_id;
2325: EXCEPTION
2326: WHEN NO_DATA_FOUND THEN
2327: IF l_debug = 1 THEN