PSIBWSDL_VW (SQL View)	Index Back
WSDL Repository View to hide the multiple rows. Show only WSDL names and related service.

PSIBWSDL_VW

(SQL View)

WSDL Repository

View to hide the multiple rows. Show only WSDL names and related service.

SELECT DISTINCT A.IB_WSDLNAME , A.IB_SERVICENAME FROM PSIBWSDLDFN A , PSSERVICE B WHERE A.IB_SERVICENAME = B.IB_SERVICENAME AND B.PTIBAPPLNAME = ' '

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 IB_WSDLNAME Character(70) VARCHAR2(70) NOT NULL WSDL Name (see PSIBWSDLDFN).

2 IB_SERVICENAME Character(30) VARCHAR2(30) NOT NULL Service (see PSSERVICE).

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	IB_WSDLNAME	Character(70)	VARCHAR2(70) NOT NULL	WSDL Name (see PSIBWSDLDFN).
2	IB_SERVICENAME	Character(30)	VARCHAR2(30) NOT NULL	Service (see PSSERVICE).