eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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:	QA.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:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
QA_RESULTS_INTERFACE_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	GROUP_ID PROCESS_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	(80)		Purchase Order number
PO_LINE_NUM	VARCHAR2	(240)		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:

QA: QA_RESULTS_INTERFACE#