[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 |