Auto Apply Documents "Doc Number"

Hi there

We are making a report in which we have to consider Applied documents.

How can we trace whether a document is applied or not through database or front end on the doc?

Regards