RDT_TMPL_COMPVW

(SQL View)
 Index Back

Components with System Data

PNLGRPNAME's defined in RB_CFG_COMP. Used as a prompt in the Display Template.

SELECT DISTINCT A.DISP_TMPL_ID , B.PNLGRPNAME FROM PS_RDT_TMPL_DEFN A , PS_RDT_TMPL_COMP B , PS_RDT_TMPL_OPT C , PS_BUS_UNIT_RC_DEF D WHERE A.DISP_TMPL_ID = B.DISP_TMPL_ID AND B.DISP_TMPL_ID = C.DISP_TMPL_ID AND B.PNLGRPNAME = C.PNLGRPNAME AND B.MARKET = C.MARKET AND A.DISP_TMPL_FAM_CD = D.DISP_TMPL_FAM_CD AND B.PNLGRPNAME = D.PNLGRPNAME AND B.MARKET = D.MARKET AND C.LIC_PROD_CD IN ( SELECT FIELDNAME FROM PSRECFIELD WHERE RECNAME = 'INSTALLATION' AND (FIELDNAME IN ( SELECT 'RC' FROM PS_INSTALLATION WHERE RC = 'Y') OR FIELDNAME IN ( SELECT 'RH' FROM PS_INSTALLATION WHERE RH = 'Y') OR FIELDNAME IN ( SELECT 'RHHR' FROM PS_INSTALLATION WHERE RHHR = 'Y') OR FIELDNAME IN ( SELECT 'RCSS' FROM PS_INSTALLATION WHERE RCSS = 'Y') OR FIELDNAME IN ( SELECT 'RHSS' FROM PS_INSTALLATION WHERE RHSS = 'Y')))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 DISP_TMPL_ID Character(30) VARCHAR2(30) NOT NULL Template identifier to define the display template.
2 PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name