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 Name Field Type Column Type Description
QRYNAME Character(30) VARCHAR2(30) NOT NULL Query Name
DESCR Character(30) VARCHAR2(30) NOT NULL Description
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19