AGC_INST_LVW

(SQL View)
 Index Back

AGC Instances Rel Lang View

Activity Guide Composer Instances Related Language View

SELECT DISTINCT OPR.OPRID , TMPL.AGC_TEMPLATE_ID , LSTL.LANGUAGE_CD , LSTL.PTAI_LABEL FROM PS_AGC_TMPL_TBL TMPL , PSOPRDEFN OPR , PS_PTAI_LIST LST , PS_PTAI_LIST_LNG LSTL WHERE TMPL.AGC_TEMPLATE_ID = %Substring(LST.PTAI_PARENT_TMPL,1,7) AND LST.PTAI_LIST_ID = LSTL.PTAI_LIST_ID AND (EXISTS ( SELECT 'X' FROM PS_PTAI_LIST_PRIV PRIV WHERE PRIV.PTAI_LIST_ID = LST.PTAI_LIST_ID AND PRIV.PTAI_PRIVSET_ID ='PTAI_CONTRIBUTOR' AND EXISTS ( SELECT 'X' FROM PSROLEUSER ROL WHERE ROL.ROLEUSER = OPR.OPRID AND ((PRIV.PTAI_MBR_TYPE = 'USER' AND PRIV.PTAI_MBR_NAME = ROL.ROLEUSER) OR (PRIV.PTAI_MBR_TYPE = 'ROLE' AND PRIV.PTAI_MBR_NAME = ROL.ROLENAME)))))

  • Related Language Record for AGC_INST_VW

    • # 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 AGC_TEMPLATE_ID Character(7) VARCHAR2(7) NOT NULL Activity Guide Composer Template Id
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description