PSSERVICE3_VW

index back

IB Services view.

Selects services that have no Service Operations tied to them.
SELECT DISTINCT A.IB_SERVICENAME , A.IB_ALIASNAME , A.DESCR FROM PSSERVICE A WHERE NOT EXISTS ( SELECT 'X' FROM PSSERVICEOPR B WHERE B.IB_SERVICENAME = A.IB_SERVICENAME)

  • Related language record: PSSERVICE3_LVW
  • PeopleSoft Field Name Field Type Column Type Description
    IB_SERVICENAME Character(30) VARCHAR2(30) NOT NULL Service (see PSSERVICE).
    IB_ALIASNAME Character(128) VARCHAR2(128) NOT NULL Service Alias
    DESCR Character(30) VARCHAR2(30) NOT NULL Description
    index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
    PTRef generated on 09-JUN-19