[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | QA_RESULTS_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  QA.QA_RESULTS_V
|
| Subobject Name: | |
| Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ROW_ID | ROWID | (10) | Identifies row in table QA_RESULTS. | |
| COLLECTION_ID | NUMBER | Yes | Collection ID identifies the result collected in a single session. | |
| OCCURRENCE | NUMBER | Yes | Uniquely identifies results rows. | |
| 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 | |
| QA_LAST_UPDATED_BY_NAME | VARCHAR2 | (100) | Yes | Quality standard who column |
| CREATION_DATE | DATE | Yes | Standard who column | |
| QA_CREATION_DATE | DATE | Yes | Quality standard who column | |
| CREATED_BY | NUMBER | Yes | Standard who column | |
| QA_CREATED_BY | NUMBER | Yes | Quality standard who column | |
| QA_CREATED_BY_NAME | VARCHAR2 | (100) | Yes | Quality standard who column |
| LAST_UPDATE_LOGIN | NUMBER | Standard who column | ||
| REQUEST_ID | NUMBER | Standard concurrent request whio columns | ||
| PROGRAM_APPLICATION_ID | NUMBER | Standard concurrent request whio columns | ||
| PROGRAM_ID | NUMBER | Standard concurrent request whio columns | ||
| PROGRAM_UPDATE_DATE | DATE | Date this row was processed using collection import | ||
| TRANSACTION_NUMBER | NUMBER | Quality parent 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 | ||
| NAME | VARCHAR2 | (30) | Yes | Collection plan name |
| DESCRIPTION | VARCHAR2 | (150) | Collection plan description | |
| PLAN_TYPE | VARCHAR2 | (80) | Yes | Collecion plan type |
| TRANSACTION_ID | NUMBER | Parent transaction identifier | ||
| DEPARTMENT_ID | NUMBER | Department identifier | ||
| DEPARTMENT | VARCHAR2 | (10) | Department code | |
| TO_DEPARTMENT_ID | NUMBER | To department identifier | ||
| TO_DEPARTMENT | VARCHAR2 | (10) | To department code | |
| RESOURCE_ID | NUMBER | Bills of material resource identifier | ||
| RESOURCE_CODE | VARCHAR2 | (10) | Bills of material resource code | |
| QUANTITY | NUMBER | Quantity is a hardcoded collection element | ||
| ITEM_ID | NUMBER | Inventory item identifier | ||
| UOM | VARCHAR2 | (3) | Unit of measurement | |
| REVISION | VARCHAR2 | (3) | Item revision | |
| SUBINVENTORY | VARCHAR2 | (10) | Hardcoded collection element | |
| SUB_LOC_TYPE | NUMBER | Locator type | ||
| LOCATOR_ID | NUMBER | Locator identifier | ||
| LOT_NUMBER | VARCHAR2 | (80) | Lot number | |
| SERIAL_NUMBER | VARCHAR2 | (30) | serial number | |
| COMP_ITEM_ID | NUMBER | Component item identifier | ||
| COMP_UOM | VARCHAR2 | (3) | Component unit of measurement | |
| COMP_REVISION | VARCHAR2 | (3) | Component Revision | |
| COMP_SUBINVENTORY | VARCHAR2 | (10) | Component subinventory | |
| COMP_SUB_LOC_TYPE | NUMBER | Component sub locator type | ||
| 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 | ||
| JOB_NAME | VARCHAR2 | (240) | Wip Job name | |
| LINE_ID | NUMBER | Production line identifier | ||
| PRODUCTION_LINE | VARCHAR2 | (10) | Production line code | |
| TO_OP_SEQ_NUM | NUMBER | To Operating sequence number | ||
| FROM_OP_SEQ_NUM | NUMBER | From operating sequence number | ||
| VENDOR_ID | NUMBER | Vendor identifier | ||
| VENDOR_NAME | VARCHAR2 | (360) | Vendor name | |
| RECEIPT_NUM | VARCHAR2 | (30) | Receipt number | |
| PO_HEADER_ID | NUMBER | Purchasing document identifier | ||
| PO_RELEASE_ID | NUMBER | Purchasing release identifier | ||
| PO_NUMBER | VARCHAR2 | (20) | Purchasing document number | |
| PO_LINE_NUM | NUMBER | Purchasing line number | ||
| PO_SHIPMENT_NUM | NUMBER | Purchasing shipment number | ||
| PO_RELEASE_NUM | NUMBER | Purchasing release number | ||
| PO_TYPE_LOOKUP | VARCHAR2 | (25) | Purchasing lookup codes | |
| PROJECT_ID | NUMBER | Project identifier | ||
| PROJECT_NUMBER | VARCHAR2 | (4000) | Project number | |
| TASK_ID | NUMBER | Task identifier | ||
| TASK_NUMBER | VARCHAR2 | (25) | Task number | |
| CUSTOMER_ID | NUMBER | Customer identifier | ||
| CUSTOMER_NAME | VARCHAR2 | (360) | Customer name | |
| SO_HEADER_ID | NUMBER | Sales order identifier | ||
| SALES_ORDER | VARCHAR2 | (40) | Sales order number | |
| RMA_HEADER_ID | NUMBER | Returm material authorization identifier | ||
| RMA_NUMBER | NUMBER | Return material authorization number | ||
| STATUS | NUMBER | Result status | ||
| TRANSACTION_DATE | DATE | Date stamp of a transaction | ||
| LPN_ID | NUMBER | License Plate Number Identifier | ||
| LICENSE_PLATE_NUMBER | VARCHAR2 | (30) | License Plate Number | |
| CONTRACT_ID | NUMBER | Contract Identifier | ||
| CONTRACT_NUMBER | VARCHAR2 | (4000) | Contract Number | |
| CONTRACT_LINE_ID | NUMBER | Contract Line Identifier | ||
| CONTRACT_LINE_NUMBER | VARCHAR2 | (4000) | Contract Line Number | |
| DELIVERABLE_ID | NUMBER | Deliverable Identifier | ||
| DELIVERABLE_NUMBER | VARCHAR2 | (4000) | Deliverable Number | |
| CHARACTER1 | VARCHAR2 | (150) | Generic collection element column | |
| CHARACTER2 | VARCHAR2 | (150) | Generic collection element column | |
| CHARACTER3 | VARCHAR2 | (150) | Generic collection element column | |
| CHARACTER4 | VARCHAR2 | (150) | Generic collection element column | |
| CHARACTER5 | VARCHAR2 | (150) | Generic collection element column | |
| CHARACTER6 | VARCHAR2 | (150) | Generic collection element column | |
| CHARACTER7 | VARCHAR2 | (150) | Generic collection element column | |
| CHARACTER8 | VARCHAR2 | (150) | Generic collection element column | |
| CHARACTER9 | VARCHAR2 | (150) | Generic collection element column | |
| CHARACTER10 | VARCHAR2 | (150) | Generic collection element column | |
| CHARACTER11 | VARCHAR2 | (150) | Generic collection element column | |
| CHARACTER12 | VARCHAR2 | (150) | Generic collection element column | |
| CHARACTER13 | VARCHAR2 | (150) | Generic collection element column | |
| CHARACTER14 | VARCHAR2 | (150) | Generic collection element column | |
| CHARACTER15 | VARCHAR2 | (150) | Generic collection element column | |
| CHARACTER16 | VARCHAR2 | (150) | Generic collection element column | |
| CHARACTER17 | VARCHAR2 | (150) | Generic collection element column | |
| CHARACTER18 | VARCHAR2 | (150) | Generic collection element column | |
| CHARACTER19 | VARCHAR2 | (150) | Generic collection element column | |
| CHARACTER20 | VARCHAR2 | (150) | Generic collection element column | |
| CHARACTER21 | VARCHAR2 | (150) | Generic collection element column | |
| CHARACTER22 | VARCHAR2 | (150) | Generic collection element column | |
| CHARACTER23 | VARCHAR2 | (150) | Generic collection element column | |
| CHARACTER24 | VARCHAR2 | (150) | Generic collection element column | |
| CHARACTER25 | VARCHAR2 | (150) | Generic collection element column | |
| CHARACTER26 | VARCHAR2 | (150) | Generic collection element column | |
| CHARACTER27 | VARCHAR2 | (150) | Generic collection element column | |
| CHARACTER28 | VARCHAR2 | (150) | Generic collection element column | |
| CHARACTER29 | VARCHAR2 | (150) | Generic collection element column | |
| CHARACTER30 | VARCHAR2 | (150) | Generic collection element column | |
| CHARACTER31 | VARCHAR2 | (150) | Generic collection element column | |
| CHARACTER32 | VARCHAR2 | (150) | Generic collection element column | |
| CHARACTER33 | VARCHAR2 | (150) | Generic collection element column | |
| CHARACTER34 | VARCHAR2 | (150) | Generic collection element column | |
| CHARACTER35 | VARCHAR2 | (150) | Generic collection element column | |
| CHARACTER36 | VARCHAR2 | (150) | Generic collection element column | |
| CHARACTER37 | VARCHAR2 | (150) | Generic collection element column | |
| CHARACTER38 | VARCHAR2 | (150) | Generic collection element column | |
| CHARACTER39 | VARCHAR2 | (150) | Generic collection element column | |
| CHARACTER40 | VARCHAR2 | (150) | Generic collection element column | |
| CHARACTER41 | VARCHAR2 | (150) | Generic collection element column | |
| CHARACTER42 | VARCHAR2 | (150) | Generic collection element column | |
| CHARACTER43 | VARCHAR2 | (150) | Generic collection element column | |
| CHARACTER44 | VARCHAR2 | (150) | Generic collection element column | |
| CHARACTER45 | VARCHAR2 | (150) | Generic collection element column | |
| CHARACTER46 | VARCHAR2 | (150) | Generic collection element column | |
| CHARACTER47 | VARCHAR2 | (150) | Generic collection element column | |
| CHARACTER48 | VARCHAR2 | (150) | Generic collection element column | |
| CHARACTER49 | VARCHAR2 | (150) | Generic collection element column | |
| CHARACTER50 | VARCHAR2 | (150) | Generic collection element column | |
| CHARACTER51 | VARCHAR2 | (150) | Generic collection element column | |
| CHARACTER52 | VARCHAR2 | (150) | Generic collection element column | |
| CHARACTER53 | VARCHAR2 | (150) | Generic collection element column | |
| CHARACTER54 | VARCHAR2 | (150) | Generic collection element column | |
| CHARACTER55 | VARCHAR2 | (150) | Generic collection element column | |
| CHARACTER56 | VARCHAR2 | (150) | Generic collection element column | |
| CHARACTER57 | VARCHAR2 | (150) | Generic collection element column | |
| CHARACTER58 | VARCHAR2 | (150) | Generic collection element column | |
| CHARACTER59 | VARCHAR2 | (150) | Generic collection element column | |
| CHARACTER60 | VARCHAR2 | (150) | Generic collection element column | |
| CHARACTER61 | VARCHAR2 | (150) | Generic collection element column | |
| CHARACTER62 | VARCHAR2 | (150) | Generic collection element column | |
| CHARACTER63 | VARCHAR2 | (150) | Generic collection element column | |
| CHARACTER64 | VARCHAR2 | (150) | Generic collection element column | |
| CHARACTER65 | VARCHAR2 | (150) | Generic collection element column | |
| CHARACTER66 | VARCHAR2 | (150) | Generic collection element column | |
| CHARACTER67 | VARCHAR2 | (150) | Generic collection element column | |
| CHARACTER68 | VARCHAR2 | (150) | Generic collection element column | |
| CHARACTER69 | VARCHAR2 | (150) | Generic collection element column | |
| CHARACTER70 | VARCHAR2 | (150) | Generic collection element column | |
| CHARACTER71 | VARCHAR2 | (150) | Generic collection element column | |
| CHARACTER72 | VARCHAR2 | (150) | Generic collection element column | |
| CHARACTER73 | VARCHAR2 | (150) | Generic collection element column | |
| CHARACTER74 | VARCHAR2 | (150) | Generic collection element column | |
| CHARACTER75 | VARCHAR2 | (150) | Generic collection element column | |
| CHARACTER76 | VARCHAR2 | (150) | Generic collection element column | |
| CHARACTER77 | VARCHAR2 | (150) | Generic collection element column | |
| CHARACTER78 | VARCHAR2 | (150) | Generic collection element column | |
| CHARACTER79 | VARCHAR2 | (150) | Generic collection element column | |
| CHARACTER80 | VARCHAR2 | (150) | Generic collection element column | |
| CHARACTER81 | VARCHAR2 | (150) | Generic collection element column | |
| CHARACTER82 | VARCHAR2 | (150) | Generic collection element column | |
| CHARACTER83 | VARCHAR2 | (150) | Generic collection element column | |
| CHARACTER84 | VARCHAR2 | (150) | Generic collection element column | |
| CHARACTER85 | VARCHAR2 | (150) | Generic collection element column | |
| CHARACTER86 | VARCHAR2 | (150) | Generic collection element column | |
| CHARACTER87 | VARCHAR2 | (150) | Generic collection element column | |
| CHARACTER88 | VARCHAR2 | (150) | Generic collection element column | |
| CHARACTER89 | VARCHAR2 | (150) | Generic collection element column | |
| CHARACTER90 | VARCHAR2 | (150) | Generic collection element column | |
| CHARACTER91 | VARCHAR2 | (150) | Generic collection element column | |
| CHARACTER92 | VARCHAR2 | (150) | Generic collection element column | |
| CHARACTER93 | VARCHAR2 | (150) | Generic collection element column | |
| CHARACTER94 | VARCHAR2 | (150) | Generic collection element column | |
| CHARACTER95 | VARCHAR2 | (150) | Generic collection element column | |
| CHARACTER96 | VARCHAR2 | (150) | Generic collection element column | |
| CHARACTER97 | VARCHAR2 | (150) | Generic collection element column | |
| CHARACTER98 | VARCHAR2 | (150) | Generic collection element column | |
| CHARACTER99 | VARCHAR2 | (150) | Generic collection element column | |
| CHARACTER100 | VARCHAR2 | (150) | Generic collection element column | |
| ASSET_GROUP_ID | NUMBER | asset group ID | ||
| ASSET_GROUP | VARCHAR2 | (4000) | asset group | |
| ASSET_NUMBER | VARCHAR2 | (30) | asset number | |
| ASSET_ACTIVITY_ID | NUMBER | asset activity ID | ||
| ASSET_ACTIVITY | VARCHAR2 | (4000) | asset activity | |
| WORK_ORDER_ID | NUMBER | work order ID | ||
| WORK_ORDER | VARCHAR2 | (240) | work order | |
| SEQUENCE1 | VARCHAR2 | (50) | Generic column to store sequence datatype value | |
| SEQUENCE2 | VARCHAR2 | (50) | Generic column to store sequence datatype value | |
| SEQUENCE3 | VARCHAR2 | (50) | Generic column to store sequence datatype value | |
| SEQUENCE4 | VARCHAR2 | (50) | Generic column to store sequence datatype value | |
| SEQUENCE5 | VARCHAR2 | (50) | Generic column to store sequence datatype value | |
| SEQUENCE6 | VARCHAR2 | (50) | Generic column to store sequence datatype value | |
| SEQUENCE7 | VARCHAR2 | (50) | Generic column to store sequence datatype value | |
| SEQUENCE8 | VARCHAR2 | (50) | Generic column to store sequence datatype value | |
| SEQUENCE9 | VARCHAR2 | (50) | Generic column to store sequence datatype value | |
| SEQUENCE10 | VARCHAR2 | (50) | Generic column to store sequence datatype value | |
| SEQUENCE11 | VARCHAR2 | (50) | Generic column to store sequence datatype value | |
| SEQUENCE12 | VARCHAR2 | (50) | Generic column to store sequence datatype value | |
| SEQUENCE13 | VARCHAR2 | (50) | Generic column to store sequence datatype value | |
| SEQUENCE14 | VARCHAR2 | (50) | Generic column to store sequence datatype value | |
| SEQUENCE15 | VARCHAR2 | (50) | Generic column to store sequence datatype value | |
| COMMENT1 | VARCHAR2 | (2000) | Generic column to store comment datatype value | |
| COMMENT2 | VARCHAR2 | (2000) | Generic column to store comment datatype value | |
| COMMENT3 | VARCHAR2 | (2000) | Generic column to store comment datatype value | |
| COMMENT4 | VARCHAR2 | (2000) | Generic column to store comment datatype value | |
| COMMENT5 | VARCHAR2 | (2000) | Generic column to store comment datatype value | |
| PARTY_ID | NUMBER | party ID | ||
| PARTY_NAME | VARCHAR2 | (360) | party name | |
| CSI_INSTANCE_ID | NUMBER | Installed base item instance ID. Oracle Internal use only - reserved for future use | ||
| ITEM_INSTANCE | VARCHAR2 | (30) | Installed Base item instance number. Oracle Internal use only - reserved for future use | |
| COUNTER_ID | NUMBER | Service Counter ID. Oracle Internal use only - reserved for future use | ||
| COUNTER_NAME | VARCHAR2 | (80) | Service counter name. Oracle Internal use only - reserved for future use | |
| COUNTER_READING_ID | NUMBER | Service counter readings ID. Oracle Internal use only - reserved for future use | ||
| COUNTER_READING | NUMBER | Service counter reading. 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 | ||
| MAINTENANCE_REQUIREMENT | VARCHAR2 | (80) | AHL maintenance requirement. Oracle Internal use only - reserved for future use | |
| CS_INCIDENT_ID | NUMBER | Service request ID. Oracle Internal use only - reserved for future use | ||
| SERVICE_REQUEST | VARCHAR2 | (64) | Service request number. Oracle Internal use only - reserved for future use | |
| WIP_REWORK_ID | NUMBER | WIP rework job ID. Oracle Internal use only - reserved for future use | ||
| REWORK_JOB | VARCHAR2 | (240) | WIP rework job. 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 | |
| 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_SUB_LOC_TYPE | NUMBER | To Sub Locator Type | ||
| 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 | ||
| LOT_STATUS | VARCHAR2 | (80) | Lot Status | |
| SERIAL_STATUS_ID | NUMBER | Serial Status Id | ||
| SERIAL_STATUS | VARCHAR2 | (80) | Serial Status | |
| 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 used in EAM | ||
| FOLLOWUP_ACTIVITY | VARCHAR2 | (4000) | Followup activity | |
| XFR_LPN_ID | NUMBER | transfer-to license plate number used in receiving/wms merge | ||
| XFR_LICENSE_PLATE_NUMBER | VARCHAR2 | (30) | transfer-to license plate number used in receiving/wms merge | |
| REPAIR_LINE_ID | NUMBER | Repair Line ID. Identifier for Depot Repair Order. | ||
| REPAIR_ORDER_NUMBER | VARCHAR2 | (30) | Repair Order Number. Visual Identifier for Depot Repair Order. | |
| JTF_TASK_ID | NUMBER | JTF Task ID. Identifier for Task used by service product family. | ||
| JTF_TASK_NUMBER | VARCHAR2 | (30) | JTF Task Number. Visual Identifier for Task used by service product family. | |
| ASSET_INSTANCE_ID | NUMBER | Asset Instance ID. This Stores Install Base Item Instance ID for EAM | ||
| ASSET_INSTANCE_NUMBER | VARCHAR2 | (30) | Asset Instance Number. Visual Identifier for Install Base Item Instance for EAM | |
| PROCESS_BATCH_ID | NUMBER | Process Batch ID. Identifier for Batch for Process | ||
| PROCESS_BATCH_NUM | VARCHAR2 | (32) | Process Batch Number. Visual Identifier for Batch for Process | |
| PROCESS_BATCHSTEP_ID | NUMBER | Process Batch Step ID. Identifier for Batch Step for Process. | ||
| PROCESS_BATCHSTEP_NUM | NUMBER | (10) | Process Batch Step Number. Visual Identifier for Batch Step for Process. | |
| PROCESS_OPERATION_ID | NUMBER | Process Operation ID. Identifier for Operation for Process. | ||
| PROCESS_OPERATION | VARCHAR2 | (57) | Process Operation. Visual Identifier for Operation for Process. | |
| PROCESS_ACTIVITY_ID | NUMBER | Process Activity ID. Identifier for Activity for Process. | ||
| PROCESS_ACTIVITY | VARCHAR2 | (16) | Process Activity. Visual Identifier for Activity for Process. | |
| PROCESS_RESOURCE_ID | NUMBER | Process Resource ID. Identifier for Resource for Process. | ||
| PROCESS_RESOURCE | VARCHAR2 | (16) | Process Resource. Visual Identifier for Resource for Process. | |
| PROCESS_PARAMETER_ID | NUMBER | Process Parameter ID. Identifier for Parameter for Process. | ||
| PROCESS_PARAMETER | VARCHAR2 | (40) | Process Parameter. Visual Identifier for Parameter for Process. | |
| COMP_ITEM | VARCHAR2 | (4000) |
Cut, paste (and edit) the following text to query this object:
SELECT 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
, 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
, UOM
, REVISION
, SUBINVENTORY
, SUB_LOC_TYPE
, LOCATOR_ID
, 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
, 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
, COMP_ITEM
FROM APPS.QA_RESULTS_V;
APPS
AP_SUPPLIERS
BOM_DEPARTMENTS
BOM_RESOURCES
CSD_REPAIRS
CSI_COUNTERS_TL
CSI_COUNTER_READINGS
CSI_ITEM_INSTANCES
CS_INCIDENTS_ALL_B
FND_LOOKUP_VALUES
FND_USER_VIEW
GMD_OPERATIONS_B
GME_BATCH_HEADER
GME_BATCH_STEPS
GME_BATCH_STEP_ACTIVITIES
GME_BATCH_STEP_RESOURCES
GMP_PROCESS_PARAMETERS_B
HZ_CUST_ACCOUNTS
HZ_PARTIES
JTF_TASKS_B
MTL_MATERIAL_STATUSES_B
MTL_MATERIAL_STATUSES_TL
MTL_SALES_ORDERS
MTL_SECONDARY_INVENTORIES
OE_ORDER_HEADERS_ALL
PA_TASKS
PO_HEADERS_ALL
PO_RELEASES_ALL
QA_AHL_MR
QA_CSI_ITEM_INSTANCES
QA_FLEX_UTIL
- show dependent code
QA_PLANS
QA_RESULTS
WIP_ENTITIES
WIP_LINES
WMS_LICENSE_PLATE_NUMBERS
APPS
GMO_VALIDATE_BATCH_GRP
- show dependent code
|
|
|
|