Product: | JTF - CRM Foundation |
---|---|
Description: | MLS View for JTF_TASK_AUDITS_B and JTF_TASK_AUDITS_TL. |
Implementation/DBA Data: | APPS.JTF_TASK_AUDITS_VL |
SELECT B.BILLABLE_CHANGED_FLAG
, B.CREATED_BY
, B.CREATION_DATE
, B.DEVICE1_CHANGED_FLAG
, B.DEVICE2_CHANGED_FLAG
, B.DEVICE3_CHANGED_FLAG
, B.HOLIDAY_CHANGED_FLAG
, B.LAPTOP_CHANGED_FLAG
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATE_LOGIN
, B.MILESTONE_CHANGED_FLAG
, B.MULTI_BOOKED_CHANGED_FLAG
, B.NEW_ACTUAL_EFFORT
, B.NEW_ACTUAL_EFFORT_UOM
, B.NEW_ACTUAL_END_DATE
, B.NEW_ACTUAL_START_DATE
, B.NEW_ADDRESS_ID
, B.NEW_ASSIGNED_BY_ID
, B.NEW_BOUND_MODE_CODE
, B.NEW_COSTS
, B.NEW_CURRENCY_CODE
, B.NEW_CUSTOMER_ID
, B.NEW_CUST_ACCOUNT_ID
, B.NEW_DURATION
, B.NEW_DURATION_UOM
, B.NEW_NOTIFICATION_PERIOD
, B.NEW_NOTIFICATION_PERIOD_UOM
, B.NEW_ORG_ID
, B.NEW_OWNER_ID
, B.NEW_OWNER_TYPE_CODE
, B.NEW_PARENT_TASK_ID
, B.NEW_PERCENTAGE_COMPLETE
, B.NEW_PLANNED_EFFORT
, B.NEW_PLANNED_EFFORT_UOM
, B.NEW_PLANNED_END_DATE
, B.NEW_PLANNED_START_DATE
, B.NEW_REASON_CODE
, B.NEW_RECURRENCE_RULE_ID
, B.NEW_SCHEDULED_END_DATE
, B.NEW_SCHEDULED_START_DATE
, B.NEW_SOURCE_OBJECT_ID
, B.NEW_SOURCE_OBJECT_NAME
, B.NEW_SOURCE_OBJECT_TYPE_CODE
, B.NEW_TASK_PRIORITY_ID
, B.NEW_TASK_STATUS_ID
, B.NEW_TASK_TYPE_ID
, B.NEW_TIMEZONE_ID
, B.NEW_WORKFLOW_PROCESS_ID
, B.NOTIFICATION_CHANGED_FLAG
, B.OLD_ACTUAL_EFFORT
, B.OLD_ACTUAL_EFFORT_UOM
, B.OLD_ACTUAL_END_DATE
, B.OLD_ACTUAL_START_DATE
, B.OLD_ADDRESS_ID
, B.OLD_ASSIGNED_BY_ID
, B.OLD_BOUND_MODE_CODE
, B.OLD_COSTS
, B.OLD_CURRENCY_CODE
, B.OLD_CUSTOMER_ID
, B.OLD_CUST_ACCOUNT_ID
, B.OLD_DURATION
, B.OLD_DURATION_UOM
, B.OLD_NOTIFICATION_PERIOD
, B.OLD_NOTIFICATION_PERIOD_UOM
, B.OLD_ORG_ID
, B.OLD_OWNER_ID
, B.OLD_OWNER_TYPE_CODE
, B.OLD_PARENT_TASK_ID
, B.OLD_PERCENTAGE_COMPLETE
, B.OLD_PLANNED_EFFORT
, B.OLD_PLANNED_EFFORT_UOM
, B.OLD_PLANNED_END_DATE
, B.OLD_PLANNED_START_DATE
, B.OLD_REASON_CODE
, B.OLD_RECURRENCE_RULE_ID
, B.OLD_SCHEDULED_END_DATE
, B.OLD_SCHEDULED_START_DATE
, B.OLD_SOURCE_OBJECT_ID
, B.OLD_SOURCE_OBJECT_NAME
, B.OLD_SOURCE_OBJECT_TYPE_CODE
, B.OLD_TASK_PRIORITY_ID
, B.OLD_TASK_STATUS_ID
, B.OLD_TASK_TYPE_ID
, B.OLD_TIMEZONE_ID
, B.OLD_WORKFLOW_PROCESS_ID
, B.PALM_CHANGED_FLAG
, B.PRIVATE_CHANGED_FLAG
, B.PUBLISH_CHANGED_FLAG
, B.RESTRICT_CLOSURE_CHANGE_FLAG
, B.ROWID ROW_ID
, B.SOFT_BOUND_CHANGED_FLAG
, B.TASK_AUDIT_ID
, B.TASK_ID
, B.WINCE_CHANGED_FLAG
, T.NEW_DESCRIPTION
, T.NEW_TASK_NAME
, T.OLD_DESCRIPTION
, T.OLD_TASK_NAME
, B.OLD_OWNER_TERRITORY_ID
, B.NEW_OWNER_TERRITORY_ID
, B.OLD_ESCALATION_LEVEL
, B.NEW_ESCALATION_LEVEL
, B.OLD_LOCATION_ID
, B.NEW_LOCATION_ID
FROM JTF_TASK_AUDITS_TL T
, JTF_TASK_AUDITS_B B
WHERE B.TASK_AUDIT_ID = T.TASK_AUDIT_ID
AND T.LANGUAGE = USERENV('LANG')