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.

DBA Data [Home] [Help] [Dependency Information]

TABLE: JTF.JTF_RS_RESOURCE_EXTN_AUD

Object Details

Object Name:	JTF_RS_RESOURCE_EXTN_AUD
Object Type:	TABLE
Owner:	JTF
FND Design Data:	JTF.JTF_RS_RESOURCE_EXTN_AUD
Subobject Name:
Status:	VALID

The table that stores audit information for Resources

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
JTF_RS_RESOURCE_EXTN_AUD_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	RESOURCE_AUDIT_ID
SYS_IL0000084703C00066$$	LOB	UNIQUE	APPS_TS_TX_DATA
SYS_IL0000084703C00067$$	LOB	UNIQUE	APPS_TS_TX_DATA
SYS_IL0000084703C00074$$	LOB	UNIQUE	APPS_TS_TX_DATA
SYS_IL0000084703C00075$$	LOB	UNIQUE	APPS_TS_TX_DATA

Columns

Name	Datatype	Length	Mandatory	Comments
RESOURCE_AUDIT_ID	NUMBER		Yes	Resource Extension audit Identifier
RESOURCE_ID	NUMBER		Yes	Resource Identifier
NEW_CATEGORY	VARCHAR2	(30)		New value for Category
OLD_CATEGORY	VARCHAR2	(30)		Old value for Category
NEW_RESOURCE_NUMBER	VARCHAR2	(30)		New value for resource number
OLD_RESOURCE_NUMBER	VARCHAR2	(30)		Old value for resource number
NEW_SOURCE_ID	NUMBER			New value for source id
OLD_SOURCE_ID	NUMBER			Old value for source id
NEW_MANAGING_EMPLOYEE_ID	NUMBER			New value for managing employee id
OLD_MANAGING_EMPLOYEE_ID	NUMBER			Old value for managing employee id
NEW_TIME_ZONE	NUMBER			New value for time zone
OLD_TIME_ZONE	NUMBER			Old value for time zone
NEW_COST_PER_HR	NUMBER			New value for cost per hour
OLD_COST_PER_HR	NUMBER			Old value for cost per hour
NEW_PRIMARY_LANGUAGE	VARCHAR2	(30)		New primary language
OLD_PRIMARY_LANGUAGE	VARCHAR2	(30)		Old primary language
NEW_SECONDARY_LANGUAGE	VARCHAR2	(30)		New Secondary Language
OLD_SECONDARY_LANGUAGE	VARCHAR2	(30)		Old Seconday Language
NEW_IES_AGENT_LOGIN	VARCHAR2	(240)		New ies agent login
OLD_IES_AGENT_LOGIN	VARCHAR2	(240)		Old ies agent login
NEW_SERVER_GROUP_ID	NUMBER			New server group id
OLD_SERVER_GROUP_ID	NUMBER			Old Server group id
NEW_ASSIGNED_TO_GROUP_ID	NUMBER			New assigned to group id
OLD_ASSIGNED_TO_GROUP_ID	NUMBER			Old assigned to group id
NEW_COST_CENTER	VARCHAR2	(30)		New cost center
OLD_COST_CENTER	VARCHAR2	(30)		Old Cost center
NEW_CHARGE_TO_COST_CENTER	VARCHAR2	(30)		New charge to sost center
OLD_CHARGE_TO_COST_CENTER	VARCHAR2	(30)		Old charge to cost center
NEW_COMPENSATION_CURRENCY_CODE	VARCHAR2	(15)		New compensation currency code
OLD_COMPENSATION_CURRENCY_CODE	VARCHAR2	(15)		Old compensation currency code
NEW_COMMISSIONABLE_FLAG	VARCHAR2	(1)		New commissionable flag
OLD_COMMISSIONABLE_FLAG	VARCHAR2	(1)		Old commissionable flag
NEW_HOLD_REASON_CODE	VARCHAR2	(30)		New old reason code
OLD_HOLD_REASON_CODE	VARCHAR2	(30)		Old hold reason code
NEW_HOLD_PAYMENT	VARCHAR2	(1)		New hold payment
OLD_HOLD_PAYMENT	VARCHAR2	(1)		Old hold payment
NEW_COMP_SERVICE_TEAM_ID	NUMBER			New comp service team id
OLD_COMP_SERVICE_TEAM_ID	NUMBER			Old comp service team id
NEW_TRANSACTION_NUMBER	NUMBER			New transaction number
OLD_TRANSACTION_NUMBER	NUMBER			Old transaction number
NEW_OBJECT_VERSION_NUMBER	NUMBER			New object version number
OLD_OBJECT_VERSION_NUMBER	NUMBER			Old object version number
CREATED_BY	NUMBER		Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
LAST_UPDATED_BY	NUMBER		Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN	NUMBER			Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
NEW_ADDRESS_ID	NUMBER			New address id
OLD_ADDRESS_ID	NUMBER			Old address id
NEW_CONTACT_ID	NUMBER			New contact id
OLD_CONTACT_ID	NUMBER			Old contact id
OLD_START_DATE_ACTIVE	DATE			Old start date active
NEW_START_DATE_ACTIVE	DATE			New start date active
OLD_END_DATE_ACTIVE	DATE			Old end date active
NEW_END_DATE_ACTIVE	DATE			New end date active
NEW_USER_ID	NUMBER			New user id
OLD_USER_ID	NUMBER			Old user id
NEW_SUPPORT_SITE_ID	NUMBER			New support site
OLD_SUPPORT_SITE_ID	NUMBER			Old support site
OLD_LOCATION	SDO_GEOMETRY	(1)
NEW_LOCATION	SDO_GEOMETRY	(1)
SECURITY_GROUP_ID	NUMBER			Column used for Applications Hosting purposes
NEW_RESOURCE_NAME	VARCHAR2	(360)		The changed resource name
OLD_RESOURCE_NAME	VARCHAR2	(360)		The previous resource name
NEW_SOURCE_NAME	VARCHAR2	(360)		The new source name
OLD_SOURCE_NAME	VARCHAR2	(360)		The old source name
NEW_SOURCE_NUMBER	VARCHAR2	(30)		The new source number
OLD_SOURCE_NUMBER	VARCHAR2	(30)		Old Source number
NEW_SOURCE_JOB_TITLE	VARCHAR2	(240)		New Job Title
OLD_SOURCE_JOB_TITLE	VARCHAR2	(240)		Old job title
NEW_SOURCE_EMAIL	VARCHAR2	(2000)		New source email
OLD_SOURCE_EMAIL	VARCHAR2	(2000)		Old source email
NEW_SOURCE_PHONE	VARCHAR2	(2000)		New source phone number
OLD_SOURCE_PHONE	VARCHAR2	(240)		Old source phone number
NEW_SOURCE_ORG_ID	NUMBER			The new source org id
OLD_SOURCE_ORG_ID	NUMBER			The old source org id
NEW_SOURCE_ORG_NAME	VARCHAR2	(360)		The new source org name
OLD_SOURCE_ORG_NAME	VARCHAR2	(360)		The old source org name
NEW_SOURCE_ADDRESS1	VARCHAR2	(240)		New source address line 1
OLD_SOURCE_ADDRESS1	VARCHAR2	(240)		Old source address line 1
NEW_SOURCE_ADDRESS2	VARCHAR2	(240)		New source address line 1
OLD_SOURCE_ADDRESS2	VARCHAR2	(240)		Old source address line 2
NEW_SOURCE_ADDRESS3	VARCHAR2	(240)		New source address line 3
OLD_SOURCE_ADDRESS3	VARCHAR2	(240)		Old source address line 3
NEW_SOURCE_ADDRESS4	VARCHAR2	(240)		New source address line 4
OLD_SOURCE_ADDRESS4	VARCHAR2	(240)		Old source address line 4
NEW_SOURCE_CITY	VARCHAR2	(60)		New source city
OLD_SOURCE_CITY	VARCHAR2	(60)		Old source city
NEW_SOURCE_POSTAL_CODE	VARCHAR2	(60)		New source postal code
OLD_SOURCE_POSTAL_CODE	VARCHAR2	(60)		Old source postal code
NEW_SOURCE_STATE	VARCHAR2	(150)		New soource state
OLD_SOURCE_STATE	VARCHAR2	(150)		Old soource state
NEW_SOURCE_PROVINCE	VARCHAR2	(150)		New source Province
OLD_SOURCE_PROVINCE	VARCHAR2	(150)		Old source Province
NEW_SOURCE_COUNTY	VARCHAR2	(150)		New source county
OLD_SOURCE_COUNTY	VARCHAR2	(150)		Old source county
NEW_SOURCE_COUNTRY	VARCHAR2	(60)		New source country
OLD_SOURCE_COUNTRY	VARCHAR2	(60)		Old source country
NEW_SOURCE_MGR_ID	NUMBER			New source manager id
OLD_SOURCE_MGR_ID	NUMBER			Old source manager id
NEW_SOURCE_MGR_NAME	VARCHAR2	(360)		New source manager name
OLD_SOURCE_MGR_NAME	VARCHAR2	(360)		Old source manager name
NEW_SOURCE_BUSINESS_GRP_ID	NUMBER			New source business group id
OLD_SOURCE_BUSINESS_GRP_ID	NUMBER			Old source business group id
NEW_SOURCE_BUSINESS_GRP_NAME	VARCHAR2	(360)		New source business group name
OLD_SOURCE_BUSINESS_GRP_NAME	VARCHAR2	(360)		Old source business group name
NEW_SOURCE_FIRST_NAME	VARCHAR2	(360)		New Source First Name.
OLD_SOURCE_FIRST_NAME	VARCHAR2	(360)		Old Source First Name.
NEW_SOURCE_MIDDLE_NAME	VARCHAR2	(360)		New Source middle name.
OLD_SOURCE_MIDDLE_NAME	VARCHAR2	(360)		Old source middle name.
NEW_SOURCE_LAST_NAME	VARCHAR2	(360)		New source last name.
OLD_SOURCE_LAST_NAME	VARCHAR2	(360)		Old source last name.
NEW_SOURCE_CATEGORY	VARCHAR2	(360)		Source Category.
OLD_SOURCE_CATEGORY	VARCHAR2	(360)		Source Category.
NEW_SOURCE_STATUS	VARCHAR2	(360)		New source status.
OLD_SOURCE_STATUS	VARCHAR2	(360)		Old source status.
OLD_SOURCE_OFFICE	VARCHAR2	(45)		Old source office.
NEW_SOURCE_OFFICE	VARCHAR2	(45)		New source office.
OLD_SOURCE_LOCATION	VARCHAR2	(45)		Old source location.
NEW_SOURCE_LOCATION	VARCHAR2	(45)		New source location.
OLD_SOURCE_MAILSTOP	VARCHAR2	(45)		Old source mailstop.
NEW_SOURCE_MAILSTOP	VARCHAR2	(45)		New source mailstop.
OLD_USER_NAME	VARCHAR2	(100)		Old user name.
NEW_USER_NAME	VARCHAR2	(100)		New user name.
OLD_SOURCE_MOBILE_PHONE	VARCHAR2	(60)		Old Source Mobile phone of the resource.
NEW_SOURCE_MOBILE_PHONE	VARCHAR2	(60)		New Source Mobile phone of the resource.
OLD_SOURCE_PAGER	VARCHAR2	(60)		Old Source Pager
NEW_SOURCE_PAGER	VARCHAR2	(60)		New Source Pager
OLD_PARTY_ID	NUMBER			Party ID corresponding to an Employee
NEW_PARTY_ID	NUMBER			Party ID corresponding to an Employee
OLD_SOURCE_JOB_ID	NUMBER			Job ID corresponding to only EMPLOYEE type of Resource.
NEW_SOURCE_JOB_ID	NUMBER			Job ID corresponding to only EMPLOYEE type of Resource.
OLD_FS_SETUP_COMPLETE	VARCHAR2	(1)		Store FS_SETUP_COMPLETE columns old value
NEW_FS_SETUP_COMPLETE	VARCHAR2	(1)		Store FS_SETUP_COMPLETE columns new value

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 references the following:

MDSYS: SDO_GEOMETRY
SYS: STANDARD - show dependent code

JTF.JTF_RS_RESOURCE_EXTN_AUD is referenced by following:

JTF: JTF_RS_RESOURCE_EXTN_AUD#