AP Expense Report Template Listing - draft

Description
Categories: BI Publisher, Financials, Procurement
Application: Payables
Source: Expense Report Template Listing (XML) - Not Supported: Reserved For Future Use
Short Name: APXXPXPL_XML
DB package: AP_APXXPXPL_XMLP_PKG
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
Ledger
 
Effective Date
 
Date
Include Active/Inactive
 
LOV Oracle