[Home] [Help] [Dependency Information]
Object Name: | JTF_TASK_AUDITS_VL |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | JTF.JTF_TASK_AUDITS_VL |
Subobject Name: | |
Status: | VALID |
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
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 |
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;
|
|
|