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

TABLE: QA.QA_RESULTS_INTERFACE

Object Details
Object Name: QA_RESULTS_INTERFACE
Object Type: TABLE
Owner: QA
FND Design Data: TableQA.QA_RESULTS_INTERFACE
Subobject Name:
Status: VALID


QA_RESULTS_INTERFACE is the Oracle Quality Open Interfaces table.
QA_RESULTS_INTERFACE mimics the structure of QA_RESULTS and is
the central entity of the collection import process. Users load
rows of data into the QA_RESULTS_INTERFACE table and invoke a
Collection Import Concurrent Manager request. Successfully
processed data is then moved from the QA_RESULTS_INTERFACE table
to the QA_RESULTS table.
Oracle Quality supports dynamic views. These are created through
the Collection Plan window. You can create both a dynamic plan view
and a dynamic import view for a collection plan.
The dynamic import view has the format Q__IV where
corresponds to the name of the collection plan on which the view
is based. The dynamic import view can be used to insert values
into the QA_RESULTS_INTERFACE table. This view resolves the
generic CHARACTERx columns of the QA_RESULTS_INTERFACE table
into meaningful columns based on the collection element name.


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
QA_RESULTS_INTERFACE_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnGROUP_ID
ColumnPROCESS_STATUS
Columns
Name Datatype Length Mandatory Comments
TRANSACTION_INTERFACE_ID NUMBER

Colection Import transaction Identifier
LAST_UPDATE_DATE DATE

Standard Who column
LAST_UPDATED_BY NUMBER

Standard Who column
QA_LAST_UPDATED_BY NUMBER

Quality Who column
QA_LAST_UPDATED_BY_NAME VARCHAR2 (100)
Quality Who column
CREATION_DATE DATE

Standard Who column
CREATED_BY NUMBER

Standard Who column
QA_CREATED_BY NUMBER

Standard Who column
QA_CREATED_BY_NAME VARCHAR2 (100)
Quality Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
REQUEST_ID NUMBER

Concurrent request Standard 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
COLLECTION_ID NUMBER

Result collection Identifier
GROUP_ID NUMBER

A unique group ID assigned per plan per transaction worker for collection import transaction
SOURCE_CODE VARCHAR2 (30)
Identifies the source of quality data
SOURCE_LINE_ID NUMBER

More detailed identification about the quality data
PROCESS_STATUS NUMBER
Yes Indicates status of a row. Status could be pending, running, error, or successful completion
VALIDATE_FLAG NUMBER

Validate flag
MARKER NUMBER

Indicates which rows have triggered actions or have actions assigned to them
ORGANIZATION_ID NUMBER

Inventory Organization identifier
ORGANIZATION_CODE VARCHAR2 (3) Yes Inventory organization code
PLAN_ID NUMBER

Collection plan Identifier
PLAN_NAME VARCHAR2 (30) Yes Collection plan name
SPEC_ID NUMBER

Specification identifier
SPEC_NAME VARCHAR2 (30)
Specification name
DEPARTMENT_ID NUMBER

Department Identifier
DEPARTMENT VARCHAR2 (10)
Department Name
TO_DEPARTMENT_ID NUMBER

To department Identifier
TO_DEPARTMENT VARCHAR2 (10)
To department code
RESOURCE_ID NUMBER

Resource Identifier
RESOURCE_CODE VARCHAR2 (10)
Resource code
QUANTITY NUMBER

Quantity is a hardcoded collection element in Oracle Quality
ITEM_ID NUMBER

Item Identifier
ITEM VARCHAR2 (2000)
Item Description
UOM VARCHAR2 (3)
Unit of measurement
REVISION VARCHAR2 (3)
Revision is a hardcoded collection element
SUBINVENTORY VARCHAR2 (10)
Subinventory is a hardcoded collection element
LOCATOR_ID NUMBER

Locator Identifier
LOCATOR VARCHAR2 (2000)
Locator description
LOT_NUMBER VARCHAR2 (80)
Lot number
SERIAL_NUMBER VARCHAR2 (30)
Serial number
COMP_ITEM_ID NUMBER

Component item Identifier
COMP_ITEM VARCHAR2 (2000)
Component item
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_LOCATOR VARCHAR2 (2000)
Component locator
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 description
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 (240)
Vendor name
RECEIPT_NUM VARCHAR2 (30)
Receipt number
PO_HEADER_ID NUMBER

Purchasing document Identifier
PO_RELEASE_ID NUMBER

Purchasing release Identifier
PO_RELEASE_NUM NUMBER

Purchasing release Number
PO_TYPE_LOOKUP VARCHAR2 (25)
Purchase order type lookup
PO_NUMBER VARCHAR2 (20)
Purchase Order number
PO_LINE_NUM NUMBER

Purchase Order line number
PO_SHIPMENT_NUM NUMBER

Purchase Order Shipment Number
CUSTOMER_ID NUMBER

Customer Identifier
CUSTOMER_NAME VARCHAR2 (360)
Customer name
SO_HEADER_ID NUMBER

Sales order Identifier
SALES_ORDER NUMBER

Sales order number
RESTRICT_LOCATORS_CODE NUMBER

Locators restriction type
LOCATION_CONTROL_CODE NUMBER

Stock locator control code
REVISION_QTY_CONTROL_CODE NUMBER

Revision quantity control code
RESTRICT_SUBINV_CODE NUMBER

Subinventory restriction type
SUB_LOCATOR_TYPE NUMBER

Subinventory level stock locator control type
GEN_LOC_CTRL_CODE NUMBER

Organization level stock locator control code
COMP_RESTRICT_LOCATORS_CODE NUMBER

Component locators restriction type
COMP_LOCATION_CONTROL_CODE NUMBER

Component stock locator control code
COMP_REVISION_QTY_CONTROL_CODE NUMBER

Component revision quantity control code
COMP_RESTRICT_SUBINV_CODE NUMBER

Component subinventory restriction type
COMP_SUB_LOCATOR_TYPE NUMBER

Component subinventory level stock locator control type
PROJECT_ID NUMBER

Project Identifier
PROJECT_NUMBER VARCHAR2 (25)
Project number
TASK_ID NUMBER

Task Identifier
TASK_NUMBER VARCHAR2 (25)
Task number
STATUS NUMBER

Flag to indicate whether this row is valid quality result or not. A value of NULL or 2 indicates valid row whereas a value of 1 indicates invalid row
TRANSACTION_DATE DATE

Transaction Date
COMP_GEN_LOC_CTRL_CODE NUMBER

Component locator control code
RMA_HEADER_ID NUMBER

Return material authorization identifier
RMA_NUMBER NUMBER

Return material authorization number
INSERT_TYPE NUMBER

Indicates type of import transaction: 1 or Null means insert, and 2 means update
MATCHING_ELEMENTS VARCHAR2 (1000)
A comma-separated list of column names. The data in these columns will be used as search keys to find matching rows in collection import updates.
CHARACTER1 VARCHAR2 (150)
Generic placeholder column for user-defined collection element
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
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
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
PO_AGENT_ID NUMBER

PO Buyer ID
LPN_ID NUMBER

License Plate Number Identifier
LICENSE_PLATE_NUMBER VARCHAR2 (30)
License Plate Number
CONTRACT_ID NUMBER

Contract Identifier
CONTRACT_NUMBER VARCHAR2 (120)
Contract Number
CONTRACT_LINE_ID NUMBER

Contract Line Identifier
CONTRACT_LINE_NUMBER VARCHAR2 (150)
Contract Line Number
DELIVERABLE_ID NUMBER

Deliverable Identifier
DELIVERABLE_NUMBER VARCHAR2 (150)
Deliverable Number
ASSET_GROUP_ID NUMBER

asset group ID
ASSET_GROUP VARCHAR2 (2000)
asset group
ASSET_NUMBER VARCHAR2 (30)
asset number
ASSET_ACTIVITY_ID NUMBER

asset activity ID
ASSET_ACTIVITY VARCHAR2 (2000)
asset activity
WORK_ORDER_ID NUMBER

work order ID
WORK_ORDER VARCHAR2 (240)
work order
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
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 (30)
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
VERSION_NUMBER NUMBER

AHL maintenance requirement version number. 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 (240)
Disposition source. Oracle Internal use only - reserved for future use
DISPOSITION VARCHAR2 (240)
Disposition. Oracle Internal use only - reserved for future use
DISPOSITION_ACTION VARCHAR2 (240)
Disposition action. Oracle Internal use only - reserved for future use
DISPOSITION_STATUS VARCHAR2 (240)
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 (240)
To Subinventory
TO_LOCATOR_ID NUMBER

To Locator Id
TO_LOCATOR VARCHAR2 (2000)
To Locator
TO_SUB_LOCATOR_TYPE NUMBER

To Sub Locator Type
BILL_REFERENCE_ID NUMBER

Bill Reference Id
BILL_REFERENCE VARCHAR2 (2000)
Bill Reference
ROUTING_REFERENCE_ID NUMBER

Routing Reference Id
ROUTING_REFERENCE VARCHAR2 (2000)
Routing Reference
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
LOT_STATUS VARCHAR2 (30)
Lot Status
SERIAL_STATUS VARCHAR2 (80)
Serial Status
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
FOLLOWUP_ACTIVITY VARCHAR2 (2000)
Follwup Activity used in EAM
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

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.
OPERATING_UNIT_ID NUMBER

Operating Unit ID
OPERATING_UNIT VARCHAR2 (240)
Operating unit name
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT TRANSACTION_INTERFACE_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      QA_LAST_UPDATED_BY
,      QA_LAST_UPDATED_BY_NAME
,      CREATION_DATE
,      CREATED_BY
,      QA_CREATED_BY
,      QA_CREATED_BY_NAME
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      COLLECTION_ID
,      GROUP_ID
,      SOURCE_CODE
,      SOURCE_LINE_ID
,      PROCESS_STATUS
,      VALIDATE_FLAG
,      MARKER
,      ORGANIZATION_ID
,      ORGANIZATION_CODE
,      PLAN_ID
,      PLAN_NAME
,      SPEC_ID
,      SPEC_NAME
,      DEPARTMENT_ID
,      DEPARTMENT
,      TO_DEPARTMENT_ID
,      TO_DEPARTMENT
,      RESOURCE_ID
,      RESOURCE_CODE
,      QUANTITY
,      ITEM_ID
,      ITEM
,      UOM
,      REVISION
,      SUBINVENTORY
,      LOCATOR_ID
,      LOCATOR
,      LOT_NUMBER
,      SERIAL_NUMBER
,      COMP_ITEM_ID
,      COMP_ITEM
,      COMP_UOM
,      COMP_REVISION
,      COMP_SUBINVENTORY
,      COMP_LOCATOR_ID
,      COMP_LOCATOR
,      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_RELEASE_NUM
,      PO_TYPE_LOOKUP
,      PO_NUMBER
,      PO_LINE_NUM
,      PO_SHIPMENT_NUM
,      CUSTOMER_ID
,      CUSTOMER_NAME
,      SO_HEADER_ID
,      SALES_ORDER
,      RESTRICT_LOCATORS_CODE
,      LOCATION_CONTROL_CODE
,      REVISION_QTY_CONTROL_CODE
,      RESTRICT_SUBINV_CODE
,      SUB_LOCATOR_TYPE
,      GEN_LOC_CTRL_CODE
,      COMP_RESTRICT_LOCATORS_CODE
,      COMP_LOCATION_CONTROL_CODE
,      COMP_REVISION_QTY_CONTROL_CODE
,      COMP_RESTRICT_SUBINV_CODE
,      COMP_SUB_LOCATOR_TYPE
,      PROJECT_ID
,      PROJECT_NUMBER
,      TASK_ID
,      TASK_NUMBER
,      STATUS
,      TRANSACTION_DATE
,      COMP_GEN_LOC_CTRL_CODE
,      RMA_HEADER_ID
,      RMA_NUMBER
,      INSERT_TYPE
,      MATCHING_ELEMENTS
,      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
,      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
,      CHARACTER38
,      CHARACTER39
,      CHARACTER40
,      PO_AGENT_ID
,      LPN_ID
,      LICENSE_PLATE_NUMBER
,      CONTRACT_ID
,      CONTRACT_NUMBER
,      CONTRACT_LINE_ID
,      CONTRACT_LINE_NUMBER
,      DELIVERABLE_ID
,      DELIVERABLE_NUMBER
,      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
,      VERSION_NUMBER
,      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_LOCATOR_ID
,      TO_LOCATOR
,      TO_SUB_LOCATOR_TYPE
,      BILL_REFERENCE_ID
,      BILL_REFERENCE
,      ROUTING_REFERENCE_ID
,      ROUTING_REFERENCE
,      CONCURRENT_REQUEST_ID
,      LOT_STATUS_ID
,      SERIAL_STATUS_ID
,      NONCONFORMANCE_STATUS
,      RCV_TRANSACTION_ID
,      LOT_STATUS
,      SERIAL_STATUS
,      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
,      OPERATING_UNIT_ID
,      OPERATING_UNIT
FROM QA.QA_RESULTS_INTERFACE;

Dependencies

[top of page]

QA.QA_RESULTS_INTERFACE does not reference any database object

QA.QA_RESULTS_INTERFACE is referenced by following:

SchemaAPPS
SynonymQA_RESULTS_INTERFACE