VIEW: JTF.JTF_RS_RESOURCE_EXTN_AUD#

Source

View Text - Preformatted

select RESOURCE_AUDIT_ID RESOURCE_AUDIT_ID, RESOURCE_ID RESOURCE_ID, NEW_CATEGORY NEW_CATEGORY, OLD_CATEGORY OLD_CATEGORY, NEW_RESOURCE_NUMBER NEW_RESOURCE_NUMBER, OLD_RESOURCE_NUMBER OLD_RESOURCE_NUMBER, NEW_SOURCE_ID NEW_SOURCE_ID, OLD_SOURCE_ID OLD_SOURCE_ID, NEW_MANAGING_EMPLOYEE_ID NEW_MANAGING_EMPLOYEE_ID, OLD_MANAGING_EMPLOYEE_ID OLD_MANAGING_EMPLOYEE_ID, NEW_TIME_ZONE NEW_TIME_ZONE, OLD_TIME_ZONE OLD_TIME_ZONE, NEW_COST_PER_HR NEW_COST_PER_HR, OLD_COST_PER_HR OLD_COST_PER_HR, NEW_PRIMARY_LANGUAGE NEW_PRIMARY_LANGUAGE, OLD_PRIMARY_LANGUAGE OLD_PRIMARY_LANGUAGE, NEW_SECONDARY_LANGUAGE NEW_SECONDARY_LANGUAGE, OLD_SECONDARY_LANGUAGE OLD_SECONDARY_LANGUAGE, NEW_IES_AGENT_LOGIN NEW_IES_AGENT_LOGIN, OLD_IES_AGENT_LOGIN OLD_IES_AGENT_LOGIN, NEW_SERVER_GROUP_ID NEW_SERVER_GROUP_ID, OLD_SERVER_GROUP_ID OLD_SERVER_GROUP_ID, NEW_ASSIGNED_TO_GROUP_ID NEW_ASSIGNED_TO_GROUP_ID, OLD_ASSIGNED_TO_GROUP_ID OLD_ASSIGNED_TO_GROUP_ID, NEW_COST_CENTER NEW_COST_CENTER, OLD_COST_CENTER OLD_COST_CENTER, NEW_CHARGE_TO_COST_CENTER NEW_CHARGE_TO_COST_CENTER, OLD_CHARGE_TO_COST_CENTER OLD_CHARGE_TO_COST_CENTER, NEW_COMPENSATION_CURRENCY_CODE NEW_COMPENSATION_CURRENCY_CODE, OLD_COMPENSATION_CURRENCY_CODE OLD_COMPENSATION_CURRENCY_CODE, NEW_COMMISSIONABLE_FLAG NEW_COMMISSIONABLE_FLAG, OLD_COMMISSIONABLE_FLAG OLD_COMMISSIONABLE_FLAG, NEW_HOLD_REASON_CODE NEW_HOLD_REASON_CODE, OLD_HOLD_REASON_CODE OLD_HOLD_REASON_CODE, NEW_HOLD_PAYMENT NEW_HOLD_PAYMENT, OLD_HOLD_PAYMENT OLD_HOLD_PAYMENT, NEW_COMP_SERVICE_TEAM_ID NEW_COMP_SERVICE_TEAM_ID, OLD_COMP_SERVICE_TEAM_ID OLD_COMP_SERVICE_TEAM_ID, NEW_TRANSACTION_NUMBER NEW_TRANSACTION_NUMBER, OLD_TRANSACTION_NUMBER OLD_TRANSACTION_NUMBER, NEW_OBJECT_VERSION_NUMBER NEW_OBJECT_VERSION_NUMBER, OLD_OBJECT_VERSION_NUMBER OLD_OBJECT_VERSION_NUMBER, 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, NEW_ADDRESS_ID NEW_ADDRESS_ID, OLD_ADDRESS_ID OLD_ADDRESS_ID, NEW_CONTACT_ID NEW_CONTACT_ID, OLD_CONTACT_ID OLD_CONTACT_ID, OLD_START_DATE_ACTIVE OLD_START_DATE_ACTIVE, NEW_START_DATE_ACTIVE NEW_START_DATE_ACTIVE, OLD_END_DATE_ACTIVE OLD_END_DATE_ACTIVE, NEW_END_DATE_ACTIVE NEW_END_DATE_ACTIVE, NEW_USER_ID NEW_USER_ID, OLD_USER_ID OLD_USER_ID, NEW_SUPPORT_SITE_ID NEW_SUPPORT_SITE_ID, OLD_SUPPORT_SITE_ID OLD_SUPPORT_SITE_ID, OLD_LOCATION OLD_LOCATION, NEW_LOCATION NEW_LOCATION, SECURITY_GROUP_ID SECURITY_GROUP_ID, NEW_RESOURCE_NAME NEW_RESOURCE_NAME, OLD_RESOURCE_NAME OLD_RESOURCE_NAME, NEW_SOURCE_NAME NEW_SOURCE_NAME, OLD_SOURCE_NAME OLD_SOURCE_NAME, NEW_SOURCE_NUMBER NEW_SOURCE_NUMBER, OLD_SOURCE_NUMBER OLD_SOURCE_NUMBER, NEW_SOURCE_JOB_TITLE NEW_SOURCE_JOB_TITLE, OLD_SOURCE_JOB_TITLE OLD_SOURCE_JOB_TITLE, NEW_SOURCE_EMAIL NEW_SOURCE_EMAIL, OLD_SOURCE_EMAIL OLD_SOURCE_EMAIL, NEW_SOURCE_PHONE NEW_SOURCE_PHONE, OLD_SOURCE_PHONE OLD_SOURCE_PHONE, NEW_SOURCE_ORG_ID NEW_SOURCE_ORG_ID, OLD_SOURCE_ORG_ID OLD_SOURCE_ORG_ID, NEW_SOURCE_ORG_NAME NEW_SOURCE_ORG_NAME, OLD_SOURCE_ORG_NAME OLD_SOURCE_ORG_NAME, NEW_SOURCE_ADDRESS1 NEW_SOURCE_ADDRESS1, OLD_SOURCE_ADDRESS1 OLD_SOURCE_ADDRESS1, NEW_SOURCE_ADDRESS2 NEW_SOURCE_ADDRESS2, OLD_SOURCE_ADDRESS2 OLD_SOURCE_ADDRESS2, NEW_SOURCE_ADDRESS3 NEW_SOURCE_ADDRESS3, OLD_SOURCE_ADDRESS3 OLD_SOURCE_ADDRESS3, NEW_SOURCE_ADDRESS4 NEW_SOURCE_ADDRESS4, OLD_SOURCE_ADDRESS4 OLD_SOURCE_ADDRESS4, NEW_SOURCE_CITY NEW_SOURCE_CITY, OLD_SOURCE_CITY OLD_SOURCE_CITY, NEW_SOURCE_POSTAL_CODE NEW_SOURCE_POSTAL_CODE, OLD_SOURCE_POSTAL_CODE OLD_SOURCE_POSTAL_CODE, NEW_SOURCE_STATE NEW_SOURCE_STATE, OLD_SOURCE_STATE OLD_SOURCE_STATE, NEW_SOURCE_PROVINCE NEW_SOURCE_PROVINCE, OLD_SOURCE_PROVINCE OLD_SOURCE_PROVINCE, NEW_SOURCE_COUNTY NEW_SOURCE_COUNTY, OLD_SOURCE_COUNTY OLD_SOURCE_COUNTY, NEW_SOURCE_COUNTRY NEW_SOURCE_COUNTRY, OLD_SOURCE_COUNTRY OLD_SOURCE_COUNTRY, NEW_SOURCE_MGR_ID NEW_SOURCE_MGR_ID, OLD_SOURCE_MGR_ID OLD_SOURCE_MGR_ID, NEW_SOURCE_MGR_NAME NEW_SOURCE_MGR_NAME, OLD_SOURCE_MGR_NAME OLD_SOURCE_MGR_NAME, NEW_SOURCE_BUSINESS_GRP_ID NEW_SOURCE_BUSINESS_GRP_ID, OLD_SOURCE_BUSINESS_GRP_ID OLD_SOURCE_BUSINESS_GRP_ID, NEW_SOURCE_BUSINESS_GRP_NAME NEW_SOURCE_BUSINESS_GRP_NAME, OLD_SOURCE_BUSINESS_GRP_NAME OLD_SOURCE_BUSINESS_GRP_NAME, NEW_SOURCE_FIRST_NAME NEW_SOURCE_FIRST_NAME, OLD_SOURCE_FIRST_NAME OLD_SOURCE_FIRST_NAME, NEW_SOURCE_MIDDLE_NAME NEW_SOURCE_MIDDLE_NAME, OLD_SOURCE_MIDDLE_NAME OLD_SOURCE_MIDDLE_NAME, NEW_SOURCE_LAST_NAME NEW_SOURCE_LAST_NAME, OLD_SOURCE_LAST_NAME OLD_SOURCE_LAST_NAME, NEW_SOURCE_CATEGORY NEW_SOURCE_CATEGORY, OLD_SOURCE_CATEGORY OLD_SOURCE_CATEGORY, NEW_SOURCE_STATUS NEW_SOURCE_STATUS, OLD_SOURCE_STATUS OLD_SOURCE_STATUS, OLD_SOURCE_OFFICE OLD_SOURCE_OFFICE, NEW_SOURCE_OFFICE NEW_SOURCE_OFFICE, OLD_SOURCE_LOCATION OLD_SOURCE_LOCATION, NEW_SOURCE_LOCATION NEW_SOURCE_LOCATION, OLD_SOURCE_MAILSTOP OLD_SOURCE_MAILSTOP, NEW_SOURCE_MAILSTOP NEW_SOURCE_MAILSTOP, OLD_USER_NAME OLD_USER_NAME, NEW_USER_NAME NEW_USER_NAME, OLD_SOURCE_MOBILE_PHONE OLD_SOURCE_MOBILE_PHONE, NEW_SOURCE_MOBILE_PHONE NEW_SOURCE_MOBILE_PHONE, OLD_SOURCE_PAGER OLD_SOURCE_PAGER, NEW_SOURCE_PAGER NEW_SOURCE_PAGER, OLD_PARTY_ID OLD_PARTY_ID, NEW_PARTY_ID NEW_PARTY_ID, OLD_SOURCE_JOB_ID OLD_SOURCE_JOB_ID, NEW_SOURCE_JOB_ID NEW_SOURCE_JOB_ID, OLD_FS_SETUP_COMPLETE OLD_FS_SETUP_COMPLETE, NEW_FS_SETUP_COMPLETE NEW_FS_SETUP_COMPLETE from "JTF"."JTF_RS_RESOURCE_EXTN_AUD"

