XMLFILE_IDCTPR_SRCH_VW(SQL View) |
Index Back |
|---|---|
Search Vw Contract PrintingESP.- Search Vw Contract Printing Mapping |
| SELECT A.XMLFILE_ID , A.DESCR FROM PS_XML_DEFN A ,PS_XML_TEMPLT_TBL B WHERE B.XML_SET = 'P01' AND B.XML_TEMPLATE_ID = A.XML_TEMPLATE_ID AND B.XML_TEMPLATE_ID = 'P01' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | XMLFILE_ID |
Character(50) | VARCHAR2(50) NOT NULL | XML File ID |
| 2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |