RB_AMPCTGRYST_V (SQL View)	Index Back
View to select Categories View to select Categories on AMP Rule Definition

RB_AMPCTGRYST_V

(SQL View)

View to select Categories

View to select Categories on AMP Rule Definition

SELECT A.TMPLT_CATEGRY_ID , A.TMPLT_CATEGRY_NAME FROM PS_RBC_TEMPLT_CAT A WHERE A.TMPLT_CATEGRY_ID IN ( SELECT B.TMPLT_CATEGRY_ID FROM PS_RBN_CATGSET_DTL B WHERE B.NLP_CATEGORYSET_ID = 'AMP CATEGORIES')

Related Language Record: RB_AMPCTST_VLNG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 TMPLT_CATEGRY_ID Number(6,0) INTEGER NOT NULL Template Category ID

2 TMPLT_CATEGRY_NAME Character(30) VARCHAR2(30) NOT NULL Holds the names of the categories. 01/16/03: Set the Format Type to "Mixedcase", from Uppercase.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	TMPLT_CATEGRY_ID	Number(6,0)	INTEGER NOT NULL	Template Category ID
2	TMPLT_CATEGRY_NAME	Character(30)	VARCHAR2(30) NOT NULL	Holds the names of the categories. 01/16/03: Set the Format Type to "Mixedcase", from Uppercase.