2008年10月14日星期二

查询有7.5中效日程程序

查询有效日程
for each scx_ref no-lock where scx_domain = "01" and scx_type = 1,
each sch_mstr no-lock where sch_domain = scx_domain and sch_nbr = scx_order and sch_line = scx_line and sch_type = 3, each schd_det no-lock where schd_domain = sch_domain and schd_nbr = sch_nbr and schd_line = sch_line and schd_rlse_id = sch_rlse_id and schd_type = sch_type and schd_type = 3 and schd_reference = "s", each sod_det no-lock where sod_domain = schd_domain and sod_nbr = schd_nbr and sod_line = schd_line and sod_curr_rlse_id[3] = sch_rlse_id : display scx_part scx_order scx_line schd_upd_qty schd_time schd_date.

没有评论: