SP_AN_GRPLCLSVW

(SQL View)
 Index Back

Sec Vw - Analysis Group Lng Vw


SELECT DISTINCT CD.CLASSID , ANGRP.SETID , ANGRP.ANALYSIS_GROUP , LNG.LANGUAGE_CD , LNG.DESCR FROM PSCLASSDEFN CD , PS_PROJ_AN_GRP_TBL ANGRP , PS_INSTALLATION_FS INS , PS_PROJ_AN_GRP_LNG LNG WHERE %Join(COMMON_KEYS, PROJ_AN_GRP_TBL ANGRP, PROJ_AN_GRP_LNG LNG) AND ( INS.SECURITY_TYPE = 'C' AND INS.PROJECT_SECURITY = 'Y' AND INS.PROJ_SECURITY_TYPE = 'L' AND EXISTS ( SELECT 'X' FROM PS_SEC_PROJLST_CLS SPRC , PS_PROJ_ROLE PROLE1 , PS_PC_SECPRO_ANGRP SPAN1 , PS_SET_CNTRL_REC SCR1 WHERE SPRC.OPRCLASS = CD.CLASSID AND SCR1.SETCNTRLVALUE = SPRC.BUSINESS_UNIT AND SCR1.RECNAME = 'PROJ_ROLE' AND PROLE1.SETID = SCR1.SETID AND PROLE1.PROJ_ROLE = SPRC.PROJ_ROLE AND SPAN1.SECURITY_PROFILE = PROLE1.PROJ_ROLE AND ANGRP.ANALYSIS_GROUP = SPAN1.ANALYSIS_GROUP )) OR ( INS.SECURITY_TYPE = 'C' AND INS.PROJECT_SECURITY = 'Y' AND INS.PROJ_SECURITY_TYPE = 'T' AND EXISTS ( SELECT 'X' FROM PS_SEC_PROJ_CLS SPC , PS_PROJ_ROLE PROLE2 , PS_PC_SECPRO_ANGRP SPAN2 , PS_SET_CNTRL_REC SCR2 WHERE SPC.OPRCLASS = CD.CLASSID AND SCR2.SETCNTRLVALUE = SPC.TREE_BU AND SCR2.RECNAME = 'PROJ_ROLE' AND PROLE2.SETID = SCR2.SETID AND PROLE2.PROJ_ROLE = SPC.PROJ_ROLE AND SPAN2.SECURITY_PROFILE = PROLE2.PROJ_ROLE AND ANGRP.ANALYSIS_GROUP = SPAN2.ANALYSIS_GROUP ))

  • Related Language Record for SP_AN_GRP_CLSVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRCLASS Character(30) VARCHAR2(30) NOT NULL Operator Class
    2 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    3 ANALYSIS_GROUP Character(5) VARCHAR2(5) NOT NULL Analysis Group
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description