PTAI_TASKS_LVW

index back

Action Items in Tasks Rel.Lang

Related Language Action Items in Tasks View
SELECT A.PTAI_ITEM_ID , C.LANGUAGE_CD , C.PTAI_LABEL , C.PTAI_DESCRLONG FROM PS_PTAI_ITEM A , PS_PTAI_ITEM_LNG C WHERE C.PTAI_ITEM_ID = A.PTAI_ITEM_ID

  • Related language record for PTAI_TASKS_VW
  • PeopleSoft Field NameField TypeColumn TypeDescription
    PTAI_ITEM_IDCharacter(31)VARCHAR2(31) NOT NULLAction Items - Action Item ID
    LANGUAGE_CDCharacter(3)VARCHAR2(3) NOT NULLLanguage Code translate values
    PTAI_LABELCharacter(100)VARCHAR2(100) NOT NULLAction Items - Label
    PTAI_DESCRLONGLong CharacterCLOBAction Items - Long Description
    index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19