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
Run
FA Asset Maintenance Report- Not Supported: Reserved For Future Use and other Oracle EBS reports with Blitz Report™ on our demo environment
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 |