FND Design Data [Home] [Help]

View: QA_RESULTS_QWB_V

Product: QA - Quality
Description: Shows all quality results
Implementation/DBA Data: ViewAPPS.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

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