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_TASK_ASSIGNMENTS_AUDIT_B

Object Details

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

Table for stroing changes in Task Assignments.It has row for every change in Task Assignment.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
JTF_TASK_ASG_AUDIT_B_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ASSIGNMENT_ID
JTF_TASK_ASG_AUDIT_B_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TASK_ID
JTF_TASK_ASG_AUDIT_B_U1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ASSIGNMENT_AUDIT_ID

Columns

Name	Datatype	Length	Mandatory	Comments
ASSIGNMENT_AUDIT_ID	NUMBER		Yes	Sequence generated Primary Key
ASSIGNMENT_ID	NUMBER		Yes	Assignemnt ID of task Assignment for which the audit records belongs to
TASK_ID	NUMBER		Yes	Task Identifier for corresponding task assignment
CREATED_BY	VARCHAR2	(25)	Yes	Standard WHO column-user who created this row
CREATION_DATE	DATE		Yes	Standard WHO column -Date when this row was created
LAST_UPDATED_BY	VARCHAR2	(25)	Yes	Standard WHO Column - user who last updated this row
LAST_UPDATE_LOGIN	NUMBER			Standard WHO Column -operating system login of user who last updated this row
LAST_UPDATE_DATE	DATE		Yes	Standard WHO Column - Date when a user last updated this row
OBJECT_VERSION_NUMBER	NUMBER			Row's version number
OLD_RESOURCE_TYPE_CODE	VARCHAR2	(30)		Old Resource Type Code
NEW_RESOURCE_TYPE_CODE	VARCHAR2	(30)		New Resource Type Code
OLD_RESOURCE_ID	NUMBER			Old Resource Id
NEW_RESOURCE_ID	NUMBER			New Resource Id
OLD_ASSIGNMENT_STATUS_ID	NUMBER			Old Assignment Status identifier of the assignee
NEW_ASSIGNMENT_STATUS_ID	NUMBER			New Assignment Status identifier of the assignee
OLD_ACTUAL_EFFORT	NUMBER			Old Actual Effort
NEW_ACTUAL_EFFORT	NUMBER			New Actual Effort
OLD_ACTUAL_EFFORT_UOM	VARCHAR2	(3)		Old Unit of measure for actual effort
NEW_ACTUAL_EFFORT_UOM	VARCHAR2	(3)		Old Unit of measure for actual effort
OLD_RES_TERRITORY_ID	NUMBER			Old Resource Territory Id for this assignment
NEW_RES_TERRITORY_ID	NUMBER			New Resource Territory Id for this assignment
OLD_ASSIGNEE_ROLE	VARCHAR2	(30)		Old Assignee Role.Possible values are "ASSIGNEE" and "OWNER"
NEW_ASSIGNEE_ROLE	VARCHAR2	(30)		New Assignee Role.Possible values are "ASSIGNEE" and "OWNER"
SCHEDULE_FLAG_CHANGED	VARCHAR2	(1)		Schedule Flag Changed or not in this record history.possible values are Y or N.
OLD_ALARM_TYPE	VARCHAR2	(30)		Old Alarm Type.A lookup code that indicates how alarms should be sent to resource. e.g. 'EMAIL','PAGER','PHONE'
NEW_ALARM_TYPE	VARCHAR2	(30)		New Alarm Type.A lookup code that indicates how alarms should be sent to resource. e.g. 'EMAIL','PAGER','PHONE'
OLD_ALARM_CONTACT	VARCHAR2	(200)		Old Alarm Contact.Contact information for sending alarms, this field may store email address , pager , number or phone number
NEW_ALARM_CONTACT	VARCHAR2	(200)		New Alarm Contact.Contact information for sending alarms, this field may store email address , pager , number or phone number
UPDATE_STATUS_FLAG_CHANGED	VARCHAR2	(1)		Update Status Flag Changed or not in this record history.possible values are Y or N.
SHOW_ON_CALENDAR_CHANGED	VARCHAR2	(1)		Show On Calendar Flag Changed or not in this record history.possible values are Y or N.
OLD_CATEGORY_ID	NUMBER			Old Category
NEW_CATEGORY_ID	NUMBER			New Category
FREE_BUSY_TYPE_CHANGED	VARCHAR2	(1)		Free/Busy Status for this assignemnt changed or not in this record history.possible values are Y or N.
OLD_BOOKING_START_DATE	DATE			Old Booking Start Date
NEW_BOOKING_START_DATE	DATE			New Booking Start Date
OLD_BOOKING_END_DATE	DATE			Old Booking End Date
NEW_BOOKING_END_DATE	DATE			New Booking End Date
OLD_ACTUAL_TRAVEL_DISTANCE	NUMBER			Old Actual Travel Distance
NEW_ACTUAL_TRAVEL_DISTANCE	NUMBER			New Actual Travel Distance
OLD_ACTUAL_TRAVEL_DURATION	NUMBER			Old Actual Travel Duration
NEW_ACTUAL_TRAVEL_DURATION	NUMBER			New Actual Travel Duration
OLD_ACTUAL_TRAVEL_DURATION_UOM	VARCHAR2	(3)		Old Unit of measure for Actual Travel Duration
NEW_ACTUAL_TRAVEL_DURATION_UOM	VARCHAR2	(3)		New Unit of measure for Actual Travel Duration
OLD_SCHED_TRAVEL_DISTANCE	NUMBER			Old Scheduled Travel Distance
NEW_SCHED_TRAVEL_DISTANCE	NUMBER			New Scheduled Travel Distance
OLD_SCHED_TRAVEL_DURATION	NUMBER			Old Scheduled Travel Duration
NEW_SCHED_TRAVEL_DURATION	NUMBER			New Scheduled Travel Duration
OLD_SCHED_TRAVEL_DURATION_UOM	VARCHAR2	(3)		Old Unit of Measure for Scheduled Travel Duration
NEW_SCHED_TRAVEL_DURATION_UOM	VARCHAR2	(3)		New Unit of Measure for Scheduled Travel Duration
OLD_ACTUAL_START_DATE	DATE			Old Actual Start Date
NEW_ACTUAL_START_DATE	DATE			New Actual Start Date
OLD_ACTUAL_END_DATE	DATE			Old Actual End Date
NEW_ACTUAL_END_DATE	DATE			New Actual End Date

