PO_XMLP_T_LGVW

(SQL View)
 Index Back

PO XMLP template

Language Record of RECV_AN_LGVW

SELECT A.TMPLDEFN_ID , d.LANGUAGE_CD , d.DESCR FROM PSXPRPTTMPL A , PSXPTMPLDEFN B , PSXPTMPLFILEDEF C , PSXPTMPLDEFNLNG d WHERE A.TMPLDEFN_ID = B.TMPLDEFN_ID AND B.TMPLDEFN_ID = C.TMPLDEFN_ID AND A.REPORT_DEFN_ID = 'PO_DISPATCH' AND C.EFFDT = ( SELECT MAX(C1.EFFDT) FROM PSXPTMPLFILEDEF C1 WHERE C1.TMPLDEFN_ID = C.TMPLDEFN_ID AND C1.EFFDT <= %CurrentDateIn) AND C.TMPLFILE_STATUS = 'A' AND b.tmpldefn_id=d.tmpldefn_id

  • Related Language Record for PO_XMLP_TMPL_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 TMPLDEFN_ID Character(30) VARCHAR2(30) NOT NULL Template ID (see PSXPTMPLDEFN).
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description