SELECT
PSV.VENDOR_NAME VENDOR_NAME
, PSV.SEGMENT1 VENDOR_NUMBER
, PSSV.PARTY_SITE_NAME PARTY_SITE_NAME
, PSSV.COUNTRY COUNTRY
, ACA.PAYMENT_METHOD_CODE PAYMENT_METHOD_CODE
, FLV.MEANING PAYMENT_METHOD_DESC
, ACA.CHECK_ID CHECK_ID
, ACA.AMOUNT CHECK_AMOUNT
, ACA.CHECK_NUMBER CHECK_NUMBER
, TO_CHAR(ACA.CHECK_DATE , 'DD-Mon-RRRR') CHECK_DATE
, ACA.DOC_SEQUENCE_VALUE CHECK_VOUCHER_NUM
, ACA.CHECK_NUMBER CHECK_DOCUMENT_SEQ
, ACA.LEGAL_ENTITY_ID LEGAL_ENTITY_ID
, XLP.NAME LEGAL_ENTITY_NAME
, CBA.BANK_ACCOUNT_NAME BANK_ACCOUNT_NAME
, CBA.BANK_ACCOUNT_NUM BANK_ACCOUNT_NUM
, FABV.BU_NAME BU_NAME
, ACA.CHECKRUN_NAME CHECKRUN_NAME
, GL.CURRENCY_CODE PRIMARY_LEDGER_CURRENCY
FROM AP_CHECKS_ALL ACA
, POZ_SUPPLIERS_V PSV
, POZ_SUPPLIER_SITES_V PSSV
, FND_LOOKUP_VALUES FLV
, XLE_ENTITY_PROFILES XLP
, FUN_ALL_BUSINESS_UNITS_V FABV
, GL_LEDGERS GL
, FND_DOCUMENT_SEQUENCES FDS
, CE_BANK_ACCOUNTS CBA
, CE_BANK_ACCT_USES_ALL CBAUA
WHERE ACA.VENDOR_ID = PSV.VENDOR_ID
AND PSSV.VENDOR_ID = PSV.VENDOR_ID
AND PSSV.VENDOR_SITE_ID = ACA.VENDOR_SITE_ID
AND FLV.LOOKUP_CODE = ACA.PAYMENT_METHOD_CODE
AND FLV.LOOKUP_TYPE = 'PAYMENT METHOD'
AND FLV.LANGUAGE = 'US'
AND XLP.LEGAL_ENTITY_ID = ACA.LEGAL_ENTITY_ID
AND ACA.ORG_ID = FABV.BU_ID
AND FABV.PRIMARY_LEDGER_ID = GL.LEDGER_ID
AND ACA.DOC_SEQUENCE_ID = FDS.DOC_SEQUENCE_ID
AND CBA.BANK_ACCOUNT_ID = CBAUA.BANK_ACCOUNT_ID
AND ACA.CE_BANK_ACCT_USE_ID = CBAUA.BANK_ACCT_USE_ID
AND ACA.STATUS_LOOKUP_CODE <> 'VOIDED'
ORDER BY ACA.CHECK_ID