VIEW: APPS.ISC_QA_RESULTS_V

Source

View Text - Preformatted

SELECT COLLECTION_ID COLLECTION_ID, OCCURRENCE OCCURRENCE, CREATION_DATE CREATION_DATE, QUANTITY QUANTITY, UOM UOM, REVISION REVISION, LOCATOR_ID LOCATOR_ID, TRANSACTION_NUMBER TRANSACTION_NUMBER, TXN_HEADER_ID TXN_HEADER_ID, ORGANIZATION_ID ORGANIZATION_ID, PLAN_ID PLAN_ID, SPEC_ID SPEC_ID, TRANSACTION_ID TRANSACTION_ID, DEPARTMENT_ID DEPARTMENT_ID, RESOURCE_ID RESOURCE_ID, NVL(ITEM_ID, -1) ITEM_ID, SUBINVENTORY SUBINVENTORY, COMP_ITEM_ID COMP_ITEM_ID, COMP_SUBINVENTORY COMP_SUBINVENTORY, COMP_LOCATOR_ID COMP_LOCATOR_ID, WIP_ENTITY_ID WIP_ENTITY_ID, LINE_ID LINE_ID, VENDOR_ID VENDOR_ID, PO_HEADER_ID PO_HEADER_ID, NVL(CUSTOMER_ID, -2) CUSTOMER_ID, SO_HEADER_ID SO_HEADER_ID, RMA_HEADER_ID RMA_HEADER_ID, 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, CHARACTER38 CHARACTER38, CHARACTER39 CHARACTER39, CHARACTER40 CHARACTER40, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, TO_DEPARTMENT_ID TO_DEPARTMENT_ID, PO_RELEASE_ID PO_RELEASE_ID, 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, PROJECT_ID PROJECT_ID, TASK_ID TASK_ID, LPN_ID LPN_ID, CONTRACT_ID CONTRACT_ID, CONTRACT_LINE_ID CONTRACT_LINE_ID, DELIVERABLE_ID DELIVERABLE_ID, ASSET_GROUP_ID ASSET_GROUP_ID, ASSET_ACTIVITY_ID ASSET_ACTIVITY_ID, WORK_ORDER_ID WORK_ORDER_ID, SEQUENCE6 SEQUENCE6, SEQUENCE7 SEQUENCE7, SEQUENCE8 SEQUENCE8, SEQUENCE9 SEQUENCE9, SEQUENCE10 SEQUENCE10, SEQUENCE11 SEQUENCE11, SEQUENCE12 SEQUENCE12, SEQUENCE13 SEQUENCE13, SEQUENCE14 SEQUENCE14, SEQUENCE15 SEQUENCE15, COMMENT4 COMMENT4, COMMENT5 COMMENT5, PARTY_ID PARTY_ID, CSI_INSTANCE_ID CSI_INSTANCE_ID, COUNTER_ID COUNTER_ID, COUNTER_READING_ID COUNTER_READING_ID, AHL_MR_ID AHL_MR_ID, CS_INCIDENT_ID CS_INCIDENT_ID, WIP_REWORK_ID WIP_REWORK_ID, QA_FLEX_UTIL.LOCATOR2(QR.ORGANIZATION_ID, QR.LOCATOR_ID) LOCATOR, LOT_NUMBER LOT_NUMBER, SERIAL_NUMBER SERIAL_NUMBER, COMP_UOM COMP_UOM, COMP_REVISION COMP_REVISION, COMP_LOT_NUMBER COMP_LOT_NUMBER, COMP_SERIAL_NUMBER COMP_SERIAL_NUMBER, TO_OP_SEQ_NUM TO_OP_SEQ_NUM, FROM_OP_SEQ_NUM FROM_OP_SEQ_NUM, RECEIPT_NUM RECEIPT_NUM, PO_LINE_NUM PO_LINE_NUM, PO_SHIPMENT_NUM PO_SHIPMENT_NUM, QA_FLEX_UTIL.PROJECT_NUMBER(QR.PROJECT_ID) PROJECT_NUMBER, QA_FLEX_UTIL.SALES_ORDER(QR.SO_HEADER_ID) SALES_ORDER, QA_FLEX_UTIL.RMA_NUMBER(QR.RMA_HEADER_ID) RMA_NUMBER, STATUS STATUS, TRANSACTION_DATE TRANSACTION_DATE, QA_FLEX_UTIL.CONTRACT_NUMBER(QR.CONTRACT_ID) CONTRACT_NUMBER, QA_FLEX_UTIL.CONTRACT_LINE_NUMBER(QR.CONTRACT_LINE_ID) CONTRACT_LINE_NUMBER, QA_FLEX_UTIL.DELIVERABLE_NUMBER(QR.DELIVERABLE_ID) DELIVERABLE_NUMBER, 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, QA_FLEX_UTIL.ITEM2(QR.ORGANIZATION_ID, QR.ASSET_GROUP_ID) ASSET_GROUP, ASSET_NUMBER ASSET_NUMBER, QA_FLEX_UTIL.ITEM2(QR.ORGANIZATION_ID, QR.ASSET_ACTIVITY_ID) ASSET_ACTIVITY, SEQUENCE1 SEQUENCE1, SEQUENCE2 SEQUENCE2, SEQUENCE3 SEQUENCE3, SEQUENCE4 SEQUENCE4, SEQUENCE5 SEQUENCE5, COMMENT1 COMMENT1, COMMENT2 COMMENT2, COMMENT3 COMMENT3, NONCONFORM_SEVERITY NONCONFORM_SEVERITY, NONCONFORM_PRIORITY NONCONFORM_PRIORITY, NONCONFORMANCE_CODE NONCONFORMANCE_CODE, DATE_OPENED DATE_OPENED, DATE_CLOSED DATE_CLOSED, DAYS_TO_CLOSE DAYS_TO_CLOSE, TO_SUBINVENTORY TO_SUBINVENTORY, REQUEST_STATUS REQUEST_STATUS, REQUEST_SOURCE REQUEST_SOURCE, REQUEST_PRIORITY REQUEST_PRIORITY, REQUEST_SEVERITY REQUEST_SEVERITY, ECO_NAME ECO_NAME, QA_FLEX_UTIL.ITEM2(QR.ORGANIZATION_ID, QR.COMP_ITEM_ID) COMPONENT_ITEM, QA_FLEX_UTIL.LOCATOR2(QR.ORGANIZATION_ID, QR.COMP_LOCATOR_ID) COMPONENT_LOCATOR, QA_FLEX_UTIL.LOCATOR2(QR.ORGANIZATION_ID, QR.TO_LOCATOR_ID) TO_LOCATOR, QA_FLEX_UTIL.ITEM2(QR.ORGANIZATION_ID, QR.BILL_REFERENCE_ID) BILL_REFERENCE, QA_FLEX_UTIL.ITEM2(QR.ORGANIZATION_ID, QR.ROUTING_REFERENCE_ID) ROUTING_REFERENCE, DISPOSITION_SOURCE DISPOSITION_SOURCE, DISPOSITION DISPOSITION, DISPOSITION_ACTION DISPOSITION_ACTION, DISPOSITION_STATUS DISPOSITION_STATUS, MAINTENANCE_OP_SEQ MAINTENANCE_OP_SEQ, NONCONFORMANCE_SOURCE NONCONFORMANCE_SOURCE, NONCONFORMANCE_TYPE NONCONFORMANCE_TYPE, NONCONFORMANCE_STATUS NONCONFORMANCE_STATUS, SERIAL_STATUS_ID SERIAL_STATUS_ID, LOT_STATUS_ID LOT_STATUS_ID, 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, TO_LOCATOR_ID TO_LOCATOR_ID, BILL_REFERENCE_ID BILL_REFERENCE_ID, ROUTING_REFERENCE_ID ROUTING_REFERENCE_ID, CONCURRENT_REQUEST_ID CONCURRENT_REQUEST_ID, RCV_TRANSACTION_ID RCV_TRANSACTION_ID, FOLLOWUP_ACTIVITY_ID FOLLOWUP_ACTIVITY_ID, XFR_LPN_ID XFR_LPN_ID FROM QA_RESULTS QR

View Text - HTML Formatted

SELECT COLLECTION_ID COLLECTION_ID
, OCCURRENCE OCCURRENCE
, CREATION_DATE CREATION_DATE
, QUANTITY QUANTITY
, UOM UOM
, REVISION REVISION
, LOCATOR_ID LOCATOR_ID
, TRANSACTION_NUMBER TRANSACTION_NUMBER
, TXN_HEADER_ID TXN_HEADER_ID
, ORGANIZATION_ID ORGANIZATION_ID
, PLAN_ID PLAN_ID
, SPEC_ID SPEC_ID
, TRANSACTION_ID TRANSACTION_ID
, DEPARTMENT_ID DEPARTMENT_ID
, RESOURCE_ID RESOURCE_ID
, NVL(ITEM_ID
, -1) ITEM_ID
, SUBINVENTORY SUBINVENTORY
, COMP_ITEM_ID COMP_ITEM_ID
, COMP_SUBINVENTORY COMP_SUBINVENTORY
, COMP_LOCATOR_ID COMP_LOCATOR_ID
, WIP_ENTITY_ID WIP_ENTITY_ID
, LINE_ID LINE_ID
, VENDOR_ID VENDOR_ID
, PO_HEADER_ID PO_HEADER_ID
, NVL(CUSTOMER_ID
, -2) CUSTOMER_ID
, SO_HEADER_ID SO_HEADER_ID
, RMA_HEADER_ID RMA_HEADER_ID
, 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
, CHARACTER38 CHARACTER38
, CHARACTER39 CHARACTER39
, CHARACTER40 CHARACTER40
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, TO_DEPARTMENT_ID TO_DEPARTMENT_ID
, PO_RELEASE_ID PO_RELEASE_ID
, 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
, PROJECT_ID PROJECT_ID
, TASK_ID TASK_ID
, LPN_ID LPN_ID
, CONTRACT_ID CONTRACT_ID
, CONTRACT_LINE_ID CONTRACT_LINE_ID
, DELIVERABLE_ID DELIVERABLE_ID
, ASSET_GROUP_ID ASSET_GROUP_ID
, ASSET_ACTIVITY_ID ASSET_ACTIVITY_ID
, WORK_ORDER_ID WORK_ORDER_ID
, SEQUENCE6 SEQUENCE6
, SEQUENCE7 SEQUENCE7
, SEQUENCE8 SEQUENCE8
, SEQUENCE9 SEQUENCE9
, SEQUENCE10 SEQUENCE10
, SEQUENCE11 SEQUENCE11
, SEQUENCE12 SEQUENCE12
, SEQUENCE13 SEQUENCE13
, SEQUENCE14 SEQUENCE14
, SEQUENCE15 SEQUENCE15
, COMMENT4 COMMENT4
, COMMENT5 COMMENT5
, PARTY_ID PARTY_ID
, CSI_INSTANCE_ID CSI_INSTANCE_ID
, COUNTER_ID COUNTER_ID
, COUNTER_READING_ID COUNTER_READING_ID
, AHL_MR_ID AHL_MR_ID
, CS_INCIDENT_ID CS_INCIDENT_ID
, WIP_REWORK_ID WIP_REWORK_ID
, QA_FLEX_UTIL.LOCATOR2(QR.ORGANIZATION_ID
, QR.LOCATOR_ID) LOCATOR
, LOT_NUMBER LOT_NUMBER
, SERIAL_NUMBER SERIAL_NUMBER
, COMP_UOM COMP_UOM
, COMP_REVISION COMP_REVISION
, COMP_LOT_NUMBER COMP_LOT_NUMBER
, COMP_SERIAL_NUMBER COMP_SERIAL_NUMBER
, TO_OP_SEQ_NUM TO_OP_SEQ_NUM
, FROM_OP_SEQ_NUM FROM_OP_SEQ_NUM
, RECEIPT_NUM RECEIPT_NUM
, PO_LINE_NUM PO_LINE_NUM
, PO_SHIPMENT_NUM PO_SHIPMENT_NUM
, QA_FLEX_UTIL.PROJECT_NUMBER(QR.PROJECT_ID) PROJECT_NUMBER
, QA_FLEX_UTIL.SALES_ORDER(QR.SO_HEADER_ID) SALES_ORDER
, QA_FLEX_UTIL.RMA_NUMBER(QR.RMA_HEADER_ID) RMA_NUMBER
, STATUS STATUS
, TRANSACTION_DATE TRANSACTION_DATE
, QA_FLEX_UTIL.CONTRACT_NUMBER(QR.CONTRACT_ID) CONTRACT_NUMBER
, QA_FLEX_UTIL.CONTRACT_LINE_NUMBER(QR.CONTRACT_LINE_ID) CONTRACT_LINE_NUMBER
, QA_FLEX_UTIL.DELIVERABLE_NUMBER(QR.DELIVERABLE_ID) DELIVERABLE_NUMBER
, 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
, QA_FLEX_UTIL.ITEM2(QR.ORGANIZATION_ID
, QR.ASSET_GROUP_ID) ASSET_GROUP
, ASSET_NUMBER ASSET_NUMBER
, QA_FLEX_UTIL.ITEM2(QR.ORGANIZATION_ID
, QR.ASSET_ACTIVITY_ID) ASSET_ACTIVITY
, SEQUENCE1 SEQUENCE1
, SEQUENCE2 SEQUENCE2
, SEQUENCE3 SEQUENCE3
, SEQUENCE4 SEQUENCE4
, SEQUENCE5 SEQUENCE5
, COMMENT1 COMMENT1
, COMMENT2 COMMENT2
, COMMENT3 COMMENT3
, NONCONFORM_SEVERITY NONCONFORM_SEVERITY
, NONCONFORM_PRIORITY NONCONFORM_PRIORITY
, NONCONFORMANCE_CODE NONCONFORMANCE_CODE
, DATE_OPENED DATE_OPENED
, DATE_CLOSED DATE_CLOSED
, DAYS_TO_CLOSE DAYS_TO_CLOSE
, TO_SUBINVENTORY TO_SUBINVENTORY
, REQUEST_STATUS REQUEST_STATUS
, REQUEST_SOURCE REQUEST_SOURCE
, REQUEST_PRIORITY REQUEST_PRIORITY
, REQUEST_SEVERITY REQUEST_SEVERITY
, ECO_NAME ECO_NAME
, QA_FLEX_UTIL.ITEM2(QR.ORGANIZATION_ID
, QR.COMP_ITEM_ID) COMPONENT_ITEM
, QA_FLEX_UTIL.LOCATOR2(QR.ORGANIZATION_ID
, QR.COMP_LOCATOR_ID) COMPONENT_LOCATOR
, QA_FLEX_UTIL.LOCATOR2(QR.ORGANIZATION_ID
, QR.TO_LOCATOR_ID) TO_LOCATOR
, QA_FLEX_UTIL.ITEM2(QR.ORGANIZATION_ID
, QR.BILL_REFERENCE_ID) BILL_REFERENCE
, QA_FLEX_UTIL.ITEM2(QR.ORGANIZATION_ID
, QR.ROUTING_REFERENCE_ID) ROUTING_REFERENCE
, DISPOSITION_SOURCE DISPOSITION_SOURCE
, DISPOSITION DISPOSITION
, DISPOSITION_ACTION DISPOSITION_ACTION
, DISPOSITION_STATUS DISPOSITION_STATUS
, MAINTENANCE_OP_SEQ MAINTENANCE_OP_SEQ
, NONCONFORMANCE_SOURCE NONCONFORMANCE_SOURCE
, NONCONFORMANCE_TYPE NONCONFORMANCE_TYPE
, NONCONFORMANCE_STATUS NONCONFORMANCE_STATUS
, SERIAL_STATUS_ID SERIAL_STATUS_ID
, LOT_STATUS_ID LOT_STATUS_ID
, 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
, TO_LOCATOR_ID TO_LOCATOR_ID
, BILL_REFERENCE_ID BILL_REFERENCE_ID
, ROUTING_REFERENCE_ID ROUTING_REFERENCE_ID
, CONCURRENT_REQUEST_ID CONCURRENT_REQUEST_ID
, RCV_TRANSACTION_ID RCV_TRANSACTION_ID
, FOLLOWUP_ACTIVITY_ID FOLLOWUP_ACTIVITY_ID
, XFR_LPN_ID XFR_LPN_ID
FROM QA_RESULTS QR