DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.JTF_TASKS_VL

Object Details
Object Name: JTF_TASKS_VL
Object Type: VIEW
Owner: APPS
FND Design Data: ViewJTF.JTF_TASKS_VL
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


MLS View for JTF_TASKS_B and JTF_TASKS_TL


[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Row Identifier
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE_CATEGORY VARCHAR2 (150)
Descriptive flexfield structure definition column.
TASK_ID NUMBER
Yes Unique task identifier (PK)
CREATED_BY NUMBER (15) Yes Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Yes Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Yes Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
TASK_NUMBER VARCHAR2 (30) Yes Task Number
TASK_TYPE_ID NUMBER
Yes Task type (foreign key to JTF_TASK_TYPES)
TASK_STATUS_ID NUMBER
Yes Task status (foreign key to JTF_TASK_STATUSES)
TASK_PRIORITY_ID NUMBER

Task priority (foreign key to JTF_TASK_PRIORITIES)
OWNER_ID NUMBER
Yes Owner of the task
OWNER_TYPE_CODE VARCHAR2 (30) Yes Resource type identifier of task owner
ASSIGNED_BY_ID NUMBER

User who assigned the task to current owner
CUST_ACCOUNT_ID NUMBER

Customer account identifier
CUSTOMER_ID NUMBER

Customer associated with task
ADDRESS_ID NUMBER

Address Identifier
PLANNED_START_DATE DATE

Planned start date
PALM_FLAG VARCHAR2 (1)
Used by Mobile Device
WINCE_FLAG VARCHAR2 (1)
Used by Mobile Device
LAPTOP_FLAG VARCHAR2 (1)
Used by Mobile Device
DEVICE1_FLAG VARCHAR2 (1)
Used by Mobile Device
DEVICE2_FLAG VARCHAR2 (1)
Used by Mobile Device
DEVICE3_FLAG VARCHAR2 (1)
Used by Mobile Device
COSTS NUMBER

Used by Marketing
CURRENCY_CODE VARCHAR2 (15)
Used by Marketing
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
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 NUMBER

Parent Task's ID
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
ALARM_ON VARCHAR2 (1)
Indicates whether the alarm is on
ALARM_COUNT NUMBER

Total number of alarms to fire
ALARM_FIRED_COUNT NUMBER

Number of alarms fired
ALARM_INTERVAL NUMBER

Alarm interval
ALARM_INTERVAL_UOM VARCHAR2 (3)
Unit of measure for Alarm Interval
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
SOURCE_OBJECT_TYPE_CODE VARCHAR2 (30)
Type of source object (foreign key to JTF_TASK_OBJECT_TYPES)
TIMEZONE_ID NUMBER

Time zone identifier
SOURCE_OBJECT_ID NUMBER

Internal ID of source object
SOURCE_OBJECT_NAME VARCHAR2 (80)
User-visible source object identifier
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
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.
RESTRICT_CLOSURE_FLAG VARCHAR2 (1)
Indicates whether completing the task is necessary for the source object to be deemed complete
MULTI_BOOKED_FLAG VARCHAR2 (1)
Indicates whether the task can book resources that are already assigned to other tasks
MILESTONE_FLAG VARCHAR2 (1)
Indicates whether the task is a milestone delivery date
HOLIDAY_FLAG VARCHAR2 (1)
Indicates whether the task can be performed on holidays
BILLABLE_FLAG VARCHAR2 (1)
Indicates whether the task is billable.
BOUND_MODE_CODE VARCHAR2 (30)
Used for Scheduling.
SOFT_BOUND_FLAG VARCHAR2 (1)
Used for Scheduling.
WORKFLOW_PROCESS_ID NUMBER

Identifier of last workflow process launched for this task
NOTIFICATION_FLAG VARCHAR2 (1)
Flag indicating whether notification workflow will be automatically launched.
PLANNED_END_DATE DATE

Planned end date
SCHEDULED_START_DATE DATE

Scheduled start date
SCHEDULED_END_DATE DATE

Scheduled end date
TASK_NAME VARCHAR2 (80) Yes Task Name
DESCRIPTION VARCHAR2 (4000)
Task Description
OBJECT_VERSION_NUMBER NUMBER
Yes Sequential number used for database locking control when using HTML as a user interface
OWNER_TERRITORY_ID NUMBER

Territory identifier of the Owner
ESCALATION_LEVEL VARCHAR2 (30)
Escalation Level
CALENDAR_START_DATE DATE

Calendar start date (derivated)
CALENDAR_END_DATE DATE

Calendar end date (derivated)
DATE_SELECTED VARCHAR2 (1)
Indicate default date pair
TEMPLATE_ID NUMBER

Reference to task template
TEMPLATE_GROUP_ID NUMBER

Reference to task template group
OPEN_FLAG VARCHAR2 (1)
This column is used to indicate whether the task is open or closed
TASK_CONFIRMATION_STATUS VARCHAR2 (1)
Customer confirmation status
TASK_CONFIRMATION_COUNTER NUMBER

Customer confirmation counter
TASK_SPLIT_FLAG VARCHAR2 (1)
Marks split tasks
ENTITY VARCHAR2 (30) Yes Entity of the task
CHILD_POSITION VARCHAR2 (1)
To hold the position of child in respect to the parent
CHILD_SEQUENCE_NUM NUMBER (15)
To hold the sequence number in the dependency chain for the parent
LOCATION_ID NUMBER

Location Identifier
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ROW_ID
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE_CATEGORY
,      TASK_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      TASK_NUMBER
,      TASK_TYPE_ID
,      TASK_STATUS_ID
,      TASK_PRIORITY_ID
,      OWNER_ID
,      OWNER_TYPE_CODE
,      ASSIGNED_BY_ID
,      CUST_ACCOUNT_ID
,      CUSTOMER_ID
,      ADDRESS_ID
,      PLANNED_START_DATE
,      PALM_FLAG
,      WINCE_FLAG
,      LAPTOP_FLAG
,      DEVICE1_FLAG
,      DEVICE2_FLAG
,      DEVICE3_FLAG
,      COSTS
,      CURRENCY_CODE
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      NOTIFICATION_PERIOD
,      NOTIFICATION_PERIOD_UOM
,      PARENT_TASK_ID
,      RECURRENCE_RULE_ID
,      ALARM_START
,      ALARM_START_UOM
,      ALARM_ON
,      ALARM_COUNT
,      ALARM_FIRED_COUNT
,      ALARM_INTERVAL
,      ALARM_INTERVAL_UOM
,      DELETED_FLAG
,      ACTUAL_START_DATE
,      ACTUAL_END_DATE
,      SOURCE_OBJECT_TYPE_CODE
,      TIMEZONE_ID
,      SOURCE_OBJECT_ID
,      SOURCE_OBJECT_NAME
,      DURATION
,      DURATION_UOM
,      PLANNED_EFFORT
,      PLANNED_EFFORT_UOM
,      ACTUAL_EFFORT
,      ACTUAL_EFFORT_UOM
,      PERCENTAGE_COMPLETE
,      REASON_CODE
,      PRIVATE_FLAG
,      PUBLISH_FLAG
,      RESTRICT_CLOSURE_FLAG
,      MULTI_BOOKED_FLAG
,      MILESTONE_FLAG
,      HOLIDAY_FLAG
,      BILLABLE_FLAG
,      BOUND_MODE_CODE
,      SOFT_BOUND_FLAG
,      WORKFLOW_PROCESS_ID
,      NOTIFICATION_FLAG
,      PLANNED_END_DATE
,      SCHEDULED_START_DATE
,      SCHEDULED_END_DATE
,      TASK_NAME
,      DESCRIPTION
,      OBJECT_VERSION_NUMBER
,      OWNER_TERRITORY_ID
,      ESCALATION_LEVEL
,      CALENDAR_START_DATE
,      CALENDAR_END_DATE
,      DATE_SELECTED
,      TEMPLATE_ID
,      TEMPLATE_GROUP_ID
,      OPEN_FLAG
,      TASK_CONFIRMATION_STATUS
,      TASK_CONFIRMATION_COUNTER
,      TASK_SPLIT_FLAG
,      ENTITY
,      CHILD_POSITION
,      CHILD_SEQUENCE_NUM
,      LOCATION_ID
FROM APPS.JTF_TASKS_VL;

Dependencies

[top of page]

APPS.JTF_TASKS_VL references the following:

SchemaAPPS
SynonymJTF_TASKS_B
SynonymJTF_TASKS_TL
APPS.JTF_TASKS_VL is referenced by following:

SchemaAPPS
Package BodyAMS_COPYELEMENTS_PVT - show dependent code
Package BodyAMS_TASK_PVT - show dependent code
Package BodyASO_TASK_INT - show dependent code
Package BodyASP_ALERTS_SUBS - show dependent code
Package BodyASP_SERVICE_CONTENT_PROVIDER - show dependent code
ViewAST_TASKREF_V
ViewAST_TASKS_MAIN_V
ViewAST_TASKS_V
Package BodyAS_SALES_METH_WF - show dependent code
Package BodyCAC_SYNC_TASK_COMMON - show dependent code
Package BodyCAC_VIEW_ACC_DAILY_VIEW_PVT - show dependent code
Package BodyCAC_VIEW_PVT - show dependent code
Package BodyCAC_VIEW_WF_PVT - show dependent code
ViewCSC_TASKS_V
Package BodyCSD_MIGRATE_FROM_115X_PKG3 - show dependent code
Package BodyCSD_MIGRATE_FROM_115X_PKG6 - show dependent code
Package BodyCSD_PROCESS_UTIL - show dependent code
ViewCSD_REPAIR_TASKS_V
PL/SQL PackageCSF_ALERTS_PUB - show dependent code
Package BodyCSF_ALERTS_PUB - show dependent code
ViewCSF_DEBRIEF_HEADERS_V
Package BodyCSF_DEBRIEF_PVT - show dependent code
ViewCSF_DEBRIEF_SRC_NUMBERS_V
ViewCSF_DEBRIEF_TASKS_V
Package BodyCSF_TASKS_PUB - show dependent code
Package BodyCSF_TRIPS_PUB - show dependent code
ViewCSP_REQUIRED_PARTS_V
ViewCSP_SPARES_ORDERS_OM_V
Package BodyCSP_TO_FORM_MOLINES - show dependent code
Package BodyCS_CHG_AUTO_SUB_CON_PKG - show dependent code
Package BodyCS_SERVICEREQUEST_UTIL - show dependent code
Package BodyCS_SR_CHILD_AUDIT_PKG - show dependent code
Package BodyCS_SR_LOG_DATA_TEMP_PVT - show dependent code
ViewCS_SR_TASKS_V
ViewCS_SR_TASK_TERRITORY_V
Package BodyCS_WF_EVENT_SUBSCRIPTIONS_PKG - show dependent code
Package BodyCUG_GENERIC_WF_PKG - show dependent code
Package BodyIEU_WP_MSG_ACTIONS - show dependent code
Package BodyIEX_OPI_PVT - show dependent code
Package BodyIEX_PROMISES_BATCH_PUB - show dependent code
ViewIEX_PROMISES_UWQ_V
ViewIEX_TASKREF_V
ViewIEX_TASKS_V
Package BodyJTA_SYNC_TASK_COMMON - show dependent code
ViewJTF_AM_TASK_DTLS_V
PL/SQL PackageJTF_AM_WF_EVENTS_PUB - show dependent code
Package BodyJTF_AM_WF_EVENTS_PUB - show dependent code
PL/SQL PackageJTF_ASSIGN_PUB - show dependent code
Package BodyJTF_ASSIGN_PUB - show dependent code
Package BodyJTF_CAL_WF_PVT - show dependent code
Package BodyJTF_EC_PVT - show dependent code
Package BodyJTF_EC_REFERENCES_PVT - show dependent code
PL/SQL PackageJTF_EC_WORKFLOW_PKG - show dependent code
Package BodyJTF_EC_WORKFLOW_PKG - show dependent code
ViewJTF_ESCALATION_TASK_V
Package BodyJTF_ESCWFACTIVITY_PVT - show dependent code
Package BodyJTF_TASKS_PKG - show dependent code
PL/SQL PackageJTF_TASKS_PUB - show dependent code
Package BodyJTF_TASKS_PUB - show dependent code
Package BodyJTF_TASKS_PVT - show dependent code
ViewJTF_TASKS_V
Package BodyJTF_TASK_AUDITS_PVT - show dependent code
Package BodyJTF_TASK_CONFIRMATION_PUB - show dependent code
ViewJTF_TASK_DEPENDS_V
Package BodyJTF_TASK_TEMPLATES_UTL - show dependent code
ViewJTF_TASK_TERRITORY_V
Package BodyJTF_TASK_UTL - show dependent code
Package BodyJTF_TASK_UTL_EXT - show dependent code
Package BodyJTF_TASK_WORKFLOW_PKG - show dependent code
Package BodyOKC_TASK_ALERT_ESCL_PVT - show dependent code
ViewOKL_CS_TASKS_BALI_UV
ViewOKL_CS_TASKS_MAIN_UV
Package BodyOZF_CLAIM_PVT - show dependent code
Package BodyPER_ABS_SHADOW_BOOKING_PKG - show dependent code