VIEW: APPS.JTF_TASK_AUDITS_VL

Source

View Text - Preformatted

SELECT B.BILLABLE_CHANGED_FLAG, B.CREATED_BY, B.CREATION_DATE, B.DEVICE1_CHANGED_FLAG, B.DEVICE2_CHANGED_FLAG, B.DEVICE3_CHANGED_FLAG, B.HOLIDAY_CHANGED_FLAG, B.LAPTOP_CHANGED_FLAG, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN, B.MILESTONE_CHANGED_FLAG, B.MULTI_BOOKED_CHANGED_FLAG, B.NEW_ACTUAL_EFFORT, B.NEW_ACTUAL_EFFORT_UOM, B.NEW_ACTUAL_END_DATE, B.NEW_ACTUAL_START_DATE, B.NEW_ADDRESS_ID, B.NEW_ASSIGNED_BY_ID, B.NEW_BOUND_MODE_CODE, B.NEW_COSTS, B.NEW_CURRENCY_CODE, B.NEW_CUSTOMER_ID, B.NEW_CUST_ACCOUNT_ID, B.NEW_DURATION, B.NEW_DURATION_UOM, B.NEW_NOTIFICATION_PERIOD, B.NEW_NOTIFICATION_PERIOD_UOM, B.NEW_ORG_ID, B.NEW_OWNER_ID, B.NEW_OWNER_TYPE_CODE, B.NEW_PARENT_TASK_ID, B.NEW_PERCENTAGE_COMPLETE, B.NEW_PLANNED_EFFORT, B.NEW_PLANNED_EFFORT_UOM, B.NEW_PLANNED_END_DATE, B.NEW_PLANNED_START_DATE, B.NEW_REASON_CODE, B.NEW_RECURRENCE_RULE_ID, B.NEW_SCHEDULED_END_DATE, B.NEW_SCHEDULED_START_DATE, B.NEW_SOURCE_OBJECT_ID, B.NEW_SOURCE_OBJECT_NAME, B.NEW_SOURCE_OBJECT_TYPE_CODE, B.NEW_TASK_PRIORITY_ID, B.NEW_TASK_STATUS_ID, B.NEW_TASK_TYPE_ID, B.NEW_TIMEZONE_ID, B.NEW_WORKFLOW_PROCESS_ID, B.NOTIFICATION_CHANGED_FLAG, B.OLD_ACTUAL_EFFORT, B.OLD_ACTUAL_EFFORT_UOM, B.OLD_ACTUAL_END_DATE, B.OLD_ACTUAL_START_DATE, B.OLD_ADDRESS_ID, B.OLD_ASSIGNED_BY_ID, B.OLD_BOUND_MODE_CODE, B.OLD_COSTS, B.OLD_CURRENCY_CODE, B.OLD_CUSTOMER_ID, B.OLD_CUST_ACCOUNT_ID, B.OLD_DURATION, B.OLD_DURATION_UOM, B.OLD_NOTIFICATION_PERIOD, B.OLD_NOTIFICATION_PERIOD_UOM, B.OLD_ORG_ID, B.OLD_OWNER_ID, B.OLD_OWNER_TYPE_CODE, B.OLD_PARENT_TASK_ID, B.OLD_PERCENTAGE_COMPLETE, B.OLD_PLANNED_EFFORT, B.OLD_PLANNED_EFFORT_UOM, B.OLD_PLANNED_END_DATE, B.OLD_PLANNED_START_DATE, B.OLD_REASON_CODE, B.OLD_RECURRENCE_RULE_ID, B.OLD_SCHEDULED_END_DATE, B.OLD_SCHEDULED_START_DATE, B.OLD_SOURCE_OBJECT_ID, B.OLD_SOURCE_OBJECT_NAME, B.OLD_SOURCE_OBJECT_TYPE_CODE, B.OLD_TASK_PRIORITY_ID, B.OLD_TASK_STATUS_ID, B.OLD_TASK_TYPE_ID, B.OLD_TIMEZONE_ID, B.OLD_WORKFLOW_PROCESS_ID, B.PALM_CHANGED_FLAG, B.PRIVATE_CHANGED_FLAG, B.PUBLISH_CHANGED_FLAG, B.RESTRICT_CLOSURE_CHANGE_FLAG, B.ROWID ROW_ID, B.SOFT_BOUND_CHANGED_FLAG, B.TASK_AUDIT_ID, B.TASK_ID, B.WINCE_CHANGED_FLAG, T.NEW_DESCRIPTION, T.NEW_TASK_NAME, T.OLD_DESCRIPTION, T.OLD_TASK_NAME, B.old_owner_territory_id, B.new_owner_territory_id , b.old_escalation_level , b.new_escalation_level, b.old_location_id, b.new_location_id from JTF_TASK_AUDITS_TL T, JTF_TASK_AUDITS_B B WHERE B.TASK_AUDIT_ID = T.TASK_AUDIT_ID and T.LANGUAGE = userenv('LANG')

View Text - HTML Formatted

