PSOPRRTNWSDL_VW

index back

Service Operation WSDL View

Lists routings with service operations exported to WSDL.
SELECT DISTINCT B.IB_OPERATIONNAME , B.VERSIONNAME , B.IB_EXPORTSTATUS , C.ROUTINGDEFNNAME FROM PSOPRVERDFN B , PSIBRTNGDEFN C WHERE B.IB_OPERATIONNAME = C.IB_OPERATIONNAME AND B.VERSIONNAME = C.VERSIONNAME AND B.IB_EXPORTSTATUS <> 'N'

PeopleSoft Field NameField TypeColumn TypeDescription
IB_OPERATIONNAMECharacter(30)VARCHAR2(30) NOT NULLService Operation (see PSOPERATION).
VERSIONNAMECharacter(30)VARCHAR2(30) NOT NULLService Operation Version
IB_EXPORTSTATUSCharacter(1)VARCHAR2(1) NOT NULLExport Status
C=Changed After Export
E=Exported
N=Not Exported
ROUTINGDEFNNAMECharacter(30)VARCHAR2(30) NOT NULLRouting Name
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19