XMLP_TEMPLATELANGUAGE_CDXML_XMLP_LNG(SQL View) |
Index Back |
|---|---|
View to fetch XMLP objectsView to fetch XMLP objects. |
| SELECT A.REPORT_DEFN_ID , B.LANGUAGE_CD , A.DESCR FROM PSXPRPTDEFN A , PSXPRPTDEFNLNG B WHERE A.REPORT_DEFN_ID = B.REPORT_DEFN_ID AND A.DS_TYPE = 'XML' AND A.OBJECTOWNERID IN ('HRR', 'HES', 'HGES') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | XMLP_TEMPLATE |
Character(30) | VARCHAR2(30) NOT NULL | XMLP Template |
| 2 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |