AP Expense Report Template Listing- Not Supported: Reserved For Future Use

Description
Categories: BI Publisher
Imported from BI Publisher
Description: Expense Report Template Listing
Application: Payables
Source: Expense Report Template Listing (XML) - Not Supported: Reserved For Future Use
Short Name: APXXPXPL_XML
DB package: AP_APXXPXPL_XMLP_PKG
Run AP Expense Report Template Listing- Not Supported: Reserved For Future Use and other Oracle EBS reports with Blitz Report™ on our demo environment
SELECT  report_type C_REPORT_NAME,
                description C_DESCRIPTION,
                inactive_date C_INACTIVE_DATE,
		expense_report_id C_REPORT_ID
FROM  	ap_expense_reports
	WHERE   (decode(upper(:p_active_type),
		'ACTIVE',nvl(inactive_date,
			 :p_effective_date+1)
					-:p_effective_date,
		'INACTIVE',:p_effective_date
			  -nvl(inactive_date,:p_effective_date+1),
		'BOTH',1, null,1) > 0 )
	ORDER BY UPPER(report_type)
Parameter Name SQL text Validation
Operating Unit
 
LOV
Include Active/Inactive
 
LOV Oracle
Effective Date
 
Date
Blitz Report™