PTAI_PRNTITMLVW

 index back

SELECT DISTINCT A.PTAI_LIST_ID , A.PTAI_ITEM_ID , B.LANGUAGE_CD , B.PTAI_LABEL FROM PS_PTAI_ITEM A , PS_PTAI_ITEM_LNG B WHERE (A.PTAI_ITEM_ID=B.PTAI_ITEM_ID AND A.PTAI_SUMMARY = 'Y') UNION SELECT DISTINCT X.PTAI_LIST_ID , 'ROOT' ,Y.LANGUAGE_CD , 'ROOT' FROM PS_PTAI_LIST X , PS_PTAI_LIST_LNG Y

  • Related language record for PTAI_PRNTITM_VW

    • PeopleSoft Field Name Field Type Column Type Description
    PTAI_LIST_ID Character(31) VARCHAR2(31) NOT NULL Action Items - Action Item List ID
    PTAI_PARENT_ACTION Character(31) VARCHAR2(31) NOT NULL Controller Action
    LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code translate values
    PTAI_PARENT_LABEL Character(100) VARCHAR2(100) NOT NULL Action Items - Label
    index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
    PTRef generated on 21-DEC-20