Why does the rising number not match the batch number?

[vishalduttauk]

Hi there,

I am trying to get a rolling number whenever proposals get activated. I am able to execute the following SQL script which gets me a figure for proposals activated today using this:

select * from cr_managementinformation where activation_date >= '06-JUNE-23'
order by proposal_status 

When I change the input type to Batch then i use this:

SELECT * FROM cr_managementinformation
WHERE PROPOSAL_NUMBER > ?
AND activation_date = TO_DATE(current_date)
ORDER BY PROPOSAL_NUMBER ASC

The rising number does not match the batch number. i.e. the batch number of activations today is 302 but the rising number is only 5.

Can you help?