APPRVL Main select

Hello,

Did you have any functional documentation about Payables Batch Invoices Validation process (APPRVL) to explain

which criteria are used to select the invoices .

Main Select for APPRVL

SELECT  /*+ dynamic_sampling(2) cardinality(ai,10) */

invoice_id

from AP_INVOICES AI  

WHERE

                AI.VALIDATION_REQUEST_ID IS NULL

            AND AI.APPROVAL_READY_FLAG <> 'S'

        AND AI.CANCELLED_DATE IS NULL /* Bug 9777752 */

            AND NOT ( NVL(AI.PAYMENT_STATUS_FLAG,'N') = 'Y' AND

                      NVL(AI.HISTORICAL_FLAG,'N') = 'Y' )

            AND EXISTS (

                         SELECT /*+ PUSH_SUBQ */ 1

                           FROM DUAL

                          WHERE UPPER(NVL(AI.SOURCE, 'X')) <> 'RECURRING INVOICE'

                         UNION ALL

                         SELECT 1

                           FROM DUAL

                          WHERE UPPER(NVL(AI.SOURCE, 'X')) = 'RECURRING INVOICE'