[Home] [Help] [Dependency Information]
Object Name: | CUG_TSK_TYP_ATTR_MAPS_B |
---|---|
Object Type: | TABLE |
Owner: | CUG |
FND Design Data: | CUG.CUG_TSK_TYP_ATTR_MAPS_B |
Subobject Name: | |
Status: | VALID |
The CUG_TSK_TYP_ATTR_MAPS_B Table stores the Task Type Attributes associated with a Task Type. The Task Type Attributes are associated with the Task Type by the Business Analyst at time of configuring the CIC Application. This association is independant of the Service Request Type. The Table also contains columns to specify the Task Type Attribute as Mandatory and to hold the default values of the Task Type Attributes. The Task Type Attributes can be inactivated for a Task Type using the START_DATE_ACTIVE and END_DATE_ACTIVE Columns of the Table.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
CUG_TSK_TYP_ATTR_MAPS_B_U1 | NORMAL | UNIQUE | APPS_TS_SEED |
TSK_TYP_ATTR_MAP_ID
ZD_EDITION_NAME |
CUG_TSK_TYP_ATTR_MAPS_B_U2 | NORMAL | UNIQUE | APPS_TS_SEED |
TASK_TYPE_ATTRIBUTE_CODE
TASK_TYPE_ID ZD_EDITION_NAME |
CUG_TSK_TYP_ATTR_MAPS_B_N1 | NORMAL | NONUNIQUE | APPS_TS_SEED | TASK_TYPE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TSK_TYP_ATTR_MAP_ID | NUMBER | (15) | Yes | Primary key for the Table |
OBJECT_VERSION_NUMBER | NUMBER | (15) | used by 'stateless' HTML applications | |
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_LOGIN | NUMBER | (15) | Standard Who column | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
TASK_TYPE_ATTRIBUTE_CODE | VARCHAR2 | (30) | Yes | Task Type Attribute Name. Foreign Key to the FND_LOOKUP_VALUES Table |
TASK_TYPE_ID | NUMBER | (15) | Yes | Uniquely identifies the Task Type. Foreign key to the JTF_TASK_TYPES Table |
TASK_ATTR_DEFAULT_VALUE | VARCHAR2 | (1997) | Holds the default value of the Task Attribute | |
TASK_ATTR_MANDATORY_FLAG | VARCHAR2 | (1) | Specifies whether the Task type Attribute is mandatory for a Task Type | |
TASK_ATTR_DISPLAYED_FLAG | VARCHAR2 | (1) | Specifies whether the Task Type Attribute is displayed or not | |
TASK_ATTRIBUTE_LIST_NAME | VARCHAR2 | (30) | Holds the name of the List of Values for the Task Type Attribute | |
START_DATE_ACTIVE | DATE | Start Date of the time period for which Task Type Attribute is valid | ||
END_DATE_ACTIVE | DATE | End Date of the time period for which Task Type Attribute is valid | ||
ATTRIBUTE1 | VARCHAR2 | (150) | Standard Flexfield column | |
ATTRIBUTE2 | VARCHAR2 | (150) | Standard Flexfield column | |
ATTRIBUTE3 | VARCHAR2 | (150) | Standard Flexfield column | |
ATTRIBUTE4 | VARCHAR2 | (150) | Standard Flexfield column | |
ATTRIBUTE5 | VARCHAR2 | (150) | Standard Flexfield column | |
ATTRIBUTE6 | VARCHAR2 | (150) | Standard Flexfield column | |
ATTRIBUTE7 | VARCHAR2 | (150) | Standard Flexfield column | |
ATTRIBUTE8 | VARCHAR2 | (150) | Standard Flexfield column | |
ATTRIBUTE9 | VARCHAR2 | (150) | Standard Flexfield column | |
ATTRIBUTE10 | VARCHAR2 | (150) | Standard Flexfield column | |
ATTRIBUTE11 | VARCHAR2 | (150) | Standard Flexfield column | |
ATTRIBUTE12 | VARCHAR2 | (150) | Standard Flexfield column | |
ATTRIBUTE13 | VARCHAR2 | (150) | Standard Flexfield column | |
ATTRIBUTE14 | VARCHAR2 | (150) | Standard Flexfield column | |
ATTRIBUTE15 | VARCHAR2 | (150) | Standard Flexfield column | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Standard Flexfield column | |
SECURITY_GROUP_ID | NUMBER | (15) | security column for hosted applications | |
ZD_EDITION_NAME | VARCHAR2 | (30) | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT TSK_TYP_ATTR_MAP_ID
, OBJECT_VERSION_NUMBER
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, LAST_UPDATE_DATE
, TASK_TYPE_ATTRIBUTE_CODE
, TASK_TYPE_ID
, TASK_ATTR_DEFAULT_VALUE
, TASK_ATTR_MANDATORY_FLAG
, TASK_ATTR_DISPLAYED_FLAG
, TASK_ATTRIBUTE_LIST_NAME
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE_CATEGORY
, SECURITY_GROUP_ID
, ZD_EDITION_NAME
FROM CUG.CUG_TSK_TYP_ATTR_MAPS_B;
CUG.CUG_TSK_TYP_ATTR_MAPS_B does not reference any database object
CUG.CUG_TSK_TYP_ATTR_MAPS_B is referenced by following:
|
|
|