View: QA_RESULTS_QWB_V

Product:	QA - Quality
Description:	Shows all quality results
Implementation/DBA Data:	APPS.QA_RESULTS_QWB_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
, NULL
, 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
, NULL
, QR.PLAN_ID
, QP.TEMPLATE_PLAN_ID
, QR.SPEC_ID
, QP.NAME
, QP.DESCRIPTION
, FL.MEANING PLAN_TYPE
, QR.TRANSACTION_ID
, QR.DEPARTMENT_ID
, NULL
, QR.TO_DEPARTMENT_ID
, NULL
, QR.RESOURCE_ID
, NULL
, QR.QUANTITY
, QR.ITEM_ID
, NULL
, QR.UOM
, QR.REVISION
, QR.SUBINVENTORY
, TO_NUMBER(NULL)
, QR.LOCATOR_ID
, NULL
, QR.LOT_NUMBER
, QR.SERIAL_NUMBER
, QR.COMP_ITEM_ID
, QR.COMP_UOM
, QR.COMP_REVISION
, QR.COMP_SUBINVENTORY
, TO_NUMBER(NULL)
, QR.COMP_LOCATOR_ID
, QR.COMP_LOT_NUMBER
, QR.COMP_SERIAL_NUMBER
, QR.WIP_ENTITY_ID
, NULL
, QR.LINE_ID
, NULL
, QR.TO_OP_SEQ_NUM
, QR.FROM_OP_SEQ_NUM
, QR.VENDOR_ID
, NULL
, QR.RECEIPT_NUM
, QR.PO_HEADER_ID
, QR.PO_RELEASE_ID
, NULL
, QR.PO_LINE_NUM
, QR.PO_SHIPMENT_NUM
, TO_NUMBER(NULL)
, NULL
, QR.PROJECT_ID
, NULL
, QR.TASK_ID
, NULL
, QR.CUSTOMER_ID
, NULL
, QR.SO_HEADER_ID
, NULL
, QR.RMA_HEADER_ID
, TO_NUMBER(NULL)
, QR.STATUS
, QR.TRANSACTION_DATE
, QR.LPN_ID
, NULL
, QR.CONTRACT_ID
, NULL
, QR.CONTRACT_LINE_ID
, NULL
, QR.DELIVERABLE_ID
, NULL
, 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
, NULL
, QR.ASSET_NUMBER
, QR.ASSET_ACTIVITY_ID
, NULL
, QR.WORK_ORDER_ID
, NULL
, 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
, NULL
, QR.CSI_INSTANCE_ID
, NULL
, QR.COUNTER_ID
, NULL
, QR.COUNTER_READING_ID
, TO_NUMBER(NULL)
, QR.AHL_MR_ID
, NULL
, QR.CS_INCIDENT_ID
, NULL
, QR.WIP_REWORK_ID
, NULL
, 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
, TO_NUMBER(NULL)
, QR.TO_LOCATOR_ID
, QR.BILL_REFERENCE_ID
, QR.ROUTING_REFERENCE_ID
, QR.CONCURRENT_REQUEST_ID
, QR.LOT_STATUS_ID
, NULL
, QR.SERIAL_STATUS_ID
, NULL
, 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
, NULL
, QR.XFR_LPN_ID
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, QR.REPAIR_LINE_ID
, NULL
, QR.JTF_TASK_ID
, NULL
, QR.ASSET_INSTANCE_ID
, NULL
, QR.PROCESS_BATCH_ID
, NULL
, QR.PROCESS_BATCHSTEP_ID
, TO_NUMBER( NULL)
, QR.PROCESS_OPERATION_ID
, NULL
, QR.PROCESS_ACTIVITY_ID
, NULL
, QR.PROCESS_RESOURCE_ID
, NULL
, QR.PROCESS_PARAMETER_ID
, NULL
, QA_PARENT_CHILD_PKG.HAS_ENTERABLE_CHILD(QR.PLAN_ID
, QR.COLLECTION_ID
, QR.OCCURRENCE)
, QA_PARENT_CHILD_PKG.CHILD_EXISTS_FOR_UPDATE(QR.PLAN_ID
, QR.COLLECTION_ID
, QR.OCCURRENCE)
, DECODE(QA_WEB_TXN_API.ALLOWED_FOR_PLAN('QA_RESULTS_ENTER'
, QR.PLAN_ID)
, 'T'
, 'INSERT_Y'
, 'INSERT_N')
, DECODE(QA_WEB_TXN_API.ALLOWED_FOR_PLAN('QA_RESULTS_UPDATE'
, QR.PLAN_ID)
, 'T'
, 'UPDATE_Y'
, 'UPDATE_N')
, DECODE(QA_WEB_TXN_API.ALLOWED_FOR_PLAN('QA_RESULTS_DELETE'
, QR.PLAN_ID)
, 'T'
, 'DELETE_Y'
, 'DELETE_N')
, QA_WEB_TXN_API.ALLOWED_FOR_PLAN('QA_RESULTS_VIEW'
, QR.PLAN_ID)
, QA_PARENT_CHILD_PKG.GETCHILDCOUNT(QR.PLAN_ID
, QR.COLLECTION_ID
, QR.OCCURRENCE)
, QA_PLAN_ELEMENT_API.BUILD_INFO_COLUMN(QR.PLAN_ID
, QR.COLLECTION_ID
, QR.OCCURRENCE)
FROM FND_USER_VIEW FU2
, FND_LOOKUP_VALUES FL
, MTL_PARAMETERS MP
, QA_PLANS QP
, QA_RESULTS QR
WHERE QR.PLAN_ID = QP.PLAN_ID
AND QR.QA_CREATED_BY = FU2.USER_ID
AND QR.ORGANIZATION_ID = MP.ORGANIZATION_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')

Columns