eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: JTF.JTF_TASK_AUDITS_B#

Source

View Text - Preformatted


select TASK_AUDIT_ID TASK_AUDIT_ID, TASK_ID TASK_ID, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, OLD_TASK_TYPE_ID OLD_TASK_TYPE_ID, NEW_TASK_TYPE_ID NEW_TASK_TYPE_ID, OLD_TASK_STATUS_ID OLD_TASK_STATUS_ID, NEW_TASK_STATUS_ID NEW_TASK_STATUS_ID, OLD_TASK_PRIORITY_ID OLD_TASK_PRIORITY_ID, NEW_TASK_PRIORITY_ID NEW_TASK_PRIORITY_ID, OLD_OWNER_ID OLD_OWNER_ID, NEW_OWNER_ID NEW_OWNER_ID, OLD_OWNER_TYPE_CODE OLD_OWNER_TYPE_CODE, NEW_OWNER_TYPE_CODE NEW_OWNER_TYPE_CODE, OLD_ASSIGNED_BY_ID OLD_ASSIGNED_BY_ID, NEW_ASSIGNED_BY_ID NEW_ASSIGNED_BY_ID, OLD_CUST_ACCOUNT_ID OLD_CUST_ACCOUNT_ID, NEW_CUST_ACCOUNT_ID NEW_CUST_ACCOUNT_ID, OLD_CUSTOMER_ID OLD_CUSTOMER_ID, NEW_CUSTOMER_ID NEW_CUSTOMER_ID, OLD_ADDRESS_ID OLD_ADDRESS_ID, NEW_ADDRESS_ID NEW_ADDRESS_ID, OLD_PLANNED_START_DATE OLD_PLANNED_START_DATE, NEW_PLANNED_START_DATE NEW_PLANNED_START_DATE, OLD_PLANNED_END_DATE OLD_PLANNED_END_DATE, NEW_PLANNED_END_DATE NEW_PLANNED_END_DATE, OLD_SCHEDULED_START_DATE OLD_SCHEDULED_START_DATE, NEW_SCHEDULED_START_DATE NEW_SCHEDULED_START_DATE, OLD_SCHEDULED_END_DATE OLD_SCHEDULED_END_DATE, NEW_SCHEDULED_END_DATE NEW_SCHEDULED_END_DATE, OLD_ACTUAL_START_DATE OLD_ACTUAL_START_DATE, NEW_ACTUAL_START_DATE NEW_ACTUAL_START_DATE, OLD_ACTUAL_END_DATE OLD_ACTUAL_END_DATE, NEW_ACTUAL_END_DATE NEW_ACTUAL_END_DATE, OLD_SOURCE_OBJECT_TYPE_CODE OLD_SOURCE_OBJECT_TYPE_CODE, NEW_SOURCE_OBJECT_TYPE_CODE NEW_SOURCE_OBJECT_TYPE_CODE, OLD_TIMEZONE_ID OLD_TIMEZONE_ID, NEW_TIMEZONE_ID NEW_TIMEZONE_ID, OLD_SOURCE_OBJECT_ID OLD_SOURCE_OBJECT_ID, NEW_SOURCE_OBJECT_ID NEW_SOURCE_OBJECT_ID, OLD_SOURCE_OBJECT_NAME OLD_SOURCE_OBJECT_NAME, NEW_SOURCE_OBJECT_NAME NEW_SOURCE_OBJECT_NAME, OLD_DURATION OLD_DURATION, NEW_DURATION NEW_DURATION, OLD_DURATION_UOM OLD_DURATION_UOM, NEW_DURATION_UOM NEW_DURATION_UOM, OLD_PLANNED_EFFORT OLD_PLANNED_EFFORT, NEW_PLANNED_EFFORT NEW_PLANNED_EFFORT, OLD_PLANNED_EFFORT_UOM OLD_PLANNED_EFFORT_UOM, NEW_PLANNED_EFFORT_UOM NEW_PLANNED_EFFORT_UOM, OLD_ACTUAL_EFFORT OLD_ACTUAL_EFFORT, NEW_ACTUAL_EFFORT NEW_ACTUAL_EFFORT, OLD_ACTUAL_EFFORT_UOM OLD_ACTUAL_EFFORT_UOM, NEW_ACTUAL_EFFORT_UOM NEW_ACTUAL_EFFORT_UOM, OLD_PERCENTAGE_COMPLETE OLD_PERCENTAGE_COMPLETE, NEW_PERCENTAGE_COMPLETE NEW_PERCENTAGE_COMPLETE, OLD_REASON_CODE OLD_REASON_CODE, NEW_REASON_CODE NEW_REASON_CODE, PRIVATE_CHANGED_FLAG PRIVATE_CHANGED_FLAG, PUBLISH_CHANGED_FLAG PUBLISH_CHANGED_FLAG, RESTRICT_CLOSURE_CHANGE_FLAG RESTRICT_CLOSURE_CHANGE_FLAG, MULTI_BOOKED_CHANGED_FLAG MULTI_BOOKED_CHANGED_FLAG, MILESTONE_CHANGED_FLAG MILESTONE_CHANGED_FLAG, HOLIDAY_CHANGED_FLAG HOLIDAY_CHANGED_FLAG, BILLABLE_CHANGED_FLAG BILLABLE_CHANGED_FLAG, OLD_BOUND_MODE_CODE OLD_BOUND_MODE_CODE, NEW_BOUND_MODE_CODE NEW_BOUND_MODE_CODE, SOFT_BOUND_CHANGED_FLAG SOFT_BOUND_CHANGED_FLAG, OLD_WORKFLOW_PROCESS_ID OLD_WORKFLOW_PROCESS_ID, NEW_WORKFLOW_PROCESS_ID NEW_WORKFLOW_PROCESS_ID, NOTIFICATION_CHANGED_FLAG NOTIFICATION_CHANGED_FLAG, OLD_NOTIFICATION_PERIOD OLD_NOTIFICATION_PERIOD, NEW_NOTIFICATION_PERIOD NEW_NOTIFICATION_PERIOD, OLD_NOTIFICATION_PERIOD_UOM OLD_NOTIFICATION_PERIOD_UOM, NEW_NOTIFICATION_PERIOD_UOM NEW_NOTIFICATION_PERIOD_UOM, OLD_PARENT_TASK_ID OLD_PARENT_TASK_ID, NEW_PARENT_TASK_ID NEW_PARENT_TASK_ID, OLD_RECURRENCE_RULE_ID OLD_RECURRENCE_RULE_ID, NEW_RECURRENCE_RULE_ID NEW_RECURRENCE_RULE_ID, PALM_CHANGED_FLAG PALM_CHANGED_FLAG, WINCE_CHANGED_FLAG WINCE_CHANGED_FLAG, LAPTOP_CHANGED_FLAG LAPTOP_CHANGED_FLAG, DEVICE1_CHANGED_FLAG DEVICE1_CHANGED_FLAG, DEVICE2_CHANGED_FLAG DEVICE2_CHANGED_FLAG, DEVICE3_CHANGED_FLAG DEVICE3_CHANGED_FLAG, OLD_CURRENCY_CODE OLD_CURRENCY_CODE, NEW_CURRENCY_CODE NEW_CURRENCY_CODE, OLD_COSTS OLD_COSTS, NEW_COSTS NEW_COSTS, OLD_ORG_ID OLD_ORG_ID, NEW_ORG_ID NEW_ORG_ID, NEW_OWNER_TERRITORY_ID NEW_OWNER_TERRITORY_ID, OLD_OWNER_TERRITORY_ID OLD_OWNER_TERRITORY_ID, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, OLD_ESCALATION_LEVEL OLD_ESCALATION_LEVEL, NEW_ESCALATION_LEVEL NEW_ESCALATION_LEVEL, SECURITY_GROUP_ID SECURITY_GROUP_ID, ORIG_SYSTEM_REFERENCE ORIG_SYSTEM_REFERENCE, ORIG_SYSTEM_REFERENCE_ID ORIG_SYSTEM_REFERENCE_ID, UPGRADE_STATUS_FLAG UPGRADE_STATUS_FLAG, OLD_DATE_SELECTED OLD_DATE_SELECTED, NEW_DATE_SELECTED NEW_DATE_SELECTED, OLD_LOCATION_ID OLD_LOCATION_ID, NEW_LOCATION_ID NEW_LOCATION_ID from "JTF"."JTF_TASK_AUDITS_B"