View Text - HTML Formatted

SELECT RESOURCE_AUDIT_ID RESOURCE_AUDIT_ID
, RESOURCE_ID RESOURCE_ID
, NEW_CATEGORY NEW_CATEGORY
, OLD_CATEGORY OLD_CATEGORY
, NEW_RESOURCE_NUMBER NEW_RESOURCE_NUMBER
, OLD_RESOURCE_NUMBER OLD_RESOURCE_NUMBER
, NEW_SOURCE_ID NEW_SOURCE_ID
, OLD_SOURCE_ID OLD_SOURCE_ID
, NEW_MANAGING_EMPLOYEE_ID NEW_MANAGING_EMPLOYEE_ID
, OLD_MANAGING_EMPLOYEE_ID OLD_MANAGING_EMPLOYEE_ID
, NEW_TIME_ZONE NEW_TIME_ZONE
, OLD_TIME_ZONE OLD_TIME_ZONE
, NEW_COST_PER_HR NEW_COST_PER_HR
, OLD_COST_PER_HR OLD_COST_PER_HR
, NEW_PRIMARY_LANGUAGE NEW_PRIMARY_LANGUAGE
, OLD_PRIMARY_LANGUAGE OLD_PRIMARY_LANGUAGE
, NEW_SECONDARY_LANGUAGE NEW_SECONDARY_LANGUAGE
, OLD_SECONDARY_LANGUAGE OLD_SECONDARY_LANGUAGE
, NEW_IES_AGENT_LOGIN NEW_IES_AGENT_LOGIN
, OLD_IES_AGENT_LOGIN OLD_IES_AGENT_LOGIN
, NEW_SERVER_GROUP_ID NEW_SERVER_GROUP_ID
, OLD_SERVER_GROUP_ID OLD_SERVER_GROUP_ID
, NEW_ASSIGNED_TO_GROUP_ID NEW_ASSIGNED_TO_GROUP_ID
, OLD_ASSIGNED_TO_GROUP_ID OLD_ASSIGNED_TO_GROUP_ID
, NEW_COST_CENTER NEW_COST_CENTER
, OLD_COST_CENTER OLD_COST_CENTER
, NEW_CHARGE_TO_COST_CENTER NEW_CHARGE_TO_COST_CENTER
, OLD_CHARGE_TO_COST_CENTER OLD_CHARGE_TO_COST_CENTER
, NEW_COMPENSATION_CURRENCY_CODE NEW_COMPENSATION_CURRENCY_CODE
, OLD_COMPENSATION_CURRENCY_CODE OLD_COMPENSATION_CURRENCY_CODE
, NEW_COMMISSIONABLE_FLAG NEW_COMMISSIONABLE_FLAG
, OLD_COMMISSIONABLE_FLAG OLD_COMMISSIONABLE_FLAG
, NEW_HOLD_REASON_CODE NEW_HOLD_REASON_CODE
, OLD_HOLD_REASON_CODE OLD_HOLD_REASON_CODE
, NEW_HOLD_PAYMENT NEW_HOLD_PAYMENT
, OLD_HOLD_PAYMENT OLD_HOLD_PAYMENT
, NEW_COMP_SERVICE_TEAM_ID NEW_COMP_SERVICE_TEAM_ID
, OLD_COMP_SERVICE_TEAM_ID OLD_COMP_SERVICE_TEAM_ID
, NEW_TRANSACTION_NUMBER NEW_TRANSACTION_NUMBER
, OLD_TRANSACTION_NUMBER OLD_TRANSACTION_NUMBER
, NEW_OBJECT_VERSION_NUMBER NEW_OBJECT_VERSION_NUMBER
, OLD_OBJECT_VERSION_NUMBER OLD_OBJECT_VERSION_NUMBER
, 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
, NEW_ADDRESS_ID NEW_ADDRESS_ID
, OLD_ADDRESS_ID OLD_ADDRESS_ID
, NEW_CONTACT_ID NEW_CONTACT_ID
, OLD_CONTACT_ID OLD_CONTACT_ID
, OLD_START_DATE_ACTIVE OLD_START_DATE_ACTIVE
, NEW_START_DATE_ACTIVE NEW_START_DATE_ACTIVE
, OLD_END_DATE_ACTIVE OLD_END_DATE_ACTIVE
, NEW_END_DATE_ACTIVE NEW_END_DATE_ACTIVE
, NEW_USER_ID NEW_USER_ID
, OLD_USER_ID OLD_USER_ID
, NEW_SUPPORT_SITE_ID NEW_SUPPORT_SITE_ID
, OLD_SUPPORT_SITE_ID OLD_SUPPORT_SITE_ID
, OLD_LOCATION OLD_LOCATION
, NEW_LOCATION NEW_LOCATION
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, NEW_RESOURCE_NAME NEW_RESOURCE_NAME
, OLD_RESOURCE_NAME OLD_RESOURCE_NAME
, NEW_SOURCE_NAME NEW_SOURCE_NAME
, OLD_SOURCE_NAME OLD_SOURCE_NAME
, NEW_SOURCE_NUMBER NEW_SOURCE_NUMBER
, OLD_SOURCE_NUMBER OLD_SOURCE_NUMBER
, NEW_SOURCE_JOB_TITLE NEW_SOURCE_JOB_TITLE
, OLD_SOURCE_JOB_TITLE OLD_SOURCE_JOB_TITLE
, NEW_SOURCE_EMAIL NEW_SOURCE_EMAIL
, OLD_SOURCE_EMAIL OLD_SOURCE_EMAIL
, NEW_SOURCE_PHONE NEW_SOURCE_PHONE
, OLD_SOURCE_PHONE OLD_SOURCE_PHONE
, NEW_SOURCE_ORG_ID NEW_SOURCE_ORG_ID
, OLD_SOURCE_ORG_ID OLD_SOURCE_ORG_ID
, NEW_SOURCE_ORG_NAME NEW_SOURCE_ORG_NAME
, OLD_SOURCE_ORG_NAME OLD_SOURCE_ORG_NAME
, NEW_SOURCE_ADDRESS1 NEW_SOURCE_ADDRESS1
, OLD_SOURCE_ADDRESS1 OLD_SOURCE_ADDRESS1
, NEW_SOURCE_ADDRESS2 NEW_SOURCE_ADDRESS2
, OLD_SOURCE_ADDRESS2 OLD_SOURCE_ADDRESS2
, NEW_SOURCE_ADDRESS3 NEW_SOURCE_ADDRESS3
, OLD_SOURCE_ADDRESS3 OLD_SOURCE_ADDRESS3
, NEW_SOURCE_ADDRESS4 NEW_SOURCE_ADDRESS4
, OLD_SOURCE_ADDRESS4 OLD_SOURCE_ADDRESS4
, NEW_SOURCE_CITY NEW_SOURCE_CITY
, OLD_SOURCE_CITY OLD_SOURCE_CITY
, NEW_SOURCE_POSTAL_CODE NEW_SOURCE_POSTAL_CODE
, OLD_SOURCE_POSTAL_CODE OLD_SOURCE_POSTAL_CODE
, NEW_SOURCE_STATE NEW_SOURCE_STATE
, OLD_SOURCE_STATE OLD_SOURCE_STATE
, NEW_SOURCE_PROVINCE NEW_SOURCE_PROVINCE
, OLD_SOURCE_PROVINCE OLD_SOURCE_PROVINCE
, NEW_SOURCE_COUNTY NEW_SOURCE_COUNTY
, OLD_SOURCE_COUNTY OLD_SOURCE_COUNTY
, NEW_SOURCE_COUNTRY NEW_SOURCE_COUNTRY
, OLD_SOURCE_COUNTRY OLD_SOURCE_COUNTRY
, NEW_SOURCE_MGR_ID NEW_SOURCE_MGR_ID
, OLD_SOURCE_MGR_ID OLD_SOURCE_MGR_ID
, NEW_SOURCE_MGR_NAME NEW_SOURCE_MGR_NAME
, OLD_SOURCE_MGR_NAME OLD_SOURCE_MGR_NAME
, NEW_SOURCE_BUSINESS_GRP_ID NEW_SOURCE_BUSINESS_GRP_ID
, OLD_SOURCE_BUSINESS_GRP_ID OLD_SOURCE_BUSINESS_GRP_ID
, NEW_SOURCE_BUSINESS_GRP_NAME NEW_SOURCE_BUSINESS_GRP_NAME
, OLD_SOURCE_BUSINESS_GRP_NAME OLD_SOURCE_BUSINESS_GRP_NAME
, NEW_SOURCE_FIRST_NAME NEW_SOURCE_FIRST_NAME
, OLD_SOURCE_FIRST_NAME OLD_SOURCE_FIRST_NAME
, NEW_SOURCE_MIDDLE_NAME NEW_SOURCE_MIDDLE_NAME
, OLD_SOURCE_MIDDLE_NAME OLD_SOURCE_MIDDLE_NAME
, NEW_SOURCE_LAST_NAME NEW_SOURCE_LAST_NAME
, OLD_SOURCE_LAST_NAME OLD_SOURCE_LAST_NAME
, NEW_SOURCE_CATEGORY NEW_SOURCE_CATEGORY
, OLD_SOURCE_CATEGORY OLD_SOURCE_CATEGORY
, NEW_SOURCE_STATUS NEW_SOURCE_STATUS
, OLD_SOURCE_STATUS OLD_SOURCE_STATUS
, OLD_SOURCE_OFFICE OLD_SOURCE_OFFICE
, NEW_SOURCE_OFFICE NEW_SOURCE_OFFICE
, OLD_SOURCE_LOCATION OLD_SOURCE_LOCATION
, NEW_SOURCE_LOCATION NEW_SOURCE_LOCATION
, OLD_SOURCE_MAILSTOP OLD_SOURCE_MAILSTOP
, NEW_SOURCE_MAILSTOP NEW_SOURCE_MAILSTOP
, OLD_USER_NAME OLD_USER_NAME
, NEW_USER_NAME NEW_USER_NAME
, OLD_SOURCE_MOBILE_PHONE OLD_SOURCE_MOBILE_PHONE
, NEW_SOURCE_MOBILE_PHONE NEW_SOURCE_MOBILE_PHONE
, OLD_SOURCE_PAGER OLD_SOURCE_PAGER
, NEW_SOURCE_PAGER NEW_SOURCE_PAGER
, OLD_PARTY_ID OLD_PARTY_ID
, NEW_PARTY_ID NEW_PARTY_ID
, OLD_SOURCE_JOB_ID OLD_SOURCE_JOB_ID
, NEW_SOURCE_JOB_ID NEW_SOURCE_JOB_ID
, OLD_FS_SETUP_COMPLETE OLD_FS_SETUP_COMPLETE
, NEW_FS_SETUP_COMPLETE NEW_FS_SETUP_COMPLETE
FROM "JTF"."JTF_RS_RESOURCE_EXTN_AUD"