VIEW: APPS.CS_SR_TASKS_V

Source

View Text - Preformatted

SELECT tsk_vl.ROW_ID, tsk_vl.ATTRIBUTE4, tsk_vl.ATTRIBUTE5, tsk_vl.ATTRIBUTE6, tsk_vl.ATTRIBUTE7, tsk_vl.ATTRIBUTE8, tsk_vl.ATTRIBUTE9, tsk_vl.ATTRIBUTE10, tsk_vl.ATTRIBUTE11, tsk_vl.ATTRIBUTE12, tsk_vl.ATTRIBUTE13, tsk_vl.ATTRIBUTE14, tsk_vl.ATTRIBUTE15, tsk_vl.ATTRIBUTE_CATEGORY, tsk_vl.TASK_ID, tsk_vl.CREATED_BY, tsk_vl.CREATION_DATE, tsk_vl.LAST_UPDATED_BY, tsk_vl.LAST_UPDATE_DATE, tsk_vl.LAST_UPDATE_LOGIN, tsk_vl.TASK_NUMBER, tsk_vl.TASK_TYPE_ID, typ_vl.NAME TASK_TYPE, typ_vl.RULE, tsk_vl.TASK_STATUS_ID, sts_vl.NAME TASK_STATUS, tsk_vl.TASK_PRIORITY_ID, pri_vl.NAME TASK_PRIORITY, tsk_vl.OWNER_ID, jtf_task_utl.get_owner(tsk_vl.owner_type_code, tsk_vl.owner_id) OWNER, tsk_vl.OWNER_TYPE_CODE, obj_vl.NAME OWNER_TYPE, tsk_vl.ASSIGNED_BY_ID, tsk_vl.CUST_ACCOUNT_ID, tsk_vl.CUSTOMER_ID, tsk_vl.ADDRESS_ID, tsk_vl.PLANNED_START_DATE, tsk_vl.PALM_FLAG, tsk_vl.WINCE_FLAG, tsk_vl.LAPTOP_FLAG, tsk_vl.DEVICE1_FLAG, tsk_vl.DEVICE2_FLAG, tsk_vl.DEVICE3_FLAG, tsk_vl.COSTS, tsk_vl.CURRENCY_CODE, tsk_vl.ATTRIBUTE1, tsk_vl.ATTRIBUTE2, tsk_vl.ATTRIBUTE3, tsk_vl.NOTIFICATION_PERIOD, tsk_vl.NOTIFICATION_PERIOD_UOM, tsk_vl.PARENT_TASK_ID, tsk_vl.RECURRENCE_RULE_ID, tsk_vl.ALARM_START, tsk_vl.ALARM_START_UOM, tsk_vl.ALARM_ON, tsk_vl.ALARM_COUNT, tsk_vl.ALARM_FIRED_COUNT, tsk_vl.ALARM_INTERVAL, tsk_vl.ALARM_INTERVAL_UOM, tsk_vl.DELETED_FLAG, tsk_vl.ACTUAL_START_DATE, tsk_vl.ACTUAL_END_DATE, tsk_vl.SOURCE_OBJECT_TYPE_CODE, tsk_vl.TIMEZONE_ID, tsk_vl.SOURCE_OBJECT_ID, tsk_vl.SOURCE_OBJECT_NAME, tsk_vl.DURATION, tsk_vl.DURATION_UOM, tsk_vl.PLANNED_EFFORT, tsk_vl.PLANNED_EFFORT_UOM, tsk_vl.ACTUAL_EFFORT, tsk_vl.ACTUAL_EFFORT_UOM, tsk_vl.PERCENTAGE_COMPLETE, tsk_vl.REASON_CODE, tsk_vl.PRIVATE_FLAG, tsk_vl.PUBLISH_FLAG, tsk_vl.RESTRICT_CLOSURE_FLAG, tsk_vl.MULTI_BOOKED_FLAG, tsk_vl.MILESTONE_FLAG, tsk_vl.HOLIDAY_FLAG, tsk_vl.BILLABLE_FLAG, tsk_vl.BOUND_MODE_CODE, tsk_vl.SOFT_BOUND_FLAG, tsk_vl.WORKFLOW_PROCESS_ID, tsk_vl.NOTIFICATION_FLAG, tsk_vl.PLANNED_END_DATE, tsk_vl.SCHEDULED_START_DATE, tsk_vl.SCHEDULED_END_DATE, tsk_vl.TASK_NAME, tsk_vl.DESCRIPTION, tsk_vl.OBJECT_VERSION_NUMBER, tsk_vl.OWNER_TERRITORY_ID, tsk_vl.ESCALATION_LEVEL, tsk_vl2.task_number parent_task_number, tsk_vl.TASK_CONFIRMATION_STATUS from jtf_tasks_vl tsk_vl, jtf_tasks_b tsk_vl2, jtf_task_statuses_vl sts_vl, jtf_task_types_vl typ_vl, jtf_task_priorities_vl pri_vl, jtf_objects_vl obj_vl WHERE (tsk_vl.deleted_flag <> 'Y' OR tsk_vl.deleted_flag is null) and tsk_vl.task_status_id = sts_vl.task_status_id and tsk_vl.task_priority_id = pri_vl.task_priority_id (+) and tsk_vl.parent_task_id = tsk_vl2.task_id (+) and tsk_vl.task_type_id = typ_vl.task_type_id and tsk_vl.owner_type_code = obj_vl.object_code

View Text - HTML Formatted

