VIEW: APPS.AP_SLA_PAYMENTS_TRANSACTION_V

Source

View Text - Preformatted

SELECT  /*+ push_pred(CBB) */ 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 bug 14636989
       ,decode(ac.paycard_reference_id, null,CE_BANK_AND_ACCOUNT_UTIL.get_masked_bank_acct_num(cba.bank_account_id),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(+)

View Text - HTML Formatted

SELECT /*+ PUSH_PRED(CBB) */ 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 BUG 14636989
, DECODE(AC.PAYCARD_REFERENCE_ID
, NULL
, CE_BANK_AND_ACCOUNT_UTIL.GET_MASKED_BANK_ACCT_NUM(CBA.BANK_ACCOUNT_ID)
, 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(+)