1862: END IF;
1863:
1864: SELECT mln.*
1865: INTO p_lot
1866: FROM MTL_LOT_NUMBERS MLN
1867: WHERE MLN.INVENTORY_ITEM_ID = p_item.inventory_item_id
1868: AND MLN.ORGANIZATION_ID = p_org.organization_id
1869: AND MLN.LOT_NUMBER = p_lot.lot_number
1870: AND MLN.LOT_NUMBER IN (SELECT LOT_NUMBER
3152:
3153:
3154: SELECT mln.*
3155: INTO p_lot
3156: FROM MTL_LOT_NUMBERS MLN
3157: WHERE MLN.INVENTORY_ITEM_ID = p_item.inventory_item_id
3158: AND MLN.ORGANIZATION_ID = p_org.organization_id
3159: AND MLN.LOT_NUMBER = p_lot.lot_number;
3160: