QA — Quality
63 documented tables · 93 views — Oracle EBS ETRM 12.2.2
Most-referenced tables
| Table | Description | Data Vault class* |
|---|---|---|
QA_PLANS |
Collection plan definitions | hub |
QA_CHARS |
Collection elements definitions | hub |
QA_SL_SP_RCV_CRITERIA |
Skip Lot/Sampling Criteria for Receiving | hub-leaning |
QA_SKIPLOT_PROCESS_PLANS |
Skip Lot Process Plans | satellite-leaning |
QA_SKIPLOT_PROCESSES |
Skip lot processes | hub-leaning |
QA_CRITERIA_HEADERS |
Header table for Criterias | hub-leaning |
QA_SAMPLING_PLANS |
Sampling Plans | hub-leaning |
QA_PC_PLAN_RELATIONSHIP |
This table stores the parent plan id and the child plan id, along with the relation type and a flag to indicat | satellite-leaning |
QA_SKIPLOT_RCV_RESULTS |
Skip Lot Inspection Results for Receiving | satellite-leaning |
QA_ACTIONS |
Defines Oracle Quality actions | hub-leaning |
QA_CAR_TYPES |
Intended to be used in future for corrective action functionality | hub-leaning |
QA_SPECS |
Defines Quality Specifications | hub-leaning |
QA_RESULTS |
Quality Results data repository | satellite-leaning |
QA_CHAR_ACTIONS |
Defines collection elements and actions assigned to them | satellite-leaning |
QA_PLAN_CHAR_ACTIONS |
Stores actions assigned to collection elements for collection plans | satellite-leaning |
*Heuristic classification mined from FK structure — a modeling suggestion, not Oracle's.
Key public APIs
| Package | Class | Procedures | Used by |
|---|---|---|---|
QA_PLAN_ELEMENT_API |
API | 168 | 22 packages |
QA_CHARS_API |
API | 26 | 20 packages |
QA_RESULT_GRP |
GRP | 8 | 11 packages |
QA_VALIDATION_API |
API | 15 | 8 packages |
QA_TXN_GRP |
GRP | 47 | 7 packages |
QA_SEQUENCE_API |
API | 16 | 7 packages |
QA_WEB_TXN_API |
API | 10 | 6 packages |
QA_RESULTS_PUB |
PUB | 4 | 6 packages |
QA_PLANS_API |
API | 8 | 5 packages |
QA_SKIPLOT_RCV_GRP |
GRP | 5 | 3 packages |