AP Recurring Invoices Report- Not Supported: Reserved For Future Use

➜ Back to Library
Description
Categories: BI Publisher
Imported from BI Publisher
Description: Recurring Invoices Report
Application: Payables
Source: Recurring Invoices Report (XML) - Not Supported: Reserved For Future Use
Short Name: APXRPRPR_XML
DB package: AP_APXRPRPR_XMLP_PKG
Run AP Recurring Invoices Report- Not Supported: Reserved For Future Use and other Oracle EBS reports with Blitz Report™ on our demo environment
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 Name SQL text Validation
Operating Unit 
 
 LOV
From Entered Date 
 
 Date
To Entered Date 
 
 Date
Open Items Only 
 
 LOV Oracle
Order By 
 
 LOV Oracle
Download
Related Blitz Reports
AP Withholding Tax by Invoice AP Invoices and Lines AP Invoice on Hold AP Discounts Taken and Lost Report- Not Supported: Reserved For Future Use AP Withholding Tax by Tax Authority - draft AP Withholding Tax by Payment Report- Not Supported: Reserved For Future Use AP Withholding Tax by Supplier - draft AP Unaccounted Transactions Report- Delete - Not Supported: Reserved For Future Use AP Period Close Exceptions Report- Delete - Not Supported: Reserved For Future Use
Blitz Report™

Blitz Report™ provides multiple benefits: