View: CSC_FND_ALL_COLUMNS_V

Product:	CSC - Customer Care
Description:	View to get column properties in FND_COLUMNS
Implementation/DBA Data:	APPS.CSC_FND_ALL_COLUMNS_V

View Text

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)

Columns