[Home] [Help] [Dependency Information]
Object Name: | CUG_SR_TASK_TYPE_DETS_VL |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | CUG.CUG_SR_TASK_TYPE_DETS_VL |
Subobject Name: | |
Status: | VALID |
MultiLingual view (a language resolved view of the data.)
This view is used by the SR Type - Task Type Attribute Capture form to capture the Mandatory Attributes during configuration. These attributes are used as the default values by the Create Task API when tasks are created for an SR .
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Row ID | |
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) | Reserved For Future Use | |
PLANNED_END_OFFSET | NUMBER | (15) | Reserved For Future Use | |
SR_TASK_TYPE_DET_ID | NUMBER | (15) | Yes | Primary Key of the Underlying Base 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 | |
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 | |
ATTRIBUTE2 | VARCHAR2 | (150) | Standard Flexfield column | |
OWNER_TYPE_CODE | VARCHAR2 | (30) | Yes | Unique identifier of the Type of the Task Owner |
PLANNED_START_UOM | VARCHAR2 | (30) | Reserved For Future Use | |
PLANNED_END_UOM | VARCHAR2 | (30) | Reserved For Future Use | |
SCHEDULED_START_OFFSET | NUMBER | (15) | Reserved For Future Use | |
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 |
ATTRIBUTE3 | VARCHAR2 | (150) | Standard Flexfield column | |
ATTRIBUTE4 | VARCHAR2 | (150) | Standard Flexfield column | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who Column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who Column | |
OWNER_ID | NUMBER | Yes | Unique identifier of the Task Owner | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who Column |
SCHEDULED_END_OFFSET | NUMBER | (15) | Reserved For Future Use | |
SCHEDULED_START_UOM | VARCHAR2 | (30) | Reserved For Future Use | |
SCHEDULED_END_UOM | VARCHAR2 | (30) | 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 | |
ATTRIBUTE5 | VARCHAR2 | (150) | Standard Flexfield column | |
TASK_NAME | VARCHAR2 | (80) | Yes | Default Task Name used when a Task is Created |
DESCRIPTION | VARCHAR2 | (4000) | Default Task Description used when a Task is Created |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, ASSIGNED_BY_ID
, ASSIGNEE_TYPE_CODE
, TASK_PRIORITY_ID
, PLANNED_START_OFFSET
, PLANNED_END_OFFSET
, SR_TASK_TYPE_DET_ID
, OBJECT_VERSION_NUMBER
, CREATED_BY
, CREATION_DATE
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE_CATEGORY
, ATTRIBUTE2
, OWNER_TYPE_CODE
, PLANNED_START_UOM
, PLANNED_END_UOM
, SCHEDULED_START_OFFSET
, TSK_TYP_ATTR_DEP_ID
, TASK_STATUS_ID
, ATTRIBUTE3
, ATTRIBUTE4
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, OWNER_ID
, LAST_UPDATED_BY
, SCHEDULED_END_OFFSET
, SCHEDULED_START_UOM
, SCHEDULED_END_UOM
, PRIVATE_FLAG
, PUBLISH_FLAG
, ATTRIBUTE1
, ATTRIBUTE5
, TASK_NAME
, DESCRIPTION
FROM APPS.CUG_SR_TASK_TYPE_DETS_VL;
|
|
|