[Home] [Help] [Dependency Information]
Object Name: | ISC_QA_RESULTS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
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 |
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;
APPS.ISC_QA_RESULTS_V is not referenced by any database object
|
|
|