AP Supplier Open Balance Letter- Not Supported: Reserved For Future Use

            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