VIEW: JTF.JTF_TASKS_B#

Source

View Text - Preformatted

select TASK_ID TASK_ID, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, TASK_NUMBER TASK_NUMBER, TASK_TYPE_ID TASK_TYPE_ID, TASK_STATUS_ID TASK_STATUS_ID, TASK_PRIORITY_ID TASK_PRIORITY_ID, OWNER_ID OWNER_ID, OWNER_TYPE_CODE OWNER_TYPE_CODE, OWNER_TERRITORY_ID OWNER_TERRITORY_ID, ASSIGNED_BY_ID ASSIGNED_BY_ID, CUST_ACCOUNT_ID CUST_ACCOUNT_ID, CUSTOMER_ID CUSTOMER_ID, ADDRESS_ID ADDRESS_ID, PLANNED_START_DATE PLANNED_START_DATE, PLANNED_END_DATE PLANNED_END_DATE, SCHEDULED_START_DATE SCHEDULED_START_DATE, SCHEDULED_END_DATE SCHEDULED_END_DATE, ACTUAL_START_DATE ACTUAL_START_DATE, ACTUAL_END_DATE ACTUAL_END_DATE, SOURCE_OBJECT_TYPE_CODE SOURCE_OBJECT_TYPE_CODE, TIMEZONE_ID TIMEZONE_ID, SOURCE_OBJECT_ID SOURCE_OBJECT_ID, SOURCE_OBJECT_NAME SOURCE_OBJECT_NAME, DURATION DURATION, DURATION_UOM DURATION_UOM, PLANNED_EFFORT PLANNED_EFFORT, PLANNED_EFFORT_UOM PLANNED_EFFORT_UOM, ACTUAL_EFFORT ACTUAL_EFFORT, ACTUAL_EFFORT_UOM ACTUAL_EFFORT_UOM, PERCENTAGE_COMPLETE PERCENTAGE_COMPLETE, REASON_CODE REASON_CODE, PRIVATE_FLAG PRIVATE_FLAG, PUBLISH_FLAG PUBLISH_FLAG, RESTRICT_CLOSURE_FLAG RESTRICT_CLOSURE_FLAG, MULTI_BOOKED_FLAG MULTI_BOOKED_FLAG, MILESTONE_FLAG MILESTONE_FLAG, HOLIDAY_FLAG HOLIDAY_FLAG, BILLABLE_FLAG BILLABLE_FLAG, BOUND_MODE_CODE BOUND_MODE_CODE, SOFT_BOUND_FLAG SOFT_BOUND_FLAG, WORKFLOW_PROCESS_ID WORKFLOW_PROCESS_ID, NOTIFICATION_FLAG NOTIFICATION_FLAG, NOTIFICATION_PERIOD NOTIFICATION_PERIOD, NOTIFICATION_PERIOD_UOM NOTIFICATION_PERIOD_UOM, PARENT_TASK_ID PARENT_TASK_ID, RECURRENCE_RULE_ID RECURRENCE_RULE_ID, ALARM_START ALARM_START, ALARM_START_UOM ALARM_START_UOM, ALARM_ON ALARM_ON, ALARM_COUNT ALARM_COUNT, ALARM_FIRED_COUNT ALARM_FIRED_COUNT, ALARM_INTERVAL ALARM_INTERVAL, ALARM_INTERVAL_UOM ALARM_INTERVAL_UOM, DELETED_FLAG DELETED_FLAG, PALM_FLAG PALM_FLAG, WINCE_FLAG WINCE_FLAG, LAPTOP_FLAG LAPTOP_FLAG, DEVICE1_FLAG DEVICE1_FLAG, DEVICE2_FLAG DEVICE2_FLAG, DEVICE3_FLAG DEVICE3_FLAG, COSTS COSTS, CURRENCY_CODE CURRENCY_CODE, ORG_ID ORG_ID, ESCALATION_LEVEL ESCALATION_LEVEL, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, SECURITY_GROUP_ID SECURITY_GROUP_ID, ORIG_SYSTEM_REFERENCE ORIG_SYSTEM_REFERENCE, ORIG_SYSTEM_REFERENCE_ID ORIG_SYSTEM_REFERENCE_ID, UPDATE_STATUS_FLAG UPDATE_STATUS_FLAG, CALENDAR_START_DATE CALENDAR_START_DATE, CALENDAR_END_DATE CALENDAR_END_DATE, DATE_SELECTED DATE_SELECTED, TEMPLATE_ID TEMPLATE_ID, TEMPLATE_GROUP_ID TEMPLATE_GROUP_ID, OBJECT_CHANGED_DATE OBJECT_CHANGED_DATE, TASK_CONFIRMATION_STATUS TASK_CONFIRMATION_STATUS, TASK_CONFIRMATION_COUNTER TASK_CONFIRMATION_COUNTER, TASK_SPLIT_FLAG TASK_SPLIT_FLAG, OPEN_FLAG OPEN_FLAG, ENTITY ENTITY, CHILD_POSITION CHILD_POSITION, CHILD_SEQUENCE_NUM CHILD_SEQUENCE_NUM, LOCATION_ID LOCATION_ID from "JTF"."JTF_TASKS_B"

View Text - HTML Formatted

