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


VIEW: APPS.QA_RESULTS_FULL_V

Object Details
Object Name: QA_RESULTS_FULL_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewQA.QA_RESULTS_FULL_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 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
ORGANIZATION_CODE VARCHAR2 (3)
Org Code
ORGANIZATION_NAME VARCHAR2 (240)
Org Name
PLAN_ID NUMBER
Yes collection plan identifier
TEMPLATE_PLAN_ID NUMBER

Template plan ID
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
ITEM VARCHAR2 (4000)
Item
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
LOCATOR VARCHAR2 (4000)
Locator
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
COMP_ITEM VARCHAR2 (4000)
Component Item
COMP_LOCATOR VARCHAR2 (4000)
Component locator
TO_LOCATOR VARCHAR2 (4000)
To Locator
BILL_REFERENCE VARCHAR2 (4000)
Bill reference
ROUTING_REFERENCE VARCHAR2 (4000)
Routing reference
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.
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
,      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
,      ORGANIZATION_CODE
,      ORGANIZATION_NAME
,      PLAN_ID
,      TEMPLATE_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
,      ITEM
,      UOM
,      REVISION
,      SUBINVENTORY
,      SUB_LOC_TYPE
,      LOCATOR_ID
,      LOCATOR
,      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
,      COMP_ITEM
,      COMP_LOCATOR
,      TO_LOCATOR
,      BILL_REFERENCE
,      ROUTING_REFERENCE
,      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
FROM APPS.QA_RESULTS_FULL_V;

Dependencies

[top of page]

APPS.QA_RESULTS_FULL_V references the following:

SchemaAPPS
SynonymAP_SUPPLIERS
SynonymBOM_DEPARTMENTS
SynonymBOM_RESOURCES
SynonymCSD_REPAIRS
SynonymCSI_COUNTERS_TL
SynonymCSI_COUNTER_READINGS
SynonymCSI_ITEM_INSTANCES
SynonymCS_INCIDENTS_ALL_B
SynonymFND_LOOKUP_VALUES
ViewFND_USER_VIEW
SynonymGMD_OPERATIONS_B
SynonymGME_BATCH_HEADER
SynonymGME_BATCH_STEPS
SynonymGME_BATCH_STEP_ACTIVITIES
SynonymGME_BATCH_STEP_RESOURCES
SynonymGMP_PROCESS_PARAMETERS_B
SynonymHR_ALL_ORGANIZATION_UNITS_TL
SynonymHZ_CUST_ACCOUNTS
SynonymHZ_PARTIES
SynonymJTF_TASKS_B
SynonymMTL_MATERIAL_STATUSES_B
SynonymMTL_MATERIAL_STATUSES_TL
SynonymMTL_PARAMETERS
SynonymMTL_SALES_ORDERS
SynonymMTL_SECONDARY_INVENTORIES
SynonymOE_ORDER_HEADERS_ALL
SynonymPA_TASKS
SynonymPO_HEADERS_ALL
SynonymPO_RELEASES_ALL
SynonymQA_AHL_MR
SynonymQA_CSI_ITEM_INSTANCES
PL/SQL PackageQA_FLEX_UTIL - show dependent code
SynonymQA_PLANS
SynonymQA_RESULTS
SynonymWIP_ENTITIES
SynonymWIP_LINES
SynonymWMS_LICENSE_PLATE_NUMBERS

APPS.QA_RESULTS_FULL_V is not referenced by any database object