SELECT FT.APPLICATION_ID APPLICATION_ID , FT.TABLE_NAME TABLE_NAME , FC.COLUMN_NAME COLUMN_NAME , 'T' TYPE FROM FND_COLUMNS FC , FND_TABLES FT WHERE FT.APPLICATION_ID = FC.APPLICATION_ID AND FT.TABLE_ID = FC.TABLE_ID UNION SELECT FT.APPLICATION_ID APPLICATION_ID , FT.VIEW_NAME TABLE_NAME , FC.COLUMN_NAME COLUMN_NAME , 'V' TYPE FROM FND_VIEW_COLUMNS FC , FND_VIEWS FT WHERE FT.APPLICATION_ID = FC.APPLICATION_ID AND FT.VIEW_ID = FC.VIEW_ID