PTFP_GFEED_VW

(SQL View)
 Index Back

Generic Feed Svc Operations

Generic feed Service operations view. This is also the search record for PTFP_GENERIC_FEED component.

SELECT A.IB_OPERATIONNAME , A.DESCR FROM PSOPERATION A , PSOPRVERDFNPARM B , PSOPRVERDFN D WHERE A.IB_OPERATIONNAME= B.IB_OPERATIONNAME AND A.IB_OPERATIONNAME= D.IB_OPERATIONNAME AND A.DEFAULTVER= B.VERSIONNAME AND A.DEFAULTVER= D.VERSIONNAME AND B.MSGNAME<>'PT_FEED_REQUEST' AND B.PARAMETERNAME='REQUEST' AND A.RTNGTYPE ='A' AND D.ACTIVE_FLAG='A'

  • Related Language Record: PTFP_GFEED_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 IB_OPERATIONNAME Character(30) VARCHAR2(30) NOT NULL Service Operation (see PSOPERATION).
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description