[Home] [Help]
View: AP_SLA_PAYMENTS_TRANSACTION_V
View Text
SELECT AC.CHECK_ID
, DECODE (AC.PAYCARD_REFERENCE_ID
, NULL
, CBB.BANK_NAME
, AC.BANK_ACCOUNT_NAME) BANK_NAME
, CBB.BANK_BRANCH_NAME
, DECODE (AC.PAYCARD_REFERENCE_ID
, NULL
, CBA.BANK_ACCOUNT_NUM
, AC.BANK_ACCOUNT_NUM) BANK_ACCOUNT_NUM
, AC.CHECK_NUMBER
, AC.AMOUNT
, AC.CURRENCY_CODE
, AC.BASE_AMOUNT
, AC.CHECK_DATE
, AC.VOID_DATE
, (SELECT HP.PARTY_NAME
FROM HZ_PARTIES HP
WHERE HP.PARTY_ID= AC.PARTY_ID ) VENDOR_NAME
, CPD.PAYMENT_DOCUMENT_NAME
, AC.FUTURE_PAY_DUE_DATE
, AC.PAYMENT_METHOD_CODE
FROM AP_CHECKS_ALL AC
, CE_BANK_ACCT_USES_ALL CBAU
, CE_BANK_ACCOUNTS CBA
, CE_BANK_BRANCHES_V CBB
, CE_PAYMENT_DOCUMENTS CPD
WHERE AC.CE_BANK_ACCT_USE_ID = CBAU.BANK_ACCT_USE_ID (+)
AND CBAU.BANK_ACCOUNT_ID = CBA.BANK_ACCOUNT_ID (+)
AND CBA.BANK_BRANCH_ID = CBB.BRANCH_PARTY_ID (+)
AND AC.PAYMENT_DOCUMENT_ID = CPD.PAYMENT_DOCUMENT_ID(+)
Columns
Name |
CHECK_ID |
BANK_NAME |
BANK_BRANCH_NAME |
BANK_ACCOUNT_NUM |
CHECK_NUMBER |
AMOUNT |
CURRENCY_CODE |
BASE_AMOUNT |
CHECK_DATE |
VOID_DATE |
VENDOR_NAME |
PAYMENT_DOCUMENT_NAME |
FUTURE_PAY_DUE_DATE |
PAYMENT_METHOD_CODE |