[Home] [Help]
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
Name |
APPLICATION_ID |
TABLE_ID |
COLUMN_SEQUENCE |
COLUMN_NAME |
DESCRIPTION |
TYPE |