VIEW: APPS.CSC_FND_ALL_COLUMNS_V

Source

View Text - Preformatted

SELECT a.application_id , a.table_id , a.column_sequence , a.column_name , a.description , 'TABLE' FROM fnd_columns a UNION (SELECT b.application_id , b.view_id , b.column_sequence , b.column_name , NULL , 'VIEW' FROM fnd_view_columns b)

View Text - HTML Formatted

SELECT A.APPLICATION_ID
, A.TABLE_ID
, A.COLUMN_SEQUENCE
, A.COLUMN_NAME
, A.DESCRIPTION
, 'TABLE'
FROM FND_COLUMNS A UNION (SELECT B.APPLICATION_ID
, B.VIEW_ID
, B.COLUMN_SEQUENCE
, B.COLUMN_NAME
, NULL
, 'VIEW'
FROM FND_VIEW_COLUMNS B)