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]

VIEW: APPS.ISC_QA_RESULTS_V

Object Details

Object Name:	ISC_QA_RESULTS_V
Object Type:	VIEW
Owner:	APPS
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
COLLECTION_ID	NUMBER		Yes	Collection Id
OCCURRENCE	NUMBER		Yes	Occurrence
CREATION_DATE	DATE		Yes	Creation Date
QUANTITY	NUMBER
UOM	VARCHAR2	(3)
REVISION	VARCHAR2	(3)
LOCATOR_ID	NUMBER
TRANSACTION_NUMBER	NUMBER
TXN_HEADER_ID	NUMBER
ORGANIZATION_ID	NUMBER		Yes
PLAN_ID	NUMBER		Yes
SPEC_ID	NUMBER
TRANSACTION_ID	NUMBER
DEPARTMENT_ID	NUMBER
RESOURCE_ID	NUMBER
ITEM_ID	NUMBER
SUBINVENTORY	VARCHAR2	(10)
COMP_ITEM_ID	NUMBER
COMP_SUBINVENTORY	VARCHAR2	(10)
COMP_LOCATOR_ID	NUMBER
WIP_ENTITY_ID	NUMBER
LINE_ID	NUMBER
VENDOR_ID	NUMBER
PO_HEADER_ID	NUMBER
CUSTOMER_ID	NUMBER
SO_HEADER_ID	NUMBER
RMA_HEADER_ID	NUMBER
CHARACTER21	VARCHAR2	(150)
CHARACTER22	VARCHAR2	(150)
CHARACTER23	VARCHAR2	(150)
CHARACTER24	VARCHAR2	(150)
CHARACTER25	VARCHAR2	(150)
CHARACTER26	VARCHAR2	(150)
CHARACTER27	VARCHAR2	(150)
CHARACTER28	VARCHAR2	(150)
CHARACTER29	VARCHAR2	(150)
CHARACTER30	VARCHAR2	(150)
CHARACTER31	VARCHAR2	(150)
CHARACTER32	VARCHAR2	(150)
CHARACTER33	VARCHAR2	(150)
CHARACTER34	VARCHAR2	(150)
CHARACTER35	VARCHAR2	(150)
CHARACTER36	VARCHAR2	(150)
CHARACTER37	VARCHAR2	(150)
CHARACTER38	VARCHAR2	(150)
CHARACTER39	VARCHAR2	(150)
CHARACTER40	VARCHAR2	(150)
REQUEST_ID	NUMBER
PROGRAM_APPLICATION_ID	NUMBER
PROGRAM_ID	NUMBER
TO_DEPARTMENT_ID	NUMBER
PO_RELEASE_ID	NUMBER
CHARACTER41	VARCHAR2	(150)
CHARACTER42	VARCHAR2	(150)
CHARACTER43	VARCHAR2	(150)
CHARACTER44	VARCHAR2	(150)
CHARACTER45	VARCHAR2	(150)
CHARACTER46	VARCHAR2	(150)
CHARACTER47	VARCHAR2	(150)
CHARACTER48	VARCHAR2	(150)
CHARACTER49	VARCHAR2	(150)
CHARACTER50	VARCHAR2	(150)
CHARACTER51	VARCHAR2	(150)
CHARACTER52	VARCHAR2	(150)
CHARACTER53	VARCHAR2	(150)
CHARACTER54	VARCHAR2	(150)
CHARACTER55	VARCHAR2	(150)
CHARACTER56	VARCHAR2	(150)
CHARACTER57	VARCHAR2	(150)
CHARACTER58	VARCHAR2	(150)
CHARACTER59	VARCHAR2	(150)
CHARACTER60	VARCHAR2	(150)
CHARACTER61	VARCHAR2	(150)
CHARACTER62	VARCHAR2	(150)
CHARACTER63	VARCHAR2	(150)
CHARACTER64	VARCHAR2	(150)
CHARACTER65	VARCHAR2	(150)
CHARACTER66	VARCHAR2	(150)
CHARACTER67	VARCHAR2	(150)
CHARACTER68	VARCHAR2	(150)
CHARACTER69	VARCHAR2	(150)
CHARACTER70	VARCHAR2	(150)
CHARACTER71	VARCHAR2	(150)
CHARACTER72	VARCHAR2	(150)
CHARACTER73	VARCHAR2	(150)
CHARACTER74	VARCHAR2	(150)
CHARACTER75	VARCHAR2	(150)
CHARACTER76	VARCHAR2	(150)
CHARACTER77	VARCHAR2	(150)
CHARACTER78	VARCHAR2	(150)
CHARACTER79	VARCHAR2	(150)
CHARACTER80	VARCHAR2	(150)
CHARACTER81	VARCHAR2	(150)
CHARACTER82	VARCHAR2	(150)
CHARACTER83	VARCHAR2	(150)
CHARACTER84	VARCHAR2	(150)
CHARACTER85	VARCHAR2	(150)
CHARACTER86	VARCHAR2	(150)
CHARACTER87	VARCHAR2	(150)
CHARACTER88	VARCHAR2	(150)
CHARACTER89	VARCHAR2	(150)
CHARACTER90	VARCHAR2	(150)
CHARACTER91	VARCHAR2	(150)
CHARACTER92	VARCHAR2	(150)
CHARACTER93	VARCHAR2	(150)
CHARACTER94	VARCHAR2	(150)
CHARACTER95	VARCHAR2	(150)
CHARACTER96	VARCHAR2	(150)
CHARACTER97	VARCHAR2	(150)
CHARACTER98	VARCHAR2	(150)
CHARACTER99	VARCHAR2	(150)
CHARACTER100	VARCHAR2	(150)
PROJECT_ID	NUMBER
TASK_ID	NUMBER
LPN_ID	NUMBER
CONTRACT_ID	NUMBER
CONTRACT_LINE_ID	NUMBER
DELIVERABLE_ID	NUMBER
ASSET_GROUP_ID	NUMBER
ASSET_ACTIVITY_ID	NUMBER
WORK_ORDER_ID	NUMBER
SEQUENCE6	VARCHAR2	(50)
SEQUENCE7	VARCHAR2	(50)
SEQUENCE8	VARCHAR2	(50)
SEQUENCE9	VARCHAR2	(50)
SEQUENCE10	VARCHAR2	(50)
SEQUENCE11	VARCHAR2	(50)
SEQUENCE12	VARCHAR2	(50)
SEQUENCE13	VARCHAR2	(50)
SEQUENCE14	VARCHAR2	(50)
SEQUENCE15	VARCHAR2	(50)
COMMENT4	VARCHAR2	(2000)
COMMENT5	VARCHAR2	(2000)
PARTY_ID	NUMBER
CSI_INSTANCE_ID	NUMBER
COUNTER_ID	NUMBER
COUNTER_READING_ID	NUMBER
AHL_MR_ID	NUMBER
CS_INCIDENT_ID	NUMBER
WIP_REWORK_ID	NUMBER
LOCATOR	VARCHAR2	(4000)
LOT_NUMBER	VARCHAR2	(80)
SERIAL_NUMBER	VARCHAR2	(30)
COMP_UOM	VARCHAR2	(3)
COMP_REVISION	VARCHAR2	(3)
COMP_LOT_NUMBER	VARCHAR2	(80)
COMP_SERIAL_NUMBER	VARCHAR2	(30)
TO_OP_SEQ_NUM	NUMBER
FROM_OP_SEQ_NUM	NUMBER
RECEIPT_NUM	VARCHAR2	(30)
PO_LINE_NUM	NUMBER
PO_SHIPMENT_NUM	NUMBER
PROJECT_NUMBER	VARCHAR2	(4000)
SALES_ORDER	VARCHAR2	(4000)
RMA_NUMBER	NUMBER
STATUS	NUMBER
TRANSACTION_DATE	DATE
CONTRACT_NUMBER	VARCHAR2	(4000)
CONTRACT_LINE_NUMBER	VARCHAR2	(4000)
DELIVERABLE_NUMBER	VARCHAR2	(4000)
CHARACTER1	VARCHAR2	(150)
CHARACTER2	VARCHAR2	(150)
CHARACTER3	VARCHAR2	(150)
CHARACTER4	VARCHAR2	(150)
CHARACTER5	VARCHAR2	(150)
CHARACTER6	VARCHAR2	(150)
CHARACTER7	VARCHAR2	(150)
CHARACTER8	VARCHAR2	(150)
CHARACTER9	VARCHAR2	(150)
CHARACTER10	VARCHAR2	(150)
CHARACTER11	VARCHAR2	(150)
CHARACTER12	VARCHAR2	(150)
CHARACTER13	VARCHAR2	(150)
CHARACTER14	VARCHAR2	(150)
CHARACTER15	VARCHAR2	(150)
CHARACTER16	VARCHAR2	(150)
CHARACTER17	VARCHAR2	(150)
CHARACTER18	VARCHAR2	(150)
CHARACTER19	VARCHAR2	(150)
CHARACTER20	VARCHAR2	(150)
ASSET_GROUP	VARCHAR2	(4000)
ASSET_NUMBER	VARCHAR2	(30)
ASSET_ACTIVITY	VARCHAR2	(4000)
SEQUENCE1	VARCHAR2	(50)
SEQUENCE2	VARCHAR2	(50)
SEQUENCE3	VARCHAR2	(50)
SEQUENCE4	VARCHAR2	(50)
SEQUENCE5	VARCHAR2	(50)
COMMENT1	VARCHAR2	(2000)
COMMENT2	VARCHAR2	(2000)
COMMENT3	VARCHAR2	(2000)
NONCONFORM_SEVERITY	VARCHAR2	(150)
NONCONFORM_PRIORITY	VARCHAR2	(150)
NONCONFORMANCE_CODE	VARCHAR2	(150)
DATE_OPENED	DATE
DATE_CLOSED	DATE
DAYS_TO_CLOSE	NUMBER
TO_SUBINVENTORY	VARCHAR2	(150)
REQUEST_STATUS	VARCHAR2	(150)
REQUEST_SOURCE	VARCHAR2	(150)
REQUEST_PRIORITY	VARCHAR2	(150)
REQUEST_SEVERITY	VARCHAR2	(150)
ECO_NAME	VARCHAR2	(150)
COMPONENT_ITEM	VARCHAR2	(4000)
COMPONENT_LOCATOR	VARCHAR2	(4000)
TO_LOCATOR	VARCHAR2	(4000)
BILL_REFERENCE	VARCHAR2	(4000)
ROUTING_REFERENCE	VARCHAR2	(4000)
DISPOSITION_SOURCE	VARCHAR2	(150)
DISPOSITION	VARCHAR2	(150)
DISPOSITION_ACTION	VARCHAR2	(150)
DISPOSITION_STATUS	VARCHAR2	(150)
MAINTENANCE_OP_SEQ	NUMBER
NONCONFORMANCE_SOURCE	VARCHAR2	(150)
NONCONFORMANCE_TYPE	VARCHAR2	(150)
NONCONFORMANCE_STATUS	VARCHAR2	(150)
SERIAL_STATUS_ID	NUMBER
LOT_STATUS_ID	NUMBER
MTI_TRANSACTION_HEADER_ID	NUMBER
MTI_TRANSACTION_INTERFACE_ID	NUMBER
MMT_TRANSACTION_ID	NUMBER
WJSI_GROUP_ID	NUMBER
WMTI_GROUP_ID	NUMBER
WMT_TRANSACTION_ID	NUMBER
RTI_INTERFACE_TRANSACTION_ID	NUMBER
TO_LOCATOR_ID	NUMBER
BILL_REFERENCE_ID	NUMBER
ROUTING_REFERENCE_ID	NUMBER
CONCURRENT_REQUEST_ID	NUMBER
RCV_TRANSACTION_ID	NUMBER
FOLLOWUP_ACTIVITY_ID	NUMBER
XFR_LPN_ID	NUMBER

Query Text

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


SELECT COLLECTION_ID
,      OCCURRENCE
,      CREATION_DATE
,      QUANTITY
,      UOM
,      REVISION
,      LOCATOR_ID
,      TRANSACTION_NUMBER
,      TXN_HEADER_ID
,      ORGANIZATION_ID
,      PLAN_ID
,      SPEC_ID
,      TRANSACTION_ID
,      DEPARTMENT_ID
,      RESOURCE_ID
,      ITEM_ID
,      SUBINVENTORY
,      COMP_ITEM_ID
,      COMP_SUBINVENTORY
,      COMP_LOCATOR_ID
,      WIP_ENTITY_ID
,      LINE_ID
,      VENDOR_ID
,      PO_HEADER_ID
,      CUSTOMER_ID
,      SO_HEADER_ID
,      RMA_HEADER_ID
,      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
,      TO_DEPARTMENT_ID
,      PO_RELEASE_ID
,      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
,      PROJECT_ID
,      TASK_ID
,      LPN_ID
,      CONTRACT_ID
,      CONTRACT_LINE_ID
,      DELIVERABLE_ID
,      ASSET_GROUP_ID
,      ASSET_ACTIVITY_ID
,      WORK_ORDER_ID
,      SEQUENCE6
,      SEQUENCE7
,      SEQUENCE8
,      SEQUENCE9
,      SEQUENCE10
,      SEQUENCE11
,      SEQUENCE12
,      SEQUENCE13
,      SEQUENCE14
,      SEQUENCE15
,      COMMENT4
,      COMMENT5
,      PARTY_ID
,      CSI_INSTANCE_ID
,      COUNTER_ID
,      COUNTER_READING_ID
,      AHL_MR_ID
,      CS_INCIDENT_ID
,      WIP_REWORK_ID
,      LOCATOR
,      LOT_NUMBER
,      SERIAL_NUMBER
,      COMP_UOM
,      COMP_REVISION
,      COMP_LOT_NUMBER
,      COMP_SERIAL_NUMBER
,      TO_OP_SEQ_NUM
,      FROM_OP_SEQ_NUM
,      RECEIPT_NUM
,      PO_LINE_NUM
,      PO_SHIPMENT_NUM
,      PROJECT_NUMBER
,      SALES_ORDER
,      RMA_NUMBER
,      STATUS
,      TRANSACTION_DATE
,      CONTRACT_NUMBER
,      CONTRACT_LINE_NUMBER
,      DELIVERABLE_NUMBER
,      CHARACTER1
,      CHARACTER2
,      CHARACTER3
,      CHARACTER4
,      CHARACTER5
,      CHARACTER6
,      CHARACTER7
,      CHARACTER8
,      CHARACTER9
,      CHARACTER10
,      CHARACTER11
,      CHARACTER12
,      CHARACTER13
,      CHARACTER14
,      CHARACTER15
,      CHARACTER16
,      CHARACTER17
,      CHARACTER18
,      CHARACTER19
,      CHARACTER20
,      ASSET_GROUP
,      ASSET_NUMBER
,      ASSET_ACTIVITY
,      SEQUENCE1
,      SEQUENCE2
,      SEQUENCE3
,      SEQUENCE4
,      SEQUENCE5
,      COMMENT1
,      COMMENT2
,      COMMENT3
,      NONCONFORM_SEVERITY
,      NONCONFORM_PRIORITY
,      NONCONFORMANCE_CODE
,      DATE_OPENED
,      DATE_CLOSED
,      DAYS_TO_CLOSE
,      TO_SUBINVENTORY
,      REQUEST_STATUS
,      REQUEST_SOURCE
,      REQUEST_PRIORITY
,      REQUEST_SEVERITY
,      ECO_NAME
,      COMPONENT_ITEM
,      COMPONENT_LOCATOR
,      TO_LOCATOR
,      BILL_REFERENCE
,      ROUTING_REFERENCE
,      DISPOSITION_SOURCE
,      DISPOSITION
,      DISPOSITION_ACTION
,      DISPOSITION_STATUS
,      MAINTENANCE_OP_SEQ
,      NONCONFORMANCE_SOURCE
,      NONCONFORMANCE_TYPE
,      NONCONFORMANCE_STATUS
,      SERIAL_STATUS_ID
,      LOT_STATUS_ID
,      MTI_TRANSACTION_HEADER_ID
,      MTI_TRANSACTION_INTERFACE_ID
,      MMT_TRANSACTION_ID
,      WJSI_GROUP_ID
,      WMTI_GROUP_ID
,      WMT_TRANSACTION_ID
,      RTI_INTERFACE_TRANSACTION_ID
,      TO_LOCATOR_ID
,      BILL_REFERENCE_ID
,      ROUTING_REFERENCE_ID
,      CONCURRENT_REQUEST_ID
,      RCV_TRANSACTION_ID
,      FOLLOWUP_ACTIVITY_ID
,      XFR_LPN_ID
FROM APPS.ISC_QA_RESULTS_V;

Dependencies

[top of page]

APPS.ISC_QA_RESULTS_V references the following:

APPS: QA_FLEX_UTIL - show dependent code; QA_RESULTS

APPS.ISC_QA_RESULTS_V is not referenced by any database object