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: OKS.OKS_RULE_ERROR#

Source

View Text - Preformatted


select ROW_NUM ROW_NUM, ID ID, RGP_ID RGP_ID, CHR_ID CHR_ID, CLE_ID CLE_ID, CONTRACT_NUMBER CONTRACT_NUMBER, CONTRACT_NUMBER_MODIFIER CONTRACT_NUMBER_MODIFIER, MAJOR_VERSION MAJOR_VERSION, LINE_NUMBER LINE_NUMBER, SCRIPT_NAME SCRIPT_NAME, PROCESS PROCESS, FLAG FLAG, RULE_INFORMATION_CATEGORY RULE_INFORMATION_CATEGORY, COLUMN_NAME COLUMN_NAME, ATTRIBUTE_NAME ATTRIBUTE_NAME, ATTRIBUTE_VALUE ATTRIBUTE_VALUE, NEW_VALUE NEW_VALUE, ERROR_MSG ERROR_MSG, CC_EXPIRY_DATE CC_EXPIRY_DATE, ALLOW_UPDATE_FLAG ALLOW_UPDATE_FLAG from "OKS"."OKS_RULE_ERROR"

View Text - HTML Formatted

SELECT ROW_NUM ROW_NUM
, ID ID
, RGP_ID RGP_ID
, CHR_ID CHR_ID
, CLE_ID CLE_ID
, CONTRACT_NUMBER CONTRACT_NUMBER
, CONTRACT_NUMBER_MODIFIER CONTRACT_NUMBER_MODIFIER
, MAJOR_VERSION MAJOR_VERSION
, LINE_NUMBER LINE_NUMBER
, SCRIPT_NAME SCRIPT_NAME
, PROCESS PROCESS
, FLAG FLAG
, RULE_INFORMATION_CATEGORY RULE_INFORMATION_CATEGORY
, COLUMN_NAME COLUMN_NAME
, ATTRIBUTE_NAME ATTRIBUTE_NAME
, ATTRIBUTE_VALUE ATTRIBUTE_VALUE
, NEW_VALUE NEW_VALUE
, ERROR_MSG ERROR_MSG
, CC_EXPIRY_DATE CC_EXPIRY_DATE
, ALLOW_UPDATE_FLAG ALLOW_UPDATE_FLAG
FROM "OKS"."OKS_RULE_ERROR"