myPeopleSoft

PeopleSoft Community Network

360 degree view of component.

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'

2 members like this

▶ Reply to This

Replies to This Discussion

Permalink Reply by Jae Hunsinger on May 16, 2013 at 12:54am

Great !!

▶ Reply

Permalink Reply by kristen on July 9, 2017 at 1:22pm

it's a pleasure to meet you. I am USA Army personnel, i have an important thing to discus with you.
Please write me on my email (captkristen899@gmail.com)