GP_WC_LT_LNG_VW

(SQL View)
 Index Back

PROMPT FOR LIST ID LNG

Prompt table language record for list id in work centre

SELECT A.PTAI_LIST_ID ,B.LANGUAGE_CD , B.PTAI_LABEL FROM PS_PTAI_LIST A , PS_PTAI_LIST_LNG B WHERE A.PTAI_ACTIVE_FLG = 'Y' AND A.OBJECTOWNERID LIKE ('HG%') AND A.PTAI_IS_TMPL = 'Y' AND A.PTAI_LIST_ID = B.PTAI_LIST_ID

  • Related Language Record for GP_WC_LISTID_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PTAI_LIST_ID Character(31) VARCHAR2(31) NOT NULL Action Items - Action Item List ID
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description