View: AP_SLA_PAYMENTS_TRANSACTION_V

Product:	AP - Payables
Description:
Implementation/DBA Data:	APPS.AP_SLA_PAYMENTS_TRANSACTION_V

View Text

SELECT AC.CHECK_ID
, CBB.BANK_NAME
, CBB.BANK_BRANCH_NAME
, CBA.BANK_ACCOUNT_NUM
, AC.CHECK_NUMBER
, AC.AMOUNT
, AC.CURRENCY_CODE
, AC.BASE_AMOUNT
, AC.CHECK_DATE
, AC.VOID_DATE
, AC.VENDOR_NAME
, CPD.PAYMENT_DOCUMENT_NAME
, AC.FUTURE_PAY_DUE_DATE
, AC.PAYMENT_METHOD_CODE
FROM AP_CHECKS_ALL AC INNER JOIN CE_BANK_ACCT_USES_ALL CBAU ON AC.CE_BANK_ACCT_USE_ID = CBAU.BANK_ACCT_USE_ID INNER JOIN CE_BANK_ACCOUNTS CBA ON CBAU.BANK_ACCOUNT_ID = CBA.BANK_ACCOUNT_ID INNER JOIN CE_BANK_BRANCHES_V CBB ON CBA.BANK_BRANCH_ID = CBB.BRANCH_PARTY_ID LEFT OUTER JOIN CE_PAYMENT_DOCUMENTS CPD ON AC.PAYMENT_DOCUMENT_ID = CPD.PAYMENT_DOCUMENT_ID

Columns