AP Recurring Invoices - draft

Description
Categories: BI Publisher, Financials, Procurement
Application: Payables
Source: Recurring Invoices Report (XML) - Not Supported: Reserved For Future Use
Short Name: APXRPRPR_XML
DB package: AP_APXRPRPR_XMLP_PKG
SELECT  substr(recurring_pay_num, 1, 13)                                                                                                       C_RECURRING_PAY_NUM,
	p.creation_date                        C_CREATION_DATE,
	substr(vendor_name,1,23)       C_VENDOR_NAME,
	substr(vendor_site_code, 1, 9)   C_VENDOR_SITE_CODE,
	control_amount                       C_CONTROL_AMOUNT,
	NVL(released_amount, 0)        C_RELEASED_AMOUNT, 
	NVL(num_of_periods_rem, 0)                                                                                                         C_NUM_OF_PERIODS_REM,
	substr(p.description,1,105)   C_DESCRIPTION,
	rec_pay_period_type                                                                                                                    C_REC_PAY_PERIOD_TYPE,
               upper(rec_pay_period_type) 
                                               C_UPPER_REC_PAY_PRD_TYPE,
        substr(next_period, 1, 9)              C_NEXT_PERIOD,
        NVL(next_payment, 0)                 C_NEXT_PAYMENT,
	substr(gl1.name,1,25)            C_CURRENCY,
      upper(substr(gl1.name,1,25) )           C_UPPER_CURRENCY,
	p.invoice_currency_code      C_CURRENCY_CODE,
        alc.displayed_field                     C_NLS_HOLD_LOOKUP_CODE
FROM  	
	ap_recurring_payments p,
	po_vendors v,
	po_vendor_sites s,
	FND_CURRENCIES_VL gl1,
                ap_lookup_codes alc
&P_WHERE
AND  (trunc(p.creation_date) BETWEEN :p_start_date  AND  :p_end_date )
ORDER BY  &P_ORDERBY
Parameter NameSQL textValidation
Ledger
 
Order By
 
LOV Oracle
Open Items Only
 
LOV Oracle
To Entered Date
 
Date
From Entered Date
 
Date