MIN_SERVICES_VW

(SQL View)
Index Back

IB services prompt view .


SELECT DISTINCT B.IB_SERVICENAME , A.IB_OPERATIONNAME , C.VERSIONNAME , A.DESCR FROM PSSERVICEOPR B , PSOPERATION A , PSOPRVERDFN C WHERE B.IB_OPERATIONNAME = A.IB_OPERATIONNAME AND A.IB_OPERATIONNAME = C.IB_OPERATIONNAME

  • Related Language Record: PSSERVICE_LVW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 IB_SERVICENAME Character(30) VARCHAR2(30) NOT NULL Service (see PSSERVICE).
    2 IB_OPERATIONNAME Character(30) VARCHAR2(30) NOT NULL Service Operation (see PSOPERATION).
    3 VERSIONNAME Character(30) VARCHAR2(30) NOT NULL Service Operation Version
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description