PTRS_QRYLANGVW

index back

Report search related lang qry

This record provides related language fields for PTRS_SRCHQRYVW record.
SELECT A.PRCSINSTANCE , A.ENDDTTM , F.psrf_report_descr , F.LANGUAGE_CD FROM PS_CDM_LIST A INNER JOIN PS_CDM_FILE_LIST B ON A.PRCSINSTANCE = B.PRCSINSTANCE INNER JOIN PSRF_RINFO_TBL C ON A.PRCSINSTANCE = C.PRCSINSTANCE INNER JOIN PSPRCSRQST D ON A.PRCSINSTANCE = D.PRCSINSTANCE INNER JOIN PS_CDM_AUTH E ON A.CONTENTID = E.CONTENTID INNER JOIN PSRF_RDESC_LANG F ON a.prcstype = f.prcstype AND a.prcsname = f.prcsname WHERE A.LOGFILEONLY_FLAG = '0' AND B.CDM_FILE_TYPE NOT IN ('STDOUT', 'TRC', 'LOG', 'OUT', 'AET') AND C.FILENAME IS NOT NULL

  • Related language record for PTRS_SRCHQRYVW
  • Parent record: CDM_LIST
  • PeopleSoft Field Name Field Type Column Type Description
    PRCSINSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
    ENDDTTM DateTime(26) TIMESTAMP End Date/Time
    CONTENT_DESCR Character(254) VARCHAR2(254) NOT NULL Report Description
    LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code translate values
    index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
    PTRef generated on 09-JUN-19