Is there a sql query someone can provide to determine eligibility criteria for generate asset lines?

Summary: Is there a sql query someone can provide to determine eligibility criteria for generate asset lines? Whenever something doesn't generate I spend hours and hours trying to figure out why. It would great if someone can provide the sql that generate asset lines uses to determine which expenditures are eligible.

Content (required):n/a

Version (include the version you are using, if applicable):23C

Code Snippet (add any code snippets that support your topic, if applicable):n/a