45: */
46:
47: TYPE line_cont_info IS RECORD (
48: group_id NUMBER,
49: organization_id WSH_DELIVERY_DETAILS.organization_id%TYPE,
50: fill_pc_basis WSH_SHIPPING_PARAMETERS.percent_fill_basis_flag%TYPE,
51: process_flag VARCHAR2(1),
52: inventory_item_id WSH_DELIVERY_DETAILS.inventory_item_id%TYPE,
53: indivisible_flag MTL_SYSTEM_ITEMS.indivisible_flag%TYPE,
48: group_id NUMBER,
49: organization_id WSH_DELIVERY_DETAILS.organization_id%TYPE,
50: fill_pc_basis WSH_SHIPPING_PARAMETERS.percent_fill_basis_flag%TYPE,
51: process_flag VARCHAR2(1),
52: inventory_item_id WSH_DELIVERY_DETAILS.inventory_item_id%TYPE,
53: indivisible_flag MTL_SYSTEM_ITEMS.indivisible_flag%TYPE,
54: delivery_detail_id WSH_DELIVERY_DETAILS.delivery_detail_id%TYPE,
55: shp_qty WSH_DELIVERY_DETAILS.shipped_quantity%TYPE,
56: req_qty WSH_DELIVERY_DETAILS.requested_quantity%TYPE,
50: fill_pc_basis WSH_SHIPPING_PARAMETERS.percent_fill_basis_flag%TYPE,
51: process_flag VARCHAR2(1),
52: inventory_item_id WSH_DELIVERY_DETAILS.inventory_item_id%TYPE,
53: indivisible_flag MTL_SYSTEM_ITEMS.indivisible_flag%TYPE,
54: delivery_detail_id WSH_DELIVERY_DETAILS.delivery_detail_id%TYPE,
55: shp_qty WSH_DELIVERY_DETAILS.shipped_quantity%TYPE,
56: req_qty WSH_DELIVERY_DETAILS.requested_quantity%TYPE,
57: shp_qty2 WSH_DELIVERY_DETAILS.shipped_quantity%TYPE,
58: req_qty2 WSH_DELIVERY_DETAILS.requested_quantity%TYPE,
51: process_flag VARCHAR2(1),
52: inventory_item_id WSH_DELIVERY_DETAILS.inventory_item_id%TYPE,
53: indivisible_flag MTL_SYSTEM_ITEMS.indivisible_flag%TYPE,
54: delivery_detail_id WSH_DELIVERY_DETAILS.delivery_detail_id%TYPE,
55: shp_qty WSH_DELIVERY_DETAILS.shipped_quantity%TYPE,
56: req_qty WSH_DELIVERY_DETAILS.requested_quantity%TYPE,
57: shp_qty2 WSH_DELIVERY_DETAILS.shipped_quantity%TYPE,
58: req_qty2 WSH_DELIVERY_DETAILS.requested_quantity%TYPE,
59: req_qty_uom WSH_DELIVERY_DETAILS.requested_quantity_uom%TYPE,
52: inventory_item_id WSH_DELIVERY_DETAILS.inventory_item_id%TYPE,
53: indivisible_flag MTL_SYSTEM_ITEMS.indivisible_flag%TYPE,
54: delivery_detail_id WSH_DELIVERY_DETAILS.delivery_detail_id%TYPE,
55: shp_qty WSH_DELIVERY_DETAILS.shipped_quantity%TYPE,
56: req_qty WSH_DELIVERY_DETAILS.requested_quantity%TYPE,
57: shp_qty2 WSH_DELIVERY_DETAILS.shipped_quantity%TYPE,
58: req_qty2 WSH_DELIVERY_DETAILS.requested_quantity%TYPE,
59: req_qty_uom WSH_DELIVERY_DETAILS.requested_quantity_uom%TYPE,
60: detail_cont_item_id WSH_DELIVERY_DETAILS.detail_container_item_id%TYPE,
53: indivisible_flag MTL_SYSTEM_ITEMS.indivisible_flag%TYPE,
54: delivery_detail_id WSH_DELIVERY_DETAILS.delivery_detail_id%TYPE,
55: shp_qty WSH_DELIVERY_DETAILS.shipped_quantity%TYPE,
56: req_qty WSH_DELIVERY_DETAILS.requested_quantity%TYPE,
57: shp_qty2 WSH_DELIVERY_DETAILS.shipped_quantity%TYPE,
58: req_qty2 WSH_DELIVERY_DETAILS.requested_quantity%TYPE,
59: req_qty_uom WSH_DELIVERY_DETAILS.requested_quantity_uom%TYPE,
60: detail_cont_item_id WSH_DELIVERY_DETAILS.detail_container_item_id%TYPE,
61: master_cont_item_id WSH_DELIVERY_DETAILS.master_container_item_id%TYPE,
54: delivery_detail_id WSH_DELIVERY_DETAILS.delivery_detail_id%TYPE,
55: shp_qty WSH_DELIVERY_DETAILS.shipped_quantity%TYPE,
56: req_qty WSH_DELIVERY_DETAILS.requested_quantity%TYPE,
57: shp_qty2 WSH_DELIVERY_DETAILS.shipped_quantity%TYPE,
58: req_qty2 WSH_DELIVERY_DETAILS.requested_quantity%TYPE,
59: req_qty_uom WSH_DELIVERY_DETAILS.requested_quantity_uom%TYPE,
60: detail_cont_item_id WSH_DELIVERY_DETAILS.detail_container_item_id%TYPE,
61: master_cont_item_id WSH_DELIVERY_DETAILS.master_container_item_id%TYPE,
62: gross_weight WSH_DELIVERY_DETAILS.gross_weight%TYPE,
55: shp_qty WSH_DELIVERY_DETAILS.shipped_quantity%TYPE,
56: req_qty WSH_DELIVERY_DETAILS.requested_quantity%TYPE,
57: shp_qty2 WSH_DELIVERY_DETAILS.shipped_quantity%TYPE,
58: req_qty2 WSH_DELIVERY_DETAILS.requested_quantity%TYPE,
59: req_qty_uom WSH_DELIVERY_DETAILS.requested_quantity_uom%TYPE,
60: detail_cont_item_id WSH_DELIVERY_DETAILS.detail_container_item_id%TYPE,
61: master_cont_item_id WSH_DELIVERY_DETAILS.master_container_item_id%TYPE,
62: gross_weight WSH_DELIVERY_DETAILS.gross_weight%TYPE,
63: net_weight WSH_DELIVERY_DETAILS.net_weight%TYPE,
56: req_qty WSH_DELIVERY_DETAILS.requested_quantity%TYPE,
57: shp_qty2 WSH_DELIVERY_DETAILS.shipped_quantity%TYPE,
58: req_qty2 WSH_DELIVERY_DETAILS.requested_quantity%TYPE,
59: req_qty_uom WSH_DELIVERY_DETAILS.requested_quantity_uom%TYPE,
60: detail_cont_item_id WSH_DELIVERY_DETAILS.detail_container_item_id%TYPE,
61: master_cont_item_id WSH_DELIVERY_DETAILS.master_container_item_id%TYPE,
62: gross_weight WSH_DELIVERY_DETAILS.gross_weight%TYPE,
63: net_weight WSH_DELIVERY_DETAILS.net_weight%TYPE,
64: converted_wt WSH_DELIVERY_DETAILS.net_weight%TYPE,
57: shp_qty2 WSH_DELIVERY_DETAILS.shipped_quantity%TYPE,
58: req_qty2 WSH_DELIVERY_DETAILS.requested_quantity%TYPE,
59: req_qty_uom WSH_DELIVERY_DETAILS.requested_quantity_uom%TYPE,
60: detail_cont_item_id WSH_DELIVERY_DETAILS.detail_container_item_id%TYPE,
61: master_cont_item_id WSH_DELIVERY_DETAILS.master_container_item_id%TYPE,
62: gross_weight WSH_DELIVERY_DETAILS.gross_weight%TYPE,
63: net_weight WSH_DELIVERY_DETAILS.net_weight%TYPE,
64: converted_wt WSH_DELIVERY_DETAILS.net_weight%TYPE,
65: weight_uom WSH_DELIVERY_DETAILS.weight_uom_code%TYPE,
58: req_qty2 WSH_DELIVERY_DETAILS.requested_quantity%TYPE,
59: req_qty_uom WSH_DELIVERY_DETAILS.requested_quantity_uom%TYPE,
60: detail_cont_item_id WSH_DELIVERY_DETAILS.detail_container_item_id%TYPE,
61: master_cont_item_id WSH_DELIVERY_DETAILS.master_container_item_id%TYPE,
62: gross_weight WSH_DELIVERY_DETAILS.gross_weight%TYPE,
63: net_weight WSH_DELIVERY_DETAILS.net_weight%TYPE,
64: converted_wt WSH_DELIVERY_DETAILS.net_weight%TYPE,
65: weight_uom WSH_DELIVERY_DETAILS.weight_uom_code%TYPE,
66: volume WSH_DELIVERY_DETAILS.volume%TYPE,
59: req_qty_uom WSH_DELIVERY_DETAILS.requested_quantity_uom%TYPE,
60: detail_cont_item_id WSH_DELIVERY_DETAILS.detail_container_item_id%TYPE,
61: master_cont_item_id WSH_DELIVERY_DETAILS.master_container_item_id%TYPE,
62: gross_weight WSH_DELIVERY_DETAILS.gross_weight%TYPE,
63: net_weight WSH_DELIVERY_DETAILS.net_weight%TYPE,
64: converted_wt WSH_DELIVERY_DETAILS.net_weight%TYPE,
65: weight_uom WSH_DELIVERY_DETAILS.weight_uom_code%TYPE,
66: volume WSH_DELIVERY_DETAILS.volume%TYPE,
67: converted_vol WSH_DELIVERY_DETAILS.volume%TYPE,
60: detail_cont_item_id WSH_DELIVERY_DETAILS.detail_container_item_id%TYPE,
61: master_cont_item_id WSH_DELIVERY_DETAILS.master_container_item_id%TYPE,
62: gross_weight WSH_DELIVERY_DETAILS.gross_weight%TYPE,
63: net_weight WSH_DELIVERY_DETAILS.net_weight%TYPE,
64: converted_wt WSH_DELIVERY_DETAILS.net_weight%TYPE,
65: weight_uom WSH_DELIVERY_DETAILS.weight_uom_code%TYPE,
66: volume WSH_DELIVERY_DETAILS.volume%TYPE,
67: converted_vol WSH_DELIVERY_DETAILS.volume%TYPE,
68: volume_uom WSH_DELIVERY_DETAILS.volume_uom_code%TYPE,
61: master_cont_item_id WSH_DELIVERY_DETAILS.master_container_item_id%TYPE,
62: gross_weight WSH_DELIVERY_DETAILS.gross_weight%TYPE,
63: net_weight WSH_DELIVERY_DETAILS.net_weight%TYPE,
64: converted_wt WSH_DELIVERY_DETAILS.net_weight%TYPE,
65: weight_uom WSH_DELIVERY_DETAILS.weight_uom_code%TYPE,
66: volume WSH_DELIVERY_DETAILS.volume%TYPE,
67: converted_vol WSH_DELIVERY_DETAILS.volume%TYPE,
68: volume_uom WSH_DELIVERY_DETAILS.volume_uom_code%TYPE,
69: det_cont_qty WSH_DELIVERY_DETAILS.requested_quantity%TYPE,
62: gross_weight WSH_DELIVERY_DETAILS.gross_weight%TYPE,
63: net_weight WSH_DELIVERY_DETAILS.net_weight%TYPE,
64: converted_wt WSH_DELIVERY_DETAILS.net_weight%TYPE,
65: weight_uom WSH_DELIVERY_DETAILS.weight_uom_code%TYPE,
66: volume WSH_DELIVERY_DETAILS.volume%TYPE,
67: converted_vol WSH_DELIVERY_DETAILS.volume%TYPE,
68: volume_uom WSH_DELIVERY_DETAILS.volume_uom_code%TYPE,
69: det_cont_qty WSH_DELIVERY_DETAILS.requested_quantity%TYPE,
70: mast_max_load_qty WSH_CONTAINER_ITEMS.max_load_quantity%TYPE,
63: net_weight WSH_DELIVERY_DETAILS.net_weight%TYPE,
64: converted_wt WSH_DELIVERY_DETAILS.net_weight%TYPE,
65: weight_uom WSH_DELIVERY_DETAILS.weight_uom_code%TYPE,
66: volume WSH_DELIVERY_DETAILS.volume%TYPE,
67: converted_vol WSH_DELIVERY_DETAILS.volume%TYPE,
68: volume_uom WSH_DELIVERY_DETAILS.volume_uom_code%TYPE,
69: det_cont_qty WSH_DELIVERY_DETAILS.requested_quantity%TYPE,
70: mast_max_load_qty WSH_CONTAINER_ITEMS.max_load_quantity%TYPE,
71: source_line_id WSH_DELIVERY_DETAILS.source_line_id%TYPE,
64: converted_wt WSH_DELIVERY_DETAILS.net_weight%TYPE,
65: weight_uom WSH_DELIVERY_DETAILS.weight_uom_code%TYPE,
66: volume WSH_DELIVERY_DETAILS.volume%TYPE,
67: converted_vol WSH_DELIVERY_DETAILS.volume%TYPE,
68: volume_uom WSH_DELIVERY_DETAILS.volume_uom_code%TYPE,
69: det_cont_qty WSH_DELIVERY_DETAILS.requested_quantity%TYPE,
70: mast_max_load_qty WSH_CONTAINER_ITEMS.max_load_quantity%TYPE,
71: source_line_id WSH_DELIVERY_DETAILS.source_line_id%TYPE,
72: source_code WSH_DELIVERY_DETAILS.source_code%TYPE,
65: weight_uom WSH_DELIVERY_DETAILS.weight_uom_code%TYPE,
66: volume WSH_DELIVERY_DETAILS.volume%TYPE,
67: converted_vol WSH_DELIVERY_DETAILS.volume%TYPE,
68: volume_uom WSH_DELIVERY_DETAILS.volume_uom_code%TYPE,
69: det_cont_qty WSH_DELIVERY_DETAILS.requested_quantity%TYPE,
70: mast_max_load_qty WSH_CONTAINER_ITEMS.max_load_quantity%TYPE,
71: source_line_id WSH_DELIVERY_DETAILS.source_line_id%TYPE,
72: source_code WSH_DELIVERY_DETAILS.source_code%TYPE,
73: preferred_container WSH_CONTAINER_ITEMS.container_item_id%TYPE,
67: converted_vol WSH_DELIVERY_DETAILS.volume%TYPE,
68: volume_uom WSH_DELIVERY_DETAILS.volume_uom_code%TYPE,
69: det_cont_qty WSH_DELIVERY_DETAILS.requested_quantity%TYPE,
70: mast_max_load_qty WSH_CONTAINER_ITEMS.max_load_quantity%TYPE,
71: source_line_id WSH_DELIVERY_DETAILS.source_line_id%TYPE,
72: source_code WSH_DELIVERY_DETAILS.source_code%TYPE,
73: preferred_container WSH_CONTAINER_ITEMS.container_item_id%TYPE,
74: max_load_qty NUMBER,
75: cont_wt WSH_DELIVERY_DETAILS.net_weight%TYPE,
68: volume_uom WSH_DELIVERY_DETAILS.volume_uom_code%TYPE,
69: det_cont_qty WSH_DELIVERY_DETAILS.requested_quantity%TYPE,
70: mast_max_load_qty WSH_CONTAINER_ITEMS.max_load_quantity%TYPE,
71: source_line_id WSH_DELIVERY_DETAILS.source_line_id%TYPE,
72: source_code WSH_DELIVERY_DETAILS.source_code%TYPE,
73: preferred_container WSH_CONTAINER_ITEMS.container_item_id%TYPE,
74: max_load_qty NUMBER,
75: cont_wt WSH_DELIVERY_DETAILS.net_weight%TYPE,
76: delivery_id wsh_delivery_assignments_v.DELIVERY_ID%TYPE, -- anxsharm
71: source_line_id WSH_DELIVERY_DETAILS.source_line_id%TYPE,
72: source_code WSH_DELIVERY_DETAILS.source_code%TYPE,
73: preferred_container WSH_CONTAINER_ITEMS.container_item_id%TYPE,
74: max_load_qty NUMBER,
75: cont_wt WSH_DELIVERY_DETAILS.net_weight%TYPE,
76: delivery_id wsh_delivery_assignments_v.DELIVERY_ID%TYPE, -- anxsharm
77: -- HW OPMCONV - Change variable name from opm_lot_ind to lot_divisible_flag
78: lot_divisible_flag MTL_SYSTEM_ITEMS.lot_divisible_flag%TYPE,
79: cont_vol WSH_DELIVERY_DETAILS.volume%TYPE);
75: cont_wt WSH_DELIVERY_DETAILS.net_weight%TYPE,
76: delivery_id wsh_delivery_assignments_v.DELIVERY_ID%TYPE, -- anxsharm
77: -- HW OPMCONV - Change variable name from opm_lot_ind to lot_divisible_flag
78: lot_divisible_flag MTL_SYSTEM_ITEMS.lot_divisible_flag%TYPE,
79: cont_vol WSH_DELIVERY_DETAILS.volume%TYPE);
80:
81: -- table of line_cont_info records that stores delivery line information
82: -- of the lines that are selected for autopacking
83:
84: TYPE line_cont_info_tab IS TABLE OF line_cont_info INDEX BY BINARY_INTEGER;
85:
86:
87: TYPE cont_inst_rec IS RECORD (
88: cont_name WSH_DELIVERY_DETAILS.container_name%TYPE,
89: cont_instance_id NUMBER,
90: delivery_detail_id NUMBER,
91: delivery_assignment_id NUMBER, --added for WDA
92: gross_weight NUMBER,
124: TYPE empty_cont_info_tab IS TABLE OF empty_cont_info INDEX BY BINARY_INTEGER;
125:
126: TYPE cont_info IS RECORD (
127: group_id NUMBER,
128: organization_id WSH_DELIVERY_DETAILS.organization_id%TYPE,
129: fill_pc_basis WSH_SHIPPING_PARAMETERS.percent_fill_basis_flag%TYPE,
130: inventory_item_id WSH_DELIVERY_DETAILS.inventory_item_id%TYPE,
131: delivery_detail_id WSH_DELIVERY_DETAILS.delivery_detail_id%TYPE,
132: shp_qty WSH_DELIVERY_DETAILS.shipped_quantity%TYPE,
126: TYPE cont_info IS RECORD (
127: group_id NUMBER,
128: organization_id WSH_DELIVERY_DETAILS.organization_id%TYPE,
129: fill_pc_basis WSH_SHIPPING_PARAMETERS.percent_fill_basis_flag%TYPE,
130: inventory_item_id WSH_DELIVERY_DETAILS.inventory_item_id%TYPE,
131: delivery_detail_id WSH_DELIVERY_DETAILS.delivery_detail_id%TYPE,
132: shp_qty WSH_DELIVERY_DETAILS.shipped_quantity%TYPE,
133: req_qty WSH_DELIVERY_DETAILS.requested_quantity%TYPE,
134: gross_weight WSH_DELIVERY_DETAILS.net_weight%TYPE,
127: group_id NUMBER,
128: organization_id WSH_DELIVERY_DETAILS.organization_id%TYPE,
129: fill_pc_basis WSH_SHIPPING_PARAMETERS.percent_fill_basis_flag%TYPE,
130: inventory_item_id WSH_DELIVERY_DETAILS.inventory_item_id%TYPE,
131: delivery_detail_id WSH_DELIVERY_DETAILS.delivery_detail_id%TYPE,
132: shp_qty WSH_DELIVERY_DETAILS.shipped_quantity%TYPE,
133: req_qty WSH_DELIVERY_DETAILS.requested_quantity%TYPE,
134: gross_weight WSH_DELIVERY_DETAILS.net_weight%TYPE,
135: converted_wt WSH_DELIVERY_DETAILS.net_weight%TYPE,
128: organization_id WSH_DELIVERY_DETAILS.organization_id%TYPE,
129: fill_pc_basis WSH_SHIPPING_PARAMETERS.percent_fill_basis_flag%TYPE,
130: inventory_item_id WSH_DELIVERY_DETAILS.inventory_item_id%TYPE,
131: delivery_detail_id WSH_DELIVERY_DETAILS.delivery_detail_id%TYPE,
132: shp_qty WSH_DELIVERY_DETAILS.shipped_quantity%TYPE,
133: req_qty WSH_DELIVERY_DETAILS.requested_quantity%TYPE,
134: gross_weight WSH_DELIVERY_DETAILS.net_weight%TYPE,
135: converted_wt WSH_DELIVERY_DETAILS.net_weight%TYPE,
136: weight_uom WSH_DELIVERY_DETAILS.weight_uom_code%TYPE,
129: fill_pc_basis WSH_SHIPPING_PARAMETERS.percent_fill_basis_flag%TYPE,
130: inventory_item_id WSH_DELIVERY_DETAILS.inventory_item_id%TYPE,
131: delivery_detail_id WSH_DELIVERY_DETAILS.delivery_detail_id%TYPE,
132: shp_qty WSH_DELIVERY_DETAILS.shipped_quantity%TYPE,
133: req_qty WSH_DELIVERY_DETAILS.requested_quantity%TYPE,
134: gross_weight WSH_DELIVERY_DETAILS.net_weight%TYPE,
135: converted_wt WSH_DELIVERY_DETAILS.net_weight%TYPE,
136: weight_uom WSH_DELIVERY_DETAILS.weight_uom_code%TYPE,
137: volume WSH_DELIVERY_DETAILS.volume%TYPE,
130: inventory_item_id WSH_DELIVERY_DETAILS.inventory_item_id%TYPE,
131: delivery_detail_id WSH_DELIVERY_DETAILS.delivery_detail_id%TYPE,
132: shp_qty WSH_DELIVERY_DETAILS.shipped_quantity%TYPE,
133: req_qty WSH_DELIVERY_DETAILS.requested_quantity%TYPE,
134: gross_weight WSH_DELIVERY_DETAILS.net_weight%TYPE,
135: converted_wt WSH_DELIVERY_DETAILS.net_weight%TYPE,
136: weight_uom WSH_DELIVERY_DETAILS.weight_uom_code%TYPE,
137: volume WSH_DELIVERY_DETAILS.volume%TYPE,
138: converted_vol WSH_DELIVERY_DETAILS.volume%TYPE,
131: delivery_detail_id WSH_DELIVERY_DETAILS.delivery_detail_id%TYPE,
132: shp_qty WSH_DELIVERY_DETAILS.shipped_quantity%TYPE,
133: req_qty WSH_DELIVERY_DETAILS.requested_quantity%TYPE,
134: gross_weight WSH_DELIVERY_DETAILS.net_weight%TYPE,
135: converted_wt WSH_DELIVERY_DETAILS.net_weight%TYPE,
136: weight_uom WSH_DELIVERY_DETAILS.weight_uom_code%TYPE,
137: volume WSH_DELIVERY_DETAILS.volume%TYPE,
138: converted_vol WSH_DELIVERY_DETAILS.volume%TYPE,
139: volume_uom WSH_DELIVERY_DETAILS.volume_uom_code%TYPE,
132: shp_qty WSH_DELIVERY_DETAILS.shipped_quantity%TYPE,
133: req_qty WSH_DELIVERY_DETAILS.requested_quantity%TYPE,
134: gross_weight WSH_DELIVERY_DETAILS.net_weight%TYPE,
135: converted_wt WSH_DELIVERY_DETAILS.net_weight%TYPE,
136: weight_uom WSH_DELIVERY_DETAILS.weight_uom_code%TYPE,
137: volume WSH_DELIVERY_DETAILS.volume%TYPE,
138: converted_vol WSH_DELIVERY_DETAILS.volume%TYPE,
139: volume_uom WSH_DELIVERY_DETAILS.volume_uom_code%TYPE,
140: preferred_container WSH_CONTAINER_ITEMS.container_item_id%TYPE,
133: req_qty WSH_DELIVERY_DETAILS.requested_quantity%TYPE,
134: gross_weight WSH_DELIVERY_DETAILS.net_weight%TYPE,
135: converted_wt WSH_DELIVERY_DETAILS.net_weight%TYPE,
136: weight_uom WSH_DELIVERY_DETAILS.weight_uom_code%TYPE,
137: volume WSH_DELIVERY_DETAILS.volume%TYPE,
138: converted_vol WSH_DELIVERY_DETAILS.volume%TYPE,
139: volume_uom WSH_DELIVERY_DETAILS.volume_uom_code%TYPE,
140: preferred_container WSH_CONTAINER_ITEMS.container_item_id%TYPE,
141: max_load_qty NUMBER,
134: gross_weight WSH_DELIVERY_DETAILS.net_weight%TYPE,
135: converted_wt WSH_DELIVERY_DETAILS.net_weight%TYPE,
136: weight_uom WSH_DELIVERY_DETAILS.weight_uom_code%TYPE,
137: volume WSH_DELIVERY_DETAILS.volume%TYPE,
138: converted_vol WSH_DELIVERY_DETAILS.volume%TYPE,
139: volume_uom WSH_DELIVERY_DETAILS.volume_uom_code%TYPE,
140: preferred_container WSH_CONTAINER_ITEMS.container_item_id%TYPE,
141: max_load_qty NUMBER,
142: cont_wt WSH_DELIVERY_DETAILS.net_weight%TYPE,
135: converted_wt WSH_DELIVERY_DETAILS.net_weight%TYPE,
136: weight_uom WSH_DELIVERY_DETAILS.weight_uom_code%TYPE,
137: volume WSH_DELIVERY_DETAILS.volume%TYPE,
138: converted_vol WSH_DELIVERY_DETAILS.volume%TYPE,
139: volume_uom WSH_DELIVERY_DETAILS.volume_uom_code%TYPE,
140: preferred_container WSH_CONTAINER_ITEMS.container_item_id%TYPE,
141: max_load_qty NUMBER,
142: cont_wt WSH_DELIVERY_DETAILS.net_weight%TYPE,
143: cont_vol WSH_DELIVERY_DETAILS.volume%TYPE);
138: converted_vol WSH_DELIVERY_DETAILS.volume%TYPE,
139: volume_uom WSH_DELIVERY_DETAILS.volume_uom_code%TYPE,
140: preferred_container WSH_CONTAINER_ITEMS.container_item_id%TYPE,
141: max_load_qty NUMBER,
142: cont_wt WSH_DELIVERY_DETAILS.net_weight%TYPE,
143: cont_vol WSH_DELIVERY_DETAILS.volume%TYPE);
144:
145: TYPE cont_info_tab IS TABLE OF cont_info INDEX BY BINARY_INTEGER;
146:
139: volume_uom WSH_DELIVERY_DETAILS.volume_uom_code%TYPE,
140: preferred_container WSH_CONTAINER_ITEMS.container_item_id%TYPE,
141: max_load_qty NUMBER,
142: cont_wt WSH_DELIVERY_DETAILS.net_weight%TYPE,
143: cont_vol WSH_DELIVERY_DETAILS.volume%TYPE);
144:
145: TYPE cont_info_tab IS TABLE OF cont_info INDEX BY BINARY_INTEGER;
146:
147: