/* Data Table Details */
SELECT app.ACRONYM AS APP_ACRONYM,
	   dt.DT_ID,
	   dt.TABLE_NAME,
	   dt.REF_COLUMN_NAME,
	   dt.DISPLAY_COLUMN_NAME
  FROM DATA_TABLES dt,
  	   APPLICATIONS app
 WHERE dt.DT_ID = :DT_ID
   AND app.app_id = :APP_ID
 
 
 