VIEW: CSD.CSD_REPAIRS#

Source

View Text - Preformatted

select REPAIR_LINE_ID REPAIR_LINE_ID, REQUEST_ID REQUEST_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, 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, REPAIR_NUMBER REPAIR_NUMBER, INCIDENT_ID INCIDENT_ID, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, CUSTOMER_PRODUCT_ID CUSTOMER_PRODUCT_ID, UNIT_OF_MEASURE UNIT_OF_MEASURE, REPAIR_TYPE_ID REPAIR_TYPE_ID, RESOURCE_ID RESOURCE_ID, INSTANCE_ID INSTANCE_ID, PROJECT_ID PROJECT_ID, TASK_ID TASK_ID, CONTRACT_LINE_ID CONTRACT_LINE_ID, QUANTITY QUANTITY, STATUS STATUS, APPROVAL_REQUIRED_FLAG APPROVAL_REQUIRED_FLAG, DATE_CLOSED DATE_CLOSED, QUANTITY_IN_WIP QUANTITY_IN_WIP, APPROVAL_STATUS APPROVAL_STATUS, QUANTITY_RCVD QUANTITY_RCVD, QUANTITY_SHIPPED QUANTITY_SHIPPED, SERIAL_NUMBER SERIAL_NUMBER, PROMISE_DATE PROMISE_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, SECURITY_GROUP_ID SECURITY_GROUP_ID, ORDER_LINE_ID ORDER_LINE_ID, ORIGINAL_SOURCE_REFERENCE ORIGINAL_SOURCE_REFERENCE, STATUS_REASON_CODE STATUS_REASON_CODE, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, AUTO_PROCESS_RMA AUTO_PROCESS_RMA, REPAIR_MODE REPAIR_MODE, ITEM_REVISION ITEM_REVISION, REPAIR_GROUP_ID REPAIR_GROUP_ID, RO_TXN_STATUS RO_TXN_STATUS, CURRENCY_CODE CURRENCY_CODE, DEFAULT_PO_NUM DEFAULT_PO_NUM, ORIGINAL_SOURCE_HEADER_ID ORIGINAL_SOURCE_HEADER_ID, ORIGINAL_SOURCE_LINE_ID ORIGINAL_SOURCE_LINE_ID, SPLIT_FROM_REP_LINE_ID SPLIT_FROM_REP_LINE_ID, SPLIT_FLAG SPLIT_FLAG, PRICE_LIST_HEADER_ID PRICE_LIST_HEADER_ID, SUPERCESSION_INV_ITEM_ID SUPERCESSION_INV_ITEM_ID, OWNING_ORGANIZATION OWNING_ORGANIZATION, UNIT_NUMBER UNIT_NUMBER, OWNING_ORGANIZATION_ID OWNING_ORGANIZATION_ID, PROBLEM_DESCRIPTION PROBLEM_DESCRIPTION, FLOW_STATUS_ID FLOW_STATUS_ID, WF_ITEM_TYPE WF_ITEM_TYPE, WF_ITEM_KEY WF_ITEM_KEY, INVENTORY_ORG_ID INVENTORY_ORG_ID, RO_PRIORITY_CODE RO_PRIORITY_CODE, RESOLVE_BY_DATE RESOLVE_BY_DATE, ESCALATION_CODE ESCALATION_CODE, IN_WARRANTY_CODE IN_WARRANTY_CODE, WARRANTY_VIOLATION_CODE WARRANTY_VIOLATION_CODE, REWORK_CODE REWORK_CODE, BULLETIN_CHECK_DATE BULLETIN_CHECK_DATE, REPAIR_YIELD_QUANTITY REPAIR_YIELD_QUANTITY, ATTRIBUTE16 ATTRIBUTE16, ATTRIBUTE17 ATTRIBUTE17, ATTRIBUTE18 ATTRIBUTE18, ATTRIBUTE19 ATTRIBUTE19, ATTRIBUTE20 ATTRIBUTE20, ATTRIBUTE21 ATTRIBUTE21, ATTRIBUTE22 ATTRIBUTE22, ATTRIBUTE23 ATTRIBUTE23, ATTRIBUTE24 ATTRIBUTE24, ATTRIBUTE25 ATTRIBUTE25, ATTRIBUTE26 ATTRIBUTE26, ATTRIBUTE27 ATTRIBUTE27, ATTRIBUTE28 ATTRIBUTE28, ATTRIBUTE29 ATTRIBUTE29, ATTRIBUTE30 ATTRIBUTE30, RO_WARRANTY_STATUS_CODE RO_WARRANTY_STATUS_CODE, RETURN_ATTRIBUTE_CATEGORY RETURN_ATTRIBUTE_CATEGORY, RETURN_ATTRIBUTE1 RETURN_ATTRIBUTE1, RETURN_ATTRIBUTE2 RETURN_ATTRIBUTE2, RETURN_ATTRIBUTE3 RETURN_ATTRIBUTE3, RETURN_ATTRIBUTE4 RETURN_ATTRIBUTE4, RETURN_ATTRIBUTE5 RETURN_ATTRIBUTE5, RETURN_ATTRIBUTE6 RETURN_ATTRIBUTE6, RETURN_ATTRIBUTE7 RETURN_ATTRIBUTE7, RETURN_ATTRIBUTE8 RETURN_ATTRIBUTE8, RETURN_ATTRIBUTE9 RETURN_ATTRIBUTE9, RETURN_ATTRIBUTE10 RETURN_ATTRIBUTE10, RETURN_ATTRIBUTE11 RETURN_ATTRIBUTE11, RETURN_ATTRIBUTE12 RETURN_ATTRIBUTE12, RETURN_ATTRIBUTE13 RETURN_ATTRIBUTE13, RETURN_ATTRIBUTE14 RETURN_ATTRIBUTE14, RETURN_ATTRIBUTE15 RETURN_ATTRIBUTE15, RETURN_ATTRIBUTE16 RETURN_ATTRIBUTE16, RETURN_ATTRIBUTE17 RETURN_ATTRIBUTE17, RETURN_ATTRIBUTE18 RETURN_ATTRIBUTE18, RETURN_ATTRIBUTE19 RETURN_ATTRIBUTE19, RETURN_ATTRIBUTE20 RETURN_ATTRIBUTE20, RETURN_ATTRIBUTE21 RETURN_ATTRIBUTE21, RETURN_ATTRIBUTE22 RETURN_ATTRIBUTE22, RETURN_ATTRIBUTE23 RETURN_ATTRIBUTE23, RETURN_ATTRIBUTE24 RETURN_ATTRIBUTE24, RETURN_ATTRIBUTE25 RETURN_ATTRIBUTE25, RETURN_ATTRIBUTE26 RETURN_ATTRIBUTE26, RETURN_ATTRIBUTE27 RETURN_ATTRIBUTE27, RETURN_ATTRIBUTE28 RETURN_ATTRIBUTE28, RETURN_ATTRIBUTE29 RETURN_ATTRIBUTE29, RETURN_ATTRIBUTE30 RETURN_ATTRIBUTE30, WAYBILL_NO WAYBILL_NO, RETURN_TYPE_ID RETURN_TYPE_ID, PARENT_REPAIR_LINE_ID PARENT_REPAIR_LINE_ID from "CSD"."CSD_REPAIRS"

View Text - HTML Formatted

SELECT REPAIR_LINE_ID REPAIR_LINE_ID
, REQUEST_ID REQUEST_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, 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
, REPAIR_NUMBER REPAIR_NUMBER
, INCIDENT_ID INCIDENT_ID
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, CUSTOMER_PRODUCT_ID CUSTOMER_PRODUCT_ID
, UNIT_OF_MEASURE UNIT_OF_MEASURE
, REPAIR_TYPE_ID REPAIR_TYPE_ID
, RESOURCE_ID RESOURCE_ID
, INSTANCE_ID INSTANCE_ID
, PROJECT_ID PROJECT_ID
, TASK_ID TASK_ID
, CONTRACT_LINE_ID CONTRACT_LINE_ID
, QUANTITY QUANTITY
, STATUS STATUS
, APPROVAL_REQUIRED_FLAG APPROVAL_REQUIRED_FLAG
, DATE_CLOSED DATE_CLOSED
, QUANTITY_IN_WIP QUANTITY_IN_WIP
, APPROVAL_STATUS APPROVAL_STATUS
, QUANTITY_RCVD QUANTITY_RCVD
, QUANTITY_SHIPPED QUANTITY_SHIPPED
, SERIAL_NUMBER SERIAL_NUMBER
, PROMISE_DATE PROMISE_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
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, ORDER_LINE_ID ORDER_LINE_ID
, ORIGINAL_SOURCE_REFERENCE ORIGINAL_SOURCE_REFERENCE
, STATUS_REASON_CODE STATUS_REASON_CODE
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, AUTO_PROCESS_RMA AUTO_PROCESS_RMA
, REPAIR_MODE REPAIR_MODE
, ITEM_REVISION ITEM_REVISION
, REPAIR_GROUP_ID REPAIR_GROUP_ID
, RO_TXN_STATUS RO_TXN_STATUS
, CURRENCY_CODE CURRENCY_CODE
, DEFAULT_PO_NUM DEFAULT_PO_NUM
, ORIGINAL_SOURCE_HEADER_ID ORIGINAL_SOURCE_HEADER_ID
, ORIGINAL_SOURCE_LINE_ID ORIGINAL_SOURCE_LINE_ID
, SPLIT_FROM_REP_LINE_ID SPLIT_FROM_REP_LINE_ID
, SPLIT_FLAG SPLIT_FLAG
, PRICE_LIST_HEADER_ID PRICE_LIST_HEADER_ID
, SUPERCESSION_INV_ITEM_ID SUPERCESSION_INV_ITEM_ID
, OWNING_ORGANIZATION OWNING_ORGANIZATION
, UNIT_NUMBER UNIT_NUMBER
, OWNING_ORGANIZATION_ID OWNING_ORGANIZATION_ID
, PROBLEM_DESCRIPTION PROBLEM_DESCRIPTION
, FLOW_STATUS_ID FLOW_STATUS_ID
, WF_ITEM_TYPE WF_ITEM_TYPE
, WF_ITEM_KEY WF_ITEM_KEY
, INVENTORY_ORG_ID INVENTORY_ORG_ID
, RO_PRIORITY_CODE RO_PRIORITY_CODE
, RESOLVE_BY_DATE RESOLVE_BY_DATE
, ESCALATION_CODE ESCALATION_CODE
, IN_WARRANTY_CODE IN_WARRANTY_CODE
, WARRANTY_VIOLATION_CODE WARRANTY_VIOLATION_CODE
, REWORK_CODE REWORK_CODE
, BULLETIN_CHECK_DATE BULLETIN_CHECK_DATE
, REPAIR_YIELD_QUANTITY REPAIR_YIELD_QUANTITY
, ATTRIBUTE16 ATTRIBUTE16
, ATTRIBUTE17 ATTRIBUTE17
, ATTRIBUTE18 ATTRIBUTE18
, ATTRIBUTE19 ATTRIBUTE19
, ATTRIBUTE20 ATTRIBUTE20
, ATTRIBUTE21 ATTRIBUTE21
, ATTRIBUTE22 ATTRIBUTE22
, ATTRIBUTE23 ATTRIBUTE23
, ATTRIBUTE24 ATTRIBUTE24
, ATTRIBUTE25 ATTRIBUTE25
, ATTRIBUTE26 ATTRIBUTE26
, ATTRIBUTE27 ATTRIBUTE27
, ATTRIBUTE28 ATTRIBUTE28
, ATTRIBUTE29 ATTRIBUTE29
, ATTRIBUTE30 ATTRIBUTE30
, RO_WARRANTY_STATUS_CODE RO_WARRANTY_STATUS_CODE
, RETURN_ATTRIBUTE_CATEGORY RETURN_ATTRIBUTE_CATEGORY
, RETURN_ATTRIBUTE1 RETURN_ATTRIBUTE1
, RETURN_ATTRIBUTE2 RETURN_ATTRIBUTE2
, RETURN_ATTRIBUTE3 RETURN_ATTRIBUTE3
, RETURN_ATTRIBUTE4 RETURN_ATTRIBUTE4
, RETURN_ATTRIBUTE5 RETURN_ATTRIBUTE5
, RETURN_ATTRIBUTE6 RETURN_ATTRIBUTE6
, RETURN_ATTRIBUTE7 RETURN_ATTRIBUTE7
, RETURN_ATTRIBUTE8 RETURN_ATTRIBUTE8
, RETURN_ATTRIBUTE9 RETURN_ATTRIBUTE9
, RETURN_ATTRIBUTE10 RETURN_ATTRIBUTE10
, RETURN_ATTRIBUTE11 RETURN_ATTRIBUTE11
, RETURN_ATTRIBUTE12 RETURN_ATTRIBUTE12
, RETURN_ATTRIBUTE13 RETURN_ATTRIBUTE13
, RETURN_ATTRIBUTE14 RETURN_ATTRIBUTE14
, RETURN_ATTRIBUTE15 RETURN_ATTRIBUTE15
, RETURN_ATTRIBUTE16 RETURN_ATTRIBUTE16
, RETURN_ATTRIBUTE17 RETURN_ATTRIBUTE17
, RETURN_ATTRIBUTE18 RETURN_ATTRIBUTE18
, RETURN_ATTRIBUTE19 RETURN_ATTRIBUTE19
, RETURN_ATTRIBUTE20 RETURN_ATTRIBUTE20
, RETURN_ATTRIBUTE21 RETURN_ATTRIBUTE21
, RETURN_ATTRIBUTE22 RETURN_ATTRIBUTE22
, RETURN_ATTRIBUTE23 RETURN_ATTRIBUTE23
, RETURN_ATTRIBUTE24 RETURN_ATTRIBUTE24
, RETURN_ATTRIBUTE25 RETURN_ATTRIBUTE25
, RETURN_ATTRIBUTE26 RETURN_ATTRIBUTE26
, RETURN_ATTRIBUTE27 RETURN_ATTRIBUTE27
, RETURN_ATTRIBUTE28 RETURN_ATTRIBUTE28
, RETURN_ATTRIBUTE29 RETURN_ATTRIBUTE29
, RETURN_ATTRIBUTE30 RETURN_ATTRIBUTE30
, WAYBILL_NO WAYBILL_NO
, RETURN_TYPE_ID RETURN_TYPE_ID
, PARENT_REPAIR_LINE_ID PARENT_REPAIR_LINE_ID
FROM "CSD"."CSD_REPAIRS"