7278: CURSOR lot_csr (p_item_id IN NUMBER, p_organization_id IN NUMBER,
7279: p_lot_number IN VARCHAR2)
7280: IS
7281: SELECT lot_number
7282: FROM MTL_LOT_NUMBERS
7283: WHERE inventory_item_id = p_item_id
7284: AND organization_id = p_organization_id
7285: AND lot_number = p_lot_number ;
7286: --