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 NameField TypeColumn TypeDescription
    IB_SERVICENAMECharacter(30)VARCHAR2(30) NOT NULLService (see PSSERVICE).
    IB_ALIASNAMECharacter(128)VARCHAR2(128) NOT NULLService Alias
    DESCRCharacter(30)VARCHAR2(30) NOT NULLDescription
    index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19