QA Tables (63)
QA - Quality — documented tables from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.
| Table | Columns | Description |
|---|---|---|
QA_ACTIONS |
10 | Defines Oracle Quality actions |
QA_ACTION_LOG |
38 | Log table for actions |
QA_AHL_MR_DUMMY |
10 | A dummy table to mirror ahl_mr_headers_b. Oracle Internal use only - reserved for future use. |
QA_BIS_RESULTS |
25 | BIS Summary Table |
QA_BIS_UPDATE_HISTORY |
11 | BIS Summary Table Update History |
QA_BUG1339720_METHOD |
3 | Used as a temporary resource in Bug 1339720 |
QA_BUG1339720_TEMP |
2 | Used as a temporary resource in Bug 1339720 |
QA_CAR_TYPES |
8 | Intended to be used in future for corrective action functionality |
QA_CHARS |
70 | Collection elements definitions |
QA_CHART_CONSTANTS |
13 | Stores different costants used for chart calculations |
QA_CHART_CONTROL |
16 | Special charting table for control chart type. |
QA_CHART_DATA |
11 | Temporary table to store chart calculations |
QA_CHART_GENERIC |
10 | Table to keep data points of a chart to be plotted. |
QA_CHART_HEADERS |
17 | Table to keep an instance of a chart to be plotted. |
QA_CHAR_ACTIONS |
16 | Defines collection elements and actions assigned to them |
QA_CHAR_ACTION_OUTPUTS |
8 | Stores mapping between tokens and collection elements |
QA_CHAR_ACTION_TRIGGERS |
15 | Defines collection elements action triggers or rule |
QA_CHAR_INDEXES |
15 | Collection Element User-Defined Indexes. This table keeps track of information about user-defined indexes created on collection elements. |
QA_CHAR_VALUE_LOOKUPS |
26 | Stores set of permissible values for collection elements |
QA_CONTROL_LIMITS |
21 | Stores control limits for charts |
QA_CRITERIA |
18 | Stores "show results where" criteria for chart, Quality Dynamic Reportwriter etc. |
QA_CRITERIA_HEADERS |
24 | Header table for Criterias |
QA_CSI_ITEM_INSTANCES_DUMMY |
17 | Dummy table that mirrors a subset of csi_item_instances. Oracle Internal use only - reserved for future use |
QA_DEVICE_DATA_VALUES |
11 | Device event data |
QA_DEVICE_INFO |
13 | Device setup information |
QA_GRANTED_PRIVILEGES |
13 | Granted privileges for data security project |
QA_INTERFACE_ERRORS |
12 | Stores errors encountered during collection import |
QA_IN_LISTS |
11 | Stores in lists definitions |
QA_MQA_LOT_SERIAL_TEMP |
3 | Temporary table used in mobile application |
QA_PC_CRITERIA |
14 | This table stores criteria for the child plans to be applicable |
QA_PC_ELEMENT_RELATIONSHIP |
12 | This table stores the relationships between parent and child plan elements |
QA_PC_PLAN_RELATIONSHIP |
14 | This table stores the parent plan id and the child plan id, along with the relation type and a flag to indicate if the child plan is mandato |
QA_PC_RESULTS_RELATIONSHIP |
13 | This table stores the relationship between two parent and child result rows. |
QA_PLANS |
39 | Collection plan definitions |
QA_PLAN_CHARS |
41 | Stores collection plans and their assigned collection elements |
QA_PLAN_CHAR_ACTIONS |
19 | Stores actions assigned to collection elements for collection plans |
QA_PLAN_CHAR_ACTION_OUTPUTS |
9 | Stores mapping between output variables and collection elements in a plan |
QA_PLAN_CHAR_ACTION_TRIGGERS |
17 | Defines action triggers defined in a collection plan |
QA_PLAN_CHAR_VALUE_LOOKUPS |
27 | Contains set of permissible values for a collection elements in a collection plan |
QA_PLAN_COLLECTION_TRIGGERS |
14 | Defines collection plan triggers for Quality Collection transactions |
QA_PLAN_TRANSACTIONS |
13 | Stores information on Quality Collection Plan and the Quality Collection transactions, the plan is associated with |
QA_RESULTS |
236 | Quality Results data repository |
QA_RESULTS_INTERFACE |
309 | Quality Results Interface table for collection import |
QA_RESULTS_UPDATE_HISTORY |
14 | Stores history of collection import |
QA_SAMPLING_ASSOCIATION |
11 | Skip Lot/Sampling Criteria to Sampling Plan association |
QA_SAMPLING_CUSTOM_RULES |
10 | User-defined sampling rules |
QA_SAMPLING_INSP_LEVEL |
10 | Sampling inspection level |
QA_SAMPLING_PLANS |
12 | Sampling Plans |
QA_SAMPLING_STD_RULES |
14 | Seeded sampling standard rules |
QA_SEQ_AUDIT_HISTORY |
16 | Audit table for sequences |
QA_SKIPLOT_ASSOCIATION |
13 | Skip Lot Criteria-Process Association |
QA_SKIPLOT_LOG |
9 | Skip Lot Logs |
QA_SKIPLOT_LOT_PLANS |
17 | Skip Lot Lot-Inspection Results per Plan |
QA_SKIPLOT_PLAN_STATES |
15 | Skip Lot Process Plan States |
QA_SKIPLOT_PROCESSES |
11 | Skip lot processes |
QA_SKIPLOT_PROCESS_PLANS |
9 | Skip Lot Process Plans |
QA_SKIPLOT_PROCESS_PLAN_RULES |
12 | Skip Lot Process Skipping Parameters |
QA_SKIPLOT_RCV_RESULTS |
20 | Skip Lot Inspection Results for Receiving |
QA_SKIPLOT_STATE_HISTORY |
12 | Skip Lot Inspection History |
QA_SL_SP_RCV_CRITERIA |
15 | Skip Lot/Sampling Criteria for Receiving |
QA_SPECS |
38 | Defines Quality Specifications |
QA_SPEC_CHARS |
32 | Defines specification and specification elements |
QA_TXN_COLLECTION_TRIGGERS |
13 | Define information on applicability of a collection plan for a Quality Collection transaction |