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

➜ Back to Library
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

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

            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
Download
 
Related Blitz Reports
AP Payment Register- Not Supported: Reserved For Future Use AP Payment Exceptions Report- Not Supported: Reserved For Future Use AP Invoice Payments AP Supplier Upload AP Bills Payable Maturity Date GL Account Analysis (Distributions) CE Cleared Transactions CE Cash in Transit EC: CE Cash in Transit
Blitz Report™

Blitz Report™ provides multiple benefits: