VIEW: QA.QA_RESULTS_INTERFACE#

Source

View Text - Preformatted

select TRANSACTION_INTERFACE_ID TRANSACTION_INTERFACE_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, QA_LAST_UPDATED_BY QA_LAST_UPDATED_BY, QA_LAST_UPDATED_BY_NAME QA_LAST_UPDATED_BY_NAME, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, QA_CREATED_BY QA_CREATED_BY, QA_CREATED_BY_NAME QA_CREATED_BY_NAME, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, COLLECTION_ID COLLECTION_ID, GROUP_ID GROUP_ID, SOURCE_CODE SOURCE_CODE, SOURCE_LINE_ID SOURCE_LINE_ID, PROCESS_STATUS PROCESS_STATUS, VALIDATE_FLAG VALIDATE_FLAG, MARKER MARKER, ORGANIZATION_ID ORGANIZATION_ID, ORGANIZATION_CODE ORGANIZATION_CODE, PLAN_ID PLAN_ID, PLAN_NAME PLAN_NAME, SPEC_ID SPEC_ID, SPEC_NAME SPEC_NAME, DEPARTMENT_ID DEPARTMENT_ID, DEPARTMENT DEPARTMENT, TO_DEPARTMENT_ID TO_DEPARTMENT_ID, TO_DEPARTMENT TO_DEPARTMENT, RESOURCE_ID RESOURCE_ID, RESOURCE_CODE RESOURCE_CODE, QUANTITY QUANTITY, ITEM_ID ITEM_ID, ITEM ITEM, UOM UOM, REVISION REVISION, SUBINVENTORY SUBINVENTORY, LOCATOR_ID LOCATOR_ID, LOCATOR LOCATOR, LOT_NUMBER LOT_NUMBER, SERIAL_NUMBER SERIAL_NUMBER, COMP_ITEM_ID COMP_ITEM_ID, COMP_ITEM COMP_ITEM, COMP_UOM COMP_UOM, COMP_REVISION COMP_REVISION, COMP_SUBINVENTORY COMP_SUBINVENTORY, COMP_LOCATOR_ID COMP_LOCATOR_ID, COMP_LOCATOR COMP_LOCATOR, COMP_LOT_NUMBER COMP_LOT_NUMBER, COMP_SERIAL_NUMBER COMP_SERIAL_NUMBER, WIP_ENTITY_ID WIP_ENTITY_ID, JOB_NAME JOB_NAME, LINE_ID LINE_ID, PRODUCTION_LINE PRODUCTION_LINE, TO_OP_SEQ_NUM TO_OP_SEQ_NUM, FROM_OP_SEQ_NUM FROM_OP_SEQ_NUM, VENDOR_ID VENDOR_ID, VENDOR_NAME VENDOR_NAME, RECEIPT_NUM RECEIPT_NUM, PO_HEADER_ID PO_HEADER_ID, PO_RELEASE_ID PO_RELEASE_ID, PO_RELEASE_NUM PO_RELEASE_NUM, PO_TYPE_LOOKUP PO_TYPE_LOOKUP, PO_NUMBER PO_NUMBER, PO_LINE_NUM PO_LINE_NUM, PO_SHIPMENT_NUM PO_SHIPMENT_NUM, CUSTOMER_ID CUSTOMER_ID, CUSTOMER_NAME CUSTOMER_NAME, SO_HEADER_ID SO_HEADER_ID, SALES_ORDER SALES_ORDER, RESTRICT_LOCATORS_CODE RESTRICT_LOCATORS_CODE, LOCATION_CONTROL_CODE LOCATION_CONTROL_CODE, REVISION_QTY_CONTROL_CODE REVISION_QTY_CONTROL_CODE, RESTRICT_SUBINV_CODE RESTRICT_SUBINV_CODE, SUB_LOCATOR_TYPE SUB_LOCATOR_TYPE, GEN_LOC_CTRL_CODE GEN_LOC_CTRL_CODE, COMP_RESTRICT_LOCATORS_CODE COMP_RESTRICT_LOCATORS_CODE, COMP_LOCATION_CONTROL_CODE COMP_LOCATION_CONTROL_CODE, COMP_REVISION_QTY_CONTROL_CODE COMP_REVISION_QTY_CONTROL_CODE, COMP_RESTRICT_SUBINV_CODE COMP_RESTRICT_SUBINV_CODE, COMP_SUB_LOCATOR_TYPE COMP_SUB_LOCATOR_TYPE, PROJECT_ID PROJECT_ID, PROJECT_NUMBER PROJECT_NUMBER, TASK_ID TASK_ID, TASK_NUMBER TASK_NUMBER, STATUS STATUS, TRANSACTION_DATE TRANSACTION_DATE, COMP_GEN_LOC_CTRL_CODE COMP_GEN_LOC_CTRL_CODE, RMA_HEADER_ID RMA_HEADER_ID, RMA_NUMBER RMA_NUMBER, INSERT_TYPE INSERT_TYPE, MATCHING_ELEMENTS MATCHING_ELEMENTS, CHARACTER1 CHARACTER1, CHARACTER2 CHARACTER2, CHARACTER3 CHARACTER3, CHARACTER4 CHARACTER4, CHARACTER5 CHARACTER5, CHARACTER6 CHARACTER6, CHARACTER7 CHARACTER7, CHARACTER8 CHARACTER8, CHARACTER9 CHARACTER9, CHARACTER10 CHARACTER10, CHARACTER11 CHARACTER11, CHARACTER12 CHARACTER12, CHARACTER13 CHARACTER13, CHARACTER14 CHARACTER14, CHARACTER15 CHARACTER15, CHARACTER16 CHARACTER16, CHARACTER17 CHARACTER17, CHARACTER18 CHARACTER18, CHARACTER19 CHARACTER19, CHARACTER20 CHARACTER20, CHARACTER21 CHARACTER21, CHARACTER22 CHARACTER22, CHARACTER23 CHARACTER23, CHARACTER24 CHARACTER24, CHARACTER25 CHARACTER25, CHARACTER26 CHARACTER26, CHARACTER27 CHARACTER27, CHARACTER28 CHARACTER28, CHARACTER29 CHARACTER29, CHARACTER30 CHARACTER30, CHARACTER31 CHARACTER31, CHARACTER32 CHARACTER32, CHARACTER33 CHARACTER33, CHARACTER34 CHARACTER34, CHARACTER35 CHARACTER35, CHARACTER36 CHARACTER36, CHARACTER37 CHARACTER37, CHARACTER41 CHARACTER41, CHARACTER42 CHARACTER42, CHARACTER43 CHARACTER43, CHARACTER44 CHARACTER44, CHARACTER45 CHARACTER45, CHARACTER46 CHARACTER46, CHARACTER47 CHARACTER47, CHARACTER48 CHARACTER48, CHARACTER49 CHARACTER49, CHARACTER50 CHARACTER50, CHARACTER51 CHARACTER51, CHARACTER52 CHARACTER52, CHARACTER53 CHARACTER53, CHARACTER54 CHARACTER54, CHARACTER55 CHARACTER55, CHARACTER56 CHARACTER56, CHARACTER57 CHARACTER57, CHARACTER58 CHARACTER58, CHARACTER59 CHARACTER59, CHARACTER60 CHARACTER60, CHARACTER61 CHARACTER61, CHARACTER62 CHARACTER62, CHARACTER63 CHARACTER63, CHARACTER64 CHARACTER64, CHARACTER65 CHARACTER65, CHARACTER66 CHARACTER66, CHARACTER67 CHARACTER67, CHARACTER68 CHARACTER68, CHARACTER69 CHARACTER69, CHARACTER70 CHARACTER70, CHARACTER71 CHARACTER71, CHARACTER72 CHARACTER72, CHARACTER73 CHARACTER73, CHARACTER74 CHARACTER74, CHARACTER75 CHARACTER75, CHARACTER76 CHARACTER76, CHARACTER77 CHARACTER77, CHARACTER78 CHARACTER78, CHARACTER79 CHARACTER79, CHARACTER80 CHARACTER80, CHARACTER81 CHARACTER81, CHARACTER82 CHARACTER82, CHARACTER83 CHARACTER83, CHARACTER84 CHARACTER84, CHARACTER85 CHARACTER85, CHARACTER86 CHARACTER86, CHARACTER87 CHARACTER87, CHARACTER88 CHARACTER88, CHARACTER89 CHARACTER89, CHARACTER90 CHARACTER90, CHARACTER91 CHARACTER91, CHARACTER92 CHARACTER92, CHARACTER93 CHARACTER93, CHARACTER94 CHARACTER94, CHARACTER95 CHARACTER95, CHARACTER96 CHARACTER96, CHARACTER97 CHARACTER97, CHARACTER98 CHARACTER98, CHARACTER99 CHARACTER99, CHARACTER100 CHARACTER100, CHARACTER38 CHARACTER38, CHARACTER39 CHARACTER39, CHARACTER40 CHARACTER40, PO_AGENT_ID PO_AGENT_ID, LPN_ID LPN_ID, LICENSE_PLATE_NUMBER LICENSE_PLATE_NUMBER, CONTRACT_ID CONTRACT_ID, CONTRACT_NUMBER CONTRACT_NUMBER, CONTRACT_LINE_ID CONTRACT_LINE_ID, CONTRACT_LINE_NUMBER CONTRACT_LINE_NUMBER, DELIVERABLE_ID DELIVERABLE_ID, DELIVERABLE_NUMBER DELIVERABLE_NUMBER, ASSET_GROUP_ID ASSET_GROUP_ID, ASSET_GROUP ASSET_GROUP, ASSET_NUMBER ASSET_NUMBER, ASSET_ACTIVITY_ID ASSET_ACTIVITY_ID, ASSET_ACTIVITY ASSET_ACTIVITY, WORK_ORDER_ID WORK_ORDER_ID, WORK_ORDER WORK_ORDER, SEQUENCE1 SEQUENCE1, SEQUENCE2 SEQUENCE2, SEQUENCE3 SEQUENCE3, SEQUENCE4 SEQUENCE4, SEQUENCE5 SEQUENCE5, SEQUENCE6 SEQUENCE6, SEQUENCE7 SEQUENCE7, SEQUENCE8 SEQUENCE8, SEQUENCE9 SEQUENCE9, SEQUENCE10 SEQUENCE10, SEQUENCE11 SEQUENCE11, SEQUENCE12 SEQUENCE12, SEQUENCE13 SEQUENCE13, SEQUENCE14 SEQUENCE14, SEQUENCE15 SEQUENCE15, COMMENT1 COMMENT1, COMMENT2 COMMENT2, COMMENT3 COMMENT3, COMMENT4 COMMENT4, COMMENT5 COMMENT5, PARTY_ID PARTY_ID, PARTY_NAME PARTY_NAME, CSI_INSTANCE_ID CSI_INSTANCE_ID, ITEM_INSTANCE ITEM_INSTANCE, COUNTER_ID COUNTER_ID, COUNTER_NAME COUNTER_NAME, COUNTER_READING_ID COUNTER_READING_ID, COUNTER_READING COUNTER_READING, AHL_MR_ID AHL_MR_ID, MAINTENANCE_REQUIREMENT MAINTENANCE_REQUIREMENT, VERSION_NUMBER VERSION_NUMBER, CS_INCIDENT_ID CS_INCIDENT_ID, SERVICE_REQUEST SERVICE_REQUEST, WIP_REWORK_ID WIP_REWORK_ID, REWORK_JOB REWORK_JOB, DISPOSITION_SOURCE DISPOSITION_SOURCE, DISPOSITION DISPOSITION, DISPOSITION_ACTION DISPOSITION_ACTION, DISPOSITION_STATUS DISPOSITION_STATUS, MTI_TRANSACTION_HEADER_ID MTI_TRANSACTION_HEADER_ID, MTI_TRANSACTION_INTERFACE_ID MTI_TRANSACTION_INTERFACE_ID, MMT_TRANSACTION_ID MMT_TRANSACTION_ID, WJSI_GROUP_ID WJSI_GROUP_ID, WMTI_GROUP_ID WMTI_GROUP_ID, WMT_TRANSACTION_ID WMT_TRANSACTION_ID, RTI_INTERFACE_TRANSACTION_ID RTI_INTERFACE_TRANSACTION_ID, MAINTENANCE_OP_SEQ MAINTENANCE_OP_SEQ, NONCONFORMANCE_SOURCE NONCONFORMANCE_SOURCE, NONCONFORM_SEVERITY NONCONFORM_SEVERITY, NONCONFORM_PRIORITY NONCONFORM_PRIORITY, NONCONFORMANCE_TYPE NONCONFORMANCE_TYPE, NONCONFORMANCE_CODE NONCONFORMANCE_CODE, DATE_OPENED DATE_OPENED, DATE_CLOSED DATE_CLOSED, DAYS_TO_CLOSE DAYS_TO_CLOSE, TO_SUBINVENTORY TO_SUBINVENTORY, TO_LOCATOR_ID TO_LOCATOR_ID, TO_LOCATOR TO_LOCATOR, TO_SUB_LOCATOR_TYPE TO_SUB_LOCATOR_TYPE, BILL_REFERENCE_ID BILL_REFERENCE_ID, BILL_REFERENCE BILL_REFERENCE, ROUTING_REFERENCE_ID ROUTING_REFERENCE_ID, ROUTING_REFERENCE ROUTING_REFERENCE, CONCURRENT_REQUEST_ID CONCURRENT_REQUEST_ID, LOT_STATUS_ID LOT_STATUS_ID, SERIAL_STATUS_ID SERIAL_STATUS_ID, NONCONFORMANCE_STATUS NONCONFORMANCE_STATUS, RCV_TRANSACTION_ID RCV_TRANSACTION_ID, LOT_STATUS LOT_STATUS, SERIAL_STATUS SERIAL_STATUS, REQUEST_STATUS REQUEST_STATUS, REQUEST_SOURCE REQUEST_SOURCE, REQUEST_PRIORITY REQUEST_PRIORITY, REQUEST_SEVERITY REQUEST_SEVERITY, ECO_NAME ECO_NAME, FOLLOWUP_ACTIVITY_ID FOLLOWUP_ACTIVITY_ID, FOLLOWUP_ACTIVITY FOLLOWUP_ACTIVITY, XFR_LPN_ID XFR_LPN_ID, XFR_LICENSE_PLATE_NUMBER XFR_LICENSE_PLATE_NUMBER, REPAIR_LINE_ID REPAIR_LINE_ID, REPAIR_ORDER_NUMBER REPAIR_ORDER_NUMBER, JTF_TASK_ID JTF_TASK_ID, JTF_TASK_NUMBER JTF_TASK_NUMBER, ASSET_INSTANCE_ID ASSET_INSTANCE_ID, ASSET_INSTANCE_NUMBER ASSET_INSTANCE_NUMBER, PROCESS_BATCH_ID PROCESS_BATCH_ID, PROCESS_BATCH_NUM PROCESS_BATCH_NUM, PROCESS_BATCHSTEP_ID PROCESS_BATCHSTEP_ID, PROCESS_BATCHSTEP_NUM PROCESS_BATCHSTEP_NUM, PROCESS_OPERATION_ID PROCESS_OPERATION_ID, PROCESS_OPERATION PROCESS_OPERATION, PROCESS_ACTIVITY_ID PROCESS_ACTIVITY_ID, PROCESS_ACTIVITY PROCESS_ACTIVITY, PROCESS_RESOURCE_ID PROCESS_RESOURCE_ID, PROCESS_RESOURCE PROCESS_RESOURCE, PROCESS_PARAMETER_ID PROCESS_PARAMETER_ID, PROCESS_PARAMETER PROCESS_PARAMETER, OPERATING_UNIT_ID OPERATING_UNIT_ID, OPERATING_UNIT OPERATING_UNIT from "QA"."QA_RESULTS_INTERFACE"

