APPS.INV_MWB_LOT_TREE dependencies on INV_MWB_QUERY_MANAGER

Line 36: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');

32: inv_mwb_globals.g_serial_to IS NOT NULL OR
33: inv_mwb_globals.g_status_id IS NOT NULL -- Bug 6060233
34: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL THEN -- Bug 6429880
35: make_common_queries('MSN_QUERY');
36: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
37: ELSE
38: make_common_queries('MOQD');
39: inv_mwb_query_manager.add_qf_where_onhand('ONHAND');
40: END IF;

Line 39: inv_mwb_query_manager.add_qf_where_onhand('ONHAND');

35: make_common_queries('MSN_QUERY');
36: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
37: ELSE
38: make_common_queries('MOQD');
39: inv_mwb_query_manager.add_qf_where_onhand('ONHAND');
40: END IF;
41: inv_mwb_query_manager.execute_query;
42:
43: END IF; -- g_tree_event

Line 41: inv_mwb_query_manager.execute_query;

37: ELSE
38: make_common_queries('MOQD');
39: inv_mwb_query_manager.add_qf_where_onhand('ONHAND');
40: END IF;
41: inv_mwb_query_manager.execute_query;
42:
43: END IF; -- g_tree_event
44: EXCEPTION
45: WHEN no_data_found THEN

Line 75: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=

71: inv_mwb_globals.g_serial_to IS NOT NULL
72: OR inv_mwb_globals.g_status_id IS NOT NULL -- Bug 6060233
73: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL THEN -- Bug 6429880
74: make_common_queries('MSN_QUERY');
75: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
76: 'msn.lot_number';
77: inv_mwb_query_manager.add_where_clause(
78: 'msn.current_organization_id = :onh_tree_organization_id' ,
79: 'ONHAND'

Line 77: inv_mwb_query_manager.add_where_clause(

73: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL THEN -- Bug 6429880
74: make_common_queries('MSN_QUERY');
75: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
76: 'msn.lot_number';
77: inv_mwb_query_manager.add_where_clause(
78: 'msn.current_organization_id = :onh_tree_organization_id' ,
79: 'ONHAND'
80: );
81: inv_mwb_query_manager.add_group_clause(

Line 81: inv_mwb_query_manager.add_group_clause(

77: inv_mwb_query_manager.add_where_clause(
78: 'msn.current_organization_id = :onh_tree_organization_id' ,
79: 'ONHAND'
80: );
81: inv_mwb_query_manager.add_group_clause(
82: 'msn.lot_number' ,
83: 'ONHAND'
84: );
85: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');

Line 85: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');

81: inv_mwb_query_manager.add_group_clause(
82: 'msn.lot_number' ,
83: 'ONHAND'
84: );
85: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
86: ELSE
87: make_common_queries('MOQD');
88: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
89: 'moqd.lot_number';

Line 88: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=

84: );
85: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
86: ELSE
87: make_common_queries('MOQD');
88: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
89: 'moqd.lot_number';
90: inv_mwb_query_manager.add_where_clause(
91: 'moqd.organization_id = :onh_tree_organization_id' ,
92: 'ONHAND'

Line 90: inv_mwb_query_manager.add_where_clause(

86: ELSE
87: make_common_queries('MOQD');
88: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
89: 'moqd.lot_number';
90: inv_mwb_query_manager.add_where_clause(
91: 'moqd.organization_id = :onh_tree_organization_id' ,
92: 'ONHAND'
93: );
94: inv_mwb_query_manager.add_group_clause(

Line 94: inv_mwb_query_manager.add_group_clause(

90: inv_mwb_query_manager.add_where_clause(
91: 'moqd.organization_id = :onh_tree_organization_id' ,
92: 'ONHAND'
93: );
94: inv_mwb_query_manager.add_group_clause(
95: 'moqd.lot_number' ,
96: 'ONHAND'
97: );
98: inv_mwb_query_manager.add_qf_where_onhand('ONHAND');

Line 98: inv_mwb_query_manager.add_qf_where_onhand('ONHAND');

94: inv_mwb_query_manager.add_group_clause(
95: 'moqd.lot_number' ,
96: 'ONHAND'
97: );
98: inv_mwb_query_manager.add_qf_where_onhand('ONHAND');
99: END IF; -- serial
100: inv_mwb_query_manager.add_bind_variable(
101: 'onh_tree_organization_id',
102: inv_mwb_globals.g_tree_organization_id

Line 100: inv_mwb_query_manager.add_bind_variable(

96: 'ONHAND'
97: );
98: inv_mwb_query_manager.add_qf_where_onhand('ONHAND');
99: END IF; -- serial
100: inv_mwb_query_manager.add_bind_variable(
101: 'onh_tree_organization_id',
102: inv_mwb_globals.g_tree_organization_id
103: );
104: inv_mwb_query_manager.execute_query;

Line 104: inv_mwb_query_manager.execute_query;

100: inv_mwb_query_manager.add_bind_variable(
101: 'onh_tree_organization_id',
102: inv_mwb_globals.g_tree_organization_id
103: );
104: inv_mwb_query_manager.execute_query;
105:
106: END IF; -- g_tree_event
107:
108: EXCEPTION

Line 138: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=

134: inv_mwb_globals.g_serial_to IS NOT NULL
135: OR inv_mwb_globals.g_status_id IS NOT NULL -- Bug 6060233
136: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL THEN -- Bug 6429880
137: make_common_queries('MSN_QUERY');
138: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
139: 'msn.lot_number';
140: inv_mwb_query_manager.add_where_clause(
141: 'msn.current_organization_id = :onh_tree_organization_id' ,
142: 'ONHAND'

Line 140: inv_mwb_query_manager.add_where_clause(

136: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL THEN -- Bug 6429880
137: make_common_queries('MSN_QUERY');
138: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
139: 'msn.lot_number';
140: inv_mwb_query_manager.add_where_clause(
141: 'msn.current_organization_id = :onh_tree_organization_id' ,
142: 'ONHAND'
143: );
144: inv_mwb_query_manager.add_where_clause(

Line 144: inv_mwb_query_manager.add_where_clause(

140: inv_mwb_query_manager.add_where_clause(
141: 'msn.current_organization_id = :onh_tree_organization_id' ,
142: 'ONHAND'
143: );
144: inv_mwb_query_manager.add_where_clause(
145: 'msn.lot_number = :onh_tree_lot_number' ,
146: 'ONHAND'
147: );
148: inv_mwb_query_manager.add_group_clause(

Line 148: inv_mwb_query_manager.add_group_clause(

144: inv_mwb_query_manager.add_where_clause(
145: 'msn.lot_number = :onh_tree_lot_number' ,
146: 'ONHAND'
147: );
148: inv_mwb_query_manager.add_group_clause(
149: 'msn.lot_number' ,
150: 'ONHAND'
151: );
152: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');

Line 152: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');

148: inv_mwb_query_manager.add_group_clause(
149: 'msn.lot_number' ,
150: 'ONHAND'
151: );
152: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
153: ELSE
154: make_common_queries('MOQD');
155: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
156: 'moqd.lot_number';

Line 155: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=

151: );
152: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
153: ELSE
154: make_common_queries('MOQD');
155: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
156: 'moqd.lot_number';
157: inv_mwb_query_manager.add_where_clause(
158: 'moqd.organization_id = :onh_tree_organization_id' ,
159: 'ONHAND'

Line 157: inv_mwb_query_manager.add_where_clause(

153: ELSE
154: make_common_queries('MOQD');
155: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
156: 'moqd.lot_number';
157: inv_mwb_query_manager.add_where_clause(
158: 'moqd.organization_id = :onh_tree_organization_id' ,
159: 'ONHAND'
160: );
161: inv_mwb_query_manager.add_where_clause(

Line 161: inv_mwb_query_manager.add_where_clause(

157: inv_mwb_query_manager.add_where_clause(
158: 'moqd.organization_id = :onh_tree_organization_id' ,
159: 'ONHAND'
160: );
161: inv_mwb_query_manager.add_where_clause(
162: 'moqd.lot_number = :onh_tree_lot_number' ,
163: 'ONHAND'
164: );
165: inv_mwb_query_manager.add_group_clause(

Line 165: inv_mwb_query_manager.add_group_clause(

161: inv_mwb_query_manager.add_where_clause(
162: 'moqd.lot_number = :onh_tree_lot_number' ,
163: 'ONHAND'
164: );
165: inv_mwb_query_manager.add_group_clause(
166: 'moqd.lot_number' ,
167: 'ONHAND'
168: );
169:

Line 170: inv_mwb_query_manager.add_qf_where_onhand('ONHAND');

166: 'moqd.lot_number' ,
167: 'ONHAND'
168: );
169:
170: inv_mwb_query_manager.add_qf_where_onhand('ONHAND');
171: END IF; -- serial
172: inv_mwb_query_manager.add_bind_variable(
173: 'onh_tree_organization_id',
174: inv_mwb_globals.g_tree_organization_id

Line 172: inv_mwb_query_manager.add_bind_variable(

168: );
169:
170: inv_mwb_query_manager.add_qf_where_onhand('ONHAND');
171: END IF; -- serial
172: inv_mwb_query_manager.add_bind_variable(
173: 'onh_tree_organization_id',
174: inv_mwb_globals.g_tree_organization_id
175: );
176: inv_mwb_query_manager.add_bind_variable(

Line 176: inv_mwb_query_manager.add_bind_variable(

172: inv_mwb_query_manager.add_bind_variable(
173: 'onh_tree_organization_id',
174: inv_mwb_globals.g_tree_organization_id
175: );
176: inv_mwb_query_manager.add_bind_variable(
177: 'onh_tree_lot_number',
178: inv_mwb_globals.g_tree_lot_number
179: );
180: inv_mwb_query_manager.execute_query;

Line 180: inv_mwb_query_manager.execute_query;

176: inv_mwb_query_manager.add_bind_variable(
177: 'onh_tree_lot_number',
178: inv_mwb_globals.g_tree_lot_number
179: );
180: inv_mwb_query_manager.execute_query;
181:
182: END IF;
183:
184: EXCEPTION

Line 229: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=

225: AND inventory_item_id = inv_mwb_globals.g_tree_item_id;
226:
227: IF NVL(l_rev_control, 1) = 1 AND l_serial_control IN (2,5) THEN
228: make_common_queries('MSN');
229: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
230: 'msn.lot_number';
231: inv_mwb_query_manager.add_where_clause(
232: 'msn.current_organization_id = :onh_tree_organization_id' ,
233: 'ONHAND'

Line 231: inv_mwb_query_manager.add_where_clause(

227: IF NVL(l_rev_control, 1) = 1 AND l_serial_control IN (2,5) THEN
228: make_common_queries('MSN');
229: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
230: 'msn.lot_number';
231: inv_mwb_query_manager.add_where_clause(
232: 'msn.current_organization_id = :onh_tree_organization_id' ,
233: 'ONHAND'
234: );
235: inv_mwb_query_manager.add_where_clause(

Line 235: inv_mwb_query_manager.add_where_clause(

231: inv_mwb_query_manager.add_where_clause(
232: 'msn.current_organization_id = :onh_tree_organization_id' ,
233: 'ONHAND'
234: );
235: inv_mwb_query_manager.add_where_clause(
236: 'msn.lot_number = :onh_tree_lot_number' ,
237: 'ONHAND'
238: );
239: inv_mwb_query_manager.add_where_clause(

Line 239: inv_mwb_query_manager.add_where_clause(

235: inv_mwb_query_manager.add_where_clause(
236: 'msn.lot_number = :onh_tree_lot_number' ,
237: 'ONHAND'
238: );
239: inv_mwb_query_manager.add_where_clause(
240: 'msn.inventory_item_id = :onh_tree_inventory_item_id' ,
241: 'ONHAND'
242: );
243: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');

Line 243: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');

239: inv_mwb_query_manager.add_where_clause(
240: 'msn.inventory_item_id = :onh_tree_inventory_item_id' ,
241: 'ONHAND'
242: );
243: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
244:
245: ELSE -- item is not serial controlled
246:
247: IF inv_mwb_globals.g_serial_from IS NOT NULL OR

Line 252: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=

248: inv_mwb_globals.g_serial_to IS NOT NULL
249: OR inv_mwb_globals.g_status_id IS NOT NULL -- Bug 6060233
250: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL THEN -- Bug 6429880
251: make_common_queries('MSN_QUERY');
252: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
253: 'msn.lot_number';
254: IF l_rev_control = 2 THEN
255: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.revision).column_value :=
256: 'msn.revision';

Line 255: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.revision).column_value :=

251: make_common_queries('MSN_QUERY');
252: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
253: 'msn.lot_number';
254: IF l_rev_control = 2 THEN
255: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.revision).column_value :=
256: 'msn.revision';
257: inv_mwb_query_manager.add_group_clause(
258: 'msn.revision' ,
259: 'ONHAND'

Line 257: inv_mwb_query_manager.add_group_clause(

253: 'msn.lot_number';
254: IF l_rev_control = 2 THEN
255: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.revision).column_value :=
256: 'msn.revision';
257: inv_mwb_query_manager.add_group_clause(
258: 'msn.revision' ,
259: 'ONHAND'
260: );
261: END IF;

Line 262: inv_mwb_query_manager.add_where_clause(

258: 'msn.revision' ,
259: 'ONHAND'
260: );
261: END IF;
262: inv_mwb_query_manager.add_where_clause(
263: 'msn.current_organization_id = :onh_tree_organization_id' ,
264: 'ONHAND'
265: );
266: inv_mwb_query_manager.add_where_clause(

Line 266: inv_mwb_query_manager.add_where_clause(

262: inv_mwb_query_manager.add_where_clause(
263: 'msn.current_organization_id = :onh_tree_organization_id' ,
264: 'ONHAND'
265: );
266: inv_mwb_query_manager.add_where_clause(
267: 'msn.lot_number = :onh_tree_lot_number' ,
268: 'ONHAND'
269: );
270: inv_mwb_query_manager.add_where_clause(

Line 270: inv_mwb_query_manager.add_where_clause(

266: inv_mwb_query_manager.add_where_clause(
267: 'msn.lot_number = :onh_tree_lot_number' ,
268: 'ONHAND'
269: );
270: inv_mwb_query_manager.add_where_clause(
271: 'msn.inventory_item_id = :onh_tree_inventory_item_id' ,
272: 'ONHAND'
273: );
274: inv_mwb_query_manager.add_group_clause(

Line 274: inv_mwb_query_manager.add_group_clause(

270: inv_mwb_query_manager.add_where_clause(
271: 'msn.inventory_item_id = :onh_tree_inventory_item_id' ,
272: 'ONHAND'
273: );
274: inv_mwb_query_manager.add_group_clause(
275: 'msn.lot_number' ,
276: 'ONHAND'
277: );
278: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');

Line 278: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');

274: inv_mwb_query_manager.add_group_clause(
275: 'msn.lot_number' ,
276: 'ONHAND'
277: );
278: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
279: ELSE
280: make_common_queries('MOQD');
281: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
282: 'moqd.lot_number';

Line 281: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=

277: );
278: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
279: ELSE
280: make_common_queries('MOQD');
281: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
282: 'moqd.lot_number';
283: IF l_rev_control = 2 THEN
284: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.revision).column_value :=
285: 'moqd.revision';

Line 284: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.revision).column_value :=

280: make_common_queries('MOQD');
281: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
282: 'moqd.lot_number';
283: IF l_rev_control = 2 THEN
284: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.revision).column_value :=
285: 'moqd.revision';
286: inv_mwb_query_manager.add_group_clause(
287: 'moqd.revision' ,
288: 'ONHAND'

Line 286: inv_mwb_query_manager.add_group_clause(

282: 'moqd.lot_number';
283: IF l_rev_control = 2 THEN
284: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.revision).column_value :=
285: 'moqd.revision';
286: inv_mwb_query_manager.add_group_clause(
287: 'moqd.revision' ,
288: 'ONHAND'
289: );
290: END IF;

Line 291: inv_mwb_query_manager.add_where_clause(

287: 'moqd.revision' ,
288: 'ONHAND'
289: );
290: END IF;
291: inv_mwb_query_manager.add_where_clause(
292: 'moqd.organization_id = :onh_tree_organization_id' ,
293: 'ONHAND'
294: );
295: inv_mwb_query_manager.add_where_clause(

Line 295: inv_mwb_query_manager.add_where_clause(

291: inv_mwb_query_manager.add_where_clause(
292: 'moqd.organization_id = :onh_tree_organization_id' ,
293: 'ONHAND'
294: );
295: inv_mwb_query_manager.add_where_clause(
296: 'moqd.lot_number = :onh_tree_lot_number' ,
297: 'ONHAND'
298: );
299: inv_mwb_query_manager.add_where_clause(

Line 299: inv_mwb_query_manager.add_where_clause(

295: inv_mwb_query_manager.add_where_clause(
296: 'moqd.lot_number = :onh_tree_lot_number' ,
297: 'ONHAND'
298: );
299: inv_mwb_query_manager.add_where_clause(
300: 'moqd.inventory_item_id = :onh_tree_inventory_item_id' ,
301: 'ONHAND'
302: );
303: inv_mwb_query_manager.add_group_clause(

Line 303: inv_mwb_query_manager.add_group_clause(

299: inv_mwb_query_manager.add_where_clause(
300: 'moqd.inventory_item_id = :onh_tree_inventory_item_id' ,
301: 'ONHAND'
302: );
303: inv_mwb_query_manager.add_group_clause(
304: 'moqd.lot_number' ,
305: 'ONHAND'
306: );
307:

Line 308: inv_mwb_query_manager.add_qf_where_onhand('ONHAND');

304: 'moqd.lot_number' ,
305: 'ONHAND'
306: );
307:
308: inv_mwb_query_manager.add_qf_where_onhand('ONHAND');
309: END IF; -- serial
310:
311: END IF; -- item is not serial controlled
312: inv_mwb_query_manager.add_bind_variable(

Line 312: inv_mwb_query_manager.add_bind_variable(

308: inv_mwb_query_manager.add_qf_where_onhand('ONHAND');
309: END IF; -- serial
310:
311: END IF; -- item is not serial controlled
312: inv_mwb_query_manager.add_bind_variable(
313: 'onh_tree_organization_id',
314: inv_mwb_globals.g_tree_organization_id
315: );
316: inv_mwb_query_manager.add_bind_variable(

Line 316: inv_mwb_query_manager.add_bind_variable(

312: inv_mwb_query_manager.add_bind_variable(
313: 'onh_tree_organization_id',
314: inv_mwb_globals.g_tree_organization_id
315: );
316: inv_mwb_query_manager.add_bind_variable(
317: 'onh_tree_lot_number',
318: inv_mwb_globals.g_tree_lot_number
319: );
320: inv_mwb_query_manager.add_bind_variable(

Line 320: inv_mwb_query_manager.add_bind_variable(

316: inv_mwb_query_manager.add_bind_variable(
317: 'onh_tree_lot_number',
318: inv_mwb_globals.g_tree_lot_number
319: );
320: inv_mwb_query_manager.add_bind_variable(
321: 'onh_tree_inventory_item_id',
322: inv_mwb_globals.g_tree_item_id
323: );
324: inv_mwb_query_manager.execute_query;

Line 324: inv_mwb_query_manager.execute_query;

320: inv_mwb_query_manager.add_bind_variable(
321: 'onh_tree_inventory_item_id',
322: inv_mwb_globals.g_tree_item_id
323: );
324: inv_mwb_query_manager.execute_query;
325:
326: END IF; -- g_tree_Event
327:
328: EXCEPTION

Line 363: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=

359: AND inventory_item_id = inv_mwb_globals.g_tree_item_id;
360:
361: IF l_serial_control in ( 2,5 ) THEN
362: make_common_queries('MSN');
363: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
364: 'msn.lot_number';
365: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SERIAL).column_value :=
366: 'msn.serial_number';
367: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.revision).column_value :=

Line 365: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SERIAL).column_value :=

361: IF l_serial_control in ( 2,5 ) THEN
362: make_common_queries('MSN');
363: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
364: 'msn.lot_number';
365: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SERIAL).column_value :=
366: 'msn.serial_number';
367: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.revision).column_value :=
368: 'msn.revision';
369: inv_mwb_query_manager.add_where_clause(

Line 367: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.revision).column_value :=

363: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
364: 'msn.lot_number';
365: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SERIAL).column_value :=
366: 'msn.serial_number';
367: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.revision).column_value :=
368: 'msn.revision';
369: inv_mwb_query_manager.add_where_clause(
370: 'msn.revision = :onh_tree_revision' ,
371: 'ONHAND'

Line 369: inv_mwb_query_manager.add_where_clause(

365: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SERIAL).column_value :=
366: 'msn.serial_number';
367: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.revision).column_value :=
368: 'msn.revision';
369: inv_mwb_query_manager.add_where_clause(
370: 'msn.revision = :onh_tree_revision' ,
371: 'ONHAND'
372: );
373: inv_mwb_query_manager.add_where_clause(

Line 373: inv_mwb_query_manager.add_where_clause(

369: inv_mwb_query_manager.add_where_clause(
370: 'msn.revision = :onh_tree_revision' ,
371: 'ONHAND'
372: );
373: inv_mwb_query_manager.add_where_clause(
374: 'msn.current_organization_id = :onh_tree_organization_id' ,
375: 'ONHAND'
376: );
377: inv_mwb_query_manager.add_where_clause(

Line 377: inv_mwb_query_manager.add_where_clause(

373: inv_mwb_query_manager.add_where_clause(
374: 'msn.current_organization_id = :onh_tree_organization_id' ,
375: 'ONHAND'
376: );
377: inv_mwb_query_manager.add_where_clause(
378: 'msn.lot_number = :onh_tree_lot_number' ,
379: 'ONHAND'
380: );
381: inv_mwb_query_manager.add_where_clause(

Line 381: inv_mwb_query_manager.add_where_clause(

377: inv_mwb_query_manager.add_where_clause(
378: 'msn.lot_number = :onh_tree_lot_number' ,
379: 'ONHAND'
380: );
381: inv_mwb_query_manager.add_where_clause(
382: 'msn.inventory_item_id = :onh_tree_inventory_item_id' ,
383: 'ONHAND'
384: );
385: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');

Line 385: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');

381: inv_mwb_query_manager.add_where_clause(
382: 'msn.inventory_item_id = :onh_tree_inventory_item_id' ,
383: 'ONHAND'
384: );
385: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
386:
387: ELSE -- not serial item
388: make_common_queries('MOQD');
389: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=

Line 389: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=

385: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
386:
387: ELSE -- not serial item
388: make_common_queries('MOQD');
389: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
390: 'moqd.lot_number';
391: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.revision).column_value :=
392: 'moqd.revision';
393: inv_mwb_query_manager.add_where_clause(

Line 391: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.revision).column_value :=

387: ELSE -- not serial item
388: make_common_queries('MOQD');
389: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
390: 'moqd.lot_number';
391: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.revision).column_value :=
392: 'moqd.revision';
393: inv_mwb_query_manager.add_where_clause(
394: 'moqd.revision = :onh_tree_revision' ,
395: 'ONHAND'

Line 393: inv_mwb_query_manager.add_where_clause(

389: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
390: 'moqd.lot_number';
391: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.revision).column_value :=
392: 'moqd.revision';
393: inv_mwb_query_manager.add_where_clause(
394: 'moqd.revision = :onh_tree_revision' ,
395: 'ONHAND'
396: );
397: inv_mwb_query_manager.add_where_clause(

Line 397: inv_mwb_query_manager.add_where_clause(

393: inv_mwb_query_manager.add_where_clause(
394: 'moqd.revision = :onh_tree_revision' ,
395: 'ONHAND'
396: );
397: inv_mwb_query_manager.add_where_clause(
398: 'moqd.organization_id = :onh_tree_organization_id' ,
399: 'ONHAND'
400: );
401: inv_mwb_query_manager.add_where_clause(

Line 401: inv_mwb_query_manager.add_where_clause(

397: inv_mwb_query_manager.add_where_clause(
398: 'moqd.organization_id = :onh_tree_organization_id' ,
399: 'ONHAND'
400: );
401: inv_mwb_query_manager.add_where_clause(
402: 'moqd.lot_number = :onh_tree_lot_number' ,
403: 'ONHAND'
404: );
405: inv_mwb_query_manager.add_where_clause(

Line 405: inv_mwb_query_manager.add_where_clause(

401: inv_mwb_query_manager.add_where_clause(
402: 'moqd.lot_number = :onh_tree_lot_number' ,
403: 'ONHAND'
404: );
405: inv_mwb_query_manager.add_where_clause(
406: 'moqd.inventory_item_id = :onh_tree_inventory_item_id' ,
407: 'ONHAND'
408: );
409: inv_mwb_query_manager.add_group_clause(

Line 409: inv_mwb_query_manager.add_group_clause(

405: inv_mwb_query_manager.add_where_clause(
406: 'moqd.inventory_item_id = :onh_tree_inventory_item_id' ,
407: 'ONHAND'
408: );
409: inv_mwb_query_manager.add_group_clause(
410: 'moqd.lot_number',
411: 'ONHAND'
412: );
413: inv_mwb_query_manager.add_group_clause(

Line 413: inv_mwb_query_manager.add_group_clause(

409: inv_mwb_query_manager.add_group_clause(
410: 'moqd.lot_number',
411: 'ONHAND'
412: );
413: inv_mwb_query_manager.add_group_clause(
414: 'moqd.revision',
415: 'ONHAND'
416: );
417:

Line 418: inv_mwb_query_manager.add_qf_where_onhand('ONHAND');

414: 'moqd.revision',
415: 'ONHAND'
416: );
417:
418: inv_mwb_query_manager.add_qf_where_onhand('ONHAND');
419: END IF;
420: inv_mwb_query_manager.add_bind_variable(
421: 'onh_tree_organization_id',
422: inv_mwb_globals.g_tree_organization_id

Line 420: inv_mwb_query_manager.add_bind_variable(

416: );
417:
418: inv_mwb_query_manager.add_qf_where_onhand('ONHAND');
419: END IF;
420: inv_mwb_query_manager.add_bind_variable(
421: 'onh_tree_organization_id',
422: inv_mwb_globals.g_tree_organization_id
423: );
424: inv_mwb_query_manager.add_bind_variable(

Line 424: inv_mwb_query_manager.add_bind_variable(

420: inv_mwb_query_manager.add_bind_variable(
421: 'onh_tree_organization_id',
422: inv_mwb_globals.g_tree_organization_id
423: );
424: inv_mwb_query_manager.add_bind_variable(
425: 'onh_tree_lot_number',
426: inv_mwb_globals.g_tree_lot_number
427: );
428: inv_mwb_query_manager.add_bind_variable(

Line 428: inv_mwb_query_manager.add_bind_variable(

424: inv_mwb_query_manager.add_bind_variable(
425: 'onh_tree_lot_number',
426: inv_mwb_globals.g_tree_lot_number
427: );
428: inv_mwb_query_manager.add_bind_variable(
429: 'onh_tree_inventory_item_id',
430: inv_mwb_globals.g_tree_item_id
431: );
432: inv_mwb_query_manager.add_bind_variable(

Line 432: inv_mwb_query_manager.add_bind_variable(

428: inv_mwb_query_manager.add_bind_variable(
429: 'onh_tree_inventory_item_id',
430: inv_mwb_globals.g_tree_item_id
431: );
432: inv_mwb_query_manager.add_bind_variable(
433: 'onh_tree_revision',
434: inv_mwb_globals.g_tree_rev
435: );
436: inv_mwb_query_manager.execute_query;

Line 436: inv_mwb_query_manager.execute_query;

432: inv_mwb_query_manager.add_bind_variable(
433: 'onh_tree_revision',
434: inv_mwb_globals.g_tree_rev
435: );
436: inv_mwb_query_manager.execute_query;
437:
438: END IF; -- g_tree
439:
440: EXCEPTION

Line 467: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=

463: WHERE organization_id = inv_mwb_globals.g_tree_organization_id
464: AND inventory_item_id = inv_mwb_globals.g_tree_item_id;
465:
466: make_common_queries('MSN');
467: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
468: 'msn.lot_number';
469: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SERIAL).column_value :=
470: 'msn.serial_number';
471: IF l_rev_control = 2 THEN

Line 469: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SERIAL).column_value :=

465:
466: make_common_queries('MSN');
467: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
468: 'msn.lot_number';
469: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SERIAL).column_value :=
470: 'msn.serial_number';
471: IF l_rev_control = 2 THEN
472: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.revision).column_value :=
473: 'msn.revision';

Line 472: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.revision).column_value :=

468: 'msn.lot_number';
469: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SERIAL).column_value :=
470: 'msn.serial_number';
471: IF l_rev_control = 2 THEN
472: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.revision).column_value :=
473: 'msn.revision';
474: inv_mwb_query_manager.add_where_clause(
475: 'msn.revision = :onh_tree_revision' ,
476: 'ONHAND'

Line 474: inv_mwb_query_manager.add_where_clause(

470: 'msn.serial_number';
471: IF l_rev_control = 2 THEN
472: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.revision).column_value :=
473: 'msn.revision';
474: inv_mwb_query_manager.add_where_clause(
475: 'msn.revision = :onh_tree_revision' ,
476: 'ONHAND'
477: );
478: inv_mwb_query_manager.add_bind_variable(

Line 478: inv_mwb_query_manager.add_bind_variable(

474: inv_mwb_query_manager.add_where_clause(
475: 'msn.revision = :onh_tree_revision' ,
476: 'ONHAND'
477: );
478: inv_mwb_query_manager.add_bind_variable(
479: 'onh_tree_revision',
480: inv_mwb_globals.g_tree_rev
481: );
482: END IF;

Line 483: inv_mwb_query_manager.add_where_clause(

479: 'onh_tree_revision',
480: inv_mwb_globals.g_tree_rev
481: );
482: END IF;
483: inv_mwb_query_manager.add_where_clause(
484: 'msn.current_organization_id = :onh_tree_organization_id' ,
485: 'ONHAND'
486: );
487: inv_mwb_query_manager.add_where_clause(

Line 487: inv_mwb_query_manager.add_where_clause(

483: inv_mwb_query_manager.add_where_clause(
484: 'msn.current_organization_id = :onh_tree_organization_id' ,
485: 'ONHAND'
486: );
487: inv_mwb_query_manager.add_where_clause(
488: 'msn.lot_number = :onh_tree_lot_number' ,
489: 'ONHAND'
490: );
491: inv_mwb_query_manager.add_where_clause(

Line 491: inv_mwb_query_manager.add_where_clause(

487: inv_mwb_query_manager.add_where_clause(
488: 'msn.lot_number = :onh_tree_lot_number' ,
489: 'ONHAND'
490: );
491: inv_mwb_query_manager.add_where_clause(
492: 'msn.inventory_item_id = :onh_tree_inventory_item_id' ,
493: 'ONHAND'
494: );
495: inv_mwb_query_manager.add_where_clause(

Line 495: inv_mwb_query_manager.add_where_clause(

491: inv_mwb_query_manager.add_where_clause(
492: 'msn.inventory_item_id = :onh_tree_inventory_item_id' ,
493: 'ONHAND'
494: );
495: inv_mwb_query_manager.add_where_clause(
496: 'msn.serial_number = :onh_tree_serial_number' ,
497: 'ONHAND'
498: );
499: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');

Line 499: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');

495: inv_mwb_query_manager.add_where_clause(
496: 'msn.serial_number = :onh_tree_serial_number' ,
497: 'ONHAND'
498: );
499: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
500: inv_mwb_query_manager.add_bind_variable(
501: 'onh_tree_organization_id',
502: inv_mwb_globals.g_tree_organization_id
503: );

Line 500: inv_mwb_query_manager.add_bind_variable(

496: 'msn.serial_number = :onh_tree_serial_number' ,
497: 'ONHAND'
498: );
499: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
500: inv_mwb_query_manager.add_bind_variable(
501: 'onh_tree_organization_id',
502: inv_mwb_globals.g_tree_organization_id
503: );
504: inv_mwb_query_manager.add_bind_variable(

Line 504: inv_mwb_query_manager.add_bind_variable(

500: inv_mwb_query_manager.add_bind_variable(
501: 'onh_tree_organization_id',
502: inv_mwb_globals.g_tree_organization_id
503: );
504: inv_mwb_query_manager.add_bind_variable(
505: 'onh_tree_lot_number',
506: inv_mwb_globals.g_tree_lot_number
507: );
508: inv_mwb_query_manager.add_bind_variable(

Line 508: inv_mwb_query_manager.add_bind_variable(

504: inv_mwb_query_manager.add_bind_variable(
505: 'onh_tree_lot_number',
506: inv_mwb_globals.g_tree_lot_number
507: );
508: inv_mwb_query_manager.add_bind_variable(
509: 'onh_tree_inventory_item_id',
510: inv_mwb_globals.g_tree_item_id
511: );
512: inv_mwb_query_manager.add_bind_variable(

Line 512: inv_mwb_query_manager.add_bind_variable(

508: inv_mwb_query_manager.add_bind_variable(
509: 'onh_tree_inventory_item_id',
510: inv_mwb_globals.g_tree_item_id
511: );
512: inv_mwb_query_manager.add_bind_variable(
513: 'onh_tree_serial_number',
514: inv_mwb_globals.g_tree_serial_number
515: );
516: inv_mwb_query_manager.execute_query;

Line 516: inv_mwb_query_manager.execute_query;

512: inv_mwb_query_manager.add_bind_variable(
513: 'onh_tree_serial_number',
514: inv_mwb_globals.g_tree_serial_number
515: );
516: inv_mwb_query_manager.execute_query;
517:
518: END IF; -- g_tree
519:
520: EXCEPTION

Line 531: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ITEM_ID).column_value :=

527: BEGIN
528:
529: CASE p_flag
530: WHEN 'MSN' THEN
531: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ITEM_ID).column_value :=
532: 'msn.inventory_item_id';
533:
534: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ORG_ID).column_value :=
535: 'msn.current_organization_id';

Line 534: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ORG_ID).column_value :=

530: WHEN 'MSN' THEN
531: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ITEM_ID).column_value :=
532: 'msn.inventory_item_id';
533:
534: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ORG_ID).column_value :=
535: 'msn.current_organization_id';
536:
537: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PRIMARY_UOM_CODE).column_value :=
538: '''Ea''';

Line 537: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PRIMARY_UOM_CODE).column_value :=

533:
534: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ORG_ID).column_value :=
535: 'msn.current_organization_id';
536:
537: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PRIMARY_UOM_CODE).column_value :=
538: '''Ea''';
539:
540: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ONHAND).column_value := 1;
541:

Line 540: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ONHAND).column_value := 1;

536:
537: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PRIMARY_UOM_CODE).column_value :=
538: '''Ea''';
539:
540: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ONHAND).column_value := 1;
541:
542: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PACKED).column_value :=
543: 'DECODE(msn.lpn_id, NULL, 0,1)';
544:

Line 542: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PACKED).column_value :=

538: '''Ea''';
539:
540: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ONHAND).column_value := 1;
541:
542: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PACKED).column_value :=
543: 'DECODE(msn.lpn_id, NULL, 0,1)';
544:
545: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.UNPACKED).column_value :=
546: 'DECODE(msn.lpn_id, NULL, 1,0)';

Line 545: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.UNPACKED).column_value :=

541:
542: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PACKED).column_value :=
543: 'DECODE(msn.lpn_id, NULL, 0,1)';
544:
545: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.UNPACKED).column_value :=
546: 'DECODE(msn.lpn_id, NULL, 1,0)';
547:
548: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SECONDARY_UOM_CODE).column_value :=
549: 'NULL';

Line 548: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SECONDARY_UOM_CODE).column_value :=

544:
545: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.UNPACKED).column_value :=
546: 'DECODE(msn.lpn_id, NULL, 1,0)';
547:
548: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SECONDARY_UOM_CODE).column_value :=
549: 'NULL';
550:
551: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SECONDARY_PACKED).column_value :=
552: 'NULL';

Line 551: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SECONDARY_PACKED).column_value :=

547:
548: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SECONDARY_UOM_CODE).column_value :=
549: 'NULL';
550:
551: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SECONDARY_PACKED).column_value :=
552: 'NULL';
553:
554: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SECONDARY_UNPACKED).column_value :=
555: 'NULL';

Line 554: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SECONDARY_UNPACKED).column_value :=

550:
551: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SECONDARY_PACKED).column_value :=
552: 'NULL';
553:
554: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SECONDARY_UNPACKED).column_value :=
555: 'NULL';
556:
557: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SERIAL).column_value :=
558: 'msn.serial_number';

Line 557: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SERIAL).column_value :=

553:
554: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SECONDARY_UNPACKED).column_value :=
555: 'NULL';
556:
557: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SERIAL).column_value :=
558: 'msn.serial_number';
559:
560: inv_mwb_query_manager.add_from_clause('mtl_serial_numbers msn', 'ONHAND');
561:

Line 560: inv_mwb_query_manager.add_from_clause('mtl_serial_numbers msn', 'ONHAND');

556:
557: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SERIAL).column_value :=
558: 'msn.serial_number';
559:
560: inv_mwb_query_manager.add_from_clause('mtl_serial_numbers msn', 'ONHAND');
561:
562: inv_mwb_query_manager.add_where_clause('msn.current_status = 3', 'ONHAND');
563:
564: WHEN 'MOQD' THEN

Line 562: inv_mwb_query_manager.add_where_clause('msn.current_status = 3', 'ONHAND');

558: 'msn.serial_number';
559:
560: inv_mwb_query_manager.add_from_clause('mtl_serial_numbers msn', 'ONHAND');
561:
562: inv_mwb_query_manager.add_where_clause('msn.current_status = 3', 'ONHAND');
563:
564: WHEN 'MOQD' THEN
565:
566: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ITEM_ID).column_value :=

Line 566: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ITEM_ID).column_value :=

562: inv_mwb_query_manager.add_where_clause('msn.current_status = 3', 'ONHAND');
563:
564: WHEN 'MOQD' THEN
565:
566: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ITEM_ID).column_value :=
567: 'moqd.inventory_item_id';
568:
569: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ORG_ID).column_value :=
570: 'moqd.organization_id';

Line 569: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ORG_ID).column_value :=

565:
566: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ITEM_ID).column_value :=
567: 'moqd.inventory_item_id';
568:
569: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ORG_ID).column_value :=
570: 'moqd.organization_id';
571:
572: -- inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PRIMARY_UOM_CODE).column_value :=
573: -- 'moqd.transaction_uom_code';

Line 572: -- inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PRIMARY_UOM_CODE).column_value :=

568:
569: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ORG_ID).column_value :=
570: 'moqd.organization_id';
571:
572: -- inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PRIMARY_UOM_CODE).column_value :=
573: -- 'moqd.transaction_uom_code';
574:
575: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ONHAND).column_value :=
576: 'SUM(moqd.primary_transaction_quantity)';

Line 575: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ONHAND).column_value :=

571:
572: -- inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PRIMARY_UOM_CODE).column_value :=
573: -- 'moqd.transaction_uom_code';
574:
575: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ONHAND).column_value :=
576: 'SUM(moqd.primary_transaction_quantity)';
577:
578: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PACKED).column_value :=
579: 'SUM(DECODE(moqd.containerized_flag, 1, moqd.primary_transaction_quantity, 0))';

Line 578: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PACKED).column_value :=

574:
575: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ONHAND).column_value :=
576: 'SUM(moqd.primary_transaction_quantity)';
577:
578: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PACKED).column_value :=
579: 'SUM(DECODE(moqd.containerized_flag, 1, moqd.primary_transaction_quantity, 0))';
580:
581: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.UNPACKED).column_value :=
582: 'SUM(DECODE(moqd.containerized_flag, 1, 0, moqd.primary_transaction_quantity))';

Line 581: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.UNPACKED).column_value :=

577:
578: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PACKED).column_value :=
579: 'SUM(DECODE(moqd.containerized_flag, 1, moqd.primary_transaction_quantity, 0))';
580:
581: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.UNPACKED).column_value :=
582: 'SUM(DECODE(moqd.containerized_flag, 1, 0, moqd.primary_transaction_quantity))';
583:
584: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SECONDARY_UOM_CODE).column_value :=
585: 'moqd.secondary_uom_code';

Line 584: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SECONDARY_UOM_CODE).column_value :=

580:
581: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.UNPACKED).column_value :=
582: 'SUM(DECODE(moqd.containerized_flag, 1, 0, moqd.primary_transaction_quantity))';
583:
584: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SECONDARY_UOM_CODE).column_value :=
585: 'moqd.secondary_uom_code';
586:
587: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SECONDARY_ONHAND).column_value :=
588: 'SUM(moqd.secondary_transaction_quantity)';

Line 587: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SECONDARY_ONHAND).column_value :=

583:
584: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SECONDARY_UOM_CODE).column_value :=
585: 'moqd.secondary_uom_code';
586:
587: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SECONDARY_ONHAND).column_value :=
588: 'SUM(moqd.secondary_transaction_quantity)';
589:
590: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SECONDARY_PACKED).column_value :=
591: 'SUM(DECODE(moqd.containerized_flag, 1, moqd.secondary_transaction_quantity, 0))';

Line 590: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SECONDARY_PACKED).column_value :=

586:
587: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SECONDARY_ONHAND).column_value :=
588: 'SUM(moqd.secondary_transaction_quantity)';
589:
590: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SECONDARY_PACKED).column_value :=
591: 'SUM(DECODE(moqd.containerized_flag, 1, moqd.secondary_transaction_quantity, 0))';
592:
593: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SECONDARY_UNPACKED).column_value :=
594: 'SUM(DECODE(moqd.containerized_flag, 1, 0, moqd.secondary_transaction_quantity))';

Line 593: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SECONDARY_UNPACKED).column_value :=

589:
590: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SECONDARY_PACKED).column_value :=
591: 'SUM(DECODE(moqd.containerized_flag, 1, moqd.secondary_transaction_quantity, 0))';
592:
593: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SECONDARY_UNPACKED).column_value :=
594: 'SUM(DECODE(moqd.containerized_flag, 1, 0, moqd.secondary_transaction_quantity))';
595:
596: inv_mwb_query_manager.add_from_clause('mtl_onhand_quantities_detail moqd', 'ONHAND');
597: inv_mwb_query_manager.add_where_clause('moqd.lot_number is not null', 'ONHAND');

Line 596: inv_mwb_query_manager.add_from_clause('mtl_onhand_quantities_detail moqd', 'ONHAND');

592:
593: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SECONDARY_UNPACKED).column_value :=
594: 'SUM(DECODE(moqd.containerized_flag, 1, 0, moqd.secondary_transaction_quantity))';
595:
596: inv_mwb_query_manager.add_from_clause('mtl_onhand_quantities_detail moqd', 'ONHAND');
597: inv_mwb_query_manager.add_where_clause('moqd.lot_number is not null', 'ONHAND');
598:
599: inv_mwb_query_manager.add_group_clause('moqd.inventory_item_id', 'ONHAND');
600: inv_mwb_query_manager.add_group_clause('moqd.organization_id', 'ONHAND');

Line 597: inv_mwb_query_manager.add_where_clause('moqd.lot_number is not null', 'ONHAND');

593: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SECONDARY_UNPACKED).column_value :=
594: 'SUM(DECODE(moqd.containerized_flag, 1, 0, moqd.secondary_transaction_quantity))';
595:
596: inv_mwb_query_manager.add_from_clause('mtl_onhand_quantities_detail moqd', 'ONHAND');
597: inv_mwb_query_manager.add_where_clause('moqd.lot_number is not null', 'ONHAND');
598:
599: inv_mwb_query_manager.add_group_clause('moqd.inventory_item_id', 'ONHAND');
600: inv_mwb_query_manager.add_group_clause('moqd.organization_id', 'ONHAND');
601: -- inv_mwb_query_manager.add_group_clause('moqd.transaction_uom_code', 'ONHAND');

Line 599: inv_mwb_query_manager.add_group_clause('moqd.inventory_item_id', 'ONHAND');

595:
596: inv_mwb_query_manager.add_from_clause('mtl_onhand_quantities_detail moqd', 'ONHAND');
597: inv_mwb_query_manager.add_where_clause('moqd.lot_number is not null', 'ONHAND');
598:
599: inv_mwb_query_manager.add_group_clause('moqd.inventory_item_id', 'ONHAND');
600: inv_mwb_query_manager.add_group_clause('moqd.organization_id', 'ONHAND');
601: -- inv_mwb_query_manager.add_group_clause('moqd.transaction_uom_code', 'ONHAND');
602: inv_mwb_query_manager.add_group_clause('moqd.secondary_uom_code', 'ONHAND');
603:

Line 600: inv_mwb_query_manager.add_group_clause('moqd.organization_id', 'ONHAND');

596: inv_mwb_query_manager.add_from_clause('mtl_onhand_quantities_detail moqd', 'ONHAND');
597: inv_mwb_query_manager.add_where_clause('moqd.lot_number is not null', 'ONHAND');
598:
599: inv_mwb_query_manager.add_group_clause('moqd.inventory_item_id', 'ONHAND');
600: inv_mwb_query_manager.add_group_clause('moqd.organization_id', 'ONHAND');
601: -- inv_mwb_query_manager.add_group_clause('moqd.transaction_uom_code', 'ONHAND');
602: inv_mwb_query_manager.add_group_clause('moqd.secondary_uom_code', 'ONHAND');
603:
604: WHEN 'MSN_QUERY' THEN

Line 601: -- inv_mwb_query_manager.add_group_clause('moqd.transaction_uom_code', 'ONHAND');

597: inv_mwb_query_manager.add_where_clause('moqd.lot_number is not null', 'ONHAND');
598:
599: inv_mwb_query_manager.add_group_clause('moqd.inventory_item_id', 'ONHAND');
600: inv_mwb_query_manager.add_group_clause('moqd.organization_id', 'ONHAND');
601: -- inv_mwb_query_manager.add_group_clause('moqd.transaction_uom_code', 'ONHAND');
602: inv_mwb_query_manager.add_group_clause('moqd.secondary_uom_code', 'ONHAND');
603:
604: WHEN 'MSN_QUERY' THEN
605: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ITEM_ID).column_value :=

Line 602: inv_mwb_query_manager.add_group_clause('moqd.secondary_uom_code', 'ONHAND');

598:
599: inv_mwb_query_manager.add_group_clause('moqd.inventory_item_id', 'ONHAND');
600: inv_mwb_query_manager.add_group_clause('moqd.organization_id', 'ONHAND');
601: -- inv_mwb_query_manager.add_group_clause('moqd.transaction_uom_code', 'ONHAND');
602: inv_mwb_query_manager.add_group_clause('moqd.secondary_uom_code', 'ONHAND');
603:
604: WHEN 'MSN_QUERY' THEN
605: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ITEM_ID).column_value :=
606: 'msn.inventory_item_id';

Line 605: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ITEM_ID).column_value :=

601: -- inv_mwb_query_manager.add_group_clause('moqd.transaction_uom_code', 'ONHAND');
602: inv_mwb_query_manager.add_group_clause('moqd.secondary_uom_code', 'ONHAND');
603:
604: WHEN 'MSN_QUERY' THEN
605: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ITEM_ID).column_value :=
606: 'msn.inventory_item_id';
607: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ORG_ID).column_value :=
608: 'msn.current_organization_id';
609: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PRIMARY_UOM_CODE).column_value :=

Line 607: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ORG_ID).column_value :=