SELECT TASK_ID TASK_ID
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, TASK_NUMBER TASK_NUMBER
, TASK_TYPE_ID TASK_TYPE_ID
, TASK_STATUS_ID TASK_STATUS_ID
, TASK_PRIORITY_ID TASK_PRIORITY_ID
, OWNER_ID OWNER_ID
, OWNER_TYPE_CODE OWNER_TYPE_CODE
, OWNER_TERRITORY_ID OWNER_TERRITORY_ID
, ASSIGNED_BY_ID ASSIGNED_BY_ID
, CUST_ACCOUNT_ID CUST_ACCOUNT_ID
, CUSTOMER_ID CUSTOMER_ID
, ADDRESS_ID ADDRESS_ID
, PLANNED_START_DATE PLANNED_START_DATE
, PLANNED_END_DATE PLANNED_END_DATE
, SCHEDULED_START_DATE SCHEDULED_START_DATE
, SCHEDULED_END_DATE SCHEDULED_END_DATE
, ACTUAL_START_DATE ACTUAL_START_DATE
, ACTUAL_END_DATE ACTUAL_END_DATE
, SOURCE_OBJECT_TYPE_CODE SOURCE_OBJECT_TYPE_CODE
, TIMEZONE_ID TIMEZONE_ID
, SOURCE_OBJECT_ID SOURCE_OBJECT_ID
, SOURCE_OBJECT_NAME SOURCE_OBJECT_NAME
, DURATION DURATION
, DURATION_UOM DURATION_UOM
, PLANNED_EFFORT PLANNED_EFFORT
, PLANNED_EFFORT_UOM PLANNED_EFFORT_UOM
, ACTUAL_EFFORT ACTUAL_EFFORT
, ACTUAL_EFFORT_UOM ACTUAL_EFFORT_UOM
, PERCENTAGE_COMPLETE PERCENTAGE_COMPLETE
, REASON_CODE REASON_CODE
, PRIVATE_FLAG PRIVATE_FLAG
, PUBLISH_FLAG PUBLISH_FLAG
, RESTRICT_CLOSURE_FLAG RESTRICT_CLOSURE_FLAG
, MULTI_BOOKED_FLAG MULTI_BOOKED_FLAG
, MILESTONE_FLAG MILESTONE_FLAG
, HOLIDAY_FLAG HOLIDAY_FLAG
, BILLABLE_FLAG BILLABLE_FLAG
, BOUND_MODE_CODE BOUND_MODE_CODE
, SOFT_BOUND_FLAG SOFT_BOUND_FLAG
, WORKFLOW_PROCESS_ID WORKFLOW_PROCESS_ID
, NOTIFICATION_FLAG NOTIFICATION_FLAG
, NOTIFICATION_PERIOD NOTIFICATION_PERIOD
, NOTIFICATION_PERIOD_UOM NOTIFICATION_PERIOD_UOM
, PARENT_TASK_ID PARENT_TASK_ID
, RECURRENCE_RULE_ID RECURRENCE_RULE_ID
, ALARM_START ALARM_START
, ALARM_START_UOM ALARM_START_UOM
, ALARM_ON ALARM_ON
, ALARM_COUNT ALARM_COUNT
, ALARM_FIRED_COUNT ALARM_FIRED_COUNT
, ALARM_INTERVAL ALARM_INTERVAL
, ALARM_INTERVAL_UOM ALARM_INTERVAL_UOM
, DELETED_FLAG DELETED_FLAG
, PALM_FLAG PALM_FLAG
, WINCE_FLAG WINCE_FLAG
, LAPTOP_FLAG LAPTOP_FLAG
, DEVICE1_FLAG DEVICE1_FLAG
, DEVICE2_FLAG DEVICE2_FLAG
, DEVICE3_FLAG DEVICE3_FLAG
, COSTS COSTS
, CURRENCY_CODE CURRENCY_CODE
, ORG_ID ORG_ID
, ESCALATION_LEVEL ESCALATION_LEVEL
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, ORIG_SYSTEM_REFERENCE ORIG_SYSTEM_REFERENCE
, ORIG_SYSTEM_REFERENCE_ID ORIG_SYSTEM_REFERENCE_ID
, UPDATE_STATUS_FLAG UPDATE_STATUS_FLAG
, CALENDAR_START_DATE CALENDAR_START_DATE
, CALENDAR_END_DATE CALENDAR_END_DATE
, DATE_SELECTED DATE_SELECTED
, TEMPLATE_ID TEMPLATE_ID
, TEMPLATE_GROUP_ID TEMPLATE_GROUP_ID
, OBJECT_CHANGED_DATE OBJECT_CHANGED_DATE
, TASK_CONFIRMATION_STATUS TASK_CONFIRMATION_STATUS
, TASK_CONFIRMATION_COUNTER TASK_CONFIRMATION_COUNTER
, TASK_SPLIT_FLAG TASK_SPLIT_FLAG
, OPEN_FLAG OPEN_FLAG
, ENTITY ENTITY
, CHILD_POSITION CHILD_POSITION
, CHILD_SEQUENCE_NUM CHILD_SEQUENCE_NUM
, LOCATION_ID LOCATION_ID
FROM "JTF"."JTF_TASKS_B"