View Text - HTML Formatted

SELECT TRANSACTION_INTERFACE_ID TRANSACTION_INTERFACE_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, QA_LAST_UPDATED_BY QA_LAST_UPDATED_BY
, QA_LAST_UPDATED_BY_NAME QA_LAST_UPDATED_BY_NAME
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, QA_CREATED_BY QA_CREATED_BY
, QA_CREATED_BY_NAME QA_CREATED_BY_NAME
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, COLLECTION_ID COLLECTION_ID
, GROUP_ID GROUP_ID
, SOURCE_CODE SOURCE_CODE
, SOURCE_LINE_ID SOURCE_LINE_ID
, PROCESS_STATUS PROCESS_STATUS
, VALIDATE_FLAG VALIDATE_FLAG
, MARKER MARKER
, ORGANIZATION_ID ORGANIZATION_ID
, ORGANIZATION_CODE ORGANIZATION_CODE
, PLAN_ID PLAN_ID
, PLAN_NAME PLAN_NAME
, SPEC_ID SPEC_ID
, SPEC_NAME SPEC_NAME
, DEPARTMENT_ID DEPARTMENT_ID
, DEPARTMENT DEPARTMENT
, TO_DEPARTMENT_ID TO_DEPARTMENT_ID
, TO_DEPARTMENT TO_DEPARTMENT
, RESOURCE_ID RESOURCE_ID
, RESOURCE_CODE RESOURCE_CODE
, QUANTITY QUANTITY
, ITEM_ID ITEM_ID
, ITEM ITEM
, UOM UOM
, REVISION REVISION
, SUBINVENTORY SUBINVENTORY
, LOCATOR_ID LOCATOR_ID
, LOCATOR LOCATOR
, LOT_NUMBER LOT_NUMBER
, SERIAL_NUMBER SERIAL_NUMBER
, COMP_ITEM_ID COMP_ITEM_ID
, COMP_ITEM COMP_ITEM
, COMP_UOM COMP_UOM
, COMP_REVISION COMP_REVISION
, COMP_SUBINVENTORY COMP_SUBINVENTORY
, COMP_LOCATOR_ID COMP_LOCATOR_ID
, COMP_LOCATOR COMP_LOCATOR
, COMP_LOT_NUMBER COMP_LOT_NUMBER
, COMP_SERIAL_NUMBER COMP_SERIAL_NUMBER
, WIP_ENTITY_ID WIP_ENTITY_ID
, JOB_NAME JOB_NAME
, LINE_ID LINE_ID
, PRODUCTION_LINE PRODUCTION_LINE
, TO_OP_SEQ_NUM TO_OP_SEQ_NUM
, FROM_OP_SEQ_NUM FROM_OP_SEQ_NUM
, VENDOR_ID VENDOR_ID
, VENDOR_NAME VENDOR_NAME
, RECEIPT_NUM RECEIPT_NUM
, PO_HEADER_ID PO_HEADER_ID
, PO_RELEASE_ID PO_RELEASE_ID
, PO_RELEASE_NUM PO_RELEASE_NUM
, PO_TYPE_LOOKUP PO_TYPE_LOOKUP
, PO_NUMBER PO_NUMBER
, PO_LINE_NUM PO_LINE_NUM
, PO_SHIPMENT_NUM PO_SHIPMENT_NUM
, CUSTOMER_ID CUSTOMER_ID
, CUSTOMER_NAME CUSTOMER_NAME
, SO_HEADER_ID SO_HEADER_ID
, SALES_ORDER SALES_ORDER
, RESTRICT_LOCATORS_CODE RESTRICT_LOCATORS_CODE
, LOCATION_CONTROL_CODE LOCATION_CONTROL_CODE
, REVISION_QTY_CONTROL_CODE REVISION_QTY_CONTROL_CODE
, RESTRICT_SUBINV_CODE RESTRICT_SUBINV_CODE
, SUB_LOCATOR_TYPE SUB_LOCATOR_TYPE
, GEN_LOC_CTRL_CODE GEN_LOC_CTRL_CODE
, COMP_RESTRICT_LOCATORS_CODE COMP_RESTRICT_LOCATORS_CODE
, COMP_LOCATION_CONTROL_CODE COMP_LOCATION_CONTROL_CODE
, COMP_REVISION_QTY_CONTROL_CODE COMP_REVISION_QTY_CONTROL_CODE
, COMP_RESTRICT_SUBINV_CODE COMP_RESTRICT_SUBINV_CODE
, COMP_SUB_LOCATOR_TYPE COMP_SUB_LOCATOR_TYPE
, PROJECT_ID PROJECT_ID
, PROJECT_NUMBER PROJECT_NUMBER
, TASK_ID TASK_ID
, TASK_NUMBER TASK_NUMBER
, STATUS STATUS
, TRANSACTION_DATE TRANSACTION_DATE
, COMP_GEN_LOC_CTRL_CODE COMP_GEN_LOC_CTRL_CODE
, RMA_HEADER_ID RMA_HEADER_ID
, RMA_NUMBER RMA_NUMBER
, INSERT_TYPE INSERT_TYPE
, MATCHING_ELEMENTS MATCHING_ELEMENTS
, CHARACTER1 CHARACTER1
, CHARACTER2 CHARACTER2
, CHARACTER3 CHARACTER3
, CHARACTER4 CHARACTER4
, CHARACTER5 CHARACTER5
, CHARACTER6 CHARACTER6
, CHARACTER7 CHARACTER7
, CHARACTER8 CHARACTER8
, CHARACTER9 CHARACTER9
, CHARACTER10 CHARACTER10
, CHARACTER11 CHARACTER11
, CHARACTER12 CHARACTER12
, CHARACTER13 CHARACTER13
, CHARACTER14 CHARACTER14
, CHARACTER15 CHARACTER15
, CHARACTER16 CHARACTER16
, CHARACTER17 CHARACTER17
, CHARACTER18 CHARACTER18
, CHARACTER19 CHARACTER19
, CHARACTER20 CHARACTER20
, CHARACTER21 CHARACTER21
, CHARACTER22 CHARACTER22
, CHARACTER23 CHARACTER23
, CHARACTER24 CHARACTER24
, CHARACTER25 CHARACTER25
, CHARACTER26 CHARACTER26
, CHARACTER27 CHARACTER27
, CHARACTER28 CHARACTER28
, CHARACTER29 CHARACTER29
, CHARACTER30 CHARACTER30
, CHARACTER31 CHARACTER31
, CHARACTER32 CHARACTER32
, CHARACTER33 CHARACTER33
, CHARACTER34 CHARACTER34
, CHARACTER35 CHARACTER35
, CHARACTER36 CHARACTER36
, CHARACTER37 CHARACTER37
, CHARACTER41 CHARACTER41
, CHARACTER42 CHARACTER42
, CHARACTER43 CHARACTER43
, CHARACTER44 CHARACTER44
, CHARACTER45 CHARACTER45
, CHARACTER46 CHARACTER46
, CHARACTER47 CHARACTER47
, CHARACTER48 CHARACTER48
, CHARACTER49 CHARACTER49
, CHARACTER50 CHARACTER50
, CHARACTER51 CHARACTER51
, CHARACTER52 CHARACTER52
, CHARACTER53 CHARACTER53
, CHARACTER54 CHARACTER54
, CHARACTER55 CHARACTER55
, CHARACTER56 CHARACTER56
, CHARACTER57 CHARACTER57
, CHARACTER58 CHARACTER58
, CHARACTER59 CHARACTER59
, CHARACTER60 CHARACTER60
, CHARACTER61 CHARACTER61
, CHARACTER62 CHARACTER62
, CHARACTER63 CHARACTER63
, CHARACTER64 CHARACTER64
, CHARACTER65 CHARACTER65
, CHARACTER66 CHARACTER66
, CHARACTER67 CHARACTER67
, CHARACTER68 CHARACTER68
, CHARACTER69 CHARACTER69
, CHARACTER70 CHARACTER70
, CHARACTER71 CHARACTER71
, CHARACTER72 CHARACTER72
, CHARACTER73 CHARACTER73
, CHARACTER74 CHARACTER74
, CHARACTER75 CHARACTER75
, CHARACTER76 CHARACTER76
, CHARACTER77 CHARACTER77
, CHARACTER78 CHARACTER78
, CHARACTER79 CHARACTER79
, CHARACTER80 CHARACTER80
, CHARACTER81 CHARACTER81
, CHARACTER82 CHARACTER82
, CHARACTER83 CHARACTER83
, CHARACTER84 CHARACTER84
, CHARACTER85 CHARACTER85
, CHARACTER86 CHARACTER86
, CHARACTER87 CHARACTER87
, CHARACTER88 CHARACTER88
, CHARACTER89 CHARACTER89
, CHARACTER90 CHARACTER90
, CHARACTER91 CHARACTER91
, CHARACTER92 CHARACTER92
, CHARACTER93 CHARACTER93
, CHARACTER94 CHARACTER94
, CHARACTER95 CHARACTER95
, CHARACTER96 CHARACTER96
, CHARACTER97 CHARACTER97
, CHARACTER98 CHARACTER98
, CHARACTER99 CHARACTER99
, CHARACTER100 CHARACTER100
, CHARACTER38 CHARACTER38
, CHARACTER39 CHARACTER39
, CHARACTER40 CHARACTER40
, PO_AGENT_ID PO_AGENT_ID
, LPN_ID LPN_ID
, LICENSE_PLATE_NUMBER LICENSE_PLATE_NUMBER
, CONTRACT_ID CONTRACT_ID
, CONTRACT_NUMBER CONTRACT_NUMBER
, CONTRACT_LINE_ID CONTRACT_LINE_ID
, CONTRACT_LINE_NUMBER CONTRACT_LINE_NUMBER
, DELIVERABLE_ID DELIVERABLE_ID
, DELIVERABLE_NUMBER DELIVERABLE_NUMBER
, ASSET_GROUP_ID ASSET_GROUP_ID
, ASSET_GROUP ASSET_GROUP
, ASSET_NUMBER ASSET_NUMBER
, ASSET_ACTIVITY_ID ASSET_ACTIVITY_ID
, ASSET_ACTIVITY ASSET_ACTIVITY
, WORK_ORDER_ID WORK_ORDER_ID
, WORK_ORDER WORK_ORDER
, SEQUENCE1 SEQUENCE1
, SEQUENCE2 SEQUENCE2
, SEQUENCE3 SEQUENCE3
, SEQUENCE4 SEQUENCE4
, SEQUENCE5 SEQUENCE5
, SEQUENCE6 SEQUENCE6
, SEQUENCE7 SEQUENCE7
, SEQUENCE8 SEQUENCE8
, SEQUENCE9 SEQUENCE9
, SEQUENCE10 SEQUENCE10
, SEQUENCE11 SEQUENCE11
, SEQUENCE12 SEQUENCE12
, SEQUENCE13 SEQUENCE13
, SEQUENCE14 SEQUENCE14
, SEQUENCE15 SEQUENCE15
, COMMENT1 COMMENT1
, COMMENT2 COMMENT2
, COMMENT3 COMMENT3
, COMMENT4 COMMENT4
, COMMENT5 COMMENT5
, PARTY_ID PARTY_ID
, PARTY_NAME PARTY_NAME
, CSI_INSTANCE_ID CSI_INSTANCE_ID
, ITEM_INSTANCE ITEM_INSTANCE
, COUNTER_ID COUNTER_ID
, COUNTER_NAME COUNTER_NAME
, COUNTER_READING_ID COUNTER_READING_ID
, COUNTER_READING COUNTER_READING
, AHL_MR_ID AHL_MR_ID
, MAINTENANCE_REQUIREMENT MAINTENANCE_REQUIREMENT
, VERSION_NUMBER VERSION_NUMBER
, CS_INCIDENT_ID CS_INCIDENT_ID
, SERVICE_REQUEST SERVICE_REQUEST
, WIP_REWORK_ID WIP_REWORK_ID
, REWORK_JOB REWORK_JOB
, DISPOSITION_SOURCE DISPOSITION_SOURCE
, DISPOSITION DISPOSITION
, DISPOSITION_ACTION DISPOSITION_ACTION
, DISPOSITION_STATUS DISPOSITION_STATUS
, MTI_TRANSACTION_HEADER_ID MTI_TRANSACTION_HEADER_ID
, MTI_TRANSACTION_INTERFACE_ID MTI_TRANSACTION_INTERFACE_ID
, MMT_TRANSACTION_ID MMT_TRANSACTION_ID
, WJSI_GROUP_ID WJSI_GROUP_ID
, WMTI_GROUP_ID WMTI_GROUP_ID
, WMT_TRANSACTION_ID WMT_TRANSACTION_ID
, RTI_INTERFACE_TRANSACTION_ID RTI_INTERFACE_TRANSACTION_ID
, MAINTENANCE_OP_SEQ MAINTENANCE_OP_SEQ
, NONCONFORMANCE_SOURCE NONCONFORMANCE_SOURCE
, NONCONFORM_SEVERITY NONCONFORM_SEVERITY
, NONCONFORM_PRIORITY NONCONFORM_PRIORITY
, NONCONFORMANCE_TYPE NONCONFORMANCE_TYPE
, NONCONFORMANCE_CODE NONCONFORMANCE_CODE
, DATE_OPENED DATE_OPENED
, DATE_CLOSED DATE_CLOSED
, DAYS_TO_CLOSE DAYS_TO_CLOSE
, TO_SUBINVENTORY TO_SUBINVENTORY
, TO_LOCATOR_ID TO_LOCATOR_ID
, TO_LOCATOR TO_LOCATOR
, TO_SUB_LOCATOR_TYPE TO_SUB_LOCATOR_TYPE
, BILL_REFERENCE_ID BILL_REFERENCE_ID
, BILL_REFERENCE BILL_REFERENCE
, ROUTING_REFERENCE_ID ROUTING_REFERENCE_ID
, ROUTING_REFERENCE ROUTING_REFERENCE
, CONCURRENT_REQUEST_ID CONCURRENT_REQUEST_ID
, LOT_STATUS_ID LOT_STATUS_ID
, SERIAL_STATUS_ID SERIAL_STATUS_ID
, NONCONFORMANCE_STATUS NONCONFORMANCE_STATUS
, RCV_TRANSACTION_ID RCV_TRANSACTION_ID
, LOT_STATUS LOT_STATUS
, SERIAL_STATUS SERIAL_STATUS
, REQUEST_STATUS REQUEST_STATUS
, REQUEST_SOURCE REQUEST_SOURCE
, REQUEST_PRIORITY REQUEST_PRIORITY
, REQUEST_SEVERITY REQUEST_SEVERITY
, ECO_NAME ECO_NAME
, FOLLOWUP_ACTIVITY_ID FOLLOWUP_ACTIVITY_ID
, FOLLOWUP_ACTIVITY FOLLOWUP_ACTIVITY
, XFR_LPN_ID XFR_LPN_ID
, XFR_LICENSE_PLATE_NUMBER XFR_LICENSE_PLATE_NUMBER
, REPAIR_LINE_ID REPAIR_LINE_ID
, REPAIR_ORDER_NUMBER REPAIR_ORDER_NUMBER
, JTF_TASK_ID JTF_TASK_ID
, JTF_TASK_NUMBER JTF_TASK_NUMBER
, ASSET_INSTANCE_ID ASSET_INSTANCE_ID
, ASSET_INSTANCE_NUMBER ASSET_INSTANCE_NUMBER
, PROCESS_BATCH_ID PROCESS_BATCH_ID
, PROCESS_BATCH_NUM PROCESS_BATCH_NUM
, PROCESS_BATCHSTEP_ID PROCESS_BATCHSTEP_ID
, PROCESS_BATCHSTEP_NUM PROCESS_BATCHSTEP_NUM
, PROCESS_OPERATION_ID PROCESS_OPERATION_ID
, PROCESS_OPERATION PROCESS_OPERATION
, PROCESS_ACTIVITY_ID PROCESS_ACTIVITY_ID
, PROCESS_ACTIVITY PROCESS_ACTIVITY
, PROCESS_RESOURCE_ID PROCESS_RESOURCE_ID
, PROCESS_RESOURCE PROCESS_RESOURCE
, PROCESS_PARAMETER_ID PROCESS_PARAMETER_ID
, PROCESS_PARAMETER PROCESS_PARAMETER
, OPERATING_UNIT_ID OPERATING_UNIT_ID
, OPERATING_UNIT OPERATING_UNIT
FROM "QA"."QA_RESULTS_INTERFACE"