FA Asset Maintenance Report- Not Supported: Reserved For Future Use

Description

Categories
BI Publisher
Application
Assets
Source
Asset Maintenance Report (XML) - Not Supported: Reserved For Future Use
Short Name
FASMAINT_XML
DB package
FA_FASMAINT_XMLP_PKG
Imported from BI Publisher
Asset Maintenance Report

SQL 17 lines

SELECT    ASSET_NUMBER ||  ' - ' || DESCRIPTION    ASSET_DESC,
 	EVENT_NAME,
	MAINTENANCE_DATE,
                  CATEGORY_FF,
   	LOCATION_FF,
	SERIAL_NUMBER,
	TAG_NUMBER,       
	MAINTENANCE_COST,
	VENDOR_NAME,
	VENDOR_NUMBER,
	CONTACT_NAME,
	CONTACT_NUMBER,
	WARRANTY_NUMBER || ' - ' || WARRANTY_DESC   WARRANTY_NUMBER
FROM          FA_MAINT_REP_ITF
WHERE	    REQUEST_ID = :C_REQUEST_ID
ORDER BY  ASSET_NUMBER, MAINTENANCE_DATE

Parameters 9

ParameterTypeList of values SQL
BookLOV Oracle
Event NameChar
Maintenance Date FromDate
Maintenance Date ToDate
Asset Number FromChar
Asset Number ToChar
Date Placed In Service FromDate
Date Placed In Service ToDate
CategoryChar