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: PA.PA_RULES#

Source

View Text - Preformatted


select RULE_ID RULE_ID, RULE_NAME RULE_NAME, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, RULE_TYPE RULE_TYPE, KEY_SOURCE KEY_SOURCE, DESCRIPTION DESCRIPTION, USER_UPDATABLE_FLAG USER_UPDATABLE_FLAG, CONSTANT_VALUE CONSTANT_VALUE, KEY_PARAMETER_ID KEY_PARAMETER_ID, SEGMENT_VALUE_LOOKUP_SET_ID SEGMENT_VALUE_LOOKUP_SET_ID, SELECT_QUALIFIERS_AMT SELECT_QUALIFIERS_AMT, SELECT_MULTIPLE_ROWS_FLAG SELECT_MULTIPLE_ROWS_FLAG, SELECT_STATEMENT SELECT_STATEMENT from "PA"."PA_RULES"

View Text - HTML Formatted

SELECT RULE_ID RULE_ID
, RULE_NAME RULE_NAME
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, RULE_TYPE RULE_TYPE
, KEY_SOURCE KEY_SOURCE
, DESCRIPTION DESCRIPTION
, USER_UPDATABLE_FLAG USER_UPDATABLE_FLAG
, CONSTANT_VALUE CONSTANT_VALUE
, KEY_PARAMETER_ID KEY_PARAMETER_ID
, SEGMENT_VALUE_LOOKUP_SET_ID SEGMENT_VALUE_LOOKUP_SET_ID
, SELECT_QUALIFIERS_AMT SELECT_QUALIFIERS_AMT
, SELECT_MULTIPLE_ROWS_FLAG SELECT_MULTIPLE_ROWS_FLAG
, SELECT_STATEMENT SELECT_STATEMENT
FROM "PA"."PA_RULES"