FA Asset Maintenance Report- Not Supported: Reserved For Future Use
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
Imported from BI Publisher
Asset Maintenance Report
Asset Maintenance Report
SQL 17 lines
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 |
Parameters 9
| Parameter | Type | List of values SQL |
|---|---|---|
| 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 |