PTPG_QPRXLVWLNG

index back

SELECT A.FIELDNAME , A.FIELDVALUE , B.LANGUAGE_CD , B.XLATLONGNAME FROM PSXLATITEM A , PSXLATITEMLANG B WHERE A.EFF_STATUS='A' AND A.FIELDNAME=B.FIELDNAME AND A.FIELDVALUE=B.FIELDVALUE

  • Related language record for PTPG_QPRXLATVW
  • PeopleSoft Field Name Field Type Column Type Description
    FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
    FIELDVALUE Character(4) VARCHAR2(4) NOT NULL Field Value
    LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code translate values
    PTPG_QRYPROMPTVAL Character(30) VARCHAR2(30) NOT NULL Query Prompt Values
    index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
    PTRef generated on 21-DEC-20