rem -----------------------------------------------------------------------
rem Filename:   d2kcols.sql
rem Purpose:    List Designer column descriptions per table
rem Date:       28-Apr-2000
rem Author:     Frank Naude, Oracle FAQ
rem -----------------------------------------------------------------------

break on TAB on COL

col tab format a30 trunc
col col format a30 trunc

SELECT AL2.NAME TAB,
       AL3.NAME COL,
       AL4.TXT_TEXT
FROM   CI_APPLICATION_SYSTEMS AL1,
       CI_TABLE_DEFINITIONS AL2,
       CI_COLUMNS AL3,
       CDI_TEXT AL4,
       SDD_ELEMENTS AL5
WHERE  AL1.NAME                = 'FRANK'     -- Enter your app name here !!!
  AND  AL1.LATEST_VERSION_FLAG = 'Y'   
  AND  AL1.ID      = AL2.APPLICATION_SYSTEM_OWNED_BY
  AND  AL2.ID      = AL3.TABLE_REFERENCE
  AND  AL3.ID      = AL5.EL_ID
  AND  AL4.TXT_REF = AL5.EL_ID
ORDER  BY AL2.NAME, AL3.SEQUENCE_NUMBER, AL4.TXT_SEQ
/