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 &
获取工艺路线sql
最新推荐文章于 2022-11-30 19:27:32 发布