AP Supplier Open Balance Letter - draft

Description
Categories: BI Publisher
Columns: As Of Date, Organization Name, Functional Currency Code, Supplier Name, Supplier Number, Vat Registration Number, Supplier Site Code, Address Line1, Address Line2, Address Line3 ...
Application: Payables
Source: Supplier Open Balance Letter (XML) - Not Supported: Reserved For Future Use
Short Name: APXSOBLX_XML
DB package: AP_APXSOBLX_XMLP_PKG
            Select                               as_of_date,
                                                     organization_name ,
                                                     functional_currency_code,
                                                     supplier_name,
                                                     supplier_number,
                                                     vat_registration_number,
                                                     supplier_site_code,
                                                     address_line1,
                                                     address_line2,
                                                     address_line3,
                                                     city,
                                                     state,
                                                     zip,
                                                     country,
                                                     invoice_type,
                                                     invoice_num invoice_number,
                                                     invoice_date ,
                                                     invoice_currency_code ,
                                                    nvl( invoice_amount,0) invoice_amount,
                                                     nvl(amount_remaining,0) invoice_amount_remaining,
                                                    nvl( payment_amount,0) payment_amount,
                                                    nvl( discount_taken,0) discount_taken,
                                                    nvl(discount_amount_available,0) discount_amount_available,
                                                   nvl(inv_prepayment_amount,0) inv_prepayment_amount,
                                                 nvl( prepay_amount_original,0) prepay_amount_original,
                                                nvl( prepay_amount_remaining,0) prepay_amount_remaining,
                                                 nvl(prepay_amount_applied,0) prepay_amount_applied,
                AP_APXSOBLX_XMLP_PKG.cf_as_of_date_displayformula() CF_as_of_date_display,
                AP_APXSOBLX_XMLP_PKG.cf_cur_totalformula(:C_inv_total, :C_prepay_total) CF_cur_total,
                AP_APXSOBLX_XMLP_PKG.cf_displayformula(AP_APXSOBLX_XMLP_PKG.cf_cur_totalformula(:C_inv_total, :C_prepay_total)) CF_display
            from ap_supplier_balance_itf
            where request_id=FND_GLOBAL.conc_request_id
           /* order by supplier_name, supplier_number, organization_name,
            vat_registration_number, supplier_site_code, address_line3,
            city, state, zip, address_line1, functional_currency_code,
            as_of_date, country, address_line2, invoice_currency_code,
            invoice_type, invoice_num, invoice_date, nvl( invoice_amount,0),
            nvl(amount_remaining,0), nvl( payment_amount,0), nvl( discount_taken,0),
            nvl(discount_amount_available,0), nvl(inv_prepayment_amount,0),
            nvl( prepay_amount_original,0), nvl( prepay_amount_remaining,0),
            nvl(prepay_amount_applied,0)*/
			ORDER BY 4 ASC,5 ASC,2 ASC,6 ASC,7 ASC,10 ASC,11 ASC,12 ASC,13 ASC,8 ASC,3 ASC,1 ASC,14 ASC,9 ASC,18 ASC
Parameter Name SQL text Validation
As of Date
 
Date
Supplier Name From
 
LOV Oracle
Supplier Name To
 
LOV Oracle
Currency
 
LOV Oracle
Include Prepayments
 
LOV Oracle
Minimum Invoice Balance
 
Number
Minimum Open Balance
 
Number
Reference Number
 
Ledger Id