SECURITY_DIM_VW

index back

SELECT DISTINCT A.QRYNAME, A.DESCR FROM PSQRYDEFN A, PSQRYFIELD B, PSQRYSELECT C WHERE A.OPRID = B.OPRID AND A.QRYNAME = B.QRYNAME AND B.OPRID = C.OPRID AND B.QRYNAME = C.QRYNAME AND B.SELNUM = C.SELNUM AND B.COLUMNNUM > 0 AND ( B.FIELDNAME = 'OPRID' OR B.FIELDNAME = 'OPRCLASS')

PeopleSoft Field NameField TypeColumn TypeDescription
QRYNAMECharacter(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