SELECT C.PNLGRPNAME Component, P.PNLNAME, R.RECNAME,R.FIELDNAME,CASE
WHEN BITAND(R.USEEDIT, 256) > 0 THEN
'YES'
ELSE 'NO'
END AS RequiredField FROM psfsm.PSPNLGROUP C, psfsm.PSPNLFIELD P, psfsm.PSRECFIELD R
WHERE C.PNLNAME=P.PNLNAME AND P.RECNAME=R.RECNAME AND P.FIELDNAME=R.FIELDNAME
AND C.PNLGRPNAME='PC_BUD_GENERAL' AND market='GBL' ORDER BY 5 DESC, 3,4
WHEN BITAND(R.USEEDIT, 256) > 0 THEN
'YES'
ELSE 'NO'
END AS RequiredField FROM psfsm.PSPNLGROUP C, psfsm.PSPNLFIELD P, psfsm.PSRECFIELD R
WHERE C.PNLNAME=P.PNLNAME AND P.RECNAME=R.RECNAME AND P.FIELDNAME=R.FIELDNAME
AND C.PNLGRPNAME='PC_BUD_GENERAL' AND market='GBL' ORDER BY 5 DESC, 3,4
Comments
Post a Comment