XMLFILE_IDXML_CTTA_SRCH(SQL View) |
Index Back |
|---|---|
Search View for Contrat@ XMLESP.- Search View for Contrat@ XML |
| SELECT A.XMLFILE_ID , A.DESCR FROM PS_XML_DEFN A ,PS_XML_TEMPLT_TBL B WHERE B.XML_SET = 'C01' AND B.XML_TEMPLATE_ID = A.XML_TEMPLATE_ID |
| # | 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 |