ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN E811F942597A2075E0530100007FF4F2 Blitz Upload Mode Y select xxen_upload.action_create id, xxen_upload.action_meaning(xxen_upload.action_create) value, null description from dual union all select xxen_upload.action_create || ',' || xxen_upload.action_update id, xxen_upload.action_meaning(xxen_upload.action_create)||', '||xxen_upload.action_meaning(xxen_upload.action_update) value, null description from dual US 4D270E0AC6EF21EBE0630100007F194B 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(+) Y U A xxen_qa_upload.collection_element US QA Collection Element Upload 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, and actions are not managed by this upload. Datatype cannot be changed after initial creation. Enginatics Upload 1=1 1 10 1=1 :p_upload_mode like '%' || xxen_upload.action_update LOV Blitz Upload Mode E811F942597A2075E0530100007FF4F2 Y select xxen_upload.action_create id, xxen_upload.action_meaning(xxen_upload.action_create) value, null description from dual union all select xxen_upload.action_create || ',' || xxen_upload.action_update id, xxen_upload.action_meaning(xxen_upload.action_create)||', '||xxen_upload.action_meaning(xxen_upload.action_update) value, null description from dual C Y US Upload Mode 2 20 1=1 qc.name>=:p_element_from LOV custom select qc.name value, xxen_util.meaning(qc.char_type_code,'ELEMENT_TYPE',3) description from qa_chars qc where qc.char_context_flag=1 order by qc.name US Collection Element From 3 30 1=1 qc.name<=:p_element_to LOV custom select qc.name value, xxen_util.meaning(qc.char_type_code,'ELEMENT_TYPE',3) description from qa_chars qc where qc.char_context_flag=1 order by qc.name US Collection Element To 1 ACTION_ Char varchar2 2 STATUS_ Char varchar2 3 MESSAGE_ Char varchar2 4 MODIFIED_COLUMNS_ Char varchar2 Y 5 NAME Char varchar2 Y 6 ELEMENT_TYPE LOV custom varchar2 Y select flvv.lookup_code id, flvv.meaning value, flvv.description from fnd_lookup_values_vl flvv where flvv.lookup_type='ELEMENT_TYPE' and flvv.view_application_id=3 and flvv.security_group_id=0 and flvv.enabled_flag='Y' order by flvv.meaning Y 7 DATATYPE LOV custom varchar2 Y select to_number(flvv.lookup_code) id, flvv.meaning value, flvv.description from fnd_lookup_values_vl flvv where flvv.lookup_type='QA_CHAR_DATATYPE' and flvv.view_application_id=700 and flvv.security_group_id=0 and flvv.enabled_flag='Y' order by to_number(flvv.lookup_code) Y 8 PROMPT Char varchar2 9 DISPLAY_LENGTH Number number 10 DECIMAL_PRECISION Number number 11 MANDATORY LOV custom varchar2 Y select fl.lookup_code id, fl.meaning value, null description from fnd_lookups fl where fl.lookup_type='YES_NO' order by fl.meaning Y 12 ENABLED LOV custom varchar2 Y select fl.lookup_code id, fl.meaning value, null description from fnd_lookups fl where fl.lookup_type='YES_NO' order by fl.meaning Y 13 UOM_CODE LOV custom varchar2 select muom.uom_code value, muom.unit_of_measure description from mtl_units_of_measure muom where nvl(muom.disable_date,sysdate+1)>sysdate order by muom.uom_code 14 UNIT_OF_MEASURE Char varchar2 Y 15 DEFAULT_VALUE Char varchar2 16 DATA_ENTRY_HINT Char varchar2 17 SQL_VALIDATION_STRING Char varchar2 18 SEQUENCE_PREFIX Char varchar2 19 SEQUENCE_SUFFIX Char varchar2 20 SEQUENCE_SEPARATOR Char varchar2 21 SEQUENCE_START Number number 22 SEQUENCE_INCREMENT Number number 23 NUMBER_SEGMENT_LENGTH Number number 24 ZERO_PAD LOV custom varchar2 select fl.lookup_code id, fl.meaning value, null description from fnd_lookups fl where fl.lookup_type='YES_NO' order by fl.meaning 25 DELETE_RECORD LOV custom varchar2 select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual where :$column$.name is not null 26 CHAR_ID Number number Y U 1 p_name in Char NAME U 2 p_element_type in Char ELEMENT_TYPE U 3 p_datatype in Number DATATYPE U 4 p_prompt in Char PROMPT U 5 p_display_length in Number DISPLAY_LENGTH U 6 p_decimal_precision in Number DECIMAL_PRECISION U 7 p_mandatory in Char MANDATORY U 8 p_enabled in Char ENABLED U 9 p_uom_code in Char UOM_CODE U 10 p_default_value in Char DEFAULT_VALUE U 11 p_data_entry_hint in Char DATA_ENTRY_HINT U 12 p_sql_validation_string in Char SQL_VALIDATION_STRING U 13 p_sequence_prefix in Char SEQUENCE_PREFIX U 14 p_sequence_suffix in Char SEQUENCE_SUFFIX U 15 p_sequence_separator in Char SEQUENCE_SEPARATOR U 16 p_sequence_start in Number SEQUENCE_START U 17 p_sequence_increment in Number SEQUENCE_INCREMENT U 18 p_sequence_length in Number NUMBER_SEGMENT_LENGTH U 19 p_zero_pad in Char ZERO_PAD U 20 p_delete_record in Char DELETE_RECORD U 21 status_ out Char STATUS_CODE_ U 22 message_ out Char MESSAGE_ Error SQL Order By name Success SQL select xu.action_, xu.status_, xu.message_, xu.modified_columns_, nvl(qc.name,xu.name) 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, xu.delete_record, qc.char_id from xxen_qa_collection_elem_9876_u xu, qa_chars qc, mtl_units_of_measure muom where xu.status_code_='S' and xu.name=qc.name(+) and qc.uom_code=muom.uom_code(+) LOV query :$column$.name NAME DELETE_RECORD Value to id query :$column$.name NAME p_delete_record