DBA Data[Home] [Help]

APPS.INV_TXN_VALIDATIONS dependencies on WMS_CONTAINER_PUB

Line 2339: and wlpn.lpn_context = wms_Container_pub.LPN_Context_Picked

2335: select count(wdd.delivery_detail_id)
2336: into l_count
2337: From wsh_delivery_details wdd, wms_license_plate_numbers wlpn
2338: WHere wdd.lpn_id = wlpn.lpn_id
2339: and wlpn.lpn_context = wms_Container_pub.LPN_Context_Picked
2340: and wlpn.lpn_id = p_lpn_id
2341: and wdd.released_status = 'X'; -- For LPN reuse ER : 6845650
2342:
2343: if( l_count > 0 ) then