WO_XMLP_TMPL_VW

(SQL View)
 Index Back

Work Order PO Template

Work Order Purchase Order related XMLP Template

SELECT A.TMPLDEFN_ID , B.DESCR , A.IS_DEFAULT FROM PSXPRPTTMPL A , PSXPTMPLDEFN B , PSXPTMPLFILEDEF C WHERE A.TMPLDEFN_ID = B.TMPLDEFN_ID AND B.TMPLDEFN_ID = C.TMPLDEFN_ID AND A.REPORT_DEFN_ID = 'WO_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'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 TMPLDEFN_ID Character(30) VARCHAR2(30) NOT NULL Template ID (see PSXPTMPLDEFN).
2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
3 IS_DEFAULT Character(1) VARCHAR2(1) NOT NULL Default Template
N=No
Y=Yes