VIEW: APPS.QA_RESULTS_QWB_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 , 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 , NULL , 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, QA_PLANS QP, QA_RESULTS QR WHERE QR.PLAN_ID = QP.PLAN_ID AND QR.QA_CREATED_BY = FU2.USER_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')

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
, 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
, NULL
, 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
, QA_PLANS QP
, QA_RESULTS QR
WHERE QR.PLAN_ID = QP.PLAN_ID
AND QR.QA_CREATED_BY = FU2.USER_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')