APPS.INV_MWB_LPN_TREE dependencies on INV_MWB_GLOBALS

Line 24: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_EXPANDED' THEN

20: BEGIN
21:
22: l_procedure_name := 'ROOT_NODE_EVENT';
23:
24: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_EXPANDED' THEN
25: inv_mwb_tree1.add_orgs (
26: x_node_value
27: , x_node_tbl
28: , x_tbl_index

Line 31: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN

27: , x_node_tbl
28: , x_tbl_index
29: );
30:
31: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
32:
33: -- If all material locations are unchecked and the view by is LPN
34: -- Using ONHAND but it does not query onhand material location.
35: IF inv_mwb_globals.g_chk_onhand = 0

Line 35: IF inv_mwb_globals.g_chk_onhand = 0

31: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
32:
33: -- If all material locations are unchecked and the view by is LPN
34: -- Using ONHAND but it does not query onhand material location.
35: IF inv_mwb_globals.g_chk_onhand = 0
36: AND inv_mwb_globals.g_chk_receiving = 0
37: AND inv_mwb_globals.g_chk_inbound = 0 THEN
38: make_common_query_lpn;
39: inv_mwb_query_manager.add_qf_where_lpn_node('ONHAND');

Line 36: AND inv_mwb_globals.g_chk_receiving = 0

32:
33: -- If all material locations are unchecked and the view by is LPN
34: -- Using ONHAND but it does not query onhand material location.
35: IF inv_mwb_globals.g_chk_onhand = 0
36: AND inv_mwb_globals.g_chk_receiving = 0
37: AND inv_mwb_globals.g_chk_inbound = 0 THEN
38: make_common_query_lpn;
39: inv_mwb_query_manager.add_qf_where_lpn_node('ONHAND');
40: inv_mwb_query_manager.execute_query;

Line 37: AND inv_mwb_globals.g_chk_inbound = 0 THEN

33: -- If all material locations are unchecked and the view by is LPN
34: -- Using ONHAND but it does not query onhand material location.
35: IF inv_mwb_globals.g_chk_onhand = 0
36: AND inv_mwb_globals.g_chk_receiving = 0
37: AND inv_mwb_globals.g_chk_inbound = 0 THEN
38: make_common_query_lpn;
39: inv_mwb_query_manager.add_qf_where_lpn_node('ONHAND');
40: inv_mwb_query_manager.execute_query;
41: RETURN;

Line 44: IF inv_mwb_globals.g_chk_onhand = 1 THEN

40: inv_mwb_query_manager.execute_query;
41: RETURN;
42: END IF;
43:
44: IF inv_mwb_globals.g_chk_onhand = 1 THEN
45: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
46: inv_mwb_globals.g_serial_to IS NOT NULL
47: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL -- Bug 6429880
48: OR inv_mwb_globals.g_unit_number IS NOT NULL -- Bug 9486070

Line 45: IF inv_mwb_globals.g_serial_from IS NOT NULL OR

41: RETURN;
42: END IF;
43:
44: IF inv_mwb_globals.g_chk_onhand = 1 THEN
45: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
46: inv_mwb_globals.g_serial_to IS NOT NULL
47: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL -- Bug 6429880
48: OR inv_mwb_globals.g_unit_number IS NOT NULL -- Bug 9486070
49: THEN

Line 46: inv_mwb_globals.g_serial_to IS NOT NULL

42: END IF;
43:
44: IF inv_mwb_globals.g_chk_onhand = 1 THEN
45: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
46: inv_mwb_globals.g_serial_to IS NOT NULL
47: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL -- Bug 6429880
48: OR inv_mwb_globals.g_unit_number IS NOT NULL -- Bug 9486070
49: THEN
50: make_common_query_onhand('MSN_QUERY');

Line 47: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL -- Bug 6429880

43:
44: IF inv_mwb_globals.g_chk_onhand = 1 THEN
45: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
46: inv_mwb_globals.g_serial_to IS NOT NULL
47: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL -- Bug 6429880
48: OR inv_mwb_globals.g_unit_number IS NOT NULL -- Bug 9486070
49: THEN
50: make_common_query_onhand('MSN_QUERY');
51: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');

Line 48: OR inv_mwb_globals.g_unit_number IS NOT NULL -- Bug 9486070

44: IF inv_mwb_globals.g_chk_onhand = 1 THEN
45: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
46: inv_mwb_globals.g_serial_to IS NOT NULL
47: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL -- Bug 6429880
48: OR inv_mwb_globals.g_unit_number IS NOT NULL -- Bug 9486070
49: THEN
50: make_common_query_onhand('MSN_QUERY');
51: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
52: ELSE

Line 58: IF inv_mwb_globals.g_chk_receiving = 1 THEN

54: inv_mwb_query_manager.add_qf_where_onhand('ONHAND');
55: END IF;
56: END IF;
57:
58: IF inv_mwb_globals.g_chk_receiving = 1 THEN
59: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
60: inv_mwb_globals.g_serial_to IS NOT NULL THEN
61: make_common_query_receiving('MSN_QUERY');
62: inv_mwb_query_manager.add_qf_where_receiving('MSN_RECEIVING');

Line 59: IF inv_mwb_globals.g_serial_from IS NOT NULL OR

55: END IF;
56: END IF;
57:
58: IF inv_mwb_globals.g_chk_receiving = 1 THEN
59: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
60: inv_mwb_globals.g_serial_to IS NOT NULL THEN
61: make_common_query_receiving('MSN_QUERY');
62: inv_mwb_query_manager.add_qf_where_receiving('MSN_RECEIVING');
63: ELSE

Line 60: inv_mwb_globals.g_serial_to IS NOT NULL THEN

56: END IF;
57:
58: IF inv_mwb_globals.g_chk_receiving = 1 THEN
59: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
60: inv_mwb_globals.g_serial_to IS NOT NULL THEN
61: make_common_query_receiving('MSN_QUERY');
62: inv_mwb_query_manager.add_qf_where_receiving('MSN_RECEIVING');
63: ELSE
64: make_common_query_receiving('RECEIVING');

Line 86: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_EXPANDED' THEN

82: TYPE tab IS TABLE OF varchar2(100) index by binary_integer;
83: mtl_loc_type tab;
84: BEGIN
85: l_procedure_name := 'ORG_NODE_EVENT';
86: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_EXPANDED' THEN
87:
88: SELECT meaning
89: BULK COLLECT INTO mtl_loc_type
90: FROM mfg_lookups

Line 94: inv_mwb_globals.print_msg( g_pkg_name, l_procedure_name, 'Selected all the document types' );

90: FROM mfg_lookups
91: WHERE lookup_type = 'MTL_LOCATION_TYPES'
92: ORDER BY lookup_code;
93:
94: inv_mwb_globals.print_msg( g_pkg_name, l_procedure_name, 'Selected all the document types' );
95:
96: IF inv_mwb_globals.g_chk_onhand = 0 AND
97: inv_mwb_globals.g_chk_receiving = 0 AND
98: inv_mwb_globals.g_chk_inbound = 0 THEN

Line 96: IF inv_mwb_globals.g_chk_onhand = 0 AND

92: ORDER BY lookup_code;
93:
94: inv_mwb_globals.print_msg( g_pkg_name, l_procedure_name, 'Selected all the document types' );
95:
96: IF inv_mwb_globals.g_chk_onhand = 0 AND
97: inv_mwb_globals.g_chk_receiving = 0 AND
98: inv_mwb_globals.g_chk_inbound = 0 THEN
99:
100: inv_mwb_tree1.add_lpns (

Line 97: inv_mwb_globals.g_chk_receiving = 0 AND

93:
94: inv_mwb_globals.print_msg( g_pkg_name, l_procedure_name, 'Selected all the document types' );
95:
96: IF inv_mwb_globals.g_chk_onhand = 0 AND
97: inv_mwb_globals.g_chk_receiving = 0 AND
98: inv_mwb_globals.g_chk_inbound = 0 THEN
99:
100: inv_mwb_tree1.add_lpns (
101: x_node_value

Line 98: inv_mwb_globals.g_chk_inbound = 0 THEN

94: inv_mwb_globals.print_msg( g_pkg_name, l_procedure_name, 'Selected all the document types' );
95:
96: IF inv_mwb_globals.g_chk_onhand = 0 AND
97: inv_mwb_globals.g_chk_receiving = 0 AND
98: inv_mwb_globals.g_chk_inbound = 0 THEN
99:
100: inv_mwb_tree1.add_lpns (
101: x_node_value
102: , x_node_tbl

Line 109: IF inv_mwb_globals.g_chk_onhand = 1

105:
106: RETURN;
107: END IF;
108:
109: IF inv_mwb_globals.g_chk_onhand = 1
110: THEN
111: x_node_tbl(x_tbl_index).state := -1;
112: x_node_tbl(x_tbl_index).DEPTH := 1;
113: x_node_tbl(x_tbl_index).label := mtl_loc_type(1);

Line 120: IF NVL(inv_mwb_globals.g_chk_receiving, 1) = 1

116: x_node_tbl(x_tbl_index).TYPE := 'MATLOC';
117: x_tbl_index := x_tbl_index + 1;
118: END IF;
119:
120: IF NVL(inv_mwb_globals.g_chk_receiving, 1) = 1
121: THEN
122: x_node_tbl(x_tbl_index).state := -1;
123: x_node_tbl(x_tbl_index).DEPTH := 1;
124: x_node_tbl(x_tbl_index).label := mtl_loc_type(2);

Line 132: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN

128: x_tbl_index := x_tbl_index + 1;
129: END IF;
130:
131:
132: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
133:
134: -- If all material locations are unchecked and the view by is LPN
135: -- Using ONHAND but it does not query onhand material location.
136:

Line 137: IF inv_mwb_globals.g_chk_onhand = 0

133:
134: -- If all material locations are unchecked and the view by is LPN
135: -- Using ONHAND but it does not query onhand material location.
136:
137: IF inv_mwb_globals.g_chk_onhand = 0
138: AND inv_mwb_globals.g_chk_receiving = 0
139: AND inv_mwb_globals.g_chk_inbound = 0
140: AND inv_mwb_globals.g_view_by = 'LPN' THEN
141: make_common_query_lpn;

Line 138: AND inv_mwb_globals.g_chk_receiving = 0

134: -- If all material locations are unchecked and the view by is LPN
135: -- Using ONHAND but it does not query onhand material location.
136:
137: IF inv_mwb_globals.g_chk_onhand = 0
138: AND inv_mwb_globals.g_chk_receiving = 0
139: AND inv_mwb_globals.g_chk_inbound = 0
140: AND inv_mwb_globals.g_view_by = 'LPN' THEN
141: make_common_query_lpn;
142: inv_mwb_query_manager.add_qf_where_lpn_node('ONHAND');

Line 139: AND inv_mwb_globals.g_chk_inbound = 0

135: -- Using ONHAND but it does not query onhand material location.
136:
137: IF inv_mwb_globals.g_chk_onhand = 0
138: AND inv_mwb_globals.g_chk_receiving = 0
139: AND inv_mwb_globals.g_chk_inbound = 0
140: AND inv_mwb_globals.g_view_by = 'LPN' THEN
141: make_common_query_lpn;
142: inv_mwb_query_manager.add_qf_where_lpn_node('ONHAND');
143: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=

Line 140: AND inv_mwb_globals.g_view_by = 'LPN' THEN

136:
137: IF inv_mwb_globals.g_chk_onhand = 0
138: AND inv_mwb_globals.g_chk_receiving = 0
139: AND inv_mwb_globals.g_chk_inbound = 0
140: AND inv_mwb_globals.g_view_by = 'LPN' THEN
141: make_common_query_lpn;
142: inv_mwb_query_manager.add_qf_where_lpn_node('ONHAND');
143: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=
144: 'wlpn.subinventory_code';

Line 161: IF inv_mwb_globals.g_chk_onhand = 1 THEN

157: inv_mwb_query_manager.execute_query;
158: RETURN;
159: END IF;
160:
161: IF inv_mwb_globals.g_chk_onhand = 1 THEN
162: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
163: inv_mwb_globals.g_serial_to IS NOT NULL THEN
164: make_common_query_receiving('RECEIVING');
165: inv_mwb_query_manager.add_qf_where_receiving('RECEIVING');

Line 162: IF inv_mwb_globals.g_serial_from IS NOT NULL OR

158: RETURN;
159: END IF;
160:
161: IF inv_mwb_globals.g_chk_onhand = 1 THEN
162: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
163: inv_mwb_globals.g_serial_to IS NOT NULL THEN
164: make_common_query_receiving('RECEIVING');
165: inv_mwb_query_manager.add_qf_where_receiving('RECEIVING');
166:

Line 163: inv_mwb_globals.g_serial_to IS NOT NULL THEN

159: END IF;
160:
161: IF inv_mwb_globals.g_chk_onhand = 1 THEN
162: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
163: inv_mwb_globals.g_serial_to IS NOT NULL THEN
164: make_common_query_receiving('RECEIVING');
165: inv_mwb_query_manager.add_qf_where_receiving('RECEIVING');
166:
167: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=

Line 198: IF inv_mwb_globals.g_chk_receiving = 1 THEN

194:
195: END IF;
196: END IF;
197:
198: IF inv_mwb_globals.g_chk_receiving = 1 THEN
199: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
200: inv_mwb_globals.g_serial_to IS NOT NULL THEN
201: make_common_query_receiving('MSN_QUERY');
202: inv_mwb_query_manager.add_qf_where_receiving('MSN_RECEIVING');

Line 199: IF inv_mwb_globals.g_serial_from IS NOT NULL OR

195: END IF;
196: END IF;
197:
198: IF inv_mwb_globals.g_chk_receiving = 1 THEN
199: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
200: inv_mwb_globals.g_serial_to IS NOT NULL THEN
201: make_common_query_receiving('MSN_QUERY');
202: inv_mwb_query_manager.add_qf_where_receiving('MSN_RECEIVING');
203: inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=

Line 200: inv_mwb_globals.g_serial_to IS NOT NULL THEN

196: END IF;
197:
198: IF inv_mwb_globals.g_chk_receiving = 1 THEN
199: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
200: inv_mwb_globals.g_serial_to IS NOT NULL THEN
201: make_common_query_receiving('MSN_QUERY');
202: inv_mwb_query_manager.add_qf_where_receiving('MSN_RECEIVING');
203: inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=
204: 'msn.current_subinventory_code';

Line 246: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_EXPANDED' THEN

242: ) IS
243: l_procedure_name VARCHAR(30);
244: BEGIN
245: l_procedure_name := 'MAT_LOC_NODE_EVENT';
246: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_EXPANDED' THEN
247:
248: inv_mwb_tree1.add_lpns (
249: x_node_value
250: , x_node_tbl

Line 254: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN

250: , x_node_tbl
251: , x_tbl_index
252: );
253:
254: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
255:
256: -- If all material locations are unchecked and the view by is LPN
257: -- Using ONHAND but it does not query onhand material location.
258: IF inv_mwb_globals.g_chk_onhand = 0

Line 258: IF inv_mwb_globals.g_chk_onhand = 0

254: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
255:
256: -- If all material locations are unchecked and the view by is LPN
257: -- Using ONHAND but it does not query onhand material location.
258: IF inv_mwb_globals.g_chk_onhand = 0
259: AND inv_mwb_globals.g_chk_receiving = 0
260: AND inv_mwb_globals.g_chk_inbound = 0
261: AND inv_mwb_globals.g_view_by = 'LPN' THEN
262: make_common_query_lpn;

Line 259: AND inv_mwb_globals.g_chk_receiving = 0

255:
256: -- If all material locations are unchecked and the view by is LPN
257: -- Using ONHAND but it does not query onhand material location.
258: IF inv_mwb_globals.g_chk_onhand = 0
259: AND inv_mwb_globals.g_chk_receiving = 0
260: AND inv_mwb_globals.g_chk_inbound = 0
261: AND inv_mwb_globals.g_view_by = 'LPN' THEN
262: make_common_query_lpn;
263: inv_mwb_query_manager.add_qf_where_lpn_node('ONHAND');

Line 260: AND inv_mwb_globals.g_chk_inbound = 0

256: -- If all material locations are unchecked and the view by is LPN
257: -- Using ONHAND but it does not query onhand material location.
258: IF inv_mwb_globals.g_chk_onhand = 0
259: AND inv_mwb_globals.g_chk_receiving = 0
260: AND inv_mwb_globals.g_chk_inbound = 0
261: AND inv_mwb_globals.g_view_by = 'LPN' THEN
262: make_common_query_lpn;
263: inv_mwb_query_manager.add_qf_where_lpn_node('ONHAND');
264: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=

Line 261: AND inv_mwb_globals.g_view_by = 'LPN' THEN

257: -- Using ONHAND but it does not query onhand material location.
258: IF inv_mwb_globals.g_chk_onhand = 0
259: AND inv_mwb_globals.g_chk_receiving = 0
260: AND inv_mwb_globals.g_chk_inbound = 0
261: AND inv_mwb_globals.g_view_by = 'LPN' THEN
262: make_common_query_lpn;
263: inv_mwb_query_manager.add_qf_where_lpn_node('ONHAND');
264: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=
265: 'wlpn.subinventory_code';

Line 282: IF inv_mwb_globals.g_tree_mat_loc_id = 1 THEN

278: inv_mwb_query_manager.execute_query;
279: RETURN;
280: END IF;
281:
282: IF inv_mwb_globals.g_tree_mat_loc_id = 1 THEN
283: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
284: inv_mwb_globals.g_serial_to IS NOT NULL
285: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL -- Bug 6429880
286: OR inv_mwb_globals.g_unit_number IS NOT NULL -- Bug 9486070

Line 283: IF inv_mwb_globals.g_serial_from IS NOT NULL OR

279: RETURN;
280: END IF;
281:
282: IF inv_mwb_globals.g_tree_mat_loc_id = 1 THEN
283: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
284: inv_mwb_globals.g_serial_to IS NOT NULL
285: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL -- Bug 6429880
286: OR inv_mwb_globals.g_unit_number IS NOT NULL -- Bug 9486070
287: THEN

Line 284: inv_mwb_globals.g_serial_to IS NOT NULL

280: END IF;
281:
282: IF inv_mwb_globals.g_tree_mat_loc_id = 1 THEN
283: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
284: inv_mwb_globals.g_serial_to IS NOT NULL
285: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL -- Bug 6429880
286: OR inv_mwb_globals.g_unit_number IS NOT NULL -- Bug 9486070
287: THEN
288: make_common_query_onhand('MSN_QUERY');

Line 285: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL -- Bug 6429880

281:
282: IF inv_mwb_globals.g_tree_mat_loc_id = 1 THEN
283: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
284: inv_mwb_globals.g_serial_to IS NOT NULL
285: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL -- Bug 6429880
286: OR inv_mwb_globals.g_unit_number IS NOT NULL -- Bug 9486070
287: THEN
288: make_common_query_onhand('MSN_QUERY');
289: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');

Line 286: OR inv_mwb_globals.g_unit_number IS NOT NULL -- Bug 9486070

282: IF inv_mwb_globals.g_tree_mat_loc_id = 1 THEN
283: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
284: inv_mwb_globals.g_serial_to IS NOT NULL
285: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL -- Bug 6429880
286: OR inv_mwb_globals.g_unit_number IS NOT NULL -- Bug 9486070
287: THEN
288: make_common_query_onhand('MSN_QUERY');
289: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
290: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=

Line 323: IF inv_mwb_globals.g_tree_mat_loc_id = 2 THEN

319:
320: END IF;
321: END IF;
322:
323: IF inv_mwb_globals.g_tree_mat_loc_id = 2 THEN
324: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
325: inv_mwb_globals.g_serial_to IS NOT NULL THEN
326: make_common_query_receiving('MSN_QUERY');
327: inv_mwb_query_manager.add_qf_where_receiving('MSN_RECEIVING');

Line 324: IF inv_mwb_globals.g_serial_from IS NOT NULL OR

320: END IF;
321: END IF;
322:
323: IF inv_mwb_globals.g_tree_mat_loc_id = 2 THEN
324: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
325: inv_mwb_globals.g_serial_to IS NOT NULL THEN
326: make_common_query_receiving('MSN_QUERY');
327: inv_mwb_query_manager.add_qf_where_receiving('MSN_RECEIVING');
328: inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=

Line 325: inv_mwb_globals.g_serial_to IS NOT NULL THEN

321: END IF;
322:
323: IF inv_mwb_globals.g_tree_mat_loc_id = 2 THEN
324: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
325: inv_mwb_globals.g_serial_to IS NOT NULL THEN
326: make_common_query_receiving('MSN_QUERY');
327: inv_mwb_query_manager.add_qf_where_receiving('MSN_RECEIVING');
328: inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=
329: 'msn.current_subinventory_code';

Line 368: inv_mwb_globals.print_msg( g_pkg_name, l_procedure_name, 'Entered' );

364: l_procedure_name VARCHAR2(30);
365: BEGIN
366:
367: l_procedure_name := 'LPN_NODE_EVENT';
368: inv_mwb_globals.print_msg( g_pkg_name, l_procedure_name, 'Entered' );
369:
370: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_EXPANDED' THEN
371: inv_mwb_tree1.add_lpns (
372: x_node_value

Line 370: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_EXPANDED' THEN

366:
367: l_procedure_name := 'LPN_NODE_EVENT';
368: inv_mwb_globals.print_msg( g_pkg_name, l_procedure_name, 'Entered' );
369:
370: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_EXPANDED' THEN
371: inv_mwb_tree1.add_lpns (
372: x_node_value
373: , x_node_tbl
374: , x_tbl_index

Line 383: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN

379: , x_node_tbl
380: , x_tbl_index
381: );
382:
383: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
384:
385: -- If all material locations are unchecked and the view by is LPN
386: -- Using ONHAND but it does not query onhand material location.
387: IF inv_mwb_globals.g_chk_onhand = 0

Line 387: IF inv_mwb_globals.g_chk_onhand = 0

383: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
384:
385: -- If all material locations are unchecked and the view by is LPN
386: -- Using ONHAND but it does not query onhand material location.
387: IF inv_mwb_globals.g_chk_onhand = 0
388: AND inv_mwb_globals.g_chk_receiving = 0
389: AND inv_mwb_globals.g_chk_inbound = 0
390: AND inv_mwb_globals.g_view_by = 'LPN' THEN
391:

Line 388: AND inv_mwb_globals.g_chk_receiving = 0

384:
385: -- If all material locations are unchecked and the view by is LPN
386: -- Using ONHAND but it does not query onhand material location.
387: IF inv_mwb_globals.g_chk_onhand = 0
388: AND inv_mwb_globals.g_chk_receiving = 0
389: AND inv_mwb_globals.g_chk_inbound = 0
390: AND inv_mwb_globals.g_view_by = 'LPN' THEN
391:
392: inv_mwb_query_manager.make_nested_lpn_onhand_query;

Line 389: AND inv_mwb_globals.g_chk_inbound = 0

385: -- If all material locations are unchecked and the view by is LPN
386: -- Using ONHAND but it does not query onhand material location.
387: IF inv_mwb_globals.g_chk_onhand = 0
388: AND inv_mwb_globals.g_chk_receiving = 0
389: AND inv_mwb_globals.g_chk_inbound = 0
390: AND inv_mwb_globals.g_view_by = 'LPN' THEN
391:
392: inv_mwb_query_manager.make_nested_lpn_onhand_query;
393:

Line 390: AND inv_mwb_globals.g_view_by = 'LPN' THEN

386: -- Using ONHAND but it does not query onhand material location.
387: IF inv_mwb_globals.g_chk_onhand = 0
388: AND inv_mwb_globals.g_chk_receiving = 0
389: AND inv_mwb_globals.g_chk_inbound = 0
390: AND inv_mwb_globals.g_view_by = 'LPN' THEN
391:
392: inv_mwb_query_manager.make_nested_lpn_onhand_query;
393:
394: make_common_query_lpn;

Line 411: inv_mwb_query_manager.add_bind_variable('onh_lpn_id', inv_mwb_globals.g_tree_parent_lpn_id);

407: inv_mwb_query_manager.add_group_clause('wlpn.lpn_id','ONHAND');
408: inv_mwb_query_manager.add_group_clause('wlc.cost_group_id','ONHAND');
409:
410: inv_mwb_query_manager.add_where_clause('wlpn.lpn_id = :onh_lpn_id', 'ONHAND');
411: inv_mwb_query_manager.add_bind_variable('onh_lpn_id', inv_mwb_globals.g_tree_parent_lpn_id);
412: inv_mwb_query_manager.execute_query;
413: RETURN;
414: END IF;
415:

Line 418: IF inv_mwb_globals.g_tree_mat_loc_id = 1 THEN

414: END IF;
415:
416: -- inv_mwb_query_manager.make_nested_lpn_onhand_query;
417:
418: IF inv_mwb_globals.g_tree_mat_loc_id = 1 THEN
419: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
420: inv_mwb_globals.g_serial_to IS NOT NULL
421: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL -- Bug 6429880
422: OR inv_mwb_globals.g_unit_number IS NOT NULL -- Bug 9486070

Line 419: IF inv_mwb_globals.g_serial_from IS NOT NULL OR

415:
416: -- inv_mwb_query_manager.make_nested_lpn_onhand_query;
417:
418: IF inv_mwb_globals.g_tree_mat_loc_id = 1 THEN
419: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
420: inv_mwb_globals.g_serial_to IS NOT NULL
421: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL -- Bug 6429880
422: OR inv_mwb_globals.g_unit_number IS NOT NULL -- Bug 9486070
423: THEN

Line 420: inv_mwb_globals.g_serial_to IS NOT NULL

416: -- inv_mwb_query_manager.make_nested_lpn_onhand_query;
417:
418: IF inv_mwb_globals.g_tree_mat_loc_id = 1 THEN
419: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
420: inv_mwb_globals.g_serial_to IS NOT NULL
421: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL -- Bug 6429880
422: OR inv_mwb_globals.g_unit_number IS NOT NULL -- Bug 9486070
423: THEN
424:

Line 421: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL -- Bug 6429880

417:
418: IF inv_mwb_globals.g_tree_mat_loc_id = 1 THEN
419: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
420: inv_mwb_globals.g_serial_to IS NOT NULL
421: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL -- Bug 6429880
422: OR inv_mwb_globals.g_unit_number IS NOT NULL -- Bug 9486070
423: THEN
424:
425: inv_mwb_query_manager.make_nested_lpn_onhand_query;

Line 422: OR inv_mwb_globals.g_unit_number IS NOT NULL -- Bug 9486070

418: IF inv_mwb_globals.g_tree_mat_loc_id = 1 THEN
419: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
420: inv_mwb_globals.g_serial_to IS NOT NULL
421: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL -- Bug 6429880
422: OR inv_mwb_globals.g_unit_number IS NOT NULL -- Bug 9486070
423: THEN
424:
425: inv_mwb_query_manager.make_nested_lpn_onhand_query;
426:

Line 444: inv_mwb_query_manager.add_bind_variable('onh_lpn_id', inv_mwb_globals.g_tree_parent_lpn_id);

440: inv_mwb_query_manager.add_group_clause('msn.lpn_id','ONHAND');
441: inv_mwb_query_manager.add_group_clause('msn.cost_group_id','ONHAND');
442:
443: inv_mwb_query_manager.add_where_clause('msn.lpn_id = :onh_lpn_id', 'ONHAND');
444: inv_mwb_query_manager.add_bind_variable('onh_lpn_id', inv_mwb_globals.g_tree_parent_lpn_id);
445:
446: ELSE
447:
448: inv_mwb_query_manager.make_nested_lpn_onhand_query;

Line 466: inv_mwb_query_manager.add_bind_variable('onh_lpn_id', inv_mwb_globals.g_tree_parent_lpn_id);

462: inv_mwb_query_manager.add_group_clause('moqd.lpn_id','ONHAND');
463: inv_mwb_query_manager.add_group_clause('moqd.cost_group_id','ONHAND');
464:
465: inv_mwb_query_manager.add_where_clause('moqd.lpn_id = :onh_lpn_id', 'ONHAND');
466: inv_mwb_query_manager.add_bind_variable('onh_lpn_id', inv_mwb_globals.g_tree_parent_lpn_id);
467:
468: END IF;
469: END IF;
470:

Line 471: IF inv_mwb_globals.g_tree_mat_loc_id = 2 THEN

467:
468: END IF;
469: END IF;
470:
471: IF inv_mwb_globals.g_tree_mat_loc_id = 2 THEN
472:
473: inv_mwb_query_manager.make_nested_lpn_rcv_query;
474:
475: IF inv_mwb_globals.g_serial_from IS NOT NULL OR

Line 475: IF inv_mwb_globals.g_serial_from IS NOT NULL OR

471: IF inv_mwb_globals.g_tree_mat_loc_id = 2 THEN
472:
473: inv_mwb_query_manager.make_nested_lpn_rcv_query;
474:
475: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
476: inv_mwb_globals.g_serial_to IS NOT NULL THEN
477: make_common_query_receiving('MSN_QUERY');
478: inv_mwb_query_manager.add_qf_where_receiving('MSN_RECEIVING');
479: inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=

Line 476: inv_mwb_globals.g_serial_to IS NOT NULL THEN

472:
473: inv_mwb_query_manager.make_nested_lpn_rcv_query;
474:
475: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
476: inv_mwb_globals.g_serial_to IS NOT NULL THEN
477: make_common_query_receiving('MSN_QUERY');
478: inv_mwb_query_manager.add_qf_where_receiving('MSN_RECEIVING');
479: inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=
480: 'msn.current_subinventory_code';

Line 491: inv_mwb_query_manager.add_bind_variable('rcv_lpn_id', inv_mwb_globals.g_tree_parent_lpn_id);

487: inv_mwb_query_manager.add_group_clause('msn.current_locator_id','RECEIVING');
488: inv_mwb_query_manager.add_group_clause('msn.lpn_id','RECEIVING');
489:
490: inv_mwb_query_manager.add_where_clause('msn.lpn_id = :rcv_lpn_id', 'RECEIVING');
491: inv_mwb_query_manager.add_bind_variable('rcv_lpn_id', inv_mwb_globals.g_tree_parent_lpn_id);
492:
493: ELSE
494:
495: make_common_query_receiving('RECEIVING');

Line 509: inv_mwb_query_manager.add_bind_variable('rcv_lpn_id', inv_mwb_globals.g_tree_parent_lpn_id);

505: inv_mwb_query_manager.add_group_clause('rs.to_locator_id','RECEIVING');
506: inv_mwb_query_manager.add_group_clause('rs.lpn_id','RECEIVING');
507:
508: inv_mwb_query_manager.add_where_clause('rs.lpn_id = :rcv_lpn_id', 'RECEIVING');
509: inv_mwb_query_manager.add_bind_variable('rcv_lpn_id', inv_mwb_globals.g_tree_parent_lpn_id);
510:
511: END IF;
512: END IF;
513: inv_mwb_query_manager.execute_query;

Line 541: inv_mwb_globals.print_msg( g_pkg_name, l_procedure_name, 'Item Node Event-Entered' );

537: BEGIN
538:
539: l_procedure_name := 'ITEM_NODE_EVENT';
540:
541: inv_mwb_globals.print_msg( g_pkg_name, l_procedure_name, 'Item Node Event-Entered' );
542:
543: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_EXPANDED' THEN
544: inv_mwb_tree1.add_revs (
545: x_node_value

Line 543: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_EXPANDED' THEN

539: l_procedure_name := 'ITEM_NODE_EVENT';
540:
541: inv_mwb_globals.print_msg( g_pkg_name, l_procedure_name, 'Item Node Event-Entered' );
542:
543: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_EXPANDED' THEN
544: inv_mwb_tree1.add_revs (
545: x_node_value
546: , x_node_tbl
547: , x_tbl_index

Line 559: IF NVL(inv_mwb_globals.g_prepacked,-99) <> 10 THEN

555: );
556:
557:
558: IF x_tbl_index = 1 THEN
559: IF NVL(inv_mwb_globals.g_prepacked,-99) <> 10 THEN
560: inv_mwb_tree1.add_serials (
561: x_node_value
562: , x_node_tbl
563: , x_tbl_index

Line 572: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN

568: END IF;
569: END IF;
570:
571:
572: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
573:
574: SELECT revision_qty_control_code,
575: lot_control_code,
576: serial_number_control_code

Line 581: WHERE inventory_item_id = inv_mwb_globals.g_tree_item_id

577: INTO l_rev_control,
578: l_lot_control,
579: l_serial_control
580: FROM mtl_system_items
581: WHERE inventory_item_id = inv_mwb_globals.g_tree_item_id
582: AND organization_id = inv_mwb_globals.g_organization_id;
583:
584: -- If all material locations are unchecked and the view by is LPN
585: -- Using ONHAND but it does not query onhand material location.

Line 582: AND organization_id = inv_mwb_globals.g_organization_id;

578: l_lot_control,
579: l_serial_control
580: FROM mtl_system_items
581: WHERE inventory_item_id = inv_mwb_globals.g_tree_item_id
582: AND organization_id = inv_mwb_globals.g_organization_id;
583:
584: -- If all material locations are unchecked and the view by is LPN
585: -- Using ONHAND but it does not query onhand material location.
586: IF inv_mwb_globals.g_chk_onhand = 0

Line 586: IF inv_mwb_globals.g_chk_onhand = 0

582: AND organization_id = inv_mwb_globals.g_organization_id;
583:
584: -- If all material locations are unchecked and the view by is LPN
585: -- Using ONHAND but it does not query onhand material location.
586: IF inv_mwb_globals.g_chk_onhand = 0
587: AND inv_mwb_globals.g_chk_receiving = 0
588: AND inv_mwb_globals.g_chk_inbound = 0
589: AND inv_mwb_globals.g_view_by = 'LPN' THEN
590: make_common_query_lpn;

Line 587: AND inv_mwb_globals.g_chk_receiving = 0

583:
584: -- If all material locations are unchecked and the view by is LPN
585: -- Using ONHAND but it does not query onhand material location.
586: IF inv_mwb_globals.g_chk_onhand = 0
587: AND inv_mwb_globals.g_chk_receiving = 0
588: AND inv_mwb_globals.g_chk_inbound = 0
589: AND inv_mwb_globals.g_view_by = 'LPN' THEN
590: make_common_query_lpn;
591: inv_mwb_query_manager.add_qf_where_lpn_node('ONHAND');

Line 588: AND inv_mwb_globals.g_chk_inbound = 0

584: -- If all material locations are unchecked and the view by is LPN
585: -- Using ONHAND but it does not query onhand material location.
586: IF inv_mwb_globals.g_chk_onhand = 0
587: AND inv_mwb_globals.g_chk_receiving = 0
588: AND inv_mwb_globals.g_chk_inbound = 0
589: AND inv_mwb_globals.g_view_by = 'LPN' THEN
590: make_common_query_lpn;
591: inv_mwb_query_manager.add_qf_where_lpn_node('ONHAND');
592: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=

Line 589: AND inv_mwb_globals.g_view_by = 'LPN' THEN

585: -- Using ONHAND but it does not query onhand material location.
586: IF inv_mwb_globals.g_chk_onhand = 0
587: AND inv_mwb_globals.g_chk_receiving = 0
588: AND inv_mwb_globals.g_chk_inbound = 0
589: AND inv_mwb_globals.g_view_by = 'LPN' THEN
590: make_common_query_lpn;
591: inv_mwb_query_manager.add_qf_where_lpn_node('ONHAND');
592: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=
593: 'wlpn.subinventory_code';

Line 617: IF (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) THEN

613: END IF;
614: END IF;
615:
616: /*LPN Status Project */
617: IF (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) THEN
618: l_default_status_id := inv_cache.org_rec.default_status_id;
619: END IF;
620:
621: IF inv_cache.set_item_rec(inv_mwb_globals.g_tree_organization_id, inv_mwb_globals.g_tree_item_id) THEN

Line 621: IF inv_cache.set_item_rec(inv_mwb_globals.g_tree_organization_id, inv_mwb_globals.g_tree_item_id) THEN

617: IF (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) THEN
618: l_default_status_id := inv_cache.org_rec.default_status_id;
619: END IF;
620:
621: IF inv_cache.set_item_rec(inv_mwb_globals.g_tree_organization_id, inv_mwb_globals.g_tree_item_id) THEN
622:
623: IF (inv_cache.item_rec.serial_number_control_code in (2,5)) THEN
624: l_serial_controlled := 1; -- Item is serial controlled
625: END IF;

Line 635: l_status_id := INV_MATERIAL_STATUS_GRP.get_default_status(p_organization_id => inv_mwb_globals.g_organization_id,

631: END IF;
632:
633: IF (l_default_status_id IS NOT NULL AND l_serial_controlled = 0 AND l_lot_controlled = 0) THEN
634:
635: l_status_id := INV_MATERIAL_STATUS_GRP.get_default_status(p_organization_id => inv_mwb_globals.g_organization_id,
636: p_inventory_item_id=>inv_mwb_globals.g_tree_item_id ,
637: p_sub_code=>inv_mwb_globals.g_tree_subinventory_code,
638: p_loc_id=>inv_mwb_globals.g_tree_loc_id,
639: p_lot_number=>inv_mwb_globals.g_tree_lot_number,

Line 636: p_inventory_item_id=>inv_mwb_globals.g_tree_item_id ,

632:
633: IF (l_default_status_id IS NOT NULL AND l_serial_controlled = 0 AND l_lot_controlled = 0) THEN
634:
635: l_status_id := INV_MATERIAL_STATUS_GRP.get_default_status(p_organization_id => inv_mwb_globals.g_organization_id,
636: p_inventory_item_id=>inv_mwb_globals.g_tree_item_id ,
637: p_sub_code=>inv_mwb_globals.g_tree_subinventory_code,
638: p_loc_id=>inv_mwb_globals.g_tree_loc_id,
639: p_lot_number=>inv_mwb_globals.g_tree_lot_number,
640: p_lpn_id=>inv_mwb_globals.g_tree_parent_lpn_id);

Line 637: p_sub_code=>inv_mwb_globals.g_tree_subinventory_code,

633: IF (l_default_status_id IS NOT NULL AND l_serial_controlled = 0 AND l_lot_controlled = 0) THEN
634:
635: l_status_id := INV_MATERIAL_STATUS_GRP.get_default_status(p_organization_id => inv_mwb_globals.g_organization_id,
636: p_inventory_item_id=>inv_mwb_globals.g_tree_item_id ,
637: p_sub_code=>inv_mwb_globals.g_tree_subinventory_code,
638: p_loc_id=>inv_mwb_globals.g_tree_loc_id,
639: p_lot_number=>inv_mwb_globals.g_tree_lot_number,
640: p_lpn_id=>inv_mwb_globals.g_tree_parent_lpn_id);
641:

Line 638: p_loc_id=>inv_mwb_globals.g_tree_loc_id,

634:
635: l_status_id := INV_MATERIAL_STATUS_GRP.get_default_status(p_organization_id => inv_mwb_globals.g_organization_id,
636: p_inventory_item_id=>inv_mwb_globals.g_tree_item_id ,
637: p_sub_code=>inv_mwb_globals.g_tree_subinventory_code,
638: p_loc_id=>inv_mwb_globals.g_tree_loc_id,
639: p_lot_number=>inv_mwb_globals.g_tree_lot_number,
640: p_lpn_id=>inv_mwb_globals.g_tree_parent_lpn_id);
641:
642: inv_mwb_globals.print_msg( g_pkg_name, l_procedure_name, 'Value of l_status_id:'|| l_status_id );

Line 639: p_lot_number=>inv_mwb_globals.g_tree_lot_number,

635: l_status_id := INV_MATERIAL_STATUS_GRP.get_default_status(p_organization_id => inv_mwb_globals.g_organization_id,
636: p_inventory_item_id=>inv_mwb_globals.g_tree_item_id ,
637: p_sub_code=>inv_mwb_globals.g_tree_subinventory_code,
638: p_loc_id=>inv_mwb_globals.g_tree_loc_id,
639: p_lot_number=>inv_mwb_globals.g_tree_lot_number,
640: p_lpn_id=>inv_mwb_globals.g_tree_parent_lpn_id);
641:
642: inv_mwb_globals.print_msg( g_pkg_name, l_procedure_name, 'Value of l_status_id:'|| l_status_id );
643:

Line 640: p_lpn_id=>inv_mwb_globals.g_tree_parent_lpn_id);

636: p_inventory_item_id=>inv_mwb_globals.g_tree_item_id ,
637: p_sub_code=>inv_mwb_globals.g_tree_subinventory_code,
638: p_loc_id=>inv_mwb_globals.g_tree_loc_id,
639: p_lot_number=>inv_mwb_globals.g_tree_lot_number,
640: p_lpn_id=>inv_mwb_globals.g_tree_parent_lpn_id);
641:
642: inv_mwb_globals.print_msg( g_pkg_name, l_procedure_name, 'Value of l_status_id:'|| l_status_id );
643:
644: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.STATUS_ID).column_value :=

Line 642: inv_mwb_globals.print_msg( g_pkg_name, l_procedure_name, 'Value of l_status_id:'|| l_status_id );

638: p_loc_id=>inv_mwb_globals.g_tree_loc_id,
639: p_lot_number=>inv_mwb_globals.g_tree_lot_number,
640: p_lpn_id=>inv_mwb_globals.g_tree_parent_lpn_id);
641:
642: inv_mwb_globals.print_msg( g_pkg_name, l_procedure_name, 'Value of l_status_id:'|| l_status_id );
643:
644: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.STATUS_ID).column_value :=
645: l_status_id;
646: inv_mwb_query_manager.add_group_clause(l_status_id, 'ONHAND');

Line 657: inv_mwb_query_manager.add_bind_variable('onh_lpn_id', inv_mwb_globals.g_tree_parent_lpn_id);

653: inv_mwb_query_manager.add_group_clause('wlpn.lpn_id','ONHAND');
654: inv_mwb_query_manager.add_group_clause('wlc.cost_group_id','ONHAND');
655:
656: inv_mwb_query_manager.add_where_clause('wlpn.lpn_id = :onh_lpn_id', 'ONHAND');
657: inv_mwb_query_manager.add_bind_variable('onh_lpn_id', inv_mwb_globals.g_tree_parent_lpn_id);
658:
659: inv_mwb_query_manager.add_where_clause('wlc.inventory_item_id = :onh_inventory_item_id', 'ONHAND');
660: inv_mwb_query_manager.add_bind_variable('onh_inventory_item_id', inv_mwb_globals.g_tree_item_id);
661:

Line 660: inv_mwb_query_manager.add_bind_variable('onh_inventory_item_id', inv_mwb_globals.g_tree_item_id);

656: inv_mwb_query_manager.add_where_clause('wlpn.lpn_id = :onh_lpn_id', 'ONHAND');
657: inv_mwb_query_manager.add_bind_variable('onh_lpn_id', inv_mwb_globals.g_tree_parent_lpn_id);
658:
659: inv_mwb_query_manager.add_where_clause('wlc.inventory_item_id = :onh_inventory_item_id', 'ONHAND');
660: inv_mwb_query_manager.add_bind_variable('onh_inventory_item_id', inv_mwb_globals.g_tree_item_id);
661:
662: inv_mwb_query_manager.execute_query;
663: RETURN;
664: END IF;

Line 668: IF inv_mwb_globals.g_tree_mat_loc_id = 1 THEN

664: END IF;
665:
666:
667:
668: IF inv_mwb_globals.g_tree_mat_loc_id = 1 THEN
669: IF (inv_mwb_globals.g_serial_from IS NOT NULL OR
670: inv_mwb_globals.g_serial_to IS NOT NULL)
671: OR (NVL(l_rev_control, 1) = 1
672: AND NVL(l_lot_control, 1) = 1

Line 669: IF (inv_mwb_globals.g_serial_from IS NOT NULL OR

665:
666:
667:
668: IF inv_mwb_globals.g_tree_mat_loc_id = 1 THEN
669: IF (inv_mwb_globals.g_serial_from IS NOT NULL OR
670: inv_mwb_globals.g_serial_to IS NOT NULL)
671: OR (NVL(l_rev_control, 1) = 1
672: AND NVL(l_lot_control, 1) = 1
673: AND l_serial_control IN ( 2,5 ))

Line 670: inv_mwb_globals.g_serial_to IS NOT NULL)

666:
667:
668: IF inv_mwb_globals.g_tree_mat_loc_id = 1 THEN
669: IF (inv_mwb_globals.g_serial_from IS NOT NULL OR
670: inv_mwb_globals.g_serial_to IS NOT NULL)
671: OR (NVL(l_rev_control, 1) = 1
672: AND NVL(l_lot_control, 1) = 1
673: AND l_serial_control IN ( 2,5 ))
674: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL -- Bug 6429880

Line 674: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL -- Bug 6429880

670: inv_mwb_globals.g_serial_to IS NOT NULL)
671: OR (NVL(l_rev_control, 1) = 1
672: AND NVL(l_lot_control, 1) = 1
673: AND l_serial_control IN ( 2,5 ))
674: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL -- Bug 6429880
675: OR inv_mwb_globals.g_unit_number IS NOT NULL -- Bug 9486070
676: THEN
677:
678: make_common_query_onhand('MSN');

Line 675: OR inv_mwb_globals.g_unit_number IS NOT NULL -- Bug 9486070

671: OR (NVL(l_rev_control, 1) = 1
672: AND NVL(l_lot_control, 1) = 1
673: AND l_serial_control IN ( 2,5 ))
674: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL -- Bug 6429880
675: OR inv_mwb_globals.g_unit_number IS NOT NULL -- Bug 9486070
676: THEN
677:
678: make_common_query_onhand('MSN');
679: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');

Line 712: inv_mwb_query_manager.add_bind_variable('onh_lpn_id', inv_mwb_globals.g_tree_parent_lpn_id);

708: inv_mwb_query_manager.add_group_clause('msn.lpn_id','ONHAND');
709: inv_mwb_query_manager.add_group_clause('msn.cost_group_id','ONHAND');
710:
711: inv_mwb_query_manager.add_where_clause('msn.lpn_id = :onh_lpn_id', 'ONHAND');
712: inv_mwb_query_manager.add_bind_variable('onh_lpn_id', inv_mwb_globals.g_tree_parent_lpn_id);
713: inv_mwb_query_manager.add_where_clause('msn.inventory_item_id = :onh_inventory_item_id', 'ONHAND');
714: inv_mwb_query_manager.add_bind_variable('onh_inventory_item_id', inv_mwb_globals.g_tree_item_id);
715:
716: ELSE

Line 714: inv_mwb_query_manager.add_bind_variable('onh_inventory_item_id', inv_mwb_globals.g_tree_item_id);

710:
711: inv_mwb_query_manager.add_where_clause('msn.lpn_id = :onh_lpn_id', 'ONHAND');
712: inv_mwb_query_manager.add_bind_variable('onh_lpn_id', inv_mwb_globals.g_tree_parent_lpn_id);
713: inv_mwb_query_manager.add_where_clause('msn.inventory_item_id = :onh_inventory_item_id', 'ONHAND');
714: inv_mwb_query_manager.add_bind_variable('onh_inventory_item_id', inv_mwb_globals.g_tree_item_id);
715:
716: ELSE
717: make_common_query_onhand('MOQD');
718: inv_mwb_query_manager.add_qf_where_onhand('ONHAND');

Line 731: inv_mwb_globals.print_msg( g_pkg_name, l_procedure_name, 'LPN Status check');

727:
728: /* LPN Status Support */
729: -- For serial controlled items, the status_id will be populated in post_query of IMVMWQMB.
730:
731: inv_mwb_globals.print_msg( g_pkg_name, l_procedure_name, 'LPN Status check');
732:
733: IF (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) THEN
734: l_default_status_id := inv_cache.org_rec.default_status_id;
735: END IF;

Line 733: IF (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) THEN

729: -- For serial controlled items, the status_id will be populated in post_query of IMVMWQMB.
730:
731: inv_mwb_globals.print_msg( g_pkg_name, l_procedure_name, 'LPN Status check');
732:
733: IF (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) THEN
734: l_default_status_id := inv_cache.org_rec.default_status_id;
735: END IF;
736:
737: IF inv_cache.set_item_rec(inv_mwb_globals.g_tree_organization_id, inv_mwb_globals.g_tree_item_id) THEN

Line 737: IF inv_cache.set_item_rec(inv_mwb_globals.g_tree_organization_id, inv_mwb_globals.g_tree_item_id) THEN

733: IF (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) THEN
734: l_default_status_id := inv_cache.org_rec.default_status_id;
735: END IF;
736:
737: IF inv_cache.set_item_rec(inv_mwb_globals.g_tree_organization_id, inv_mwb_globals.g_tree_item_id) THEN
738: IF (inv_cache.item_rec.serial_number_control_code in (2,5)) THEN
739: l_serial_controlled := 1; -- Item is serial controlled
740: END IF;
741:

Line 771: inv_mwb_query_manager.add_bind_variable('onh_lpn_id', inv_mwb_globals.g_tree_parent_lpn_id);

767: inv_mwb_query_manager.add_group_clause('moqd.lpn_id','ONHAND');
768: inv_mwb_query_manager.add_group_clause('moqd.cost_group_id','ONHAND');
769:
770: inv_mwb_query_manager.add_where_clause('moqd.lpn_id = :onh_lpn_id', 'ONHAND');
771: inv_mwb_query_manager.add_bind_variable('onh_lpn_id', inv_mwb_globals.g_tree_parent_lpn_id);
772: inv_mwb_query_manager.add_where_clause('moqd.inventory_item_id = :onh_inventory_item_id', 'ONHAND');
773: inv_mwb_query_manager.add_bind_variable('onh_inventory_item_id', inv_mwb_globals.g_tree_item_id);
774:
775: END IF;

Line 773: inv_mwb_query_manager.add_bind_variable('onh_inventory_item_id', inv_mwb_globals.g_tree_item_id);

769:
770: inv_mwb_query_manager.add_where_clause('moqd.lpn_id = :onh_lpn_id', 'ONHAND');
771: inv_mwb_query_manager.add_bind_variable('onh_lpn_id', inv_mwb_globals.g_tree_parent_lpn_id);
772: inv_mwb_query_manager.add_where_clause('moqd.inventory_item_id = :onh_inventory_item_id', 'ONHAND');
773: inv_mwb_query_manager.add_bind_variable('onh_inventory_item_id', inv_mwb_globals.g_tree_item_id);
774:
775: END IF;
776: END IF;
777:

Line 778: IF inv_mwb_globals.g_tree_mat_loc_id = 2 THEN

774:
775: END IF;
776: END IF;
777:
778: IF inv_mwb_globals.g_tree_mat_loc_id = 2 THEN
779: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
780: inv_mwb_globals.g_serial_to IS NOT NULL
781: OR (NVL(l_rev_control, 1) = 1
782: AND NVL(l_lot_control, 1) = 1

Line 779: IF inv_mwb_globals.g_serial_from IS NOT NULL OR

775: END IF;
776: END IF;
777:
778: IF inv_mwb_globals.g_tree_mat_loc_id = 2 THEN
779: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
780: inv_mwb_globals.g_serial_to IS NOT NULL
781: OR (NVL(l_rev_control, 1) = 1
782: AND NVL(l_lot_control, 1) = 1
783: AND l_serial_control IN ( 2,5 )) THEN

Line 780: inv_mwb_globals.g_serial_to IS NOT NULL

776: END IF;
777:
778: IF inv_mwb_globals.g_tree_mat_loc_id = 2 THEN
779: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
780: inv_mwb_globals.g_serial_to IS NOT NULL
781: OR (NVL(l_rev_control, 1) = 1
782: AND NVL(l_lot_control, 1) = 1
783: AND l_serial_control IN ( 2,5 )) THEN
784:

Line 815: inv_mwb_query_manager.add_bind_variable('rcv_lpn_id', inv_mwb_globals.g_tree_parent_lpn_id);

811: END IF;
812: END IF;
813:
814: inv_mwb_query_manager.add_where_clause('msn.lpn_id = :rcv_lpn_id', 'RECEIVING');
815: inv_mwb_query_manager.add_bind_variable('rcv_lpn_id', inv_mwb_globals.g_tree_parent_lpn_id);
816: inv_mwb_query_manager.add_where_clause('msn.inventory_item_id = :onh_inventory_item_id', 'RECEIVING');
817: inv_mwb_query_manager.add_bind_variable('onh_inventory_item_id', inv_mwb_globals.g_tree_item_id);
818:
819:

Line 817: inv_mwb_query_manager.add_bind_variable('onh_inventory_item_id', inv_mwb_globals.g_tree_item_id);

813:
814: inv_mwb_query_manager.add_where_clause('msn.lpn_id = :rcv_lpn_id', 'RECEIVING');
815: inv_mwb_query_manager.add_bind_variable('rcv_lpn_id', inv_mwb_globals.g_tree_parent_lpn_id);
816: inv_mwb_query_manager.add_where_clause('msn.inventory_item_id = :onh_inventory_item_id', 'RECEIVING');
817: inv_mwb_query_manager.add_bind_variable('onh_inventory_item_id', inv_mwb_globals.g_tree_item_id);
818:
819:
820: ELSE
821: make_common_query_receiving('RECEIVING');

Line 886: inv_mwb_query_manager.add_bind_variable('rcv_lpn_id', inv_mwb_globals.g_tree_parent_lpn_id);

882: -- Bug 9865190 End
883: END IF;
884:
885: inv_mwb_query_manager.add_where_clause('rs.lpn_id = :rcv_lpn_id', 'RECEIVING');
886: inv_mwb_query_manager.add_bind_variable('rcv_lpn_id', inv_mwb_globals.g_tree_parent_lpn_id);
887: inv_mwb_query_manager.add_where_clause('rs.item_id = :onh_inventory_item_id', 'RECEIVING');
888: inv_mwb_query_manager.add_bind_variable('onh_inventory_item_id', inv_mwb_globals.g_tree_item_id);
889:
890: END IF;

Line 888: inv_mwb_query_manager.add_bind_variable('onh_inventory_item_id', inv_mwb_globals.g_tree_item_id);

884:
885: inv_mwb_query_manager.add_where_clause('rs.lpn_id = :rcv_lpn_id', 'RECEIVING');
886: inv_mwb_query_manager.add_bind_variable('rcv_lpn_id', inv_mwb_globals.g_tree_parent_lpn_id);
887: inv_mwb_query_manager.add_where_clause('rs.item_id = :onh_inventory_item_id', 'RECEIVING');
888: inv_mwb_query_manager.add_bind_variable('onh_inventory_item_id', inv_mwb_globals.g_tree_item_id);
889:
890: END IF;
891: END IF;
892:

Line 919: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_EXPANDED' THEN

915: BEGIN
916:
917: l_procedure_name := 'REV_NODE_EVENT';
918:
919: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_EXPANDED' THEN
920: inv_mwb_tree1.add_lots (
921: x_node_value
922: , x_node_tbl
923: , x_tbl_index

Line 935: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN

931: );
932:
933: END IF;
934:
935: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
936:
937: SELECT lot_control_code,
938: serial_number_control_code
939: INTO l_lot_control,

Line 942: WHERE inventory_item_id = inv_mwb_globals.g_tree_item_id

938: serial_number_control_code
939: INTO l_lot_control,
940: l_serial_control
941: FROM mtl_system_items
942: WHERE inventory_item_id = inv_mwb_globals.g_tree_item_id
943: AND organization_id = inv_mwb_globals.g_organization_id;
944:
945: -- If all material locations are unchecked and the view by is LPN
946: -- Using ONHAND but it does not query onhand material location.

Line 943: AND organization_id = inv_mwb_globals.g_organization_id;

939: INTO l_lot_control,
940: l_serial_control
941: FROM mtl_system_items
942: WHERE inventory_item_id = inv_mwb_globals.g_tree_item_id
943: AND organization_id = inv_mwb_globals.g_organization_id;
944:
945: -- If all material locations are unchecked and the view by is LPN
946: -- Using ONHAND but it does not query onhand material location.
947: IF inv_mwb_globals.g_chk_onhand = 0

Line 947: IF inv_mwb_globals.g_chk_onhand = 0

943: AND organization_id = inv_mwb_globals.g_organization_id;
944:
945: -- If all material locations are unchecked and the view by is LPN
946: -- Using ONHAND but it does not query onhand material location.
947: IF inv_mwb_globals.g_chk_onhand = 0
948: AND inv_mwb_globals.g_chk_receiving = 0
949: AND inv_mwb_globals.g_chk_inbound = 0
950: AND inv_mwb_globals.g_view_by = 'LPN' THEN
951: make_common_query_lpn;

Line 948: AND inv_mwb_globals.g_chk_receiving = 0

944:
945: -- If all material locations are unchecked and the view by is LPN
946: -- Using ONHAND but it does not query onhand material location.
947: IF inv_mwb_globals.g_chk_onhand = 0
948: AND inv_mwb_globals.g_chk_receiving = 0
949: AND inv_mwb_globals.g_chk_inbound = 0
950: AND inv_mwb_globals.g_view_by = 'LPN' THEN
951: make_common_query_lpn;
952: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=

Line 949: AND inv_mwb_globals.g_chk_inbound = 0

945: -- If all material locations are unchecked and the view by is LPN
946: -- Using ONHAND but it does not query onhand material location.
947: IF inv_mwb_globals.g_chk_onhand = 0
948: AND inv_mwb_globals.g_chk_receiving = 0
949: AND inv_mwb_globals.g_chk_inbound = 0
950: AND inv_mwb_globals.g_view_by = 'LPN' THEN
951: make_common_query_lpn;
952: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=
953: 'wlpn.subinventory_code';

Line 950: AND inv_mwb_globals.g_view_by = 'LPN' THEN

946: -- Using ONHAND but it does not query onhand material location.
947: IF inv_mwb_globals.g_chk_onhand = 0
948: AND inv_mwb_globals.g_chk_receiving = 0
949: AND inv_mwb_globals.g_chk_inbound = 0
950: AND inv_mwb_globals.g_view_by = 'LPN' THEN
951: make_common_query_lpn;
952: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=
953: 'wlpn.subinventory_code';
954: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=

Line 980: IF (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) THEN

976: inv_mwb_query_manager.add_group_clause('wlpn.lpn_id','ONHAND');
977: inv_mwb_query_manager.add_group_clause('wlc.cost_group_id','ONHAND');
978:
979: /*LPN Status Project */
980: IF (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) THEN
981: l_default_status_id := inv_cache.org_rec.default_status_id;
982: END IF;
983:
984: IF inv_cache.set_item_rec(inv_mwb_globals.g_tree_organization_id, inv_mwb_globals.g_tree_item_id) THEN

Line 984: IF inv_cache.set_item_rec(inv_mwb_globals.g_tree_organization_id, inv_mwb_globals.g_tree_item_id) THEN

980: IF (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) THEN
981: l_default_status_id := inv_cache.org_rec.default_status_id;
982: END IF;
983:
984: IF inv_cache.set_item_rec(inv_mwb_globals.g_tree_organization_id, inv_mwb_globals.g_tree_item_id) THEN
985:
986: IF (inv_cache.item_rec.serial_number_control_code in (2,5)) THEN
987: l_serial_controlled := 1; -- Item is serial controlled
988: END IF;

Line 998: l_status_id := INV_MATERIAL_STATUS_GRP.get_default_status(p_organization_id => inv_mwb_globals.g_organization_id,

994: END IF;
995:
996: IF (l_default_status_id IS NOT NULL AND l_serial_controlled = 0 AND l_lot_controlled = 0) THEN
997:
998: l_status_id := INV_MATERIAL_STATUS_GRP.get_default_status(p_organization_id => inv_mwb_globals.g_organization_id,
999: p_inventory_item_id=>inv_mwb_globals.g_tree_item_id ,
1000: p_sub_code=>inv_mwb_globals.g_tree_subinventory_code,
1001: p_loc_id=>inv_mwb_globals.g_tree_loc_id,
1002: p_lot_number=>inv_mwb_globals.g_tree_lot_number,

Line 999: p_inventory_item_id=>inv_mwb_globals.g_tree_item_id ,

995:
996: IF (l_default_status_id IS NOT NULL AND l_serial_controlled = 0 AND l_lot_controlled = 0) THEN
997:
998: l_status_id := INV_MATERIAL_STATUS_GRP.get_default_status(p_organization_id => inv_mwb_globals.g_organization_id,
999: p_inventory_item_id=>inv_mwb_globals.g_tree_item_id ,
1000: p_sub_code=>inv_mwb_globals.g_tree_subinventory_code,
1001: p_loc_id=>inv_mwb_globals.g_tree_loc_id,
1002: p_lot_number=>inv_mwb_globals.g_tree_lot_number,
1003: p_lpn_id=>inv_mwb_globals.g_tree_parent_lpn_id);

Line 1000: p_sub_code=>inv_mwb_globals.g_tree_subinventory_code,

996: IF (l_default_status_id IS NOT NULL AND l_serial_controlled = 0 AND l_lot_controlled = 0) THEN
997:
998: l_status_id := INV_MATERIAL_STATUS_GRP.get_default_status(p_organization_id => inv_mwb_globals.g_organization_id,
999: p_inventory_item_id=>inv_mwb_globals.g_tree_item_id ,
1000: p_sub_code=>inv_mwb_globals.g_tree_subinventory_code,
1001: p_loc_id=>inv_mwb_globals.g_tree_loc_id,
1002: p_lot_number=>inv_mwb_globals.g_tree_lot_number,
1003: p_lpn_id=>inv_mwb_globals.g_tree_parent_lpn_id);
1004:

Line 1001: p_loc_id=>inv_mwb_globals.g_tree_loc_id,

997:
998: l_status_id := INV_MATERIAL_STATUS_GRP.get_default_status(p_organization_id => inv_mwb_globals.g_organization_id,
999: p_inventory_item_id=>inv_mwb_globals.g_tree_item_id ,
1000: p_sub_code=>inv_mwb_globals.g_tree_subinventory_code,
1001: p_loc_id=>inv_mwb_globals.g_tree_loc_id,
1002: p_lot_number=>inv_mwb_globals.g_tree_lot_number,
1003: p_lpn_id=>inv_mwb_globals.g_tree_parent_lpn_id);
1004:
1005: inv_mwb_globals.print_msg( g_pkg_name, l_procedure_name, 'Value of l_status_id:'|| l_status_id );

Line 1002: p_lot_number=>inv_mwb_globals.g_tree_lot_number,

998: l_status_id := INV_MATERIAL_STATUS_GRP.get_default_status(p_organization_id => inv_mwb_globals.g_organization_id,
999: p_inventory_item_id=>inv_mwb_globals.g_tree_item_id ,
1000: p_sub_code=>inv_mwb_globals.g_tree_subinventory_code,
1001: p_loc_id=>inv_mwb_globals.g_tree_loc_id,
1002: p_lot_number=>inv_mwb_globals.g_tree_lot_number,
1003: p_lpn_id=>inv_mwb_globals.g_tree_parent_lpn_id);
1004:
1005: inv_mwb_globals.print_msg( g_pkg_name, l_procedure_name, 'Value of l_status_id:'|| l_status_id );
1006:

Line 1003: p_lpn_id=>inv_mwb_globals.g_tree_parent_lpn_id);

999: p_inventory_item_id=>inv_mwb_globals.g_tree_item_id ,
1000: p_sub_code=>inv_mwb_globals.g_tree_subinventory_code,
1001: p_loc_id=>inv_mwb_globals.g_tree_loc_id,
1002: p_lot_number=>inv_mwb_globals.g_tree_lot_number,
1003: p_lpn_id=>inv_mwb_globals.g_tree_parent_lpn_id);
1004:
1005: inv_mwb_globals.print_msg( g_pkg_name, l_procedure_name, 'Value of l_status_id:'|| l_status_id );
1006:
1007: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.STATUS_ID).column_value :=

Line 1005: inv_mwb_globals.print_msg( g_pkg_name, l_procedure_name, 'Value of l_status_id:'|| l_status_id );

1001: p_loc_id=>inv_mwb_globals.g_tree_loc_id,
1002: p_lot_number=>inv_mwb_globals.g_tree_lot_number,
1003: p_lpn_id=>inv_mwb_globals.g_tree_parent_lpn_id);
1004:
1005: inv_mwb_globals.print_msg( g_pkg_name, l_procedure_name, 'Value of l_status_id:'|| l_status_id );
1006:
1007: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.STATUS_ID).column_value :=
1008: l_status_id;
1009: inv_mwb_query_manager.add_group_clause(l_status_id, 'ONHAND');

Line 1015: inv_mwb_query_manager.add_bind_variable('onh_revision', inv_mwb_globals.g_tree_rev);

1011: END IF;
1012: /* End of fix for LPN Status Project */
1013:
1014: inv_mwb_query_manager.add_where_clause('wlc.revision = :onh_revision', 'ONHAND');
1015: inv_mwb_query_manager.add_bind_variable('onh_revision', inv_mwb_globals.g_tree_rev);
1016:
1017:
1018: inv_mwb_query_manager.add_where_clause('wlpn.lpn_id = :onh_lpn_id', 'ONHAND');
1019: inv_mwb_query_manager.add_bind_variable('onh_lpn_id', inv_mwb_globals.g_tree_parent_lpn_id);

Line 1019: inv_mwb_query_manager.add_bind_variable('onh_lpn_id', inv_mwb_globals.g_tree_parent_lpn_id);

1015: inv_mwb_query_manager.add_bind_variable('onh_revision', inv_mwb_globals.g_tree_rev);
1016:
1017:
1018: inv_mwb_query_manager.add_where_clause('wlpn.lpn_id = :onh_lpn_id', 'ONHAND');
1019: inv_mwb_query_manager.add_bind_variable('onh_lpn_id', inv_mwb_globals.g_tree_parent_lpn_id);
1020: inv_mwb_query_manager.add_qf_where_lpn_node('ONHAND');
1021: inv_mwb_query_manager.execute_query;
1022: RETURN;
1023: END IF;

