AP Supplier Open Balance Letter - draft

Description
Categories: BI Publisher, Financials, Procurement
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 NameSQL textValidation
Ledger Id
 
Reference Number
 
Minimum Open Balance
 
Number
Minimum Invoice Balance
 
Number
Include Prepayments
 
LOV Oracle
Currency
 
LOV Oracle
Supplier Name To
 
LOV Oracle
Supplier Name From
 
LOV Oracle
As of Date
 
Date