SCC_RULE_NTF_VW

(SQL View)
 Index Back

SELECT A.SCC_NTFREQ_TMPLTID , A.SCC_NTFREQ_TMPLT FROM PS_SCC_NTF_SETUP A , PS_SCC_NTF_CON_TMP B WHERE A.SCC_STATUS = 'A' AND A.SCC_NTFREQ_TMPLTID = B.SCC_NTFREQ_TMPLTID AND B.SCC_NTF_CON_ID = 'SCC_NTF_CON_20131112191211'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SCC_NTFREQ_TMPLTID Character(40) VARCHAR2(40) NOT NULL Notification Template ID
2 SCC_NTFREQ_TMPLT Character(30) VARCHAR2(30) NOT NULL Template Name