VIEW: APPS.CSM_TASK_ASSIGNMENTS_V

Source

View Text - Preformatted

SELECT CSM_UTIL_PKG.GET_NUMBER(ACC.ACCESS_ID), JTA.TASK_ASSIGNMENT_ID, CSM_UTIL_PKG.GET_NUMBER(JTA.TASK_ID), CSM_UTIL_PKG.GET_NUMBER(JTA.ASSIGNMENT_STATUS_ID), JTA.ACTUAL_START_DATE, JTA.ACTUAL_END_DATE, CSM_UTIL_PKG.GET_DATE(JTA.LAST_UPDATE_DATE), CSM_UTIL_PKG.GET_NUMBER(JTA.RESOURCE_ID) ,NVL(JTA.OBJECT_VERSION_NUMBER, JTA.OBJECT_VERSION_NUMBER) ,NVL(JTA.RESOURCE_TYPE_CODE, JTA.RESOURCE_TYPE_CODE) ,JTA.SCHED_TRAVEL_DISTANCE, JTA.SCHED_TRAVEL_DURATION ,JTA.SCHED_TRAVEL_DURATION_UOM ,JTA.ACTUAL_TRAVEL_DISTANCE ,JTA.ACTUAL_TRAVEL_DURATION, JTA.ACTUAL_TRAVEL_DURATION_UOM ,JTA.ATTRIBUTE1,JTA.ATTRIBUTE2,JTA.ATTRIBUTE3,JTA.ATTRIBUTE4,JTA.ATTRIBUTE5 ,JTA.ATTRIBUTE6,JTA.ATTRIBUTE7,JTA.ATTRIBUTE8,JTA.ATTRIBUTE9,JTA.ATTRIBUTE10 ,JTA.ATTRIBUTE11,JTA.ATTRIBUTE12,JTA.ATTRIBUTE13,JTA.ATTRIBUTE14 ,ATTRIBUTE15,JTA.ATTRIBUTE_CATEGORY,CSM_UTIL_PKG.GET_NUMBER(JTA.CREATED_BY) AS CREATED_BY,CSM_UTIL_PKG.GET_NUMBER(JTA.LAST_UPDATED_BY) AS LAST_UPDATED_BY, CSM_UTIL_PKG.GET_DATE(JTA.LAST_UPDATE_DATE) AS SERVER_LAST_UPDATE_DATE, JTA.OBJECT_CAPACITY_ID AS TRIP_ID, cast(TO_CHAR(NULL) AS VARCHAR2(1)) as UNDO_FLAG FROM CSM_TASK_ASSIGNMENTS_ACC ACC, JTF_TASK_ASSIGNMENTS JTA WHERE ACC.USER_ID = ASG_BASE.GET_USER_ID AND ACC.TASK_ASSIGNMENT_ID = JTA.TASK_ASSIGNMENT_ID

View Text - HTML Formatted

SELECT CSM_UTIL_PKG.GET_NUMBER(ACC.ACCESS_ID)
, JTA.TASK_ASSIGNMENT_ID
, CSM_UTIL_PKG.GET_NUMBER(JTA.TASK_ID)
, CSM_UTIL_PKG.GET_NUMBER(JTA.ASSIGNMENT_STATUS_ID)
, JTA.ACTUAL_START_DATE
, JTA.ACTUAL_END_DATE
, CSM_UTIL_PKG.GET_DATE(JTA.LAST_UPDATE_DATE)
, CSM_UTIL_PKG.GET_NUMBER(JTA.RESOURCE_ID)
, NVL(JTA.OBJECT_VERSION_NUMBER
, JTA.OBJECT_VERSION_NUMBER)
, NVL(JTA.RESOURCE_TYPE_CODE
, JTA.RESOURCE_TYPE_CODE)
, JTA.SCHED_TRAVEL_DISTANCE
, JTA.SCHED_TRAVEL_DURATION
, JTA.SCHED_TRAVEL_DURATION_UOM
, JTA.ACTUAL_TRAVEL_DISTANCE
, JTA.ACTUAL_TRAVEL_DURATION
, JTA.ACTUAL_TRAVEL_DURATION_UOM
, JTA.ATTRIBUTE1
, JTA.ATTRIBUTE2
, JTA.ATTRIBUTE3
, JTA.ATTRIBUTE4
, JTA.ATTRIBUTE5
, JTA.ATTRIBUTE6
, JTA.ATTRIBUTE7
, JTA.ATTRIBUTE8
, JTA.ATTRIBUTE9
, JTA.ATTRIBUTE10
, JTA.ATTRIBUTE11
, JTA.ATTRIBUTE12
, JTA.ATTRIBUTE13
, JTA.ATTRIBUTE14
, ATTRIBUTE15
, JTA.ATTRIBUTE_CATEGORY
, CSM_UTIL_PKG.GET_NUMBER(JTA.CREATED_BY) AS CREATED_BY
, CSM_UTIL_PKG.GET_NUMBER(JTA.LAST_UPDATED_BY) AS LAST_UPDATED_BY
, CSM_UTIL_PKG.GET_DATE(JTA.LAST_UPDATE_DATE) AS SERVER_LAST_UPDATE_DATE
, JTA.OBJECT_CAPACITY_ID AS TRIP_ID
, CAST(TO_CHAR(NULL) AS VARCHAR2(1)) AS UNDO_FLAG
FROM CSM_TASK_ASSIGNMENTS_ACC ACC
, JTF_TASK_ASSIGNMENTS JTA
WHERE ACC.USER_ID = ASG_BASE.GET_USER_ID
AND ACC.TASK_ASSIGNMENT_ID = JTA.TASK_ASSIGNMENT_ID