[Home] [Help]
600: where milk.inventory_location_id (+) = lpn.locator_id
601: and milk.organization_id (+) = lpn.organization_id
602: and milk.organization_id = p_organization_id
603: and milk.subinventory_code = p_sub_code
604: and (lpn.lpn_context = wms_globals.lpn_context_inv OR lpn.lpn_context = wms_globals.lpn_context_picked)
605: and milk.concatenated_segments like (p_staging_lane);
606: end if;
607: END GET_STAGING_LANE;
608:
1113: and wdd2.delivery_detail_id = wda.parent_delivery_detail_id
1114: and wdd2.lpn_id is not null -- for performance, bug 2418639
1115: and wdd2.lpn_id = lpn.lpn_id
1116: and lpn.outermost_lpn_id = wlpn.lpn_id
1117: --MR-MDC wlpn.lpn_context <> wms_globals.lpn_loaded_for_shipment
1118: and ( wlpn.lpn_context = wms_container_pvt.lpn_context_picked
1119: OR wlpn.lpn_context = wms_container_pvt.lpn_loaded_in_stage)
1120: -- 5582189 dherring additional criteria added to ensure ship confirmed deliveries
1121: -- do not appear in the lov
3034: and wdl.pick_up_stop_id = pickup_stop.stop_id
3035: and pickup_stop.trip_id = p_trip_id
3036: and lpn.lpn_id = wdd2.lpn_id
3037: and lpn.outermost_lpn_id = wlpn.lpn_id
3038: and wlpn.lpn_context <> wms_globals.lpn_loaded_for_shipment
3039: and lpn.locator_id = milk.inventory_location_id
3040: and lpn.organization_id = milk.organization_id
3041: and wlpn.license_plate_number like (p_lpn)
3042: order by wlpn.license_plate_number;
3069: and wstt.dock_appoint_flag = 'N' )
3070: and wda.delivery_id = wnd.delivery_id
3071: and lpn.lpn_id = wdd2.lpn_id
3072: and lpn.outermost_lpn_id = wlpn.lpn_id
3073: and wlpn.lpn_context <> wms_globals.lpn_loaded_for_shipment
3074: and lpn.locator_id = milk.inventory_location_id
3075: and lpn.organization_id = milk.organization_id
3076: and wlpn.license_plate_number like (p_lpn)
3077: order by wlpn.license_plate_number;
5563: mtl_item_locations_kfv milk
5564: WHERE wlpn.organization_id = wstt.organization_id
5565: AND wlpn.organization_id = p_organization_id
5566: AND wlpn.lpn_id = wstt.outermost_lpn_id
5567: and wlpn.lpn_context = wms_globals.lpn_loaded_for_shipment
5568: AND wstt.dock_door_id = p_dock_door_id
5569: AND nvl(wstt.direct_ship_flag,'N') = 'N'
5570: AND milk.organization_id = wlpn.organization_id
5571: AND milk.inventory_location_id = wlpn.locator_id
5646: END IF;
5647:
5648: --update lpn_context
5649: UPDATE wms_license_plate_numbers
5650: SET lpn_context = wms_globals.lpn_context_picked,
5651: last_update_date = Sysdate,
5652: last_updated_by = fnd_global.user_id
5653: WHERE organization_id = p_organization_id
5654: AND outermost_lpn_id = p_outermost_lpn_id;