462: SELECT expiration_date
463: , NVL(status_code, '')
464: INTO x_expiration_date
465: , x_lot_status
466: FROM mtl_lot_numbers_all_v
467: WHERE organization_id = p_organization_id
468: AND inventory_item_id = p_inventory_item_id
469: AND lot_number = p_lot_number
470: AND ROWNUM < 2
514: BEGIN
515: IF l_global_profile = 'Y' THEN
516: SELECT expiration_date
517: INTO x_expiration_date
518: FROM mtl_lot_numbers_all_v
519: WHERE organization_id <> p_organization_id
520: AND inventory_item_id = p_inventory_item_id
521: AND lot_number = p_lot_number
522: AND ROWNUM = 1;