1737: END IF;
1738:
1739: SELECT mln.*
1740: INTO p_lot
1741: FROM MTL_LOT_NUMBERS MLN
1742: WHERE MLN.INVENTORY_ITEM_ID = p_item.inventory_item_id
1743: AND MLN.ORGANIZATION_ID = p_org.organization_id
1744: AND MLN.LOT_NUMBER = p_lot.lot_number
1745: AND MLN.LOT_NUMBER IN (SELECT LOT_NUMBER
3018:
3019:
3020: SELECT mln.*
3021: INTO p_lot
3022: FROM MTL_LOT_NUMBERS MLN
3023: WHERE MLN.INVENTORY_ITEM_ID = p_item.inventory_item_id
3024: AND MLN.ORGANIZATION_ID = p_org.organization_id
3025: AND MLN.LOT_NUMBER = p_lot.lot_number;
3026: