VIEW: AMS.AMS_IBA_PS_RULES#

Source

View Text - Preformatted

select CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, SECURITY_GROUP_ID SECURITY_GROUP_ID, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, RULE_ID RULE_ID, RULEGROUP_ID RULEGROUP_ID, POSTING_ID POSTING_ID, STRATEGY_ID STRATEGY_ID, EXEC_PRIORITY EXEC_PRIORITY, BUS_PRIORITY_CODE BUS_PRIORITY_CODE, BUS_PRIORITY_DISP_ORDER BUS_PRIORITY_DISP_ORDER, CLAUSEVALUE1 CLAUSEVALUE1, CLAUSEVALUE2 CLAUSEVALUE2, CLAUSEVALUE3 CLAUSEVALUE3, CLAUSEVALUE4 CLAUSEVALUE4, CLAUSEVALUE5 CLAUSEVALUE5, CLAUSEVALUE6 CLAUSEVALUE6, USE_CLAUSE6 USE_CLAUSE6, CLAUSEVALUE7 CLAUSEVALUE7, USE_CLAUSE7 USE_CLAUSE7, CLAUSEVALUE8 CLAUSEVALUE8, USE_CLAUSE8 USE_CLAUSE8, CLAUSEVALUE9 CLAUSEVALUE9, USE_CLAUSE9 USE_CLAUSE9, CLAUSEVALUE10 CLAUSEVALUE10, USE_CLAUSE10 USE_CLAUSE10 from "AMS"."AMS_IBA_PS_RULES"

View Text - HTML Formatted

SELECT CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, RULE_ID RULE_ID
, RULEGROUP_ID RULEGROUP_ID
, POSTING_ID POSTING_ID
, STRATEGY_ID STRATEGY_ID
, EXEC_PRIORITY EXEC_PRIORITY
, BUS_PRIORITY_CODE BUS_PRIORITY_CODE
, BUS_PRIORITY_DISP_ORDER BUS_PRIORITY_DISP_ORDER
, CLAUSEVALUE1 CLAUSEVALUE1
, CLAUSEVALUE2 CLAUSEVALUE2
, CLAUSEVALUE3 CLAUSEVALUE3
, CLAUSEVALUE4 CLAUSEVALUE4
, CLAUSEVALUE5 CLAUSEVALUE5
, CLAUSEVALUE6 CLAUSEVALUE6
, USE_CLAUSE6 USE_CLAUSE6
, CLAUSEVALUE7 CLAUSEVALUE7
, USE_CLAUSE7 USE_CLAUSE7
, CLAUSEVALUE8 CLAUSEVALUE8
, USE_CLAUSE8 USE_CLAUSE8
, CLAUSEVALUE9 CLAUSEVALUE9
, USE_CLAUSE9 USE_CLAUSE9
, CLAUSEVALUE10 CLAUSEVALUE10
, USE_CLAUSE10 USE_CLAUSE10
FROM "AMS"."AMS_IBA_PS_RULES"