eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: CSD.CSD_RO_SAVEDSEARCHES#

Source

View Text - Preformatted


select CREATION_DATE CREATION_DATE, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, USER_ID USER_ID, SEARCHNAME SEARCHNAME, DEFAULTFLAG DEFAULTFLAG, REPAIR_NUMBER REPAIR_NUMBER, REPAIR_TYPE_ID REPAIR_TYPE_ID, INSTALL_SITE_USE_ID INSTALL_SITE_USE_ID, INCIDENT_NUMBER INCIDENT_NUMBER, INCIDENT_ID INCIDENT_ID, REFERENCE_NUMBER REFERENCE_NUMBER, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, ITEM ITEM, SERIAL_NUMBER SERIAL_NUMBER, RMA_NUMBER RMA_NUMBER, SALES_ORDER_NUMBER SALES_ORDER_NUMBER, DATE_CREATED DATE_CREATED, PROMISE_DATE PROMISE_DATE, DATE_CLOSED DATE_CLOSED, STATUS STATUS, ACCOUNT_NUMBER ACCOUNT_NUMBER, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, SECURITY_GROUP_ID SECURITY_GROUP_ID, CREATED_BY CREATED_BY, PARTY_ID PARTY_ID from "CSD"."CSD_RO_SAVEDSEARCHES"

View Text - HTML Formatted

SELECT CREATION_DATE CREATION_DATE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, USER_ID USER_ID
, SEARCHNAME SEARCHNAME
, DEFAULTFLAG DEFAULTFLAG
, REPAIR_NUMBER REPAIR_NUMBER
, REPAIR_TYPE_ID REPAIR_TYPE_ID
, INSTALL_SITE_USE_ID INSTALL_SITE_USE_ID
, INCIDENT_NUMBER INCIDENT_NUMBER
, INCIDENT_ID INCIDENT_ID
, REFERENCE_NUMBER REFERENCE_NUMBER
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, ITEM ITEM
, SERIAL_NUMBER SERIAL_NUMBER
, RMA_NUMBER RMA_NUMBER
, SALES_ORDER_NUMBER SALES_ORDER_NUMBER
, DATE_CREATED DATE_CREATED
, PROMISE_DATE PROMISE_DATE
, DATE_CLOSED DATE_CLOSED
, STATUS STATUS
, ACCOUNT_NUMBER ACCOUNT_NUMBER
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, CREATED_BY CREATED_BY
, PARTY_ID PARTY_ID
FROM "CSD"."CSD_RO_SAVEDSEARCHES"