DBA Data[Home] [Help]

APPS.WSH_CONTAINER_ACTIONS dependencies on WSH_DELIVERY_DETAILS

Line 49: organization_id WSH_DELIVERY_DETAILS.organization_id%TYPE,

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,

Line 52: inventory_item_id WSH_DELIVERY_DETAILS.inventory_item_id%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,

Line 54: delivery_detail_id WSH_DELIVERY_DETAILS.delivery_detail_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,
57: shp_qty2 WSH_DELIVERY_DETAILS.shipped_quantity%TYPE,
58: req_qty2 WSH_DELIVERY_DETAILS.requested_quantity%TYPE,

Line 55: shp_qty WSH_DELIVERY_DETAILS.shipped_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,

Line 56: req_qty WSH_DELIVERY_DETAILS.requested_quantity%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,

Line 57: shp_qty2 WSH_DELIVERY_DETAILS.shipped_quantity%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,

Line 58: req_qty2 WSH_DELIVERY_DETAILS.requested_quantity%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,

Line 59: req_qty_uom WSH_DELIVERY_DETAILS.requested_quantity_uom%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,

Line 60: detail_cont_item_id WSH_DELIVERY_DETAILS.detail_container_item_id%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,

Line 61: master_cont_item_id WSH_DELIVERY_DETAILS.master_container_item_id%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,

Line 62: gross_weight WSH_DELIVERY_DETAILS.gross_weight%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,

Line 63: net_weight WSH_DELIVERY_DETAILS.net_weight%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,

Line 64: converted_wt WSH_DELIVERY_DETAILS.net_weight%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,

Line 65: weight_uom WSH_DELIVERY_DETAILS.weight_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,

Line 66: volume WSH_DELIVERY_DETAILS.volume%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,

Line 67: converted_vol WSH_DELIVERY_DETAILS.volume%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,

Line 68: volume_uom WSH_DELIVERY_DETAILS.volume_uom_code%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,

Line 69: det_cont_qty WSH_DELIVERY_DETAILS.requested_quantity%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,

Line 71: source_line_id WSH_DELIVERY_DETAILS.source_line_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,

Line 72: source_code WSH_DELIVERY_DETAILS.source_code%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

Line 75: cont_wt WSH_DELIVERY_DETAILS.net_weight%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
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);

Line 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:

Line 88: cont_name WSH_DELIVERY_DETAILS.container_name%TYPE,

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,

Line 128: organization_id WSH_DELIVERY_DETAILS.organization_id%TYPE,

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,

Line 130: inventory_item_id WSH_DELIVERY_DETAILS.inventory_item_id%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,

Line 131: delivery_detail_id WSH_DELIVERY_DETAILS.delivery_detail_id%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,

Line 132: shp_qty WSH_DELIVERY_DETAILS.shipped_quantity%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,

Line 133: req_qty WSH_DELIVERY_DETAILS.requested_quantity%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,

Line 134: gross_weight WSH_DELIVERY_DETAILS.net_weight%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,

Line 135: converted_wt WSH_DELIVERY_DETAILS.net_weight%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,

Line 136: weight_uom WSH_DELIVERY_DETAILS.weight_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,

Line 137: volume WSH_DELIVERY_DETAILS.volume%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,

Line 138: converted_vol WSH_DELIVERY_DETAILS.volume%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,
142: cont_wt WSH_DELIVERY_DETAILS.net_weight%TYPE,

Line 139: volume_uom WSH_DELIVERY_DETAILS.volume_uom_code%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);

Line 142: cont_wt WSH_DELIVERY_DETAILS.net_weight%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:

Line 143: cont_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:
147: