查询税则

--查询税则详细信息
      select zr.service_type_code 税则分类,
                 ZR.TAX_RULE_ID 税则ID,
                 zr.tax_rule_code 税则代码, 
                 zr.tax_regime_code 税制,
                 zr.tax 税,
                 zr.effective_from 启用日期,
                 zr.priority 顺序,
                 zr.det_factor_templ_code 决定性因素集代码,
                 zr.enabled_flag 启用,
                 zc.condition_group_code 条件集,
                 zpr.priority 顺序,
                 zpr.alphanumeric_result 结果,
                 zpr.enabled_flag 启用,
                 zcg.determining_factor_class1_code 决定性因素分类,
                 zcg.determining_factor_code1 决定性因素名称,
                 zcg.determining_factor_cq1_code 分类限定词,
                 zcg.operator1_code 运算符,
                 zcg.value_low1 范围自,
                 zcg.value_high1 范围至,
                 om.PARTY_NAME 配置责任人
       from zx_rules_b zr,
                zx_det_factor_templ_b zdft,
                zx_det_factor_templ_dtl zdftd,
                zx_conditions zc,
                zx_condition_groups_b zcg,
                zx_process_results zpr,
              ZX_FIRST_PARTY_ORGS_MOAC_V  om
      where zr.tax_rule_id=zpr.tax_rule_id
      and zpr.condition_group_code=zcg.condition_group_code
      and zdft.det_factor_templ_code=zcg.det_factor_templ_code
      and zc.condition_group_code=zcg.condition_group_code
      and zdft.det_factor_templ_id=zdftd.det_factor_templ_id
      and zr.content_owner_id=om.PARTY_TAX_PROFILE_ID
    --and zr.content_owner_id=om.PARTY_TAX_PROFILE_ID(+)
      and zr.service_type_code='DET_TAX_RATE'
      and zr.tax_rule_code=nvl('&tax_rule_code', zr.tax_rule_code)
      ;