AP Recurring Invoices Report- Not Supported: Reserved For Future Use
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
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 |