[Home] [Help] [Dependency Information]
Object Name: | CSC_PROF_TABLE_COLUMNS_VL |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | CSC.CSC_PROF_TABLE_COLUMNS_VL |
Subobject Name: | |
Status: | VALID |
MultiLingual view (a language resolved view of the data.)
This view is the MLSed view based on CSC_PROF_TABLE_COLUMNS_VL and CSC_PROF_TABLE_COLUMNS_TL. This view is used in Customer Profile Setup form- Drilldown Details tabs.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Row Id | |
TABLE_COLUMN_ID | NUMBER | Yes | Unique identifier | |
BLOCK_ID | NUMBER | Yes | Foreign key to CS_PROF_BLOCKS_B | |
TABLE_NAME | VARCHAR2 | (30) | Yes | The real name of the table. |
ALIAS_NAME | VARCHAR2 | (30) | Alias name for this table, used in the select statement | |
COLUMN_NAME | VARCHAR2 | (30) | Yes | The real name of the column. |
COLUMN_SEQUENCE | NUMBER | Yes | Column sequence for this column. | |
DRILLDOWN_COLUMN_FLAG | VARCHAR2 | (3) | Flag to indicate , whether this column is the drilldown column. i.e. whether this is the key column to be used as parameter to a form | |
LABEL | VARCHAR2 | (80) | Label for the Column. Will be displayed in the Drilldown form. | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who Column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who Column |
CREATION_DATE | DATE | Yes | Standard Who Column | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who Column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who Column | |
OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | The version on the record |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, TABLE_COLUMN_ID
, BLOCK_ID
, TABLE_NAME
, ALIAS_NAME
, COLUMN_NAME
, COLUMN_SEQUENCE
, DRILLDOWN_COLUMN_FLAG
, LABEL
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER
FROM APPS.CSC_PROF_TABLE_COLUMNS_VL;
|
|
|