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

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

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

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
Parameter Name SQL text Validation
Book
 
LOV Oracle
Event Name
 
Char
Maintenance Date From
 
Date
Maintenance Date To
 
Date
Asset Number From
 
Char
Asset Number To
 
Char
Date Placed In Service From
 
Date
Date Placed In Service To
 
Date
Category
 
Char