DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.QA_RESULTS_VAL_V

Object Details
Object Name: QA_RESULTS_VAL_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewQA.QA_RESULTS_VAL_V
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Identifies row in table QA_RESULTS.
COLLECTION_ID NUMBER
Yes Collection ID identifies the results 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
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
LAST_UPDATE_LOGIN NUMBER

Standard who column
TRANSACTION_NUMBER NUMBER

Quality parent transaction identifier
TXN_HEADER_ID NUMBER

Transaction header identifier
ORGANIZATION_ID NUMBER
Yes Organization identifier
PLAN_ID NUMBER
Yes Plan identifier
SPEC_ID NUMBER

Specification identifier
TRANSACTION_ID NUMBER

Transaction identifer
DEPARTMENT_ID NUMBER

Department identifier
RESOURCE_ID NUMBER

Resource identifier
QUANTITY NUMBER

Quantity is a hardcoded collection element
ITEM_ID NUMBER

Item identifier
UOM VARCHAR2 (3)
Unit of measurement
REVISION VARCHAR2 (3)
Item revision
SUBINVENTORY VARCHAR2 (10)
Subinventory is stored as hardcoded collection element
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_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 entity identifier
LINE_ID NUMBER

Line identifier
TO_OP_SEQ_NUM NUMBER

To operating sequence number
FROM_OP_SEQ_NUM NUMBER

From operating sequence number
VENDOR_ID NUMBER

Vendor identifier
RECEIPT_NUM VARCHAR2 (30)
Receipt number
PO_HEADER_ID NUMBER

Purchasing document identifier
PO_LINE_NUM NUMBER

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
LPN_ID NUMBER

License Plate Number Identifier
CONTRACT_ID NUMBER

Contract Identifier
CONTRACT_LINE_ID NUMBER

Contract Line Identifier
DELIVERABLE_ID NUMBER

Deliverable Identifier
CHARACTER1 VARCHAR2 (150)
Generic collection element placeholder column
CHARACTER2 VARCHAR2 (150)
Generic collection element placeholder column
CHARACTER3 VARCHAR2 (150)
Generic collection element placeholder column
CHARACTER4 VARCHAR2 (150)
Generic collection element placeholder column
CHARACTER5 VARCHAR2 (150)
Generic collection element placeholder column
CHARACTER6 VARCHAR2 (150)
Generic collection element placeholder column
CHARACTER7 VARCHAR2 (150)
Generic collection element placeholder column
CHARACTER8 VARCHAR2 (150)
Generic collection element placeholder column
CHARACTER9 VARCHAR2 (150)
Generic collection element placeholder column
CHARACTER10 VARCHAR2 (150)
Generic collection element placeholder column
CHARACTER11 VARCHAR2 (150)
Generic collection element placeholder column
CHARACTER12 VARCHAR2 (150)
Generic collection element placeholder column
CHARACTER13 VARCHAR2 (150)
Generic collection element placeholder column
CHARACTER14 VARCHAR2 (150)
Generic collection element placeholder column
CHARACTER15 VARCHAR2 (150)
Generic collection element placeholder column
CHARACTER16 VARCHAR2 (150)
Generic collection element placeholder column
CHARACTER17 VARCHAR2 (150)
Generic collection element placeholder column
CHARACTER18 VARCHAR2 (150)
Generic collection element placeholder column
CHARACTER19 VARCHAR2 (150)
Generic collection element placeholder column
CHARACTER20 VARCHAR2 (150)
Generic collection element placeholder column
CHARACTER21 VARCHAR2 (150)
Generic collection element placeholder column
CHARACTER22 VARCHAR2 (150)
Generic collection element placeholder column
CHARACTER23 VARCHAR2 (150)
Generic collection element placeholder column
CHARACTER24 VARCHAR2 (150)
Generic collection element placeholder column
CHARACTER25 VARCHAR2 (150)
Generic collection element placeholder column
CHARACTER26 VARCHAR2 (150)
Generic collection element placeholder column
CHARACTER27 VARCHAR2 (150)
Generic collection element placeholder column
CHARACTER28 VARCHAR2 (150)
Generic collection element placeholder column
CHARACTER29 VARCHAR2 (150)
Generic collection element placeholder column
CHARACTER30 VARCHAR2 (150)
Generic collection element placeholder column
CHARACTER31 VARCHAR2 (150)
Generic collection element placeholder column
CHARACTER32 VARCHAR2 (150)
Generic collection element placeholder column
CHARACTER33 VARCHAR2 (150)
Generic collection element placeholder column
CHARACTER34 VARCHAR2 (150)
Generic collection element placeholder column
CHARACTER35 VARCHAR2 (150)
Generic collection element placeholder column
CHARACTER36 VARCHAR2 (150)
Generic collection element placeholder column
CHARACTER37 VARCHAR2 (150)
Generic collection element placeholder column
CHARACTER38 VARCHAR2 (150)
Generic collection element placeholder column
CHARACTER39 VARCHAR2 (150)
Generic collection element placeholder column
CHARACTER40 VARCHAR2 (150)
Generic collection element placeholder column
REQUEST_ID NUMBER

