QA Collection Element Upload
Description
Categories: Enginatics, Upload
Repository: Github
Repository: Github
Upload to create, update, or delete Quality Collection Elements (QA_CHARS).
This upload manages user-defined collection elements including:
- Element name, type, datatype, prompt, display length
- Mandatory/Enabled flags
- UOM, default value, data entry hint, SQL validation string
- Sequence configuration (for Sequence datatype elements)
Note: Specification limits, values ... more
This upload manages user-defined collection elements including:
- Element name, type, datatype, prompt, display length
- Mandatory/Enabled flags
- UOM, default value, data entry hint, SQL validation string
- Sequence configuration (for Sequence datatype elements)
Note: Specification limits, values ... more
select null action_, null status_, null message_, null modified_columns_, qc.name, xxen_util.meaning(qc.char_type_code,'ELEMENT_TYPE',3) element_type, xxen_util.meaning(qc.datatype,'QA_CHAR_DATATYPE',700) datatype, qc.prompt, qc.display_length, qc.decimal_precision, xxen_util.meaning(decode(qc.mandatory_flag,1,'Y','N'),'YES_NO',0) mandatory, xxen_util.meaning(decode(qc.enabled_flag,1,'Y','N'),'YES_NO',0) enabled, qc.uom_code, muom.unit_of_measure, qc.default_value, qc.data_entry_hint, qc.sql_validation_string, qc.sequence_prefix, qc.sequence_suffix, qc.sequence_separator, qc.sequence_start, qc.sequence_increment, qc.sequence_length number_segment_length, xxen_util.meaning(decode(qc.sequence_zero_pad,1,'Y','N'),'YES_NO',0) zero_pad, null delete_record, qc.char_id from qa_chars qc, mtl_units_of_measure muom where 1=1 and qc.char_context_flag=1 and qc.uom_code=muom.uom_code(+) |
| Parameter Name | SQL text | Validation | |
|---|---|---|---|
| Upload Mode |
| LOV | |
| Collection Element From |
| LOV | |
| Collection Element To |
| LOV |