|
SELECT DISTINCT Q.PNLNAME, P.DESCR FROM PSPNLFIELD Q, PSPNLDEFN P WHERE P.PNLNAME =Q.PNLNAME AND Q.FIELDTYPE IN (11,18) AND Q.SUBPNLNAME IN (SELECT DISTINCT G.PNLNAME FROM PSPNLFIELDEXT E , PSPNLDEFN G WHERE G.PNLNAME = E.PNLNAME AND E.GRPBOXTYPE='21' AND G.PNLTYPE IN ('1','2') ) UNION SELECT DISTINCT D.PNLNAME , G.DESCR FROM PSPRSMDEFN F , PSPNLGROUP C , PSPNLFIELD D , PSPNLFIELDEXT E , PSPNLDEFN G WHERE F.PORTAL_URI_SEG2 = C.PNLGRPNAME AND F.PORTAL_URI_SEG3 = C.MARKET AND F.FLUIDMODE = '1' AND F.PORTAL_REFTYPE = 'C' AND C.PNLNAME=D.PNLNAME AND D.PNLFLDID = E.PNLFLDID AND D.PNLNAME = E.PNLNAME AND E.GRPBOXTYPE='21' AND G.PNLNAME = E.PNLNAME
|
PNLNAME