SCC_RCAT_BD_VW

(SQL View)
 Index Back

SELECT SCC_RULE_CATEGORY , SCC_RULE_CAT_NAME FROM PS_SCC_RULE_CAT WHERE SCC_RULE_CATEGORY IN ( SELECT SCC_RULE_CATEGORY FROM PS_SCC_RULE_HDR WHERE SCC_RULE_TYPE<>'10' AND SCC_RULE_STATUS<>'3')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SCC_RULE_CATEGORY Character(40) VARCHAR2(40) NOT NULL Rule Category for the Rules Engine
2 SCC_RULE_CAT_NAME Character(30) VARCHAR2(30) NOT NULL Rule Name for the Rules Engine