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]

VIEW: JTF.JTF_TASK_AUDITS_B#

Object Details

Object Name:	JTF_TASK_AUDITS_B#
Object Type:	VIEW
Owner:	JTF
Subobject Name:
Status:	VALID

[View Source]

Columns

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

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

JTF: JTF_TASK_AUDITS_B

JTF.JTF_TASK_AUDITS_B# is referenced by following:

APPS: JTF_TASK_AUDITS_B