[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: |
APPS.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 |