FND Design Data [Home] [Help]

View: JTF_TERR_COLUMNS_V

Product: JTF - CRM Foundation
Description: Shows a list of column associated with a table. This is used for defining user defined qualifiers
Implementation/DBA Data: ViewAPPS.JTF_TERR_COLUMNS_V
View Text

SELECT TABLE_NAME
, COLUMN_NAME
, COLUMN_ID
, DATA_TYPE
, DATA_LENGTH
, NULLABLE
FROM ALL_TAB_COLUMNS ORDER BY TABLE_NAME
, COLUMN_ID

Columns

Name
TABLE_NAME
COLUMN_NAME
COLUMN_ID
DATA_TYPE
DATA_LENGTH
NULLABLE