IB_OPERATIONNAMEPTPPB_IBOPR_VW(SQL View) |
Index Back |
|---|
| SELECT A.IB_OPERATIONNAME , A.VERSIONNAME , C.DESCR FROM PSIBRTNGDEFN A , PSMSGNODEDEFN B , PSOPERATION C WHERE A.RTNGTYPE='S' AND A.EFF_STATUS='A' AND A.SENDERNODENAME=B.MSGNODENAME AND B.LOCALDEFAULTFLG='Y' AND A.IB_OPERATIONNAME=C.IB_OPERATIONNAME AND A.EFFDT = ( SELECT MAX(D.EFFDT) FROM PSIBRTNGDEFN D WHERE A.IB_OPERATIONNAME=D.IB_OPERATIONNAME) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | IB_OPERATIONNAME |
Character(30) | VARCHAR2(30) NOT NULL | Service Operation (see PSOPERATION). |
| 2 | VERSIONNAME | Character(30) | VARCHAR2(30) NOT NULL | Service Operation Version |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |