AP Void Payment Register- Not Supported: Reserved For Future Use

Description
Categories: BI Publisher
Imported from BI Publisher
Description: Void Payment Register
Application: Payables
Source: Void Payment Register (XML) - Not Supported: Reserved For Future Use
Short Name: APXVCHCR_XML
DB package: AP_APXVCHCR_XMLP_PKG
Run AP Void Payment Register- Not Supported: Reserved For Future Use and other Oracle EBS reports with Blitz Report™ on our demo environment
            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
Operating Unit
 
LOV
From Date
 
Date
To Date
 
Date
Include Zero Amount Payments
 
LOV Oracle
Display Payee Address
 
LOV Oracle
Date
 
LOV Oracle
Blitz Report™