SELECT TSK_VL.ROW_ID
, TSK_VL.ATTRIBUTE4
, TSK_VL.ATTRIBUTE5
, TSK_VL.ATTRIBUTE6
, TSK_VL.ATTRIBUTE7
, TSK_VL.ATTRIBUTE8
, TSK_VL.ATTRIBUTE9
, TSK_VL.ATTRIBUTE10
, TSK_VL.ATTRIBUTE11
, TSK_VL.ATTRIBUTE12
, TSK_VL.ATTRIBUTE13
, TSK_VL.ATTRIBUTE14
, TSK_VL.ATTRIBUTE15
, TSK_VL.ATTRIBUTE_CATEGORY
, TSK_VL.TASK_ID
, TSK_VL.CREATED_BY
, TSK_VL.CREATION_DATE
, TSK_VL.LAST_UPDATED_BY
, TSK_VL.LAST_UPDATE_DATE
, TSK_VL.LAST_UPDATE_LOGIN
, TSK_VL.TASK_NUMBER
, TSK_VL.TASK_TYPE_ID
, TYP_VL.NAME TASK_TYPE
, TYP_VL.RULE
, TSK_VL.TASK_STATUS_ID
, STS_VL.NAME TASK_STATUS
, TSK_VL.TASK_PRIORITY_ID
, PRI_VL.NAME TASK_PRIORITY
, TSK_VL.OWNER_ID
, JTF_TASK_UTL.GET_OWNER(TSK_VL.OWNER_TYPE_CODE
, TSK_VL.OWNER_ID) OWNER
, TSK_VL.OWNER_TYPE_CODE
, OBJ_VL.NAME OWNER_TYPE
, TSK_VL.ASSIGNED_BY_ID
, TSK_VL.CUST_ACCOUNT_ID
, TSK_VL.CUSTOMER_ID
, TSK_VL.ADDRESS_ID
, TSK_VL.PLANNED_START_DATE
, TSK_VL.PALM_FLAG
, TSK_VL.WINCE_FLAG
, TSK_VL.LAPTOP_FLAG
, TSK_VL.DEVICE1_FLAG
, TSK_VL.DEVICE2_FLAG
, TSK_VL.DEVICE3_FLAG
, TSK_VL.COSTS
, TSK_VL.CURRENCY_CODE
, TSK_VL.ATTRIBUTE1
, TSK_VL.ATTRIBUTE2
, TSK_VL.ATTRIBUTE3
, TSK_VL.NOTIFICATION_PERIOD
, TSK_VL.NOTIFICATION_PERIOD_UOM
, TSK_VL.PARENT_TASK_ID
, TSK_VL.RECURRENCE_RULE_ID
, TSK_VL.ALARM_START
, TSK_VL.ALARM_START_UOM
, TSK_VL.ALARM_ON
, TSK_VL.ALARM_COUNT
, TSK_VL.ALARM_FIRED_COUNT
, TSK_VL.ALARM_INTERVAL
, TSK_VL.ALARM_INTERVAL_UOM
, TSK_VL.DELETED_FLAG
, TSK_VL.ACTUAL_START_DATE
, TSK_VL.ACTUAL_END_DATE
, TSK_VL.SOURCE_OBJECT_TYPE_CODE
, TSK_VL.TIMEZONE_ID
, TSK_VL.SOURCE_OBJECT_ID
, TSK_VL.SOURCE_OBJECT_NAME
, TSK_VL.DURATION
, TSK_VL.DURATION_UOM
, TSK_VL.PLANNED_EFFORT
, TSK_VL.PLANNED_EFFORT_UOM
, TSK_VL.ACTUAL_EFFORT
, TSK_VL.ACTUAL_EFFORT_UOM
, TSK_VL.PERCENTAGE_COMPLETE
, TSK_VL.REASON_CODE
, TSK_VL.PRIVATE_FLAG
, TSK_VL.PUBLISH_FLAG
, TSK_VL.RESTRICT_CLOSURE_FLAG
, TSK_VL.MULTI_BOOKED_FLAG
, TSK_VL.MILESTONE_FLAG
, TSK_VL.HOLIDAY_FLAG
, TSK_VL.BILLABLE_FLAG
, TSK_VL.BOUND_MODE_CODE
, TSK_VL.SOFT_BOUND_FLAG
, TSK_VL.WORKFLOW_PROCESS_ID
, TSK_VL.NOTIFICATION_FLAG
, TSK_VL.PLANNED_END_DATE
, TSK_VL.SCHEDULED_START_DATE
, TSK_VL.SCHEDULED_END_DATE
, TSK_VL.TASK_NAME
, TSK_VL.DESCRIPTION
, TSK_VL.OBJECT_VERSION_NUMBER
, TSK_VL.OWNER_TERRITORY_ID
, TSK_VL.ESCALATION_LEVEL
, TSK_VL2.TASK_NUMBER PARENT_TASK_NUMBER
, TSK_VL.TASK_CONFIRMATION_STATUS
FROM JTF_TASKS_VL TSK_VL
, JTF_TASKS_B TSK_VL2
, JTF_TASK_STATUSES_VL STS_VL
, JTF_TASK_TYPES_VL TYP_VL
, JTF_TASK_PRIORITIES_VL PRI_VL
, JTF_OBJECTS_VL OBJ_VL
WHERE (TSK_VL.DELETED_FLAG <> 'Y' OR TSK_VL.DELETED_FLAG IS NULL)
AND TSK_VL.TASK_STATUS_ID = STS_VL.TASK_STATUS_ID
AND TSK_VL.TASK_PRIORITY_ID = PRI_VL.TASK_PRIORITY_ID (+)
AND TSK_VL.PARENT_TASK_ID = TSK_VL2.TASK_ID (+)
AND TSK_VL.TASK_TYPE_ID = TYP_VL.TASK_TYPE_ID
AND TSK_VL.OWNER_TYPE_CODE = OBJ_VL.OBJECT_CODE