DBA Data[Home] [Help]

APPS.INV_TXN_VALIDATIONS dependencies on WSH_DELIVERY_DETAILS

Line 2111: From wsh_delivery_details wdd, wms_license_plate_numbers wlpn

2107:
2108: if( l_action_id = INV_GLOBALS.G_Action_Subxfr ) then
2109: select count(wdd.delivery_detail_id)
2110: into l_count
2111: From wsh_delivery_details wdd, wms_license_plate_numbers wlpn
2112: WHere wdd.lpn_id = wlpn.lpn_id
2113: and wlpn.lpn_context = wms_Container_pub.LPN_Context_Picked
2114: and wlpn.lpn_id = p_lpn_id
2115: and wdd.released_status = 'X'; -- For LPN reuse ER : 6845650