Line 1025: IF inv_mwb_globals.g_tree_mat_loc_id = 1 THEN

1021: inv_mwb_query_manager.execute_query;
1022: RETURN;
1023: END IF;
1024:
1025: IF inv_mwb_globals.g_tree_mat_loc_id = 1 THEN
1026: IF (inv_mwb_globals.g_serial_from IS NOT NULL OR
1027: inv_mwb_globals.g_serial_to IS NOT NULL)
1028: OR (NVL(l_lot_control, 1) = 1
1029: AND l_serial_control IN ( 2,5 ))

Line 1026: IF (inv_mwb_globals.g_serial_from IS NOT NULL OR

1022: RETURN;
1023: END IF;
1024:
1025: IF inv_mwb_globals.g_tree_mat_loc_id = 1 THEN
1026: IF (inv_mwb_globals.g_serial_from IS NOT NULL OR
1027: inv_mwb_globals.g_serial_to IS NOT NULL)
1028: OR (NVL(l_lot_control, 1) = 1
1029: AND l_serial_control IN ( 2,5 ))
1030: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL -- Bug 6429880

Line 1027: inv_mwb_globals.g_serial_to IS NOT NULL)

1023: END IF;
1024:
1025: IF inv_mwb_globals.g_tree_mat_loc_id = 1 THEN
1026: IF (inv_mwb_globals.g_serial_from IS NOT NULL OR
1027: inv_mwb_globals.g_serial_to IS NOT NULL)
1028: OR (NVL(l_lot_control, 1) = 1
1029: AND l_serial_control IN ( 2,5 ))
1030: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL -- Bug 6429880
1031: OR inv_mwb_globals.g_unit_number IS NOT NULL -- Bug 9486070

Line 1030: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL -- Bug 6429880

1026: IF (inv_mwb_globals.g_serial_from IS NOT NULL OR
1027: inv_mwb_globals.g_serial_to IS NOT NULL)
1028: OR (NVL(l_lot_control, 1) = 1
1029: AND l_serial_control IN ( 2,5 ))
1030: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL -- Bug 6429880
1031: OR inv_mwb_globals.g_unit_number IS NOT NULL -- Bug 9486070
1032: THEN
1033: make_common_query_onhand('MSN');
1034: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');

Line 1031: OR inv_mwb_globals.g_unit_number IS NOT NULL -- Bug 9486070

1027: inv_mwb_globals.g_serial_to IS NOT NULL)
1028: OR (NVL(l_lot_control, 1) = 1
1029: AND l_serial_control IN ( 2,5 ))
1030: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL -- Bug 6429880
1031: OR inv_mwb_globals.g_unit_number IS NOT NULL -- Bug 9486070
1032: THEN
1033: make_common_query_onhand('MSN');
1034: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
1035:

Line 1064: inv_mwb_query_manager.add_bind_variable('onh_lpn_id', inv_mwb_globals.g_tree_parent_lpn_id);

1060: inv_mwb_query_manager.add_group_clause('msn.lpn_id','ONHAND');
1061: inv_mwb_query_manager.add_group_clause('msn.cost_group_id','ONHAND');
1062:
1063: inv_mwb_query_manager.add_where_clause('msn.lpn_id = :onh_lpn_id', 'ONHAND');
1064: inv_mwb_query_manager.add_bind_variable('onh_lpn_id', inv_mwb_globals.g_tree_parent_lpn_id);
1065: inv_mwb_query_manager.add_where_clause('msn.inventory_item_id = :onh_inventory_item_id', 'ONHAND');
1066: inv_mwb_query_manager.add_bind_variable('onh_inventory_item_id', inv_mwb_globals.g_tree_item_id);
1067: inv_mwb_query_manager.add_where_clause('msn.revision = :onh_revision', 'ONHAND');
1068: inv_mwb_query_manager.add_bind_variable('onh_revision', inv_mwb_globals.g_tree_rev);

Line 1066: inv_mwb_query_manager.add_bind_variable('onh_inventory_item_id', inv_mwb_globals.g_tree_item_id);

1062:
1063: inv_mwb_query_manager.add_where_clause('msn.lpn_id = :onh_lpn_id', 'ONHAND');
1064: inv_mwb_query_manager.add_bind_variable('onh_lpn_id', inv_mwb_globals.g_tree_parent_lpn_id);
1065: inv_mwb_query_manager.add_where_clause('msn.inventory_item_id = :onh_inventory_item_id', 'ONHAND');
1066: inv_mwb_query_manager.add_bind_variable('onh_inventory_item_id', inv_mwb_globals.g_tree_item_id);
1067: inv_mwb_query_manager.add_where_clause('msn.revision = :onh_revision', 'ONHAND');
1068: inv_mwb_query_manager.add_bind_variable('onh_revision', inv_mwb_globals.g_tree_rev);
1069:
1070:

Line 1068: inv_mwb_query_manager.add_bind_variable('onh_revision', inv_mwb_globals.g_tree_rev);

1064: inv_mwb_query_manager.add_bind_variable('onh_lpn_id', inv_mwb_globals.g_tree_parent_lpn_id);
1065: inv_mwb_query_manager.add_where_clause('msn.inventory_item_id = :onh_inventory_item_id', 'ONHAND');
1066: inv_mwb_query_manager.add_bind_variable('onh_inventory_item_id', inv_mwb_globals.g_tree_item_id);
1067: inv_mwb_query_manager.add_where_clause('msn.revision = :onh_revision', 'ONHAND');
1068: inv_mwb_query_manager.add_bind_variable('onh_revision', inv_mwb_globals.g_tree_rev);
1069:
1070:
1071: ELSE
1072: make_common_query_onhand('MOQD');

Line 1099: IF (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) THEN

1095: inv_mwb_query_manager.add_group_clause('moqd.cost_group_id','ONHAND');
1096:
1097: /* LPN Status Project */
1098: -- For serial controlled items, the status_id will be populated in post_query of IMVMWQMB.
1099: IF (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) THEN
1100: l_default_status_id := inv_cache.org_rec.default_status_id;
1101: END IF;
1102:
1103: IF inv_cache.set_item_rec(inv_mwb_globals.g_tree_organization_id, inv_mwb_globals.g_tree_item_id) THEN

Line 1103: IF inv_cache.set_item_rec(inv_mwb_globals.g_tree_organization_id, inv_mwb_globals.g_tree_item_id) THEN

1099: IF (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) THEN
1100: l_default_status_id := inv_cache.org_rec.default_status_id;
1101: END IF;
1102:
1103: IF inv_cache.set_item_rec(inv_mwb_globals.g_tree_organization_id, inv_mwb_globals.g_tree_item_id) THEN
1104: IF (inv_cache.item_rec.serial_number_control_code in (2,5)) THEN
1105: l_serial_controlled := 1; -- Item is serial controlled
1106: END IF;
1107:

Line 1122: inv_mwb_query_manager.add_bind_variable('onh_lpn_id', inv_mwb_globals.g_tree_parent_lpn_id);

1118:
1119: /* LPN Status Project */
1120:
1121: inv_mwb_query_manager.add_where_clause('moqd.lpn_id = :onh_lpn_id', 'ONHAND');
1122: inv_mwb_query_manager.add_bind_variable('onh_lpn_id', inv_mwb_globals.g_tree_parent_lpn_id);
1123: inv_mwb_query_manager.add_where_clause('moqd.inventory_item_id = :onh_inventory_item_id', 'ONHAND');
1124: inv_mwb_query_manager.add_bind_variable('onh_inventory_item_id', inv_mwb_globals.g_tree_item_id);
1125: inv_mwb_query_manager.add_where_clause('moqd.revision = :onh_revision', 'ONHAND');
1126: inv_mwb_query_manager.add_bind_variable('onh_revision', inv_mwb_globals.g_tree_rev);

Line 1124: inv_mwb_query_manager.add_bind_variable('onh_inventory_item_id', inv_mwb_globals.g_tree_item_id);

1120:
1121: inv_mwb_query_manager.add_where_clause('moqd.lpn_id = :onh_lpn_id', 'ONHAND');
1122: inv_mwb_query_manager.add_bind_variable('onh_lpn_id', inv_mwb_globals.g_tree_parent_lpn_id);
1123: inv_mwb_query_manager.add_where_clause('moqd.inventory_item_id = :onh_inventory_item_id', 'ONHAND');
1124: inv_mwb_query_manager.add_bind_variable('onh_inventory_item_id', inv_mwb_globals.g_tree_item_id);
1125: inv_mwb_query_manager.add_where_clause('moqd.revision = :onh_revision', 'ONHAND');
1126: inv_mwb_query_manager.add_bind_variable('onh_revision', inv_mwb_globals.g_tree_rev);
1127:
1128: END IF;

