Simple script to find unprocessed records from Auto Invoice

Hi Folks,

As we know there are multiple reasons to fail auto invoice import program.

Invoices:-

1. Period not in open status

2. Auto Accounting setup

3. Tax setup

4. Customer or customer address site setup

5. Transaction Type or Transaction source

etc..

Credit Memo:-

1. Overapplication of the actual Invoice amount (Either receipt got created or Credit memo amount exceeds the invoice amount)

2. Auto Accounting setup

3. Tax setup

4. Customer or customer address site setup

5. Transaction Type or Transaction source

So I want to extract Interface failed records of  multiple OU's with all possible validation with unique constraint as Date, INTERFACE_STATUS.. so please provide me script to find out such records.