[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | QA_RESULTS |
|---|---|
| Object Type: | TABLE |
| Owner: | QA |
| FND Design Data: |  QA.QA_RESULTS
|
| Subobject Name: | |
| Status: | VALID |
QA_RESULTS stores all of the quality data entered for collection plans. This table is Oracle Quality's data repository. All of the data collected either directly through transactions, or by Collection Import, reside in this table.
The columns in this table can be divided into two categories: generic or hardcoded. Generic columns are CHARACTER1 through CHARACTER100 and are generally referred to as CHARACTERx in this manual. Hardcoded columns are specific columns in this table, such as ITEM_ID or PO_HEADER_ID.
QA_CHARS.HARDCODED_COLUMN stores the name of the corresponding column in the QA_RESULTS table in which values for this collection element will be stored. For example, if QA_CHARS.HARDCODED_COLUMN has a value, there will be a corresponding column in the QA_RESULTS table that will store the collection element's result value. If QA_CHARS.HARDCODED_COLUMN has a null value, then one of the generic CHARACTERx columns will be used to store the collection lement's value.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| QA_RESULTS_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 PLAN_ID
COLLECTION_ID
OCCURRENCE
|
| QA_RESULTS_U2 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
PLAN_ID
OCCURRENCE
|
| QA_RESULTS_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
ITEM_ID
ORGANIZATION_ID
|
| QA_RESULTS_N10 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
ASSET_NUMBER
ORGANIZATION_ID
|
| QA_RESULTS_N11 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
WORK_ORDER_ID
|
| QA_RESULTS_N12 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
PROCESS_BATCH_ID
PROCESS_BATCHSTEP_ID
|
| QA_RESULTS_N13 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
WIP_ENTITY_ID
ORGANIZATION_ID
FROM_OP_SEQ_NUM
|
| QA_RESULTS_N14 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
PLAN_ID
CREATION_DATE
|
| QA_RESULTS_N2 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
SERIAL_NUMBER
ORGANIZATION_ID
|
| QA_RESULTS_N3 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
COMP_SERIAL_NUMBER
ORGANIZATION_ID
|
| QA_RESULTS_N4 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
LOT_NUMBER
ORGANIZATION_ID
|
| QA_RESULTS_N5 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
SO_HEADER_ID
|
| QA_RESULTS_N6 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
COLLECTION_ID
|
| QA_RESULTS_N7 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
TXN_HEADER_ID
|
| QA_RESULTS_N8 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
CONTRACT_ID
CONTRACT_LINE_ID
DELIVERABLE_ID
|
| QA_RESULTS_N9 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
ASSET_GROUP_ID
ORGANIZATION_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| COLLECTION_ID | NUMBER | Yes | Collection ID identifies the result collected in a single session. | |
| OCCURRENCE | NUMBER | Yes | Uniquely identifies a result row | |
| LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
| QA_LAST_UPDATE_DATE | DATE | Yes | Quality Standard Who column | |
| LAST_UPDATED_BY | NUMBER | Yes | Standard Who column | |
| QA_LAST_UPDATED_BY | NUMBER | Yes | Quality Standard Who column | |
| CREATION_DATE | DATE | Yes | Standard Who column | |
| QA_CREATION_DATE | DATE | Yes | Standard Who column | |
| CREATED_BY | NUMBER | Yes | Standard Who column | |
| QA_CREATED_BY | NUMBER | Yes | Standard Who column | |
| LAST_UPDATE_LOGIN | NUMBER | Standard Who column | ||
| REQUEST_ID | NUMBER | Concurrent request Who column | ||
| PROGRAM_APPLICATION_ID | NUMBER | Concurrent request Standard Who column | ||
| PROGRAM_ID | NUMBER | Concurrent request Standard Who column | ||
| PROGRAM_UPDATE_DATE | DATE | Concurrent request Standard Who column | ||
| TRANSACTION_NUMBER | NUMBER | Quality Transaction Identifier | ||
| TXN_HEADER_ID | NUMBER | Transaction header Identifier | ||
| ORGANIZATION_ID | NUMBER | Yes | Inventory Organization Identifier | |
| PLAN_ID | NUMBER | Yes | Collection plan Identifier | |
| SPEC_ID | NUMBER | Specification Identifier | ||
| TRANSACTION_ID | NUMBER | Parent transaction unique identifier | ||
| DEPARTMENT_ID | NUMBER | Department identifier | ||
| TO_DEPARTMENT_ID | NUMBER | To department Identifier | ||
| RESOURCE_ID | NUMBER | Resource Identifier | ||
| QUANTITY | NUMBER | Quantity is a hardcoded collection element in Oracle Quality | ||
| ITEM_ID | NUMBER | Item Identifier | ||
| UOM | VARCHAR2 | (3) | Unit of measure | |
| REVISION | VARCHAR2 | (3) | Item revision | |
| SUBINVENTORY | VARCHAR2 | (10) | Subinventory is a hardcoded collection element | |
| LOCATOR_ID | NUMBER | Locator identifier | ||
| LOT_NUMBER | VARCHAR2 | (80) | Lot Number | |
| SERIAL_NUMBER | VARCHAR2 | (30) | Serial Number | |
| COMP_ITEM_ID | NUMBER | Componenet Item identifier | ||
| COMP_UOM | VARCHAR2 | (3) | Component unit of measurement | |
| COMP_REVISION | VARCHAR2 | (3) | Component revision | |
| COMP_SUBINVENTORY | VARCHAR2 | (10) | Component subinventory | |
| COMP_LOCATOR_ID | NUMBER | Component locator identifier | ||
| COMP_LOT_NUMBER | VARCHAR2 | (80) | Component lot number | |
| COMP_SERIAL_NUMBER | VARCHAR2 | (30) | Component serial number | |
| WIP_ENTITY_ID | NUMBER | Wip job or schedule identifier | ||
| LINE_ID | NUMBER | Production line identifier | ||
| TO_OP_SEQ_NUM | NUMBER | To Operating Sequence Number | ||
| FROM_OP_SEQ_NUM | NUMBER | From Operating Sequence number | ||
| VENDOR_ID | NUMBER | Supplier Identifier | ||
| RECEIPT_NUM | VARCHAR2 | (30) | Receipt Number | |
| PO_HEADER_ID | NUMBER | Purchasing document Identifier | ||
| PO_RELEASE_ID | NUMBER | Purchasing release Identifier | ||
| PO_LINE_NUM | VARCHAR2 | (240) | Purchasing line number | |
| PO_SHIPMENT_NUM | NUMBER | Purchasing shipment number | ||
| CUSTOMER_ID | NUMBER | Customer Identifier | ||
| SO_HEADER_ID | NUMBER | Sales order Identifier | ||
| RMA_HEADER_ID | NUMBER | Return material authorization Identifier | ||
| PROJECT_ID | NUMBER | Project Identifier | ||
| TASK_ID | NUMBER | Task Identifier | ||
| STATUS | NUMBER | Result Status. Indicate whether this row contains valid or invalid results. A value of NULL or 2 indicates valid row whereas a value of 1 indicates invalid results row. | ||
| TRANSACTION_DATE | DATE | Transaction Date | ||
| CHARACTER1 | VARCHAR2 | (150) | Generic placeholder column. There are one hundred generic columns called character1 to character100 defined in QA_RESULTS. These columns are used to store use- defined collection elements. | |
| CHARACTER2 | VARCHAR2 | (150) | Generic placeholder column for user-defined collection element | |
| CHARACTER3 | VARCHAR2 | (150) | Generic placeholder column for user-defined collection element | |
| CHARACTER4 | VARCHAR2 | (150) | Generic placeholder column for user-defined collection element | |
| CHARACTER5 | VARCHAR2 | (150) | Generic placeholder column for user-defined collection element | |
| CHARACTER6 | VARCHAR2 | (150) | Generic placeholder column for user-defined collection element | |
| CHARACTER7 | VARCHAR2 | (150) | Generic placeholder column for user-defined collection element | |
| CHARACTER8 | VARCHAR2 | (150) | Generic placeholder column for user-defined collection element | |
| CHARACTER9 | VARCHAR2 | (150) | Generic placeholder column for user-defined collection element | |
| CHARACTER10 | VARCHAR2 | (150) | Generic placeholder column for user-defined collection element | |
| CHARACTER11 | VARCHAR2 | (150) | Generic placeholder column for user-defined collection element | |
| CHARACTER12 | VARCHAR2 | (150) | Generic placeholder column for user-defined collection element | |
| CHARACTER13 | VARCHAR2 | (150) | Generic placeholder column for user-defined collection element | |
| CHARACTER14 | VARCHAR2 | (150) | Generic placeholder column for user-defined collection element | |
| CHARACTER15 | VARCHAR2 | (150) | Generic placeholder column for user-defined collection element | |
| CHARACTER16 | VARCHAR2 | (150) | Generic placeholder column for user-defined collection element | |
| CHARACTER17 | VARCHAR2 | (150) | Generic placeholder column for user-defined collection element | |
| CHARACTER18 | VARCHAR2 | (150) | Generic placeholder column for user-defined collection element | |
| CHARACTER19 | VARCHAR2 | (150) | Generic placeholder column for user-defined collection element | |
| CHARACTER20 | VARCHAR2 | (150) | Generic placeholder column for user-defined collection element | |
| CHARACTER21 | VARCHAR2 | (150) | Generic placeholder column for user-defined collection element | |
| CHARACTER22 | VARCHAR2 | (150) | Generic placeholder column for user-defined collection element | |
| CHARACTER23 | VARCHAR2 | (150) | Generic placeholder column for user-defined collection element | |
| CHARACTER24 | VARCHAR2 | (150) | Generic placeholder column for user-defined collection element | |
| CHARACTER25 | VARCHAR2 | (150) | Generic placeholder column for user-defined collection element | |
| CHARACTER26 | VARCHAR2 | (150) | Generic placeholder column for user-defined collection element | |
| CHARACTER27 | VARCHAR2 | (150) | Generic placeholder column for user-defined collection element | |
| CHARACTER28 | VARCHAR2 | (150) | Generic placeholder column for user-defined collection element | |
| CHARACTER29 | VARCHAR2 | (150) | Generic placeholder column for user-defined collection element | |
| CHARACTER30 | VARCHAR2 | (150) | Generic placeholder column for user-defined collection element | |
| CHARACTER31 | VARCHAR2 | (150) | Generic placeholder column for user-defined collection element | |
| CHARACTER32 | VARCHAR2 | (150) | Generic placeholder column for user-defined collection element | |
| CHARACTER33 | VARCHAR2 | (150) | Generic placeholder column for user-defined collection element | |
| CHARACTER34 | VARCHAR2 | (150) | Generic placeholder column for user-defined collection element | |
| CHARACTER35 | VARCHAR2 | (150) | Generic placeholder column for user-defined collection element | |
| CHARACTER36 | VARCHAR2 | (150) | Generic placeholder column for user-defined collection element | |
| CHARACTER37 | VARCHAR2 | (150) | Generic placeholder column for user-defined collection element | |
| CHARACTER38 | VARCHAR2 | (150) | Generic placeholder column for user-defined collection element | |
| CHARACTER39 | VARCHAR2 | (150) | Generic placeholder column for user-defined collection element | |
| CHARACTER40 | VARCHAR2 | (150) | Generic placeholder column for user-defined collection element | |
| CHARACTER41 | VARCHAR2 | (150) | Generic placeholder column for user-defined collection element | |
| CHARACTER42 | VARCHAR2 | (150) | Generic placeholder column for user-defined collection element | |
| CHARACTER43 | VARCHAR2 | (150) | Generic placeholder column for user-defined collection element | |
| CHARACTER44 | VARCHAR2 | (150) | Generic placeholder column for user-defined collection element | |
| CHARACTER45 | VARCHAR2 | (150) | Generic placeholder column for user-defined collection element | |
| CHARACTER46 | VARCHAR2 | (150) | Generic placeholder column for user-defined collection element | |
| CHARACTER47 | VARCHAR2 | (150) | Generic placeholder column for user-defined collection element | |
| CHARACTER48 | VARCHAR2 | (150) | Generic placeholder column for user-defined collection element | |
| CHARACTER49 | VARCHAR2 | (150) | Generic placeholder column for user-defined collection element | |
| CHARACTER50 | VARCHAR2 | (150) | Generic placeholder column for user-defined collection element | |
| CHARACTER51 | VARCHAR2 | (150) | Generic placeholder column for user-defined collection element | |
| CHARACTER52 | VARCHAR2 | (150) | Generic placeholder column for user-defined collection element | |
| CHARACTER53 | VARCHAR2 | (150) | Generic placeholder column for user-defined collection element | |
| CHARACTER54 | VARCHAR2 | (150) | Generic placeholder column for user-defined collection element | |
| CHARACTER55 | VARCHAR2 | (150) | Generic placeholder column for user-defined collection element | |
| CHARACTER56 | VARCHAR2 | (150) | Generic placeholder column for user-defined collection element | |
| CHARACTER57 | VARCHAR2 | (150) | Generic placeholder column for user-defined collection element | |
| CHARACTER58 | VARCHAR2 | (150) | Generic placeholder column for user-defined collection element | |
| CHARACTER59 | VARCHAR2 | (150) | Generic placeholder column for user-defined collection element | |
| CHARACTER60 | VARCHAR2 | (150) | Generic placeholder column for user-defined collection element | |
| CHARACTER61 | VARCHAR2 | (150) | Generic placeholder column for user-defined collection element | |
| CHARACTER62 | VARCHAR2 | (150) | Generic placeholder column for user-defined collection element | |
| CHARACTER63 | VARCHAR2 | (150) | Generic placeholder column for user-defined collection element | |
| CHARACTER64 | VARCHAR2 | (150) | Generic placeholder column for user-defined collection element | |
| CHARACTER65 | VARCHAR2 | (150) | Generic placeholder column for user-defined collection element | |
| CHARACTER66 | VARCHAR2 | (150) | Generic placeholder column for user-defined collection element | |
| CHARACTER67 | VARCHAR2 | (150) | Generic placeholder column for user-defined collection element | |
| CHARACTER68 | VARCHAR2 | (150) | Generic placeholder column for user-defined collection element | |
| CHARACTER69 | VARCHAR2 | (150) | Generic placeholder column for user-defined collection element | |
| CHARACTER70 | VARCHAR2 | (150) | Generic placeholder column for user-defined collection element | |
| CHARACTER71 | VARCHAR2 | (150) | Generic placeholder column for user-defined collection element | |
| CHARACTER72 | VARCHAR2 | (150) | Generic placeholder column for user-defined collection element | |
| CHARACTER73 | VARCHAR2 | (150) | Generic placeholder column for user-defined collection element | |
| CHARACTER74 | VARCHAR2 | (150) | Generic placeholder column for user-defined collection element | |
| CHARACTER75 | VARCHAR2 | (150) | Generic placeholder column for user-defined collection element | |
| CHARACTER76 | VARCHAR2 | (150) | Generic placeholder column for user-defined collection element | |
| CHARACTER77 | VARCHAR2 | (150) | Generic placeholder column for user-defined collection element | |
| CHARACTER78 | VARCHAR2 | (150) | Generic placeholder column for user-defined collection element | |
| CHARACTER79 | VARCHAR2 | (150) | Generic placeholder column for user-defined collection element | |
| CHARACTER80 | VARCHAR2 | (150) | Generic placeholder column for user-defined collection element | |
| CHARACTER81 | VARCHAR2 | (150) | Generic placeholder column for user-defined collection element | |
| CHARACTER82 | VARCHAR2 | (150) | Generic placeholder column for user-defined collection element | |
| CHARACTER83 | VARCHAR2 | (150) | Generic placeholder column for user-defined collection element | |
| CHARACTER84 | VARCHAR2 | (150) | Generic placeholder column for user-defined collection element | |
| CHARACTER85 | VARCHAR2 | (150) | Generic placeholder column for user-defined collection element | |
| CHARACTER86 | VARCHAR2 | (150) | Generic placeholder column for user-defined collection element | |
| CHARACTER87 | VARCHAR2 | (150) | Generic placeholder column for user-defined collection element | |
| CHARACTER88 | VARCHAR2 | (150) | Generic placeholder column for user-defined collection element | |
| CHARACTER89 | VARCHAR2 | (150) | Generic placeholder column for user-defined collection element | |
| CHARACTER90 | VARCHAR2 | (150) | Generic placeholder column for user-defined collection element | |
| CHARACTER91 | VARCHAR2 | (150) | Generic placeholder column for user-defined collection element | |
| CHARACTER92 | VARCHAR2 | (150) | Generic placeholder column for user-defined collection element | |
| CHARACTER93 | VARCHAR2 | (150) | Generic placeholder column for user-defined collection element | |
| CHARACTER94 | VARCHAR2 | (150) | Generic placeholder column for user-defined collection element | |
| CHARACTER95 | VARCHAR2 | (150) | Generic placeholder column for user-defined collection element | |
| CHARACTER96 | VARCHAR2 | (150) | Generic placeholder column for user-defined collection element | |
| CHARACTER97 | VARCHAR2 | (150) | Generic placeholder column for user-defined collection element | |
| CHARACTER98 | VARCHAR2 | (150) | Generic placeholder column for user-defined collection element | |
| CHARACTER99 | VARCHAR2 | (150) | Generic placeholder column for user-defined collection element | |
| CHARACTER100 | VARCHAR2 | (150) | Generic placeholder column for user-defined collection element | |
| LPN_ID | NUMBER | License Plate Number Identifier | ||
| CONTRACT_ID | NUMBER | Contract Identifier | ||
| CONTRACT_LINE_ID | NUMBER | Contract Line Identifier | ||
| DELIVERABLE_ID | NUMBER | Deliverable Identifier | ||
| ASSET_GROUP_ID | NUMBER | Used to store ID of an Asset Group | ||
| ASSET_ACTIVITY_ID | NUMBER | Use to store ID of an Asset Activity | ||
| ASSET_NUMBER | VARCHAR2 | (30) | Use to store an Asset Number (same as Serial Number) | |
| WORK_ORDER_ID | NUMBER | Use to store a work order ID for asset management | ||
| SEQUENCE1 | VARCHAR2 | (50) | Generic column to store sequence datatype data | |
| SEQUENCE2 | VARCHAR2 | (50) | Generic column to store sequence datatype data | |
| SEQUENCE3 | VARCHAR2 | (50) | Generic column to store sequence datatype data | |
| SEQUENCE4 | VARCHAR2 | (50) | Generic column to store sequence datatype data | |
| SEQUENCE5 | VARCHAR2 | (50) | Generic column to store sequence datatype data | |
| SEQUENCE6 | VARCHAR2 | (50) | Generic column to store sequence datatype data | |
| SEQUENCE7 | VARCHAR2 | (50) | Generic column to store sequence datatype data | |
| SEQUENCE8 | VARCHAR2 | (50) | Generic column to store sequence datatype data | |
| SEQUENCE9 | VARCHAR2 | (50) | Generic column to store sequence datatype data | |
| SEQUENCE10 | VARCHAR2 | (50) | Generic column to store sequence datatype data | |
| SEQUENCE11 | VARCHAR2 | (50) | Generic column to store sequence datatype data | |
| SEQUENCE12 | VARCHAR2 | (50) | Generic column to store sequence datatype data | |
| SEQUENCE13 | VARCHAR2 | (50) | Generic column to store sequence datatype data | |
| SEQUENCE14 | VARCHAR2 | (50) | Generic column to store sequence datatype data | |
| SEQUENCE15 | VARCHAR2 | (50) | Generic column to store sequence datatype data | |
| COMMENT1 | VARCHAR2 | (2000) | Generic column to store comment datatype data | |
| COMMENT2 | VARCHAR2 | (2000) | Generic column to store comment datatype data | |
| COMMENT3 | VARCHAR2 | (2000) | Generic column to store comment datatype data | |
| COMMENT4 | VARCHAR2 | (2000) | Generic column to store comment datatype data | |
| COMMENT5 | VARCHAR2 | (2000) | Generic column to store comment datatype data | |
| PARTY_ID | NUMBER | party ID | ||
| CSI_INSTANCE_ID | NUMBER | Installed base item instance ID. Oracle Internal use only - reserved for future use | ||
| COUNTER_ID | NUMBER | Service Counter ID. Oracle Internal use only - reserved for future use | ||
| COUNTER_READING_ID | NUMBER | Service counter readings ID. Oracle Internal use only - reserved for future use | ||
| AHL_MR_ID | NUMBER | AHL maintenance requirement header ID. Oracle Internal use only - reserved for future use | ||
| CS_INCIDENT_ID | NUMBER | Service request ID. Oracle Internal use only - reserved for future use | ||
| WIP_REWORK_ID | NUMBER | WIP rework job ID. Oracle Internal use only - reserved for future use | ||
| DISPOSITION_SOURCE | VARCHAR2 | (150) | Disposition source. Oracle Internal use only - reserved for future use | |
| DISPOSITION | VARCHAR2 | (150) | Disposition. Oracle Internal use only - reserved for future use | |
| DISPOSITION_ACTION | VARCHAR2 | (150) | Disposition action. Oracle Internal use only - reserved for future use | |
| DISPOSITION_STATUS | VARCHAR2 | (150) | Disposition status. Oracle Internal use only - reserved for future use | |
| MTI_TRANSACTION_HEADER_ID | NUMBER | Inventory transaction header ID. Oracle Internal use only - reserved for future use | ||
| MTI_TRANSACTION_INTERFACE_ID | NUMBER | nventory transaction interface ID. Oracle Internal use only - reserved for future use | ||
| MMT_TRANSACTION_ID | NUMBER | Material transaction ID. Oracle Internal use only - reserved for future use | ||
| WJSI_GROUP_ID | NUMBER | wip job group ID. Oracle Internal use only - reserved for future use | ||
| WMTI_GROUP_ID | NUMBER | Material transaction group ID. Oracle Internal use only - reserved for future use | ||
| WMT_TRANSACTION_ID | NUMBER | Material transaction ID. Oracle Internal use only - reserved for future use | ||
| RTI_INTERFACE_TRANSACTION_ID | NUMBER | receiving transaction interface ID. Oracle Internal use only - reserved for future use | ||
| MAINTENANCE_OP_SEQ | NUMBER | Maintenance Operation Sequence. Oracle Internal use only - reserved for future use | ||
| NONCONFORMANCE_SOURCE | VARCHAR2 | (150) | Nonconformance Source - Oracle Internal Use Only | |
| NONCONFORM_SEVERITY | VARCHAR2 | (150) | Severity of Nonconformance | |
| NONCONFORM_PRIORITY | VARCHAR2 | (150) | Priority of Nonconformance | |
| NONCONFORMANCE_TYPE | VARCHAR2 | (150) | Nonconformance Type | |
| NONCONFORMANCE_CODE | VARCHAR2 | (150) | Nonconformance Code | |
| DATE_OPENED | DATE | Date Opened | ||
| DATE_CLOSED | DATE | Date Closed | ||
| DAYS_TO_CLOSE | NUMBER | Days to close | ||
| TO_SUBINVENTORY | VARCHAR2 | (150) | To Subinventory | |
| TO_LOCATOR_ID | NUMBER | To Locator Id | ||
| BILL_REFERENCE_ID | NUMBER | Bill Reference Id | ||
| ROUTING_REFERENCE_ID | NUMBER | Routing Reference Id | ||
| CONCURRENT_REQUEST_ID | NUMBER | Concurrent Request Id | ||
| LOT_STATUS_ID | NUMBER | Lot Status Id | ||
| SERIAL_STATUS_ID | NUMBER | Serial Status Id | ||
| NONCONFORMANCE_STATUS | VARCHAR2 | (150) | Nonconformance Status | |
| RCV_TRANSACTION_ID | NUMBER | Receiving Transaction Id | ||
| REQUEST_STATUS | VARCHAR2 | (150) | Request Status | |
| REQUEST_SOURCE | VARCHAR2 | (150) | Request Source | |
| REQUEST_PRIORITY | VARCHAR2 | (150) | Request Priority | |
| REQUEST_SEVERITY | VARCHAR2 | (150) | Request Severity | |
| ECO_NAME | VARCHAR2 | (150) | ECO Name | |
| FOLLOWUP_ACTIVITY_ID | NUMBER | Follwup Activity ID used in EAM | ||
| XFR_LPN_ID | NUMBER | transfer-to license plate number used in receiving/wms merge | ||
| REPAIR_LINE_ID | NUMBER | Repair Line ID. Identifier for Depot Repair Order. | ||
| JTF_TASK_ID | NUMBER | JTF Task ID. Identifier for Task used by service product family. | ||
| ASSET_INSTANCE_ID | NUMBER | Asset Instance ID. This Stores Install Base Item Instance ID for EAM | ||
| PROCESS_BATCH_ID | NUMBER | Process Batch ID. Identifier for Batch for Process | ||
| PROCESS_BATCHSTEP_ID | NUMBER | Process Batch Step ID. Identifier for Batch Step for Process. | ||
| PROCESS_OPERATION_ID | NUMBER | Process Operation ID. Identifier for Operation for Process. | ||
| PROCESS_ACTIVITY_ID | NUMBER | Process Activity ID. Identifier for Activity for Process. | ||
| PROCESS_RESOURCE_ID | NUMBER | Process Resource ID. Identifier for Resource for Process. | ||
| PROCESS_PARAMETER_ID | NUMBER | Process Parameter ID. Identifier for Parameter for Process. |
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 does not reference any database object
QA.QA_RESULTS is referenced by following:
QA
QA_RESULTS#
|
|
|
|