VIEW: APPS.CSM_TASK_ASSIGNMENTS_AUDIT_V

Source

View Text - Preformatted

SELECT ACC. ACCESS_ID ,B.ASSIGNMENT_AUDIT_ID ,B.ASSIGNMENT_ID ,B.TASK_ID ,B.OLD_RESOURCE_TYPE_CODE ,B.NEW_RESOURCE_TYPE_CODE ,B.OLD_RESOURCE_ID ,B.NEW_RESOURCE_ID ,B.OLD_ASSIGNMENT_STATUS_ID ,B.NEW_ASSIGNMENT_STATUS_ID ,B.OLD_ACTUAL_START_DATE ,B.NEW_ACTUAL_START_DATE ,B.OLD_ACTUAL_END_DATE ,B.NEW_ACTUAL_END_DATE ,B.OLD_SCHED_TRAVEL_DISTANCE ,B.NEW_SCHED_TRAVEL_DISTANCE ,B.OLD_SCHED_TRAVEL_DURATION ,B.NEW_SCHED_TRAVEL_DURATION ,B.OLD_SCHED_TRAVEL_DURATION_UOM ,B.NEW_SCHED_TRAVEL_DURATION_UOM ,B.OLD_ACTUAL_TRAVEL_DISTANCE ,B.NEW_ACTUAL_TRAVEL_DISTANCE ,B.OLD_ACTUAL_TRAVEL_DURATION ,B.NEW_ACTUAL_TRAVEL_DURATION ,B.OLD_ACTUAL_TRAVEL_DURATION_UOM ,B.NEW_ACTUAL_TRAVEL_DURATION_UOM ,B.CREATED_BY ,B.CREATION_DATE ,B.LAST_UPDATED_BY ,B.LAST_UPDATE_LOGIN ,B.LAST_UPDATE_DATE FROM JTF_TASK_ASSIGNMENTS_AUDIT_B B, CSM_TASK_ASSIGNMENTS_AUDIT_ACC ACC WHERE B.ASSIGNMENT_AUDIT_ID = ACC.ASSIGNMENT_AUDIT_ID AND ACC.USER_ID = ASG_BASE.GET_USER_ID

View Text - HTML Formatted

SELECT ACC. ACCESS_ID
, B.ASSIGNMENT_AUDIT_ID
, B.ASSIGNMENT_ID
, B.TASK_ID
, B.OLD_RESOURCE_TYPE_CODE
, B.NEW_RESOURCE_TYPE_CODE
, B.OLD_RESOURCE_ID
, B.NEW_RESOURCE_ID
, B.OLD_ASSIGNMENT_STATUS_ID
, B.NEW_ASSIGNMENT_STATUS_ID
, B.OLD_ACTUAL_START_DATE
, B.NEW_ACTUAL_START_DATE
, B.OLD_ACTUAL_END_DATE
, B.NEW_ACTUAL_END_DATE
, B.OLD_SCHED_TRAVEL_DISTANCE
, B.NEW_SCHED_TRAVEL_DISTANCE
, B.OLD_SCHED_TRAVEL_DURATION
, B.NEW_SCHED_TRAVEL_DURATION
, B.OLD_SCHED_TRAVEL_DURATION_UOM
, B.NEW_SCHED_TRAVEL_DURATION_UOM
, B.OLD_ACTUAL_TRAVEL_DISTANCE
, B.NEW_ACTUAL_TRAVEL_DISTANCE
, B.OLD_ACTUAL_TRAVEL_DURATION
, B.NEW_ACTUAL_TRAVEL_DURATION
, B.OLD_ACTUAL_TRAVEL_DURATION_UOM
, B.NEW_ACTUAL_TRAVEL_DURATION_UOM
, B.CREATED_BY
, B.CREATION_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_LOGIN
, B.LAST_UPDATE_DATE
FROM JTF_TASK_ASSIGNMENTS_AUDIT_B B
, CSM_TASK_ASSIGNMENTS_AUDIT_ACC ACC
WHERE B.ASSIGNMENT_AUDIT_ID = ACC.ASSIGNMENT_AUDIT_ID
AND ACC.USER_ID = ASG_BASE.GET_USER_ID