VIEW: AHL.AHL_VISIT_TASKS_B#

Source

View Text - Preformatted

select VISIT_TASK_ID VISIT_TASK_ID, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, VISIT_ID VISIT_ID, PROJECT_TASK_ID PROJECT_TASK_ID, COST_PARENT_ID COST_PARENT_ID, MR_ROUTE_ID MR_ROUTE_ID, MR_ID MR_ID, DURATION DURATION, UNIT_EFFECTIVITY_ID UNIT_EFFECTIVITY_ID, START_FROM_HOUR START_FROM_HOUR, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, INSTANCE_ID INSTANCE_ID, PRIMARY_VISIT_TASK_ID PRIMARY_VISIT_TASK_ID, SUMMARY_TASK_FLAG SUMMARY_TASK_FLAG, ORIGINATING_TASK_ID ORIGINATING_TASK_ID, VISIT_TASK_NUMBER VISIT_TASK_NUMBER, ITEM_ORGANIZATION_ID ITEM_ORGANIZATION_ID, SERVICE_REQUEST_ID SERVICE_REQUEST_ID, TASK_TYPE_CODE TASK_TYPE_CODE, SECURITY_GROUP_ID SECURITY_GROUP_ID, 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, DEPARTMENT_ID DEPARTMENT_ID, STATUS_CODE STATUS_CODE, ESTIMATED_PRICE ESTIMATED_PRICE, ACTUAL_PRICE ACTUAL_PRICE, PRICE_LIST_ID PRICE_LIST_ID, ACTUAL_COST ACTUAL_COST, STAGE_ID STAGE_ID, START_DATE_TIME START_DATE_TIME, END_DATE_TIME END_DATE_TIME, QUANTITY QUANTITY, PAST_TASK_START_DATE PAST_TASK_START_DATE, PAST_TASK_END_DATE PAST_TASK_END_DATE, SERVICE_TYPE_CODE SERVICE_TYPE_CODE, ORIGINATING_MR_HEADER_ID ORIGINATING_MR_HEADER_ID, STAGE_TYPE_CODE STAGE_TYPE_CODE, RETURN_TO_SUPPLY_FLAG RETURN_TO_SUPPLY_FLAG, REPAIR_BATCH_NAME REPAIR_BATCH_NAME, TARGET_QTY TARGET_QTY, RET_SERVICEABLE_QTY RET_SERVICEABLE_QTY, RET_UNSERVICEABLE_QTY RET_UNSERVICEABLE_QTY from "AHL"."AHL_VISIT_TASKS_B"

View Text - HTML Formatted

SELECT VISIT_TASK_ID VISIT_TASK_ID
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, VISIT_ID VISIT_ID
, PROJECT_TASK_ID PROJECT_TASK_ID
, COST_PARENT_ID COST_PARENT_ID
, MR_ROUTE_ID MR_ROUTE_ID
, MR_ID MR_ID
, DURATION DURATION
, UNIT_EFFECTIVITY_ID UNIT_EFFECTIVITY_ID
, START_FROM_HOUR START_FROM_HOUR
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, INSTANCE_ID INSTANCE_ID
, PRIMARY_VISIT_TASK_ID PRIMARY_VISIT_TASK_ID
, SUMMARY_TASK_FLAG SUMMARY_TASK_FLAG
, ORIGINATING_TASK_ID ORIGINATING_TASK_ID
, VISIT_TASK_NUMBER VISIT_TASK_NUMBER
, ITEM_ORGANIZATION_ID ITEM_ORGANIZATION_ID
, SERVICE_REQUEST_ID SERVICE_REQUEST_ID
, TASK_TYPE_CODE TASK_TYPE_CODE
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, 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
, DEPARTMENT_ID DEPARTMENT_ID
, STATUS_CODE STATUS_CODE
, ESTIMATED_PRICE ESTIMATED_PRICE
, ACTUAL_PRICE ACTUAL_PRICE
, PRICE_LIST_ID PRICE_LIST_ID
, ACTUAL_COST ACTUAL_COST
, STAGE_ID STAGE_ID
, START_DATE_TIME START_DATE_TIME
, END_DATE_TIME END_DATE_TIME
, QUANTITY QUANTITY
, PAST_TASK_START_DATE PAST_TASK_START_DATE
, PAST_TASK_END_DATE PAST_TASK_END_DATE
, SERVICE_TYPE_CODE SERVICE_TYPE_CODE
, ORIGINATING_MR_HEADER_ID ORIGINATING_MR_HEADER_ID
, STAGE_TYPE_CODE STAGE_TYPE_CODE
, RETURN_TO_SUPPLY_FLAG RETURN_TO_SUPPLY_FLAG
, REPAIR_BATCH_NAME REPAIR_BATCH_NAME
, TARGET_QTY TARGET_QTY
, RET_SERVICEABLE_QTY RET_SERVICEABLE_QTY
, RET_UNSERVICEABLE_QTY RET_UNSERVICEABLE_QTY
FROM "AHL"."AHL_VISIT_TASKS_B"