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 NameField TypeColumn TypeDescription
    PTAI_LIST_IDCharacter(31)VARCHAR2(31) NOT NULLAction Items - Action Item List ID
    PTAI_PARENT_ACTIONCharacter(31)VARCHAR2(31) NOT NULLController Action
    LANGUAGE_CDCharacter(3)VARCHAR2(3) NOT NULLLanguage Code translate values
    PTAI_PARENT_LABELCharacter(100)VARCHAR2(100) NOT NULLAction Items - Label
    index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19