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: WSH.WSH_CC_RESPONSE_LINES#

Source

View Text - Preformatted


select RESPONSE_LINE_ID RESPONSE_LINE_ID, RESPONSE_HEADER_ID RESPONSE_HEADER_ID, SERVICE_TYPE_CODE SERVICE_TYPE_CODE, USER_DEF_ID1 USER_DEF_ID1, USER_DEF_ID2 USER_DEF_ID2, TRANSACTION_SOURCE_TYPE TRANSACTION_SOURCE_TYPE, EMBARGO_FLAG EMBARGO_FLAG, LICENSE_REQUIRED LICENSE_REQUIRED, LICENSE_CLASSIFIER LICENSE_CLASSIFIER, LICENSE_EXCEPTION LICENSE_EXCEPTION, LICENSE_EXC_TYPE LICENSE_EXC_TYPE, EXCEPTION_TYPE_CODE EXCEPTION_TYPE_CODE, RED_FLAG_WORDS RED_FLAG_WORDS, DENIED_PARTY_FLAG DENIED_PARTY_FLAG, REASON REASON, ERROR_CODE ERROR_CODE, ERROR_TEXT ERROR_TEXT, ERROR_SOURCE ERROR_SOURCE, ERROR_TYPE ERROR_TYPE, ENTITY_CODE ENTITY_CODE, ENTITY_ID ENTITY_ID, ORIGINAL_SYSTEM_REFERENCE ORIGINAL_SYSTEM_REFERENCE, ORIGINAL_SYSTEM_LINE_REFERENCE ORIGINAL_SYSTEM_LINE_REFERENCE, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN from "WSH"."WSH_CC_RESPONSE_LINES"

View Text - HTML Formatted

SELECT RESPONSE_LINE_ID RESPONSE_LINE_ID
, RESPONSE_HEADER_ID RESPONSE_HEADER_ID
, SERVICE_TYPE_CODE SERVICE_TYPE_CODE
, USER_DEF_ID1 USER_DEF_ID1
, USER_DEF_ID2 USER_DEF_ID2
, TRANSACTION_SOURCE_TYPE TRANSACTION_SOURCE_TYPE
, EMBARGO_FLAG EMBARGO_FLAG
, LICENSE_REQUIRED LICENSE_REQUIRED
, LICENSE_CLASSIFIER LICENSE_CLASSIFIER
, LICENSE_EXCEPTION LICENSE_EXCEPTION
, LICENSE_EXC_TYPE LICENSE_EXC_TYPE
, EXCEPTION_TYPE_CODE EXCEPTION_TYPE_CODE
, RED_FLAG_WORDS RED_FLAG_WORDS
, DENIED_PARTY_FLAG DENIED_PARTY_FLAG
, REASON REASON
, ERROR_CODE ERROR_CODE
, ERROR_TEXT ERROR_TEXT
, ERROR_SOURCE ERROR_SOURCE
, ERROR_TYPE ERROR_TYPE
, ENTITY_CODE ENTITY_CODE
, ENTITY_ID ENTITY_ID
, ORIGINAL_SYSTEM_REFERENCE ORIGINAL_SYSTEM_REFERENCE
, ORIGINAL_SYSTEM_LINE_REFERENCE ORIGINAL_SYSTEM_LINE_REFERENCE
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM "WSH"."WSH_CC_RESPONSE_LINES"