[Home] [Help]
547: where milk.inventory_location_id (+) = lpn.locator_id
548: and milk.organization_id (+) = lpn.organization_id
549: and milk.organization_id = p_organization_id
550: and milk.subinventory_code = p_sub_code
551: and (lpn.lpn_context = wms_globals.lpn_context_inv OR lpn.lpn_context = wms_globals.lpn_context_picked)
552: and milk.concatenated_segments like (p_staging_lane);
553: end if;
554: END GET_STAGING_LANE;
555:
1060: and wdd2.delivery_detail_id = wda.parent_delivery_detail_id
1061: and wdd2.lpn_id is not null -- for performance, bug 2418639
1062: and wdd2.lpn_id = lpn.lpn_id
1063: and lpn.outermost_lpn_id = wlpn.lpn_id
1064: --MR-MDC wlpn.lpn_context <> wms_globals.lpn_loaded_for_shipment
1065: and ( wlpn.lpn_context = wms_container_pvt.lpn_context_picked
1066: OR wlpn.lpn_context = wms_container_pvt.lpn_loaded_in_stage)
1067: -- 5582189 dherring additional criteria added to ensure ship confirmed deliveries
1068: -- do not appear in the lov
2973: and wdl.pick_up_stop_id = pickup_stop.stop_id
2974: and pickup_stop.trip_id = p_trip_id
2975: and lpn.lpn_id = wdd2.lpn_id
2976: and lpn.outermost_lpn_id = wlpn.lpn_id
2977: and wlpn.lpn_context <> wms_globals.lpn_loaded_for_shipment
2978: and lpn.locator_id = milk.inventory_location_id
2979: and lpn.organization_id = milk.organization_id
2980: and wlpn.license_plate_number like (p_lpn)
2981: order by wlpn.license_plate_number;
3008: and wstt.dock_appoint_flag = 'N' )
3009: and wda.delivery_id = wnd.delivery_id
3010: and lpn.lpn_id = wdd2.lpn_id
3011: and lpn.outermost_lpn_id = wlpn.lpn_id
3012: and wlpn.lpn_context <> wms_globals.lpn_loaded_for_shipment
3013: and lpn.locator_id = milk.inventory_location_id
3014: and lpn.organization_id = milk.organization_id
3015: and wlpn.license_plate_number like (p_lpn)
3016: order by wlpn.license_plate_number;
5403: mtl_item_locations_kfv milk
5404: WHERE wlpn.organization_id = wstt.organization_id
5405: AND wlpn.organization_id = p_organization_id
5406: AND wlpn.lpn_id = wstt.outermost_lpn_id
5407: and wlpn.lpn_context = wms_globals.lpn_loaded_for_shipment
5408: AND wstt.dock_door_id = p_dock_door_id
5409: AND nvl(wstt.direct_ship_flag,'N') = 'N'
5410: AND milk.organization_id = wlpn.organization_id
5411: AND milk.inventory_location_id = wlpn.locator_id
5471: END IF;
5472:
5473: --update lpn_context
5474: UPDATE wms_license_plate_numbers
5475: SET lpn_context = wms_globals.lpn_context_picked,
5476: last_update_date = Sysdate,
5477: last_updated_by = fnd_global.user_id
5478: WHERE organization_id = p_organization_id
5479: AND outermost_lpn_id = p_outermost_lpn_id;