PSCONTFRMT_VW

 index back

SELECT A.CONTNAME , A.CONTFMT , B.CONTDATA FROM PSCONTDEFN A INNER JOIN PSCONTENT B ON A.CONTNAME=B.CONTNAME AND A.ALTCONTNUM=B.ALTCONTNUM AND A.CONTTYPE = B.CONTTYPE WHERE A.CONTTYPE=1

PeopleSoft Field Name Field Type Column Type Description
CONTNAME Character(30) VARCHAR2(30) NOT NULL Content Name
CONTFMT Character(3) VARCHAR2(3) NOT NULL Content Format
CONTDATA Image / Attachment CLOB Content Data
index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
PTRef generated on 21-DEC-20