[Home] [Help] [Dependency Information]

VIEW: JTF.JTF_RS_RESOURCE_EXTN_AUD#

Object Details

[View Source]

Columns

Query Text

Cut, paste (and edit) the following text to query this object:

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

Dependencies

[top of page]

JTF

JTF_RS_RESOURCE_EXTN_AUD

MDSYS

SDO_GEOMETRY

SYS

STANDARD - show dependent code

APPS

JTF_RS_RESOURCE_EXTN_AUD