[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | QA_RESULTS# |
|---|---|
| Object Type: | VIEW |
| Owner: | QA |
| Subobject Name: | |
| Status: | VALID |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| COLLECTION_ID | NUMBER | Yes | ||
| OCCURRENCE | NUMBER | Yes | ||
| LAST_UPDATE_DATE | DATE | Yes | ||
| QA_LAST_UPDATE_DATE | DATE | Yes | ||
| LAST_UPDATED_BY | NUMBER | Yes | ||
| QA_LAST_UPDATED_BY | NUMBER | Yes | ||
| CREATION_DATE | DATE | Yes | ||
| QA_CREATION_DATE | DATE | Yes | ||
| CREATED_BY | NUMBER | Yes | ||
| QA_CREATED_BY | NUMBER | Yes | ||
| LAST_UPDATE_LOGIN | NUMBER | |||
| REQUEST_ID | NUMBER | |||
| PROGRAM_APPLICATION_ID | NUMBER | |||
| PROGRAM_ID | NUMBER | |||
| PROGRAM_UPDATE_DATE | DATE | |||
| TRANSACTION_NUMBER | NUMBER | |||
| TXN_HEADER_ID | NUMBER | |||
| ORGANIZATION_ID | NUMBER | Yes | ||
| PLAN_ID | NUMBER | Yes | ||
| SPEC_ID | NUMBER | |||
| TRANSACTION_ID | NUMBER | |||
| DEPARTMENT_ID | NUMBER | |||
| TO_DEPARTMENT_ID | NUMBER | |||
| RESOURCE_ID | NUMBER | |||
| QUANTITY | NUMBER | |||
| ITEM_ID | NUMBER | |||
| UOM | VARCHAR2 | (3) | ||
| REVISION | VARCHAR2 | (3) | ||
| SUBINVENTORY | VARCHAR2 | (10) | ||
| LOCATOR_ID | NUMBER | |||
| LOT_NUMBER | VARCHAR2 | (80) | ||
| SERIAL_NUMBER | VARCHAR2 | (30) | ||
| COMP_ITEM_ID | NUMBER | |||
| COMP_UOM | VARCHAR2 | (3) | ||
| COMP_REVISION | VARCHAR2 | (3) | ||
| COMP_SUBINVENTORY | VARCHAR2 | (10) | ||
| COMP_LOCATOR_ID | NUMBER | |||
| COMP_LOT_NUMBER | VARCHAR2 | (80) | ||
| COMP_SERIAL_NUMBER | VARCHAR2 | (30) | ||
| WIP_ENTITY_ID | NUMBER | |||
| LINE_ID | NUMBER | |||
| TO_OP_SEQ_NUM | NUMBER | |||
| FROM_OP_SEQ_NUM | NUMBER | |||
| VENDOR_ID | NUMBER | |||
| RECEIPT_NUM | VARCHAR2 | (30) | ||
| PO_HEADER_ID | NUMBER | |||
| PO_RELEASE_ID | NUMBER | |||
| PO_LINE_NUM | VARCHAR2 | (240) | ||
| PO_SHIPMENT_NUM | NUMBER | |||
| CUSTOMER_ID | NUMBER | |||
| SO_HEADER_ID | NUMBER | |||
| RMA_HEADER_ID | NUMBER | |||
| PROJECT_ID | NUMBER | |||
| TASK_ID | NUMBER | |||
| STATUS | NUMBER | |||
| TRANSACTION_DATE | DATE | |||
| CHARACTER1 | VARCHAR2 | (150) | ||
| CHARACTER2 | VARCHAR2 | (150) | ||
| CHARACTER3 | VARCHAR2 | (150) | ||
| CHARACTER4 | VARCHAR2 | (150) | ||
| CHARACTER5 | VARCHAR2 | (150) | ||
| CHARACTER6 | VARCHAR2 | (150) | ||
| CHARACTER7 | VARCHAR2 | (150) | ||
| CHARACTER8 | VARCHAR2 | (150) | ||
| CHARACTER9 | VARCHAR2 | (150) | ||
| CHARACTER10 | VARCHAR2 | (150) | ||
| CHARACTER11 | VARCHAR2 | (150) | ||
| CHARACTER12 | VARCHAR2 | (150) | ||
| CHARACTER13 | VARCHAR2 | (150) | ||
| CHARACTER14 | VARCHAR2 | (150) | ||
| CHARACTER15 | VARCHAR2 | (150) | ||
| CHARACTER16 | VARCHAR2 | (150) | ||
| CHARACTER17 | VARCHAR2 | (150) | ||
| CHARACTER18 | VARCHAR2 | (150) | ||
| CHARACTER19 | VARCHAR2 | (150) | ||
| CHARACTER20 | VARCHAR2 | (150) | ||
| CHARACTER21 | VARCHAR2 | (150) | ||
| CHARACTER22 | VARCHAR2 | (150) | ||
| CHARACTER23 | VARCHAR2 | (150) | ||
| CHARACTER24 | VARCHAR2 | (150) | ||
| CHARACTER25 | VARCHAR2 | (150) | ||
| CHARACTER26 | VARCHAR2 | (150) | ||
| CHARACTER27 | VARCHAR2 | (150) | ||
| CHARACTER28 | VARCHAR2 | (150) | ||
| CHARACTER29 | VARCHAR2 | (150) | ||
| CHARACTER30 | VARCHAR2 | (150) | ||
| CHARACTER31 | VARCHAR2 | (150) | ||
| CHARACTER32 | VARCHAR2 | (150) | ||
| CHARACTER33 | VARCHAR2 | (150) | ||
| CHARACTER34 | VARCHAR2 | (150) | ||
| CHARACTER35 | VARCHAR2 | (150) | ||
| CHARACTER36 | VARCHAR2 | (150) | ||
| CHARACTER37 | VARCHAR2 | (150) | ||
| CHARACTER38 | VARCHAR2 | (150) | ||
| CHARACTER39 | VARCHAR2 | (150) | ||
| CHARACTER40 | VARCHAR2 | (150) | ||
| CHARACTER41 | VARCHAR2 | (150) | ||
| CHARACTER42 | VARCHAR2 | (150) | ||
| CHARACTER43 | VARCHAR2 | (150) | ||
| CHARACTER44 | VARCHAR2 | (150) | ||
| CHARACTER45 | VARCHAR2 | (150) | ||
| CHARACTER46 | VARCHAR2 | (150) | ||
| CHARACTER47 | VARCHAR2 | (150) | ||
| CHARACTER48 | VARCHAR2 | (150) | ||
| CHARACTER49 | VARCHAR2 | (150) | ||
| CHARACTER50 | VARCHAR2 | (150) | ||
| CHARACTER51 | VARCHAR2 | (150) | ||
| CHARACTER52 | VARCHAR2 | (150) | ||
| CHARACTER53 | VARCHAR2 | (150) | ||
| CHARACTER54 | VARCHAR2 | (150) | ||
| CHARACTER55 | VARCHAR2 | (150) | ||
| CHARACTER56 | VARCHAR2 | (150) | ||
| CHARACTER57 | VARCHAR2 | (150) | ||
| CHARACTER58 | VARCHAR2 | (150) | ||
| CHARACTER59 | VARCHAR2 | (150) | ||
| CHARACTER60 | VARCHAR2 | (150) | ||
| CHARACTER61 | VARCHAR2 | (150) | ||
| CHARACTER62 | VARCHAR2 | (150) | ||
| CHARACTER63 | VARCHAR2 | (150) | ||
| CHARACTER64 | VARCHAR2 | (150) | ||
| CHARACTER65 | VARCHAR2 | (150) | ||
| CHARACTER66 | VARCHAR2 | (150) | ||
| CHARACTER67 | VARCHAR2 | (150) | ||
| CHARACTER68 | VARCHAR2 | (150) | ||
| CHARACTER69 | VARCHAR2 | (150) | ||
| CHARACTER70 | VARCHAR2 | (150) | ||
| CHARACTER71 | VARCHAR2 | (150) | ||
| CHARACTER72 | VARCHAR2 | (150) | ||
| CHARACTER73 | VARCHAR2 | (150) | ||
| CHARACTER74 | VARCHAR2 | (150) | ||
| CHARACTER75 | VARCHAR2 | (150) | ||
| CHARACTER76 | VARCHAR2 | (150) | ||
| CHARACTER77 | VARCHAR2 | (150) | ||
| CHARACTER78 | VARCHAR2 | (150) | ||
| CHARACTER79 | VARCHAR2 | (150) | ||
| CHARACTER80 | VARCHAR2 | (150) | ||
| CHARACTER81 | VARCHAR2 | (150) | ||
| CHARACTER82 | VARCHAR2 | (150) | ||
| CHARACTER83 | VARCHAR2 | (150) | ||
| CHARACTER84 | VARCHAR2 | (150) | ||
| CHARACTER85 | VARCHAR2 | (150) | ||
| CHARACTER86 | VARCHAR2 | (150) | ||
| CHARACTER87 | VARCHAR2 | (150) | ||
| CHARACTER88 | VARCHAR2 | (150) | ||
| CHARACTER89 | VARCHAR2 | (150) | ||
| CHARACTER90 | VARCHAR2 | (150) | ||
| CHARACTER91 | VARCHAR2 | (150) | ||
| CHARACTER92 | VARCHAR2 | (150) | ||
| CHARACTER93 | VARCHAR2 | (150) | ||
| CHARACTER94 | VARCHAR2 | (150) | ||
| CHARACTER95 | VARCHAR2 | (150) | ||
| CHARACTER96 | VARCHAR2 | (150) | ||
| CHARACTER97 | VARCHAR2 | (150) | ||
| CHARACTER98 | VARCHAR2 | (150) | ||
| CHARACTER99 | VARCHAR2 | (150) | ||
| CHARACTER100 | VARCHAR2 | (150) | ||
| LPN_ID | NUMBER | |||
| CONTRACT_ID | NUMBER | |||
| CONTRACT_LINE_ID | NUMBER | |||
| DELIVERABLE_ID | NUMBER | |||
| ASSET_GROUP_ID | NUMBER | |||
| ASSET_ACTIVITY_ID | NUMBER | |||
| ASSET_NUMBER | VARCHAR2 | (30) | ||
| WORK_ORDER_ID | NUMBER | |||
| SEQUENCE1 | VARCHAR2 | (50) | ||
| SEQUENCE2 | VARCHAR2 | (50) | ||
| SEQUENCE3 | VARCHAR2 | (50) | ||
| SEQUENCE4 | VARCHAR2 | (50) | ||
| SEQUENCE5 | VARCHAR2 | (50) | ||
| SEQUENCE6 | VARCHAR2 | (50) | ||
| SEQUENCE7 | VARCHAR2 | (50) | ||
| SEQUENCE8 | VARCHAR2 | (50) | ||
| SEQUENCE9 | VARCHAR2 | (50) | ||
| SEQUENCE10 | VARCHAR2 | (50) | ||
| SEQUENCE11 | VARCHAR2 | (50) | ||
| SEQUENCE12 | VARCHAR2 | (50) | ||
| SEQUENCE13 | VARCHAR2 | (50) | ||
| SEQUENCE14 | VARCHAR2 | (50) | ||
| SEQUENCE15 | VARCHAR2 | (50) | ||
| COMMENT1 | VARCHAR2 | (2000) | ||
| COMMENT2 | VARCHAR2 | (2000) | ||
| COMMENT3 | VARCHAR2 | (2000) | ||
| COMMENT4 | VARCHAR2 | (2000) | ||
| COMMENT5 | VARCHAR2 | (2000) | ||
| PARTY_ID | NUMBER | |||
| CSI_INSTANCE_ID | NUMBER | |||
| COUNTER_ID | NUMBER | |||
| COUNTER_READING_ID | NUMBER | |||
| AHL_MR_ID | NUMBER | |||
| CS_INCIDENT_ID | NUMBER | |||
| WIP_REWORK_ID | NUMBER | |||
| DISPOSITION_SOURCE | VARCHAR2 | (150) | ||
| DISPOSITION | VARCHAR2 | (150) | ||
| DISPOSITION_ACTION | VARCHAR2 | (150) | ||
| DISPOSITION_STATUS | VARCHAR2 | (150) | ||
| MTI_TRANSACTION_HEADER_ID | NUMBER | |||
| MTI_TRANSACTION_INTERFACE_ID | NUMBER | |||
| MMT_TRANSACTION_ID | NUMBER | |||
| WJSI_GROUP_ID | NUMBER | |||
| WMTI_GROUP_ID | NUMBER | |||
| WMT_TRANSACTION_ID | NUMBER | |||
| RTI_INTERFACE_TRANSACTION_ID | NUMBER | |||
| MAINTENANCE_OP_SEQ | NUMBER | |||
| NONCONFORMANCE_SOURCE | VARCHAR2 | (150) | ||
| NONCONFORM_SEVERITY | VARCHAR2 | (150) | ||
| NONCONFORM_PRIORITY | VARCHAR2 | (150) | ||
| NONCONFORMANCE_TYPE | VARCHAR2 | (150) | ||
| NONCONFORMANCE_CODE | VARCHAR2 | (150) | ||
| DATE_OPENED | DATE | |||
| DATE_CLOSED | DATE | |||
| DAYS_TO_CLOSE | NUMBER | |||
| TO_SUBINVENTORY | VARCHAR2 | (150) | ||
| TO_LOCATOR_ID | NUMBER | |||
| BILL_REFERENCE_ID | NUMBER | |||
| ROUTING_REFERENCE_ID | NUMBER | |||
| CONCURRENT_REQUEST_ID | NUMBER | |||
| LOT_STATUS_ID | NUMBER | |||
| SERIAL_STATUS_ID | NUMBER | |||
| NONCONFORMANCE_STATUS | VARCHAR2 | (150) | ||
| RCV_TRANSACTION_ID | NUMBER | |||
| REQUEST_STATUS | VARCHAR2 | (150) | ||
| REQUEST_SOURCE | VARCHAR2 | (150) | ||
| REQUEST_PRIORITY | VARCHAR2 | (150) | ||
| REQUEST_SEVERITY | VARCHAR2 | (150) | ||
| ECO_NAME | VARCHAR2 | (150) | ||
| FOLLOWUP_ACTIVITY_ID | NUMBER | |||
| XFR_LPN_ID | NUMBER | |||
| REPAIR_LINE_ID | NUMBER | |||
| JTF_TASK_ID | NUMBER | |||
| ASSET_INSTANCE_ID | NUMBER | |||
| PROCESS_BATCH_ID | NUMBER | |||
| PROCESS_BATCHSTEP_ID | NUMBER | |||
| PROCESS_OPERATION_ID | NUMBER | |||
| PROCESS_ACTIVITY_ID | NUMBER | |||
| PROCESS_RESOURCE_ID | NUMBER | |||
| PROCESS_PARAMETER_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT COLLECTION_ID
, OCCURRENCE
, LAST_UPDATE_DATE
, QA_LAST_UPDATE_DATE
, LAST_UPDATED_BY
, QA_LAST_UPDATED_BY
, CREATION_DATE
, QA_CREATION_DATE
, CREATED_BY
, QA_CREATED_BY
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, TRANSACTION_NUMBER
, TXN_HEADER_ID
, ORGANIZATION_ID
, PLAN_ID
, SPEC_ID
, TRANSACTION_ID
, DEPARTMENT_ID
, TO_DEPARTMENT_ID
, RESOURCE_ID
, QUANTITY
, ITEM_ID
, UOM
, REVISION
, SUBINVENTORY
, LOCATOR_ID
, LOT_NUMBER
, SERIAL_NUMBER
, COMP_ITEM_ID
, COMP_UOM
, COMP_REVISION
, COMP_SUBINVENTORY
, COMP_LOCATOR_ID
, COMP_LOT_NUMBER
, COMP_SERIAL_NUMBER
, WIP_ENTITY_ID
, LINE_ID
, TO_OP_SEQ_NUM
, FROM_OP_SEQ_NUM
, VENDOR_ID
, RECEIPT_NUM
, PO_HEADER_ID
, PO_RELEASE_ID
, PO_LINE_NUM
, PO_SHIPMENT_NUM
, CUSTOMER_ID
, SO_HEADER_ID
, RMA_HEADER_ID
, PROJECT_ID
, TASK_ID
, STATUS
, TRANSACTION_DATE
, 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
, LPN_ID
, CONTRACT_ID
, CONTRACT_LINE_ID
, DELIVERABLE_ID
, ASSET_GROUP_ID
, ASSET_ACTIVITY_ID
, ASSET_NUMBER
, WORK_ORDER_ID
, SEQUENCE1
, SEQUENCE2
, SEQUENCE3
, SEQUENCE4
, SEQUENCE5
, SEQUENCE6
, SEQUENCE7
, SEQUENCE8
, SEQUENCE9
, SEQUENCE10
, SEQUENCE11
, SEQUENCE12
, SEQUENCE13
, SEQUENCE14
, SEQUENCE15
, COMMENT1
, COMMENT2
, COMMENT3
, COMMENT4
, COMMENT5
, PARTY_ID
, CSI_INSTANCE_ID
, COUNTER_ID
, COUNTER_READING_ID
, AHL_MR_ID
, CS_INCIDENT_ID
, WIP_REWORK_ID
, 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_LOCATOR_ID
, BILL_REFERENCE_ID
, ROUTING_REFERENCE_ID
, CONCURRENT_REQUEST_ID
, LOT_STATUS_ID
, SERIAL_STATUS_ID
, NONCONFORMANCE_STATUS
, RCV_TRANSACTION_ID
, REQUEST_STATUS
, REQUEST_SOURCE
, REQUEST_PRIORITY
, REQUEST_SEVERITY
, ECO_NAME
, FOLLOWUP_ACTIVITY_ID
, XFR_LPN_ID
, REPAIR_LINE_ID
, JTF_TASK_ID
, ASSET_INSTANCE_ID
, PROCESS_BATCH_ID
, PROCESS_BATCHSTEP_ID
, PROCESS_OPERATION_ID
, PROCESS_ACTIVITY_ID
, PROCESS_RESOURCE_ID
, PROCESS_PARAMETER_ID
FROM QA.QA_RESULTS#;
QA
QA_RESULTS
APPS
QA_RESULTS
|
|
|
|