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: APPS.JTF_TASK_AUDITS_VL

Object Details

Object Name:	JTF_TASK_AUDITS_VL
Object Type:	VIEW
Owner:	APPS
FND Design Data:	JTF.JTF_TASK_AUDITS_VL
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

MLS View for JTF_TASK_AUDITS_B and JTF_TASK_AUDITS_TL

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
BILLABLE_CHANGED_FLAG	VARCHAR2	(1)		Refer to JTF_TASKS_B table
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.
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
HOLIDAY_CHANGED_FLAG	VARCHAR2	(1)		Refer to JTF_TASKS_B table
LAPTOP_CHANGED_FLAG	VARCHAR2	(1)		Refer to JTF_TASKS_B table
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).
MILESTONE_CHANGED_FLAG	VARCHAR2	(1)		Refer to JTF_TASKS_B table
MULTI_BOOKED_CHANGED_FLAG	VARCHAR2	(1)		Refer to JTF_TASKS_B table
NEW_ACTUAL_EFFORT	NUMBER			Refer to JTF_TASKS_B table
NEW_ACTUAL_EFFORT_UOM	VARCHAR2	(3)		Refer to JTF_TASKS_B table
NEW_ACTUAL_END_DATE	DATE			Refer to JTF_TASKS_B table
NEW_ACTUAL_START_DATE	DATE			Refer to JTF_TASKS_B table
NEW_ADDRESS_ID	NUMBER			Refer to JTF_TASKS_B table
NEW_ASSIGNED_BY_ID	NUMBER			Refer to JTF_TASKS_B table
NEW_BOUND_MODE_CODE	VARCHAR2	(30)		Refer to JTF_TASKS_B table
NEW_COSTS	NUMBER			Refer to JTF_TASKS_B table
NEW_CURRENCY_CODE	VARCHAR2	(15)		Refer to JTF_TASKS_B table
NEW_CUSTOMER_ID	NUMBER			Refer to JTF_TASKS_B table
NEW_CUST_ACCOUNT_ID	NUMBER			Refer to JTF_TASKS_B table
NEW_DURATION	NUMBER			Refer to JTF_TASKS_B table
NEW_DURATION_UOM	VARCHAR2	(3)		Refer to JTF_TASKS_B table
NEW_NOTIFICATION_PERIOD	NUMBER			Refer to JTF_TASKS_B table
NEW_NOTIFICATION_PERIOD_UOM	VARCHAR2	(3)		Refer to JTF_TASKS_B table
NEW_ORG_ID	NUMBER			Refer to JTF_TASKS_B table
NEW_OWNER_ID	NUMBER			Refer to JTF_TASKS_B table
NEW_OWNER_TYPE_CODE	VARCHAR2	(30)		Refer to JTF_TASKS_B table
NEW_PARENT_TASK_ID	NUMBER			Refer to JTF_TASKS_B table
NEW_PERCENTAGE_COMPLETE	NUMBER			Refer to JTF_TASKS_B table
NEW_PLANNED_EFFORT	NUMBER			Refer to JTF_TASKS_B table
NEW_PLANNED_EFFORT_UOM	VARCHAR2	(3)		Refer to JTF_TASKS_B table
NEW_PLANNED_END_DATE	DATE			Refer to JTF_TASKS_B table
NEW_PLANNED_START_DATE	DATE			Refer to JTF_TASKS_B table
NEW_REASON_CODE	VARCHAR2	(30)		Refer to JTF_TASKS_B table
NEW_RECURRENCE_RULE_ID	NUMBER			Refer to JTF_TASKS_B table
NEW_SCHEDULED_END_DATE	DATE			Refer to JTF_TASKS_B table
NEW_SCHEDULED_START_DATE	DATE			Refer to JTF_TASKS_B table
NEW_SOURCE_OBJECT_ID	NUMBER			Refer to JTF_TASKS_B table
NEW_SOURCE_OBJECT_NAME	VARCHAR2	(80)		Refer to JTF_TASKS_B table
NEW_SOURCE_OBJECT_TYPE_CODE	VARCHAR2	(30)		Refer to JTF_TASKS_B table
NEW_TASK_PRIORITY_ID	NUMBER			Refer to JTF_TASKS_B table
NEW_TASK_STATUS_ID	NUMBER			Refer to JTF_TASKS_B table
NEW_TASK_TYPE_ID	NUMBER			Refer to JTF_TASKS_B table
NEW_TIMEZONE_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_ACTUAL_EFFORT	NUMBER			Refer to JTF_TASKS_B table
OLD_ACTUAL_EFFORT_UOM	VARCHAR2	(3)		Refer to JTF_TASKS_B table
OLD_ACTUAL_END_DATE	DATE			Refer to JTF_TASKS_B table
OLD_ACTUAL_START_DATE	DATE			Refer to JTF_TASKS_B table
OLD_ADDRESS_ID	NUMBER			Refer to JTF_TASKS_B table
OLD_ASSIGNED_BY_ID	NUMBER			Refer to JTF_TASKS_B table
OLD_BOUND_MODE_CODE	VARCHAR2	(30)		Refer to JTF_TASKS_B table
OLD_COSTS	NUMBER			Refer to JTF_TASKS_B table
OLD_CURRENCY_CODE	VARCHAR2	(15)		Refer to JTF_TASKS_B table
OLD_CUSTOMER_ID	NUMBER			Refer to JTF_TASKS_B table
OLD_CUST_ACCOUNT_ID	NUMBER			Refer to JTF_TASKS_B table
OLD_DURATION	NUMBER			Refer to JTF_TASKS_B table
OLD_DURATION_UOM	VARCHAR2	(3)		Refer to JTF_TASKS_B table
OLD_NOTIFICATION_PERIOD	NUMBER			Refer to JTF_TASKS_B table
OLD_NOTIFICATION_PERIOD_UOM	VARCHAR2	(3)		Refer to JTF_TASKS_B table
OLD_ORG_ID	NUMBER			Refer to JTF_TASKS_B table
OLD_OWNER_ID	NUMBER			Refer to JTF_TASKS_B table
OLD_OWNER_TYPE_CODE	VARCHAR2	(30)		Refer to JTF_TASKS_B table
OLD_PARENT_TASK_ID	NUMBER			Refer to JTF_TASKS_B table
OLD_PERCENTAGE_COMPLETE	NUMBER			Refer to JTF_TASKS_B table
OLD_PLANNED_EFFORT	NUMBER			Refer to JTF_TASKS_B table
OLD_PLANNED_EFFORT_UOM	VARCHAR2	(3)		Refer to JTF_TASKS_B table
OLD_PLANNED_END_DATE	DATE			Refer to JTF_TASKS_B table
OLD_PLANNED_START_DATE	DATE			Refer to JTF_TASKS_B table
OLD_REASON_CODE	VARCHAR2	(30)		Refer to JTF_TASKS_B table
OLD_RECURRENCE_RULE_ID	NUMBER			Refer to JTF_TASKS_B table
OLD_SCHEDULED_END_DATE	DATE			Refer to JTF_TASKS_B table
OLD_SCHEDULED_START_DATE	DATE			Refer to JTF_TASKS_B table
OLD_SOURCE_OBJECT_ID	NUMBER			Refer to JTF_TASKS_B table
OLD_SOURCE_OBJECT_NAME	VARCHAR2	(80)		Refer to JTF_TASKS_B table
OLD_SOURCE_OBJECT_TYPE_CODE	VARCHAR2	(30)		Refer to JTF_TASKS_B table
OLD_TASK_PRIORITY_ID	NUMBER			Refer to JTF_TASKS_B table
OLD_TASK_STATUS_ID	NUMBER			Refer to JTF_TASKS_B table
OLD_TASK_TYPE_ID	NUMBER			Refer to JTF_TASKS_B table
OLD_TIMEZONE_ID	NUMBER			Refer to JTF_TASKS_B table
OLD_WORKFLOW_PROCESS_ID	NUMBER			Refer to JTF_TASKS_B table
PALM_CHANGED_FLAG	VARCHAR2	(1)		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
ROW_ID	ROWID	(10)		Refer to JTF_TASKS_B table
SOFT_BOUND_CHANGED_FLAG	VARCHAR2	(1)		Refer to JTF_TASKS_B table
TASK_AUDIT_ID	NUMBER		Yes	Unique Task audit identifier ( PK )
TASK_ID	NUMBER		Yes	Task identifier
WINCE_CHANGED_FLAG	VARCHAR2	(1)		Refer to JTF_TASKS_B table
NEW_DESCRIPTION	VARCHAR2	(4000)		Refer to JTF_TASKS_B table
NEW_TASK_NAME	VARCHAR2	(80)		Refer to JTF_TASKS_B table
OLD_DESCRIPTION	VARCHAR2	(4000)		Refer to JTF_TASKS_B table
OLD_TASK_NAME	VARCHAR2	(80)		Refer to JTF_TASKS_B table
OLD_OWNER_TERRITORY_ID	NUMBER			Refer to JTF_TASKS_B table
NEW_OWNER_TERRITORY_ID	NUMBER			Refer to JTF_TASKS_B table
OLD_ESCALATION_LEVEL	VARCHAR2	(30)		Refer to JTF_TASKS_B table
NEW_ESCALATION_LEVEL	VARCHAR2	(30)		Refer to JTF_TASKS_B table
OLD_LOCATION_ID	NUMBER			Refer to JTF_TASKS_B table
NEW_LOCATION_ID	NUMBER			Refer to JTF_TASKS_B table

Query Text

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


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

Dependencies

[top of page]

APPS.JTF_TASK_AUDITS_VL references the following:

APPS: JTF_TASK_AUDITS_B; JTF_TASK_AUDITS_TL

APPS.JTF_TASK_AUDITS_VL is referenced by following:

APPS: CS_WF_EVENT_SUBSCRIPTIONS_PKG - show dependent code; JTF_TASK_WF_SUBSCRIBE_PVT - show dependent code