HDM系统模板配置信息查询

最新推荐文章于 2024-05-28 13:09:10 发布

BlackHeart1203

最新推荐文章于 2024-05-28 13:09:10 发布

阅读量1.1k

点赞数 1

本文链接：https://blog.csdn.net/u010304907/article/details/79553346

版权

HDM模板基础配置信息查询

SELECT to_char(hdt.idx) IDXI
      ,hdt.name TMP_NAME
      ,(SELECT htt.name
          FROM hbi_dcm_template_type_b htt
         WHERE 1 = 1
           AND htt.template_type_id = hdt.template_type_id) TMP_type
      ,decode(hdt.template_column_type,'0','普通模板','1','固定行模板') template_column_type
      ,decode(hdt.create_type
             ,'0'
             ,'自定义'
             ,'1'
             ,'从数据库选择表'
             ,'2'
             ,'从数据库选择视图') create_type

      ,hdt.db_table db_table
      ,hdt.data_start_cell
      ,hdt.data_start_line
      ,hdt.template_extend_role template_extend_role
      ,decode(hdt.handle_mode
             ,'1'
             ,'替换'
             ,'2'
             ,'追加'
             ,'3'
             ,'更新'
             ,hdt.handle_mode) handle_mode
      ,(SELECT hdc.name
          FROM hbi_dcm_combination_b hdc
         WHERE 1 = 1
           AND hdc.combination_id = hdt.combination_id) combination
      ,hdt.activiti_key activiti_key
      ,hdt.description description
       ,'checked' approve_status_
      ,'' batch_id_
      ,sys_guid() row_num_
      ,'' combination_permission_id_
      ,rank() over(ORDER BY hdt.idx) idx
  FROM hbi_dcm_template_b hdt
 WHERE 1 = 1;

HDM模板关联计算程序查询

SELECT (SELECT nvl(tt2.name, t.template_id)
          FROM hbi_dcm_template_b tt2
         WHERE 1 = 1
           AND tt2.template_id = t.template_id) TMP_NAME
       ,(SELECT decode(tt2.template_column_type,0,'普通模板',1,'固定行模板')
          FROM hbi_dcm_template_b tt2
         WHERE 1 = 1
           AND tt2.template_id = t.template_id) template_column_type
      ,(SELECT nvl(tt.calculate_name, t.calculate_id)
          FROM hbi_dcm_calculate_b tt
         WHERE tt.calculate_id = t.calculate_id) CALC_NAME
      ,(SELECT nvl(tt.calculate_code, t.calculate_id)
          FROM hbi_dcm_calculate_b tt
         WHERE tt.calculate_id = t.calculate_id) CALC_CODE
      ,(SELECT tt.description
          FROM hbi_dcm_calculate_b tt
         WHERE tt.calculate_id = t.calculate_id) CALC_DESCRIPTION
      ,t.run_style run_style
      ,t.params params
      ,to_char(seq) seq
      ,'checked' approve_status_
      ,'' batch_id_
      ,sys_guid() row_num_
      ,'' combination_permission_id_
      ,rank() over(ORDER BY template_id) idx
  FROM hbi_dcm_calculate_link_temp t
 WHERE 1 = 1;

HDM模板关联值集校验查询

SELECT (SELECT hdt.name
          FROM hbi_dcm_template_b hdt
         WHERE hdt.template_id = hsb.template_id) TMP_NAME
      ,(SELECT t1.name
          FROM hbi_dcm_template_column_b t1
         WHERE 1 = 1
           AND t1.template_column_id = hsb.template_column_id) COL_NAME
      ,(SELECT t2.db_table_col
          FROM hbi_dcm_template_column_b t2
         WHERE 1 = 1
           AND t2.template_column_id = hsb.template_column_id) COL_CODE
      ,(SELECT t3.name
          FROM hbi_dcm_dimension_b t3
         WHERE 1 = 1
           AND t3.dimension_id = hsb.dimension_id) SET_NAME
      ,hsb.dimension_value_field  VALID_SOURCE
      ,hsb.dimension_mapping_field  VALID_TARGET
      ,'checked' approve_status_
      ,'' batch_id_
      ,sys_guid() row_num_
      ,'' combination_permission_id_
      ,rank() over(ORDER BY template_id) idx
  FROM hbi_dcm_value_set_validation hsb;

HDM模板关联SQL校验程序查询

SELECT (SELECT hdt.name
          FROM hbi_dcm_template_b hdt
         WHERE hdt.template_id = hsb.template_id) TMP_NAME
      ,(SELECT t1.name
          FROM hbi_dcm_template_column_b t1
         WHERE 1 = 1
           AND t1.template_column_id = hsb.column_id) COL_NAME
      ,(SELECT t2.db_table_col
          FROM hbi_dcm_template_column_b t2
         WHERE 1 = 1
           AND t2.template_column_id = hsb.column_id) COL_CODE
      ,(SELECT t3.validation_name
          FROM hbi_dcm_validation_sql_b t3
         WHERE 1 = 1
           AND t3.validation_id = hsb.validation_id) valid_name
      ,(SELECT t4.program
          FROM hbi_dcm_validation_sql_b t4
         WHERE 1 = 1
           AND t4.validation_id = hsb.validation_id) valid_CODE
      ,(SELECT t5.description
          FROM hbi_dcm_validation_sql_b t5
         WHERE 1 = 1
           AND t5.validation_id = hsb.validation_id) valid_DESC
      ,hsb.params params
      ,to_char(hsb.seq) seq
      ,'checked' approve_status_
      ,'' batch_id_
      ,sys_guid() row_num_
      ,'' combination_permission_id_
      ,rank() over(ORDER BY template_id) idx
  FROM hbi_dcm_temp_vali_sql_b hsb
 WHERE 1 = 1;

HDM模板关联ODI场景查询

SELECT (SELECT nvl(tt2.name, t.template_id)
          FROM hbi_dcm_template_b tt2
         WHERE 1 = 1
           AND tt2.template_id = t.template_id) TMP_NAME
      ,(SELECT tt.scene_name
          FROM hbi_dcm_scene_b tt
         WHERE 1 = 1
           AND tt.scene_id = t.scene_id) scene_name
      ,(SELECT tt.scene_alias
          FROM hbi_dcm_scene_b tt
         WHERE 1 = 1
           AND tt.scene_id = t.scene_id) scene_alias
      ,t.project_name project_name
      ,t.custom_args custom_args
      ,to_char(t.seq) seq
      ,'checked' approve_status_
      ,'' batch_id_
      ,sys_guid() row_num_
      ,'' combination_permission_id_
      ,rank() over(ORDER BY template_id) idx
  FROM hdm_template_scene t;