VIEW: CS.CS_REPAIRS_ALL#

Source

View Text - Preformatted

select REPAIR_LINE_ID REPAIR_LINE_ID, 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, REQUEST_ID REQUEST_ID, REPAIR_NUMBER REPAIR_NUMBER, PROGRAM_ID PROGRAM_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, RMA_HEADER_ID RMA_HEADER_ID, RMA_LINE_ID RMA_LINE_ID, RMA_CUSTOMER_ID RMA_CUSTOMER_ID, RMA_NUMBER RMA_NUMBER, RMA_TYPE_ID RMA_TYPE_ID, RMA_DATE RMA_DATE, RMA_LINE_NUMBER RMA_LINE_NUMBER, REPAIR_DURATION REPAIR_DURATION, RECEIVED_DATE RECEIVED_DATE, MTL_TRANSACTION_ID MTL_TRANSACTION_ID, SHIPPED_DATE SHIPPED_DATE, ESTIMATE_ID ESTIMATE_ID, WIP_ENTITY_ID WIP_ENTITY_ID, GROUP_ID GROUP_ID, REPAIR_HEADER_ID REPAIR_HEADER_ID, REPAIR_ORDER_LINE_ID REPAIR_ORDER_LINE_ID, REPLACE_HEADER_ID REPLACE_HEADER_ID, LOANER_HEADER_ID LOANER_HEADER_ID, CUSTOMER_PRODUCT_ID CUSTOMER_PRODUCT_ID, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, SERIAL_NUMBER SERIAL_NUMBER, QUANTITY_RECEIVED QUANTITY_RECEIVED, QUANTITY_COMPLETE QUANTITY_COMPLETE, QUANTITY_SCRAPPED QUANTITY_SCRAPPED, QUANTITY_REPLACED QUANTITY_REPLACED, REPAIR_UNIT_OF_MEASURE_CODE REPAIR_UNIT_OF_MEASURE_CODE, STATUS STATUS, 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, CONTEXT CONTEXT, ORG_ID ORG_ID, ORGANIZATION_ID ORGANIZATION_ID, RECVD_ORGANIZATION_ID RECVD_ORGANIZATION_ID, ORIGINAL_SYSTEM_REFERENCE ORIGINAL_SYSTEM_REFERENCE, ORIGINAL_SYSTEM_LINE_REFERENCE ORIGINAL_SYSTEM_LINE_REFERENCE, ALLOW_JOB ALLOW_JOB, INCIDENT_ID INCIDENT_ID, ESTIMATE_BUSINESS_GROUP_ID ESTIMATE_BUSINESS_GROUP_ID, DIAGNOSIS_ID DIAGNOSIS_ID, DIAGNOSED_BY_ID DIAGNOSED_BY_ID, JOB_COMPLETION_DATE JOB_COMPLETION_DATE, PROMISED_DELIVERY_DATE PROMISED_DELIVERY_DATE, PROJECT_ID PROJECT_ID, TASK_ID TASK_ID from "CS"."CS_REPAIRS_ALL"

View Text - HTML Formatted

SELECT REPAIR_LINE_ID REPAIR_LINE_ID
, 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
, REQUEST_ID REQUEST_ID
, REPAIR_NUMBER REPAIR_NUMBER
, PROGRAM_ID PROGRAM_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, RMA_HEADER_ID RMA_HEADER_ID
, RMA_LINE_ID RMA_LINE_ID
, RMA_CUSTOMER_ID RMA_CUSTOMER_ID
, RMA_NUMBER RMA_NUMBER
, RMA_TYPE_ID RMA_TYPE_ID
, RMA_DATE RMA_DATE
, RMA_LINE_NUMBER RMA_LINE_NUMBER
, REPAIR_DURATION REPAIR_DURATION
, RECEIVED_DATE RECEIVED_DATE
, MTL_TRANSACTION_ID MTL_TRANSACTION_ID
, SHIPPED_DATE SHIPPED_DATE
, ESTIMATE_ID ESTIMATE_ID
, WIP_ENTITY_ID WIP_ENTITY_ID
, GROUP_ID GROUP_ID
, REPAIR_HEADER_ID REPAIR_HEADER_ID
, REPAIR_ORDER_LINE_ID REPAIR_ORDER_LINE_ID
, REPLACE_HEADER_ID REPLACE_HEADER_ID
, LOANER_HEADER_ID LOANER_HEADER_ID
, CUSTOMER_PRODUCT_ID CUSTOMER_PRODUCT_ID
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, SERIAL_NUMBER SERIAL_NUMBER
, QUANTITY_RECEIVED QUANTITY_RECEIVED
, QUANTITY_COMPLETE QUANTITY_COMPLETE
, QUANTITY_SCRAPPED QUANTITY_SCRAPPED
, QUANTITY_REPLACED QUANTITY_REPLACED
, REPAIR_UNIT_OF_MEASURE_CODE REPAIR_UNIT_OF_MEASURE_CODE
, STATUS STATUS
, 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
, CONTEXT CONTEXT
, ORG_ID ORG_ID
, ORGANIZATION_ID ORGANIZATION_ID
, RECVD_ORGANIZATION_ID RECVD_ORGANIZATION_ID
, ORIGINAL_SYSTEM_REFERENCE ORIGINAL_SYSTEM_REFERENCE
, ORIGINAL_SYSTEM_LINE_REFERENCE ORIGINAL_SYSTEM_LINE_REFERENCE
, ALLOW_JOB ALLOW_JOB
, INCIDENT_ID INCIDENT_ID
, ESTIMATE_BUSINESS_GROUP_ID ESTIMATE_BUSINESS_GROUP_ID
, DIAGNOSIS_ID DIAGNOSIS_ID
, DIAGNOSED_BY_ID DIAGNOSED_BY_ID
, JOB_COMPLETION_DATE JOB_COMPLETION_DATE
, PROMISED_DELIVERY_DATE PROMISED_DELIVERY_DATE
, PROJECT_ID PROJECT_ID
, TASK_ID TASK_ID
FROM "CS"."CS_REPAIRS_ALL"