GDP_TMPL_SM_LVW

(SQL View)
 Index Back

GDP Tmpl Priv Sum Vw Rel Lang

Guided Process Template Privilege Summary View Related Language

SELECT OPR.OPRID , GPT.GDP_TEMPLATE_ID , GPL.LANGUAGE_CD , GPL.GDP_LABEL FROM PS_GDP_TMPL_TBL GPT , PS_GDP_TMPL_LNG GPL , PSOPRDEFN OPR WHERE GPT.GDP_TEMPLATE_ID = GPL.GDP_TEMPLATE_ID AND GPT.GDP_ACTIVE_FLG = 'Y' AND EXISTS ( SELECT 'X' FROM PS_GDP_TMPL_PRIV PRL , PSROLEUSER ROL WHERE PRL.GDP_TEMPLATE_ID = GPT.GDP_TEMPLATE_ID AND PRL.GDP_MBR_TYPE = 'ROLE' AND PRL.GDP_MBR_NAME = ROL.ROLENAME AND ROL.ROLEUSER = OPR.OPRID AND PRL.GDP_PRIVSET_ID IN ('PTAI_CONTRIBUTOR', 'PTAI_ADMINISTRATOR'))

  • Related Language Record for GDP_TMPL_SM_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 GDP_TEMPLATE_ID Character(10) VARCHAR2(10) NOT NULL Guided Process Template ID
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 GDP_LABEL Character(100) VARCHAR2(100) NOT NULL Guided Process Title