[Home] [Help] [Dependency Information]
Object Name: | CSC_PROF_TABLE_COLUMNS_B |
---|---|
Object Type: | TABLE |
Owner: | CSC |
FND Design Data: | CSC.CSC_PROF_TABLE_COLUMNS_B |
Subobject Name: | |
Status: | VALID |
Base table to Store Drilldown details for a profile variable. This stores the column and table names for the drilldown form. Also stores the object_code, which provides the form_function to drilldown
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
CSC_PROF_TABLE_COLUMNS_U1 | NORMAL | UNIQUE | APPS_TS_SEED |
TABLE_COLUMN_ID
ZD_EDITION_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
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 | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
CREATION_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | The version on the record |
SECURITY_GROUP_ID | NUMBER | Used in hosted environments | ||
SEEDED_FLAG | VARCHAR2 | (3) | Identifier to know if the record is seed or not | |
ZD_EDITION_NAME | VARCHAR2 | (30) | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT TABLE_COLUMN_ID
, BLOCK_ID
, TABLE_NAME
, ALIAS_NAME
, COLUMN_NAME
, COLUMN_SEQUENCE
, DRILLDOWN_COLUMN_FLAG
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER
, SECURITY_GROUP_ID
, SEEDED_FLAG
, ZD_EDITION_NAME
FROM CSC.CSC_PROF_TABLE_COLUMNS_B;
CSC.CSC_PROF_TABLE_COLUMNS_B does not reference any database object
CSC.CSC_PROF_TABLE_COLUMNS_B is referenced by following:
|
|
|