GDP_TMPL_LVW

(SQL View)
 Index Back

GDP Template Priv Vw Rel Lang

Guided Proces Template Privilege 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')) AND EXISTS ( SELECT GPT1.GDP_TEMPLATE_ID FROM PS_GDP_TMPL_TBL GPT1 , PS_GDP_TMPL_CTX CTX1 WHERE GPT1.GDP_TEMPLATE_ID = GPT.GDP_TEMPLATE_ID AND GPT1.GDP_TEMPLATE_ID = CTX1.GDP_TEMPLATE_ID AND CTX1.FIELDNAME = 'OPRID' AND EXISTS ( SELECT COUNT(*) FROM PS_GDP_TMPL_TBL GPT2 , PS_GDP_TMPL_CTX CTX2 WHERE GPT2.GDP_TEMPLATE_ID = GPT1.GDP_TEMPLATE_ID AND GPT2.GDP_TEMPLATE_ID = CTX2.GDP_TEMPLATE_ID HAVING COUNT(*) = 1) )

  • Related Language Record for GDP_TMPL_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