VIEW: CSM.CSM_TASKS_INQ#

Source

View Text - Preformatted

select TASK_ID TASK_ID, TASK_NUMBER TASK_NUMBER, TASK_NAME TASK_NAME, TASK_TYPE_ID TASK_TYPE_ID, TASK_STATUS_ID TASK_STATUS_ID, TASK_PRIORITY_ID TASK_PRIORITY_ID, ESCALATION_LEVEL ESCALATION_LEVEL, PLANNED_START_DATE PLANNED_START_DATE, PLANNED_END_DATE PLANNED_END_DATE, PLANNED_EFFORT PLANNED_EFFORT, PLANNED_EFFORT_UOM PLANNED_EFFORT_UOM, SCHEDULED_START_DATE SCHEDULED_START_DATE, SCHEDULED_END_DATE SCHEDULED_END_DATE, SOURCE_OBJECT_ID SOURCE_OBJECT_ID, SOURCE_OBJECT_TYPE_CODE SOURCE_OBJECT_TYPE_CODE, CLID$$CS CLID$$CS, DMLTYPE$$ DMLTYPE$$, SEQNO$$ SEQNO$$, TRANID$$ TRANID$$, VERSION$$ VERSION$$, LAST_UPDATE_DATE LAST_UPDATE_DATE, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, 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, CREATED_BY CREATED_BY, CUSTOMER_ID CUSTOMER_ID, ADDRESS_ID ADDRESS_ID, DESCRIPTION DESCRIPTION, ACTUAL_START_DATE ACTUAL_START_DATE, ACTUAL_END_DATE ACTUAL_END_DATE, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, ORG_ID ORG_ID, PRIVATE_FLAG PRIVATE_FLAG, BOUND_MODE_CODE BOUND_MODE_CODE, SOURCE_OBJECT_NAME SOURCE_OBJECT_NAME, LAPTOP_FLAG LAPTOP_FLAG, WINCE_FLAG WINCE_FLAG, DEVICE1_FLAG DEVICE1_FLAG, LOCATION_ID LOCATION_ID, CUST_ACCOUNT_ID CUST_ACCOUNT_ID, OWNER_ID OWNER_ID, OWNER_TYPE_CODE OWNER_TYPE_CODE, ACTUAL_EFFORT ACTUAL_EFFORT, ACTUAL_EFFORT_UOM ACTUAL_EFFORT_UOM, DURATION DURATION, DURATION_UOM DURATION_UOM, OWNER_NAME OWNER_NAME, LAST_UPDATED_BY LAST_UPDATED_BY, SERVER_LAST_UPDATE_DATE SERVER_LAST_UPDATE_DATE from "CSM"."CSM_TASKS_INQ"

View Text - HTML Formatted

SELECT TASK_ID TASK_ID
, TASK_NUMBER TASK_NUMBER
, TASK_NAME TASK_NAME
, TASK_TYPE_ID TASK_TYPE_ID
, TASK_STATUS_ID TASK_STATUS_ID
, TASK_PRIORITY_ID TASK_PRIORITY_ID
, ESCALATION_LEVEL ESCALATION_LEVEL
, PLANNED_START_DATE PLANNED_START_DATE
, PLANNED_END_DATE PLANNED_END_DATE
, PLANNED_EFFORT PLANNED_EFFORT
, PLANNED_EFFORT_UOM PLANNED_EFFORT_UOM
, SCHEDULED_START_DATE SCHEDULED_START_DATE
, SCHEDULED_END_DATE SCHEDULED_END_DATE
, SOURCE_OBJECT_ID SOURCE_OBJECT_ID
, SOURCE_OBJECT_TYPE_CODE SOURCE_OBJECT_TYPE_CODE
, CLID$$CS CLID$$CS
, DMLTYPE$$ DMLTYPE$$
, SEQNO$$ SEQNO$$
, TRANID$$ TRANID$$
, VERSION$$ VERSION$$
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, 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
, CREATED_BY CREATED_BY
, CUSTOMER_ID CUSTOMER_ID
, ADDRESS_ID ADDRESS_ID
, DESCRIPTION DESCRIPTION
, ACTUAL_START_DATE ACTUAL_START_DATE
, ACTUAL_END_DATE ACTUAL_END_DATE
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, ORG_ID ORG_ID
, PRIVATE_FLAG PRIVATE_FLAG
, BOUND_MODE_CODE BOUND_MODE_CODE
, SOURCE_OBJECT_NAME SOURCE_OBJECT_NAME
, LAPTOP_FLAG LAPTOP_FLAG
, WINCE_FLAG WINCE_FLAG
, DEVICE1_FLAG DEVICE1_FLAG
, LOCATION_ID LOCATION_ID
, CUST_ACCOUNT_ID CUST_ACCOUNT_ID
, OWNER_ID OWNER_ID
, OWNER_TYPE_CODE OWNER_TYPE_CODE
, ACTUAL_EFFORT ACTUAL_EFFORT
, ACTUAL_EFFORT_UOM ACTUAL_EFFORT_UOM
, DURATION DURATION
, DURATION_UOM DURATION_UOM
, OWNER_NAME OWNER_NAME
, LAST_UPDATED_BY LAST_UPDATED_BY
, SERVER_LAST_UPDATE_DATE SERVER_LAST_UPDATE_DATE
FROM "CSM"."CSM_TASKS_INQ"