SELECT B.BILLABLE_CHANGED_FLAG
, B.CREATED_BY
, B.CREATION_DATE
, B.DEVICE1_CHANGED_FLAG
, B.DEVICE2_CHANGED_FLAG
, B.DEVICE3_CHANGED_FLAG
, B.HOLIDAY_CHANGED_FLAG
, B.LAPTOP_CHANGED_FLAG
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATE_LOGIN
, B.MILESTONE_CHANGED_FLAG
, B.MULTI_BOOKED_CHANGED_FLAG
, B.NEW_ACTUAL_EFFORT
, B.NEW_ACTUAL_EFFORT_UOM
, B.NEW_ACTUAL_END_DATE
, B.NEW_ACTUAL_START_DATE
, B.NEW_ADDRESS_ID
, B.NEW_ASSIGNED_BY_ID
, B.NEW_BOUND_MODE_CODE
, B.NEW_COSTS
, B.NEW_CURRENCY_CODE
, B.NEW_CUSTOMER_ID
, B.NEW_CUST_ACCOUNT_ID
, B.NEW_DURATION
, B.NEW_DURATION_UOM
, B.NEW_NOTIFICATION_PERIOD
, B.NEW_NOTIFICATION_PERIOD_UOM
, B.NEW_ORG_ID
, B.NEW_OWNER_ID
, B.NEW_OWNER_TYPE_CODE
, B.NEW_PARENT_TASK_ID
, B.NEW_PERCENTAGE_COMPLETE
, B.NEW_PLANNED_EFFORT
, B.NEW_PLANNED_EFFORT_UOM
, B.NEW_PLANNED_END_DATE
, B.NEW_PLANNED_START_DATE
, B.NEW_REASON_CODE
, B.NEW_RECURRENCE_RULE_ID
, B.NEW_SCHEDULED_END_DATE
, B.NEW_SCHEDULED_START_DATE
, B.NEW_SOURCE_OBJECT_ID
, B.NEW_SOURCE_OBJECT_NAME
, B.NEW_SOURCE_OBJECT_TYPE_CODE
, B.NEW_TASK_PRIORITY_ID
, B.NEW_TASK_STATUS_ID
, B.NEW_TASK_TYPE_ID
, B.NEW_TIMEZONE_ID
, B.NEW_WORKFLOW_PROCESS_ID
, B.NOTIFICATION_CHANGED_FLAG
, B.OLD_ACTUAL_EFFORT
, B.OLD_ACTUAL_EFFORT_UOM
, B.OLD_ACTUAL_END_DATE
, B.OLD_ACTUAL_START_DATE
, B.OLD_ADDRESS_ID
, B.OLD_ASSIGNED_BY_ID
, B.OLD_BOUND_MODE_CODE
, B.OLD_COSTS
, B.OLD_CURRENCY_CODE
, B.OLD_CUSTOMER_ID
, B.OLD_CUST_ACCOUNT_ID
, B.OLD_DURATION
, B.OLD_DURATION_UOM
, B.OLD_NOTIFICATION_PERIOD
, B.OLD_NOTIFICATION_PERIOD_UOM
, B.OLD_ORG_ID
, B.OLD_OWNER_ID
, B.OLD_OWNER_TYPE_CODE
, B.OLD_PARENT_TASK_ID
, B.OLD_PERCENTAGE_COMPLETE
, B.OLD_PLANNED_EFFORT
, B.OLD_PLANNED_EFFORT_UOM
, B.OLD_PLANNED_END_DATE
, B.OLD_PLANNED_START_DATE
, B.OLD_REASON_CODE
, B.OLD_RECURRENCE_RULE_ID
, B.OLD_SCHEDULED_END_DATE
, B.OLD_SCHEDULED_START_DATE
, B.OLD_SOURCE_OBJECT_ID
, B.OLD_SOURCE_OBJECT_NAME
, B.OLD_SOURCE_OBJECT_TYPE_CODE
, B.OLD_TASK_PRIORITY_ID
, B.OLD_TASK_STATUS_ID
, B.OLD_TASK_TYPE_ID
, B.OLD_TIMEZONE_ID
, B.OLD_WORKFLOW_PROCESS_ID
, B.PALM_CHANGED_FLAG
, B.PRIVATE_CHANGED_FLAG
, B.PUBLISH_CHANGED_FLAG
, B.RESTRICT_CLOSURE_CHANGE_FLAG
, B.ROWID ROW_ID
, B.SOFT_BOUND_CHANGED_FLAG
, B.TASK_AUDIT_ID
, B.TASK_ID
, B.WINCE_CHANGED_FLAG
, T.NEW_DESCRIPTION
, T.NEW_TASK_NAME
, T.OLD_DESCRIPTION
, T.OLD_TASK_NAME
, B.OLD_OWNER_TERRITORY_ID
, B.NEW_OWNER_TERRITORY_ID
, B.OLD_ESCALATION_LEVEL
, B.NEW_ESCALATION_LEVEL
, B.OLD_LOCATION_ID
, B.NEW_LOCATION_ID
FROM JTF_TASK_AUDITS_TL T
, JTF_TASK_AUDITS_B B
WHERE B.TASK_AUDIT_ID = T.TASK_AUDIT_ID
AND T.LANGUAGE = USERENV('LANG')