View: QA_RESULTS_V

Product:	QA - Quality
Description:	Shows all quality results
Implementation/DBA Data:	APPS.QA_RESULTS_V

View Text

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
, QR.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
, QR.UOM
, QR.REVISION
, QR.SUBINVENTORY
, MSINV.LOCATOR_TYPE SUB_LOC_TYPE
, 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
, HP2.PARTY_NAME VENDOR_NAME
, QR.RECEIPT_NUM
, QR.PO_HEADER_ID
, QR.PO_RELEASE_ID
, 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.ITEM(QR.ORGANIZATION_ID
, QR.ASSET_GROUP_ID) ASSET_GROUP
, QR.ASSET_NUMBER
, QR.ASSET_ACTIVITY_ID
, QA_FLEX_UTIL.ITEM(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.ITEM(QR.ORGANIZATION_ID
, QR.FOLLOWUP_ACTIVITY_ID)
, QR.XFR_LPN_ID
, WLPN1.LICENSE_PLATE_NUMBER
, 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
, PO_RELEASES_ALL PR
, MTL_SALES_ORDERS MSO
, OE_ORDER_HEADERS_ALL OE
, 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
, 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.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(+)

Columns