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.

[Home] [Help]

VIEW: POS.POS_OSN_REQUESTS#

Source

View Text - Preformatted


select INTERNAL_ID INTERNAL_ID, REQUEST_ID REQUEST_ID, ISP_REGISTRATION_ID ISP_REGISTRATION_ID, REQUEST_TYPE REQUEST_TYPE, REQUEST_STATUS REQUEST_STATUS, OSN_EHUB_ID OSN_EHUB_ID, OSN_TPNAME OSN_TPNAME, OSN_USERNAME OSN_USERNAME, OSN_USER_FIRSTNAME OSN_USER_FIRSTNAME, OSN_USER_MIDDLENAME OSN_USER_MIDDLENAME, OSN_USER_LASTNAME OSN_USER_LASTNAME, OSN_EMAIL OSN_EMAIL, OSN_USER_PHONE OSN_USER_PHONE, ISP_USERNAME ISP_USERNAME, ISP_PASSWORD ISP_PASSWORD, XML_MSG XML_MSG, RECEIVED_DATE RECEIVED_DATE, LAST_UPDATED_DATE LAST_UPDATED_DATE from "POS"."POS_OSN_REQUESTS"

View Text - HTML Formatted

SELECT INTERNAL_ID INTERNAL_ID
, REQUEST_ID REQUEST_ID
, ISP_REGISTRATION_ID ISP_REGISTRATION_ID
, REQUEST_TYPE REQUEST_TYPE
, REQUEST_STATUS REQUEST_STATUS
, OSN_EHUB_ID OSN_EHUB_ID
, OSN_TPNAME OSN_TPNAME
, OSN_USERNAME OSN_USERNAME
, OSN_USER_FIRSTNAME OSN_USER_FIRSTNAME
, OSN_USER_MIDDLENAME OSN_USER_MIDDLENAME
, OSN_USER_LASTNAME OSN_USER_LASTNAME
, OSN_EMAIL OSN_EMAIL
, OSN_USER_PHONE OSN_USER_PHONE
, ISP_USERNAME ISP_USERNAME
, ISP_PASSWORD ISP_PASSWORD
, XML_MSG XML_MSG
, RECEIVED_DATE RECEIVED_DATE
, LAST_UPDATED_DATE LAST_UPDATED_DATE
FROM "POS"."POS_OSN_REQUESTS"