AP_SLA_PAYMENTS_TRANSACTION_V

Details

• Schema: FUSION

• Object owner: AP

• Object type: VIEW

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

Query

SQL_Statement

SELECT AC.check_id, CBB.bank_name, CBB.bank_branch_name, CASE WHEN CBA.bank_account_id is not null THEN CE_BANK_AND_ACCOUNT_UTIL.GET_MASKED_BANK_ACCT_NUM(CBA.bank_account_id) ELSE null END as bank_account_num,/*36101011* 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, /*Commented for 11698476 */ /* AC.payment_method_code */ /* Added for 11698476 */ IBY.payment_method_name payment_method_code /* Retained old column name to match with XLA_EVENT_MAPPINGS_VL Ideally, we should change XLA_EVENT_MAPPINGS_VL too */ FROM AP_CHECKS_ALL AC /* Added for 11698476 */ INNER JOIN IBY_PAYMENT_METHODS_VL IBY ON AC.payment_method_code = IBY.payment_method_code LEFT OUTER JOIN CE_BANK_ACCT_USES_ALL CBAU ON AC.ce_bank_acct_use_id = CBAU.bank_acct_use_id LEFT OUTER JOIN CE_BANK_ACCOUNTS CBA ON CBAU.bank_account_id = CBA.bank_account_id LEFT OUTER JOIN CE_ALL_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