SCC_RULEGR6LV (SQL View)	Index Back
Rule Grp Header Lookup View This view is used to search for rule groups based on the category values.

SCC_RULEGR6LV

(SQL View)

Rule Grp Header Lookup View

This view is used to search for rule groups based on the category values.

SELECT A.SCC_RULE_GROUP_ID , L.LANGUAGE_CD , L.SCC_RULE_GROUP_NM FROM PS_SCC_RULEGR_HDR A , PS_SCC_RULEGR_HDRL L WHERE A.SCC_RULE_VERSION = ( SELECT MAX(A1.SCC_RULE_VERSION) FROM PS_SCC_RULEGR_HDR A1 WHERE A1.SCC_RULE_GROUP_ID = A.SCC_RULE_GROUP_ID) AND A.SCC_RULE_GROUP_ID = L.SCC_RULE_GROUP_ID AND A.SCC_RULE_VERSION = L.SCC_RULE_VERSION

Related Language Record for SCC_RULEGR6VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SCC_RULE_GROUP_ID Character(40) VARCHAR2(40) NOT NULL This field is the Rule Group ID for rule groups used in the Rules Engine

2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

3 SCC_RULE_GROUP_NM Character(80) VARCHAR2(80) NOT NULL This field contains the name of the rule used in the Rules Engine

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SCC_RULE_GROUP_ID	Character(40)	VARCHAR2(40) NOT NULL	This field is the Rule Group ID for rule groups used in the Rules Engine
2	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
3	SCC_RULE_GROUP_NM	Character(80)	VARCHAR2(80) NOT NULL	This field contains the name of the rule used in the Rules Engine