AUCNONA_TMP_VW

(SQL View)
Index Back

SELECT A.TMPLDEFN_ID , B.DESCR FROM PSXPRPTTMPL A , PSXPTMPLDEFN B WHERE A.TMPLDEFN_ID = B.TMPLDEFN_ID AND a.REPORT_DEFN_ID = 'AUC_NONA'

# 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