VIEW: APPS.QA_RESULTS_FULL_V

Source

View Text - Preformatted

SELECT QR.ROWID ROW_ID , QR.COLLECTION_ID , QR.OCCURRENCE , QR.LAST_UPDATE_DATE , QR.QA_LAST_UPDATE_DATE , QR.LAST_UPDATED_BY , QR.QA_LAST_UPDATED_BY , FU1.USER_NAME QA_LAST_UPDATED_BY_NAME , QR.CREATION_DATE , QR.QA_CREATION_DATE , QR.CREATED_BY , QR.QA_CREATED_BY , FU2.USER_NAME QA_CREATED_BY_NAME , QR.LAST_UPDATE_LOGIN , QR.REQUEST_ID , QR.PROGRAM_APPLICATION_ID , QR.PROGRAM_ID , QR.PROGRAM_UPDATE_DATE , QR.TRANSACTION_NUMBER , QR.TXN_HEADER_ID , QR.ORGANIZATION_ID , MP.ORGANIZATION_CODE , HRORG.NAME , QR.PLAN_ID , QP.TEMPLATE_PLAN_ID , QR.SPEC_ID , QP.NAME , QP.DESCRIPTION , FL.MEANING PLAN_TYPE , QR.TRANSACTION_ID , QR.DEPARTMENT_ID , BD.DEPARTMENT_CODE DEPARTMENT , QR.TO_DEPARTMENT_ID , BD2.DEPARTMENT_CODE TO_DEPARTMENT , QR.RESOURCE_ID , BR.RESOURCE_CODE , QR.QUANTITY , QR.ITEM_ID , QA_FLEX_UTIL.ITEM2(QR.ORGANIZATION_ID, QR.ITEM_ID) , QR.UOM , QR.REVISION , QR.SUBINVENTORY , MSINV.LOCATOR_TYPE SUB_LOC_TYPE , QR.LOCATOR_ID , QA_FLEX_UTIL.LOCATOR2(QR.ORGANIZATION_ID, QR.LOCATOR_ID) , QR.LOT_NUMBER , QR.SERIAL_NUMBER , QR.COMP_ITEM_ID , QR.COMP_UOM , QR.COMP_REVISION , QR.COMP_SUBINVENTORY , MSINV2.LOCATOR_TYPE COMP_SUB_LOC_TYPE , QR.COMP_LOCATOR_ID , QR.COMP_LOT_NUMBER , QR.COMP_SERIAL_NUMBER , QR.WIP_ENTITY_ID , WE.WIP_ENTITY_NAME JOB_NAME , QR.LINE_ID , WL.LINE_CODE PRODUCTION_LINE , QR.TO_OP_SEQ_NUM , QR.FROM_OP_SEQ_NUM , QR.VENDOR_ID , PV.VENDOR_NAME VENDOR_NAME , QR.RECEIPT_NUM , QR.PO_HEADER_ID , QR.PO_RELEASE_ID , NVL(PH.CLM_DOCUMENT_NUMBER, PH.SEGMENT1) PO_NUMBER , QR.PO_LINE_NUM , QR.PO_SHIPMENT_NUM , PR.RELEASE_NUM PO_RELEASE_NUM , PH.TYPE_LOOKUP_CODE PO_TYPE_LOOKUP ,QR.PROJECT_ID ,QA_FLEX_UTIL.PROJECT_NUMBER(QR.PROJECT_ID) PROJECT_NUMBER ,QR.TASK_ID ,PT.TASK_NUMBER , QR.CUSTOMER_ID , HP1.PARTY_NAME CUSTOMER_NAME , QR.SO_HEADER_ID , MSO.SEGMENT1 , QR.RMA_HEADER_ID , OE.ORDER_NUMBER , QR.STATUS , QR.TRANSACTION_DATE , QR.LPN_ID , WLPN.LICENSE_PLATE_NUMBER , QR.CONTRACT_ID , QA_FLEX_UTIL.CONTRACT_NUMBER(QR.CONTRACT_ID) CONTRACT_NUMBER , QR.CONTRACT_LINE_ID , QA_FLEX_UTIL.CONTRACT_LINE_NUMBER(QR.CONTRACT_LINE_ID) CONTRACT_LINE_NUMBER , QR.DELIVERABLE_ID , QA_FLEX_UTIL.DELIVERABLE_NUMBER(QR.DELIVERABLE_ID) DELIVERABLE_NUMBER , QR.CHARACTER1 , QR.CHARACTER2 , QR.CHARACTER3 , QR.CHARACTER4 , QR.CHARACTER5 , QR.CHARACTER6 , QR.CHARACTER7 , QR.CHARACTER8 , QR.CHARACTER9 , QR.CHARACTER10 , QR.CHARACTER11 , QR.CHARACTER12 , QR.CHARACTER13 , QR.CHARACTER14 , QR.CHARACTER15 , QR.CHARACTER16 , QR.CHARACTER17 , QR.CHARACTER18 , QR.CHARACTER19 , QR.CHARACTER20 , QR.CHARACTER21 , QR.CHARACTER22 , QR.CHARACTER23 , QR.CHARACTER24 , QR.CHARACTER25 , QR.CHARACTER26 , QR.CHARACTER27 , QR.CHARACTER28 , QR.CHARACTER29 , QR.CHARACTER30 , QR.CHARACTER31 , QR.CHARACTER32 , QR.CHARACTER33 , QR.CHARACTER34 , QR.CHARACTER35 , QR.CHARACTER36 , QR.CHARACTER37 , QR.CHARACTER38 , QR.CHARACTER39 , QR.CHARACTER40 , QR.CHARACTER41 , QR.CHARACTER42 , QR.CHARACTER43 , QR.CHARACTER44 , QR.CHARACTER45 , QR.CHARACTER46 , QR.CHARACTER47 , QR.CHARACTER48 , QR.CHARACTER49 , QR.CHARACTER50 , QR.CHARACTER51 , QR.CHARACTER52 , QR.CHARACTER53 , QR.CHARACTER54 , QR.CHARACTER55 , QR.CHARACTER56 , QR.CHARACTER57 , QR.CHARACTER58 , QR.CHARACTER59 , QR.CHARACTER60 , QR.CHARACTER61 , QR.CHARACTER62 , QR.CHARACTER63 , QR.CHARACTER64 , QR.CHARACTER65 , QR.CHARACTER66 , QR.CHARACTER67 , QR.CHARACTER68 , QR.CHARACTER69 , QR.CHARACTER70 , QR.CHARACTER71 , QR.CHARACTER72 , QR.CHARACTER73 , QR.CHARACTER74 , QR.CHARACTER75 , QR.CHARACTER76 , QR.CHARACTER77 , QR.CHARACTER78 , QR.CHARACTER79 , QR.CHARACTER80 , QR.CHARACTER81 , QR.CHARACTER82 , QR.CHARACTER83 , QR.CHARACTER84 , QR.CHARACTER85 , QR.CHARACTER86 , QR.CHARACTER87 , QR.CHARACTER88 , QR.CHARACTER89 , QR.CHARACTER90 , QR.CHARACTER91 , QR.CHARACTER92 , QR.CHARACTER93 , QR.CHARACTER94 , QR.CHARACTER95 , QR.CHARACTER96 , QR.CHARACTER97 , QR.CHARACTER98 , QR.CHARACTER99 , QR.CHARACTER100 , QR.ASSET_GROUP_ID , QA_FLEX_UTIL.ITEM2(QR.ORGANIZATION_ID, QR.ASSET_GROUP_ID) ASSET_GROUP , QR.ASSET_NUMBER , QR.ASSET_ACTIVITY_ID , QA_FLEX_UTIL.ITEM2(QR.ORGANIZATION_ID, QR.ASSET_ACTIVITY_ID) ASSET_ACTIVITY , QR.WORK_ORDER_ID , WO.WIP_ENTITY_NAME WORK_ORDER ,QR.SEQUENCE1 ,QR.SEQUENCE2 ,QR.SEQUENCE3 ,QR.SEQUENCE4 ,QR.SEQUENCE5 ,QR.SEQUENCE6 ,QR.SEQUENCE7 ,QR.SEQUENCE8 ,QR.SEQUENCE9 ,QR.SEQUENCE10 ,QR.SEQUENCE11 ,QR.SEQUENCE12 ,QR.SEQUENCE13 ,QR.SEQUENCE14 ,QR.SEQUENCE15 ,QR.COMMENT1 ,QR.COMMENT2 ,QR.COMMENT3 ,QR.COMMENT4 ,QR.COMMENT5 ,QR.PARTY_ID ,HP.PARTY_NAME , QR.CSI_INSTANCE_ID , CII.INSTANCE_NUMBER , QR.COUNTER_ID , CCT.NAME COUNTER_NAME , QR.COUNTER_READING_ID , CCV.COUNTER_READING , QR.AHL_MR_ID , AMR.TITLE MAINTENANCE_REQUIREMENT , QR.CS_INCIDENT_ID , CI.INCIDENT_NUMBER SERVICE_REQUEST , QR.WIP_REWORK_ID , WE2.WIP_ENTITY_NAME REWORK_JOB , QR.DISPOSITION_SOURCE , QR.DISPOSITION , QR.DISPOSITION_ACTION , QR.DISPOSITION_STATUS , QR.MTI_TRANSACTION_HEADER_ID , QR.MTI_TRANSACTION_INTERFACE_ID , QR.MMT_TRANSACTION_ID , QR.WJSI_GROUP_ID , QR.WMTI_GROUP_ID , QR.WMT_TRANSACTION_ID , QR.RTI_INTERFACE_TRANSACTION_ID , QR.MAINTENANCE_OP_SEQ , QR.NONCONFORMANCE_SOURCE , QR.NONCONFORM_SEVERITY , QR.NONCONFORM_PRIORITY , QR.NONCONFORMANCE_TYPE , QR.NONCONFORMANCE_CODE , QR.DATE_OPENED , QR.DATE_CLOSED , QR.DAYS_TO_CLOSE , QR.TO_SUBINVENTORY , MSINV3.LOCATOR_TYPE , QR.TO_LOCATOR_ID , QR.BILL_REFERENCE_ID , QR.ROUTING_REFERENCE_ID , QR.CONCURRENT_REQUEST_ID , QR.LOT_STATUS_ID , MMST.STATUS_CODE , QR.SERIAL_STATUS_ID , MMST2.STATUS_CODE , QR.NONCONFORMANCE_STATUS , QR.RCV_TRANSACTION_ID , QR.REQUEST_STATUS , QR.REQUEST_SOURCE , QR.REQUEST_PRIORITY , QR.REQUEST_SEVERITY , QR.ECO_NAME , QR.FOLLOWUP_ACTIVITY_ID , QA_FLEX_UTIL.ITEM2(QR.ORGANIZATION_ID, QR.FOLLOWUP_ACTIVITY_ID) , QR.XFR_LPN_ID , WLPN1.LICENSE_PLATE_NUMBER , QA_FLEX_UTIL.ITEM2(QR.ORGANIZATION_ID, QR.COMP_ITEM_ID) , QA_FLEX_UTIL.LOCATOR2(QR.ORGANIZATION_ID, QR.COMP_LOCATOR_ID) , QA_FLEX_UTIL.LOCATOR2(QR.ORGANIZATION_ID, QR.TO_LOCATOR_ID) , QA_FLEX_UTIL.ITEM2(QR.ORGANIZATION_ID, QR.BILL_REFERENCE_ID) , QA_FLEX_UTIL.ITEM2(QR.ORGANIZATION_ID, QR.ROUTING_REFERENCE_ID) , QR.REPAIR_LINE_ID , CR.REPAIR_NUMBER , QR.JTF_TASK_ID , JT.TASK_NUMBER , QR.ASSET_INSTANCE_ID , EAN.INSTANCE_NUMBER ,QR.PROCESS_BATCH_ID ,GBH.BATCH_NO ,QR.PROCESS_BATCHSTEP_ID ,GBS.BATCHSTEP_NO ,QR.PROCESS_OPERATION_ID ,DECODE(QR.PROCESS_OPERATION_ID, NULL, NULL, GOB.OPRN_NO || '-' || GOB.OPRN_VERS) ,QR.PROCESS_ACTIVITY_ID ,GBSA.ACTIVITY ,QR.PROCESS_RESOURCE_ID ,GBSR.RESOURCES ,QR.PROCESS_PARAMETER_ID ,GPPB.PARAMETER_NAME FROM FND_USER_VIEW FU1, FND_USER_VIEW FU2, FND_LOOKUP_VALUES FL, AP_SUPPLIERS PV, HZ_PARTIES HP2, PO_HEADERS_ALL PH, MTL_SALES_ORDERS MSO, OE_ORDER_HEADERS_ALL OE, PO_RELEASES_ALL PR, HZ_CUST_ACCOUNTS HCA, HZ_PARTIES HP1, MTL_SECONDARY_INVENTORIES MSINV, MTL_SECONDARY_INVENTORIES MSINV2, BOM_DEPARTMENTS BD, BOM_DEPARTMENTS BD2, BOM_RESOURCES BR, WIP_ENTITIES WE, WIP_LINES WL, QA_PLANS QP, PA_TASKS PT, QA_RESULTS QR, WMS_LICENSE_PLATE_NUMBERS WLPN, WMS_LICENSE_PLATE_NUMBERS WLPN1, WIP_ENTITIES WO, HZ_PARTIES HP, QA_CSI_ITEM_INSTANCES CII, QA_AHL_MR AMR, CSi_COUNTERS_TL CCT, CSI_COUNTER_READINGS CCV, WIP_ENTITIES WE2, CS_INCIDENTS_ALL_B CI, MTL_MATERIAL_STATUSES_B MMSB, MTL_MATERIAL_STATUSES_TL MMST, MTL_MATERIAL_STATUSES_B MMSB2, MTL_MATERIAL_STATUSES_TL MMST2, MTL_SECONDARY_INVENTORIES MSINV3, MTL_PARAMETERS MP, HR_ALL_ORGANIZATION_UNITS_TL HRORG, CSD_REPAIRS CR, JTF_TASKS_B JT, CSI_ITEM_INSTANCES EAN, GME_BATCH_STEP_ACTIVITIES GBSA, GME_BATCH_STEP_RESOURCES GBSR, GMP_PROCESS_PARAMETERS_B GPPB, GME_BATCH_HEADER GBH, GME_BATCH_STEPS GBS, GMD_OPERATIONS_B GOB WHERE QR.PLAN_ID = QP.PLAN_ID AND QR.QA_LAST_UPDATED_BY = FU1.USER_ID AND QR.QA_CREATED_BY = FU2.USER_ID AND QR.ORGANIZATION_ID = MSINV.ORGANIZATION_ID (+) AND QR.SUBINVENTORY = MSINV.SECONDARY_INVENTORY_NAME (+) AND QR.ORGANIZATION_ID = MSINV2.ORGANIZATION_ID (+) AND QR.COMP_SUBINVENTORY = MSINV2.SECONDARY_INVENTORY_NAME (+) AND QR.ORGANIZATION_ID = BD.ORGANIZATION_ID (+) AND QR.ORGANIZATION_ID = BD2.ORGANIZATION_ID (+) AND QR.DEPARTMENT_ID = BD.DEPARTMENT_ID (+) AND QR.TO_DEPARTMENT_ID = BD2.DEPARTMENT_ID (+) AND QR.RESOURCE_ID = BR.RESOURCE_ID (+) AND QR.ORGANIZATION_ID = WE.ORGANIZATION_ID (+) AND QR.WIP_ENTITY_ID = WE.WIP_ENTITY_ID (+) AND QR.ORGANIZATION_ID = WL.ORGANIZATION_ID (+) AND QR.LINE_ID = WL.LINE_ID (+) AND QR.VENDOR_ID = PV.VENDOR_ID (+) AND PV.PARTY_ID = HP2.PARTY_ID (+) AND QR.PO_HEADER_ID = PH.PO_HEADER_ID (+) AND QR.SO_HEADER_ID = MSO.SALES_ORDER_ID (+) AND QR.RMA_HEADER_ID = OE.HEADER_ID (+) AND QR.CUSTOMER_ID = HCA.CUST_ACCOUNT_ID (+) AND HCA.PARTY_ID = HP1.PARTY_ID (+) AND QP.PLAN_TYPE_CODE = FL.LOOKUP_CODE AND FL.VIEW_APPLICATION_ID = 3 AND FL.LOOKUP_TYPE = 'COLLECTION_PLAN_TYPE' AND FL.LANGUAGE = USERENV('LANG') AND QR.PO_RELEASE_ID = PR.PO_RELEASE_ID (+) AND QR.TASK_ID = PT.TASK_ID (+) AND QR.LPN_ID = WLPN.LPN_ID (+) AND QR.XFR_LPN_ID = WLPN1.LPN_ID (+) AND QR.ORGANIZATION_ID = WO.ORGANIZATION_ID (+) AND QR.WORK_ORDER_ID = WO.WIP_ENTITY_ID (+) AND QR.PARTY_ID = HP.PARTY_ID (+) AND QR.CSI_INSTANCE_ID = CII.INSTANCE_ID (+) AND QR.AHL_MR_ID = AMR.MR_HEADER_ID (+) AND QR.COUNTER_ID = CCT.COUNTER_ID (+) AND CCT.LANGUAGE (+) = USERENV('LANG') AND QR.COUNTER_READING_ID = CCV.COUNTER_VALUE_ID (+) AND QR.WIP_REWORK_ID = WE2.WIP_ENTITY_ID (+) AND QR.CS_INCIDENT_ID = CI.INCIDENT_ID (+) AND QR.LOT_STATUS_ID = MMSB.STATUS_ID (+) AND MMSB.STATUS_ID = MMST.STATUS_ID (+) AND MMST.LANGUAGE (+) = USERENV('LANG') AND QR.SERIAL_STATUS_ID = MMSB2.STATUS_ID (+) AND MMSB2.STATUS_ID = MMST2.STATUS_ID (+) AND MMST2.LANGUAGE (+) = USERENV('LANG') AND QR.ORGANIZATION_ID = MSINV3.ORGANIZATION_ID (+) AND QR.TO_SUBINVENTORY = MSINV3.SECONDARY_INVENTORY_NAME (+) AND QR.ORGANIZATION_ID = MP.ORGANIZATION_ID(+) AND QR.ORGANIZATION_ID = HRORG.ORGANIZATION_ID(+) AND HRORG.LANGUAGE(+) = USERENV('LANG') AND QR.REPAIR_LINE_ID = CR.REPAIR_LINE_ID (+) AND QR.JTF_TASK_ID = JT.TASK_ID (+) AND QR.ASSET_INSTANCE_ID = EAN.INSTANCE_ID (+) AND QR.PROCESS_BATCH_ID = GBH.BATCH_ID(+) AND QR.PROCESS_BATCHSTEP_ID = GBS.BATCHSTEP_ID(+) AND QR.PROCESS_OPERATION_ID = GOB.OPRN_ID(+) AND QR.PROCESS_ACTIVITY_ID = GBSA.BATCHSTEP_ACTIVITY_ID(+) AND QR.PROCESS_RESOURCE_ID = GBSR.BATCHSTEP_RESOURCE_ID(+) AND QR.PROCESS_PARAMETER_ID = GPPB.PARAMETER_ID(+)

View Text - HTML Formatted

SELECT QR.ROWID ROW_ID
, QR.COLLECTION_ID
, QR.OCCURRENCE
, QR.LAST_UPDATE_DATE
, QR.QA_LAST_UPDATE_DATE
, QR.LAST_UPDATED_BY
, QR.QA_LAST_UPDATED_BY
, FU1.USER_NAME QA_LAST_UPDATED_BY_NAME
, QR.CREATION_DATE
, QR.QA_CREATION_DATE
, QR.CREATED_BY
, QR.QA_CREATED_BY
, FU2.USER_NAME QA_CREATED_BY_NAME
, QR.LAST_UPDATE_LOGIN
, QR.REQUEST_ID
, QR.PROGRAM_APPLICATION_ID
, QR.PROGRAM_ID
, QR.PROGRAM_UPDATE_DATE
, QR.TRANSACTION_NUMBER
, QR.TXN_HEADER_ID
, QR.ORGANIZATION_ID
, MP.ORGANIZATION_CODE
, HRORG.NAME
, QR.PLAN_ID
, QP.TEMPLATE_PLAN_ID
, QR.SPEC_ID
, QP.NAME
, QP.DESCRIPTION
, FL.MEANING PLAN_TYPE
, QR.TRANSACTION_ID
, QR.DEPARTMENT_ID
, BD.DEPARTMENT_CODE DEPARTMENT
, QR.TO_DEPARTMENT_ID
, BD2.DEPARTMENT_CODE TO_DEPARTMENT
, QR.RESOURCE_ID
, BR.RESOURCE_CODE
, QR.QUANTITY
, QR.ITEM_ID
, QA_FLEX_UTIL.ITEM2(QR.ORGANIZATION_ID
, QR.ITEM_ID)
, QR.UOM
, QR.REVISION
, QR.SUBINVENTORY
, MSINV.LOCATOR_TYPE SUB_LOC_TYPE
, QR.LOCATOR_ID
, QA_FLEX_UTIL.LOCATOR2(QR.ORGANIZATION_ID
, QR.LOCATOR_ID)
, QR.LOT_NUMBER
, QR.SERIAL_NUMBER
, QR.COMP_ITEM_ID
, QR.COMP_UOM
, QR.COMP_REVISION
, QR.COMP_SUBINVENTORY
, MSINV2.LOCATOR_TYPE COMP_SUB_LOC_TYPE
, QR.COMP_LOCATOR_ID
, QR.COMP_LOT_NUMBER
, QR.COMP_SERIAL_NUMBER
, QR.WIP_ENTITY_ID
, WE.WIP_ENTITY_NAME JOB_NAME
, QR.LINE_ID
, WL.LINE_CODE PRODUCTION_LINE
, QR.TO_OP_SEQ_NUM
, QR.FROM_OP_SEQ_NUM
, QR.VENDOR_ID
, PV.VENDOR_NAME VENDOR_NAME
, QR.RECEIPT_NUM
, QR.PO_HEADER_ID
, QR.PO_RELEASE_ID
, NVL(PH.CLM_DOCUMENT_NUMBER
, PH.SEGMENT1) PO_NUMBER
, QR.PO_LINE_NUM
, QR.PO_SHIPMENT_NUM
, PR.RELEASE_NUM PO_RELEASE_NUM
, PH.TYPE_LOOKUP_CODE PO_TYPE_LOOKUP
, QR.PROJECT_ID
, QA_FLEX_UTIL.PROJECT_NUMBER(QR.PROJECT_ID) PROJECT_NUMBER
, QR.TASK_ID
, PT.TASK_NUMBER
, QR.CUSTOMER_ID
, HP1.PARTY_NAME CUSTOMER_NAME
, QR.SO_HEADER_ID
, MSO.SEGMENT1
, QR.RMA_HEADER_ID
, OE.ORDER_NUMBER
, QR.STATUS
, QR.TRANSACTION_DATE
, QR.LPN_ID
, WLPN.LICENSE_PLATE_NUMBER
, QR.CONTRACT_ID
, QA_FLEX_UTIL.CONTRACT_NUMBER(QR.CONTRACT_ID) CONTRACT_NUMBER
, QR.CONTRACT_LINE_ID
, QA_FLEX_UTIL.CONTRACT_LINE_NUMBER(QR.CONTRACT_LINE_ID) CONTRACT_LINE_NUMBER
, QR.DELIVERABLE_ID
, QA_FLEX_UTIL.DELIVERABLE_NUMBER(QR.DELIVERABLE_ID) DELIVERABLE_NUMBER
, QR.CHARACTER1
, QR.CHARACTER2
, QR.CHARACTER3
, QR.CHARACTER4
, QR.CHARACTER5
, QR.CHARACTER6
, QR.CHARACTER7
, QR.CHARACTER8
, QR.CHARACTER9
, QR.CHARACTER10
, QR.CHARACTER11
, QR.CHARACTER12
, QR.CHARACTER13
, QR.CHARACTER14
, QR.CHARACTER15
, QR.CHARACTER16
, QR.CHARACTER17
, QR.CHARACTER18
, QR.CHARACTER19
, QR.CHARACTER20
, QR.CHARACTER21
, QR.CHARACTER22
, QR.CHARACTER23
, QR.CHARACTER24
, QR.CHARACTER25
, QR.CHARACTER26
, QR.CHARACTER27
, QR.CHARACTER28
, QR.CHARACTER29
, QR.CHARACTER30
, QR.CHARACTER31
, QR.CHARACTER32
, QR.CHARACTER33
, QR.CHARACTER34
, QR.CHARACTER35
, QR.CHARACTER36
, QR.CHARACTER37
, QR.CHARACTER38
, QR.CHARACTER39
, QR.CHARACTER40
, QR.CHARACTER41
, QR.CHARACTER42
, QR.CHARACTER43
, QR.CHARACTER44
, QR.CHARACTER45
, QR.CHARACTER46
, QR.CHARACTER47
, QR.CHARACTER48
, QR.CHARACTER49
, QR.CHARACTER50
, QR.CHARACTER51
, QR.CHARACTER52
, QR.CHARACTER53
, QR.CHARACTER54
, QR.CHARACTER55
, QR.CHARACTER56
, QR.CHARACTER57
, QR.CHARACTER58
, QR.CHARACTER59
, QR.CHARACTER60
, QR.CHARACTER61
, QR.CHARACTER62
, QR.CHARACTER63
, QR.CHARACTER64
, QR.CHARACTER65
, QR.CHARACTER66
, QR.CHARACTER67
, QR.CHARACTER68
, QR.CHARACTER69
, QR.CHARACTER70
, QR.CHARACTER71
, QR.CHARACTER72
, QR.CHARACTER73
, QR.CHARACTER74
, QR.CHARACTER75
, QR.CHARACTER76
, QR.CHARACTER77
, QR.CHARACTER78
, QR.CHARACTER79
, QR.CHARACTER80
, QR.CHARACTER81
, QR.CHARACTER82
, QR.CHARACTER83
, QR.CHARACTER84
, QR.CHARACTER85
, QR.CHARACTER86
, QR.CHARACTER87
, QR.CHARACTER88
, QR.CHARACTER89
, QR.CHARACTER90
, QR.CHARACTER91
, QR.CHARACTER92
, QR.CHARACTER93
, QR.CHARACTER94
, QR.CHARACTER95
, QR.CHARACTER96
, QR.CHARACTER97
, QR.CHARACTER98
, QR.CHARACTER99
, QR.CHARACTER100
, QR.ASSET_GROUP_ID
, QA_FLEX_UTIL.ITEM2(QR.ORGANIZATION_ID
, QR.ASSET_GROUP_ID) ASSET_GROUP
, QR.ASSET_NUMBER
, QR.ASSET_ACTIVITY_ID
, QA_FLEX_UTIL.ITEM2(QR.ORGANIZATION_ID
, QR.ASSET_ACTIVITY_ID) ASSET_ACTIVITY
, QR.WORK_ORDER_ID
, WO.WIP_ENTITY_NAME WORK_ORDER
, QR.SEQUENCE1
, QR.SEQUENCE2
, QR.SEQUENCE3
, QR.SEQUENCE4
, QR.SEQUENCE5
, QR.SEQUENCE6
, QR.SEQUENCE7
, QR.SEQUENCE8
, QR.SEQUENCE9
, QR.SEQUENCE10
, QR.SEQUENCE11
, QR.SEQUENCE12
, QR.SEQUENCE13
, QR.SEQUENCE14
, QR.SEQUENCE15
, QR.COMMENT1
, QR.COMMENT2
, QR.COMMENT3
, QR.COMMENT4
, QR.COMMENT5
, QR.PARTY_ID
, HP.PARTY_NAME
, QR.CSI_INSTANCE_ID
, CII.INSTANCE_NUMBER
, QR.COUNTER_ID
, CCT.NAME COUNTER_NAME
, QR.COUNTER_READING_ID
, CCV.COUNTER_READING
, QR.AHL_MR_ID
, AMR.TITLE MAINTENANCE_REQUIREMENT
, QR.CS_INCIDENT_ID
, CI.INCIDENT_NUMBER SERVICE_REQUEST
, QR.WIP_REWORK_ID
, WE2.WIP_ENTITY_NAME REWORK_JOB
, QR.DISPOSITION_SOURCE
, QR.DISPOSITION
, QR.DISPOSITION_ACTION
, QR.DISPOSITION_STATUS
, QR.MTI_TRANSACTION_HEADER_ID
, QR.MTI_TRANSACTION_INTERFACE_ID
, QR.MMT_TRANSACTION_ID
, QR.WJSI_GROUP_ID
, QR.WMTI_GROUP_ID
, QR.WMT_TRANSACTION_ID
, QR.RTI_INTERFACE_TRANSACTION_ID
, QR.MAINTENANCE_OP_SEQ
, QR.NONCONFORMANCE_SOURCE
, QR.NONCONFORM_SEVERITY
, QR.NONCONFORM_PRIORITY
, QR.NONCONFORMANCE_TYPE
, QR.NONCONFORMANCE_CODE
, QR.DATE_OPENED
, QR.DATE_CLOSED
, QR.DAYS_TO_CLOSE
, QR.TO_SUBINVENTORY
, MSINV3.LOCATOR_TYPE
, QR.TO_LOCATOR_ID
, QR.BILL_REFERENCE_ID
, QR.ROUTING_REFERENCE_ID
, QR.CONCURRENT_REQUEST_ID
, QR.LOT_STATUS_ID
, MMST.STATUS_CODE
, QR.SERIAL_STATUS_ID
, MMST2.STATUS_CODE
, QR.NONCONFORMANCE_STATUS
, QR.RCV_TRANSACTION_ID
, QR.REQUEST_STATUS
, QR.REQUEST_SOURCE
, QR.REQUEST_PRIORITY
, QR.REQUEST_SEVERITY
, QR.ECO_NAME
, QR.FOLLOWUP_ACTIVITY_ID
, QA_FLEX_UTIL.ITEM2(QR.ORGANIZATION_ID
, QR.FOLLOWUP_ACTIVITY_ID)
, QR.XFR_LPN_ID
, WLPN1.LICENSE_PLATE_NUMBER
, QA_FLEX_UTIL.ITEM2(QR.ORGANIZATION_ID
, QR.COMP_ITEM_ID)
, QA_FLEX_UTIL.LOCATOR2(QR.ORGANIZATION_ID
, QR.COMP_LOCATOR_ID)
, QA_FLEX_UTIL.LOCATOR2(QR.ORGANIZATION_ID
, QR.TO_LOCATOR_ID)
, QA_FLEX_UTIL.ITEM2(QR.ORGANIZATION_ID
, QR.BILL_REFERENCE_ID)
, QA_FLEX_UTIL.ITEM2(QR.ORGANIZATION_ID
, QR.ROUTING_REFERENCE_ID)
, QR.REPAIR_LINE_ID
, CR.REPAIR_NUMBER
, QR.JTF_TASK_ID
, JT.TASK_NUMBER
, QR.ASSET_INSTANCE_ID
, EAN.INSTANCE_NUMBER
, QR.PROCESS_BATCH_ID
, GBH.BATCH_NO
, QR.PROCESS_BATCHSTEP_ID
, GBS.BATCHSTEP_NO
, QR.PROCESS_OPERATION_ID
, DECODE(QR.PROCESS_OPERATION_ID
, NULL
, NULL
, GOB.OPRN_NO || '-' || GOB.OPRN_VERS)
, QR.PROCESS_ACTIVITY_ID
, GBSA.ACTIVITY
, QR.PROCESS_RESOURCE_ID
, GBSR.RESOURCES
, QR.PROCESS_PARAMETER_ID
, GPPB.PARAMETER_NAME
FROM FND_USER_VIEW FU1
, FND_USER_VIEW FU2
, FND_LOOKUP_VALUES FL
, AP_SUPPLIERS PV
, HZ_PARTIES HP2
, PO_HEADERS_ALL PH
, MTL_SALES_ORDERS MSO
, OE_ORDER_HEADERS_ALL OE
, PO_RELEASES_ALL PR
, HZ_CUST_ACCOUNTS HCA
, HZ_PARTIES HP1
, MTL_SECONDARY_INVENTORIES MSINV
, MTL_SECONDARY_INVENTORIES MSINV2
, BOM_DEPARTMENTS BD
, BOM_DEPARTMENTS BD2
, BOM_RESOURCES BR
, WIP_ENTITIES WE
, WIP_LINES WL
, QA_PLANS QP
, PA_TASKS PT
, QA_RESULTS QR
, WMS_LICENSE_PLATE_NUMBERS WLPN
, WMS_LICENSE_PLATE_NUMBERS WLPN1
, WIP_ENTITIES WO
, HZ_PARTIES HP
, QA_CSI_ITEM_INSTANCES CII
, QA_AHL_MR AMR
, CSI_COUNTERS_TL CCT
, CSI_COUNTER_READINGS CCV
, WIP_ENTITIES WE2
, CS_INCIDENTS_ALL_B CI
, MTL_MATERIAL_STATUSES_B MMSB
, MTL_MATERIAL_STATUSES_TL MMST
, MTL_MATERIAL_STATUSES_B MMSB2
, MTL_MATERIAL_STATUSES_TL MMST2
, MTL_SECONDARY_INVENTORIES MSINV3
, MTL_PARAMETERS MP
, HR_ALL_ORGANIZATION_UNITS_TL HRORG
, CSD_REPAIRS CR
, JTF_TASKS_B JT
, CSI_ITEM_INSTANCES EAN
, GME_BATCH_STEP_ACTIVITIES GBSA
, GME_BATCH_STEP_RESOURCES GBSR
, GMP_PROCESS_PARAMETERS_B GPPB
, GME_BATCH_HEADER GBH
, GME_BATCH_STEPS GBS
, GMD_OPERATIONS_B GOB
WHERE QR.PLAN_ID = QP.PLAN_ID
AND QR.QA_LAST_UPDATED_BY = FU1.USER_ID
AND QR.QA_CREATED_BY = FU2.USER_ID
AND QR.ORGANIZATION_ID = MSINV.ORGANIZATION_ID (+)
AND QR.SUBINVENTORY = MSINV.SECONDARY_INVENTORY_NAME (+)
AND QR.ORGANIZATION_ID = MSINV2.ORGANIZATION_ID (+)
AND QR.COMP_SUBINVENTORY = MSINV2.SECONDARY_INVENTORY_NAME (+)
AND QR.ORGANIZATION_ID = BD.ORGANIZATION_ID (+)
AND QR.ORGANIZATION_ID = BD2.ORGANIZATION_ID (+)
AND QR.DEPARTMENT_ID = BD.DEPARTMENT_ID (+)
AND QR.TO_DEPARTMENT_ID = BD2.DEPARTMENT_ID (+)
AND QR.RESOURCE_ID = BR.RESOURCE_ID (+)
AND QR.ORGANIZATION_ID = WE.ORGANIZATION_ID (+)
AND QR.WIP_ENTITY_ID = WE.WIP_ENTITY_ID (+)
AND QR.ORGANIZATION_ID = WL.ORGANIZATION_ID (+)
AND QR.LINE_ID = WL.LINE_ID (+)
AND QR.VENDOR_ID = PV.VENDOR_ID (+)
AND PV.PARTY_ID = HP2.PARTY_ID (+)
AND QR.PO_HEADER_ID = PH.PO_HEADER_ID (+)
AND QR.SO_HEADER_ID = MSO.SALES_ORDER_ID (+)
AND QR.RMA_HEADER_ID = OE.HEADER_ID (+)
AND QR.CUSTOMER_ID = HCA.CUST_ACCOUNT_ID (+)
AND HCA.PARTY_ID = HP1.PARTY_ID (+)
AND QP.PLAN_TYPE_CODE = FL.LOOKUP_CODE
AND FL.VIEW_APPLICATION_ID = 3
AND FL.LOOKUP_TYPE = 'COLLECTION_PLAN_TYPE'
AND FL.LANGUAGE = USERENV('LANG')
AND QR.PO_RELEASE_ID = PR.PO_RELEASE_ID (+)
AND QR.TASK_ID = PT.TASK_ID (+)
AND QR.LPN_ID = WLPN.LPN_ID (+)
AND QR.XFR_LPN_ID = WLPN1.LPN_ID (+)
AND QR.ORGANIZATION_ID = WO.ORGANIZATION_ID (+)
AND QR.WORK_ORDER_ID = WO.WIP_ENTITY_ID (+)
AND QR.PARTY_ID = HP.PARTY_ID (+)
AND QR.CSI_INSTANCE_ID = CII.INSTANCE_ID (+)
AND QR.AHL_MR_ID = AMR.MR_HEADER_ID (+)
AND QR.COUNTER_ID = CCT.COUNTER_ID (+)
AND CCT.LANGUAGE (+) = USERENV('LANG')
AND QR.COUNTER_READING_ID = CCV.COUNTER_VALUE_ID (+)
AND QR.WIP_REWORK_ID = WE2.WIP_ENTITY_ID (+)
AND QR.CS_INCIDENT_ID = CI.INCIDENT_ID (+)
AND QR.LOT_STATUS_ID = MMSB.STATUS_ID (+)
AND MMSB.STATUS_ID = MMST.STATUS_ID (+)
AND MMST.LANGUAGE (+) = USERENV('LANG')
AND QR.SERIAL_STATUS_ID = MMSB2.STATUS_ID (+)
AND MMSB2.STATUS_ID = MMST2.STATUS_ID (+)
AND MMST2.LANGUAGE (+) = USERENV('LANG')
AND QR.ORGANIZATION_ID = MSINV3.ORGANIZATION_ID (+)
AND QR.TO_SUBINVENTORY = MSINV3.SECONDARY_INVENTORY_NAME (+)
AND QR.ORGANIZATION_ID = MP.ORGANIZATION_ID(+)
AND QR.ORGANIZATION_ID = HRORG.ORGANIZATION_ID(+)
AND HRORG.LANGUAGE(+) = USERENV('LANG')
AND QR.REPAIR_LINE_ID = CR.REPAIR_LINE_ID (+)
AND QR.JTF_TASK_ID = JT.TASK_ID (+)
AND QR.ASSET_INSTANCE_ID = EAN.INSTANCE_ID (+)
AND QR.PROCESS_BATCH_ID = GBH.BATCH_ID(+)
AND QR.PROCESS_BATCHSTEP_ID = GBS.BATCHSTEP_ID(+)
AND QR.PROCESS_OPERATION_ID = GOB.OPRN_ID(+)
AND QR.PROCESS_ACTIVITY_ID = GBSA.BATCHSTEP_ACTIVITY_ID(+)
AND QR.PROCESS_RESOURCE_ID = GBSR.BATCHSTEP_RESOURCE_ID(+)
AND QR.PROCESS_PARAMETER_ID = GPPB.PARAMETER_ID(+)