[Home] [Help] [Dependency Information]
Object Name: | JTF_TASK_AUDITS_B# |
---|---|
Object Type: | VIEW |
Owner: | JTF |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
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 |
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#;
|
|
|