4011: SELECT wlpn.lpn_context , wlpn.subinventory_code , wlpn.locator_id
4012: INTO l_lpn_context , l_subinventory_code , l_locator_id
4013: FROM wms_license_plate_numbers wlpn
4014: WHERE wlpn.lpn_id = p_lpn_id;
4015: IF l_lpn_context IN (WMS_Container_PUB.LPN_CONTEXT_PREGENERATED,
4016: WMS_Container_PUB.LPN_CONTEXT_VENDOR,
4017: WMS_Container_PUB.LPN_CONTEXT_STORES,
4018: WMS_Container_PUB.LPN_CONTEXT_INTRANSIT ,
4019: WMS_Container_PUB.LPN_CONTEXT_PACKING,
4012: INTO l_lpn_context , l_subinventory_code , l_locator_id
4013: FROM wms_license_plate_numbers wlpn
4014: WHERE wlpn.lpn_id = p_lpn_id;
4015: IF l_lpn_context IN (WMS_Container_PUB.LPN_CONTEXT_PREGENERATED,
4016: WMS_Container_PUB.LPN_CONTEXT_VENDOR,
4017: WMS_Container_PUB.LPN_CONTEXT_STORES,
4018: WMS_Container_PUB.LPN_CONTEXT_INTRANSIT ,
4019: WMS_Container_PUB.LPN_CONTEXT_PACKING,
4020: WMS_Container_PUB.LPN_CONTEXT_WIP,
4013: FROM wms_license_plate_numbers wlpn
4014: WHERE wlpn.lpn_id = p_lpn_id;
4015: IF l_lpn_context IN (WMS_Container_PUB.LPN_CONTEXT_PREGENERATED,
4016: WMS_Container_PUB.LPN_CONTEXT_VENDOR,
4017: WMS_Container_PUB.LPN_CONTEXT_STORES,
4018: WMS_Container_PUB.LPN_CONTEXT_INTRANSIT ,
4019: WMS_Container_PUB.LPN_CONTEXT_PACKING,
4020: WMS_Container_PUB.LPN_CONTEXT_WIP,
4021: WMS_Container_PUB.LPN_CONTEXT_RCV
4014: WHERE wlpn.lpn_id = p_lpn_id;
4015: IF l_lpn_context IN (WMS_Container_PUB.LPN_CONTEXT_PREGENERATED,
4016: WMS_Container_PUB.LPN_CONTEXT_VENDOR,
4017: WMS_Container_PUB.LPN_CONTEXT_STORES,
4018: WMS_Container_PUB.LPN_CONTEXT_INTRANSIT ,
4019: WMS_Container_PUB.LPN_CONTEXT_PACKING,
4020: WMS_Container_PUB.LPN_CONTEXT_WIP,
4021: WMS_Container_PUB.LPN_CONTEXT_RCV
4022: )
4015: IF l_lpn_context IN (WMS_Container_PUB.LPN_CONTEXT_PREGENERATED,
4016: WMS_Container_PUB.LPN_CONTEXT_VENDOR,
4017: WMS_Container_PUB.LPN_CONTEXT_STORES,
4018: WMS_Container_PUB.LPN_CONTEXT_INTRANSIT ,
4019: WMS_Container_PUB.LPN_CONTEXT_PACKING,
4020: WMS_Container_PUB.LPN_CONTEXT_WIP,
4021: WMS_Container_PUB.LPN_CONTEXT_RCV
4022: )
4023: OR (p_transaction_id is NULL)
4016: WMS_Container_PUB.LPN_CONTEXT_VENDOR,
4017: WMS_Container_PUB.LPN_CONTEXT_STORES,
4018: WMS_Container_PUB.LPN_CONTEXT_INTRANSIT ,
4019: WMS_Container_PUB.LPN_CONTEXT_PACKING,
4020: WMS_Container_PUB.LPN_CONTEXT_WIP,
4021: WMS_Container_PUB.LPN_CONTEXT_RCV
4022: )
4023: OR (p_transaction_id is NULL)
4024: OR (p_business_flow in (1,2,3,4))THEN
4017: WMS_Container_PUB.LPN_CONTEXT_STORES,
4018: WMS_Container_PUB.LPN_CONTEXT_INTRANSIT ,
4019: WMS_Container_PUB.LPN_CONTEXT_PACKING,
4020: WMS_Container_PUB.LPN_CONTEXT_WIP,
4021: WMS_Container_PUB.LPN_CONTEXT_RCV
4022: )
4023: OR (p_transaction_id is NULL)
4024: OR (p_business_flow in (1,2,3,4))THEN
4025: -- no need to check src status for these transaction so calling get_lpn_status