SQL to list out the records and fields in a PeopleSoft pages

/* Formatted on 2014/03/12 14:28 (Formatter Plus v4.8.7) */
SELECT a.pnlname, a.recname, a.fieldname, a.lbltext, c.fieldtype, c.LENGTH,
       (SELECT CASE
                  WHEN BITAND (m.useedit, 256) > 0
                     THEN 'YES'
                  ELSE 'NO'
               END AS required_field
          FROM PSRECFIELD m, PSDBFIELD n
         WHERE m.recname = b.recname
           AND m.fieldname = n.fieldname
           AND m.fieldname = c.fieldname) AS req_field,
       (SELECT CASE
                  WHEN EXISTS (
                         SELECT 'X'
                           FROM all_ind_columns
                          WHERE table_name = 'PS_' || a.recname
                            AND column_name = a.fieldname)
                     THEN 'YES'
                  ELSE 'NO'
               END AS key_field
          FROM PS_INSTALLATION) AS keys_field
  FROM PSPNLFIELD a, PSRECFIELDDB b, PSDBFIELD c
 WHERE a.recname = b.recname
   AND a.fieldname = b.fieldname
   AND b.fieldname = c.fieldname
   AND a.pnlname IN ('CS_CNTRCT_HDR','CNTRCT_HDR_SBP')
   ORDER BY a.recname