Sorting Order Criteria for generating Invoice Numbers

Hi Team,

In the O2C Process, When the order lines are successfully ship confirmed and after the Workflow Background Process is completed, we have the data in ra_interface_lines_all table ready to be picked by auto invoice program. May I know the order by criteria for the auto invoice program to pick and process to generate the invoice numbers.

We have observed the criteria of picking is not by invoice date or order number or customer. Any help in this regard would be highly appreciable.

Thanks,

Swapna