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,