2024年3月10日发(作者:)
_start_days,
_end_days,
_start_hours,
_end_hours,
_start_days,
_end_days,
_start_hours,
_end_hours,
_flag,
_priority,
tion_method,
ock_criteria_id,
c_replenishment_flag,
_id,
_name
FROM (SELECT picking_rule_name,
ders_only_flag,
decode(g,
'Exclude',
'Unreleased',
'Include',
'All',
'Only',
'Backordered') backorders,
g shipment_priority,
nt_priority_code,
zation_id,
zation_id org_id,
zation_id warehouse_id_lov,
h_org_ warehouse,
zation_code warehouse_code,
decode(ng_rsvs_only_flag, 'Y', '*' , NULL) reservation_star,
ng_rsvs_only_flag,
_method_code,
_scheduled_ship_date,
_scheduled_ship_date,
_requested_date,
_requested_date,
order_type,
_type_id,
to_char(_number) order_number,
_header_id,
_name ship_set_number,
ory_item_id,
ption item_description,
substrb(_name, 1, 50 ) customer_name,
substrb(_name, 1, 50 ) old_customer_name,
er_id,
_location_code ship_to_location,
_to_location_id,
e_planned_lines,
eate_delivery_flag,
pick_grouping_rule_name,
pick_seq_rule_name,
_id,
t_id,
tail_pr_flag,
_pick_confirm_flag,
_set_number ship_set_id,
_location_code ship_from_location,
_from_location_id,
nt_set_id,
doc_name,
_from_subinventory,
_from_locator_id,
NULL pick_from_locator,
t_stage_subinventory,
t_stage_locator_id,
NULL default_stage_locator,
g ship_method_meaning,
ck_flag,
ck_level,
_confirm_rule_id,
ship_confirm_rule_name,
_planning_flag,
_id,
_id,
_delivery_criteria,
_subinventory,
ry_set_id,
ry_id,
_start_days,
_end_days,
_start_hours,
发布评论