[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | QA_RESULTS_INTERFACE# |
|---|---|
| Object Type: | VIEW |
| Owner: | QA |
| Subobject Name: | |
| Status: | VALID |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| TRANSACTION_INTERFACE_ID | NUMBER | |||
| LAST_UPDATE_DATE | DATE | |||
| LAST_UPDATED_BY | NUMBER | |||
| QA_LAST_UPDATED_BY | NUMBER | |||
| QA_LAST_UPDATED_BY_NAME | VARCHAR2 | (100) | ||
| CREATION_DATE | DATE | |||
| CREATED_BY | NUMBER | |||
| QA_CREATED_BY | NUMBER | |||
| QA_CREATED_BY_NAME | VARCHAR2 | (100) | ||
| LAST_UPDATE_LOGIN | NUMBER | |||
| REQUEST_ID | NUMBER | |||
| PROGRAM_APPLICATION_ID | NUMBER | |||
| PROGRAM_ID | NUMBER | |||
| PROGRAM_UPDATE_DATE | DATE | |||
| COLLECTION_ID | NUMBER | |||
| GROUP_ID | NUMBER | |||
| SOURCE_CODE | VARCHAR2 | (30) | ||
| SOURCE_LINE_ID | NUMBER | |||
| PROCESS_STATUS | NUMBER | Yes | ||
| VALIDATE_FLAG | NUMBER | |||
| MARKER | NUMBER | |||
| ORGANIZATION_ID | NUMBER | |||
| ORGANIZATION_CODE | VARCHAR2 | (3) | Yes | |
| PLAN_ID | NUMBER | |||
| PLAN_NAME | VARCHAR2 | (30) | Yes | |
| SPEC_ID | NUMBER | |||
| SPEC_NAME | VARCHAR2 | (30) | ||
| DEPARTMENT_ID | NUMBER | |||
| DEPARTMENT | VARCHAR2 | (10) | ||
| TO_DEPARTMENT_ID | NUMBER | |||
| TO_DEPARTMENT | VARCHAR2 | (10) | ||
| RESOURCE_ID | NUMBER | |||
| RESOURCE_CODE | VARCHAR2 | (10) | ||
| QUANTITY | NUMBER | |||
| ITEM_ID | NUMBER | |||
| ITEM | VARCHAR2 | (2000) | ||
| UOM | VARCHAR2 | (3) | ||
| REVISION | VARCHAR2 | (3) | ||
| SUBINVENTORY | VARCHAR2 | (10) | ||
| LOCATOR_ID | NUMBER | |||
| LOCATOR | VARCHAR2 | (2000) | ||
| LOT_NUMBER | VARCHAR2 | (80) | ||
| SERIAL_NUMBER | VARCHAR2 | (30) | ||
| COMP_ITEM_ID | NUMBER | |||
| COMP_ITEM | VARCHAR2 | (2000) | ||
| COMP_UOM | VARCHAR2 | (3) | ||
| COMP_REVISION | VARCHAR2 | (3) | ||
| COMP_SUBINVENTORY | VARCHAR2 | (10) | ||
| COMP_LOCATOR_ID | NUMBER | |||
| COMP_LOCATOR | VARCHAR2 | (2000) | ||
| COMP_LOT_NUMBER | VARCHAR2 | (80) | ||
| COMP_SERIAL_NUMBER | VARCHAR2 | (30) | ||
| WIP_ENTITY_ID | NUMBER | |||
| JOB_NAME | VARCHAR2 | (240) | ||
| LINE_ID | NUMBER | |||
| PRODUCTION_LINE | VARCHAR2 | (10) | ||
| TO_OP_SEQ_NUM | NUMBER | |||
| FROM_OP_SEQ_NUM | NUMBER | |||
| VENDOR_ID | NUMBER | |||
| VENDOR_NAME | VARCHAR2 | (240) | ||
| RECEIPT_NUM | VARCHAR2 | (30) | ||
| PO_HEADER_ID | NUMBER | |||
| PO_RELEASE_ID | NUMBER | |||
| PO_RELEASE_NUM | NUMBER | |||
| PO_TYPE_LOOKUP | VARCHAR2 | (25) | ||
| PO_NUMBER | VARCHAR2 | (80) | ||
| PO_LINE_NUM | VARCHAR2 | (240) | ||
| PO_SHIPMENT_NUM | NUMBER | |||
| CUSTOMER_ID | NUMBER | |||
| CUSTOMER_NAME | VARCHAR2 | (360) | ||
| SO_HEADER_ID | NUMBER | |||
| SALES_ORDER | NUMBER | |||
| RESTRICT_LOCATORS_CODE | NUMBER | |||
| LOCATION_CONTROL_CODE | NUMBER | |||
| REVISION_QTY_CONTROL_CODE | NUMBER | |||
| RESTRICT_SUBINV_CODE | NUMBER | |||
| SUB_LOCATOR_TYPE | NUMBER | |||
| GEN_LOC_CTRL_CODE | NUMBER | |||
| COMP_RESTRICT_LOCATORS_CODE | NUMBER | |||
| COMP_LOCATION_CONTROL_CODE | NUMBER | |||
| COMP_REVISION_QTY_CONTROL_CODE | NUMBER | |||
| COMP_RESTRICT_SUBINV_CODE | NUMBER | |||
| COMP_SUB_LOCATOR_TYPE | NUMBER | |||
| PROJECT_ID | NUMBER | |||
| PROJECT_NUMBER | VARCHAR2 | (25) | ||
| TASK_ID | NUMBER | |||
| TASK_NUMBER | VARCHAR2 | (25) | ||
| STATUS | NUMBER | |||
| TRANSACTION_DATE | DATE | |||
| COMP_GEN_LOC_CTRL_CODE | NUMBER | |||
| RMA_HEADER_ID | NUMBER | |||
| RMA_NUMBER | NUMBER | |||
| INSERT_TYPE | NUMBER | |||
| MATCHING_ELEMENTS | VARCHAR2 | (1000) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| CHARACTER38 | VARCHAR2 | (150) | ||
| CHARACTER39 | VARCHAR2 | (150) | ||
| CHARACTER40 | VARCHAR2 | (150) | ||
| PO_AGENT_ID | NUMBER | |||
| LPN_ID | NUMBER | |||
| LICENSE_PLATE_NUMBER | VARCHAR2 | (30) | ||
| CONTRACT_ID | NUMBER | |||
| CONTRACT_NUMBER | VARCHAR2 | (120) | ||
| CONTRACT_LINE_ID | NUMBER | |||
| CONTRACT_LINE_NUMBER | VARCHAR2 | (150) | ||
| DELIVERABLE_ID | NUMBER | |||
| DELIVERABLE_NUMBER | VARCHAR2 | (150) | ||
| ASSET_GROUP_ID | NUMBER | |||
| ASSET_GROUP | VARCHAR2 | (2000) | ||
| ASSET_NUMBER | VARCHAR2 | (30) | ||
| ASSET_ACTIVITY_ID | NUMBER | |||
| ASSET_ACTIVITY | VARCHAR2 | (2000) | ||
| WORK_ORDER_ID | NUMBER | |||
| WORK_ORDER | VARCHAR2 | (240) | ||
| SEQUENCE1 | VARCHAR2 | (50) | ||
| SEQUENCE2 | VARCHAR2 | (50) | ||
| SEQUENCE3 | VARCHAR2 | (50) | ||
| SEQUENCE4 | VARCHAR2 | (50) | ||
| SEQUENCE5 | VARCHAR2 | (50) | ||
| 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) | ||
| COMMENT1 | VARCHAR2 | (2000) | ||
| COMMENT2 | VARCHAR2 | (2000) | ||
| COMMENT3 | VARCHAR2 | (2000) | ||
| COMMENT4 | VARCHAR2 | (2000) | ||
| COMMENT5 | VARCHAR2 | (2000) | ||
| PARTY_ID | NUMBER | |||
| PARTY_NAME | VARCHAR2 | (360) | ||
| CSI_INSTANCE_ID | NUMBER | |||
| ITEM_INSTANCE | VARCHAR2 | (30) | ||
| COUNTER_ID | NUMBER | |||
| COUNTER_NAME | VARCHAR2 | (30) | ||
| COUNTER_READING_ID | NUMBER | |||
| COUNTER_READING | NUMBER | |||
| AHL_MR_ID | NUMBER | |||
| MAINTENANCE_REQUIREMENT | VARCHAR2 | (80) | ||
| VERSION_NUMBER | NUMBER | |||
| CS_INCIDENT_ID | NUMBER | |||
| SERVICE_REQUEST | VARCHAR2 | (64) | ||
| WIP_REWORK_ID | NUMBER | |||
| REWORK_JOB | VARCHAR2 | (240) | ||
| DISPOSITION_SOURCE | VARCHAR2 | (240) | ||
| DISPOSITION | VARCHAR2 | (240) | ||
| DISPOSITION_ACTION | VARCHAR2 | (240) | ||
| DISPOSITION_STATUS | VARCHAR2 | (240) | ||
| 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 | |||
| MAINTENANCE_OP_SEQ | NUMBER | |||
| NONCONFORMANCE_SOURCE | VARCHAR2 | (150) | ||
| NONCONFORM_SEVERITY | VARCHAR2 | (150) | ||
| NONCONFORM_PRIORITY | VARCHAR2 | (150) | ||
| NONCONFORMANCE_TYPE | VARCHAR2 | (150) | ||
| NONCONFORMANCE_CODE | VARCHAR2 | (150) | ||
| DATE_OPENED | DATE | |||
| DATE_CLOSED | DATE | |||
| DAYS_TO_CLOSE | NUMBER | |||
| TO_SUBINVENTORY | VARCHAR2 | (240) | ||
| TO_LOCATOR_ID | NUMBER | |||
| TO_LOCATOR | VARCHAR2 | (2000) | ||
| TO_SUB_LOCATOR_TYPE | NUMBER | |||
| BILL_REFERENCE_ID | NUMBER | |||
| BILL_REFERENCE | VARCHAR2 | (2000) | ||
| ROUTING_REFERENCE_ID | NUMBER | |||
| ROUTING_REFERENCE | VARCHAR2 | (2000) | ||
| CONCURRENT_REQUEST_ID | NUMBER | |||
| LOT_STATUS_ID | NUMBER | |||
| SERIAL_STATUS_ID | NUMBER | |||
| NONCONFORMANCE_STATUS | VARCHAR2 | (150) | ||
| RCV_TRANSACTION_ID | NUMBER | |||
| LOT_STATUS | VARCHAR2 | (30) | ||
| SERIAL_STATUS | VARCHAR2 | (80) | ||
| REQUEST_STATUS | VARCHAR2 | (150) | ||
| REQUEST_SOURCE | VARCHAR2 | (150) | ||
| REQUEST_PRIORITY | VARCHAR2 | (150) | ||
| REQUEST_SEVERITY | VARCHAR2 | (150) | ||
| ECO_NAME | VARCHAR2 | (150) | ||
| FOLLOWUP_ACTIVITY_ID | NUMBER | |||
| FOLLOWUP_ACTIVITY | VARCHAR2 | (2000) | ||
| XFR_LPN_ID | NUMBER | |||
| XFR_LICENSE_PLATE_NUMBER | VARCHAR2 | (30) | ||
| REPAIR_LINE_ID | NUMBER | |||
| REPAIR_ORDER_NUMBER | VARCHAR2 | (30) | ||
| JTF_TASK_ID | NUMBER | |||
| JTF_TASK_NUMBER | VARCHAR2 | (30) | ||
| ASSET_INSTANCE_ID | NUMBER | |||
| ASSET_INSTANCE_NUMBER | VARCHAR2 | (30) | ||
| PROCESS_BATCH_ID | NUMBER | |||
| PROCESS_BATCH_NUM | VARCHAR2 | (32) | ||
| PROCESS_BATCHSTEP_ID | NUMBER | |||
| PROCESS_BATCHSTEP_NUM | NUMBER | |||
| PROCESS_OPERATION_ID | NUMBER | |||
| PROCESS_OPERATION | VARCHAR2 | (57) | ||
| PROCESS_ACTIVITY_ID | NUMBER | |||
| PROCESS_ACTIVITY | VARCHAR2 | (16) | ||
| PROCESS_RESOURCE_ID | NUMBER | |||
| PROCESS_RESOURCE | VARCHAR2 | (16) | ||
| PROCESS_PARAMETER_ID | NUMBER | |||
| PROCESS_PARAMETER | VARCHAR2 | (40) | ||
| OPERATING_UNIT_ID | NUMBER | |||
| OPERATING_UNIT | VARCHAR2 | (240) |
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#;
QA
QA_RESULTS_INTERFACE
APPS
QA_RESULTS_INTERFACE
|
|
|
|