DBA Data[Home] [Help]

APPS.WMS_PACKING_WORKBENCH_PVT dependencies on WSH_DELIVERY_LEGS_OB_GRP_V

Line 1949: (select wdl.delivery_id from wsh_delivery_legs_ob_grp_v wdl, wsh_trip_stops_ob_grp_v wts

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
1949: (select wdl.delivery_id from wsh_delivery_legs_ob_grp_v wdl, wsh_trip_stops_ob_grp_v wts
1950: where wdl.pick_up_stop_id = wts.stop_id
1951: and wts.trip_id = p_trip_id)))
1952: AND ((p_delivery_state IS NULL) OR
1953: (p_delivery_state IS NOT NULL AND

Line 1963: (select wdl.delivery_id from wsh_delivery_legs_ob_grp_v wdl, wsh_trip_stops_ob_grp_v wts

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
1965: and wts.trip_id = p_trip_id)
1966: AND ((p_delivery_state IS NULL) OR
1967: (p_delivery_state IS NOT NULL AND