Standard concurrent request who column
PROGRAM_APPLICATION_ID NUMBER

Standard concurrent request who column
PROGRAM_ID NUMBER

Standard concurrent request who column
PROGRAM_UPDATE_DATE DATE

Standard concurrent request who column
TO_DEPARTMENT_ID NUMBER

To department identifier
PO_RELEASE_ID NUMBER

Purchasing release identifier
STATUS NUMBER

Result status
CHARACTER41 VARCHAR2 (150)
Generic collection element place holder column
CHARACTER42 VARCHAR2 (150)
Generic collection element place holder column
CHARACTER43 VARCHAR2 (150)
Generic collection element place holder column
CHARACTER44 VARCHAR2 (150)
Generic collection element place holder column
CHARACTER45 VARCHAR2 (150)
Generic collection element place holder column
CHARACTER46 VARCHAR2 (150)
Generic collection element place holder column
CHARACTER47 VARCHAR2 (150)
Generic collection element place holder column
CHARACTER48 VARCHAR2 (150)
Generic collection element place holder column
CHARACTER49 VARCHAR2 (150)
Generic collection element place holder column
CHARACTER50 VARCHAR2 (150)
Generic collection element place holder column
CHARACTER51 VARCHAR2 (150)
Generic collection element place holder column
CHARACTER52 VARCHAR2 (150)
Generic collection element place holder column
CHARACTER53 VARCHAR2 (150)
Generic collection element place holder column
CHARACTER54 VARCHAR2 (150)
Generic collection element place holder column
CHARACTER55 VARCHAR2 (150)
Generic collection element place holder column
CHARACTER56 VARCHAR2 (150)
Generic collection element place holder column
CHARACTER57 VARCHAR2 (150)
Generic collection element place holder column
CHARACTER58 VARCHAR2 (150)
Generic collection element place holder column
CHARACTER59 VARCHAR2 (150)
Generic collection element place holder column
CHARACTER60 VARCHAR2 (150)
Generic collection element place holder column
CHARACTER61 VARCHAR2 (150)
Generic collection element place holder column
CHARACTER62 VARCHAR2 (150)
Generic collection element place holder column
CHARACTER63 VARCHAR2 (150)
Generic collection element place holder column
CHARACTER64 VARCHAR2 (150)
Generic collection element place holder column
CHARACTER65 VARCHAR2 (150)
Generic collection element place holder column
CHARACTER66 VARCHAR2 (150)
Generic collection element place holder column
CHARACTER67 VARCHAR2 (150)
Generic collection element place holder column
CHARACTER68 VARCHAR2 (150)
Generic collection element place holder column
CHARACTER69 VARCHAR2 (150)
Generic collection element place holder column
CHARACTER70 VARCHAR2 (150)
Generic collection element place holder column
CHARACTER71 VARCHAR2 (150)
Generic collection element place holder column
CHARACTER72 VARCHAR2 (150)
Generic collection element place holder column
CHARACTER73 VARCHAR2 (150)
Generic collection element place holder column
CHARACTER74 VARCHAR2 (150)
Generic collection element place holder column
CHARACTER75 VARCHAR2 (150)
Generic collection element place holder column
CHARACTER76 VARCHAR2 (150)
Generic collection element place holder column
CHARACTER77 VARCHAR2 (150)
Generic collection element place holder column
CHARACTER78 VARCHAR2 (150)
Generic collection element place holder column
CHARACTER79 VARCHAR2 (150)
Generic collection element place holder column
CHARACTER80 VARCHAR2 (150)
Generic collection element place holder column
CHARACTER81 VARCHAR2 (150)
Generic collection element place holder column
CHARACTER82 VARCHAR2 (150)
Generic collection element place holder column
CHARACTER83 VARCHAR2 (150)
Generic collection element place holder column
CHARACTER84 VARCHAR2 (150)
Generic collection element place holder column
CHARACTER85 VARCHAR2 (150)
Generic collection element place holder column
CHARACTER86 VARCHAR2 (150)
Generic collection element place holder column
CHARACTER87 VARCHAR2 (150)
Generic collection element place holder column
CHARACTER88 VARCHAR2 (150)
Generic collection element place holder column
CHARACTER89 VARCHAR2 (150)
Generic collection element place holder column
CHARACTER90 VARCHAR2 (150)
Generic collection element place holder column
CHARACTER91 VARCHAR2 (150)
Generic collection element place holder column
CHARACTER92 VARCHAR2 (150)
Generic collection element place holder column
CHARACTER93 VARCHAR2 (150)
Generic collection element place holder column
CHARACTER94 VARCHAR2 (150)
Generic collection element place holder column
CHARACTER95 VARCHAR2 (150)
Generic collection element place holder column
CHARACTER96 VARCHAR2 (150)
Generic collection element place holder column
CHARACTER97 VARCHAR2 (150)
Generic collection element place holder column
CHARACTER98 VARCHAR2 (150)
Generic collection element place holder column
CHARACTER99 VARCHAR2 (150)
Generic collection element place holder column
CHARACTER100 VARCHAR2 (150)
Generic collection element place holder column
TRANSACTION_DATE DATE

Transaction date
ASSET_GROUP_ID NUMBER

asset group ID
ASSET_ACTIVITY_ID NUMBER

asset activity ID
ASSET_NUMBER VARCHAR2 (30)
asset number
WORK_ORDER_ID NUMBER

work order ID
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
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
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 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.
Query Text

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
,      CREATION_DATE
,      QA_CREATION_DATE
,      CREATED_BY
,      QA_CREATED_BY
,      LAST_UPDATE_LOGIN
,      TRANSACTION_NUMBER
,      TXN_HEADER_ID
,      ORGANIZATION_ID
,      PLAN_ID
,      SPEC_ID
,      TRANSACTION_ID
,      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_LINE_NUM
,      PO_SHIPMENT_NUM
,      CUSTOMER_ID
,      SO_HEADER_ID
,      RMA_HEADER_ID
,      PROJECT_ID
,      TASK_ID
,      LPN_ID
,      CONTRACT_ID
,      CONTRACT_LINE_ID
,      DELIVERABLE_ID
,      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
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      TO_DEPARTMENT_ID
,      PO_RELEASE_ID
,      STATUS
,      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
,      TRANSACTION_DATE
,      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 APPS.QA_RESULTS_VAL_V;

Dependencies

[top of page]

APPS.QA_RESULTS_VAL_V references the following:

SchemaAPPS
SynonymQA_RESULTS
APPS.QA_RESULTS_VAL_V is referenced by following:

SchemaAPPS
ViewMTL_GENEALOGY_QA_DATA