PeopleSoft Community Network
SELECT A.PNLGRPNAME, A.PNLNAME, A.ITEMLABEL, B.RECNAME,b.fieldname,b.occurslevel, B.LBLTEXT,A.MARKET,B.PNLNAME,B.PNLFLDID,objectvalue1,objectvalue2,objectvalue3,objectvalue4,
c.recname,refname
FROM PSPNLGROUP A, PSPNLFIELD B, PSPCMNAME C
WHERE ( A.PNLNAME = B.PNLNAME ) and (
(b.recname=objectvalue1 and b.fieldname=objectvalue2)
or
(A.PNLGRPNAME=objectvalue1 and objectvalue2='GBL' and b.recname=objectvalue3 and b.fieldname=objectvalue4)
)
and PNLGRPNAME ='VCHR_EXPRESS'
Tags:
Great !!
© 2024 Created by Maisam Agha. Powered by