FA Asset Maintenance - draft

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
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
Category Flex Structure
 
Number
Category
 
Date Placed In Service To
 
Date
Date Placed In Service From
 
Date
Asset Number To
 
Asset Number From
 
Maintenance Date To
 
Date
Maintenance Date From
 
Date
Event Name
 
Book
 
LOV Oracle