CA_SEC_CMB_VW

(SQL View)
 Index Back

Validation Combinations View

Validation Template Combinations View

SELECT HDR.OBJECTOWNERID ,HDR.TEMPLATE_ID ,CMB.PNLGRPNAME ,CMB.MARKET ,CMB.COMBINATION_NO ,USR.OPRID FROM PS_CA_SEC_TMPL_HDR HDR , PS_CA_SEC_TMPL_CMB CMB , PS_CA_SEC_USER_LST USR WHERE CMB.OBJECTOWNERID = HDR.OBJECTOWNERID AND CMB.TEMPLATE_ID = HDR.TEMPLATE_ID AND HDR.EFF_STATUS = 'A' AND HDR.SEC_TEMPLATE_TYPE='U' AND USR.OBJECTOWNERID = HDR.OBJECTOWNERID AND USR.TEMPLATE_ID = HDR.TEMPLATE_ID UNION SELECT HDR.OBJECTOWNERID ,HDR.TEMPLATE_ID ,CMB.PNLGRPNAME ,CMB.MARKET ,CMB.COMBINATION_NO ,RL.ROLEUSER FROM PS_CA_SEC_TMPL_HDR HDR , PS_CA_SEC_TMPL_CMB CMB , PSROLEUSER RL WHERE HDR.EFF_STATUS = 'A' AND HDR.SEC_TEMPLATE_TYPE='R' AND CMB.OBJECTOWNERID = HDR.OBJECTOWNERID AND CMB.TEMPLATE_ID = HDR.TEMPLATE_ID AND RL.ROLENAME = HDR.ROLENAME AND NOT EXISTS ( SELECT 'X' FROM PS_CA_SEC_EXCL_LST EXC WHERE EXC.OBJECTOWNERID = HDR.OBJECTOWNERID AND EXC.TEMPLATE_ID = HDR.TEMPLATE_ID AND EXC.OPRID = RL.ROLEUSER)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OBJECTOWNERID Character(4) VARCHAR2(4) NOT NULL Object owner identifier
2 TEMPLATE_ID Character(30) VARCHAR2(30) NOT NULL Project Template
3 PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name

Prompt Table: CA_SEC_CMP_VW

4 MARKET Character(3) VARCHAR2(3) NOT NULL Market

Prompt Table: CA_SEC_CMP_DEFN

5 COMBINATION_NO Number(3,0) SMALLINT NOT NULL Combination Number
6 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).