LAST_PROCESS_INSTLANGUAGE_CDIN_DMD_LST_DLVW(SQL View) |
Index Back |
|---|
| SELECT DISTINCT A.LAST_PROCESS_INST , C.LANGUAGE_CD , C.DESCR FROM PS_IN_DEMAND A , PSPRCSRQST B , PS_PRCSDEFNLANG C WHERE A.LAST_PROCESS_INST = B.PRCSINSTANCE AND B.PRCSTYPE = C.PRCSTYPE AND B.PRCSNAME = C.PRCSNAME AND A.LAST_PROCESS_INST > 0 AND IN_PROCESS_DATE IS NOT NULL |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | LAST_PROCESS_INST |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |