PSOPRFLTMSGS_VW(SQL View) |
Index Back |
---|---|
IB Service Parameters |
SELECT A.IB_OPERATIONNAME , A.VERSIONNAME , B.MSGNAME , B.IB_MSGVERSION FROM PSOPRVERDFNPARM A , PSOPRVERDFNPARM B WHERE A.IB_OPERATIONNAME = B.IB_OPERATIONNAME (+) AND A.VERSIONNAME = B.VERSIONNAME (+) AND B.PARAMETERNAME (+) = 'Z_FAULT' AND A.PARAMETERNAME = 'REQUEST' |
# | 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 | MSGNAME | Character(30) | VARCHAR2(30) NOT NULL | Application Message Name. Name of the Application Message Definition. (see PSMSGDEFN). |
4 | IB_MSGVERSION | Character(30) | VARCHAR2(30) NOT NULL | Message Version |