SQL Query to check if AP invoices is Accounted or not.

Validated but not posted.

SELECT INVOICE_NUM
FROM AP_INVOICES_ALL
WHERE AP_INVOICES_PKG.GET_APPROVAL_STATUS
 (INVOICE_ID,
 INVOICE_AMOUNT,
 PAYMENT_STATUS_FLAG,
 INVOICE_TYPE_LOOKUP_CODE
 ) ='APPROVED'
 AND AP_INVOICES_PKG.GET_POSTING_STATUS(INVOICE_ID)='N'

Validated and posted. 

SELECT INVOICE_NUM
FROM AP_INVOICES_ALL
WHERE AP_INVOICES_PKG.GET_APPROVAL_STATUS
 (INVOICE_ID,
 INVOICE_AMOUNT,
 PAYMENT_STATUS_FLAG,
 INVOICE_TYPE_LOOKUP_CODE
 ) ='APPROVED'
 AND AP_INVOICES_PKG.GET_POSTING_STATUS(INVOICE_ID)='P'

There are 4 different types as below

'S' - Selected
'P' - Partial
'N' - Unposted
'Y' - Posted