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

➜ Back to Library
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
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 NameSQL textValidation
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
Download
Related Blitz Reports
FA Japanese Detail by Asset Type (Addition/All Assets) Report 180 Characters FA Mass Revaluation Preview - draft FA Japanese Depreciable Assets Tax Summary JG Statutory Asset Cost/Reserve Detail Report- Not Supported: Reserved For Future Use JG Statutory Asset Ledger Report- Not Supported: Reserved For Future Use FA Depreciation Summary Tax Register (Russia) FA Japanese Detail by Asset Type (Addition/All Assets) Report 132 Characters APL: AR Transaction Register AR Transaction Register
Blitz Report™