Active Invoice in Oracle Fusion with inactive Code combinations

Summary:3-37815901131 : Reports for Inactive GL Code Combinations

Problem Summary: Assistance Needed with Invoice Approval Status

I am seeking assistance in identifying specific invoices within our system. The requirements are as follows:

1. Identify Active Invoices: I need a list of invoices that are currently active but have not yet been approved.
2. Check Code Combination Status: Among these invoices, I want to know which ones were created before their corresponding code combinations became inactive.

We are currently facing challenges in retrieving this information. If you have any SQL scripts or queries that can help facilitate this process, that would be extremely beneficial.