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: MSC.MSC_ST_COMPANY_USERS#

Source

View Text - Preformatted


select USER_NAME USER_NAME, SR_COMPANY_ID SR_COMPANY_ID, SR_INSTANCE_ID SR_INSTANCE_ID, PARTNER_TYPE PARTNER_TYPE, START_DATE START_DATE, END_DATE END_DATE, DESCRIPTION DESCRIPTION, EMAIL_ADDRESS EMAIL_ADDRESS, FAX FAX, COMPANY_NAME COMPANY_NAME, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, LAST_UPDATE_DATE LAST_UPDATE_DATE, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, SR_INSTANCE_CODE SR_INSTANCE_CODE, MESSAGE_ID MESSAGE_ID, PROCESS_FLAG PROCESS_FLAG, ERROR_TEXT ERROR_TEXT, DATA_SOURCE_TYPE DATA_SOURCE_TYPE, ST_TRANSACTION_ID ST_TRANSACTION_ID, BATCH_ID BATCH_ID, REFRESH_ID REFRESH_ID, REQUEST_ID REQUEST_ID, LAST_UPDATED_BY LAST_UPDATED_BY, COLLECTION_PARAMETER COLLECTION_PARAMETER, USER_GUID USER_GUID from "MSC"."MSC_ST_COMPANY_USERS"

View Text - HTML Formatted

SELECT USER_NAME USER_NAME
, SR_COMPANY_ID SR_COMPANY_ID
, SR_INSTANCE_ID SR_INSTANCE_ID
, PARTNER_TYPE PARTNER_TYPE
, START_DATE START_DATE
, END_DATE END_DATE
, DESCRIPTION DESCRIPTION
, EMAIL_ADDRESS EMAIL_ADDRESS
, FAX FAX
, COMPANY_NAME COMPANY_NAME
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, SR_INSTANCE_CODE SR_INSTANCE_CODE
, MESSAGE_ID MESSAGE_ID
, PROCESS_FLAG PROCESS_FLAG
, ERROR_TEXT ERROR_TEXT
, DATA_SOURCE_TYPE DATA_SOURCE_TYPE
, ST_TRANSACTION_ID ST_TRANSACTION_ID
, BATCH_ID BATCH_ID
, REFRESH_ID REFRESH_ID
, REQUEST_ID REQUEST_ID
, LAST_UPDATED_BY LAST_UPDATED_BY
, COLLECTION_PARAMETER COLLECTION_PARAMETER
, USER_GUID USER_GUID
FROM "MSC"."MSC_ST_COMPANY_USERS"