Query Text

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


SELECT ASSIGNMENT_AUDIT_ID
,      ASSIGNMENT_ID
,      TASK_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
,      OBJECT_VERSION_NUMBER
,      OLD_RESOURCE_TYPE_CODE
,      NEW_RESOURCE_TYPE_CODE
,      OLD_RESOURCE_ID
,      NEW_RESOURCE_ID
,      OLD_ASSIGNMENT_STATUS_ID
,      NEW_ASSIGNMENT_STATUS_ID
,      OLD_ACTUAL_EFFORT
,      NEW_ACTUAL_EFFORT
,      OLD_ACTUAL_EFFORT_UOM
,      NEW_ACTUAL_EFFORT_UOM
,      OLD_RES_TERRITORY_ID
,      NEW_RES_TERRITORY_ID
,      OLD_ASSIGNEE_ROLE
,      NEW_ASSIGNEE_ROLE
,      SCHEDULE_FLAG_CHANGED
,      OLD_ALARM_TYPE
,      NEW_ALARM_TYPE
,      OLD_ALARM_CONTACT
,      NEW_ALARM_CONTACT
,      UPDATE_STATUS_FLAG_CHANGED
,      SHOW_ON_CALENDAR_CHANGED
,      OLD_CATEGORY_ID
,      NEW_CATEGORY_ID
,      FREE_BUSY_TYPE_CHANGED
,      OLD_BOOKING_START_DATE
,      NEW_BOOKING_START_DATE
,      OLD_BOOKING_END_DATE
,      NEW_BOOKING_END_DATE
,      OLD_ACTUAL_TRAVEL_DISTANCE
,      NEW_ACTUAL_TRAVEL_DISTANCE
,      OLD_ACTUAL_TRAVEL_DURATION
,      NEW_ACTUAL_TRAVEL_DURATION
,      OLD_ACTUAL_TRAVEL_DURATION_UOM
,      NEW_ACTUAL_TRAVEL_DURATION_UOM
,      OLD_SCHED_TRAVEL_DISTANCE
,      NEW_SCHED_TRAVEL_DISTANCE
,      OLD_SCHED_TRAVEL_DURATION
,      NEW_SCHED_TRAVEL_DURATION
,      OLD_SCHED_TRAVEL_DURATION_UOM
,      NEW_SCHED_TRAVEL_DURATION_UOM
,      OLD_ACTUAL_START_DATE
,      NEW_ACTUAL_START_DATE
,      OLD_ACTUAL_END_DATE
,      NEW_ACTUAL_END_DATE
FROM JTF.JTF_TASK_ASSIGNMENTS_AUDIT_B;

Dependencies

[top of page]

JTF.JTF_TASK_ASSIGNMENTS_AUDIT_B does not reference any database object

JTF.JTF_TASK_ASSIGNMENTS_AUDIT_B is referenced by following:

JTF: JTF_TASK_ASSIGNMENTS_AUDIT_B#