AP Void Payment Register - draft

Description
Categories: BI Publisher, Financials, Procurement
Application: Payables
Source: Void Payment Register (XML) - Not Supported: Reserved For Future Use
Short Name: APXVCHCR_XML
DB package: AP_APXVCHCR_XMLP_PKG
            SELECT  nvl(cpd.payment_document_name, :c_nls_none_ep) C_CHECK_STOCK_NAME,
                chk.check_stock_id C_CHECK_STOCK_ID,
                chk.check_number   C_CHECK_NUMBER,
                chk.check_date     C_CHECK_DATE,
                chk.amount         C_AMOUNT,
                chk.vendor_name C_VENDOR_NAME,
                chk.vendor_site_code C_VENDOR_SITE_CODE,
                chk.address_line1 C_ADDRESS_LINE1,
                chk.address_line2 C_ADDRESS_LINE2,
                chk.address_line3 C_ADDRESS_LINE3,
                chk.city C_CITY,
                chk.state C_STATE,
                chk.zip C_ZIP,
                ft.territory_short_name C_COUNTRY,
                chk.void_date      C_VOID_DATE,
                bb.bank_name       C_BANK,
                upper(bb.bank_name) C_UPP_BANK,
                bb.bank_branch_name C_BRANCH,
                upper(bb.bank_branch_name)  C_UPP_BANK_BRANCH,
                chk.bank_account_name   C_ACCOUNT,
                UPPER(chk.bank_account_name) C_UPP_ACCOUNT,
                chk.ce_bank_acct_use_id      C_ACCOUNTID,
                bb.branch_party_id        C_BANK_BRANCH,
                ba.currency_code         C_BANK_CURR_CODE,
                UPPER(ba.currency_code)  C_UPP_BANK_CURR_CODE,
                chk.currency_code        C_PAY_CURR_CODE,
                UPPER(chk.currency_code) C_UPP_PAY_CURR_CODE,
                AP_APXVCHCR_XMLP_PKG.c_bank_curr_nameformula(ba.currency_code) C_BANK_CURR_NAME,
                AP_APXVCHCR_XMLP_PKG.c_pay_curr_nameformula(chk.currency_code) C_PAY_CURR_NAME
            FROM    ap_checks chk  ,
                    ce_payment_documents cpd  ,
                    ce_bank_accounts ba  ,
                    ce_bank_acct_uses_all cbau,
                    ce_bank_branches_v bb  ,
                    fnd_territories_vl ft
            &P_WHERE1
            order by bb.bank_name, bb.branch_party_id, upper(bb.bank_branch_name),
            chk.ce_bank_acct_use_id, UPPER(chk.bank_account_name), UPPER(chk.currency_code),
            chk.currency_code, chk.check_stock_id, nvl(cpd.payment_document_name, :c_nls_none_ep),
            chk.check_number, chk.check_date, chk.vendor_name, chk.vendor_site_code,
            chk.address_line1, chk.bank_account_name, chk.void_date, chk.address_line2,
            chk.address_line3, chk.city, chk.state, chk.zip, ft.territory_short_name
Parameter Name SQL text Validation
Ledger
 
Date
 
LOV Oracle
Display Payee Address
 
LOV Oracle
Include Zero Amount Payments
 
LOV Oracle
To Date
 
Date
From Date
 
Date