PTSF_CQQRY_VW

index back

lists all queries in a conn qu


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

PeopleSoft Field NameField TypeColumn TypeDescription
CONQRSNAMECharacter(30)VARCHAR2(30) NOT NULLConnected Queries object name
QRYNAMECharacter(30)VARCHAR2(30) NOT NULLQuery Name
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19