PTSF_CQQRY_VW

 index back

lists all queries in a conn qu


SELECT DISTINCT PSCONQRSMAP.CONQRSNAME ,PSQRYDEFN.QRYNAME ,PSQRYDEFN.DESCR FROM PSQRYDEFN , PSCONQRSMAP WHERE PSQRYDEFN.qryname = PSCONQRSMAP.qrynamechild

  • Related language record: PTSF_CQQRYLG_VW

    • PeopleSoft Field Name Field Type Column Type Description
    CONQRSNAME Character(30) VARCHAR2(30) NOT NULL Connected Queries object name
    QRYNAME Character(30) VARCHAR2(30) NOT NULL Query Name
    DESCR Character(30) VARCHAR2(30) NOT NULL Description
    index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
    PTRef generated on 21-DEC-20