DBA Data[Home] [Help]

APPS.INV_LABEL_PVT7 dependencies on WMS_LICENSE_PLATE_NUMBERS

Line 188: select lpn_id from wms_license_plate_numbers

184: AND wda.delivery_id IS NOT NULL
185: AND wdd.lpn_id IS NOT NULL
186: AND wdd.released_status = 'X' -- For LPN reuse ER : 6845650
187: AND exists(
188: select lpn_id from wms_license_plate_numbers
189: where lpn_id = wdd.lpn_id
190: and outermost_lpn_id = p_lpn_id)
191: AND rownum<2;
192: