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 THEN -- Bug 6429880
48: make_common_query_onhand('MSN_QUERY');

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 THEN -- Bug 6429880
48: make_common_query_onhand('MSN_QUERY');
49: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');

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 THEN -- Bug 6429880
48: make_common_query_onhand('MSN_QUERY');
49: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
50: ELSE

Line 47: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL THEN -- 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 THEN -- Bug 6429880
48: make_common_query_onhand('MSN_QUERY');
49: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
50: ELSE
51: make_common_query_onhand('MOQD');

Line 56: IF inv_mwb_globals.g_chk_receiving = 1 THEN

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

Line 57: IF inv_mwb_globals.g_serial_from IS NOT NULL OR

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

Line 58: inv_mwb_globals.g_serial_to IS NOT NULL THEN

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

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

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

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

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

Line 94: IF inv_mwb_globals.g_chk_onhand = 0 AND

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

Line 95: inv_mwb_globals.g_chk_receiving = 0 AND

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

Line 96: inv_mwb_globals.g_chk_inbound = 0 THEN

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

Line 107: IF inv_mwb_globals.g_chk_onhand = 1

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

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

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

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

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

Line 135: IF inv_mwb_globals.g_chk_onhand = 0

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

Line 136: AND inv_mwb_globals.g_chk_receiving = 0

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

Line 137: AND inv_mwb_globals.g_chk_inbound = 0

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

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

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

Line 159: IF inv_mwb_globals.g_chk_onhand = 1 THEN

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

Line 160: IF inv_mwb_globals.g_serial_from IS NOT NULL OR

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

Line 161: inv_mwb_globals.g_serial_to IS NOT NULL THEN

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

Line 196: IF inv_mwb_globals.g_chk_receiving = 1 THEN

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

Line 197: IF inv_mwb_globals.g_serial_from IS NOT NULL OR

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

Line 198: inv_mwb_globals.g_serial_to IS NOT NULL THEN

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

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

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

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

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

Line 256: IF inv_mwb_globals.g_chk_onhand = 0

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

Line 257: AND inv_mwb_globals.g_chk_receiving = 0

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

Line 258: AND inv_mwb_globals.g_chk_inbound = 0

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

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

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

Line 280: IF inv_mwb_globals.g_tree_mat_loc_id = 1 THEN

276: inv_mwb_query_manager.execute_query;
277: RETURN;
278: END IF;
279:
280: IF inv_mwb_globals.g_tree_mat_loc_id = 1 THEN
281: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
282: inv_mwb_globals.g_serial_to IS NOT NULL
283: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL THEN -- Bug 6429880
284: make_common_query_onhand('MSN_QUERY');

Line 281: IF inv_mwb_globals.g_serial_from IS NOT NULL OR

277: RETURN;
278: END IF;
279:
280: IF inv_mwb_globals.g_tree_mat_loc_id = 1 THEN
281: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
282: inv_mwb_globals.g_serial_to IS NOT NULL
283: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL THEN -- Bug 6429880
284: make_common_query_onhand('MSN_QUERY');
285: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');

Line 282: inv_mwb_globals.g_serial_to IS NOT NULL

278: END IF;
279:
280: IF inv_mwb_globals.g_tree_mat_loc_id = 1 THEN
281: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
282: inv_mwb_globals.g_serial_to IS NOT NULL
283: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL THEN -- Bug 6429880
284: make_common_query_onhand('MSN_QUERY');
285: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
286: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=

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

279:
280: IF inv_mwb_globals.g_tree_mat_loc_id = 1 THEN
281: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
282: inv_mwb_globals.g_serial_to IS NOT NULL
283: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL THEN -- Bug 6429880
284: make_common_query_onhand('MSN_QUERY');
285: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
286: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=
287: 'msn.current_subinventory_code';

Line 319: IF inv_mwb_globals.g_tree_mat_loc_id = 2 THEN

315:
316: END IF;
317: END IF;
318:
319: IF inv_mwb_globals.g_tree_mat_loc_id = 2 THEN
320: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
321: inv_mwb_globals.g_serial_to IS NOT NULL THEN
322: make_common_query_receiving('MSN_QUERY');
323: inv_mwb_query_manager.add_qf_where_receiving('MSN_RECEIVING');

Line 320: IF inv_mwb_globals.g_serial_from IS NOT NULL OR

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

Line 321: inv_mwb_globals.g_serial_to IS NOT NULL THEN

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

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

360: l_procedure_name VARCHAR2(30);
361: BEGIN
362:
363: l_procedure_name := 'LPN_NODE_EVENT';
364: inv_mwb_globals.print_msg( g_pkg_name, l_procedure_name, 'Entered' );
365:
366: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_EXPANDED' THEN
367: inv_mwb_tree1.add_lpns (
368: x_node_value

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

362:
363: l_procedure_name := 'LPN_NODE_EVENT';
364: inv_mwb_globals.print_msg( g_pkg_name, l_procedure_name, 'Entered' );
365:
366: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_EXPANDED' THEN
367: inv_mwb_tree1.add_lpns (
368: x_node_value
369: , x_node_tbl
370: , x_tbl_index

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

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

Line 383: IF inv_mwb_globals.g_chk_onhand = 0

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

Line 384: AND inv_mwb_globals.g_chk_receiving = 0

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

Line 385: AND inv_mwb_globals.g_chk_inbound = 0

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

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

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

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

403: inv_mwb_query_manager.add_group_clause('wlpn.lpn_id','ONHAND');
404: inv_mwb_query_manager.add_group_clause('wlc.cost_group_id','ONHAND');
405:
406: inv_mwb_query_manager.add_where_clause('wlpn.lpn_id = :onh_lpn_id', 'ONHAND');
407: inv_mwb_query_manager.add_bind_variable('onh_lpn_id', inv_mwb_globals.g_tree_parent_lpn_id);
408: inv_mwb_query_manager.execute_query;
409: RETURN;
410: END IF;
411:

Line 414: IF inv_mwb_globals.g_tree_mat_loc_id = 1 THEN

410: END IF;
411:
412: -- inv_mwb_query_manager.make_nested_lpn_onhand_query;
413:
414: IF inv_mwb_globals.g_tree_mat_loc_id = 1 THEN
415: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
416: inv_mwb_globals.g_serial_to IS NOT NULL
417: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL THEN -- Bug 6429880
418:

Line 415: IF inv_mwb_globals.g_serial_from IS NOT NULL OR

411:
412: -- inv_mwb_query_manager.make_nested_lpn_onhand_query;
413:
414: IF inv_mwb_globals.g_tree_mat_loc_id = 1 THEN
415: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
416: inv_mwb_globals.g_serial_to IS NOT NULL
417: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL THEN -- Bug 6429880
418:
419: inv_mwb_query_manager.make_nested_lpn_onhand_query;

Line 416: inv_mwb_globals.g_serial_to IS NOT NULL

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

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

413:
414: IF inv_mwb_globals.g_tree_mat_loc_id = 1 THEN
415: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
416: inv_mwb_globals.g_serial_to IS NOT NULL
417: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL THEN -- Bug 6429880
418:
419: inv_mwb_query_manager.make_nested_lpn_onhand_query;
420:
421: make_common_query_onhand('MSN_QUERY');

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

434: inv_mwb_query_manager.add_group_clause('msn.lpn_id','ONHAND');
435: inv_mwb_query_manager.add_group_clause('msn.cost_group_id','ONHAND');
436:
437: inv_mwb_query_manager.add_where_clause('msn.lpn_id = :onh_lpn_id', 'ONHAND');
438: inv_mwb_query_manager.add_bind_variable('onh_lpn_id', inv_mwb_globals.g_tree_parent_lpn_id);
439:
440: ELSE
441:
442: inv_mwb_query_manager.make_nested_lpn_onhand_query;

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

456: inv_mwb_query_manager.add_group_clause('moqd.lpn_id','ONHAND');
457: inv_mwb_query_manager.add_group_clause('moqd.cost_group_id','ONHAND');
458:
459: inv_mwb_query_manager.add_where_clause('moqd.lpn_id = :onh_lpn_id', 'ONHAND');
460: inv_mwb_query_manager.add_bind_variable('onh_lpn_id', inv_mwb_globals.g_tree_parent_lpn_id);
461:
462: END IF;
463: END IF;
464:

Line 465: IF inv_mwb_globals.g_tree_mat_loc_id = 2 THEN

461:
462: END IF;
463: END IF;
464:
465: IF inv_mwb_globals.g_tree_mat_loc_id = 2 THEN
466:
467: inv_mwb_query_manager.make_nested_lpn_rcv_query;
468:
469: IF inv_mwb_globals.g_serial_from IS NOT NULL OR

Line 469: IF inv_mwb_globals.g_serial_from IS NOT NULL OR

465: IF inv_mwb_globals.g_tree_mat_loc_id = 2 THEN
466:
467: inv_mwb_query_manager.make_nested_lpn_rcv_query;
468:
469: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
470: inv_mwb_globals.g_serial_to IS NOT NULL THEN
471: make_common_query_receiving('MSN_QUERY');
472: inv_mwb_query_manager.add_qf_where_receiving('MSN_RECEIVING');
473: inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=

Line 470: inv_mwb_globals.g_serial_to IS NOT NULL THEN

466:
467: inv_mwb_query_manager.make_nested_lpn_rcv_query;
468:
469: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
470: inv_mwb_globals.g_serial_to IS NOT NULL THEN
471: make_common_query_receiving('MSN_QUERY');
472: inv_mwb_query_manager.add_qf_where_receiving('MSN_RECEIVING');
473: inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=
474: 'msn.current_subinventory_code';

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

481: inv_mwb_query_manager.add_group_clause('msn.current_locator_id','RECEIVING');
482: inv_mwb_query_manager.add_group_clause('msn.lpn_id','RECEIVING');
483:
484: inv_mwb_query_manager.add_where_clause('msn.lpn_id = :rcv_lpn_id', 'RECEIVING');
485: inv_mwb_query_manager.add_bind_variable('rcv_lpn_id', inv_mwb_globals.g_tree_parent_lpn_id);
486:
487: ELSE
488:
489: make_common_query_receiving('RECEIVING');

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

499: inv_mwb_query_manager.add_group_clause('rs.to_locator_id','RECEIVING');
500: inv_mwb_query_manager.add_group_clause('rs.lpn_id','RECEIVING');
501:
502: inv_mwb_query_manager.add_where_clause('rs.lpn_id = :rcv_lpn_id', 'RECEIVING');
503: inv_mwb_query_manager.add_bind_variable('rcv_lpn_id', inv_mwb_globals.g_tree_parent_lpn_id);
504:
505: END IF;
506: END IF;
507: inv_mwb_query_manager.execute_query;

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

531: BEGIN
532:
533: l_procedure_name := 'ITEM_NODE_EVENT';
534:
535: inv_mwb_globals.print_msg( g_pkg_name, l_procedure_name, 'Item Node Event-Entered' );
536:
537: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_EXPANDED' THEN
538: inv_mwb_tree1.add_revs (
539: x_node_value

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

533: l_procedure_name := 'ITEM_NODE_EVENT';
534:
535: inv_mwb_globals.print_msg( g_pkg_name, l_procedure_name, 'Item Node Event-Entered' );
536:
537: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_EXPANDED' THEN
538: inv_mwb_tree1.add_revs (
539: x_node_value
540: , x_node_tbl
541: , x_tbl_index

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

549: );
550:
551:
552: IF x_tbl_index = 1 THEN
553: IF NVL(inv_mwb_globals.g_prepacked,-99) <> 10 THEN
554: inv_mwb_tree1.add_serials (
555: x_node_value
556: , x_node_tbl
557: , x_tbl_index

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

562: END IF;
563: END IF;
564:
565:
566: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
567:
568: SELECT revision_qty_control_code,
569: lot_control_code,
570: serial_number_control_code

Line 575: WHERE inventory_item_id = inv_mwb_globals.g_tree_item_id

571: INTO l_rev_control,
572: l_lot_control,
573: l_serial_control
574: FROM mtl_system_items
575: WHERE inventory_item_id = inv_mwb_globals.g_tree_item_id
576: AND organization_id = inv_mwb_globals.g_organization_id;
577:
578: -- If all material locations are unchecked and the view by is LPN
579: -- Using ONHAND but it does not query onhand material location.

Line 576: AND organization_id = inv_mwb_globals.g_organization_id;

572: l_lot_control,
573: l_serial_control
574: FROM mtl_system_items
575: WHERE inventory_item_id = inv_mwb_globals.g_tree_item_id
576: AND organization_id = inv_mwb_globals.g_organization_id;
577:
578: -- If all material locations are unchecked and the view by is LPN
579: -- Using ONHAND but it does not query onhand material location.
580: IF inv_mwb_globals.g_chk_onhand = 0

Line 580: IF inv_mwb_globals.g_chk_onhand = 0

576: AND organization_id = inv_mwb_globals.g_organization_id;
577:
578: -- If all material locations are unchecked and the view by is LPN
579: -- Using ONHAND but it does not query onhand material location.
580: IF inv_mwb_globals.g_chk_onhand = 0
581: AND inv_mwb_globals.g_chk_receiving = 0
582: AND inv_mwb_globals.g_chk_inbound = 0
583: AND inv_mwb_globals.g_view_by = 'LPN' THEN
584: make_common_query_lpn;

Line 581: AND inv_mwb_globals.g_chk_receiving = 0

577:
578: -- If all material locations are unchecked and the view by is LPN
579: -- Using ONHAND but it does not query onhand material location.
580: IF inv_mwb_globals.g_chk_onhand = 0
581: AND inv_mwb_globals.g_chk_receiving = 0
582: AND inv_mwb_globals.g_chk_inbound = 0
583: AND inv_mwb_globals.g_view_by = 'LPN' THEN
584: make_common_query_lpn;
585: inv_mwb_query_manager.add_qf_where_lpn_node('ONHAND');

Line 582: AND inv_mwb_globals.g_chk_inbound = 0

578: -- If all material locations are unchecked and the view by is LPN
579: -- Using ONHAND but it does not query onhand material location.
580: IF inv_mwb_globals.g_chk_onhand = 0
581: AND inv_mwb_globals.g_chk_receiving = 0
582: AND inv_mwb_globals.g_chk_inbound = 0
583: AND inv_mwb_globals.g_view_by = 'LPN' THEN
584: make_common_query_lpn;
585: inv_mwb_query_manager.add_qf_where_lpn_node('ONHAND');
586: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=

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

579: -- Using ONHAND but it does not query onhand material location.
580: IF inv_mwb_globals.g_chk_onhand = 0
581: AND inv_mwb_globals.g_chk_receiving = 0
582: AND inv_mwb_globals.g_chk_inbound = 0
583: AND inv_mwb_globals.g_view_by = 'LPN' THEN
584: make_common_query_lpn;
585: inv_mwb_query_manager.add_qf_where_lpn_node('ONHAND');
586: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=
587: 'wlpn.subinventory_code';

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

607: END IF;
608: END IF;
609:
610: /*LPN Status Project */
611: IF (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) THEN
612: l_default_status_id := inv_cache.org_rec.default_status_id;
613: END IF;
614:
615: IF inv_cache.set_item_rec(inv_mwb_globals.g_tree_organization_id, inv_mwb_globals.g_tree_item_id) THEN

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

611: IF (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) THEN
612: l_default_status_id := inv_cache.org_rec.default_status_id;
613: END IF;
614:
615: IF inv_cache.set_item_rec(inv_mwb_globals.g_tree_organization_id, inv_mwb_globals.g_tree_item_id) THEN
616:
617: IF (inv_cache.item_rec.serial_number_control_code in (2,5)) THEN
618: l_serial_controlled := 1; -- Item is serial controlled
619: END IF;

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

625: END IF;
626:
627: IF (l_default_status_id IS NOT NULL AND l_serial_controlled = 0 AND l_lot_controlled = 0) THEN
628:
629: l_status_id := INV_MATERIAL_STATUS_GRP.get_default_status(p_organization_id => inv_mwb_globals.g_organization_id,
630: p_inventory_item_id=>inv_mwb_globals.g_tree_item_id ,
631: p_sub_code=>inv_mwb_globals.g_tree_subinventory_code,
632: p_loc_id=>inv_mwb_globals.g_tree_loc_id,
633: p_lot_number=>inv_mwb_globals.g_tree_lot_number,

Line 630: p_inventory_item_id=>inv_mwb_globals.g_tree_item_id ,

626:
627: IF (l_default_status_id IS NOT NULL AND l_serial_controlled = 0 AND l_lot_controlled = 0) THEN
628:
629: l_status_id := INV_MATERIAL_STATUS_GRP.get_default_status(p_organization_id => inv_mwb_globals.g_organization_id,
630: p_inventory_item_id=>inv_mwb_globals.g_tree_item_id ,
631: p_sub_code=>inv_mwb_globals.g_tree_subinventory_code,
632: p_loc_id=>inv_mwb_globals.g_tree_loc_id,
633: p_lot_number=>inv_mwb_globals.g_tree_lot_number,
634: p_lpn_id=>inv_mwb_globals.g_tree_parent_lpn_id);

Line 631: p_sub_code=>inv_mwb_globals.g_tree_subinventory_code,

627: IF (l_default_status_id IS NOT NULL AND l_serial_controlled = 0 AND l_lot_controlled = 0) THEN
628:
629: l_status_id := INV_MATERIAL_STATUS_GRP.get_default_status(p_organization_id => inv_mwb_globals.g_organization_id,
630: p_inventory_item_id=>inv_mwb_globals.g_tree_item_id ,
631: p_sub_code=>inv_mwb_globals.g_tree_subinventory_code,
632: p_loc_id=>inv_mwb_globals.g_tree_loc_id,
633: p_lot_number=>inv_mwb_globals.g_tree_lot_number,
634: p_lpn_id=>inv_mwb_globals.g_tree_parent_lpn_id);
635:

Line 632: p_loc_id=>inv_mwb_globals.g_tree_loc_id,

628:
629: l_status_id := INV_MATERIAL_STATUS_GRP.get_default_status(p_organization_id => inv_mwb_globals.g_organization_id,
630: p_inventory_item_id=>inv_mwb_globals.g_tree_item_id ,
631: p_sub_code=>inv_mwb_globals.g_tree_subinventory_code,
632: p_loc_id=>inv_mwb_globals.g_tree_loc_id,
633: p_lot_number=>inv_mwb_globals.g_tree_lot_number,
634: p_lpn_id=>inv_mwb_globals.g_tree_parent_lpn_id);
635:
636: inv_mwb_globals.print_msg( g_pkg_name, l_procedure_name, 'Value of l_status_id:'|| l_status_id );

Line 633: p_lot_number=>inv_mwb_globals.g_tree_lot_number,

629: l_status_id := INV_MATERIAL_STATUS_GRP.get_default_status(p_organization_id => inv_mwb_globals.g_organization_id,
630: p_inventory_item_id=>inv_mwb_globals.g_tree_item_id ,
631: p_sub_code=>inv_mwb_globals.g_tree_subinventory_code,
632: p_loc_id=>inv_mwb_globals.g_tree_loc_id,
633: p_lot_number=>inv_mwb_globals.g_tree_lot_number,
634: p_lpn_id=>inv_mwb_globals.g_tree_parent_lpn_id);
635:
636: inv_mwb_globals.print_msg( g_pkg_name, l_procedure_name, 'Value of l_status_id:'|| l_status_id );
637:

Line 634: p_lpn_id=>inv_mwb_globals.g_tree_parent_lpn_id);

630: p_inventory_item_id=>inv_mwb_globals.g_tree_item_id ,
631: p_sub_code=>inv_mwb_globals.g_tree_subinventory_code,
632: p_loc_id=>inv_mwb_globals.g_tree_loc_id,
633: p_lot_number=>inv_mwb_globals.g_tree_lot_number,
634: p_lpn_id=>inv_mwb_globals.g_tree_parent_lpn_id);
635:
636: inv_mwb_globals.print_msg( g_pkg_name, l_procedure_name, 'Value of l_status_id:'|| l_status_id );
637:
638: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.STATUS_ID).column_value :=

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

632: p_loc_id=>inv_mwb_globals.g_tree_loc_id,
633: p_lot_number=>inv_mwb_globals.g_tree_lot_number,
634: p_lpn_id=>inv_mwb_globals.g_tree_parent_lpn_id);
635:
636: inv_mwb_globals.print_msg( g_pkg_name, l_procedure_name, 'Value of l_status_id:'|| l_status_id );
637:
638: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.STATUS_ID).column_value :=
639: l_status_id;
640: inv_mwb_query_manager.add_group_clause(l_status_id, 'ONHAND');

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

647: inv_mwb_query_manager.add_group_clause('wlpn.lpn_id','ONHAND');
648: inv_mwb_query_manager.add_group_clause('wlc.cost_group_id','ONHAND');
649:
650: inv_mwb_query_manager.add_where_clause('wlpn.lpn_id = :onh_lpn_id', 'ONHAND');
651: inv_mwb_query_manager.add_bind_variable('onh_lpn_id', inv_mwb_globals.g_tree_parent_lpn_id);
652:
653: inv_mwb_query_manager.add_where_clause('wlc.inventory_item_id = :onh_inventory_item_id', 'ONHAND');
654: inv_mwb_query_manager.add_bind_variable('onh_inventory_item_id', inv_mwb_globals.g_tree_item_id);
655:

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

650: inv_mwb_query_manager.add_where_clause('wlpn.lpn_id = :onh_lpn_id', 'ONHAND');
651: inv_mwb_query_manager.add_bind_variable('onh_lpn_id', inv_mwb_globals.g_tree_parent_lpn_id);
652:
653: inv_mwb_query_manager.add_where_clause('wlc.inventory_item_id = :onh_inventory_item_id', 'ONHAND');
654: inv_mwb_query_manager.add_bind_variable('onh_inventory_item_id', inv_mwb_globals.g_tree_item_id);
655:
656: inv_mwb_query_manager.execute_query;
657: RETURN;
658: END IF;

Line 662: IF inv_mwb_globals.g_tree_mat_loc_id = 1 THEN

658: END IF;
659:
660:
661:
662: IF inv_mwb_globals.g_tree_mat_loc_id = 1 THEN
663: IF (inv_mwb_globals.g_serial_from IS NOT NULL OR
664: inv_mwb_globals.g_serial_to IS NOT NULL)
665: OR (NVL(l_rev_control, 1) = 1
666: AND NVL(l_lot_control, 1) = 1

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

659:
660:
661:
662: IF inv_mwb_globals.g_tree_mat_loc_id = 1 THEN
663: IF (inv_mwb_globals.g_serial_from IS NOT NULL OR
664: inv_mwb_globals.g_serial_to IS NOT NULL)
665: OR (NVL(l_rev_control, 1) = 1
666: AND NVL(l_lot_control, 1) = 1
667: AND l_serial_control IN ( 2,5 ))

Line 664: inv_mwb_globals.g_serial_to IS NOT NULL)

660:
661:
662: IF inv_mwb_globals.g_tree_mat_loc_id = 1 THEN
663: IF (inv_mwb_globals.g_serial_from IS NOT NULL OR
664: inv_mwb_globals.g_serial_to IS NOT NULL)
665: OR (NVL(l_rev_control, 1) = 1
666: AND NVL(l_lot_control, 1) = 1
667: AND l_serial_control IN ( 2,5 ))
668: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL THEN -- Bug 6429880

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

664: inv_mwb_globals.g_serial_to IS NOT NULL)
665: OR (NVL(l_rev_control, 1) = 1
666: AND NVL(l_lot_control, 1) = 1
667: AND l_serial_control IN ( 2,5 ))
668: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL THEN -- Bug 6429880
669:
670: make_common_query_onhand('MSN');
671: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
672:

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

700: inv_mwb_query_manager.add_group_clause('msn.lpn_id','ONHAND');
701: inv_mwb_query_manager.add_group_clause('msn.cost_group_id','ONHAND');
702:
703: inv_mwb_query_manager.add_where_clause('msn.lpn_id = :onh_lpn_id', 'ONHAND');
704: inv_mwb_query_manager.add_bind_variable('onh_lpn_id', inv_mwb_globals.g_tree_parent_lpn_id);
705: inv_mwb_query_manager.add_where_clause('msn.inventory_item_id = :onh_inventory_item_id', 'ONHAND');
706: inv_mwb_query_manager.add_bind_variable('onh_inventory_item_id', inv_mwb_globals.g_tree_item_id);
707:
708: ELSE

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

702:
703: inv_mwb_query_manager.add_where_clause('msn.lpn_id = :onh_lpn_id', 'ONHAND');
704: inv_mwb_query_manager.add_bind_variable('onh_lpn_id', inv_mwb_globals.g_tree_parent_lpn_id);
705: inv_mwb_query_manager.add_where_clause('msn.inventory_item_id = :onh_inventory_item_id', 'ONHAND');
706: inv_mwb_query_manager.add_bind_variable('onh_inventory_item_id', inv_mwb_globals.g_tree_item_id);
707:
708: ELSE
709: make_common_query_onhand('MOQD');
710: inv_mwb_query_manager.add_qf_where_onhand('ONHAND');

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

719:
720: /* LPN Status Support */
721: -- For serial controlled items, the status_id will be populated in post_query of IMVMWQMB.
722:
723: inv_mwb_globals.print_msg( g_pkg_name, l_procedure_name, 'LPN Status check');
724:
725: IF (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) THEN
726: l_default_status_id := inv_cache.org_rec.default_status_id;
727: END IF;

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

721: -- For serial controlled items, the status_id will be populated in post_query of IMVMWQMB.
722:
723: inv_mwb_globals.print_msg( g_pkg_name, l_procedure_name, 'LPN Status check');
724:
725: IF (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) THEN
726: l_default_status_id := inv_cache.org_rec.default_status_id;
727: END IF;
728:
729: IF inv_cache.set_item_rec(inv_mwb_globals.g_tree_organization_id, inv_mwb_globals.g_tree_item_id) THEN

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

725: IF (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) THEN
726: l_default_status_id := inv_cache.org_rec.default_status_id;
727: END IF;
728:
729: IF inv_cache.set_item_rec(inv_mwb_globals.g_tree_organization_id, inv_mwb_globals.g_tree_item_id) THEN
730: IF (inv_cache.item_rec.serial_number_control_code in (2,5)) THEN
731: l_serial_controlled := 1; -- Item is serial controlled
732: END IF;
733:

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

759: inv_mwb_query_manager.add_group_clause('moqd.lpn_id','ONHAND');
760: inv_mwb_query_manager.add_group_clause('moqd.cost_group_id','ONHAND');
761:
762: inv_mwb_query_manager.add_where_clause('moqd.lpn_id = :onh_lpn_id', 'ONHAND');
763: inv_mwb_query_manager.add_bind_variable('onh_lpn_id', inv_mwb_globals.g_tree_parent_lpn_id);
764: inv_mwb_query_manager.add_where_clause('moqd.inventory_item_id = :onh_inventory_item_id', 'ONHAND');
765: inv_mwb_query_manager.add_bind_variable('onh_inventory_item_id', inv_mwb_globals.g_tree_item_id);
766:
767: END IF;

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

761:
762: inv_mwb_query_manager.add_where_clause('moqd.lpn_id = :onh_lpn_id', 'ONHAND');
763: inv_mwb_query_manager.add_bind_variable('onh_lpn_id', inv_mwb_globals.g_tree_parent_lpn_id);
764: inv_mwb_query_manager.add_where_clause('moqd.inventory_item_id = :onh_inventory_item_id', 'ONHAND');
765: inv_mwb_query_manager.add_bind_variable('onh_inventory_item_id', inv_mwb_globals.g_tree_item_id);
766:
767: END IF;
768: END IF;
769:

Line 770: IF inv_mwb_globals.g_tree_mat_loc_id = 2 THEN

766:
767: END IF;
768: END IF;
769:
770: IF inv_mwb_globals.g_tree_mat_loc_id = 2 THEN
771: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
772: inv_mwb_globals.g_serial_to IS NOT NULL
773: OR (NVL(l_rev_control, 1) = 1
774: AND NVL(l_lot_control, 1) = 1

Line 771: IF inv_mwb_globals.g_serial_from IS NOT NULL OR

767: END IF;
768: END IF;
769:
770: IF inv_mwb_globals.g_tree_mat_loc_id = 2 THEN
771: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
772: inv_mwb_globals.g_serial_to IS NOT NULL
773: OR (NVL(l_rev_control, 1) = 1
774: AND NVL(l_lot_control, 1) = 1
775: AND l_serial_control IN ( 2,5 )) THEN

Line 772: inv_mwb_globals.g_serial_to IS NOT NULL

768: END IF;
769:
770: IF inv_mwb_globals.g_tree_mat_loc_id = 2 THEN
771: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
772: inv_mwb_globals.g_serial_to IS NOT NULL
773: OR (NVL(l_rev_control, 1) = 1
774: AND NVL(l_lot_control, 1) = 1
775: AND l_serial_control IN ( 2,5 )) THEN
776:

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

803: END IF;
804: END IF;
805:
806: inv_mwb_query_manager.add_where_clause('msn.lpn_id = :rcv_lpn_id', 'RECEIVING');
807: inv_mwb_query_manager.add_bind_variable('rcv_lpn_id', inv_mwb_globals.g_tree_parent_lpn_id);
808: inv_mwb_query_manager.add_where_clause('msn.inventory_item_id = :onh_inventory_item_id', 'RECEIVING');
809: inv_mwb_query_manager.add_bind_variable('onh_inventory_item_id', inv_mwb_globals.g_tree_item_id);
810:
811:

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

805:
806: inv_mwb_query_manager.add_where_clause('msn.lpn_id = :rcv_lpn_id', 'RECEIVING');
807: inv_mwb_query_manager.add_bind_variable('rcv_lpn_id', inv_mwb_globals.g_tree_parent_lpn_id);
808: inv_mwb_query_manager.add_where_clause('msn.inventory_item_id = :onh_inventory_item_id', 'RECEIVING');
809: inv_mwb_query_manager.add_bind_variable('onh_inventory_item_id', inv_mwb_globals.g_tree_item_id);
810:
811:
812: ELSE
813: make_common_query_receiving('RECEIVING');

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

833: inv_mwb_query_manager.add_group_clause('rls.lot_num','RECEIVING');
834: END IF;
835:
836: inv_mwb_query_manager.add_where_clause('rs.lpn_id = :rcv_lpn_id', 'RECEIVING');
837: inv_mwb_query_manager.add_bind_variable('rcv_lpn_id', inv_mwb_globals.g_tree_parent_lpn_id);
838: inv_mwb_query_manager.add_where_clause('rs.item_id = :onh_inventory_item_id', 'RECEIVING');
839: inv_mwb_query_manager.add_bind_variable('onh_inventory_item_id', inv_mwb_globals.g_tree_item_id);
840:
841: END IF;

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

835:
836: inv_mwb_query_manager.add_where_clause('rs.lpn_id = :rcv_lpn_id', 'RECEIVING');
837: inv_mwb_query_manager.add_bind_variable('rcv_lpn_id', inv_mwb_globals.g_tree_parent_lpn_id);
838: inv_mwb_query_manager.add_where_clause('rs.item_id = :onh_inventory_item_id', 'RECEIVING');
839: inv_mwb_query_manager.add_bind_variable('onh_inventory_item_id', inv_mwb_globals.g_tree_item_id);
840:
841: END IF;
842: END IF;
843:

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

866: BEGIN
867:
868: l_procedure_name := 'REV_NODE_EVENT';
869:
870: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_EXPANDED' THEN
871: inv_mwb_tree1.add_lots (
872: x_node_value
873: , x_node_tbl
874: , x_tbl_index

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

882: );
883:
884: END IF;
885:
886: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
887:
888: SELECT lot_control_code,
889: serial_number_control_code
890: INTO l_lot_control,

Line 893: WHERE inventory_item_id = inv_mwb_globals.g_tree_item_id

889: serial_number_control_code
890: INTO l_lot_control,
891: l_serial_control
892: FROM mtl_system_items
893: WHERE inventory_item_id = inv_mwb_globals.g_tree_item_id
894: AND organization_id = inv_mwb_globals.g_organization_id;
895:
896: -- If all material locations are unchecked and the view by is LPN
897: -- Using ONHAND but it does not query onhand material location.

Line 894: AND organization_id = inv_mwb_globals.g_organization_id;

890: INTO l_lot_control,
891: l_serial_control
892: FROM mtl_system_items
893: WHERE inventory_item_id = inv_mwb_globals.g_tree_item_id
894: AND organization_id = inv_mwb_globals.g_organization_id;
895:
896: -- If all material locations are unchecked and the view by is LPN
897: -- Using ONHAND but it does not query onhand material location.
898: IF inv_mwb_globals.g_chk_onhand = 0

Line 898: IF inv_mwb_globals.g_chk_onhand = 0

894: AND organization_id = inv_mwb_globals.g_organization_id;
895:
896: -- If all material locations are unchecked and the view by is LPN
897: -- Using ONHAND but it does not query onhand material location.
898: IF inv_mwb_globals.g_chk_onhand = 0
899: AND inv_mwb_globals.g_chk_receiving = 0
900: AND inv_mwb_globals.g_chk_inbound = 0
901: AND inv_mwb_globals.g_view_by = 'LPN' THEN
902: make_common_query_lpn;

Line 899: AND inv_mwb_globals.g_chk_receiving = 0

895:
896: -- If all material locations are unchecked and the view by is LPN
897: -- Using ONHAND but it does not query onhand material location.
898: IF inv_mwb_globals.g_chk_onhand = 0
899: AND inv_mwb_globals.g_chk_receiving = 0
900: AND inv_mwb_globals.g_chk_inbound = 0
901: AND inv_mwb_globals.g_view_by = 'LPN' THEN
902: make_common_query_lpn;
903: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=

Line 900: AND inv_mwb_globals.g_chk_inbound = 0

896: -- If all material locations are unchecked and the view by is LPN
897: -- Using ONHAND but it does not query onhand material location.
898: IF inv_mwb_globals.g_chk_onhand = 0
899: AND inv_mwb_globals.g_chk_receiving = 0
900: AND inv_mwb_globals.g_chk_inbound = 0
901: AND inv_mwb_globals.g_view_by = 'LPN' THEN
902: make_common_query_lpn;
903: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=
904: 'wlpn.subinventory_code';

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

897: -- Using ONHAND but it does not query onhand material location.
898: IF inv_mwb_globals.g_chk_onhand = 0
899: AND inv_mwb_globals.g_chk_receiving = 0
900: AND inv_mwb_globals.g_chk_inbound = 0
901: AND inv_mwb_globals.g_view_by = 'LPN' THEN
902: make_common_query_lpn;
903: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=
904: 'wlpn.subinventory_code';
905: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=

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

927: inv_mwb_query_manager.add_group_clause('wlpn.lpn_id','ONHAND');
928: inv_mwb_query_manager.add_group_clause('wlc.cost_group_id','ONHAND');
929:
930: /*LPN Status Project */
931: IF (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) THEN
932: l_default_status_id := inv_cache.org_rec.default_status_id;
933: END IF;
934:
935: IF inv_cache.set_item_rec(inv_mwb_globals.g_tree_organization_id, inv_mwb_globals.g_tree_item_id) THEN

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

931: IF (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) THEN
932: l_default_status_id := inv_cache.org_rec.default_status_id;
933: END IF;
934:
935: IF inv_cache.set_item_rec(inv_mwb_globals.g_tree_organization_id, inv_mwb_globals.g_tree_item_id) THEN
936:
937: IF (inv_cache.item_rec.serial_number_control_code in (2,5)) THEN
938: l_serial_controlled := 1; -- Item is serial controlled
939: END IF;

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

945: END IF;
946:
947: IF (l_default_status_id IS NOT NULL AND l_serial_controlled = 0 AND l_lot_controlled = 0) THEN
948:
949: l_status_id := INV_MATERIAL_STATUS_GRP.get_default_status(p_organization_id => inv_mwb_globals.g_organization_id,
950: p_inventory_item_id=>inv_mwb_globals.g_tree_item_id ,
951: p_sub_code=>inv_mwb_globals.g_tree_subinventory_code,
952: p_loc_id=>inv_mwb_globals.g_tree_loc_id,
953: p_lot_number=>inv_mwb_globals.g_tree_lot_number,

Line 950: p_inventory_item_id=>inv_mwb_globals.g_tree_item_id ,

946:
947: IF (l_default_status_id IS NOT NULL AND l_serial_controlled = 0 AND l_lot_controlled = 0) THEN
948:
949: l_status_id := INV_MATERIAL_STATUS_GRP.get_default_status(p_organization_id => inv_mwb_globals.g_organization_id,
950: p_inventory_item_id=>inv_mwb_globals.g_tree_item_id ,
951: p_sub_code=>inv_mwb_globals.g_tree_subinventory_code,
952: p_loc_id=>inv_mwb_globals.g_tree_loc_id,
953: p_lot_number=>inv_mwb_globals.g_tree_lot_number,
954: p_lpn_id=>inv_mwb_globals.g_tree_parent_lpn_id);

Line 951: p_sub_code=>inv_mwb_globals.g_tree_subinventory_code,

947: IF (l_default_status_id IS NOT NULL AND l_serial_controlled = 0 AND l_lot_controlled = 0) THEN
948:
949: l_status_id := INV_MATERIAL_STATUS_GRP.get_default_status(p_organization_id => inv_mwb_globals.g_organization_id,
950: p_inventory_item_id=>inv_mwb_globals.g_tree_item_id ,
951: p_sub_code=>inv_mwb_globals.g_tree_subinventory_code,
952: p_loc_id=>inv_mwb_globals.g_tree_loc_id,
953: p_lot_number=>inv_mwb_globals.g_tree_lot_number,
954: p_lpn_id=>inv_mwb_globals.g_tree_parent_lpn_id);
955:

Line 952: p_loc_id=>inv_mwb_globals.g_tree_loc_id,

948:
949: l_status_id := INV_MATERIAL_STATUS_GRP.get_default_status(p_organization_id => inv_mwb_globals.g_organization_id,
950: p_inventory_item_id=>inv_mwb_globals.g_tree_item_id ,
951: p_sub_code=>inv_mwb_globals.g_tree_subinventory_code,
952: p_loc_id=>inv_mwb_globals.g_tree_loc_id,
953: p_lot_number=>inv_mwb_globals.g_tree_lot_number,
954: p_lpn_id=>inv_mwb_globals.g_tree_parent_lpn_id);
955:
956: inv_mwb_globals.print_msg( g_pkg_name, l_procedure_name, 'Value of l_status_id:'|| l_status_id );

Line 953: p_lot_number=>inv_mwb_globals.g_tree_lot_number,

949: l_status_id := INV_MATERIAL_STATUS_GRP.get_default_status(p_organization_id => inv_mwb_globals.g_organization_id,
950: p_inventory_item_id=>inv_mwb_globals.g_tree_item_id ,
951: p_sub_code=>inv_mwb_globals.g_tree_subinventory_code,
952: p_loc_id=>inv_mwb_globals.g_tree_loc_id,
953: p_lot_number=>inv_mwb_globals.g_tree_lot_number,
954: p_lpn_id=>inv_mwb_globals.g_tree_parent_lpn_id);
955:
956: inv_mwb_globals.print_msg( g_pkg_name, l_procedure_name, 'Value of l_status_id:'|| l_status_id );
957:

Line 954: p_lpn_id=>inv_mwb_globals.g_tree_parent_lpn_id);

950: p_inventory_item_id=>inv_mwb_globals.g_tree_item_id ,
951: p_sub_code=>inv_mwb_globals.g_tree_subinventory_code,
952: p_loc_id=>inv_mwb_globals.g_tree_loc_id,
953: p_lot_number=>inv_mwb_globals.g_tree_lot_number,
954: p_lpn_id=>inv_mwb_globals.g_tree_parent_lpn_id);
955:
956: inv_mwb_globals.print_msg( g_pkg_name, l_procedure_name, 'Value of l_status_id:'|| l_status_id );
957:
958: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.STATUS_ID).column_value :=

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

952: p_loc_id=>inv_mwb_globals.g_tree_loc_id,
953: p_lot_number=>inv_mwb_globals.g_tree_lot_number,
954: p_lpn_id=>inv_mwb_globals.g_tree_parent_lpn_id);
955:
956: inv_mwb_globals.print_msg( g_pkg_name, l_procedure_name, 'Value of l_status_id:'|| l_status_id );
957:
958: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.STATUS_ID).column_value :=
959: l_status_id;
960: inv_mwb_query_manager.add_group_clause(l_status_id, 'ONHAND');

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

962: END IF;
963: /* End of fix for LPN Status Project */
964:
965: inv_mwb_query_manager.add_where_clause('wlc.revision = :onh_revision', 'ONHAND');
966: inv_mwb_query_manager.add_bind_variable('onh_revision', inv_mwb_globals.g_tree_rev);
967:
968:
969: inv_mwb_query_manager.add_where_clause('wlpn.lpn_id = :onh_lpn_id', 'ONHAND');
970: inv_mwb_query_manager.add_bind_variable('onh_lpn_id', inv_mwb_globals.g_tree_parent_lpn_id);

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

966: inv_mwb_query_manager.add_bind_variable('onh_revision', inv_mwb_globals.g_tree_rev);
967:
968:
969: inv_mwb_query_manager.add_where_clause('wlpn.lpn_id = :onh_lpn_id', 'ONHAND');
970: inv_mwb_query_manager.add_bind_variable('onh_lpn_id', inv_mwb_globals.g_tree_parent_lpn_id);
971: inv_mwb_query_manager.add_qf_where_lpn_node('ONHAND');
972: inv_mwb_query_manager.execute_query;
973: RETURN;
974: END IF;

Line 976: IF inv_mwb_globals.g_tree_mat_loc_id = 1 THEN

972: inv_mwb_query_manager.execute_query;
973: RETURN;
974: END IF;
975:
976: IF inv_mwb_globals.g_tree_mat_loc_id = 1 THEN
977: IF (inv_mwb_globals.g_serial_from IS NOT NULL OR
978: inv_mwb_globals.g_serial_to IS NOT NULL)
979: OR (NVL(l_lot_control, 1) = 1
980: AND l_serial_control IN ( 2,5 ))

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

973: RETURN;
974: END IF;
975:
976: IF inv_mwb_globals.g_tree_mat_loc_id = 1 THEN
977: IF (inv_mwb_globals.g_serial_from IS NOT NULL OR
978: inv_mwb_globals.g_serial_to IS NOT NULL)
979: OR (NVL(l_lot_control, 1) = 1
980: AND l_serial_control IN ( 2,5 ))
981: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL THEN -- Bug 6429880

Line 978: inv_mwb_globals.g_serial_to IS NOT NULL)

974: END IF;
975:
976: IF inv_mwb_globals.g_tree_mat_loc_id = 1 THEN
977: IF (inv_mwb_globals.g_serial_from IS NOT NULL OR
978: inv_mwb_globals.g_serial_to IS NOT NULL)
979: OR (NVL(l_lot_control, 1) = 1
980: AND l_serial_control IN ( 2,5 ))
981: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL THEN -- Bug 6429880
982: make_common_query_onhand('MSN');

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

977: IF (inv_mwb_globals.g_serial_from IS NOT NULL OR
978: inv_mwb_globals.g_serial_to IS NOT NULL)
979: OR (NVL(l_lot_control, 1) = 1
980: AND l_serial_control IN ( 2,5 ))
981: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL THEN -- Bug 6429880
982: make_common_query_onhand('MSN');
983: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
984:
985: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=

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

1009: inv_mwb_query_manager.add_group_clause('msn.lpn_id','ONHAND');
1010: inv_mwb_query_manager.add_group_clause('msn.cost_group_id','ONHAND');
1011:
1012: inv_mwb_query_manager.add_where_clause('msn.lpn_id = :onh_lpn_id', 'ONHAND');
1013: inv_mwb_query_manager.add_bind_variable('onh_lpn_id', inv_mwb_globals.g_tree_parent_lpn_id);
1014: inv_mwb_query_manager.add_where_clause('msn.inventory_item_id = :onh_inventory_item_id', 'ONHAND');
1015: inv_mwb_query_manager.add_bind_variable('onh_inventory_item_id', inv_mwb_globals.g_tree_item_id);
1016: inv_mwb_query_manager.add_where_clause('msn.revision = :onh_revision', 'ONHAND');
1017: inv_mwb_query_manager.add_bind_variable('onh_revision', inv_mwb_globals.g_tree_rev);

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

1011:
1012: inv_mwb_query_manager.add_where_clause('msn.lpn_id = :onh_lpn_id', 'ONHAND');
1013: inv_mwb_query_manager.add_bind_variable('onh_lpn_id', inv_mwb_globals.g_tree_parent_lpn_id);
1014: inv_mwb_query_manager.add_where_clause('msn.inventory_item_id = :onh_inventory_item_id', 'ONHAND');
1015: inv_mwb_query_manager.add_bind_variable('onh_inventory_item_id', inv_mwb_globals.g_tree_item_id);
1016: inv_mwb_query_manager.add_where_clause('msn.revision = :onh_revision', 'ONHAND');
1017: inv_mwb_query_manager.add_bind_variable('onh_revision', inv_mwb_globals.g_tree_rev);
1018:
1019:

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

1013: inv_mwb_query_manager.add_bind_variable('onh_lpn_id', inv_mwb_globals.g_tree_parent_lpn_id);
1014: inv_mwb_query_manager.add_where_clause('msn.inventory_item_id = :onh_inventory_item_id', 'ONHAND');
1015: inv_mwb_query_manager.add_bind_variable('onh_inventory_item_id', inv_mwb_globals.g_tree_item_id);
1016: inv_mwb_query_manager.add_where_clause('msn.revision = :onh_revision', 'ONHAND');
1017: inv_mwb_query_manager.add_bind_variable('onh_revision', inv_mwb_globals.g_tree_rev);
1018:
1019:
1020: ELSE
1021: make_common_query_onhand('MOQD');

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

1044: inv_mwb_query_manager.add_group_clause('moqd.cost_group_id','ONHAND');
1045:
1046: /* LPN Status Project */
1047: -- For serial controlled items, the status_id will be populated in post_query of IMVMWQMB.
1048: IF (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) THEN
1049: l_default_status_id := inv_cache.org_rec.default_status_id;
1050: END IF;
1051:
1052: IF inv_cache.set_item_rec(inv_mwb_globals.g_tree_organization_id, inv_mwb_globals.g_tree_item_id) THEN

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

1048: IF (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) THEN
1049: l_default_status_id := inv_cache.org_rec.default_status_id;
1050: END IF;
1051:
1052: IF inv_cache.set_item_rec(inv_mwb_globals.g_tree_organization_id, inv_mwb_globals.g_tree_item_id) THEN
1053: IF (inv_cache.item_rec.serial_number_control_code in (2,5)) THEN
1054: l_serial_controlled := 1; -- Item is serial controlled
1055: END IF;
1056:

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

1067:
1068: /* LPN Status Project */
1069:
1070: inv_mwb_query_manager.add_where_clause('moqd.lpn_id = :onh_lpn_id', 'ONHAND');
1071: inv_mwb_query_manager.add_bind_variable('onh_lpn_id', inv_mwb_globals.g_tree_parent_lpn_id);
1072: inv_mwb_query_manager.add_where_clause('moqd.inventory_item_id = :onh_inventory_item_id', 'ONHAND');
1073: inv_mwb_query_manager.add_bind_variable('onh_inventory_item_id', inv_mwb_globals.g_tree_item_id);
1074: inv_mwb_query_manager.add_where_clause('moqd.revision = :onh_revision', 'ONHAND');
1075: inv_mwb_query_manager.add_bind_variable('onh_revision', inv_mwb_globals.g_tree_rev);

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

1069:
1070: inv_mwb_query_manager.add_where_clause('moqd.lpn_id = :onh_lpn_id', 'ONHAND');
1071: inv_mwb_query_manager.add_bind_variable('onh_lpn_id', inv_mwb_globals.g_tree_parent_lpn_id);
1072: inv_mwb_query_manager.add_where_clause('moqd.inventory_item_id = :onh_inventory_item_id', 'ONHAND');
1073: inv_mwb_query_manager.add_bind_variable('onh_inventory_item_id', inv_mwb_globals.g_tree_item_id);
1074: inv_mwb_query_manager.add_where_clause('moqd.revision = :onh_revision', 'ONHAND');
1075: inv_mwb_query_manager.add_bind_variable('onh_revision', inv_mwb_globals.g_tree_rev);
1076:
1077: END IF;

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

1071: inv_mwb_query_manager.add_bind_variable('onh_lpn_id', inv_mwb_globals.g_tree_parent_lpn_id);
1072: inv_mwb_query_manager.add_where_clause('moqd.inventory_item_id = :onh_inventory_item_id', 'ONHAND');
1073: inv_mwb_query_manager.add_bind_variable('onh_inventory_item_id', inv_mwb_globals.g_tree_item_id);
1074: inv_mwb_query_manager.add_where_clause('moqd.revision = :onh_revision', 'ONHAND');
1075: inv_mwb_query_manager.add_bind_variable('onh_revision', inv_mwb_globals.g_tree_rev);
1076:
1077: END IF;
1078: END IF;
1079:

Line 1080: IF inv_mwb_globals.g_tree_mat_loc_id = 2 THEN

1076:
1077: END IF;
1078: END IF;
1079:
1080: IF inv_mwb_globals.g_tree_mat_loc_id = 2 THEN
1081: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
1082: inv_mwb_globals.g_serial_to IS NOT NULL
1083: OR (NVL(l_lot_control, 1) = 1
1084: AND l_serial_control IN ( 2,5 )) THEN

Line 1081: IF inv_mwb_globals.g_serial_from IS NOT NULL OR

1077: END IF;
1078: END IF;
1079:
1080: IF inv_mwb_globals.g_tree_mat_loc_id = 2 THEN
1081: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
1082: inv_mwb_globals.g_serial_to IS NOT NULL
1083: OR (NVL(l_lot_control, 1) = 1
1084: AND l_serial_control IN ( 2,5 )) THEN
1085:

Line 1082: inv_mwb_globals.g_serial_to IS NOT NULL

1078: END IF;
1079:
1080: IF inv_mwb_globals.g_tree_mat_loc_id = 2 THEN
1081: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
1082: inv_mwb_globals.g_serial_to IS NOT NULL
1083: OR (NVL(l_lot_control, 1) = 1
1084: AND l_serial_control IN ( 2,5 )) THEN
1085:
1086: make_common_query_receiving('MSN_QUERY');

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

1110: inv_mwb_query_manager.add_group_clause('msn.serial_number','RECEIVING');
1111: END IF;
1112:
1113: inv_mwb_query_manager.add_where_clause('msn.lpn_id = :rcv_lpn_id', 'RECEIVING');
1114: inv_mwb_query_manager.add_bind_variable('rcv_lpn_id', inv_mwb_globals.g_tree_parent_lpn_id);
1115: inv_mwb_query_manager.add_where_clause('msn.revision = :onh_revision', 'RECEIVING');
1116: inv_mwb_query_manager.add_bind_variable('onh_revision', inv_mwb_globals.g_tree_rev);
1117: inv_mwb_query_manager.add_where_clause('msn.inventory_item_id = :onh_inventory_item_id', 'RECEIVING');
1118: inv_mwb_query_manager.add_bind_variable('onh_inventory_item_id', inv_mwb_globals.g_tree_item_id);

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

1112:
1113: inv_mwb_query_manager.add_where_clause('msn.lpn_id = :rcv_lpn_id', 'RECEIVING');
1114: inv_mwb_query_manager.add_bind_variable('rcv_lpn_id', inv_mwb_globals.g_tree_parent_lpn_id);
1115: inv_mwb_query_manager.add_where_clause('msn.revision = :onh_revision', 'RECEIVING');
1116: inv_mwb_query_manager.add_bind_variable('onh_revision', inv_mwb_globals.g_tree_rev);
1117: inv_mwb_query_manager.add_where_clause('msn.inventory_item_id = :onh_inventory_item_id', 'RECEIVING');
1118: inv_mwb_query_manager.add_bind_variable('onh_inventory_item_id', inv_mwb_globals.g_tree_item_id);
1119:
1120: ELSE

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

1114: inv_mwb_query_manager.add_bind_variable('rcv_lpn_id', inv_mwb_globals.g_tree_parent_lpn_id);
1115: inv_mwb_query_manager.add_where_clause('msn.revision = :onh_revision', 'RECEIVING');
1116: inv_mwb_query_manager.add_bind_variable('onh_revision', inv_mwb_globals.g_tree_rev);
1117: inv_mwb_query_manager.add_where_clause('msn.inventory_item_id = :onh_inventory_item_id', 'RECEIVING');
1118: inv_mwb_query_manager.add_bind_variable('onh_inventory_item_id', inv_mwb_globals.g_tree_item_id);
1119:
1120: ELSE
1121:
1122: make_common_query_receiving('RECEIVING');

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

1142: inv_mwb_query_manager.add_group_clause('rls.lot_num','RECEIVING');
1143: END IF;
1144:
1145: inv_mwb_query_manager.add_where_clause('rs.lpn_id = :rcv_lpn_id', 'RECEIVING');
1146: inv_mwb_query_manager.add_bind_variable('rcv_lpn_id', inv_mwb_globals.g_tree_parent_lpn_id);
1147: inv_mwb_query_manager.add_where_clause('rs.item_revision = :onh_revision', 'RECEIVING');
1148: inv_mwb_query_manager.add_bind_variable('onh_revision', inv_mwb_globals.g_tree_rev);
1149: inv_mwb_query_manager.add_where_clause('rs.item_id = :onh_inventory_item_id', 'RECEIVING');
1150: inv_mwb_query_manager.add_bind_variable('onh_inventory_item_id', inv_mwb_globals.g_tree_item_id);

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

1144:
1145: inv_mwb_query_manager.add_where_clause('rs.lpn_id = :rcv_lpn_id', 'RECEIVING');
1146: inv_mwb_query_manager.add_bind_variable('rcv_lpn_id', inv_mwb_globals.g_tree_parent_lpn_id);
1147: inv_mwb_query_manager.add_where_clause('rs.item_revision = :onh_revision', 'RECEIVING');
1148: inv_mwb_query_manager.add_bind_variable('onh_revision', inv_mwb_globals.g_tree_rev);
1149: inv_mwb_query_manager.add_where_clause('rs.item_id = :onh_inventory_item_id', 'RECEIVING');
1150: inv_mwb_query_manager.add_bind_variable('onh_inventory_item_id', inv_mwb_globals.g_tree_item_id);
1151:
1152: END IF;

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

1146: inv_mwb_query_manager.add_bind_variable('rcv_lpn_id', inv_mwb_globals.g_tree_parent_lpn_id);
1147: inv_mwb_query_manager.add_where_clause('rs.item_revision = :onh_revision', 'RECEIVING');
1148: inv_mwb_query_manager.add_bind_variable('onh_revision', inv_mwb_globals.g_tree_rev);
1149: inv_mwb_query_manager.add_where_clause('rs.item_id = :onh_inventory_item_id', 'RECEIVING');
1150: inv_mwb_query_manager.add_bind_variable('onh_inventory_item_id', inv_mwb_globals.g_tree_item_id);
1151:
1152: END IF;
1153: END IF;
1154: inv_mwb_query_manager.execute_query;

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

1175: BEGIN
1176:
1177: l_procedure_name := 'LOT_NODE_EVENT';
1178:
1179: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_EXPANDED' THEN
1180: inv_mwb_tree1.add_serials (
1181: x_node_value
1182: , x_node_tbl
1183: , x_tbl_index);

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

1181: x_node_value
1182: , x_node_tbl
1183: , x_tbl_index);
1184:
1185: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
1186:
1187: SELECT serial_number_control_code
1188: INTO l_serial_control
1189: FROM mtl_system_items

Line 1190: WHERE inventory_item_id = inv_mwb_globals.g_tree_item_id

1186:
1187: SELECT serial_number_control_code
1188: INTO l_serial_control
1189: FROM mtl_system_items
1190: WHERE inventory_item_id = inv_mwb_globals.g_tree_item_id
1191: AND organization_id = inv_mwb_globals.g_organization_id;
1192:
1193: IF inv_mwb_globals.g_chk_onhand = 0
1194: AND inv_mwb_globals.g_chk_receiving = 0

Line 1191: AND organization_id = inv_mwb_globals.g_organization_id;

1187: SELECT serial_number_control_code
1188: INTO l_serial_control
1189: FROM mtl_system_items
1190: WHERE inventory_item_id = inv_mwb_globals.g_tree_item_id
1191: AND organization_id = inv_mwb_globals.g_organization_id;
1192:
1193: IF inv_mwb_globals.g_chk_onhand = 0
1194: AND inv_mwb_globals.g_chk_receiving = 0
1195: AND inv_mwb_globals.g_chk_inbound = 0 THEN

Line 1193: IF inv_mwb_globals.g_chk_onhand = 0

1189: FROM mtl_system_items
1190: WHERE inventory_item_id = inv_mwb_globals.g_tree_item_id
1191: AND organization_id = inv_mwb_globals.g_organization_id;
1192:
1193: IF inv_mwb_globals.g_chk_onhand = 0
1194: AND inv_mwb_globals.g_chk_receiving = 0
1195: AND inv_mwb_globals.g_chk_inbound = 0 THEN
1196: make_common_query_lpn;
1197: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=

Line 1194: AND inv_mwb_globals.g_chk_receiving = 0

1190: WHERE inventory_item_id = inv_mwb_globals.g_tree_item_id
1191: AND organization_id = inv_mwb_globals.g_organization_id;
1192:
1193: IF inv_mwb_globals.g_chk_onhand = 0
1194: AND inv_mwb_globals.g_chk_receiving = 0
1195: AND inv_mwb_globals.g_chk_inbound = 0 THEN
1196: make_common_query_lpn;
1197: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=
1198: 'wlpn.subinventory_code';

Line 1195: AND inv_mwb_globals.g_chk_inbound = 0 THEN

1191: AND organization_id = inv_mwb_globals.g_organization_id;
1192:
1193: IF inv_mwb_globals.g_chk_onhand = 0
1194: AND inv_mwb_globals.g_chk_receiving = 0
1195: AND inv_mwb_globals.g_chk_inbound = 0 THEN
1196: make_common_query_lpn;
1197: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=
1198: 'wlpn.subinventory_code';
1199: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=

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

1223:
1224: /* LPN Status Project */
1225: -- For serial controlled items, the status_id will be populated in post_query of IMVMWQMB.
1226:
1227: inv_mwb_globals.print_msg(g_pkg_name, l_procedure_name, 'org id' ||inv_mwb_globals.g_tree_organization_id );
1228:
1229: IF(inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) THEN
1230: l_default_status_id := inv_cache.org_rec.default_status_id;
1231: END IF;

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

1225: -- For serial controlled items, the status_id will be populated in post_query of IMVMWQMB.
1226:
1227: inv_mwb_globals.print_msg(g_pkg_name, l_procedure_name, 'org id' ||inv_mwb_globals.g_tree_organization_id );
1228:
1229: IF(inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) THEN
1230: l_default_status_id := inv_cache.org_rec.default_status_id;
1231: END IF;
1232:
1233: inv_mwb_globals.print_msg(g_pkg_name, l_procedure_name, 'org status id' || l_default_status_id);

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

1229: IF(inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) THEN
1230: l_default_status_id := inv_cache.org_rec.default_status_id;
1231: END IF;
1232:
1233: inv_mwb_globals.print_msg(g_pkg_name, l_procedure_name, 'org status id' || l_default_status_id);
1234:
1235: IF inv_cache.set_item_rec(inv_mwb_globals.g_tree_organization_id, inv_mwb_globals.g_tree_item_id) THEN
1236: IF (inv_cache.item_rec.serial_number_control_code in (2,5)) THEN
1237: l_serial_controlled := 1; -- Item is serial controlled

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

1231: END IF;
1232:
1233: inv_mwb_globals.print_msg(g_pkg_name, l_procedure_name, 'org status id' || l_default_status_id);
1234:
1235: IF inv_cache.set_item_rec(inv_mwb_globals.g_tree_organization_id, inv_mwb_globals.g_tree_item_id) THEN
1236: IF (inv_cache.item_rec.serial_number_control_code in (2,5)) THEN
1237: l_serial_controlled := 1; -- Item is serial controlled
1238: END IF;
1239: END IF;

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

1239: END IF;
1240:
1241: IF (l_default_status_id is not null and l_serial_controlled = 0) THEN
1242:
1243: l_status_id := INV_MATERIAL_STATUS_GRP.get_default_status(p_organization_id => inv_mwb_globals.g_organization_id,
1244: p_inventory_item_id=>inv_mwb_globals.g_tree_item_id ,
1245: p_sub_code=>inv_mwb_globals.g_tree_subinventory_code,
1246: p_loc_id=>inv_mwb_globals.g_tree_loc_id,
1247: p_lot_number=>inv_mwb_globals.g_tree_lot_number,

Line 1244: p_inventory_item_id=>inv_mwb_globals.g_tree_item_id ,

1240:
1241: IF (l_default_status_id is not null and l_serial_controlled = 0) THEN
1242:
1243: l_status_id := INV_MATERIAL_STATUS_GRP.get_default_status(p_organization_id => inv_mwb_globals.g_organization_id,
1244: p_inventory_item_id=>inv_mwb_globals.g_tree_item_id ,
1245: p_sub_code=>inv_mwb_globals.g_tree_subinventory_code,
1246: p_loc_id=>inv_mwb_globals.g_tree_loc_id,
1247: p_lot_number=>inv_mwb_globals.g_tree_lot_number,
1248: p_lpn_id=>inv_mwb_globals.g_tree_parent_lpn_id);

Line 1245: p_sub_code=>inv_mwb_globals.g_tree_subinventory_code,

1241: IF (l_default_status_id is not null and l_serial_controlled = 0) THEN
1242:
1243: l_status_id := INV_MATERIAL_STATUS_GRP.get_default_status(p_organization_id => inv_mwb_globals.g_organization_id,
1244: p_inventory_item_id=>inv_mwb_globals.g_tree_item_id ,
1245: p_sub_code=>inv_mwb_globals.g_tree_subinventory_code,
1246: p_loc_id=>inv_mwb_globals.g_tree_loc_id,
1247: p_lot_number=>inv_mwb_globals.g_tree_lot_number,
1248: p_lpn_id=>inv_mwb_globals.g_tree_parent_lpn_id);
1249:

Line 1246: p_loc_id=>inv_mwb_globals.g_tree_loc_id,

1242:
1243: l_status_id := INV_MATERIAL_STATUS_GRP.get_default_status(p_organization_id => inv_mwb_globals.g_organization_id,
1244: p_inventory_item_id=>inv_mwb_globals.g_tree_item_id ,
1245: p_sub_code=>inv_mwb_globals.g_tree_subinventory_code,
1246: p_loc_id=>inv_mwb_globals.g_tree_loc_id,
1247: p_lot_number=>inv_mwb_globals.g_tree_lot_number,
1248: p_lpn_id=>inv_mwb_globals.g_tree_parent_lpn_id);
1249:
1250: inv_mwb_globals.print_msg( g_pkg_name, l_procedure_name, 'Value of l_status_id:'|| l_status_id );

Line 1247: p_lot_number=>inv_mwb_globals.g_tree_lot_number,

1243: l_status_id := INV_MATERIAL_STATUS_GRP.get_default_status(p_organization_id => inv_mwb_globals.g_organization_id,
1244: p_inventory_item_id=>inv_mwb_globals.g_tree_item_id ,
1245: p_sub_code=>inv_mwb_globals.g_tree_subinventory_code,
1246: p_loc_id=>inv_mwb_globals.g_tree_loc_id,
1247: p_lot_number=>inv_mwb_globals.g_tree_lot_number,
1248: p_lpn_id=>inv_mwb_globals.g_tree_parent_lpn_id);
1249:
1250: inv_mwb_globals.print_msg( g_pkg_name, l_procedure_name, 'Value of l_status_id:'|| l_status_id );
1251:

Line 1248: p_lpn_id=>inv_mwb_globals.g_tree_parent_lpn_id);

1244: p_inventory_item_id=>inv_mwb_globals.g_tree_item_id ,
1245: p_sub_code=>inv_mwb_globals.g_tree_subinventory_code,
1246: p_loc_id=>inv_mwb_globals.g_tree_loc_id,
1247: p_lot_number=>inv_mwb_globals.g_tree_lot_number,
1248: p_lpn_id=>inv_mwb_globals.g_tree_parent_lpn_id);
1249:
1250: inv_mwb_globals.print_msg( g_pkg_name, l_procedure_name, 'Value of l_status_id:'|| l_status_id );
1251:
1252: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.STATUS_ID).column_value :=

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

1246: p_loc_id=>inv_mwb_globals.g_tree_loc_id,
1247: p_lot_number=>inv_mwb_globals.g_tree_lot_number,
1248: p_lpn_id=>inv_mwb_globals.g_tree_parent_lpn_id);
1249:
1250: inv_mwb_globals.print_msg( g_pkg_name, l_procedure_name, 'Value of l_status_id:'|| l_status_id );
1251:
1252: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.STATUS_ID).column_value :=
1253: l_status_id;
1254: inv_mwb_query_manager.add_group_clause(l_status_id, 'ONHAND');

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

1257: /* End of fix for LPN Status Project */
1258:
1259: inv_mwb_query_manager.add_where_clause('wlpn.lpn_id = :onh_lpn_id', 'ONHAND');
1260: inv_mwb_query_manager.add_where_clause('wlc.lot_number = :onh_lot_number', 'ONHAND');
1261: inv_mwb_query_manager.add_bind_variable('onh_lot_number', inv_mwb_globals.g_tree_lot_number);
1262: inv_mwb_query_manager.add_bind_variable('onh_lpn_id', inv_mwb_globals.g_tree_parent_lpn_id);
1263: inv_mwb_query_manager.add_qf_where_lpn_node('ONHAND');
1264: inv_mwb_query_manager.execute_query;
1265: RETURN;

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

1258:
1259: inv_mwb_query_manager.add_where_clause('wlpn.lpn_id = :onh_lpn_id', 'ONHAND');
1260: inv_mwb_query_manager.add_where_clause('wlc.lot_number = :onh_lot_number', 'ONHAND');
1261: inv_mwb_query_manager.add_bind_variable('onh_lot_number', inv_mwb_globals.g_tree_lot_number);
1262: inv_mwb_query_manager.add_bind_variable('onh_lpn_id', inv_mwb_globals.g_tree_parent_lpn_id);
1263: inv_mwb_query_manager.add_qf_where_lpn_node('ONHAND');
1264: inv_mwb_query_manager.execute_query;
1265: RETURN;
1266: END IF;

Line 1268: IF inv_mwb_globals.g_tree_mat_loc_id = 1 THEN

1264: inv_mwb_query_manager.execute_query;
1265: RETURN;
1266: END IF;
1267:
1268: IF inv_mwb_globals.g_tree_mat_loc_id = 1 THEN
1269: IF (inv_mwb_globals.g_serial_from IS NOT NULL OR
1270: inv_mwb_globals.g_serial_to IS NOT NULL)
1271: OR l_serial_control IN ( 2,5 )
1272: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL THEN -- Bug 6429880

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

1265: RETURN;
1266: END IF;
1267:
1268: IF inv_mwb_globals.g_tree_mat_loc_id = 1 THEN
1269: IF (inv_mwb_globals.g_serial_from IS NOT NULL OR
1270: inv_mwb_globals.g_serial_to IS NOT NULL)
1271: OR l_serial_control IN ( 2,5 )
1272: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL THEN -- Bug 6429880
1273: make_common_query_onhand('MSN');

Line 1270: inv_mwb_globals.g_serial_to IS NOT NULL)

1266: END IF;
1267:
1268: IF inv_mwb_globals.g_tree_mat_loc_id = 1 THEN
1269: IF (inv_mwb_globals.g_serial_from IS NOT NULL OR
1270: inv_mwb_globals.g_serial_to IS NOT NULL)
1271: OR l_serial_control IN ( 2,5 )
1272: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL THEN -- Bug 6429880
1273: make_common_query_onhand('MSN');
1274: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');

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

1268: IF inv_mwb_globals.g_tree_mat_loc_id = 1 THEN
1269: IF (inv_mwb_globals.g_serial_from IS NOT NULL OR
1270: inv_mwb_globals.g_serial_to IS NOT NULL)
1271: OR l_serial_control IN ( 2,5 )
1272: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL THEN -- Bug 6429880
1273: make_common_query_onhand('MSN');
1274: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
1275:
1276: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=

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

1300: inv_mwb_query_manager.add_group_clause('msn.revision','ONHAND');
1301: inv_mwb_query_manager.add_group_clause('msn.lot_number','ONHAND');
1302:
1303: inv_mwb_query_manager.add_where_clause('msn.lpn_id = :onh_lpn_id', 'ONHAND');
1304: inv_mwb_query_manager.add_bind_variable('onh_lpn_id', inv_mwb_globals.g_tree_parent_lpn_id);
1305: inv_mwb_query_manager.add_where_clause('msn.inventory_item_id = :onh_inventory_item_id', 'ONHAND');
1306: inv_mwb_query_manager.add_bind_variable('onh_inventory_item_id', inv_mwb_globals.g_tree_item_id);
1307:
1308: IF inv_mwb_globals.g_tree_rev IS NOT NULL THEN

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

1302:
1303: inv_mwb_query_manager.add_where_clause('msn.lpn_id = :onh_lpn_id', 'ONHAND');
1304: inv_mwb_query_manager.add_bind_variable('onh_lpn_id', inv_mwb_globals.g_tree_parent_lpn_id);
1305: inv_mwb_query_manager.add_where_clause('msn.inventory_item_id = :onh_inventory_item_id', 'ONHAND');
1306: inv_mwb_query_manager.add_bind_variable('onh_inventory_item_id', inv_mwb_globals.g_tree_item_id);
1307:
1308: IF inv_mwb_globals.g_tree_rev IS NOT NULL THEN
1309: inv_mwb_query_manager.add_where_clause('msn.revision = :onh_revision', 'ONHAND');
1310: inv_mwb_query_manager.add_bind_variable('onh_revision', inv_mwb_globals.g_tree_rev);

Line 1308: IF inv_mwb_globals.g_tree_rev IS NOT NULL THEN

1304: inv_mwb_query_manager.add_bind_variable('onh_lpn_id', inv_mwb_globals.g_tree_parent_lpn_id);
1305: inv_mwb_query_manager.add_where_clause('msn.inventory_item_id = :onh_inventory_item_id', 'ONHAND');
1306: inv_mwb_query_manager.add_bind_variable('onh_inventory_item_id', inv_mwb_globals.g_tree_item_id);
1307:
1308: IF inv_mwb_globals.g_tree_rev IS NOT NULL THEN
1309: inv_mwb_query_manager.add_where_clause('msn.revision = :onh_revision', 'ONHAND');
1310: inv_mwb_query_manager.add_bind_variable('onh_revision', inv_mwb_globals.g_tree_rev);
1311: END IF;
1312: ELSE

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

1306: inv_mwb_query_manager.add_bind_variable('onh_inventory_item_id', inv_mwb_globals.g_tree_item_id);
1307:
1308: IF inv_mwb_globals.g_tree_rev IS NOT NULL THEN
1309: inv_mwb_query_manager.add_where_clause('msn.revision = :onh_revision', 'ONHAND');
1310: inv_mwb_query_manager.add_bind_variable('onh_revision', inv_mwb_globals.g_tree_rev);
1311: END IF;
1312: ELSE
1313: make_common_query_onhand('MOQD');
1314: inv_mwb_query_manager.add_qf_where_onhand('ONHAND');

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

1335:
1336: /* LPN Status Project */
1337: -- For serial controlled items, the status_id will be populated in post_query of IMVMWQMB.
1338:
1339: inv_mwb_globals.print_msg(g_pkg_name, l_procedure_name, 'org id' ||inv_mwb_globals.g_tree_organization_id );
1340:
1341: IF(inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) THEN
1342: l_default_status_id := inv_cache.org_rec.default_status_id;
1343: END IF;

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

1337: -- For serial controlled items, the status_id will be populated in post_query of IMVMWQMB.
1338:
1339: inv_mwb_globals.print_msg(g_pkg_name, l_procedure_name, 'org id' ||inv_mwb_globals.g_tree_organization_id );
1340:
1341: IF(inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) THEN
1342: l_default_status_id := inv_cache.org_rec.default_status_id;
1343: END IF;
1344:
1345: inv_mwb_globals.print_msg(g_pkg_name, l_procedure_name, 'org status id' || l_default_status_id);

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

1341: IF(inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) THEN
1342: l_default_status_id := inv_cache.org_rec.default_status_id;
1343: END IF;
1344:
1345: inv_mwb_globals.print_msg(g_pkg_name, l_procedure_name, 'org status id' || l_default_status_id);
1346:
1347: IF inv_cache.set_item_rec(inv_mwb_globals.g_tree_organization_id, inv_mwb_globals.g_tree_item_id) THEN
1348: IF (inv_cache.item_rec.serial_number_control_code in (2,5)) THEN
1349: l_serial_controlled := 1; -- Item is serial controlled

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

1343: END IF;
1344:
1345: inv_mwb_globals.print_msg(g_pkg_name, l_procedure_name, 'org status id' || l_default_status_id);
1346:
1347: IF inv_cache.set_item_rec(inv_mwb_globals.g_tree_organization_id, inv_mwb_globals.g_tree_item_id) THEN
1348: IF (inv_cache.item_rec.serial_number_control_code in (2,5)) THEN
1349: l_serial_controlled := 1; -- Item is serial controlled
1350: END IF;
1351: END IF;

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

1349: l_serial_controlled := 1; -- Item is serial controlled
1350: END IF;
1351: END IF;
1352:
1353: inv_mwb_globals.print_msg(g_pkg_name, l_procedure_name, 'serial controlled' || l_serial_controlled);
1354:
1355: IF (l_default_status_id is not null and l_serial_controlled = 0) THEN
1356: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.STATUS_ID).column_value :=
1357: 'moqd.status_id';

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

1359: END IF;
1360: /* LPN Status Project */
1361:
1362: inv_mwb_query_manager.add_where_clause('moqd.lpn_id = :onh_lpn_id', 'ONHAND');
1363: inv_mwb_query_manager.add_bind_variable('onh_lpn_id', inv_mwb_globals.g_tree_parent_lpn_id);
1364: inv_mwb_query_manager.add_where_clause('moqd.inventory_item_id = :onh_inventory_item_id', 'ONHAND');
1365: inv_mwb_query_manager.add_bind_variable('onh_inventory_item_id', inv_mwb_globals.g_tree_item_id);
1366: inv_mwb_query_manager.add_where_clause('moqd.lot_number = :onh_lot_number', 'ONHAND');
1367: inv_mwb_query_manager.add_bind_variable('onh_lot_number', inv_mwb_globals.g_tree_lot_number);

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

1361:
1362: inv_mwb_query_manager.add_where_clause('moqd.lpn_id = :onh_lpn_id', 'ONHAND');
1363: inv_mwb_query_manager.add_bind_variable('onh_lpn_id', inv_mwb_globals.g_tree_parent_lpn_id);
1364: inv_mwb_query_manager.add_where_clause('moqd.inventory_item_id = :onh_inventory_item_id', 'ONHAND');
1365: inv_mwb_query_manager.add_bind_variable('onh_inventory_item_id', inv_mwb_globals.g_tree_item_id);
1366: inv_mwb_query_manager.add_where_clause('moqd.lot_number = :onh_lot_number', 'ONHAND');
1367: inv_mwb_query_manager.add_bind_variable('onh_lot_number', inv_mwb_globals.g_tree_lot_number);
1368: IF inv_mwb_globals.g_tree_rev IS NOT NULL THEN
1369: inv_mwb_query_manager.add_where_clause('moqd.revision = :onh_revision', 'ONHAND');

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

1363: inv_mwb_query_manager.add_bind_variable('onh_lpn_id', inv_mwb_globals.g_tree_parent_lpn_id);
1364: inv_mwb_query_manager.add_where_clause('moqd.inventory_item_id = :onh_inventory_item_id', 'ONHAND');
1365: inv_mwb_query_manager.add_bind_variable('onh_inventory_item_id', inv_mwb_globals.g_tree_item_id);
1366: inv_mwb_query_manager.add_where_clause('moqd.lot_number = :onh_lot_number', 'ONHAND');
1367: inv_mwb_query_manager.add_bind_variable('onh_lot_number', inv_mwb_globals.g_tree_lot_number);
1368: IF inv_mwb_globals.g_tree_rev IS NOT NULL THEN
1369: inv_mwb_query_manager.add_where_clause('moqd.revision = :onh_revision', 'ONHAND');
1370: inv_mwb_query_manager.add_bind_variable('onh_revision', inv_mwb_globals.g_tree_rev);
1371: END IF;

Line 1368: IF inv_mwb_globals.g_tree_rev IS NOT NULL THEN

1364: inv_mwb_query_manager.add_where_clause('moqd.inventory_item_id = :onh_inventory_item_id', 'ONHAND');
1365: inv_mwb_query_manager.add_bind_variable('onh_inventory_item_id', inv_mwb_globals.g_tree_item_id);
1366: inv_mwb_query_manager.add_where_clause('moqd.lot_number = :onh_lot_number', 'ONHAND');
1367: inv_mwb_query_manager.add_bind_variable('onh_lot_number', inv_mwb_globals.g_tree_lot_number);
1368: IF inv_mwb_globals.g_tree_rev IS NOT NULL THEN
1369: inv_mwb_query_manager.add_where_clause('moqd.revision = :onh_revision', 'ONHAND');
1370: inv_mwb_query_manager.add_bind_variable('onh_revision', inv_mwb_globals.g_tree_rev);
1371: END IF;
1372: END IF;

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

1366: inv_mwb_query_manager.add_where_clause('moqd.lot_number = :onh_lot_number', 'ONHAND');
1367: inv_mwb_query_manager.add_bind_variable('onh_lot_number', inv_mwb_globals.g_tree_lot_number);
1368: IF inv_mwb_globals.g_tree_rev IS NOT NULL THEN
1369: inv_mwb_query_manager.add_where_clause('moqd.revision = :onh_revision', 'ONHAND');
1370: inv_mwb_query_manager.add_bind_variable('onh_revision', inv_mwb_globals.g_tree_rev);
1371: END IF;
1372: END IF;
1373: END IF;
1374:

Line 1375: IF inv_mwb_globals.g_tree_mat_loc_id = 2 THEN

1371: END IF;
1372: END IF;
1373: END IF;
1374:
1375: IF inv_mwb_globals.g_tree_mat_loc_id = 2 THEN
1376: IF (inv_mwb_globals.g_serial_from IS NOT NULL OR
1377: inv_mwb_globals.g_serial_to IS NOT NULL)
1378: OR l_serial_control IN ( 2,5 ) THEN
1379:

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

1372: END IF;
1373: END IF;
1374:
1375: IF inv_mwb_globals.g_tree_mat_loc_id = 2 THEN
1376: IF (inv_mwb_globals.g_serial_from IS NOT NULL OR
1377: inv_mwb_globals.g_serial_to IS NOT NULL)
1378: OR l_serial_control IN ( 2,5 ) THEN
1379:
1380: make_common_query_receiving('MSN_QUERY');

Line 1377: inv_mwb_globals.g_serial_to IS NOT NULL)

1373: END IF;
1374:
1375: IF inv_mwb_globals.g_tree_mat_loc_id = 2 THEN
1376: IF (inv_mwb_globals.g_serial_from IS NOT NULL OR
1377: inv_mwb_globals.g_serial_to IS NOT NULL)
1378: OR l_serial_control IN ( 2,5 ) THEN
1379:
1380: make_common_query_receiving('MSN_QUERY');
1381: inv_mwb_query_manager.add_qf_where_receiving('MSN_RECEIVING');

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

1404: inv_mwb_query_manager.add_group_clause('msn.serial_number','RECEIVING');
1405: END IF;
1406:
1407: inv_mwb_query_manager.add_where_clause('msn.lpn_id = :rcv_lpn_id', 'RECEIVING');
1408: inv_mwb_query_manager.add_bind_variable('rcv_lpn_id', inv_mwb_globals.g_tree_parent_lpn_id);
1409: inv_mwb_query_manager.add_where_clause('msn.lot_number = :onh_lot_number', 'RECEIVING');
1410: inv_mwb_query_manager.add_bind_variable('onh_lot_number', inv_mwb_globals.g_tree_lot_number);
1411:
1412: IF inv_mwb_globals.g_tree_rev IS NOT NULL THEN

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

1406:
1407: inv_mwb_query_manager.add_where_clause('msn.lpn_id = :rcv_lpn_id', 'RECEIVING');
1408: inv_mwb_query_manager.add_bind_variable('rcv_lpn_id', inv_mwb_globals.g_tree_parent_lpn_id);
1409: inv_mwb_query_manager.add_where_clause('msn.lot_number = :onh_lot_number', 'RECEIVING');
1410: inv_mwb_query_manager.add_bind_variable('onh_lot_number', inv_mwb_globals.g_tree_lot_number);
1411:
1412: IF inv_mwb_globals.g_tree_rev IS NOT NULL THEN
1413: inv_mwb_query_manager.add_where_clause('msn.revision = :onh_revision', 'RECEIVING');
1414: inv_mwb_query_manager.add_bind_variable('onh_revision', inv_mwb_globals.g_tree_rev);

Line 1412: IF inv_mwb_globals.g_tree_rev IS NOT NULL THEN

1408: inv_mwb_query_manager.add_bind_variable('rcv_lpn_id', inv_mwb_globals.g_tree_parent_lpn_id);
1409: inv_mwb_query_manager.add_where_clause('msn.lot_number = :onh_lot_number', 'RECEIVING');
1410: inv_mwb_query_manager.add_bind_variable('onh_lot_number', inv_mwb_globals.g_tree_lot_number);
1411:
1412: IF inv_mwb_globals.g_tree_rev IS NOT NULL THEN
1413: inv_mwb_query_manager.add_where_clause('msn.revision = :onh_revision', 'RECEIVING');
1414: inv_mwb_query_manager.add_bind_variable('onh_revision', inv_mwb_globals.g_tree_rev);
1415: END IF;
1416: inv_mwb_query_manager.add_where_clause('msn.inventory_item_id = :onh_inventory_item_id', 'RECEIVING');

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

1410: inv_mwb_query_manager.add_bind_variable('onh_lot_number', inv_mwb_globals.g_tree_lot_number);
1411:
1412: IF inv_mwb_globals.g_tree_rev IS NOT NULL THEN
1413: inv_mwb_query_manager.add_where_clause('msn.revision = :onh_revision', 'RECEIVING');
1414: inv_mwb_query_manager.add_bind_variable('onh_revision', inv_mwb_globals.g_tree_rev);
1415: END IF;
1416: inv_mwb_query_manager.add_where_clause('msn.inventory_item_id = :onh_inventory_item_id', 'RECEIVING');
1417: inv_mwb_query_manager.add_bind_variable('onh_inventory_item_id', inv_mwb_globals.g_tree_item_id);
1418:

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

1413: inv_mwb_query_manager.add_where_clause('msn.revision = :onh_revision', 'RECEIVING');
1414: inv_mwb_query_manager.add_bind_variable('onh_revision', inv_mwb_globals.g_tree_rev);
1415: END IF;
1416: inv_mwb_query_manager.add_where_clause('msn.inventory_item_id = :onh_inventory_item_id', 'RECEIVING');
1417: inv_mwb_query_manager.add_bind_variable('onh_inventory_item_id', inv_mwb_globals.g_tree_item_id);
1418:
1419: ELSE
1420:
1421: make_common_query_receiving('RECEIVING');

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

1441: inv_mwb_query_manager.add_group_clause('rls.lot_num','RECEIVING');
1442:
1443:
1444: inv_mwb_query_manager.add_where_clause('rs.lpn_id = :rcv_lpn_id', 'RECEIVING');
1445: inv_mwb_query_manager.add_bind_variable('rcv_lpn_id', inv_mwb_globals.g_tree_parent_lpn_id);
1446: IF inv_mwb_globals.g_tree_rev IS NOT NULL THEN
1447: inv_mwb_query_manager.add_where_clause('rs.item_revision = :onh_revision', 'RECEIVING');
1448: inv_mwb_query_manager.add_bind_variable('onh_revision', inv_mwb_globals.g_tree_rev);
1449: END IF;

Line 1446: IF inv_mwb_globals.g_tree_rev IS NOT NULL THEN

1442:
1443:
1444: inv_mwb_query_manager.add_where_clause('rs.lpn_id = :rcv_lpn_id', 'RECEIVING');
1445: inv_mwb_query_manager.add_bind_variable('rcv_lpn_id', inv_mwb_globals.g_tree_parent_lpn_id);
1446: IF inv_mwb_globals.g_tree_rev IS NOT NULL THEN
1447: inv_mwb_query_manager.add_where_clause('rs.item_revision = :onh_revision', 'RECEIVING');
1448: inv_mwb_query_manager.add_bind_variable('onh_revision', inv_mwb_globals.g_tree_rev);
1449: END IF;
1450: inv_mwb_query_manager.add_where_clause('rls.lot_number = :onh_lot_number', 'RECEIVING');

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

1444: inv_mwb_query_manager.add_where_clause('rs.lpn_id = :rcv_lpn_id', 'RECEIVING');
1445: inv_mwb_query_manager.add_bind_variable('rcv_lpn_id', inv_mwb_globals.g_tree_parent_lpn_id);
1446: IF inv_mwb_globals.g_tree_rev IS NOT NULL THEN
1447: inv_mwb_query_manager.add_where_clause('rs.item_revision = :onh_revision', 'RECEIVING');
1448: inv_mwb_query_manager.add_bind_variable('onh_revision', inv_mwb_globals.g_tree_rev);
1449: END IF;
1450: inv_mwb_query_manager.add_where_clause('rls.lot_number = :onh_lot_number', 'RECEIVING');
1451: inv_mwb_query_manager.add_bind_variable('onh_lot_number', inv_mwb_globals.g_tree_lot_number);
1452:

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

1447: inv_mwb_query_manager.add_where_clause('rs.item_revision = :onh_revision', 'RECEIVING');
1448: inv_mwb_query_manager.add_bind_variable('onh_revision', inv_mwb_globals.g_tree_rev);
1449: END IF;
1450: inv_mwb_query_manager.add_where_clause('rls.lot_number = :onh_lot_number', 'RECEIVING');
1451: inv_mwb_query_manager.add_bind_variable('onh_lot_number', inv_mwb_globals.g_tree_lot_number);
1452:
1453: inv_mwb_query_manager.add_where_clause('rs.item_id = :onh_inventory_item_id', 'RECEIVING');
1454: inv_mwb_query_manager.add_bind_variable('onh_inventory_item_id', inv_mwb_globals.g_tree_item_id);
1455:

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

1450: inv_mwb_query_manager.add_where_clause('rls.lot_number = :onh_lot_number', 'RECEIVING');
1451: inv_mwb_query_manager.add_bind_variable('onh_lot_number', inv_mwb_globals.g_tree_lot_number);
1452:
1453: inv_mwb_query_manager.add_where_clause('rs.item_id = :onh_inventory_item_id', 'RECEIVING');
1454: inv_mwb_query_manager.add_bind_variable('onh_inventory_item_id', inv_mwb_globals.g_tree_item_id);
1455:
1456: END IF;
1457: END IF;
1458:

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

1473: BEGIN
1474:
1475: l_procedure_name := 'SERIAL_NODE_EVENT';
1476:
1477: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
1478: IF inv_mwb_globals.g_chk_onhand = 0
1479: AND inv_mwb_globals.g_chk_receiving = 0
1480: AND inv_mwb_globals.g_chk_inbound = 0
1481: AND inv_mwb_globals.g_view_by = 'LPN' THEN

Line 1478: IF inv_mwb_globals.g_chk_onhand = 0

1474:
1475: l_procedure_name := 'SERIAL_NODE_EVENT';
1476:
1477: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
1478: IF inv_mwb_globals.g_chk_onhand = 0
1479: AND inv_mwb_globals.g_chk_receiving = 0
1480: AND inv_mwb_globals.g_chk_inbound = 0
1481: AND inv_mwb_globals.g_view_by = 'LPN' THEN
1482: make_common_query_lpn;

Line 1479: AND inv_mwb_globals.g_chk_receiving = 0

1475: l_procedure_name := 'SERIAL_NODE_EVENT';
1476:
1477: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
1478: IF inv_mwb_globals.g_chk_onhand = 0
1479: AND inv_mwb_globals.g_chk_receiving = 0
1480: AND inv_mwb_globals.g_chk_inbound = 0
1481: AND inv_mwb_globals.g_view_by = 'LPN' THEN
1482: make_common_query_lpn;
1483: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=

Line 1480: AND inv_mwb_globals.g_chk_inbound = 0

1476:
1477: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
1478: IF inv_mwb_globals.g_chk_onhand = 0
1479: AND inv_mwb_globals.g_chk_receiving = 0
1480: AND inv_mwb_globals.g_chk_inbound = 0
1481: AND inv_mwb_globals.g_view_by = 'LPN' THEN
1482: make_common_query_lpn;
1483: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=
1484: 'wlpn.subinventory_code';

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

1477: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
1478: IF inv_mwb_globals.g_chk_onhand = 0
1479: AND inv_mwb_globals.g_chk_receiving = 0
1480: AND inv_mwb_globals.g_chk_inbound = 0
1481: AND inv_mwb_globals.g_view_by = 'LPN' THEN
1482: make_common_query_lpn;
1483: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=
1484: 'wlpn.subinventory_code';
1485: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=

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

1506: inv_mwb_query_manager.add_group_clause('wlc.cost_group_id','ONHAND');
1507:
1508: inv_mwb_query_manager.add_where_clause('wlpn.lpn_id = :onh_lpn_id', 'ONHAND');
1509: inv_mwb_query_manager.add_where_clause('msn.serial_number = :onh_serial_number', 'ONHAND');
1510: inv_mwb_query_manager.add_bind_variable('onh_serial_number', inv_mwb_globals. g_tree_serial_number);
1511: inv_mwb_query_manager.add_bind_variable('onh_lpn_id', inv_mwb_globals.g_tree_parent_lpn_id);
1512: inv_mwb_query_manager.add_qf_where_lpn_node('ONHAND');
1513: inv_mwb_query_manager.execute_query;
1514: RETURN;

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

1507:
1508: inv_mwb_query_manager.add_where_clause('wlpn.lpn_id = :onh_lpn_id', 'ONHAND');
1509: inv_mwb_query_manager.add_where_clause('msn.serial_number = :onh_serial_number', 'ONHAND');
1510: inv_mwb_query_manager.add_bind_variable('onh_serial_number', inv_mwb_globals. g_tree_serial_number);
1511: inv_mwb_query_manager.add_bind_variable('onh_lpn_id', inv_mwb_globals.g_tree_parent_lpn_id);
1512: inv_mwb_query_manager.add_qf_where_lpn_node('ONHAND');
1513: inv_mwb_query_manager.execute_query;
1514: RETURN;
1515: END IF;

Line 1517: IF inv_mwb_globals.g_tree_mat_loc_id = 1 THEN

1513: inv_mwb_query_manager.execute_query;
1514: RETURN;
1515: END IF;
1516:
1517: IF inv_mwb_globals.g_tree_mat_loc_id = 1 THEN
1518: make_common_query_onhand('MSN');
1519: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
1520:
1521: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=

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

1543: inv_mwb_query_manager.add_group_clause('msn.lpn_id','ONHAND');
1544: inv_mwb_query_manager.add_group_clause('msn.cost_group_id','ONHAND');
1545:
1546: inv_mwb_query_manager.add_where_clause('msn.lpn_id = :onh_lpn_id', 'ONHAND');
1547: inv_mwb_query_manager.add_bind_variable('onh_lpn_id', inv_mwb_globals.g_tree_parent_lpn_id);
1548: inv_mwb_query_manager.add_where_clause('msn.inventory_item_id = :onh_inventory_item_id', 'ONHAND');
1549: inv_mwb_query_manager.add_bind_variable('onh_inventory_item_id', inv_mwb_globals.g_tree_item_id);
1550: inv_mwb_query_manager.add_where_clause('msn.serial_number = :onh_serial_number', 'ONHAND');
1551: inv_mwb_query_manager.add_bind_variable('onh_serial_number', inv_mwb_globals. g_tree_serial_number);

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

1545:
1546: inv_mwb_query_manager.add_where_clause('msn.lpn_id = :onh_lpn_id', 'ONHAND');
1547: inv_mwb_query_manager.add_bind_variable('onh_lpn_id', inv_mwb_globals.g_tree_parent_lpn_id);
1548: inv_mwb_query_manager.add_where_clause('msn.inventory_item_id = :onh_inventory_item_id', 'ONHAND');
1549: inv_mwb_query_manager.add_bind_variable('onh_inventory_item_id', inv_mwb_globals.g_tree_item_id);
1550: inv_mwb_query_manager.add_where_clause('msn.serial_number = :onh_serial_number', 'ONHAND');
1551: inv_mwb_query_manager.add_bind_variable('onh_serial_number', inv_mwb_globals. g_tree_serial_number);
1552:
1553: IF inv_mwb_globals.g_tree_rev IS NOT NULL THEN

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

1547: inv_mwb_query_manager.add_bind_variable('onh_lpn_id', inv_mwb_globals.g_tree_parent_lpn_id);
1548: inv_mwb_query_manager.add_where_clause('msn.inventory_item_id = :onh_inventory_item_id', 'ONHAND');
1549: inv_mwb_query_manager.add_bind_variable('onh_inventory_item_id', inv_mwb_globals.g_tree_item_id);
1550: inv_mwb_query_manager.add_where_clause('msn.serial_number = :onh_serial_number', 'ONHAND');
1551: inv_mwb_query_manager.add_bind_variable('onh_serial_number', inv_mwb_globals. g_tree_serial_number);
1552:
1553: IF inv_mwb_globals.g_tree_rev IS NOT NULL THEN
1554: inv_mwb_query_manager.add_where_clause('msn.revision = :onh_revision', 'ONHAND');
1555: inv_mwb_query_manager.add_bind_variable('onh_revision', inv_mwb_globals.g_tree_rev);

Line 1553: IF inv_mwb_globals.g_tree_rev IS NOT NULL THEN

1549: inv_mwb_query_manager.add_bind_variable('onh_inventory_item_id', inv_mwb_globals.g_tree_item_id);
1550: inv_mwb_query_manager.add_where_clause('msn.serial_number = :onh_serial_number', 'ONHAND');
1551: inv_mwb_query_manager.add_bind_variable('onh_serial_number', inv_mwb_globals. g_tree_serial_number);
1552:
1553: IF inv_mwb_globals.g_tree_rev IS NOT NULL THEN
1554: inv_mwb_query_manager.add_where_clause('msn.revision = :onh_revision', 'ONHAND');
1555: inv_mwb_query_manager.add_bind_variable('onh_revision', inv_mwb_globals.g_tree_rev);
1556: END IF;
1557: IF inv_mwb_globals.g_tree_lot_number IS NOT NULL THEN

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

1551: inv_mwb_query_manager.add_bind_variable('onh_serial_number', inv_mwb_globals. g_tree_serial_number);
1552:
1553: IF inv_mwb_globals.g_tree_rev IS NOT NULL THEN
1554: inv_mwb_query_manager.add_where_clause('msn.revision = :onh_revision', 'ONHAND');
1555: inv_mwb_query_manager.add_bind_variable('onh_revision', inv_mwb_globals.g_tree_rev);
1556: END IF;
1557: IF inv_mwb_globals.g_tree_lot_number IS NOT NULL THEN
1558: inv_mwb_query_manager.add_where_clause('msn.lot_number = :onh_lot_number', 'ONHAND');
1559: inv_mwb_query_manager.add_bind_variable('onh_lot_number', inv_mwb_globals.g_tree_lot_number);

Line 1557: IF inv_mwb_globals.g_tree_lot_number IS NOT NULL THEN

1553: IF inv_mwb_globals.g_tree_rev IS NOT NULL THEN
1554: inv_mwb_query_manager.add_where_clause('msn.revision = :onh_revision', 'ONHAND');
1555: inv_mwb_query_manager.add_bind_variable('onh_revision', inv_mwb_globals.g_tree_rev);
1556: END IF;
1557: IF inv_mwb_globals.g_tree_lot_number IS NOT NULL THEN
1558: inv_mwb_query_manager.add_where_clause('msn.lot_number = :onh_lot_number', 'ONHAND');
1559: inv_mwb_query_manager.add_bind_variable('onh_lot_number', inv_mwb_globals.g_tree_lot_number);
1560: END IF;
1561: END IF;

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

1555: inv_mwb_query_manager.add_bind_variable('onh_revision', inv_mwb_globals.g_tree_rev);
1556: END IF;
1557: IF inv_mwb_globals.g_tree_lot_number IS NOT NULL THEN
1558: inv_mwb_query_manager.add_where_clause('msn.lot_number = :onh_lot_number', 'ONHAND');
1559: inv_mwb_query_manager.add_bind_variable('onh_lot_number', inv_mwb_globals.g_tree_lot_number);
1560: END IF;
1561: END IF;
1562:
1563: IF inv_mwb_globals.g_tree_mat_loc_id = 2 THEN

Line 1563: IF inv_mwb_globals.g_tree_mat_loc_id = 2 THEN

1559: inv_mwb_query_manager.add_bind_variable('onh_lot_number', inv_mwb_globals.g_tree_lot_number);
1560: END IF;
1561: END IF;
1562:
1563: IF inv_mwb_globals.g_tree_mat_loc_id = 2 THEN
1564: make_common_query_receiving('MSN_QUERY');
1565: inv_mwb_query_manager.add_qf_where_receiving('MSN_RECEIVING');
1566:
1567: inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=

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

1589: inv_mwb_query_manager.add_group_clause('msn.lpn_id','RECEIVING');
1590: inv_mwb_query_manager.add_group_clause('msn.cost_group_id','RECEIVING');
1591:
1592: inv_mwb_query_manager.add_where_clause('msn.lpn_id = :onh_lpn_id', 'RECEIVING');
1593: inv_mwb_query_manager.add_bind_variable('onh_lpn_id', inv_mwb_globals.g_tree_parent_lpn_id);
1594: inv_mwb_query_manager.add_where_clause('msn.inventory_item_id = :onh_inventory_item_id', 'RECEIVING');
1595: inv_mwb_query_manager.add_bind_variable('onh_inventory_item_id', inv_mwb_globals.g_tree_item_id);
1596: inv_mwb_query_manager.add_where_clause('msn.serial_number = :onh_serial_number', 'RECEIVING');
1597: inv_mwb_query_manager.add_bind_variable('onh_serial_number', inv_mwb_globals. g_tree_serial_number);

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

1591:
1592: inv_mwb_query_manager.add_where_clause('msn.lpn_id = :onh_lpn_id', 'RECEIVING');
1593: inv_mwb_query_manager.add_bind_variable('onh_lpn_id', inv_mwb_globals.g_tree_parent_lpn_id);
1594: inv_mwb_query_manager.add_where_clause('msn.inventory_item_id = :onh_inventory_item_id', 'RECEIVING');
1595: inv_mwb_query_manager.add_bind_variable('onh_inventory_item_id', inv_mwb_globals.g_tree_item_id);
1596: inv_mwb_query_manager.add_where_clause('msn.serial_number = :onh_serial_number', 'RECEIVING');
1597: inv_mwb_query_manager.add_bind_variable('onh_serial_number', inv_mwb_globals. g_tree_serial_number);
1598:
1599: IF inv_mwb_globals.g_tree_rev IS NOT NULL THEN

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

1593: inv_mwb_query_manager.add_bind_variable('onh_lpn_id', inv_mwb_globals.g_tree_parent_lpn_id);
1594: inv_mwb_query_manager.add_where_clause('msn.inventory_item_id = :onh_inventory_item_id', 'RECEIVING');
1595: inv_mwb_query_manager.add_bind_variable('onh_inventory_item_id', inv_mwb_globals.g_tree_item_id);
1596: inv_mwb_query_manager.add_where_clause('msn.serial_number = :onh_serial_number', 'RECEIVING');
1597: inv_mwb_query_manager.add_bind_variable('onh_serial_number', inv_mwb_globals. g_tree_serial_number);
1598:
1599: IF inv_mwb_globals.g_tree_rev IS NOT NULL THEN
1600: inv_mwb_query_manager.add_where_clause('msn.revision = :onh_revision', 'RECEIVING');
1601: inv_mwb_query_manager.add_bind_variable('onh_revision', inv_mwb_globals.g_tree_rev);

Line 1599: IF inv_mwb_globals.g_tree_rev IS NOT NULL THEN

1595: inv_mwb_query_manager.add_bind_variable('onh_inventory_item_id', inv_mwb_globals.g_tree_item_id);
1596: inv_mwb_query_manager.add_where_clause('msn.serial_number = :onh_serial_number', 'RECEIVING');
1597: inv_mwb_query_manager.add_bind_variable('onh_serial_number', inv_mwb_globals. g_tree_serial_number);
1598:
1599: IF inv_mwb_globals.g_tree_rev IS NOT NULL THEN
1600: inv_mwb_query_manager.add_where_clause('msn.revision = :onh_revision', 'RECEIVING');
1601: inv_mwb_query_manager.add_bind_variable('onh_revision', inv_mwb_globals.g_tree_rev);
1602: END IF;
1603: IF inv_mwb_globals.g_tree_lot_number IS NOT NULL THEN

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

1597: inv_mwb_query_manager.add_bind_variable('onh_serial_number', inv_mwb_globals. g_tree_serial_number);
1598:
1599: IF inv_mwb_globals.g_tree_rev IS NOT NULL THEN
1600: inv_mwb_query_manager.add_where_clause('msn.revision = :onh_revision', 'RECEIVING');
1601: inv_mwb_query_manager.add_bind_variable('onh_revision', inv_mwb_globals.g_tree_rev);
1602: END IF;
1603: IF inv_mwb_globals.g_tree_lot_number IS NOT NULL THEN
1604: inv_mwb_query_manager.add_where_clause('msn.lot_number = :onh_lot_number', 'RECEIVING');
1605: inv_mwb_query_manager.add_bind_variable('onh_lot_number', inv_mwb_globals.g_tree_lot_number);

Line 1603: IF inv_mwb_globals.g_tree_lot_number IS NOT NULL THEN

1599: IF inv_mwb_globals.g_tree_rev IS NOT NULL THEN
1600: inv_mwb_query_manager.add_where_clause('msn.revision = :onh_revision', 'RECEIVING');
1601: inv_mwb_query_manager.add_bind_variable('onh_revision', inv_mwb_globals.g_tree_rev);
1602: END IF;
1603: IF inv_mwb_globals.g_tree_lot_number IS NOT NULL THEN
1604: inv_mwb_query_manager.add_where_clause('msn.lot_number = :onh_lot_number', 'RECEIVING');
1605: inv_mwb_query_manager.add_bind_variable('onh_lot_number', inv_mwb_globals.g_tree_lot_number);
1606: END IF;
1607: END IF;

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

1601: inv_mwb_query_manager.add_bind_variable('onh_revision', inv_mwb_globals.g_tree_rev);
1602: END IF;
1603: IF inv_mwb_globals.g_tree_lot_number IS NOT NULL THEN
1604: inv_mwb_query_manager.add_where_clause('msn.lot_number = :onh_lot_number', 'RECEIVING');
1605: inv_mwb_query_manager.add_bind_variable('onh_lot_number', inv_mwb_globals.g_tree_lot_number);
1606: END IF;
1607: END IF;
1608:
1609: inv_mwb_query_manager.execute_query;

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

1624:
1625:
1626: PROCEDURE make_common_query_onhand(p_flag VARCHAR2) IS
1627: BEGIN
1628: IF(inv_mwb_globals.g_chk_onhand = 1) THEN
1629: CASE p_flag
1630: WHEN 'MSN' THEN
1631: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ITEM_ID).column_value :=
1632: 'msn.inventory_item_id';

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

1726: PROCEDURE make_common_query_receiving(p_flag VARCHAR2) IS
1727: l_procedure_name VARCHAR2(30);
1728: BEGIN
1729: l_procedure_name := 'MAKE_COMMON_QUERY_RECEIVING';
1730: inv_mwb_globals.print_msg(g_pkg_name, l_procedure_name, 'Entered');
1731: inv_mwb_globals.print_msg(g_pkg_name, l_procedure_name, 'p_flag : ' || p_flag);
1732: IF(inv_mwb_globals.g_chk_receiving = 1) THEN
1733: IF p_flag = 'RECEIVING' THEN
1734: inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.ORG_ID).column_value :=

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

1727: l_procedure_name VARCHAR2(30);
1728: BEGIN
1729: l_procedure_name := 'MAKE_COMMON_QUERY_RECEIVING';
1730: inv_mwb_globals.print_msg(g_pkg_name, l_procedure_name, 'Entered');
1731: inv_mwb_globals.print_msg(g_pkg_name, l_procedure_name, 'p_flag : ' || p_flag);
1732: IF(inv_mwb_globals.g_chk_receiving = 1) THEN
1733: IF p_flag = 'RECEIVING' THEN
1734: inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.ORG_ID).column_value :=
1735: 'rs.to_organization_id';

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

1728: BEGIN
1729: l_procedure_name := 'MAKE_COMMON_QUERY_RECEIVING';
1730: inv_mwb_globals.print_msg(g_pkg_name, l_procedure_name, 'Entered');
1731: inv_mwb_globals.print_msg(g_pkg_name, l_procedure_name, 'p_flag : ' || p_flag);
1732: IF(inv_mwb_globals.g_chk_receiving = 1) THEN
1733: IF p_flag = 'RECEIVING' THEN
1734: inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.ORG_ID).column_value :=
1735: 'rs.to_organization_id';
1736: inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.ITEM_ID).column_value :=

Line 1746: IF inv_mwb_globals.g_multiple_loc_selected = 'FALSE'

1742: inv_mwb_query_manager.add_group_clause('rs.item_id','RECEIVING');
1743: inv_mwb_query_manager.add_where_clause('rs.lpn_id IS NOT NULL', 'RECEIVING');
1744:
1745:
1746: IF inv_mwb_globals.g_multiple_loc_selected = 'FALSE'
1747: OR inv_mwb_globals.g_tree_node_type <> 'APPTREE_OBJECT_TRUNK' THEN
1748: inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.UNPACKED).column_value := 0;
1749: inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.PACKED).column_value :=
1750: 'SUM(rs.to_org_primary_quantity)';

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

1743: inv_mwb_query_manager.add_where_clause('rs.lpn_id IS NOT NULL', 'RECEIVING');
1744:
1745:
1746: IF inv_mwb_globals.g_multiple_loc_selected = 'FALSE'
1747: OR inv_mwb_globals.g_tree_node_type <> 'APPTREE_OBJECT_TRUNK' THEN
1748: inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.UNPACKED).column_value := 0;
1749: inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.PACKED).column_value :=
1750: 'SUM(rs.to_org_primary_quantity)';
1751: END IF;

Line 1768: IF inv_mwb_globals.g_multiple_loc_selected = 'FALSE'

1764: inv_mwb_query_manager.add_group_clause('wlpn.organization_id','RECEIVING');
1765: inv_mwb_query_manager.add_group_clause('wlc.inventory_item_id','RECEIVING');
1766: inv_mwb_query_manager.add_group_clause('wlc.uom_code','RECEIVING');
1767:
1768: IF inv_mwb_globals.g_multiple_loc_selected = 'FALSE'
1769: OR inv_mwb_globals.g_tree_node_type <> 'APPTREE_OBJECT_TRUNK' THEN
1770: inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.SECONDARY_UOM_CODE).column_value :=
1771: 'wlc.secondary_uom_code';
1772: inv_mwb_query_manager.add_group_clause('wlc.secondary_uom_code','RECEIVING');

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

1765: inv_mwb_query_manager.add_group_clause('wlc.inventory_item_id','RECEIVING');
1766: inv_mwb_query_manager.add_group_clause('wlc.uom_code','RECEIVING');
1767:
1768: IF inv_mwb_globals.g_multiple_loc_selected = 'FALSE'
1769: OR inv_mwb_globals.g_tree_node_type <> 'APPTREE_OBJECT_TRUNK' THEN
1770: inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.SECONDARY_UOM_CODE).column_value :=
1771: 'wlc.secondary_uom_code';
1772: inv_mwb_query_manager.add_group_clause('wlc.secondary_uom_code','RECEIVING');
1773: END IF;

Line 1789: IF inv_mwb_globals.g_multiple_loc_selected = 'FALSE'

1785: inv_mwb_query_manager.add_group_clause('msn.current_organization_id', 'RECEIVING');
1786: inv_mwb_query_manager.add_group_clause('msn.inventory_item_id', 'RECEIVING');
1787: inv_mwb_query_manager.add_group_clause('''Ea''', 'RECEIVING');
1788:
1789: IF inv_mwb_globals.g_multiple_loc_selected = 'FALSE'
1790: OR inv_mwb_globals.g_tree_node_type <> 'APPTREE_OBJECT_TRUNK' THEN
1791: inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.PACKED).column_value := 1;
1792: inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.UNPACKED).column_value := 0;
1793: END IF;

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

1786: inv_mwb_query_manager.add_group_clause('msn.inventory_item_id', 'RECEIVING');
1787: inv_mwb_query_manager.add_group_clause('''Ea''', 'RECEIVING');
1788:
1789: IF inv_mwb_globals.g_multiple_loc_selected = 'FALSE'
1790: OR inv_mwb_globals.g_tree_node_type <> 'APPTREE_OBJECT_TRUNK' THEN
1791: inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.PACKED).column_value := 1;
1792: inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.UNPACKED).column_value := 0;
1793: END IF;
1794:

Line 1808: IF inv_mwb_globals.g_multiple_loc_selected = 'FALSE'

1804: inv_mwb_query_manager.add_group_clause('msn.inventory_item_id' , 'RECEIVING');
1805: inv_mwb_query_manager.add_group_clause('msn.current_organization_id', 'RECEIVING');
1806: inv_mwb_query_manager.add_group_clause('''Ea''', 'RECEIVING');
1807:
1808: IF inv_mwb_globals.g_multiple_loc_selected = 'FALSE'
1809: OR inv_mwb_globals.g_tree_node_type <> 'APPTREE_OBJECT_TRUNK' THEN
1810: inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.PACKED).column_value :=
1811: 'count(1)';
1812: inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.UNPACKED).column_value := 0;

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

1805: inv_mwb_query_manager.add_group_clause('msn.current_organization_id', 'RECEIVING');
1806: inv_mwb_query_manager.add_group_clause('''Ea''', 'RECEIVING');
1807:
1808: IF inv_mwb_globals.g_multiple_loc_selected = 'FALSE'
1809: OR inv_mwb_globals.g_tree_node_type <> 'APPTREE_OBJECT_TRUNK' THEN
1810: inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.PACKED).column_value :=
1811: 'count(1)';
1812: inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.UNPACKED).column_value := 0;
1813: END IF;

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

1829: 'wlc.secondary_uom_code';
1830: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ONHAND).column_value :=
1831: 'SUM(wlc.primary_quantity)'; --bug 4761399
1832:
1833: -- IF inv_mwb_globals.g_prepacked <> 12 THEN -- For All states chosen dont add this where clause. -- Bug : 6023196
1834: IF inv_mwb_globals.g_prepacked <> 999 THEN -- For All states chosen dont add this where clause. -- Bug : 6023196
1835: inv_mwb_query_manager.add_where_clause('wlpn.lpn_context = :onh_lpn_context', 'ONHAND');
1836: inv_mwb_query_manager.add_bind_variable('onh_lpn_context', inv_mwb_globals.g_prepacked);
1837: END IF;

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

1830: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ONHAND).column_value :=
1831: 'SUM(wlc.primary_quantity)'; --bug 4761399
1832:
1833: -- IF inv_mwb_globals.g_prepacked <> 12 THEN -- For All states chosen dont add this where clause. -- Bug : 6023196
1834: IF inv_mwb_globals.g_prepacked <> 999 THEN -- For All states chosen dont add this where clause. -- Bug : 6023196
1835: inv_mwb_query_manager.add_where_clause('wlpn.lpn_context = :onh_lpn_context', 'ONHAND');
1836: inv_mwb_query_manager.add_bind_variable('onh_lpn_context', inv_mwb_globals.g_prepacked);
1837: END IF;
1838:

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

1832:
1833: -- IF inv_mwb_globals.g_prepacked <> 12 THEN -- For All states chosen dont add this where clause. -- Bug : 6023196
1834: IF inv_mwb_globals.g_prepacked <> 999 THEN -- For All states chosen dont add this where clause. -- Bug : 6023196
1835: inv_mwb_query_manager.add_where_clause('wlpn.lpn_context = :onh_lpn_context', 'ONHAND');
1836: inv_mwb_query_manager.add_bind_variable('onh_lpn_context', inv_mwb_globals.g_prepacked);
1837: END IF;
1838:
1839: inv_mwb_query_manager.add_group_clause('wlpn.organization_id','ONHAND');
1840: inv_mwb_query_manager.add_group_clause('wlc.inventory_item_id','ONHAND');

Line 1857: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_EXPANDED'

1853: l_procedure_name := 'EVENT';
1854: x_tbl_index := 1;
1855: x_node_value := 1;
1856:
1857: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_EXPANDED'
1858: OR inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
1859:
1860: CASE inv_mwb_globals.g_tree_node_type
1861: WHEN 'APPTREE_OBJECT_TRUNK' THEN

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

1854: x_tbl_index := 1;
1855: x_node_value := 1;
1856:
1857: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_EXPANDED'
1858: OR inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
1859:
1860: CASE inv_mwb_globals.g_tree_node_type
1861: WHEN 'APPTREE_OBJECT_TRUNK' THEN
1862: root_node_event (

Line 1860: CASE inv_mwb_globals.g_tree_node_type

1856:
1857: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_EXPANDED'
1858: OR inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
1859:
1860: CASE inv_mwb_globals.g_tree_node_type
1861: WHEN 'APPTREE_OBJECT_TRUNK' THEN
1862: root_node_event (
1863: x_node_value
1864: , x_node_tbl