View Text - HTML Formatted

SELECT TASK_AUDIT_ID TASK_AUDIT_ID
, TASK_ID TASK_ID
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, OLD_TASK_TYPE_ID OLD_TASK_TYPE_ID
, NEW_TASK_TYPE_ID NEW_TASK_TYPE_ID
, OLD_TASK_STATUS_ID OLD_TASK_STATUS_ID
, NEW_TASK_STATUS_ID NEW_TASK_STATUS_ID
, OLD_TASK_PRIORITY_ID OLD_TASK_PRIORITY_ID
, NEW_TASK_PRIORITY_ID NEW_TASK_PRIORITY_ID
, OLD_OWNER_ID OLD_OWNER_ID
, NEW_OWNER_ID NEW_OWNER_ID
, OLD_OWNER_TYPE_CODE OLD_OWNER_TYPE_CODE
, NEW_OWNER_TYPE_CODE NEW_OWNER_TYPE_CODE
, OLD_ASSIGNED_BY_ID OLD_ASSIGNED_BY_ID
, NEW_ASSIGNED_BY_ID NEW_ASSIGNED_BY_ID
, OLD_CUST_ACCOUNT_ID OLD_CUST_ACCOUNT_ID
, NEW_CUST_ACCOUNT_ID NEW_CUST_ACCOUNT_ID
, OLD_CUSTOMER_ID OLD_CUSTOMER_ID
, NEW_CUSTOMER_ID NEW_CUSTOMER_ID
, OLD_ADDRESS_ID OLD_ADDRESS_ID
, NEW_ADDRESS_ID NEW_ADDRESS_ID
, OLD_PLANNED_START_DATE OLD_PLANNED_START_DATE
, NEW_PLANNED_START_DATE NEW_PLANNED_START_DATE
, OLD_PLANNED_END_DATE OLD_PLANNED_END_DATE
, NEW_PLANNED_END_DATE NEW_PLANNED_END_DATE
, OLD_SCHEDULED_START_DATE OLD_SCHEDULED_START_DATE
, NEW_SCHEDULED_START_DATE NEW_SCHEDULED_START_DATE
, OLD_SCHEDULED_END_DATE OLD_SCHEDULED_END_DATE
, NEW_SCHEDULED_END_DATE NEW_SCHEDULED_END_DATE
, OLD_ACTUAL_START_DATE OLD_ACTUAL_START_DATE
, NEW_ACTUAL_START_DATE NEW_ACTUAL_START_DATE
, OLD_ACTUAL_END_DATE OLD_ACTUAL_END_DATE
, NEW_ACTUAL_END_DATE NEW_ACTUAL_END_DATE
, OLD_SOURCE_OBJECT_TYPE_CODE OLD_SOURCE_OBJECT_TYPE_CODE
, NEW_SOURCE_OBJECT_TYPE_CODE NEW_SOURCE_OBJECT_TYPE_CODE
, OLD_TIMEZONE_ID OLD_TIMEZONE_ID
, NEW_TIMEZONE_ID NEW_TIMEZONE_ID
, OLD_SOURCE_OBJECT_ID OLD_SOURCE_OBJECT_ID
, NEW_SOURCE_OBJECT_ID NEW_SOURCE_OBJECT_ID
, OLD_SOURCE_OBJECT_NAME OLD_SOURCE_OBJECT_NAME
, NEW_SOURCE_OBJECT_NAME NEW_SOURCE_OBJECT_NAME
, OLD_DURATION OLD_DURATION
, NEW_DURATION NEW_DURATION
, OLD_DURATION_UOM OLD_DURATION_UOM
, NEW_DURATION_UOM NEW_DURATION_UOM
, OLD_PLANNED_EFFORT OLD_PLANNED_EFFORT
, NEW_PLANNED_EFFORT NEW_PLANNED_EFFORT
, OLD_PLANNED_EFFORT_UOM OLD_PLANNED_EFFORT_UOM
, NEW_PLANNED_EFFORT_UOM NEW_PLANNED_EFFORT_UOM
, OLD_ACTUAL_EFFORT OLD_ACTUAL_EFFORT
, NEW_ACTUAL_EFFORT NEW_ACTUAL_EFFORT
, OLD_ACTUAL_EFFORT_UOM OLD_ACTUAL_EFFORT_UOM
, NEW_ACTUAL_EFFORT_UOM NEW_ACTUAL_EFFORT_UOM
, OLD_PERCENTAGE_COMPLETE OLD_PERCENTAGE_COMPLETE
, NEW_PERCENTAGE_COMPLETE NEW_PERCENTAGE_COMPLETE
, OLD_REASON_CODE OLD_REASON_CODE
, NEW_REASON_CODE NEW_REASON_CODE
, PRIVATE_CHANGED_FLAG PRIVATE_CHANGED_FLAG
, PUBLISH_CHANGED_FLAG PUBLISH_CHANGED_FLAG
, RESTRICT_CLOSURE_CHANGE_FLAG RESTRICT_CLOSURE_CHANGE_FLAG
, MULTI_BOOKED_CHANGED_FLAG MULTI_BOOKED_CHANGED_FLAG
, MILESTONE_CHANGED_FLAG MILESTONE_CHANGED_FLAG
, HOLIDAY_CHANGED_FLAG HOLIDAY_CHANGED_FLAG
, BILLABLE_CHANGED_FLAG BILLABLE_CHANGED_FLAG
, OLD_BOUND_MODE_CODE OLD_BOUND_MODE_CODE
, NEW_BOUND_MODE_CODE NEW_BOUND_MODE_CODE
, SOFT_BOUND_CHANGED_FLAG SOFT_BOUND_CHANGED_FLAG
, OLD_WORKFLOW_PROCESS_ID OLD_WORKFLOW_PROCESS_ID
, NEW_WORKFLOW_PROCESS_ID NEW_WORKFLOW_PROCESS_ID
, NOTIFICATION_CHANGED_FLAG NOTIFICATION_CHANGED_FLAG
, OLD_NOTIFICATION_PERIOD OLD_NOTIFICATION_PERIOD
, NEW_NOTIFICATION_PERIOD NEW_NOTIFICATION_PERIOD
, OLD_NOTIFICATION_PERIOD_UOM OLD_NOTIFICATION_PERIOD_UOM
, NEW_NOTIFICATION_PERIOD_UOM NEW_NOTIFICATION_PERIOD_UOM
, OLD_PARENT_TASK_ID OLD_PARENT_TASK_ID
, NEW_PARENT_TASK_ID NEW_PARENT_TASK_ID
, OLD_RECURRENCE_RULE_ID OLD_RECURRENCE_RULE_ID
, NEW_RECURRENCE_RULE_ID NEW_RECURRENCE_RULE_ID
, PALM_CHANGED_FLAG PALM_CHANGED_FLAG
, WINCE_CHANGED_FLAG WINCE_CHANGED_FLAG
, LAPTOP_CHANGED_FLAG LAPTOP_CHANGED_FLAG
, DEVICE1_CHANGED_FLAG DEVICE1_CHANGED_FLAG
, DEVICE2_CHANGED_FLAG DEVICE2_CHANGED_FLAG
, DEVICE3_CHANGED_FLAG DEVICE3_CHANGED_FLAG
, OLD_CURRENCY_CODE OLD_CURRENCY_CODE
, NEW_CURRENCY_CODE NEW_CURRENCY_CODE
, OLD_COSTS OLD_COSTS
, NEW_COSTS NEW_COSTS
, OLD_ORG_ID OLD_ORG_ID
, NEW_ORG_ID NEW_ORG_ID
, NEW_OWNER_TERRITORY_ID NEW_OWNER_TERRITORY_ID
, OLD_OWNER_TERRITORY_ID OLD_OWNER_TERRITORY_ID
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, OLD_ESCALATION_LEVEL OLD_ESCALATION_LEVEL
, NEW_ESCALATION_LEVEL NEW_ESCALATION_LEVEL
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, ORIG_SYSTEM_REFERENCE ORIG_SYSTEM_REFERENCE
, ORIG_SYSTEM_REFERENCE_ID ORIG_SYSTEM_REFERENCE_ID
, UPGRADE_STATUS_FLAG UPGRADE_STATUS_FLAG
, OLD_DATE_SELECTED OLD_DATE_SELECTED
, NEW_DATE_SELECTED NEW_DATE_SELECTED
, OLD_LOCATION_ID OLD_LOCATION_ID
, NEW_LOCATION_ID NEW_LOCATION_ID
FROM "JTF"."JTF_TASK_AUDITS_B"