IB_SERVICENAMELANGUAGE_CDPSPUBLSVC_LVW(SQL View) |
Index Back |
|---|---|
Services with ANY routingServices with ANY routing |
| SELECT DISTINCT A.IB_SERVICENAME , C.LANGUAGE_CD , C.DESCR FROM PSOPERATION A , PSOPRVERDFN B , PSSERVICELANG C WHERE A.IB_OPERATIONNAME = B.IB_OPERATIONNAME AND A.DEFAULTVER = B.VERSIONNAME AND A.RTNGTYPE IN ('A', 'S', 'R') AND A.IB_SERVICENAME = C.IB_SERVICENAME AND C.IB_SERVICENAME NOT IN ('SOAPTOCI', 'IB_UTILITY') AND EXISTS ( SELECT 'X' FROM PSRTGANYPARMVW X WHERE X.IB_OPERATIONNAME = B.IB_OPERATIONNAME AND X.VERSIONNAME = B.VERSIONNAME) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | IB_SERVICENAME |
Character(30) | VARCHAR2(30) NOT NULL | Service (see PSSERVICE). |
| 2 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |