获取工艺路线sql

select ood.organization_name,
       msi.segment1 as "物料",
       msi.description as "描述",
       msi.primary_uom_code as "单位",
       bor.alternate_routing_designator as "替代项",
       nvl(bor.ctp_flag, 2) as "可承诺能力",
       bor.attribute1 as "Organization",
       bor.attribute2 as "BASELINE",
       mri.process_revision as "版本",
       mri.effectivity_date as "有效日期",
       mri.implementation_date as "实施日期",
       mri.change_notice as "ECO-版本",
       seq.operation_seq_num as "序号",
       bd.department_code as "部门",
       seq.effectivity_date as "有效日期",
       seq.disable_date as "禁用日期",
       decode(seq.count_point_type, 1, 1, 2) as "计数点",
       decode(seq.count_point_type, 3, 2, 1) as "自动计费",
       seq.backflush_flag as "倒冲",
       seq.minimum_transfer_quantity as "最小传送数量",
       seq.yield AS "产出率",
       seq.cumulative_yield as "累计产出率",
       seq.include_in_rollup as "包括在累计中",
       decode(seq.implementation_date, null, 2, 1) as "已实施",