[Home] [Help] [Dependency Information]
Object Name: | CSF_SKILL_TYPES_B |
---|---|
Object Type: | TABLE |
Owner: | CSF |
FND Design Data: | CSF.CSF_SKILL_TYPES_B |
Subobject Name: | |
Status: | VALID |
CSF_SKILL_TYPES_B is used to store skill types.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
CSF_SKILL_TYPES_B_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | SKILL_TYPE_ID |
CSF_SKILL_TYPES_B_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | RATING_SCALE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SKILL_TYPE_ID | NUMBER | Yes | Primary key for table | |
KEY_COLUMN | VARCHAR2 | (200) | Select statement element representing a primary key column. E.g. inventory_item_id in case of a product skill object | |
DATA_COLUMN | VARCHAR2 | (2000) | Select statement element representing a column list | |
NAME_NUMBER_COLUMN | VARCHAR2 | (200) | Select statement element representing a column which contains the string or numeric value by which the object is usually known, e.g. product name. This information is used for display purposes | |
FROM_CLAUSE | VARCHAR2 | (2000) | Select statement representing the list of views or tables | |
WHERE_CLAUSE | VARCHAR2 | (2000) | Select statement representing the where clause | |
ORDER_BY_CLAUSE | VARCHAR2 | (200) | Select statement representing the order by clause | |
START_DATE_ACTIVE | DATE | Yes | Start Active date | |
END_DATE_ACTIVE | DATE | End Date active | ||
RATING_SCALE_ID | NUMBER | (15) | Yes | Foreign key to the rating scale id |
SEEDED_FLAG | VARCHAR2 | (1) | identifies whether this record is seeded | |
OBJECT_VERSION_NUMBER | NUMBER | Yes | The object version number is incremented by one at every update. The object version number is read when the row is read. When the record is updated a check is made that the update version number in the database has the same value as when the row was read. If the number was changed, some other process has updated the record and the row changes should be abandoned. | |
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 | |
SECURITY_GROUP_ID | NUMBER | Security group identifier | ||
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield column | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield column | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield column | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield column | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield column | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield column | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield column | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield column | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield column | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield column | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield column | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield column | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield column | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield column | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield column | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield column |
Cut, paste (and edit) the following text to query this object:
SELECT SKILL_TYPE_ID
, KEY_COLUMN
, DATA_COLUMN
, NAME_NUMBER_COLUMN
, FROM_CLAUSE
, WHERE_CLAUSE
, ORDER_BY_CLAUSE
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, RATING_SCALE_ID
, SEEDED_FLAG
, OBJECT_VERSION_NUMBER
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, SECURITY_GROUP_ID
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE_CATEGORY
FROM CSF.CSF_SKILL_TYPES_B;
CSF.CSF_SKILL_TYPES_B does not reference any database object
CSF.CSF_SKILL_TYPES_B is referenced by following:
|
|
|