Line 1126: inv_mwb_query_manager.add_bind_variable('onh_revision', inv_mwb_globals.g_tree_rev);

1122: inv_mwb_query_manager.add_bind_variable('onh_lpn_id', inv_mwb_globals.g_tree_parent_lpn_id);
1123: inv_mwb_query_manager.add_where_clause('moqd.inventory_item_id = :onh_inventory_item_id', 'ONHAND');
1124: inv_mwb_query_manager.add_bind_variable('onh_inventory_item_id', inv_mwb_globals.g_tree_item_id);
1125: inv_mwb_query_manager.add_where_clause('moqd.revision = :onh_revision', 'ONHAND');
1126: inv_mwb_query_manager.add_bind_variable('onh_revision', inv_mwb_globals.g_tree_rev);
1127:
1128: END IF;
1129: END IF;
1130:

Line 1131: IF inv_mwb_globals.g_tree_mat_loc_id = 2 THEN

1127:
1128: END IF;
1129: END IF;
1130:
1131: IF inv_mwb_globals.g_tree_mat_loc_id = 2 THEN
1132: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
1133: inv_mwb_globals.g_serial_to IS NOT NULL
1134: OR (NVL(l_lot_control, 1) = 1
1135: AND l_serial_control IN ( 2,5 )) THEN

Line 1132: IF inv_mwb_globals.g_serial_from IS NOT NULL OR

1128: END IF;
1129: END IF;
1130:
1131: IF inv_mwb_globals.g_tree_mat_loc_id = 2 THEN
1132: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
1133: inv_mwb_globals.g_serial_to IS NOT NULL
1134: OR (NVL(l_lot_control, 1) = 1
1135: AND l_serial_control IN ( 2,5 )) THEN
1136:

Line 1133: inv_mwb_globals.g_serial_to IS NOT NULL

1129: END IF;
1130:
1131: IF inv_mwb_globals.g_tree_mat_loc_id = 2 THEN
1132: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
1133: inv_mwb_globals.g_serial_to IS NOT NULL
1134: OR (NVL(l_lot_control, 1) = 1
1135: AND l_serial_control IN ( 2,5 )) THEN
1136:
1137: make_common_query_receiving('MSN_QUERY');

Line 1165: inv_mwb_query_manager.add_bind_variable('rcv_lpn_id', inv_mwb_globals.g_tree_parent_lpn_id);

1161: inv_mwb_query_manager.add_group_clause('msn.serial_number','RECEIVING');
1162: END IF;
1163:
1164: inv_mwb_query_manager.add_where_clause('msn.lpn_id = :rcv_lpn_id', 'RECEIVING');
1165: inv_mwb_query_manager.add_bind_variable('rcv_lpn_id', inv_mwb_globals.g_tree_parent_lpn_id);
1166: inv_mwb_query_manager.add_where_clause('msn.revision = :onh_revision', 'RECEIVING');
1167: inv_mwb_query_manager.add_bind_variable('onh_revision', inv_mwb_globals.g_tree_rev);
1168: inv_mwb_query_manager.add_where_clause('msn.inventory_item_id = :onh_inventory_item_id', 'RECEIVING');
1169: inv_mwb_query_manager.add_bind_variable('onh_inventory_item_id', inv_mwb_globals.g_tree_item_id);

Line 1167: inv_mwb_query_manager.add_bind_variable('onh_revision', inv_mwb_globals.g_tree_rev);

1163:
1164: inv_mwb_query_manager.add_where_clause('msn.lpn_id = :rcv_lpn_id', 'RECEIVING');
1165: inv_mwb_query_manager.add_bind_variable('rcv_lpn_id', inv_mwb_globals.g_tree_parent_lpn_id);
1166: inv_mwb_query_manager.add_where_clause('msn.revision = :onh_revision', 'RECEIVING');
1167: inv_mwb_query_manager.add_bind_variable('onh_revision', inv_mwb_globals.g_tree_rev);
1168: inv_mwb_query_manager.add_where_clause('msn.inventory_item_id = :onh_inventory_item_id', 'RECEIVING');
1169: inv_mwb_query_manager.add_bind_variable('onh_inventory_item_id', inv_mwb_globals.g_tree_item_id);
1170:
1171: ELSE

Line 1169: inv_mwb_query_manager.add_bind_variable('onh_inventory_item_id', inv_mwb_globals.g_tree_item_id);

1165: inv_mwb_query_manager.add_bind_variable('rcv_lpn_id', inv_mwb_globals.g_tree_parent_lpn_id);
1166: inv_mwb_query_manager.add_where_clause('msn.revision = :onh_revision', 'RECEIVING');
1167: inv_mwb_query_manager.add_bind_variable('onh_revision', inv_mwb_globals.g_tree_rev);
1168: inv_mwb_query_manager.add_where_clause('msn.inventory_item_id = :onh_inventory_item_id', 'RECEIVING');
1169: inv_mwb_query_manager.add_bind_variable('onh_inventory_item_id', inv_mwb_globals.g_tree_item_id);
1170:
1171: ELSE
1172:
1173: make_common_query_receiving('RECEIVING');

Line 1215: inv_mwb_query_manager.add_bind_variable('rcv_lpn_id', inv_mwb_globals.g_tree_parent_lpn_id);

1211: -- Bug 9865190 End
1212: END IF;
1213:
1214: inv_mwb_query_manager.add_where_clause('rs.lpn_id = :rcv_lpn_id', 'RECEIVING');
1215: inv_mwb_query_manager.add_bind_variable('rcv_lpn_id', inv_mwb_globals.g_tree_parent_lpn_id);
1216: inv_mwb_query_manager.add_where_clause('rs.item_revision = :onh_revision', 'RECEIVING');
1217: inv_mwb_query_manager.add_bind_variable('onh_revision', inv_mwb_globals.g_tree_rev);
1218: inv_mwb_query_manager.add_where_clause('rs.item_id = :onh_inventory_item_id', 'RECEIVING');
1219: inv_mwb_query_manager.add_bind_variable('onh_inventory_item_id', inv_mwb_globals.g_tree_item_id);

Line 1217: inv_mwb_query_manager.add_bind_variable('onh_revision', inv_mwb_globals.g_tree_rev);

1213:
1214: inv_mwb_query_manager.add_where_clause('rs.lpn_id = :rcv_lpn_id', 'RECEIVING');
1215: inv_mwb_query_manager.add_bind_variable('rcv_lpn_id', inv_mwb_globals.g_tree_parent_lpn_id);
1216: inv_mwb_query_manager.add_where_clause('rs.item_revision = :onh_revision', 'RECEIVING');
1217: inv_mwb_query_manager.add_bind_variable('onh_revision', inv_mwb_globals.g_tree_rev);
1218: inv_mwb_query_manager.add_where_clause('rs.item_id = :onh_inventory_item_id', 'RECEIVING');
1219: inv_mwb_query_manager.add_bind_variable('onh_inventory_item_id', inv_mwb_globals.g_tree_item_id);
1220:
1221: END IF;

Line 1219: inv_mwb_query_manager.add_bind_variable('onh_inventory_item_id', inv_mwb_globals.g_tree_item_id);

1215: inv_mwb_query_manager.add_bind_variable('rcv_lpn_id', inv_mwb_globals.g_tree_parent_lpn_id);
1216: inv_mwb_query_manager.add_where_clause('rs.item_revision = :onh_revision', 'RECEIVING');
1217: inv_mwb_query_manager.add_bind_variable('onh_revision', inv_mwb_globals.g_tree_rev);
1218: inv_mwb_query_manager.add_where_clause('rs.item_id = :onh_inventory_item_id', 'RECEIVING');
1219: inv_mwb_query_manager.add_bind_variable('onh_inventory_item_id', inv_mwb_globals.g_tree_item_id);
1220:
1221: END IF;
1222: END IF;
1223: inv_mwb_query_manager.execute_query;

Line 1248: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_EXPANDED' THEN

1244: BEGIN
1245:
1246: l_procedure_name := 'LOT_NODE_EVENT';
1247:
1248: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_EXPANDED' THEN
1249: inv_mwb_tree1.add_serials (
1250: x_node_value
1251: , x_node_tbl
1252: , x_tbl_index);

Line 1254: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN

1250: x_node_value
1251: , x_node_tbl
1252: , x_tbl_index);
1253:
1254: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
1255:
1256: SELECT serial_number_control_code
1257: INTO l_serial_control
1258: FROM mtl_system_items

Line 1259: WHERE inventory_item_id = inv_mwb_globals.g_tree_item_id

1255:
1256: SELECT serial_number_control_code
1257: INTO l_serial_control
1258: FROM mtl_system_items
1259: WHERE inventory_item_id = inv_mwb_globals.g_tree_item_id
1260: AND organization_id = inv_mwb_globals.g_organization_id;
1261:
1262: IF inv_mwb_globals.g_chk_onhand = 0
1263: AND inv_mwb_globals.g_chk_receiving = 0

Line 1260: AND organization_id = inv_mwb_globals.g_organization_id;

1256: SELECT serial_number_control_code
1257: INTO l_serial_control
1258: FROM mtl_system_items
1259: WHERE inventory_item_id = inv_mwb_globals.g_tree_item_id
1260: AND organization_id = inv_mwb_globals.g_organization_id;
1261:
1262: IF inv_mwb_globals.g_chk_onhand = 0
1263: AND inv_mwb_globals.g_chk_receiving = 0
1264: AND inv_mwb_globals.g_chk_inbound = 0 THEN

Line 1262: IF inv_mwb_globals.g_chk_onhand = 0

1258: FROM mtl_system_items
1259: WHERE inventory_item_id = inv_mwb_globals.g_tree_item_id
1260: AND organization_id = inv_mwb_globals.g_organization_id;
1261:
1262: IF inv_mwb_globals.g_chk_onhand = 0
1263: AND inv_mwb_globals.g_chk_receiving = 0
1264: AND inv_mwb_globals.g_chk_inbound = 0 THEN
1265: make_common_query_lpn;
1266: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=

Line 1263: AND inv_mwb_globals.g_chk_receiving = 0

1259: WHERE inventory_item_id = inv_mwb_globals.g_tree_item_id
1260: AND organization_id = inv_mwb_globals.g_organization_id;
1261:
1262: IF inv_mwb_globals.g_chk_onhand = 0
1263: AND inv_mwb_globals.g_chk_receiving = 0
1264: AND inv_mwb_globals.g_chk_inbound = 0 THEN
1265: make_common_query_lpn;
1266: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=
1267: 'wlpn.subinventory_code';

Line 1264: AND inv_mwb_globals.g_chk_inbound = 0 THEN

1260: AND organization_id = inv_mwb_globals.g_organization_id;
1261:
1262: IF inv_mwb_globals.g_chk_onhand = 0
1263: AND inv_mwb_globals.g_chk_receiving = 0
1264: AND inv_mwb_globals.g_chk_inbound = 0 THEN
1265: make_common_query_lpn;
1266: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=
1267: 'wlpn.subinventory_code';
1268: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=

Line 1296: inv_mwb_globals.print_msg(g_pkg_name, l_procedure_name, 'org id' ||inv_mwb_globals.g_tree_organization_id );

1292:
1293: /* LPN Status Project */
1294: -- For serial controlled items, the status_id will be populated in post_query of IMVMWQMB.
1295:
1296: inv_mwb_globals.print_msg(g_pkg_name, l_procedure_name, 'org id' ||inv_mwb_globals.g_tree_organization_id );
1297:
1298: IF(inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) THEN
1299: l_default_status_id := inv_cache.org_rec.default_status_id;
1300: END IF;

Line 1298: IF(inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) THEN

1294: -- For serial controlled items, the status_id will be populated in post_query of IMVMWQMB.
1295:
1296: inv_mwb_globals.print_msg(g_pkg_name, l_procedure_name, 'org id' ||inv_mwb_globals.g_tree_organization_id );
1297:
1298: IF(inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) THEN
1299: l_default_status_id := inv_cache.org_rec.default_status_id;
1300: END IF;
1301:
1302: inv_mwb_globals.print_msg(g_pkg_name, l_procedure_name, 'org status id' || l_default_status_id);

Line 1302: inv_mwb_globals.print_msg(g_pkg_name, l_procedure_name, 'org status id' || l_default_status_id);

1298: IF(inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) THEN
1299: l_default_status_id := inv_cache.org_rec.default_status_id;
1300: END IF;
1301:
1302: inv_mwb_globals.print_msg(g_pkg_name, l_procedure_name, 'org status id' || l_default_status_id);
1303:
1304: IF inv_cache.set_item_rec(inv_mwb_globals.g_tree_organization_id, inv_mwb_globals.g_tree_item_id) THEN
1305: IF (inv_cache.item_rec.serial_number_control_code in (2,5)) THEN
1306: l_serial_controlled := 1; -- Item is serial controlled

Line 1304: IF inv_cache.set_item_rec(inv_mwb_globals.g_tree_organization_id, inv_mwb_globals.g_tree_item_id) THEN

1300: END IF;
1301:
1302: inv_mwb_globals.print_msg(g_pkg_name, l_procedure_name, 'org status id' || l_default_status_id);
1303:
1304: IF inv_cache.set_item_rec(inv_mwb_globals.g_tree_organization_id, inv_mwb_globals.g_tree_item_id) THEN
1305: IF (inv_cache.item_rec.serial_number_control_code in (2,5)) THEN
1306: l_serial_controlled := 1; -- Item is serial controlled
1307: END IF;
1308: END IF;

Line 1312: l_status_id := INV_MATERIAL_STATUS_GRP.get_default_status(p_organization_id => inv_mwb_globals.g_organization_id,

1308: END IF;
1309:
1310: IF (l_default_status_id is not null and l_serial_controlled = 0) THEN
1311:
1312: l_status_id := INV_MATERIAL_STATUS_GRP.get_default_status(p_organization_id => inv_mwb_globals.g_organization_id,
1313: p_inventory_item_id=>inv_mwb_globals.g_tree_item_id ,
1314: p_sub_code=>inv_mwb_globals.g_tree_subinventory_code,
1315: p_loc_id=>inv_mwb_globals.g_tree_loc_id,
1316: p_lot_number=>inv_mwb_globals.g_tree_lot_number,

Line 1313: p_inventory_item_id=>inv_mwb_globals.g_tree_item_id ,

1309:
1310: IF (l_default_status_id is not null and l_serial_controlled = 0) THEN
1311:
1312: l_status_id := INV_MATERIAL_STATUS_GRP.get_default_status(p_organization_id => inv_mwb_globals.g_organization_id,
1313: p_inventory_item_id=>inv_mwb_globals.g_tree_item_id ,
1314: p_sub_code=>inv_mwb_globals.g_tree_subinventory_code,
1315: p_loc_id=>inv_mwb_globals.g_tree_loc_id,
1316: p_lot_number=>inv_mwb_globals.g_tree_lot_number,
1317: p_lpn_id=>inv_mwb_globals.g_tree_parent_lpn_id);

Line 1314: p_sub_code=>inv_mwb_globals.g_tree_subinventory_code,

1310: IF (l_default_status_id is not null and l_serial_controlled = 0) THEN
1311:
1312: l_status_id := INV_MATERIAL_STATUS_GRP.get_default_status(p_organization_id => inv_mwb_globals.g_organization_id,
1313: p_inventory_item_id=>inv_mwb_globals.g_tree_item_id ,
1314: p_sub_code=>inv_mwb_globals.g_tree_subinventory_code,
1315: p_loc_id=>inv_mwb_globals.g_tree_loc_id,
1316: p_lot_number=>inv_mwb_globals.g_tree_lot_number,
1317: p_lpn_id=>inv_mwb_globals.g_tree_parent_lpn_id);
1318:

Line 1315: p_loc_id=>inv_mwb_globals.g_tree_loc_id,

1311:
1312: l_status_id := INV_MATERIAL_STATUS_GRP.get_default_status(p_organization_id => inv_mwb_globals.g_organization_id,
1313: p_inventory_item_id=>inv_mwb_globals.g_tree_item_id ,
1314: p_sub_code=>inv_mwb_globals.g_tree_subinventory_code,
1315: p_loc_id=>inv_mwb_globals.g_tree_loc_id,
1316: p_lot_number=>inv_mwb_globals.g_tree_lot_number,
1317: p_lpn_id=>inv_mwb_globals.g_tree_parent_lpn_id);
1318:
1319: inv_mwb_globals.print_msg( g_pkg_name, l_procedure_name, 'Value of l_status_id:'|| l_status_id );

Line 1316: p_lot_number=>inv_mwb_globals.g_tree_lot_number,

1312: l_status_id := INV_MATERIAL_STATUS_GRP.get_default_status(p_organization_id => inv_mwb_globals.g_organization_id,
1313: p_inventory_item_id=>inv_mwb_globals.g_tree_item_id ,
1314: p_sub_code=>inv_mwb_globals.g_tree_subinventory_code,
1315: p_loc_id=>inv_mwb_globals.g_tree_loc_id,
1316: p_lot_number=>inv_mwb_globals.g_tree_lot_number,
1317: p_lpn_id=>inv_mwb_globals.g_tree_parent_lpn_id);
1318:
1319: inv_mwb_globals.print_msg( g_pkg_name, l_procedure_name, 'Value of l_status_id:'|| l_status_id );
1320:

Line 1317: p_lpn_id=>inv_mwb_globals.g_tree_parent_lpn_id);

1313: p_inventory_item_id=>inv_mwb_globals.g_tree_item_id ,
1314: p_sub_code=>inv_mwb_globals.g_tree_subinventory_code,
1315: p_loc_id=>inv_mwb_globals.g_tree_loc_id,
1316: p_lot_number=>inv_mwb_globals.g_tree_lot_number,
1317: p_lpn_id=>inv_mwb_globals.g_tree_parent_lpn_id);
1318:
1319: inv_mwb_globals.print_msg( g_pkg_name, l_procedure_name, 'Value of l_status_id:'|| l_status_id );
1320:
1321: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.STATUS_ID).column_value :=

Line 1319: inv_mwb_globals.print_msg( g_pkg_name, l_procedure_name, 'Value of l_status_id:'|| l_status_id );

1315: p_loc_id=>inv_mwb_globals.g_tree_loc_id,
1316: p_lot_number=>inv_mwb_globals.g_tree_lot_number,
1317: p_lpn_id=>inv_mwb_globals.g_tree_parent_lpn_id);
1318:
1319: inv_mwb_globals.print_msg( g_pkg_name, l_procedure_name, 'Value of l_status_id:'|| l_status_id );
1320:
1321: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.STATUS_ID).column_value :=
1322: l_status_id;
1323: inv_mwb_query_manager.add_group_clause(l_status_id, 'ONHAND');

Line 1330: inv_mwb_query_manager.add_bind_variable('onh_lot_number', inv_mwb_globals.g_tree_lot_number);

1326: /* End of fix for LPN Status Project */
1327:
1328: inv_mwb_query_manager.add_where_clause('wlpn.lpn_id = :onh_lpn_id', 'ONHAND');
1329: inv_mwb_query_manager.add_where_clause('wlc.lot_number = :onh_lot_number', 'ONHAND');
1330: inv_mwb_query_manager.add_bind_variable('onh_lot_number', inv_mwb_globals.g_tree_lot_number);
1331: inv_mwb_query_manager.add_bind_variable('onh_lpn_id', inv_mwb_globals.g_tree_parent_lpn_id);
1332: inv_mwb_query_manager.add_qf_where_lpn_node('ONHAND');
1333: inv_mwb_query_manager.execute_query;
1334: RETURN;

Line 1331: inv_mwb_query_manager.add_bind_variable('onh_lpn_id', inv_mwb_globals.g_tree_parent_lpn_id);

1327:
1328: inv_mwb_query_manager.add_where_clause('wlpn.lpn_id = :onh_lpn_id', 'ONHAND');
1329: inv_mwb_query_manager.add_where_clause('wlc.lot_number = :onh_lot_number', 'ONHAND');
1330: inv_mwb_query_manager.add_bind_variable('onh_lot_number', inv_mwb_globals.g_tree_lot_number);
1331: inv_mwb_query_manager.add_bind_variable('onh_lpn_id', inv_mwb_globals.g_tree_parent_lpn_id);
1332: inv_mwb_query_manager.add_qf_where_lpn_node('ONHAND');
1333: inv_mwb_query_manager.execute_query;
1334: RETURN;
1335: END IF;

Line 1337: IF inv_mwb_globals.g_tree_mat_loc_id = 1 THEN

1333: inv_mwb_query_manager.execute_query;
1334: RETURN;
1335: END IF;
1336:
1337: IF inv_mwb_globals.g_tree_mat_loc_id = 1 THEN
1338: IF (inv_mwb_globals.g_serial_from IS NOT NULL OR
1339: inv_mwb_globals.g_serial_to IS NOT NULL)
1340: OR l_serial_control IN ( 2,5 )
1341: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL -- Bug 6429880

Line 1338: IF (inv_mwb_globals.g_serial_from IS NOT NULL OR

1334: RETURN;
1335: END IF;
1336:
1337: IF inv_mwb_globals.g_tree_mat_loc_id = 1 THEN
1338: IF (inv_mwb_globals.g_serial_from IS NOT NULL OR
1339: inv_mwb_globals.g_serial_to IS NOT NULL)
1340: OR l_serial_control IN ( 2,5 )
1341: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL -- Bug 6429880
1342: OR inv_mwb_globals.g_unit_number IS NOT NULL -- Bug 9486070

Line 1339: inv_mwb_globals.g_serial_to IS NOT NULL)

1335: END IF;
1336:
1337: IF inv_mwb_globals.g_tree_mat_loc_id = 1 THEN
1338: IF (inv_mwb_globals.g_serial_from IS NOT NULL OR
1339: inv_mwb_globals.g_serial_to IS NOT NULL)
1340: OR l_serial_control IN ( 2,5 )
1341: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL -- Bug 6429880
1342: OR inv_mwb_globals.g_unit_number IS NOT NULL -- Bug 9486070
1343: THEN

Line 1341: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL -- Bug 6429880

1337: IF inv_mwb_globals.g_tree_mat_loc_id = 1 THEN
1338: IF (inv_mwb_globals.g_serial_from IS NOT NULL OR
1339: inv_mwb_globals.g_serial_to IS NOT NULL)
1340: OR l_serial_control IN ( 2,5 )
1341: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL -- Bug 6429880
1342: OR inv_mwb_globals.g_unit_number IS NOT NULL -- Bug 9486070
1343: THEN
1344: make_common_query_onhand('MSN');
1345: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');

Line 1342: OR inv_mwb_globals.g_unit_number IS NOT NULL -- Bug 9486070

1338: IF (inv_mwb_globals.g_serial_from IS NOT NULL OR
1339: inv_mwb_globals.g_serial_to IS NOT NULL)
1340: OR l_serial_control IN ( 2,5 )
1341: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL -- Bug 6429880
1342: OR inv_mwb_globals.g_unit_number IS NOT NULL -- Bug 9486070
1343: THEN
1344: make_common_query_onhand('MSN');
1345: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
1346:

Line 1375: inv_mwb_query_manager.add_bind_variable('onh_lpn_id', inv_mwb_globals.g_tree_parent_lpn_id);

1371: inv_mwb_query_manager.add_group_clause('msn.revision','ONHAND');
1372: inv_mwb_query_manager.add_group_clause('msn.lot_number','ONHAND');
1373:
1374: inv_mwb_query_manager.add_where_clause('msn.lpn_id = :onh_lpn_id', 'ONHAND');
1375: inv_mwb_query_manager.add_bind_variable('onh_lpn_id', inv_mwb_globals.g_tree_parent_lpn_id);
1376: inv_mwb_query_manager.add_where_clause('msn.inventory_item_id = :onh_inventory_item_id', 'ONHAND');
1377: inv_mwb_query_manager.add_bind_variable('onh_inventory_item_id', inv_mwb_globals.g_tree_item_id);
1378:
1379: IF inv_mwb_globals.g_tree_rev IS NOT NULL THEN

Line 1377: inv_mwb_query_manager.add_bind_variable('onh_inventory_item_id', inv_mwb_globals.g_tree_item_id);

1373:
1374: inv_mwb_query_manager.add_where_clause('msn.lpn_id = :onh_lpn_id', 'ONHAND');
1375: inv_mwb_query_manager.add_bind_variable('onh_lpn_id', inv_mwb_globals.g_tree_parent_lpn_id);
1376: inv_mwb_query_manager.add_where_clause('msn.inventory_item_id = :onh_inventory_item_id', 'ONHAND');
1377: inv_mwb_query_manager.add_bind_variable('onh_inventory_item_id', inv_mwb_globals.g_tree_item_id);
1378:
1379: IF inv_mwb_globals.g_tree_rev IS NOT NULL THEN
1380: inv_mwb_query_manager.add_where_clause('msn.revision = :onh_revision', 'ONHAND');
1381: inv_mwb_query_manager.add_bind_variable('onh_revision', inv_mwb_globals.g_tree_rev);

Line 1379: IF inv_mwb_globals.g_tree_rev IS NOT NULL THEN

1375: inv_mwb_query_manager.add_bind_variable('onh_lpn_id', inv_mwb_globals.g_tree_parent_lpn_id);
1376: inv_mwb_query_manager.add_where_clause('msn.inventory_item_id = :onh_inventory_item_id', 'ONHAND');
1377: inv_mwb_query_manager.add_bind_variable('onh_inventory_item_id', inv_mwb_globals.g_tree_item_id);
1378:
1379: IF inv_mwb_globals.g_tree_rev IS NOT NULL THEN
1380: inv_mwb_query_manager.add_where_clause('msn.revision = :onh_revision', 'ONHAND');
1381: inv_mwb_query_manager.add_bind_variable('onh_revision', inv_mwb_globals.g_tree_rev);
1382: END IF;
1383: ELSE

Line 1381: inv_mwb_query_manager.add_bind_variable('onh_revision', inv_mwb_globals.g_tree_rev);

1377: inv_mwb_query_manager.add_bind_variable('onh_inventory_item_id', inv_mwb_globals.g_tree_item_id);
1378:
1379: IF inv_mwb_globals.g_tree_rev IS NOT NULL THEN
1380: inv_mwb_query_manager.add_where_clause('msn.revision = :onh_revision', 'ONHAND');
1381: inv_mwb_query_manager.add_bind_variable('onh_revision', inv_mwb_globals.g_tree_rev);
1382: END IF;
1383: ELSE
1384: make_common_query_onhand('MOQD');
1385: inv_mwb_query_manager.add_qf_where_onhand('ONHAND');

Line 1410: inv_mwb_globals.print_msg(g_pkg_name, l_procedure_name, 'org id' ||inv_mwb_globals.g_tree_organization_id );

1406:
1407: /* LPN Status Project */
1408: -- For serial controlled items, the status_id will be populated in post_query of IMVMWQMB.
1409:
1410: inv_mwb_globals.print_msg(g_pkg_name, l_procedure_name, 'org id' ||inv_mwb_globals.g_tree_organization_id );
1411:
1412: IF(inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) THEN
1413: l_default_status_id := inv_cache.org_rec.default_status_id;
1414: END IF;

Line 1412: IF(inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) THEN

1408: -- For serial controlled items, the status_id will be populated in post_query of IMVMWQMB.
1409:
1410: inv_mwb_globals.print_msg(g_pkg_name, l_procedure_name, 'org id' ||inv_mwb_globals.g_tree_organization_id );
1411:
1412: IF(inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) THEN
1413: l_default_status_id := inv_cache.org_rec.default_status_id;
1414: END IF;
1415:
1416: inv_mwb_globals.print_msg(g_pkg_name, l_procedure_name, 'org status id' || l_default_status_id);

Line 1416: inv_mwb_globals.print_msg(g_pkg_name, l_procedure_name, 'org status id' || l_default_status_id);

1412: IF(inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) THEN
1413: l_default_status_id := inv_cache.org_rec.default_status_id;
1414: END IF;
1415:
1416: inv_mwb_globals.print_msg(g_pkg_name, l_procedure_name, 'org status id' || l_default_status_id);
1417:
1418: IF inv_cache.set_item_rec(inv_mwb_globals.g_tree_organization_id, inv_mwb_globals.g_tree_item_id) THEN
1419: IF (inv_cache.item_rec.serial_number_control_code in (2,5)) THEN
1420: l_serial_controlled := 1; -- Item is serial controlled

Line 1418: IF inv_cache.set_item_rec(inv_mwb_globals.g_tree_organization_id, inv_mwb_globals.g_tree_item_id) THEN

1414: END IF;
1415:
1416: inv_mwb_globals.print_msg(g_pkg_name, l_procedure_name, 'org status id' || l_default_status_id);
1417:
1418: IF inv_cache.set_item_rec(inv_mwb_globals.g_tree_organization_id, inv_mwb_globals.g_tree_item_id) THEN
1419: IF (inv_cache.item_rec.serial_number_control_code in (2,5)) THEN
1420: l_serial_controlled := 1; -- Item is serial controlled
1421: END IF;
1422: END IF;

Line 1424: inv_mwb_globals.print_msg(g_pkg_name, l_procedure_name, 'serial controlled' || l_serial_controlled);

1420: l_serial_controlled := 1; -- Item is serial controlled
1421: END IF;
1422: END IF;
1423:
1424: inv_mwb_globals.print_msg(g_pkg_name, l_procedure_name, 'serial controlled' || l_serial_controlled);
1425:
1426: IF (l_default_status_id is not null and l_serial_controlled = 0) THEN
1427: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.STATUS_ID).column_value :=
1428: 'moqd.status_id';

Line 1434: inv_mwb_query_manager.add_bind_variable('onh_lpn_id', inv_mwb_globals.g_tree_parent_lpn_id);

1430: END IF;
1431: /* LPN Status Project */
1432:
1433: inv_mwb_query_manager.add_where_clause('moqd.lpn_id = :onh_lpn_id', 'ONHAND');
1434: inv_mwb_query_manager.add_bind_variable('onh_lpn_id', inv_mwb_globals.g_tree_parent_lpn_id);
1435: inv_mwb_query_manager.add_where_clause('moqd.inventory_item_id = :onh_inventory_item_id', 'ONHAND');
1436: inv_mwb_query_manager.add_bind_variable('onh_inventory_item_id', inv_mwb_globals.g_tree_item_id);
1437: inv_mwb_query_manager.add_where_clause('moqd.lot_number = :onh_lot_number', 'ONHAND');
1438: inv_mwb_query_manager.add_bind_variable('onh_lot_number', inv_mwb_globals.g_tree_lot_number);

Line 1436: inv_mwb_query_manager.add_bind_variable('onh_inventory_item_id', inv_mwb_globals.g_tree_item_id);

1432:
1433: inv_mwb_query_manager.add_where_clause('moqd.lpn_id = :onh_lpn_id', 'ONHAND');
1434: inv_mwb_query_manager.add_bind_variable('onh_lpn_id', inv_mwb_globals.g_tree_parent_lpn_id);
1435: inv_mwb_query_manager.add_where_clause('moqd.inventory_item_id = :onh_inventory_item_id', 'ONHAND');
1436: inv_mwb_query_manager.add_bind_variable('onh_inventory_item_id', inv_mwb_globals.g_tree_item_id);
1437: inv_mwb_query_manager.add_where_clause('moqd.lot_number = :onh_lot_number', 'ONHAND');
1438: inv_mwb_query_manager.add_bind_variable('onh_lot_number', inv_mwb_globals.g_tree_lot_number);
1439: IF inv_mwb_globals.g_tree_rev IS NOT NULL THEN
1440: inv_mwb_query_manager.add_where_clause('moqd.revision = :onh_revision', 'ONHAND');

Line 1438: inv_mwb_query_manager.add_bind_variable('onh_lot_number', inv_mwb_globals.g_tree_lot_number);

1434: inv_mwb_query_manager.add_bind_variable('onh_lpn_id', inv_mwb_globals.g_tree_parent_lpn_id);
1435: inv_mwb_query_manager.add_where_clause('moqd.inventory_item_id = :onh_inventory_item_id', 'ONHAND');
1436: inv_mwb_query_manager.add_bind_variable('onh_inventory_item_id', inv_mwb_globals.g_tree_item_id);
1437: inv_mwb_query_manager.add_where_clause('moqd.lot_number = :onh_lot_number', 'ONHAND');
1438: inv_mwb_query_manager.add_bind_variable('onh_lot_number', inv_mwb_globals.g_tree_lot_number);
1439: IF inv_mwb_globals.g_tree_rev IS NOT NULL THEN
1440: inv_mwb_query_manager.add_where_clause('moqd.revision = :onh_revision', 'ONHAND');
1441: inv_mwb_query_manager.add_bind_variable('onh_revision', inv_mwb_globals.g_tree_rev);
1442: END IF;

Line 1439: IF inv_mwb_globals.g_tree_rev IS NOT NULL THEN

1435: inv_mwb_query_manager.add_where_clause('moqd.inventory_item_id = :onh_inventory_item_id', 'ONHAND');
1436: inv_mwb_query_manager.add_bind_variable('onh_inventory_item_id', inv_mwb_globals.g_tree_item_id);
1437: inv_mwb_query_manager.add_where_clause('moqd.lot_number = :onh_lot_number', 'ONHAND');
1438: inv_mwb_query_manager.add_bind_variable('onh_lot_number', inv_mwb_globals.g_tree_lot_number);
1439: IF inv_mwb_globals.g_tree_rev IS NOT NULL THEN
1440: inv_mwb_query_manager.add_where_clause('moqd.revision = :onh_revision', 'ONHAND');
1441: inv_mwb_query_manager.add_bind_variable('onh_revision', inv_mwb_globals.g_tree_rev);
1442: END IF;
1443: END IF;

Line 1441: inv_mwb_query_manager.add_bind_variable('onh_revision', inv_mwb_globals.g_tree_rev);

1437: inv_mwb_query_manager.add_where_clause('moqd.lot_number = :onh_lot_number', 'ONHAND');
1438: inv_mwb_query_manager.add_bind_variable('onh_lot_number', inv_mwb_globals.g_tree_lot_number);
1439: IF inv_mwb_globals.g_tree_rev IS NOT NULL THEN
1440: inv_mwb_query_manager.add_where_clause('moqd.revision = :onh_revision', 'ONHAND');
1441: inv_mwb_query_manager.add_bind_variable('onh_revision', inv_mwb_globals.g_tree_rev);
1442: END IF;
1443: END IF;
1444: END IF;
1445:

Line 1446: IF inv_mwb_globals.g_tree_mat_loc_id = 2 THEN

1442: END IF;
1443: END IF;
1444: END IF;
1445:
1446: IF inv_mwb_globals.g_tree_mat_loc_id = 2 THEN
1447: IF (inv_mwb_globals.g_serial_from IS NOT NULL OR
1448: inv_mwb_globals.g_serial_to IS NOT NULL)
1449: OR l_serial_control IN ( 2,5 ) THEN
1450:

Line 1447: IF (inv_mwb_globals.g_serial_from IS NOT NULL OR

1443: END IF;
1444: END IF;
1445:
1446: IF inv_mwb_globals.g_tree_mat_loc_id = 2 THEN
1447: IF (inv_mwb_globals.g_serial_from IS NOT NULL OR
1448: inv_mwb_globals.g_serial_to IS NOT NULL)
1449: OR l_serial_control IN ( 2,5 ) THEN
1450:
1451: make_common_query_receiving('MSN_QUERY');

Line 1448: inv_mwb_globals.g_serial_to IS NOT NULL)

1444: END IF;
1445:
1446: IF inv_mwb_globals.g_tree_mat_loc_id = 2 THEN
1447: IF (inv_mwb_globals.g_serial_from IS NOT NULL OR
1448: inv_mwb_globals.g_serial_to IS NOT NULL)
1449: OR l_serial_control IN ( 2,5 ) THEN
1450:
1451: make_common_query_receiving('MSN_QUERY');
1452: inv_mwb_query_manager.add_qf_where_receiving('MSN_RECEIVING');

Line 1479: inv_mwb_query_manager.add_bind_variable('rcv_lpn_id', inv_mwb_globals.g_tree_parent_lpn_id);

1475: inv_mwb_query_manager.add_group_clause('msn.serial_number','RECEIVING');
1476: END IF;
1477:
1478: inv_mwb_query_manager.add_where_clause('msn.lpn_id = :rcv_lpn_id', 'RECEIVING');
1479: inv_mwb_query_manager.add_bind_variable('rcv_lpn_id', inv_mwb_globals.g_tree_parent_lpn_id);
1480: inv_mwb_query_manager.add_where_clause('msn.lot_number = :onh_lot_number', 'RECEIVING');
1481: inv_mwb_query_manager.add_bind_variable('onh_lot_number', inv_mwb_globals.g_tree_lot_number);
1482:
1483: IF inv_mwb_globals.g_tree_rev IS NOT NULL THEN

Line 1481: inv_mwb_query_manager.add_bind_variable('onh_lot_number', inv_mwb_globals.g_tree_lot_number);

1477:
1478: inv_mwb_query_manager.add_where_clause('msn.lpn_id = :rcv_lpn_id', 'RECEIVING');
1479: inv_mwb_query_manager.add_bind_variable('rcv_lpn_id', inv_mwb_globals.g_tree_parent_lpn_id);
1480: inv_mwb_query_manager.add_where_clause('msn.lot_number = :onh_lot_number', 'RECEIVING');
1481: inv_mwb_query_manager.add_bind_variable('onh_lot_number', inv_mwb_globals.g_tree_lot_number);
1482:
1483: IF inv_mwb_globals.g_tree_rev IS NOT NULL THEN
1484: inv_mwb_query_manager.add_where_clause('msn.revision = :onh_revision', 'RECEIVING');
1485: inv_mwb_query_manager.add_bind_variable('onh_revision', inv_mwb_globals.g_tree_rev);

Line 1483: IF inv_mwb_globals.g_tree_rev IS NOT NULL THEN

1479: inv_mwb_query_manager.add_bind_variable('rcv_lpn_id', inv_mwb_globals.g_tree_parent_lpn_id);
1480: inv_mwb_query_manager.add_where_clause('msn.lot_number = :onh_lot_number', 'RECEIVING');
1481: inv_mwb_query_manager.add_bind_variable('onh_lot_number', inv_mwb_globals.g_tree_lot_number);
1482:
1483: IF inv_mwb_globals.g_tree_rev IS NOT NULL THEN
1484: inv_mwb_query_manager.add_where_clause('msn.revision = :onh_revision', 'RECEIVING');
1485: inv_mwb_query_manager.add_bind_variable('onh_revision', inv_mwb_globals.g_tree_rev);
1486: END IF;
1487: inv_mwb_query_manager.add_where_clause('msn.inventory_item_id = :onh_inventory_item_id', 'RECEIVING');

Line 1485: inv_mwb_query_manager.add_bind_variable('onh_revision', inv_mwb_globals.g_tree_rev);

1481: inv_mwb_query_manager.add_bind_variable('onh_lot_number', inv_mwb_globals.g_tree_lot_number);
1482:
1483: IF inv_mwb_globals.g_tree_rev IS NOT NULL THEN
1484: inv_mwb_query_manager.add_where_clause('msn.revision = :onh_revision', 'RECEIVING');
1485: inv_mwb_query_manager.add_bind_variable('onh_revision', inv_mwb_globals.g_tree_rev);
1486: END IF;
1487: inv_mwb_query_manager.add_where_clause('msn.inventory_item_id = :onh_inventory_item_id', 'RECEIVING');
1488: inv_mwb_query_manager.add_bind_variable('onh_inventory_item_id', inv_mwb_globals.g_tree_item_id);
1489:

Line 1488: inv_mwb_query_manager.add_bind_variable('onh_inventory_item_id', inv_mwb_globals.g_tree_item_id);

1484: inv_mwb_query_manager.add_where_clause('msn.revision = :onh_revision', 'RECEIVING');
1485: inv_mwb_query_manager.add_bind_variable('onh_revision', inv_mwb_globals.g_tree_rev);
1486: END IF;
1487: inv_mwb_query_manager.add_where_clause('msn.inventory_item_id = :onh_inventory_item_id', 'RECEIVING');
1488: inv_mwb_query_manager.add_bind_variable('onh_inventory_item_id', inv_mwb_globals.g_tree_item_id);
1489:
1490: ELSE
1491:
1492: make_common_query_receiving('RECEIVING');

Line 1533: inv_mwb_query_manager.add_bind_variable('rcv_lpn_id', inv_mwb_globals.g_tree_parent_lpn_id);

1529: -- Bug 9865190 End
1530:
1531:
1532: inv_mwb_query_manager.add_where_clause('rs.lpn_id = :rcv_lpn_id', 'RECEIVING');
1533: inv_mwb_query_manager.add_bind_variable('rcv_lpn_id', inv_mwb_globals.g_tree_parent_lpn_id);
1534: IF inv_mwb_globals.g_tree_rev IS NOT NULL THEN
1535: inv_mwb_query_manager.add_where_clause('rs.item_revision = :onh_revision', 'RECEIVING');
1536: inv_mwb_query_manager.add_bind_variable('onh_revision', inv_mwb_globals.g_tree_rev);
1537: END IF;

Line 1534: IF inv_mwb_globals.g_tree_rev IS NOT NULL THEN

1530:
1531:
1532: inv_mwb_query_manager.add_where_clause('rs.lpn_id = :rcv_lpn_id', 'RECEIVING');
1533: inv_mwb_query_manager.add_bind_variable('rcv_lpn_id', inv_mwb_globals.g_tree_parent_lpn_id);
1534: IF inv_mwb_globals.g_tree_rev IS NOT NULL THEN
1535: inv_mwb_query_manager.add_where_clause('rs.item_revision = :onh_revision', 'RECEIVING');
1536: inv_mwb_query_manager.add_bind_variable('onh_revision', inv_mwb_globals.g_tree_rev);
1537: END IF;
1538: inv_mwb_query_manager.add_where_clause('rls.lot_num = :onh_lot_number', 'RECEIVING');-- Bug 9865190

Line 1536: inv_mwb_query_manager.add_bind_variable('onh_revision', inv_mwb_globals.g_tree_rev);

1532: inv_mwb_query_manager.add_where_clause('rs.lpn_id = :rcv_lpn_id', 'RECEIVING');
1533: inv_mwb_query_manager.add_bind_variable('rcv_lpn_id', inv_mwb_globals.g_tree_parent_lpn_id);
1534: IF inv_mwb_globals.g_tree_rev IS NOT NULL THEN
1535: inv_mwb_query_manager.add_where_clause('rs.item_revision = :onh_revision', 'RECEIVING');
1536: inv_mwb_query_manager.add_bind_variable('onh_revision', inv_mwb_globals.g_tree_rev);
1537: END IF;
1538: inv_mwb_query_manager.add_where_clause('rls.lot_num = :onh_lot_number', 'RECEIVING');-- Bug 9865190
1539: inv_mwb_query_manager.add_bind_variable('onh_lot_number', inv_mwb_globals.g_tree_lot_number);
1540:

Line 1539: inv_mwb_query_manager.add_bind_variable('onh_lot_number', inv_mwb_globals.g_tree_lot_number);

1535: inv_mwb_query_manager.add_where_clause('rs.item_revision = :onh_revision', 'RECEIVING');
1536: inv_mwb_query_manager.add_bind_variable('onh_revision', inv_mwb_globals.g_tree_rev);
1537: END IF;
1538: inv_mwb_query_manager.add_where_clause('rls.lot_num = :onh_lot_number', 'RECEIVING');-- Bug 9865190
1539: inv_mwb_query_manager.add_bind_variable('onh_lot_number', inv_mwb_globals.g_tree_lot_number);
1540:
1541: inv_mwb_query_manager.add_where_clause('rs.item_id = :onh_inventory_item_id', 'RECEIVING');
1542: inv_mwb_query_manager.add_bind_variable('onh_inventory_item_id', inv_mwb_globals.g_tree_item_id);
1543:

Line 1542: inv_mwb_query_manager.add_bind_variable('onh_inventory_item_id', inv_mwb_globals.g_tree_item_id);

1538: inv_mwb_query_manager.add_where_clause('rls.lot_num = :onh_lot_number', 'RECEIVING');-- Bug 9865190
1539: inv_mwb_query_manager.add_bind_variable('onh_lot_number', inv_mwb_globals.g_tree_lot_number);
1540:
1541: inv_mwb_query_manager.add_where_clause('rs.item_id = :onh_inventory_item_id', 'RECEIVING');
1542: inv_mwb_query_manager.add_bind_variable('onh_inventory_item_id', inv_mwb_globals.g_tree_item_id);
1543:
1544: END IF;
1545: END IF;
1546:

Line 1565: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN

1561: BEGIN
1562:
1563: l_procedure_name := 'SERIAL_NODE_EVENT';
1564:
1565: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
1566: IF inv_mwb_globals.g_chk_onhand = 0
1567: AND inv_mwb_globals.g_chk_receiving = 0
1568: AND inv_mwb_globals.g_chk_inbound = 0
1569: AND inv_mwb_globals.g_view_by = 'LPN' THEN

Line 1566: IF inv_mwb_globals.g_chk_onhand = 0

1562:
1563: l_procedure_name := 'SERIAL_NODE_EVENT';
1564:
1565: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
1566: IF inv_mwb_globals.g_chk_onhand = 0
1567: AND inv_mwb_globals.g_chk_receiving = 0
1568: AND inv_mwb_globals.g_chk_inbound = 0
1569: AND inv_mwb_globals.g_view_by = 'LPN' THEN
1570: make_common_query_lpn;

Line 1567: AND inv_mwb_globals.g_chk_receiving = 0

1563: l_procedure_name := 'SERIAL_NODE_EVENT';
1564:
1565: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
1566: IF inv_mwb_globals.g_chk_onhand = 0
1567: AND inv_mwb_globals.g_chk_receiving = 0
1568: AND inv_mwb_globals.g_chk_inbound = 0
1569: AND inv_mwb_globals.g_view_by = 'LPN' THEN
1570: make_common_query_lpn;
1571: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=

Line 1568: AND inv_mwb_globals.g_chk_inbound = 0

1564:
1565: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
1566: IF inv_mwb_globals.g_chk_onhand = 0
1567: AND inv_mwb_globals.g_chk_receiving = 0
1568: AND inv_mwb_globals.g_chk_inbound = 0
1569: AND inv_mwb_globals.g_view_by = 'LPN' THEN
1570: make_common_query_lpn;
1571: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=
1572: 'wlpn.subinventory_code';

Line 1569: AND inv_mwb_globals.g_view_by = 'LPN' THEN

1565: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
1566: IF inv_mwb_globals.g_chk_onhand = 0
1567: AND inv_mwb_globals.g_chk_receiving = 0
1568: AND inv_mwb_globals.g_chk_inbound = 0
1569: AND inv_mwb_globals.g_view_by = 'LPN' THEN
1570: make_common_query_lpn;
1571: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=
1572: 'wlpn.subinventory_code';
1573: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=

Line 1598: inv_mwb_query_manager.add_bind_variable('onh_serial_number', inv_mwb_globals. g_tree_serial_number);

1594: inv_mwb_query_manager.add_group_clause('wlc.cost_group_id','ONHAND');
1595:
1596: inv_mwb_query_manager.add_where_clause('wlpn.lpn_id = :onh_lpn_id', 'ONHAND');
1597: inv_mwb_query_manager.add_where_clause('msn.serial_number = :onh_serial_number', 'ONHAND');
1598: inv_mwb_query_manager.add_bind_variable('onh_serial_number', inv_mwb_globals. g_tree_serial_number);
1599: inv_mwb_query_manager.add_bind_variable('onh_lpn_id', inv_mwb_globals.g_tree_parent_lpn_id);
1600: inv_mwb_query_manager.add_qf_where_lpn_node('ONHAND');
1601: inv_mwb_query_manager.execute_query;
1602: RETURN;

Line 1599: inv_mwb_query_manager.add_bind_variable('onh_lpn_id', inv_mwb_globals.g_tree_parent_lpn_id);

1595:
1596: inv_mwb_query_manager.add_where_clause('wlpn.lpn_id = :onh_lpn_id', 'ONHAND');
1597: inv_mwb_query_manager.add_where_clause('msn.serial_number = :onh_serial_number', 'ONHAND');
1598: inv_mwb_query_manager.add_bind_variable('onh_serial_number', inv_mwb_globals. g_tree_serial_number);
1599: inv_mwb_query_manager.add_bind_variable('onh_lpn_id', inv_mwb_globals.g_tree_parent_lpn_id);
1600: inv_mwb_query_manager.add_qf_where_lpn_node('ONHAND');
1601: inv_mwb_query_manager.execute_query;
1602: RETURN;
1603: END IF;

Line 1605: IF inv_mwb_globals.g_tree_mat_loc_id = 1 THEN

1601: inv_mwb_query_manager.execute_query;
1602: RETURN;
1603: END IF;
1604:
1605: IF inv_mwb_globals.g_tree_mat_loc_id = 1 THEN
1606: make_common_query_onhand('MSN');
1607: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
1608:
1609: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=

Line 1635: inv_mwb_query_manager.add_bind_variable('onh_lpn_id', inv_mwb_globals.g_tree_parent_lpn_id);

1631: inv_mwb_query_manager.add_group_clause('msn.lpn_id','ONHAND');
1632: inv_mwb_query_manager.add_group_clause('msn.cost_group_id','ONHAND');
1633:
1634: inv_mwb_query_manager.add_where_clause('msn.lpn_id = :onh_lpn_id', 'ONHAND');
1635: inv_mwb_query_manager.add_bind_variable('onh_lpn_id', inv_mwb_globals.g_tree_parent_lpn_id);
1636: inv_mwb_query_manager.add_where_clause('msn.inventory_item_id = :onh_inventory_item_id', 'ONHAND');
1637: inv_mwb_query_manager.add_bind_variable('onh_inventory_item_id', inv_mwb_globals.g_tree_item_id);
1638: inv_mwb_query_manager.add_where_clause('msn.serial_number = :onh_serial_number', 'ONHAND');
1639: inv_mwb_query_manager.add_bind_variable('onh_serial_number', inv_mwb_globals. g_tree_serial_number);

Line 1637: inv_mwb_query_manager.add_bind_variable('onh_inventory_item_id', inv_mwb_globals.g_tree_item_id);

1633:
1634: inv_mwb_query_manager.add_where_clause('msn.lpn_id = :onh_lpn_id', 'ONHAND');
1635: inv_mwb_query_manager.add_bind_variable('onh_lpn_id', inv_mwb_globals.g_tree_parent_lpn_id);
1636: inv_mwb_query_manager.add_where_clause('msn.inventory_item_id = :onh_inventory_item_id', 'ONHAND');
1637: inv_mwb_query_manager.add_bind_variable('onh_inventory_item_id', inv_mwb_globals.g_tree_item_id);
1638: inv_mwb_query_manager.add_where_clause('msn.serial_number = :onh_serial_number', 'ONHAND');
1639: inv_mwb_query_manager.add_bind_variable('onh_serial_number', inv_mwb_globals. g_tree_serial_number);
1640:
1641: IF inv_mwb_globals.g_tree_rev IS NOT NULL THEN

Line 1639: inv_mwb_query_manager.add_bind_variable('onh_serial_number', inv_mwb_globals. g_tree_serial_number);

1635: inv_mwb_query_manager.add_bind_variable('onh_lpn_id', inv_mwb_globals.g_tree_parent_lpn_id);
1636: inv_mwb_query_manager.add_where_clause('msn.inventory_item_id = :onh_inventory_item_id', 'ONHAND');
1637: inv_mwb_query_manager.add_bind_variable('onh_inventory_item_id', inv_mwb_globals.g_tree_item_id);
1638: inv_mwb_query_manager.add_where_clause('msn.serial_number = :onh_serial_number', 'ONHAND');
1639: inv_mwb_query_manager.add_bind_variable('onh_serial_number', inv_mwb_globals. g_tree_serial_number);
1640:
1641: IF inv_mwb_globals.g_tree_rev IS NOT NULL THEN
1642: inv_mwb_query_manager.add_where_clause('msn.revision = :onh_revision', 'ONHAND');
1643: inv_mwb_query_manager.add_bind_variable('onh_revision', inv_mwb_globals.g_tree_rev);

Line 1641: IF inv_mwb_globals.g_tree_rev IS NOT NULL THEN

1637: inv_mwb_query_manager.add_bind_variable('onh_inventory_item_id', inv_mwb_globals.g_tree_item_id);
1638: inv_mwb_query_manager.add_where_clause('msn.serial_number = :onh_serial_number', 'ONHAND');
1639: inv_mwb_query_manager.add_bind_variable('onh_serial_number', inv_mwb_globals. g_tree_serial_number);
1640:
1641: IF inv_mwb_globals.g_tree_rev IS NOT NULL THEN
1642: inv_mwb_query_manager.add_where_clause('msn.revision = :onh_revision', 'ONHAND');
1643: inv_mwb_query_manager.add_bind_variable('onh_revision', inv_mwb_globals.g_tree_rev);
1644: END IF;
1645: IF inv_mwb_globals.g_tree_lot_number IS NOT NULL THEN

Line 1643: inv_mwb_query_manager.add_bind_variable('onh_revision', inv_mwb_globals.g_tree_rev);

1639: inv_mwb_query_manager.add_bind_variable('onh_serial_number', inv_mwb_globals. g_tree_serial_number);
1640:
1641: IF inv_mwb_globals.g_tree_rev IS NOT NULL THEN
1642: inv_mwb_query_manager.add_where_clause('msn.revision = :onh_revision', 'ONHAND');
1643: inv_mwb_query_manager.add_bind_variable('onh_revision', inv_mwb_globals.g_tree_rev);
1644: END IF;
1645: IF inv_mwb_globals.g_tree_lot_number IS NOT NULL THEN
1646: inv_mwb_query_manager.add_where_clause('msn.lot_number = :onh_lot_number', 'ONHAND');
1647: inv_mwb_query_manager.add_bind_variable('onh_lot_number', inv_mwb_globals.g_tree_lot_number);

Line 1645: IF inv_mwb_globals.g_tree_lot_number IS NOT NULL THEN

1641: IF inv_mwb_globals.g_tree_rev IS NOT NULL THEN
1642: inv_mwb_query_manager.add_where_clause('msn.revision = :onh_revision', 'ONHAND');
1643: inv_mwb_query_manager.add_bind_variable('onh_revision', inv_mwb_globals.g_tree_rev);
1644: END IF;
1645: IF inv_mwb_globals.g_tree_lot_number IS NOT NULL THEN
1646: inv_mwb_query_manager.add_where_clause('msn.lot_number = :onh_lot_number', 'ONHAND');
1647: inv_mwb_query_manager.add_bind_variable('onh_lot_number', inv_mwb_globals.g_tree_lot_number);
1648: END IF;
1649: END IF;

Line 1647: inv_mwb_query_manager.add_bind_variable('onh_lot_number', inv_mwb_globals.g_tree_lot_number);

1643: inv_mwb_query_manager.add_bind_variable('onh_revision', inv_mwb_globals.g_tree_rev);
1644: END IF;
1645: IF inv_mwb_globals.g_tree_lot_number IS NOT NULL THEN
1646: inv_mwb_query_manager.add_where_clause('msn.lot_number = :onh_lot_number', 'ONHAND');
1647: inv_mwb_query_manager.add_bind_variable('onh_lot_number', inv_mwb_globals.g_tree_lot_number);
1648: END IF;
1649: END IF;
1650:
1651: IF inv_mwb_globals.g_tree_mat_loc_id = 2 THEN

Line 1651: IF inv_mwb_globals.g_tree_mat_loc_id = 2 THEN

1647: inv_mwb_query_manager.add_bind_variable('onh_lot_number', inv_mwb_globals.g_tree_lot_number);
1648: END IF;
1649: END IF;
1650:
1651: IF inv_mwb_globals.g_tree_mat_loc_id = 2 THEN
1652: make_common_query_receiving('MSN_QUERY');
1653: inv_mwb_query_manager.add_qf_where_receiving('MSN_RECEIVING');
1654:
1655: inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=

Line 1681: inv_mwb_query_manager.add_bind_variable('onh_lpn_id', inv_mwb_globals.g_tree_parent_lpn_id);

1677: inv_mwb_query_manager.add_group_clause('msn.lpn_id','RECEIVING');
1678: inv_mwb_query_manager.add_group_clause('msn.cost_group_id','RECEIVING');
1679:
1680: inv_mwb_query_manager.add_where_clause('msn.lpn_id = :onh_lpn_id', 'RECEIVING');
1681: inv_mwb_query_manager.add_bind_variable('onh_lpn_id', inv_mwb_globals.g_tree_parent_lpn_id);
1682: inv_mwb_query_manager.add_where_clause('msn.inventory_item_id = :onh_inventory_item_id', 'RECEIVING');
1683: inv_mwb_query_manager.add_bind_variable('onh_inventory_item_id', inv_mwb_globals.g_tree_item_id);
1684: inv_mwb_query_manager.add_where_clause('msn.serial_number = :onh_serial_number', 'RECEIVING');
1685: inv_mwb_query_manager.add_bind_variable('onh_serial_number', inv_mwb_globals. g_tree_serial_number);

Line 1683: inv_mwb_query_manager.add_bind_variable('onh_inventory_item_id', inv_mwb_globals.g_tree_item_id);

1679:
1680: inv_mwb_query_manager.add_where_clause('msn.lpn_id = :onh_lpn_id', 'RECEIVING');
1681: inv_mwb_query_manager.add_bind_variable('onh_lpn_id', inv_mwb_globals.g_tree_parent_lpn_id);
1682: inv_mwb_query_manager.add_where_clause('msn.inventory_item_id = :onh_inventory_item_id', 'RECEIVING');
1683: inv_mwb_query_manager.add_bind_variable('onh_inventory_item_id', inv_mwb_globals.g_tree_item_id);
1684: inv_mwb_query_manager.add_where_clause('msn.serial_number = :onh_serial_number', 'RECEIVING');
1685: inv_mwb_query_manager.add_bind_variable('onh_serial_number', inv_mwb_globals. g_tree_serial_number);
1686:
1687: IF inv_mwb_globals.g_tree_rev IS NOT NULL THEN

Line 1685: inv_mwb_query_manager.add_bind_variable('onh_serial_number', inv_mwb_globals. g_tree_serial_number);

1681: inv_mwb_query_manager.add_bind_variable('onh_lpn_id', inv_mwb_globals.g_tree_parent_lpn_id);
1682: inv_mwb_query_manager.add_where_clause('msn.inventory_item_id = :onh_inventory_item_id', 'RECEIVING');
1683: inv_mwb_query_manager.add_bind_variable('onh_inventory_item_id', inv_mwb_globals.g_tree_item_id);
1684: inv_mwb_query_manager.add_where_clause('msn.serial_number = :onh_serial_number', 'RECEIVING');
1685: inv_mwb_query_manager.add_bind_variable('onh_serial_number', inv_mwb_globals. g_tree_serial_number);
1686:
1687: IF inv_mwb_globals.g_tree_rev IS NOT NULL THEN
1688: inv_mwb_query_manager.add_where_clause('msn.revision = :onh_revision', 'RECEIVING');
1689: inv_mwb_query_manager.add_bind_variable('onh_revision', inv_mwb_globals.g_tree_rev);

Line 1687: IF inv_mwb_globals.g_tree_rev IS NOT NULL THEN

1683: inv_mwb_query_manager.add_bind_variable('onh_inventory_item_id', inv_mwb_globals.g_tree_item_id);
1684: inv_mwb_query_manager.add_where_clause('msn.serial_number = :onh_serial_number', 'RECEIVING');
1685: inv_mwb_query_manager.add_bind_variable('onh_serial_number', inv_mwb_globals. g_tree_serial_number);
1686:
1687: IF inv_mwb_globals.g_tree_rev IS NOT NULL THEN
1688: inv_mwb_query_manager.add_where_clause('msn.revision = :onh_revision', 'RECEIVING');
1689: inv_mwb_query_manager.add_bind_variable('onh_revision', inv_mwb_globals.g_tree_rev);
1690: END IF;
1691: IF inv_mwb_globals.g_tree_lot_number IS NOT NULL THEN

Line 1689: inv_mwb_query_manager.add_bind_variable('onh_revision', inv_mwb_globals.g_tree_rev);

1685: inv_mwb_query_manager.add_bind_variable('onh_serial_number', inv_mwb_globals. g_tree_serial_number);
1686:
1687: IF inv_mwb_globals.g_tree_rev IS NOT NULL THEN
1688: inv_mwb_query_manager.add_where_clause('msn.revision = :onh_revision', 'RECEIVING');
1689: inv_mwb_query_manager.add_bind_variable('onh_revision', inv_mwb_globals.g_tree_rev);
1690: END IF;
1691: IF inv_mwb_globals.g_tree_lot_number IS NOT NULL THEN
1692: inv_mwb_query_manager.add_where_clause('msn.lot_number = :onh_lot_number', 'RECEIVING');
1693: inv_mwb_query_manager.add_bind_variable('onh_lot_number', inv_mwb_globals.g_tree_lot_number);

Line 1691: IF inv_mwb_globals.g_tree_lot_number IS NOT NULL THEN

1687: IF inv_mwb_globals.g_tree_rev IS NOT NULL THEN
1688: inv_mwb_query_manager.add_where_clause('msn.revision = :onh_revision', 'RECEIVING');
1689: inv_mwb_query_manager.add_bind_variable('onh_revision', inv_mwb_globals.g_tree_rev);
1690: END IF;
1691: IF inv_mwb_globals.g_tree_lot_number IS NOT NULL THEN
1692: inv_mwb_query_manager.add_where_clause('msn.lot_number = :onh_lot_number', 'RECEIVING');
1693: inv_mwb_query_manager.add_bind_variable('onh_lot_number', inv_mwb_globals.g_tree_lot_number);
1694: END IF;
1695: END IF;

Line 1693: inv_mwb_query_manager.add_bind_variable('onh_lot_number', inv_mwb_globals.g_tree_lot_number);

1689: inv_mwb_query_manager.add_bind_variable('onh_revision', inv_mwb_globals.g_tree_rev);
1690: END IF;
1691: IF inv_mwb_globals.g_tree_lot_number IS NOT NULL THEN
1692: inv_mwb_query_manager.add_where_clause('msn.lot_number = :onh_lot_number', 'RECEIVING');
1693: inv_mwb_query_manager.add_bind_variable('onh_lot_number', inv_mwb_globals.g_tree_lot_number);
1694: END IF;
1695: END IF;
1696:
1697: inv_mwb_query_manager.execute_query;

Line 1716: IF(inv_mwb_globals.g_chk_onhand = 1) THEN

1712:
1713:
1714: PROCEDURE make_common_query_onhand(p_flag VARCHAR2) IS
1715: BEGIN
1716: IF(inv_mwb_globals.g_chk_onhand = 1) THEN
1717: CASE p_flag
1718: WHEN 'MSN' THEN
1719: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ITEM_ID).column_value :=
1720: 'msn.inventory_item_id';

Line 1818: inv_mwb_globals.print_msg(g_pkg_name, l_procedure_name, 'Entered');

1814: PROCEDURE make_common_query_receiving(p_flag VARCHAR2) IS
1815: l_procedure_name VARCHAR2(30);
1816: BEGIN
1817: l_procedure_name := 'MAKE_COMMON_QUERY_RECEIVING';
1818: inv_mwb_globals.print_msg(g_pkg_name, l_procedure_name, 'Entered');
1819: inv_mwb_globals.print_msg(g_pkg_name, l_procedure_name, 'p_flag : ' || p_flag);
1820: IF(inv_mwb_globals.g_chk_receiving = 1) THEN
1821: IF p_flag = 'RECEIVING' THEN
1822: inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.ORG_ID).column_value :=

Line 1819: inv_mwb_globals.print_msg(g_pkg_name, l_procedure_name, 'p_flag : ' || p_flag);

1815: l_procedure_name VARCHAR2(30);
1816: BEGIN
1817: l_procedure_name := 'MAKE_COMMON_QUERY_RECEIVING';
1818: inv_mwb_globals.print_msg(g_pkg_name, l_procedure_name, 'Entered');
1819: inv_mwb_globals.print_msg(g_pkg_name, l_procedure_name, 'p_flag : ' || p_flag);
1820: IF(inv_mwb_globals.g_chk_receiving = 1) THEN
1821: IF p_flag = 'RECEIVING' THEN
1822: inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.ORG_ID).column_value :=
1823: 'rs.to_organization_id';

Line 1820: IF(inv_mwb_globals.g_chk_receiving = 1) THEN

1816: BEGIN
1817: l_procedure_name := 'MAKE_COMMON_QUERY_RECEIVING';
1818: inv_mwb_globals.print_msg(g_pkg_name, l_procedure_name, 'Entered');
1819: inv_mwb_globals.print_msg(g_pkg_name, l_procedure_name, 'p_flag : ' || p_flag);
1820: IF(inv_mwb_globals.g_chk_receiving = 1) THEN
1821: IF p_flag = 'RECEIVING' THEN
1822: inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.ORG_ID).column_value :=
1823: 'rs.to_organization_id';
1824: inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.ITEM_ID).column_value :=

Line 1839: IF inv_mwb_globals.g_multiple_loc_selected = 'FALSE'

1835: inv_mwb_query_manager.add_group_clause('rs.item_id','RECEIVING');
1836: inv_mwb_query_manager.add_where_clause('rs.lpn_id IS NOT NULL', 'RECEIVING');
1837:
1838:
1839: IF inv_mwb_globals.g_multiple_loc_selected = 'FALSE'
1840: OR inv_mwb_globals.g_tree_node_type <> 'APPTREE_OBJECT_TRUNK' THEN
1841: inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.UNPACKED).column_value := 0;
1842: inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.PACKED).column_value :=
1843: 'SUM(rs.to_org_primary_quantity)';

Line 1840: OR inv_mwb_globals.g_tree_node_type <> 'APPTREE_OBJECT_TRUNK' THEN

1836: inv_mwb_query_manager.add_where_clause('rs.lpn_id IS NOT NULL', 'RECEIVING');
1837:
1838:
1839: IF inv_mwb_globals.g_multiple_loc_selected = 'FALSE'
1840: OR inv_mwb_globals.g_tree_node_type <> 'APPTREE_OBJECT_TRUNK' THEN
1841: inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.UNPACKED).column_value := 0;
1842: inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.PACKED).column_value :=
1843: 'SUM(rs.to_org_primary_quantity)';
1844:

Line 1869: IF inv_mwb_globals.g_multiple_loc_selected = 'FALSE'

1865: inv_mwb_query_manager.add_group_clause('wlpn.organization_id','RECEIVING');
1866: inv_mwb_query_manager.add_group_clause('wlc.inventory_item_id','RECEIVING');
1867: inv_mwb_query_manager.add_group_clause('wlc.uom_code','RECEIVING');
1868:
1869: IF inv_mwb_globals.g_multiple_loc_selected = 'FALSE'
1870: OR inv_mwb_globals.g_tree_node_type <> 'APPTREE_OBJECT_TRUNK' THEN
1871: inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.SECONDARY_UOM_CODE).column_value :=
1872: 'wlc.secondary_uom_code';
1873: inv_mwb_query_manager.add_group_clause('wlc.secondary_uom_code','RECEIVING');

Line 1870: OR inv_mwb_globals.g_tree_node_type <> 'APPTREE_OBJECT_TRUNK' THEN

1866: inv_mwb_query_manager.add_group_clause('wlc.inventory_item_id','RECEIVING');
1867: inv_mwb_query_manager.add_group_clause('wlc.uom_code','RECEIVING');
1868:
1869: IF inv_mwb_globals.g_multiple_loc_selected = 'FALSE'
1870: OR inv_mwb_globals.g_tree_node_type <> 'APPTREE_OBJECT_TRUNK' THEN
1871: inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.SECONDARY_UOM_CODE).column_value :=
1872: 'wlc.secondary_uom_code';
1873: inv_mwb_query_manager.add_group_clause('wlc.secondary_uom_code','RECEIVING');
1874: END IF;

Line 1890: IF inv_mwb_globals.g_multiple_loc_selected = 'FALSE'

1886: inv_mwb_query_manager.add_group_clause('msn.current_organization_id', 'RECEIVING');
1887: inv_mwb_query_manager.add_group_clause('msn.inventory_item_id', 'RECEIVING');
1888: inv_mwb_query_manager.add_group_clause('''Ea''', 'RECEIVING');
1889:
1890: IF inv_mwb_globals.g_multiple_loc_selected = 'FALSE'
1891: OR inv_mwb_globals.g_tree_node_type <> 'APPTREE_OBJECT_TRUNK' THEN
1892: inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.PACKED).column_value := 1;
1893: inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.UNPACKED).column_value := 0;
1894: END IF;

Line 1891: OR inv_mwb_globals.g_tree_node_type <> 'APPTREE_OBJECT_TRUNK' THEN

1887: inv_mwb_query_manager.add_group_clause('msn.inventory_item_id', 'RECEIVING');
1888: inv_mwb_query_manager.add_group_clause('''Ea''', 'RECEIVING');
1889:
1890: IF inv_mwb_globals.g_multiple_loc_selected = 'FALSE'
1891: OR inv_mwb_globals.g_tree_node_type <> 'APPTREE_OBJECT_TRUNK' THEN
1892: inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.PACKED).column_value := 1;
1893: inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.UNPACKED).column_value := 0;
1894: END IF;
1895:

Line 1909: IF inv_mwb_globals.g_multiple_loc_selected = 'FALSE'

1905: inv_mwb_query_manager.add_group_clause('msn.inventory_item_id' , 'RECEIVING');
1906: inv_mwb_query_manager.add_group_clause('msn.current_organization_id', 'RECEIVING');
1907: inv_mwb_query_manager.add_group_clause('''Ea''', 'RECEIVING');
1908:
1909: IF inv_mwb_globals.g_multiple_loc_selected = 'FALSE'
1910: OR inv_mwb_globals.g_tree_node_type <> 'APPTREE_OBJECT_TRUNK' THEN
1911: inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.PACKED).column_value :=
1912: 'count(1)';
1913: inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.UNPACKED).column_value := 0;

Line 1910: OR inv_mwb_globals.g_tree_node_type <> 'APPTREE_OBJECT_TRUNK' THEN

1906: inv_mwb_query_manager.add_group_clause('msn.current_organization_id', 'RECEIVING');
1907: inv_mwb_query_manager.add_group_clause('''Ea''', 'RECEIVING');
1908:
1909: IF inv_mwb_globals.g_multiple_loc_selected = 'FALSE'
1910: OR inv_mwb_globals.g_tree_node_type <> 'APPTREE_OBJECT_TRUNK' THEN
1911: inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.PACKED).column_value :=
1912: 'count(1)';
1913: inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.UNPACKED).column_value := 0;
1914: END IF;

Line 1934: -- IF inv_mwb_globals.g_prepacked <> 12 THEN -- For All states chosen dont add this where clause. -- Bug : 6023196

1930: 'wlc.secondary_uom_code';
1931: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ONHAND).column_value :=
1932: 'SUM(wlc.primary_quantity)'; --bug 4761399
1933:
1934: -- IF inv_mwb_globals.g_prepacked <> 12 THEN -- For All states chosen dont add this where clause. -- Bug : 6023196
1935: IF inv_mwb_globals.g_prepacked <> 999 THEN -- For All states chosen dont add this where clause. -- Bug : 6023196
1936: inv_mwb_query_manager.add_where_clause('wlpn.lpn_context = :onh_lpn_context', 'ONHAND');
1937: inv_mwb_query_manager.add_bind_variable('onh_lpn_context', inv_mwb_globals.g_prepacked);
1938: END IF;

Line 1935: IF inv_mwb_globals.g_prepacked <> 999 THEN -- For All states chosen dont add this where clause. -- Bug : 6023196

1931: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ONHAND).column_value :=
1932: 'SUM(wlc.primary_quantity)'; --bug 4761399
1933:
1934: -- IF inv_mwb_globals.g_prepacked <> 12 THEN -- For All states chosen dont add this where clause. -- Bug : 6023196
1935: IF inv_mwb_globals.g_prepacked <> 999 THEN -- For All states chosen dont add this where clause. -- Bug : 6023196
1936: inv_mwb_query_manager.add_where_clause('wlpn.lpn_context = :onh_lpn_context', 'ONHAND');
1937: inv_mwb_query_manager.add_bind_variable('onh_lpn_context', inv_mwb_globals.g_prepacked);
1938: END IF;
1939:

Line 1937: inv_mwb_query_manager.add_bind_variable('onh_lpn_context', inv_mwb_globals.g_prepacked);

1933:
1934: -- IF inv_mwb_globals.g_prepacked <> 12 THEN -- For All states chosen dont add this where clause. -- Bug : 6023196
1935: IF inv_mwb_globals.g_prepacked <> 999 THEN -- For All states chosen dont add this where clause. -- Bug : 6023196
1936: inv_mwb_query_manager.add_where_clause('wlpn.lpn_context = :onh_lpn_context', 'ONHAND');
1937: inv_mwb_query_manager.add_bind_variable('onh_lpn_context', inv_mwb_globals.g_prepacked);
1938: END IF;
1939:
1940: inv_mwb_query_manager.add_group_clause('wlpn.organization_id','ONHAND');
1941: inv_mwb_query_manager.add_group_clause('wlc.inventory_item_id','ONHAND');

Line 1958: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_EXPANDED'

1954: l_procedure_name := 'EVENT';
1955: x_tbl_index := 1;
1956: x_node_value := 1;
1957:
1958: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_EXPANDED'
1959: OR inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
1960:
1961: CASE inv_mwb_globals.g_tree_node_type
1962: WHEN 'APPTREE_OBJECT_TRUNK' THEN

Line 1959: OR inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN

1955: x_tbl_index := 1;
1956: x_node_value := 1;
1957:
1958: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_EXPANDED'
1959: OR inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
1960:
1961: CASE inv_mwb_globals.g_tree_node_type
1962: WHEN 'APPTREE_OBJECT_TRUNK' THEN
1963: root_node_event (

Line 1961: CASE inv_mwb_globals.g_tree_node_type

1957:
1958: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_EXPANDED'
1959: OR inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
1960:
1961: CASE inv_mwb_globals.g_tree_node_type
1962: WHEN 'APPTREE_OBJECT_TRUNK' THEN
1963: root_node_event (
1964: x_node_value
1965: , x_node_tbl