View: CSD_REPAIR_TASKS_V

Product:	CSD - Depot Repair
Description:	This view is used for the repair tasks tab of the Depot Repair workbench. This shows all the task related information for tasks created with source object "DR".
Implementation/DBA Data:	APPS.CSD_REPAIR_TASKS_V

View Text

SELECT TSK_VL.ROW_ID
, TSK_VL.TASK_ID
, 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
, CSD_PROCESS_UTIL.GET_RES_NAME(SUBSTR(TSK_VL.OWNER_TYPE_CODE
, 4)
, 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.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.CREATED_BY
, TSK_VL.CREATION_DATE
, TSK_VL.LAST_UPDATED_BY
, TSK_VL.LAST_UPDATE_DATE
, TSK_VL.LAST_UPDATE_LOGIN
, 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 /*SANGIGUP R12 DEVELOPMENT */
, APPLICABLE_QA_PLANS
, CT.OBJECT_VERSION_NUMBER RO_TASK_OBJ_VER_NUM
, CT.REPAIR_TASK_ID /*SANGIGUP R12 DEVELOPMENT */
FROM JTF_TASKS_VL TSK_VL
, JTF_TASKS_VL 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 /* SANGIGUP R12 DEVELOPMENT */
, CSD_TASKS CT /*SANGIGUP R12 DEVELOPMENT */
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
AND TSK_VL.SOURCE_OBJECT_TYPE_CODE = 'DR' /*SANGIGUP R12 DEVELOPMENT */
AND TSK_VL.TASK_ID = CT.TASK_ID /*SANGIGUP R12 DEVELOPMENT */

Columns