DBA Data[Home] [Help]

APPS.INV_UI_ITEM_SUB_LOC_LOVS dependencies on MTL_SERIAL_NUMBERS

Line 3539: FROM mtl_serial_numbers

3535: , lot_number
3536: , inventory_item_id
3537: , current_subinventory_code
3538: , current_locator_id
3539: FROM mtl_serial_numbers
3540: WHERE current_organization_id = p_orgid
3541: AND lpn_id IN (SELECT lpn_id
3542: FROM wms_license_plate_numbers
3543: WHERE outermost_lpn_id = p_lpn_id);