DBA Data[Home] [Help]

APPS.INV_TXN_VALIDATIONS dependencies on WSH_DELIVERY_DETAILS

Line 2337: From wsh_delivery_details wdd, wms_license_plate_numbers wlpn

2333:
2334: if( l_action_id = INV_GLOBALS.G_Action_Subxfr ) then
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