DBA Data[Home] [Help]

APPS.INV_UI_ITEM_SUB_LOC_LOVS dependencies on MTL_SERIAL_NUMBERS

Line 3144: FROM mtl_serial_numbers

3140: , lot_number
3141: , inventory_item_id
3142: , current_subinventory_code
3143: , current_locator_id
3144: FROM mtl_serial_numbers
3145: WHERE current_organization_id = p_orgid
3146: AND lpn_id IN (SELECT lpn_id
3147: FROM wms_license_plate_numbers
3148: WHERE outermost_lpn_id = p_lpn_id);