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

➜ Back to Library
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
Download
Related Blitz Reports
GL Account Analysis (Distributions) GL Account Analysis (Distributions) 11g CAC Inventory Organization Summary PN Generate Portfolio Summary PN Generate Portfolio Detail JL Argentine Payables CITI Flat File - Legal - draft JA Cash Flow Statement Program - Cash Flow Detail PA Supplier Cost Audit AP Open Balances Revaluation (1)
Blitz Report™

Blitz Report™ provides multiple benefits: