VIEW: CSD.CSD_REPAIRS_INTERFACE#

Source

View Text - Preformatted

select TRANSACTION_ID TRANSACTION_ID, GROUP_ID GROUP_ID, SR_ACCOUNT_ID SR_ACCOUNT_ID, SR_PARTY_ID SR_PARTY_ID, SR_INCIDENT_ID SR_INCIDENT_ID, SR_INCIDENT_SUMMARY SR_INCIDENT_SUMMARY, SR_BILL_TO_SITE_USE_ID SR_BILL_TO_SITE_USE_ID, SR_SHIP_TO_SITE_USE_ID SR_SHIP_TO_SITE_USE_ID, SR_TYPE_ID SR_TYPE_ID, SR_STATUS_ID SR_STATUS_ID, SR_SEVERITY_ID SR_SEVERITY_ID, SR_URGENCY_ID SR_URGENCY_ID, SR_OWNER_ID SR_OWNER_ID, SR_RESOURCE_TYPE SR_RESOURCE_TYPE, 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, 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, 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, RO_TXN_STATUS RO_TXN_STATUS, REPAIR_GROUP_ID REPAIR_GROUP_ID, CURRENCY_CODE CURRENCY_CODE, ORIGINAL_SOURCE_HEADER_ID ORIGINAL_SOURCE_HEADER_ID, ORIGINAL_SOURCE_LINE_ID ORIGINAL_SOURCE_LINE_ID, PRICE_LIST_HEADER_ID PRICE_LIST_HEADER_ID, DEFAULT_PO_NUM DEFAULT_PO_NUM, SPLIT_FROM_REP_LINE_ID SPLIT_FROM_REP_LINE_ID, SPLIT_FLAG SPLIT_FLAG, SUPERCESSION_INV_ITEM_ID SUPERCESSION_INV_ITEM_ID, OWNING_ORGANIZATION OWNING_ORGANIZATION, OWNING_ORGANIZATION_ID OWNING_ORGANIZATION_ID, UNIT_NUMBER UNIT_NUMBER, 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, ESCALATED_CODE ESCALATED_CODE, IN_WARRANTY_CODE IN_WARRANTY_CODE, WARRANTY_VIOLATION_CODE WARRANTY_VIOLATION_CODE, REWORK_CODE REWORK_CODE, BULLETIN_CHECK_DATE BULLETIN_CHECK_DATE, SUPERCESSION_QUANTITY SUPERCESSION_QUANTITY, ESCALATION_CODE ESCALATION_CODE, REPAIR_YIELD_QUANTITY REPAIR_YIELD_QUANTITY, LOT_NUMBER LOT_NUMBER, EXTERNAL_REFERENCE EXTERNAL_REFERENCE, PROCESSING_PHASE PROCESSING_PHASE, SERIAL_CONTROL_FLAG SERIAL_CONTROL_FLAG, REVISION_CONTROL_FLAG REVISION_CONTROL_FLAG, IB_CONTROL_FLAG IB_CONTROL_FLAG from "CSD"."CSD_REPAIRS_INTERFACE"

View Text - HTML Formatted

SELECT TRANSACTION_ID TRANSACTION_ID
, GROUP_ID GROUP_ID
, SR_ACCOUNT_ID SR_ACCOUNT_ID
, SR_PARTY_ID SR_PARTY_ID
, SR_INCIDENT_ID SR_INCIDENT_ID
, SR_INCIDENT_SUMMARY SR_INCIDENT_SUMMARY
, SR_BILL_TO_SITE_USE_ID SR_BILL_TO_SITE_USE_ID
, SR_SHIP_TO_SITE_USE_ID SR_SHIP_TO_SITE_USE_ID
, SR_TYPE_ID SR_TYPE_ID
, SR_STATUS_ID SR_STATUS_ID
, SR_SEVERITY_ID SR_SEVERITY_ID
, SR_URGENCY_ID SR_URGENCY_ID
, SR_OWNER_ID SR_OWNER_ID
, SR_RESOURCE_TYPE SR_RESOURCE_TYPE
, 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
, 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
, 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
, RO_TXN_STATUS RO_TXN_STATUS
, REPAIR_GROUP_ID REPAIR_GROUP_ID
, CURRENCY_CODE CURRENCY_CODE
, ORIGINAL_SOURCE_HEADER_ID ORIGINAL_SOURCE_HEADER_ID
, ORIGINAL_SOURCE_LINE_ID ORIGINAL_SOURCE_LINE_ID
, PRICE_LIST_HEADER_ID PRICE_LIST_HEADER_ID
, DEFAULT_PO_NUM DEFAULT_PO_NUM
, SPLIT_FROM_REP_LINE_ID SPLIT_FROM_REP_LINE_ID
, SPLIT_FLAG SPLIT_FLAG
, SUPERCESSION_INV_ITEM_ID SUPERCESSION_INV_ITEM_ID
, OWNING_ORGANIZATION OWNING_ORGANIZATION
, OWNING_ORGANIZATION_ID OWNING_ORGANIZATION_ID
, UNIT_NUMBER UNIT_NUMBER
, 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
, ESCALATED_CODE ESCALATED_CODE
, IN_WARRANTY_CODE IN_WARRANTY_CODE
, WARRANTY_VIOLATION_CODE WARRANTY_VIOLATION_CODE
, REWORK_CODE REWORK_CODE
, BULLETIN_CHECK_DATE BULLETIN_CHECK_DATE
, SUPERCESSION_QUANTITY SUPERCESSION_QUANTITY
, ESCALATION_CODE ESCALATION_CODE
, REPAIR_YIELD_QUANTITY REPAIR_YIELD_QUANTITY
, LOT_NUMBER LOT_NUMBER
, EXTERNAL_REFERENCE EXTERNAL_REFERENCE
, PROCESSING_PHASE PROCESSING_PHASE
, SERIAL_CONTROL_FLAG SERIAL_CONTROL_FLAG
, REVISION_CONTROL_FLAG REVISION_CONTROL_FLAG
, IB_CONTROL_FLAG IB_CONTROL_FLAG
FROM "CSD"."CSD_REPAIRS_INTERFACE"