[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | OKL_CS_TASKS_BALI_UV |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  OKL.OKL_CS_TASKS_BALI_UV
|
| Subobject Name: | |
| Status: | VALID |
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ROW_ID | ROWID | (10) | Row Identifier in the database | |
| TASK_ID | NUMBER | Yes | Unique task identifier (PK) | |
| TASK_NUMBER | VARCHAR2 | (30) | Yes | Task Number |
| TASK_NAME | VARCHAR2 | (80) | Yes | Task Name |
| DESCRIPTION | VARCHAR2 | (4000) | User entered description | |
| TASK_TYPE_ID | NUMBER | Yes | Task type (foreign key to JTF_TASK_TYPES) | |
| TASK_TYPE | VARCHAR2 | (30) | ||
| TASK_STATUS_ID | NUMBER | Yes | Task status (foreign key to JTF_TASK_STATUSES) | |
| TASK_STATUS | VARCHAR2 | (30) | Yes | |
| CLOSED | VARCHAR2 | (1) | ||
| CANCELLED | VARCHAR2 | (1) | ||
| COMPLETED | VARCHAR2 | (1) | ||
| REJECTED | VARCHAR2 | (1) | ||
| TASK_PRIORITY_ID | NUMBER | Task priority (foreign key to JTF_TASK_PRIORITIES) | ||
| TASK_PRIORITY | VARCHAR2 | (30) | ||
| OWNER_ID | NUMBER | Yes | Owner of the task | |
| OWNER_TYPE_CODE | VARCHAR2 | (30) | Yes | Resource type identifier of task owner |
| OWNER_TYPE | VARCHAR2 | (30) | Yes | |
| OWNER | VARCHAR2 | (4000) | ||
| SOURCE_OBJECT_ID | NUMBER | Internal ID of source object | ||
| SOURCE_OBJECT_NAME | VARCHAR2 | (80) | User-visible source object identifier | |
| SOURCE_OBJECT_TYPE_CODE | VARCHAR2 | (30) | Type of source object (foreign key to JTF_TASK_OBJECT_TYPES) | |
| SOURCE_OBJECT_TYPE | VARCHAR2 | (30) | Yes | |
| REASON_CODE | VARCHAR2 | (30) | Reason for rejecting a task, reassigning a task, etc. | |
| PRIVATE_FLAG | VARCHAR2 | (1) | Indicates whether the task is private or public | |
| PUBLISH_FLAG | VARCHAR2 | (1) | Indicates whether the task should be published. | |
| NOTIFICATION_FLAG | VARCHAR2 | (1) | Flag indicating whether notification workflow will be automatically launched. | |
| CUSTOMER_ID | NUMBER | Customer associated with task | ||
| 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 | |
| ASSIGNED_BY_ID | NUMBER | User who assigned the task to current owner | ||
| ASSIGNED_BY_NAME | VARCHAR2 | (100) | ||
| CUST_ACCOUNT_ID | NUMBER | Customer account identifier | ||
| ADDRESS_ID | NUMBER | Address Identifier | ||
| PLANNED_START_DATE | DATE | Planned start date | ||
| NOTIFICATION_PERIOD | NUMBER | Time before the scheduled start date that a notification is sent to the assignees | ||
| NOTIFICATION_PERIOD_UOM | VARCHAR2 | (3) | Unit of measure for notification period | |
| PARENT_TASK_ID | VARCHAR2 | (0) | Parent Task's ID | |
| PARENT_TASK_NUMBER | VARCHAR2 | (0) | ||
| RECURRENCE_RULE_ID | NUMBER | Recurrence rule identifier | ||
| ALARM_START | NUMBER | Indicates when the first alarm should be fired | ||
| ALARM_START_UOM | VARCHAR2 | (3) | Unit of measure for ALARM_START | |
| DELETED_FLAG | VARCHAR2 | (1) | Flag indicating the task has been deleted | |
| ACTUAL_START_DATE | DATE | Actual start date | ||
| ACTUAL_END_DATE | DATE | Actual end date | ||
| DURATION | NUMBER | Duration of task | ||
| DURATION_UOM | VARCHAR2 | (3) | Unit of measure for duration | |
| PLANNED_EFFORT | NUMBER | Planned effort | ||
| PLANNED_EFFORT_UOM | VARCHAR2 | (3) | Unit of measure for planned effort | |
| ACTUAL_EFFORT | NUMBER | Actual amount of effort spent on a task by all assignees | ||
| ACTUAL_EFFORT_UOM | VARCHAR2 | (3) | Unit of measure for actual work | |
| PERCENTAGE_COMPLETE | NUMBER | Percentage completion of task | ||
| PLANNED_END_DATE | DATE | Planned end date | ||
| SCHEDULED_START_DATE | DATE | Scheduled start date | ||
| SCHEDULED_END_DATE | DATE | Scheduled end date | ||
| OBJECT_VERSION_NUMBER | NUMBER | Yes | Column used for locking records during updates | |
| OWNER_TERRITORY_ID | NUMBER | Territory identifier of the Owner | ||
| ASSIGNEE_TYPE_CODE | VARCHAR2 | (30) | Assignee type identifier | |
| ASSIGNEE_TYPE | VARCHAR2 | (30) | Assignee Type | |
| ASSIGNEE_ID | NUMBER | Assignee Identifier | ||
| ASSIGN_TO | VARCHAR2 | (4000) | Assign To |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, TASK_ID
, TASK_NUMBER
, TASK_NAME
, DESCRIPTION
, TASK_TYPE_ID
, TASK_TYPE
, TASK_STATUS_ID
, TASK_STATUS
, CLOSED
, CANCELLED
, COMPLETED
, REJECTED
, TASK_PRIORITY_ID
, TASK_PRIORITY
, OWNER_ID
, OWNER_TYPE_CODE
, OWNER_TYPE
, OWNER
, SOURCE_OBJECT_ID
, SOURCE_OBJECT_NAME
, SOURCE_OBJECT_TYPE_CODE
, SOURCE_OBJECT_TYPE
, REASON_CODE
, PRIVATE_FLAG
, PUBLISH_FLAG
, NOTIFICATION_FLAG
, CUSTOMER_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, ASSIGNED_BY_ID
, ASSIGNED_BY_NAME
, CUST_ACCOUNT_ID
, ADDRESS_ID
, PLANNED_START_DATE
, NOTIFICATION_PERIOD
, NOTIFICATION_PERIOD_UOM
, PARENT_TASK_ID
, PARENT_TASK_NUMBER
, RECURRENCE_RULE_ID
, ALARM_START
, ALARM_START_UOM
, DELETED_FLAG
, ACTUAL_START_DATE
, ACTUAL_END_DATE
, DURATION
, DURATION_UOM
, PLANNED_EFFORT
, PLANNED_EFFORT_UOM
, ACTUAL_EFFORT
, ACTUAL_EFFORT_UOM
, PERCENTAGE_COMPLETE
, PLANNED_END_DATE
, SCHEDULED_START_DATE
, SCHEDULED_END_DATE
, OBJECT_VERSION_NUMBER
, OWNER_TERRITORY_ID
, ASSIGNEE_TYPE_CODE
, ASSIGNEE_TYPE
, ASSIGNEE_ID
, ASSIGN_TO
FROM APPS.OKL_CS_TASKS_BALI_UV;
APPS
FND_USER
JTF_OBJECTS_VL
JTF_TASKS_VL
JTF_TASK_ASSIGNMENTS
JTF_TASK_PRIORITIES_TL
JTF_TASK_STATUSES_VL
JTF_TASK_TYPES_TL
JTF_TASK_UTL
- show dependent code
APPS.OKL_CS_TASKS_BALI_UV is not referenced by any database object
|
|
|
|