603:
604: WHEN 'MSN_QUERY' THEN
605: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ITEM_ID).column_value :=
606: 'msn.inventory_item_id';
607: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ORG_ID).column_value :=
608: 'msn.current_organization_id';
609: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PRIMARY_UOM_CODE).column_value :=
610: '''Ea''';
611: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ONHAND).column_value :=

Line 609: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PRIMARY_UOM_CODE).column_value :=

605: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ITEM_ID).column_value :=
606: 'msn.inventory_item_id';
607: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ORG_ID).column_value :=
608: 'msn.current_organization_id';
609: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PRIMARY_UOM_CODE).column_value :=
610: '''Ea''';
611: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ONHAND).column_value :=
612: 'count(1)';
613: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PACKED).column_value :=

Line 611: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ONHAND).column_value :=

607: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ORG_ID).column_value :=
608: 'msn.current_organization_id';
609: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PRIMARY_UOM_CODE).column_value :=
610: '''Ea''';
611: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ONHAND).column_value :=
612: 'count(1)';
613: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PACKED).column_value :=
614: 'sum(decode(msn.lpn_id,NULL,0, 1))';
615: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.UNPACKED).column_value :=

Line 613: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PACKED).column_value :=

609: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PRIMARY_UOM_CODE).column_value :=
610: '''Ea''';
611: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ONHAND).column_value :=
612: 'count(1)';
613: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PACKED).column_value :=
614: 'sum(decode(msn.lpn_id,NULL,0, 1))';
615: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.UNPACKED).column_value :=
616: 'sum(decode(msn.lpn_id,NULL,1, 0))';
617: inv_mwb_query_manager.add_from_clause('mtl_serial_numbers msn' , 'ONHAND');

Line 615: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.UNPACKED).column_value :=

611: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ONHAND).column_value :=
612: 'count(1)';
613: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PACKED).column_value :=
614: 'sum(decode(msn.lpn_id,NULL,0, 1))';
615: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.UNPACKED).column_value :=
616: 'sum(decode(msn.lpn_id,NULL,1, 0))';
617: inv_mwb_query_manager.add_from_clause('mtl_serial_numbers msn' , 'ONHAND');
618: inv_mwb_query_manager.add_where_clause('msn.lot_number is not null' , 'ONHAND');
619: inv_mwb_query_manager.add_group_clause('msn.inventory_item_id' , 'ONHAND');

Line 617: inv_mwb_query_manager.add_from_clause('mtl_serial_numbers msn' , 'ONHAND');

613: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PACKED).column_value :=
614: 'sum(decode(msn.lpn_id,NULL,0, 1))';
615: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.UNPACKED).column_value :=
616: 'sum(decode(msn.lpn_id,NULL,1, 0))';
617: inv_mwb_query_manager.add_from_clause('mtl_serial_numbers msn' , 'ONHAND');
618: inv_mwb_query_manager.add_where_clause('msn.lot_number is not null' , 'ONHAND');
619: inv_mwb_query_manager.add_group_clause('msn.inventory_item_id' , 'ONHAND');
620: inv_mwb_query_manager.add_group_clause('msn.current_organization_id', 'ONHAND');
621: inv_mwb_query_manager.add_group_clause('''Ea''', 'ONHAND');

Line 618: inv_mwb_query_manager.add_where_clause('msn.lot_number is not null' , 'ONHAND');

614: 'sum(decode(msn.lpn_id,NULL,0, 1))';
615: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.UNPACKED).column_value :=
616: 'sum(decode(msn.lpn_id,NULL,1, 0))';
617: inv_mwb_query_manager.add_from_clause('mtl_serial_numbers msn' , 'ONHAND');
618: inv_mwb_query_manager.add_where_clause('msn.lot_number is not null' , 'ONHAND');
619: inv_mwb_query_manager.add_group_clause('msn.inventory_item_id' , 'ONHAND');
620: inv_mwb_query_manager.add_group_clause('msn.current_organization_id', 'ONHAND');
621: inv_mwb_query_manager.add_group_clause('''Ea''', 'ONHAND');
622: END CASE; -- p_flag

Line 619: inv_mwb_query_manager.add_group_clause('msn.inventory_item_id' , 'ONHAND');

615: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.UNPACKED).column_value :=
616: 'sum(decode(msn.lpn_id,NULL,1, 0))';
617: inv_mwb_query_manager.add_from_clause('mtl_serial_numbers msn' , 'ONHAND');
618: inv_mwb_query_manager.add_where_clause('msn.lot_number is not null' , 'ONHAND');
619: inv_mwb_query_manager.add_group_clause('msn.inventory_item_id' , 'ONHAND');
620: inv_mwb_query_manager.add_group_clause('msn.current_organization_id', 'ONHAND');
621: inv_mwb_query_manager.add_group_clause('''Ea''', 'ONHAND');
622: END CASE; -- p_flag
623:

Line 620: inv_mwb_query_manager.add_group_clause('msn.current_organization_id', 'ONHAND');

616: 'sum(decode(msn.lpn_id,NULL,1, 0))';
617: inv_mwb_query_manager.add_from_clause('mtl_serial_numbers msn' , 'ONHAND');
618: inv_mwb_query_manager.add_where_clause('msn.lot_number is not null' , 'ONHAND');
619: inv_mwb_query_manager.add_group_clause('msn.inventory_item_id' , 'ONHAND');
620: inv_mwb_query_manager.add_group_clause('msn.current_organization_id', 'ONHAND');
621: inv_mwb_query_manager.add_group_clause('''Ea''', 'ONHAND');
622: END CASE; -- p_flag
623:
624: END make_common_queries;

Line 621: inv_mwb_query_manager.add_group_clause('''Ea''', 'ONHAND');

617: inv_mwb_query_manager.add_from_clause('mtl_serial_numbers msn' , 'ONHAND');
618: inv_mwb_query_manager.add_where_clause('msn.lot_number is not null' , 'ONHAND');
619: inv_mwb_query_manager.add_group_clause('msn.inventory_item_id' , 'ONHAND');
620: inv_mwb_query_manager.add_group_clause('msn.current_organization_id', 'ONHAND');
621: inv_mwb_query_manager.add_group_clause('''Ea''', 'ONHAND');
622: END CASE; -- p_flag
623:
624: END make_common_queries;
625: --