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_AUDITS_B

Object Details

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

Base Table which stores audit information for a task.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
JTF_TASK_AUDITS_B_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	TASK_AUDIT_ID
JTF_TASK_AUDITS_B_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TASK_ID
JTF_TASK_AUDITS_B_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	NEW_CUSTOMER_ID
JTF_TASK_AUDITS_B_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	NEW_SOURCE_OBJECT_ID
JTF_TASK_AUDITS_B_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	OLD_CUSTOMER_ID
JTF_TASK_AUDITS_B_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	OLD_SOURCE_OBJECT_ID
JTF_TASK_AUDITS_B_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	NEW_ADDRESS_ID
JTF_TASK_AUDITS_B_N7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	OLD_ADDRESS_ID
JTF_TASK_AUDITS_B_N8	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	NEW_CUST_ACCOUNT_ID
JTF_TASK_AUDITS_B_N9	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	OLD_CUST_ACCOUNT_ID

Columns

Name	Datatype	Length	Mandatory	Comments
TASK_AUDIT_ID	NUMBER		Yes	Unique Task audit identifier ( PK )
TASK_ID	NUMBER		Yes	Task identifier
CREATED_BY	NUMBER	(15)	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	(15)	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	(15)		Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
OLD_TASK_TYPE_ID	NUMBER			Refer to JTF_TASKS_B table
NEW_TASK_TYPE_ID	NUMBER			Refer to JTF_TASKS_B table
OLD_TASK_STATUS_ID	NUMBER			Refer to JTF_TASKS_B table
NEW_TASK_STATUS_ID	NUMBER			Refer to JTF_TASKS_B table
OLD_TASK_PRIORITY_ID	NUMBER			Refer to JTF_TASKS_B table
NEW_TASK_PRIORITY_ID	NUMBER			Refer to JTF_TASKS_B table
OLD_OWNER_ID	NUMBER			Refer to JTF_TASKS_B table
NEW_OWNER_ID	NUMBER			Refer to JTF_TASKS_B table
OLD_OWNER_TYPE_CODE	VARCHAR2	(30)		Refer to JTF_TASKS_B table
NEW_OWNER_TYPE_CODE	VARCHAR2	(30)		Refer to JTF_TASKS_B table
OLD_ASSIGNED_BY_ID	NUMBER			Refer to JTF_TASKS_B table
NEW_ASSIGNED_BY_ID	NUMBER			Refer to JTF_TASKS_B table
OLD_CUST_ACCOUNT_ID	NUMBER			Refer to JTF_TASKS_B table
NEW_CUST_ACCOUNT_ID	NUMBER			Refer to JTF_TASKS_B table
OLD_CUSTOMER_ID	NUMBER			Refer to JTF_TASKS_B table
NEW_CUSTOMER_ID	NUMBER			Refer to JTF_TASKS_B table
OLD_ADDRESS_ID	NUMBER			Refer to JTF_TASKS_B table
NEW_ADDRESS_ID	NUMBER			Refer to JTF_TASKS_B table
OLD_PLANNED_START_DATE	DATE			Refer to JTF_TASKS_B table
NEW_PLANNED_START_DATE	DATE			Refer to JTF_TASKS_B table
OLD_PLANNED_END_DATE	DATE			Refer to JTF_TASKS_B table
NEW_PLANNED_END_DATE	DATE			Refer to JTF_TASKS_B table
OLD_SCHEDULED_START_DATE	DATE			Refer to JTF_TASKS_B table
NEW_SCHEDULED_START_DATE	DATE			Refer to JTF_TASKS_B table
OLD_SCHEDULED_END_DATE	DATE			Refer to JTF_TASKS_B table
NEW_SCHEDULED_END_DATE	DATE			Refer to JTF_TASKS_B table
OLD_ACTUAL_START_DATE	DATE			Refer to JTF_TASKS_B table
NEW_ACTUAL_START_DATE	DATE			Refer to JTF_TASKS_B table
OLD_ACTUAL_END_DATE	DATE			Refer to JTF_TASKS_B table
NEW_ACTUAL_END_DATE	DATE			Refer to JTF_TASKS_B table
OLD_SOURCE_OBJECT_TYPE_CODE	VARCHAR2	(30)		Refer to JTF_TASKS_B table
NEW_SOURCE_OBJECT_TYPE_CODE	VARCHAR2	(30)		Refer to JTF_TASKS_B table
OLD_TIMEZONE_ID	NUMBER			Refer to JTF_TASKS_B table
NEW_TIMEZONE_ID	NUMBER			Refer to JTF_TASKS_B table
OLD_SOURCE_OBJECT_ID	NUMBER			Refer to JTF_TASKS_B table
NEW_SOURCE_OBJECT_ID	NUMBER			Refer to JTF_TASKS_B table
OLD_SOURCE_OBJECT_NAME	VARCHAR2	(80)		Refer to JTF_TASKS_B table
NEW_SOURCE_OBJECT_NAME	VARCHAR2	(80)		Refer to JTF_TASKS_B table
OLD_DURATION	NUMBER			Refer to JTF_TASKS_B table
NEW_DURATION	NUMBER			Refer to JTF_TASKS_B table
OLD_DURATION_UOM	VARCHAR2	(3)		Refer to JTF_TASKS_B table
NEW_DURATION_UOM	VARCHAR2	(3)		Refer to JTF_TASKS_B table
OLD_PLANNED_EFFORT	NUMBER			Refer to JTF_TASKS_B table
NEW_PLANNED_EFFORT	NUMBER			Refer to JTF_TASKS_B table
OLD_PLANNED_EFFORT_UOM	VARCHAR2	(3)		Refer to JTF_TASKS_B table
NEW_PLANNED_EFFORT_UOM	VARCHAR2	(3)		Refer to JTF_TASKS_B table
OLD_ACTUAL_EFFORT	NUMBER			Refer to JTF_TASKS_B table
NEW_ACTUAL_EFFORT	NUMBER			Refer to JTF_TASKS_B table
OLD_ACTUAL_EFFORT_UOM	VARCHAR2	(3)		Refer to JTF_TASKS_B table
NEW_ACTUAL_EFFORT_UOM	VARCHAR2	(3)		Refer to JTF_TASKS_B table
OLD_PERCENTAGE_COMPLETE	NUMBER			Refer to JTF_TASKS_B table
NEW_PERCENTAGE_COMPLETE	NUMBER			Refer to JTF_TASKS_B table
OLD_REASON_CODE	VARCHAR2	(30)		Refer to JTF_TASKS_B table
NEW_REASON_CODE	VARCHAR2	(30)		Refer to JTF_TASKS_B table
PRIVATE_CHANGED_FLAG	VARCHAR2	(1)		Refer to JTF_TASKS_B table
PUBLISH_CHANGED_FLAG	VARCHAR2	(1)		Refer to JTF_TASKS_B table
RESTRICT_CLOSURE_CHANGE_FLAG	VARCHAR2	(1)		Refer to JTF_TASKS_B table
MULTI_BOOKED_CHANGED_FLAG	VARCHAR2	(1)		Refer to JTF_TASKS_B table
MILESTONE_CHANGED_FLAG	VARCHAR2	(1)		Refer to JTF_TASKS_B table
HOLIDAY_CHANGED_FLAG	VARCHAR2	(1)		Refer to JTF_TASKS_B table
BILLABLE_CHANGED_FLAG	VARCHAR2	(1)		Refer to JTF_TASKS_B table
OLD_BOUND_MODE_CODE	VARCHAR2	(30)		Refer to JTF_TASKS_B table
NEW_BOUND_MODE_CODE	VARCHAR2	(30)		Refer to JTF_TASKS_B table
SOFT_BOUND_CHANGED_FLAG	VARCHAR2	(1)		Refer to JTF_TASKS_B table
OLD_WORKFLOW_PROCESS_ID	NUMBER			Refer to JTF_TASKS_B table
NEW_WORKFLOW_PROCESS_ID	NUMBER			Refer to JTF_TASKS_B table
NOTIFICATION_CHANGED_FLAG	VARCHAR2	(1)		Refer to JTF_TASKS_B table
OLD_NOTIFICATION_PERIOD	NUMBER			Refer to JTF_TASKS_B table
NEW_NOTIFICATION_PERIOD	NUMBER			Refer to JTF_TASKS_B table
OLD_NOTIFICATION_PERIOD_UOM	VARCHAR2	(3)		Refer to JTF_TASKS_B table
NEW_NOTIFICATION_PERIOD_UOM	VARCHAR2	(3)		Refer to JTF_TASKS_B table
OLD_PARENT_TASK_ID	NUMBER			Refer to JTF_TASKS_B table
NEW_PARENT_TASK_ID	NUMBER			Refer to JTF_TASKS_B table
OLD_RECURRENCE_RULE_ID	NUMBER			Refer to JTF_TASKS_B table
NEW_RECURRENCE_RULE_ID	NUMBER			Refer to JTF_TASKS_B table
PALM_CHANGED_FLAG	VARCHAR2	(1)		Refer to JTF_TASKS_B table
WINCE_CHANGED_FLAG	VARCHAR2	(1)		Refer to JTF_TASKS_B table
LAPTOP_CHANGED_FLAG	VARCHAR2	(1)		Refer to JTF_TASKS_B table
DEVICE1_CHANGED_FLAG	VARCHAR2	(1)		Refer to JTF_TASKS_B table
DEVICE2_CHANGED_FLAG	VARCHAR2	(1)		Refer to JTF_TASKS_B table
DEVICE3_CHANGED_FLAG	VARCHAR2	(1)		Refer to JTF_TASKS_B table
OLD_CURRENCY_CODE	VARCHAR2	(15)		Refer to JTF_TASKS_B table
NEW_CURRENCY_CODE	VARCHAR2	(15)		Refer to JTF_TASKS_B table
OLD_COSTS	NUMBER			Refer to JTF_TASKS_B table
NEW_COSTS	NUMBER			Refer to JTF_TASKS_B table
OLD_ORG_ID	NUMBER			Refer to JTF_TASKS_B table
NEW_ORG_ID	NUMBER			Refer to JTF_TASKS_B table
NEW_OWNER_TERRITORY_ID	NUMBER			Refer to JTF_TASKS_B table
OLD_OWNER_TERRITORY_ID	NUMBER			Refer to JTF_TASKS_B table
OBJECT_VERSION_NUMBER	NUMBER		Yes	Sequential number used for database locking control when using HTML as a user interface
OLD_ESCALATION_LEVEL	VARCHAR2	(30)		Refer to JTF_TASKS_B table
NEW_ESCALATION_LEVEL	VARCHAR2	(30)		Refer to JTF_TASKS_B table
SECURITY_GROUP_ID	NUMBER			Used in hosted environments
ORIG_SYSTEM_REFERENCE	VARCHAR2	(60)		Identifier of the system or table where this row was originally created
ORIG_SYSTEM_REFERENCE_ID	NUMBER			Unique identifier for this row in the original system or table
UPGRADE_STATUS_FLAG	VARCHAR2	(1)		To support partial re-run of upgrade or migration
OLD_DATE_SELECTED	VARCHAR2	(1)		The value before jtf_tasks_b.date_selected gets changed
NEW_DATE_SELECTED	VARCHAR2	(1)		The value after jtf_tasks_b.date_selected got changed
OLD_LOCATION_ID	NUMBER			The value before jtf_tasks_b.location_id gets changed
NEW_LOCATION_ID	NUMBER			The value after jtf_tasks_b.location_id gets changed

Query Text

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


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

Dependencies

[top of page]

JTF.JTF_TASK_AUDITS_B does not reference any database object

JTF.JTF_TASK_AUDITS_B is referenced by following:

APPS: JTF_TASK_AUDITS_B