SP_AN_GRPLOPRVW

(SQL View)
 Index Back

Sec Vw - An Grp - Opr Lang Vw


SELECT DISTINCT OD.OPRID , ANGRP.SETID , ANGRP.ANALYSIS_GROUP , LNG.LANGUAGE_CD , LNG.DESCR FROM PSOPRDEFN OD , 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 = 'O' AND INS.PROJECT_SECURITY = 'Y' AND INS.PROJ_SECURITY_TYPE = 'L' AND EXISTS ( SELECT 'X' FROM PS_SEC_PROJLST_OPR SPRO , PS_PROJ_ROLE PROLE1 , PS_PC_SECPRO_ANGRP SPAN1 , PS_SET_CNTRL_REC SCR1 WHERE SPRO.OPRID = OD.OPRID AND SCR1.SETCNTRLVALUE = SPRO.BUSINESS_UNIT AND SCR1.RECNAME = 'PROJ_ROLE' AND PROLE1.SETID = SCR1.SETID AND PROLE1.PROJ_ROLE = SPRO.PROJ_ROLE AND SPAN1.SECURITY_PROFILE = PROLE1.SECURITY_PROFILE AND ANGRP.ANALYSIS_GROUP = SPAN1.ANALYSIS_GROUP )) OR ( INS.SECURITY_TYPE = '0' AND INS.PROJECT_SECURITY = 'Y' AND INS.PROJ_SECURITY_TYPE = 'T' AND EXISTS ( SELECT 'X' FROM PS_SEC_PROJ_OPR SPO , PS_PROJ_ROLE PROLE2 , PS_PC_SECPRO_ANGRP SPAN2 , PS_SET_CNTRL_REC SCR2 WHERE SPO.OPRID = OD.OPRID AND SCR2.SETCNTRLVALUE = SPO.TREE_BU AND SCR2.RECNAME = 'PROJ_ROLE' AND PROLE2.SETID = SCR2.SETID AND PROLE2.PROJ_ROLE = SPO.PROJ_ROLE AND SPAN2.SECURITY_PROFILE = PROLE2.SECURITY_PROFILE AND ANGRP.ANALYSIS_GROUP = SPAN2.ANALYSIS_GROUP ))

  • Related Language Record for SP_AN_GRP_OPRVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    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