IB_OPERATIONNAMEPSIBOPER_VW(SQL View) |
Index Back |
|---|---|
IB Operation ViewExcludes Service Operations belonging to Open API Services |
| SELECT IB_OPERATIONNAME FROM PSOPERATION A WHERE A.PTIBAPPLNAME = ' ' AND NOT EXISTS (SELECT 'X' FROM PSSERVICE B WHERE A.IB_SERVICENAME = B.IB_SERVICENAME and B.PT_OPEN_API = 1) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | IB_OPERATIONNAME |
Character(30) | VARCHAR2(30) NOT NULL | Service Operation (see PSOPERATION). |