PTSF_DELQRYS_VW

index back

SELECT DISTINCT PSQRYFIELD.QRYNAME , PSQRYDEFN.DESCR FROM PSQRYFIELD , PSQRYDEFN , PSQRYEXPR WHERE (PSQRYFIELD.FLDEXPNUM=1 AND PSQRYEXPR.FIELDTYPE=11 AND PSQRYFIELD.QRYFLDNAME <> ' ' AND PSQRYFIELD.SELNUM = 1) AND( PSQRYFIELD.QRYNAME = PSQRYEXPR.QRYNAME ) AND (PSQRYFIELD.QRYNAME = PSQRYDEFN.QRYNAME)

PeopleSoft Field NameField TypeColumn TypeDescription
PTSF_PSQUERY_DLTCharacter(30)VARCHAR2(30) NOT NULLQuery Name
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