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
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 |