PTOPRCLAUSE_VW

index back

Dynamic Views using %OPRCLAUSE


SELECT A.SQLID, B.RECDESCR FROM PSSQLTEXTDEFN A , PSRECDEFN B WHERE UPPER(SQLTEXT) LIKE '%%OPRCLAUS%' AND SQLTYPE = 2 AND A.SQLID = B.RECNAME AND B.RECTYPE = 5

  • Related language record: PTOPRCLAUSE_LVW
  • PeopleSoft Field Name Field Type Column Type Description
    RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
    RECDESCR Character(30) VARCHAR2(30) NOT NULL Record Description
    index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
    PTRef generated on 21-DEC-20