[Home] [Help] [Dependency Information]
Object Name: | CUG_SR_TASK_TYPE_DETS_B |
---|---|
Object Type: | TABLE |
Owner: | CUG |
FND Design Data: | CUG.CUG_SR_TASK_TYPE_DETS_B |
Subobject Name: | |
Status: | VALID |
The CUG_SR_TASK_TYPE_DETS_B table is used to hold additional details about the Task Type for a Service Request Type. The additonal details are required to be entered at configuration time to be used while creating the Tasks of the Task Type attached to the Service Request Type.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
CUG_SR_TASK_TYPE_DETS_B_N1 | NORMAL | NONUNIQUE | APPS_TS_SEED | TSK_TYP_ATTR_DEP_ID |
CUG_SR_TASK_TYPE_DETS_B_N3 | NORMAL | NONUNIQUE | APPS_TS_SEED | TASK_STATUS_ID |
CUG_SR_TASK_TYPE_DETS_B_N4 | NORMAL | NONUNIQUE | APPS_TS_SEED | OWNER_ID |
CUG_SR_TASK_TYPE_DETS_B_N5 | NORMAL | NONUNIQUE | APPS_TS_SEED | TASK_PRIORITY_ID |
CUG_SR_TASK_TYPE_DETS_B_U1 | NORMAL | NONUNIQUE | APPS_TS_SEED | SR_TASK_TYPE_DET_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SR_TASK_TYPE_DET_ID | NUMBER | (15) | Yes | Primary Key of the Table |
OBJECT_VERSION_NUMBER | NUMBER | (15) | Used for 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_DATE | DATE | Yes | Standard who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
TSK_TYP_ATTR_DEP_ID | NUMBER | (15) | Yes | Foreign key to the CUG_TSK_TYP_ATTR_DEPS_B Table |
TASK_STATUS_ID | NUMBER | (15) | Yes | Foreign key to the JTF_TASK_STATUSES_B Table |
OWNER_ID | NUMBER | Yes | Unique identifier of the Task Owner | |
OWNER_TYPE_CODE | VARCHAR2 | (30) | Yes | Unique identifier of the Type of the Task Owner |
ASSIGNED_BY_ID | NUMBER | Unique identifier of the user who assigned the task to current owner | ||
ASSIGNEE_TYPE_CODE | VARCHAR2 | (30) | Unique identifier of the type of person who assigned the task to the owner | |
TASK_PRIORITY_ID | NUMBER | Foreign key to JTF_TASK_PRIORITIES_B | ||
PLANNED_START_OFFSET | NUMBER | (15) | The time period from the current date that marks the planned start date of the Task. Reserved For Future Use. | |
PLANNED_END_OFFSET | NUMBER | (15) | The time period from the current date that marks the planned end date of the Task. Reserved For Future Use. | |
PLANNED_START_UOM | VARCHAR2 | (30) | The unit of measure for the time period offset of the Planned Start Date. Reserved For Future Use. | |
PLANNED_END_UOM | VARCHAR2 | (30) | The unit of measure for the time period offset of the Planned End Date. Reserved For Future Use. | |
SCHEDULED_START_OFFSET | NUMBER | (15) | The time period from the current date that marks the scheduled start date of the Task. Reserved For Future Use. | |
SCHEDULED_END_OFFSET | NUMBER | (15) | The time period from the current date that marks the scheduled start date of the Task. Reserved For Future Use. | |
SCHEDULED_START_UOM | VARCHAR2 | (30) | The unit of measure for the time period offset of the Scheduled Start Date. Reserved For Future Use. | |
SCHEDULED_END_UOM | VARCHAR2 | (30) | The unit of measure for the time period offset of the Planned End Date. Reserved For Future Use. | |
PRIVATE_FLAG | VARCHAR2 | (1) | Indicates whether the task is private or public | |
PUBLISH_FLAG | VARCHAR2 | (1) | Indicates whether the task should be published. | |
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 |
Cut, paste (and edit) the following text to query this object:
SELECT SR_TASK_TYPE_DET_ID
, OBJECT_VERSION_NUMBER
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, TSK_TYP_ATTR_DEP_ID
, TASK_STATUS_ID
, OWNER_ID
, OWNER_TYPE_CODE
, ASSIGNED_BY_ID
, ASSIGNEE_TYPE_CODE
, TASK_PRIORITY_ID
, PLANNED_START_OFFSET
, PLANNED_END_OFFSET
, PLANNED_START_UOM
, PLANNED_END_UOM
, SCHEDULED_START_OFFSET
, SCHEDULED_END_OFFSET
, SCHEDULED_START_UOM
, SCHEDULED_END_UOM
, PRIVATE_FLAG
, PUBLISH_FLAG
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE_CATEGORY
, SECURITY_GROUP_ID
FROM CUG.CUG_SR_TASK_TYPE_DETS_B;
CUG.CUG_SR_TASK_TYPE_DETS_B does not reference any database object
CUG.CUG_SR_TASK_TYPE_DETS_B is referenced by following:
|
|
|