eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_MWB_LOT_TREE dependencies on INV_MWB_QUERY_MANAGER

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

34: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL -- Bug 6429880
35: OR inv_mwb_globals.g_unit_number IS NOT NULL -- Bug 9365452
36: THEN
37: make_common_queries('MSN_QUERY');
38: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
39: ELSE
40: make_common_queries('MOQD');
41: inv_mwb_query_manager.add_qf_where_onhand('ONHAND');
42: END IF;

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

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

Line 43: inv_mwb_query_manager.execute_query;

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

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

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

Line 81: inv_mwb_query_manager.add_where_clause(

77: THEN
78: make_common_queries('MSN_QUERY');
79: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
80: 'msn.lot_number';
81: inv_mwb_query_manager.add_where_clause(
82: 'msn.current_organization_id = :onh_tree_organization_id' ,
83: 'ONHAND'
84: );
85: inv_mwb_query_manager.add_group_clause(

Line 85: inv_mwb_query_manager.add_group_clause(

81: inv_mwb_query_manager.add_where_clause(
82: 'msn.current_organization_id = :onh_tree_organization_id' ,
83: 'ONHAND'
84: );
85: inv_mwb_query_manager.add_group_clause(
86: 'msn.lot_number' ,
87: 'ONHAND'
88: );
89: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');

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

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

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

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

Line 94: inv_mwb_query_manager.add_where_clause(

90: ELSE
91: make_common_queries('MOQD');
92: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
93: 'moqd.lot_number';
94: inv_mwb_query_manager.add_where_clause(
95: 'moqd.organization_id = :onh_tree_organization_id' ,
96: 'ONHAND'
97: );
98: inv_mwb_query_manager.add_group_clause(

Line 98: inv_mwb_query_manager.add_group_clause(

94: inv_mwb_query_manager.add_where_clause(
95: 'moqd.organization_id = :onh_tree_organization_id' ,
96: 'ONHAND'
97: );
98: inv_mwb_query_manager.add_group_clause(
99: 'moqd.lot_number' ,
100: 'ONHAND'
101: );
102: inv_mwb_query_manager.add_qf_where_onhand('ONHAND');

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

98: inv_mwb_query_manager.add_group_clause(
99: 'moqd.lot_number' ,
100: 'ONHAND'
101: );
102: inv_mwb_query_manager.add_qf_where_onhand('ONHAND');
103: END IF; -- serial
104: inv_mwb_query_manager.add_bind_variable(
105: 'onh_tree_organization_id',
106: inv_mwb_globals.g_tree_organization_id

Line 104: inv_mwb_query_manager.add_bind_variable(

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

Line 108: inv_mwb_query_manager.execute_query;

104: inv_mwb_query_manager.add_bind_variable(
105: 'onh_tree_organization_id',
106: inv_mwb_globals.g_tree_organization_id
107: );
108: inv_mwb_query_manager.execute_query;
109:
110: END IF; -- g_tree_event
111:
112: EXCEPTION

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

140: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL -- Bug 6429880
141: OR inv_mwb_globals.g_unit_number IS NOT NULL -- Bug 9365452
142: THEN
143: make_common_queries('MSN_QUERY');
144: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
145: 'msn.lot_number';
146: inv_mwb_query_manager.add_where_clause(
147: 'msn.current_organization_id = :onh_tree_organization_id' ,
148: 'ONHAND'

Line 146: inv_mwb_query_manager.add_where_clause(

142: THEN
143: make_common_queries('MSN_QUERY');
144: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
145: 'msn.lot_number';
146: inv_mwb_query_manager.add_where_clause(
147: 'msn.current_organization_id = :onh_tree_organization_id' ,
148: 'ONHAND'
149: );
150: inv_mwb_query_manager.add_where_clause(

Line 150: inv_mwb_query_manager.add_where_clause(

146: inv_mwb_query_manager.add_where_clause(
147: 'msn.current_organization_id = :onh_tree_organization_id' ,
148: 'ONHAND'
149: );
150: inv_mwb_query_manager.add_where_clause(
151: 'msn.lot_number = :onh_tree_lot_number' ,
152: 'ONHAND'
153: );
154: inv_mwb_query_manager.add_group_clause(

Line 154: inv_mwb_query_manager.add_group_clause(

150: inv_mwb_query_manager.add_where_clause(
151: 'msn.lot_number = :onh_tree_lot_number' ,
152: 'ONHAND'
153: );
154: inv_mwb_query_manager.add_group_clause(
155: 'msn.lot_number' ,
156: 'ONHAND'
157: );
158: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');

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

154: inv_mwb_query_manager.add_group_clause(
155: 'msn.lot_number' ,
156: 'ONHAND'
157: );
158: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
159: ELSE
160: make_common_queries('MOQD');
161: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
162: 'moqd.lot_number';

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

157: );
158: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
159: ELSE
160: make_common_queries('MOQD');
161: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
162: 'moqd.lot_number';
163: inv_mwb_query_manager.add_where_clause(
164: 'moqd.organization_id = :onh_tree_organization_id' ,
165: 'ONHAND'

Line 163: inv_mwb_query_manager.add_where_clause(

159: ELSE
160: make_common_queries('MOQD');
161: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
162: 'moqd.lot_number';
163: inv_mwb_query_manager.add_where_clause(
164: 'moqd.organization_id = :onh_tree_organization_id' ,
165: 'ONHAND'
166: );
167: inv_mwb_query_manager.add_where_clause(

Line 167: inv_mwb_query_manager.add_where_clause(

163: inv_mwb_query_manager.add_where_clause(
164: 'moqd.organization_id = :onh_tree_organization_id' ,
165: 'ONHAND'
166: );
167: inv_mwb_query_manager.add_where_clause(
168: 'moqd.lot_number = :onh_tree_lot_number' ,
169: 'ONHAND'
170: );
171: inv_mwb_query_manager.add_group_clause(

Line 171: inv_mwb_query_manager.add_group_clause(

167: inv_mwb_query_manager.add_where_clause(
168: 'moqd.lot_number = :onh_tree_lot_number' ,
169: 'ONHAND'
170: );
171: inv_mwb_query_manager.add_group_clause(
172: 'moqd.lot_number' ,
173: 'ONHAND'
174: );
175:

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

172: 'moqd.lot_number' ,
173: 'ONHAND'
174: );
175:
176: inv_mwb_query_manager.add_qf_where_onhand('ONHAND');
177: END IF; -- serial
178: inv_mwb_query_manager.add_bind_variable(
179: 'onh_tree_organization_id',
180: inv_mwb_globals.g_tree_organization_id

Line 178: inv_mwb_query_manager.add_bind_variable(

174: );
175:
176: inv_mwb_query_manager.add_qf_where_onhand('ONHAND');
177: END IF; -- serial
178: inv_mwb_query_manager.add_bind_variable(
179: 'onh_tree_organization_id',
180: inv_mwb_globals.g_tree_organization_id
181: );
182: inv_mwb_query_manager.add_bind_variable(

Line 182: inv_mwb_query_manager.add_bind_variable(

178: inv_mwb_query_manager.add_bind_variable(
179: 'onh_tree_organization_id',
180: inv_mwb_globals.g_tree_organization_id
181: );
182: inv_mwb_query_manager.add_bind_variable(
183: 'onh_tree_lot_number',
184: inv_mwb_globals.g_tree_lot_number
185: );
186: inv_mwb_query_manager.execute_query;

Line 186: inv_mwb_query_manager.execute_query;

182: inv_mwb_query_manager.add_bind_variable(
183: 'onh_tree_lot_number',
184: inv_mwb_globals.g_tree_lot_number
185: );
186: inv_mwb_query_manager.execute_query;
187:
188: END IF;
189:
190: EXCEPTION

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

231: AND inventory_item_id = inv_mwb_globals.g_tree_item_id;
232:
233: IF NVL(l_rev_control, 1) = 1 AND l_serial_control IN (2,5) THEN
234: make_common_queries('MSN');
235: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
236: 'msn.lot_number';
237: inv_mwb_query_manager.add_where_clause(
238: 'msn.current_organization_id = :onh_tree_organization_id' ,
239: 'ONHAND'

Line 237: inv_mwb_query_manager.add_where_clause(

233: IF NVL(l_rev_control, 1) = 1 AND l_serial_control IN (2,5) THEN
234: make_common_queries('MSN');
235: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
236: 'msn.lot_number';
237: inv_mwb_query_manager.add_where_clause(
238: 'msn.current_organization_id = :onh_tree_organization_id' ,
239: 'ONHAND'
240: );
241: inv_mwb_query_manager.add_where_clause(

Line 241: inv_mwb_query_manager.add_where_clause(

237: inv_mwb_query_manager.add_where_clause(
238: 'msn.current_organization_id = :onh_tree_organization_id' ,
239: 'ONHAND'
240: );
241: inv_mwb_query_manager.add_where_clause(
242: 'msn.lot_number = :onh_tree_lot_number' ,
243: 'ONHAND'
244: );
245: inv_mwb_query_manager.add_where_clause(

Line 245: inv_mwb_query_manager.add_where_clause(

241: inv_mwb_query_manager.add_where_clause(
242: 'msn.lot_number = :onh_tree_lot_number' ,
243: 'ONHAND'
244: );
245: inv_mwb_query_manager.add_where_clause(
246: 'msn.inventory_item_id = :onh_tree_inventory_item_id' ,
247: 'ONHAND'
248: );
249: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');

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

245: inv_mwb_query_manager.add_where_clause(
246: 'msn.inventory_item_id = :onh_tree_inventory_item_id' ,
247: 'ONHAND'
248: );
249: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
250:
251: ELSE -- item is not serial controlled
252:
253: IF inv_mwb_globals.g_serial_from IS NOT NULL OR

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

256: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL -- Bug 6429880
257: OR inv_mwb_globals.g_unit_number IS NOT NULL -- Bug 9365452
258: THEN
259: make_common_queries('MSN_QUERY');
260: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
261: 'msn.lot_number';
262: IF l_rev_control = 2 THEN
263: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.revision).column_value :=
264: 'msn.revision';

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

259: make_common_queries('MSN_QUERY');
260: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
261: 'msn.lot_number';
262: IF l_rev_control = 2 THEN
263: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.revision).column_value :=
264: 'msn.revision';
265: inv_mwb_query_manager.add_group_clause(
266: 'msn.revision' ,
267: 'ONHAND'

Line 265: inv_mwb_query_manager.add_group_clause(

261: 'msn.lot_number';
262: IF l_rev_control = 2 THEN
263: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.revision).column_value :=
264: 'msn.revision';
265: inv_mwb_query_manager.add_group_clause(
266: 'msn.revision' ,
267: 'ONHAND'
268: );
269: END IF;

Line 270: inv_mwb_query_manager.add_where_clause(

266: 'msn.revision' ,
267: 'ONHAND'
268: );
269: END IF;
270: inv_mwb_query_manager.add_where_clause(
271: 'msn.current_organization_id = :onh_tree_organization_id' ,
272: 'ONHAND'
273: );
274: inv_mwb_query_manager.add_where_clause(

Line 274: inv_mwb_query_manager.add_where_clause(

270: inv_mwb_query_manager.add_where_clause(
271: 'msn.current_organization_id = :onh_tree_organization_id' ,
272: 'ONHAND'
273: );
274: inv_mwb_query_manager.add_where_clause(
275: 'msn.lot_number = :onh_tree_lot_number' ,
276: 'ONHAND'
277: );
278: inv_mwb_query_manager.add_where_clause(

Line 278: inv_mwb_query_manager.add_where_clause(

274: inv_mwb_query_manager.add_where_clause(
275: 'msn.lot_number = :onh_tree_lot_number' ,
276: 'ONHAND'
277: );
278: inv_mwb_query_manager.add_where_clause(
279: 'msn.inventory_item_id = :onh_tree_inventory_item_id' ,
280: 'ONHAND'
281: );
282: inv_mwb_query_manager.add_group_clause(

Line 282: inv_mwb_query_manager.add_group_clause(

278: inv_mwb_query_manager.add_where_clause(
279: 'msn.inventory_item_id = :onh_tree_inventory_item_id' ,
280: 'ONHAND'
281: );
282: inv_mwb_query_manager.add_group_clause(
283: 'msn.lot_number' ,
284: 'ONHAND'
285: );
286: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');

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

282: inv_mwb_query_manager.add_group_clause(
283: 'msn.lot_number' ,
284: 'ONHAND'
285: );
286: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
287: ELSE
288: make_common_queries('MOQD');
289: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
290: 'moqd.lot_number';

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

285: );
286: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
287: ELSE
288: make_common_queries('MOQD');
289: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
290: 'moqd.lot_number';
291: IF l_rev_control = 2 THEN
292: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.revision).column_value :=
293: 'moqd.revision';

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

288: make_common_queries('MOQD');
289: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
290: 'moqd.lot_number';
291: IF l_rev_control = 2 THEN
292: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.revision).column_value :=
293: 'moqd.revision';
294: inv_mwb_query_manager.add_group_clause(
295: 'moqd.revision' ,
296: 'ONHAND'

Line 294: inv_mwb_query_manager.add_group_clause(

290: 'moqd.lot_number';
291: IF l_rev_control = 2 THEN
292: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.revision).column_value :=
293: 'moqd.revision';
294: inv_mwb_query_manager.add_group_clause(
295: 'moqd.revision' ,
296: 'ONHAND'
297: );
298: END IF;

Line 299: inv_mwb_query_manager.add_where_clause(

295: 'moqd.revision' ,
296: 'ONHAND'
297: );
298: END IF;
299: inv_mwb_query_manager.add_where_clause(
300: 'moqd.organization_id = :onh_tree_organization_id' ,
301: 'ONHAND'
302: );
303: inv_mwb_query_manager.add_where_clause(

Line 303: inv_mwb_query_manager.add_where_clause(

299: inv_mwb_query_manager.add_where_clause(
300: 'moqd.organization_id = :onh_tree_organization_id' ,
301: 'ONHAND'
302: );
303: inv_mwb_query_manager.add_where_clause(
304: 'moqd.lot_number = :onh_tree_lot_number' ,
305: 'ONHAND'
306: );
307: inv_mwb_query_manager.add_where_clause(

Line 307: inv_mwb_query_manager.add_where_clause(

303: inv_mwb_query_manager.add_where_clause(
304: 'moqd.lot_number = :onh_tree_lot_number' ,
305: 'ONHAND'
306: );
307: inv_mwb_query_manager.add_where_clause(
308: 'moqd.inventory_item_id = :onh_tree_inventory_item_id' ,
309: 'ONHAND'
310: );
311: inv_mwb_query_manager.add_group_clause(

Line 311: inv_mwb_query_manager.add_group_clause(

307: inv_mwb_query_manager.add_where_clause(
308: 'moqd.inventory_item_id = :onh_tree_inventory_item_id' ,
309: 'ONHAND'
310: );
311: inv_mwb_query_manager.add_group_clause(
312: 'moqd.lot_number' ,
313: 'ONHAND'
314: );
315:

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

312: 'moqd.lot_number' ,
313: 'ONHAND'
314: );
315:
316: inv_mwb_query_manager.add_qf_where_onhand('ONHAND');
317: END IF; -- serial
318:
319: END IF; -- item is not serial controlled
320: inv_mwb_query_manager.add_bind_variable(

Line 320: inv_mwb_query_manager.add_bind_variable(

316: inv_mwb_query_manager.add_qf_where_onhand('ONHAND');
317: END IF; -- serial
318:
319: END IF; -- item is not serial controlled
320: inv_mwb_query_manager.add_bind_variable(
321: 'onh_tree_organization_id',
322: inv_mwb_globals.g_tree_organization_id
323: );
324: inv_mwb_query_manager.add_bind_variable(

Line 324: inv_mwb_query_manager.add_bind_variable(

320: inv_mwb_query_manager.add_bind_variable(
321: 'onh_tree_organization_id',
322: inv_mwb_globals.g_tree_organization_id
323: );
324: inv_mwb_query_manager.add_bind_variable(
325: 'onh_tree_lot_number',
326: inv_mwb_globals.g_tree_lot_number
327: );
328: inv_mwb_query_manager.add_bind_variable(

Line 328: inv_mwb_query_manager.add_bind_variable(

324: inv_mwb_query_manager.add_bind_variable(
325: 'onh_tree_lot_number',
326: inv_mwb_globals.g_tree_lot_number
327: );
328: inv_mwb_query_manager.add_bind_variable(
329: 'onh_tree_inventory_item_id',
330: inv_mwb_globals.g_tree_item_id
331: );
332: inv_mwb_query_manager.execute_query;

Line 332: inv_mwb_query_manager.execute_query;

328: inv_mwb_query_manager.add_bind_variable(
329: 'onh_tree_inventory_item_id',
330: inv_mwb_globals.g_tree_item_id
331: );
332: inv_mwb_query_manager.execute_query;
333:
334: END IF; -- g_tree_Event
335:
336: EXCEPTION

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

367: AND inventory_item_id = inv_mwb_globals.g_tree_item_id;
368:
369: IF l_serial_control in ( 2,5 ) THEN
370: make_common_queries('MSN');
371: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
372: 'msn.lot_number';
373: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SERIAL).column_value :=
374: 'msn.serial_number';
375: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.revision).column_value :=

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

369: IF l_serial_control in ( 2,5 ) THEN
370: make_common_queries('MSN');
371: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
372: 'msn.lot_number';
373: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SERIAL).column_value :=
374: 'msn.serial_number';
375: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.revision).column_value :=
376: 'msn.revision';
377: inv_mwb_query_manager.add_where_clause(

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

371: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
372: 'msn.lot_number';
373: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SERIAL).column_value :=
374: 'msn.serial_number';
375: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.revision).column_value :=
376: 'msn.revision';
377: inv_mwb_query_manager.add_where_clause(
378: 'msn.revision = :onh_tree_revision' ,
379: 'ONHAND'

Line 377: inv_mwb_query_manager.add_where_clause(

373: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SERIAL).column_value :=
374: 'msn.serial_number';
375: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.revision).column_value :=
376: 'msn.revision';
377: inv_mwb_query_manager.add_where_clause(
378: 'msn.revision = :onh_tree_revision' ,
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.revision = :onh_tree_revision' ,
379: 'ONHAND'
380: );
381: inv_mwb_query_manager.add_where_clause(
382: 'msn.current_organization_id = :onh_tree_organization_id' ,
383: 'ONHAND'
384: );
385: inv_mwb_query_manager.add_where_clause(

Line 385: inv_mwb_query_manager.add_where_clause(

381: inv_mwb_query_manager.add_where_clause(
382: 'msn.current_organization_id = :onh_tree_organization_id' ,
383: 'ONHAND'
384: );
385: inv_mwb_query_manager.add_where_clause(
386: 'msn.lot_number = :onh_tree_lot_number' ,
387: 'ONHAND'
388: );
389: inv_mwb_query_manager.add_where_clause(

Line 389: inv_mwb_query_manager.add_where_clause(

385: inv_mwb_query_manager.add_where_clause(
386: 'msn.lot_number = :onh_tree_lot_number' ,
387: 'ONHAND'
388: );
389: inv_mwb_query_manager.add_where_clause(
390: 'msn.inventory_item_id = :onh_tree_inventory_item_id' ,
391: 'ONHAND'
392: );
393: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');

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

389: inv_mwb_query_manager.add_where_clause(
390: 'msn.inventory_item_id = :onh_tree_inventory_item_id' ,
391: 'ONHAND'
392: );
393: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
394:
395: ELSE -- not serial item
396: make_common_queries('MOQD');
397: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=

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

393: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
394:
395: ELSE -- not serial item
396: make_common_queries('MOQD');
397: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
398: 'moqd.lot_number';
399: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.revision).column_value :=
400: 'moqd.revision';
401: inv_mwb_query_manager.add_where_clause(

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

395: ELSE -- not serial item
396: make_common_queries('MOQD');
397: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
398: 'moqd.lot_number';
399: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.revision).column_value :=
400: 'moqd.revision';
401: inv_mwb_query_manager.add_where_clause(
402: 'moqd.revision = :onh_tree_revision' ,
403: 'ONHAND'

Line 401: inv_mwb_query_manager.add_where_clause(

397: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
398: 'moqd.lot_number';
399: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.revision).column_value :=
400: 'moqd.revision';
401: inv_mwb_query_manager.add_where_clause(
402: 'moqd.revision = :onh_tree_revision' ,
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.revision = :onh_tree_revision' ,
403: 'ONHAND'
404: );
405: inv_mwb_query_manager.add_where_clause(
406: 'moqd.organization_id = :onh_tree_organization_id' ,
407: 'ONHAND'
408: );
409: inv_mwb_query_manager.add_where_clause(

Line 409: inv_mwb_query_manager.add_where_clause(

405: inv_mwb_query_manager.add_where_clause(
406: 'moqd.organization_id = :onh_tree_organization_id' ,
407: 'ONHAND'
408: );
409: inv_mwb_query_manager.add_where_clause(
410: 'moqd.lot_number = :onh_tree_lot_number' ,
411: 'ONHAND'
412: );
413: inv_mwb_query_manager.add_where_clause(

Line 413: inv_mwb_query_manager.add_where_clause(

409: inv_mwb_query_manager.add_where_clause(
410: 'moqd.lot_number = :onh_tree_lot_number' ,
411: 'ONHAND'
412: );
413: inv_mwb_query_manager.add_where_clause(
414: 'moqd.inventory_item_id = :onh_tree_inventory_item_id' ,
415: 'ONHAND'
416: );
417: inv_mwb_query_manager.add_group_clause(

Line 417: inv_mwb_query_manager.add_group_clause(

413: inv_mwb_query_manager.add_where_clause(
414: 'moqd.inventory_item_id = :onh_tree_inventory_item_id' ,
415: 'ONHAND'
416: );
417: inv_mwb_query_manager.add_group_clause(
418: 'moqd.lot_number',
419: 'ONHAND'
420: );
421: inv_mwb_query_manager.add_group_clause(

Line 421: inv_mwb_query_manager.add_group_clause(

417: inv_mwb_query_manager.add_group_clause(
418: 'moqd.lot_number',
419: 'ONHAND'
420: );
421: inv_mwb_query_manager.add_group_clause(
422: 'moqd.revision',
423: 'ONHAND'
424: );
425:

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

422: 'moqd.revision',
423: 'ONHAND'
424: );
425:
426: inv_mwb_query_manager.add_qf_where_onhand('ONHAND');
427: END IF;
428: inv_mwb_query_manager.add_bind_variable(
429: 'onh_tree_organization_id',
430: inv_mwb_globals.g_tree_organization_id

Line 428: inv_mwb_query_manager.add_bind_variable(

424: );
425:
426: inv_mwb_query_manager.add_qf_where_onhand('ONHAND');
427: END IF;
428: inv_mwb_query_manager.add_bind_variable(
429: 'onh_tree_organization_id',
430: inv_mwb_globals.g_tree_organization_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_organization_id',
430: inv_mwb_globals.g_tree_organization_id
431: );
432: inv_mwb_query_manager.add_bind_variable(
433: 'onh_tree_lot_number',
434: inv_mwb_globals.g_tree_lot_number
435: );
436: inv_mwb_query_manager.add_bind_variable(

Line 436: inv_mwb_query_manager.add_bind_variable(

432: inv_mwb_query_manager.add_bind_variable(
433: 'onh_tree_lot_number',
434: inv_mwb_globals.g_tree_lot_number
435: );
436: inv_mwb_query_manager.add_bind_variable(
437: 'onh_tree_inventory_item_id',
438: inv_mwb_globals.g_tree_item_id
439: );
440: inv_mwb_query_manager.add_bind_variable(

Line 440: inv_mwb_query_manager.add_bind_variable(

436: inv_mwb_query_manager.add_bind_variable(
437: 'onh_tree_inventory_item_id',
438: inv_mwb_globals.g_tree_item_id
439: );
440: inv_mwb_query_manager.add_bind_variable(
441: 'onh_tree_revision',
442: inv_mwb_globals.g_tree_rev
443: );
444: inv_mwb_query_manager.execute_query;

Line 444: inv_mwb_query_manager.execute_query;

440: inv_mwb_query_manager.add_bind_variable(
441: 'onh_tree_revision',
442: inv_mwb_globals.g_tree_rev
443: );
444: inv_mwb_query_manager.execute_query;
445:
446: END IF; -- g_tree
447:
448: EXCEPTION

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

471: WHERE organization_id = inv_mwb_globals.g_tree_organization_id
472: AND inventory_item_id = inv_mwb_globals.g_tree_item_id;
473:
474: make_common_queries('MSN');
475: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
476: 'msn.lot_number';
477: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SERIAL).column_value :=
478: 'msn.serial_number';
479: IF l_rev_control = 2 THEN

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

473:
474: make_common_queries('MSN');
475: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
476: 'msn.lot_number';
477: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SERIAL).column_value :=
478: 'msn.serial_number';
479: IF l_rev_control = 2 THEN
480: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.revision).column_value :=
481: 'msn.revision';

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

476: 'msn.lot_number';
477: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SERIAL).column_value :=
478: 'msn.serial_number';
479: IF l_rev_control = 2 THEN
480: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.revision).column_value :=
481: 'msn.revision';
482: inv_mwb_query_manager.add_where_clause(
483: 'msn.revision = :onh_tree_revision' ,
484: 'ONHAND'

Line 482: inv_mwb_query_manager.add_where_clause(

478: 'msn.serial_number';
479: IF l_rev_control = 2 THEN
480: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.revision).column_value :=
481: 'msn.revision';
482: inv_mwb_query_manager.add_where_clause(
483: 'msn.revision = :onh_tree_revision' ,
484: 'ONHAND'
485: );
486: inv_mwb_query_manager.add_bind_variable(

Line 486: inv_mwb_query_manager.add_bind_variable(

482: inv_mwb_query_manager.add_where_clause(
483: 'msn.revision = :onh_tree_revision' ,
484: 'ONHAND'
485: );
486: inv_mwb_query_manager.add_bind_variable(
487: 'onh_tree_revision',
488: inv_mwb_globals.g_tree_rev
489: );
490: END IF;

Line 491: inv_mwb_query_manager.add_where_clause(

487: 'onh_tree_revision',
488: inv_mwb_globals.g_tree_rev
489: );
490: END IF;
491: inv_mwb_query_manager.add_where_clause(
492: 'msn.current_organization_id = :onh_tree_organization_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.current_organization_id = :onh_tree_organization_id' ,
493: 'ONHAND'
494: );
495: inv_mwb_query_manager.add_where_clause(
496: 'msn.lot_number = :onh_tree_lot_number' ,
497: 'ONHAND'
498: );
499: inv_mwb_query_manager.add_where_clause(

Line 499: inv_mwb_query_manager.add_where_clause(

495: inv_mwb_query_manager.add_where_clause(
496: 'msn.lot_number = :onh_tree_lot_number' ,
497: 'ONHAND'
498: );
499: inv_mwb_query_manager.add_where_clause(
500: 'msn.inventory_item_id = :onh_tree_inventory_item_id' ,
501: 'ONHAND'
502: );
503: inv_mwb_query_manager.add_where_clause(

Line 503: inv_mwb_query_manager.add_where_clause(

499: inv_mwb_query_manager.add_where_clause(
500: 'msn.inventory_item_id = :onh_tree_inventory_item_id' ,
501: 'ONHAND'
502: );
503: inv_mwb_query_manager.add_where_clause(
504: 'msn.serial_number = :onh_tree_serial_number' ,
505: 'ONHAND'
506: );
507: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');

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

503: inv_mwb_query_manager.add_where_clause(
504: 'msn.serial_number = :onh_tree_serial_number' ,
505: 'ONHAND'
506: );
507: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
508: inv_mwb_query_manager.add_bind_variable(
509: 'onh_tree_organization_id',
510: inv_mwb_globals.g_tree_organization_id
511: );

Line 508: inv_mwb_query_manager.add_bind_variable(

504: 'msn.serial_number = :onh_tree_serial_number' ,
505: 'ONHAND'
506: );
507: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
508: inv_mwb_query_manager.add_bind_variable(
509: 'onh_tree_organization_id',
510: inv_mwb_globals.g_tree_organization_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_organization_id',
510: inv_mwb_globals.g_tree_organization_id
511: );
512: inv_mwb_query_manager.add_bind_variable(
513: 'onh_tree_lot_number',
514: inv_mwb_globals.g_tree_lot_number
515: );
516: inv_mwb_query_manager.add_bind_variable(

Line 516: inv_mwb_query_manager.add_bind_variable(

512: inv_mwb_query_manager.add_bind_variable(
513: 'onh_tree_lot_number',
514: inv_mwb_globals.g_tree_lot_number
515: );
516: inv_mwb_query_manager.add_bind_variable(
517: 'onh_tree_inventory_item_id',
518: inv_mwb_globals.g_tree_item_id
519: );
520: inv_mwb_query_manager.add_bind_variable(

Line 520: inv_mwb_query_manager.add_bind_variable(

516: inv_mwb_query_manager.add_bind_variable(
517: 'onh_tree_inventory_item_id',
518: inv_mwb_globals.g_tree_item_id
519: );
520: inv_mwb_query_manager.add_bind_variable(
521: 'onh_tree_serial_number',
522: inv_mwb_globals.g_tree_serial_number
523: );
524: inv_mwb_query_manager.execute_query;

Line 524: inv_mwb_query_manager.execute_query;

520: inv_mwb_query_manager.add_bind_variable(
521: 'onh_tree_serial_number',
522: inv_mwb_globals.g_tree_serial_number
523: );
524: inv_mwb_query_manager.execute_query;
525:
526: END IF; -- g_tree
527:
528: EXCEPTION

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

535: BEGIN
536:
537: CASE p_flag
538: WHEN 'MSN' THEN
539: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ITEM_ID).column_value :=
540: 'msn.inventory_item_id';
541:
542: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ORG_ID).column_value :=
543: 'msn.current_organization_id';

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

538: WHEN 'MSN' THEN
539: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ITEM_ID).column_value :=
540: 'msn.inventory_item_id';
541:
542: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ORG_ID).column_value :=
543: 'msn.current_organization_id';
544:
545: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PRIMARY_UOM_CODE).column_value :=
546: '''Ea''';

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

541:
542: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ORG_ID).column_value :=
543: 'msn.current_organization_id';
544:
545: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PRIMARY_UOM_CODE).column_value :=
546: '''Ea''';
547:
548: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ONHAND).column_value := 1;
549:

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

544:
545: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PRIMARY_UOM_CODE).column_value :=
546: '''Ea''';
547:
548: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ONHAND).column_value := 1;
549:
550: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PACKED).column_value :=
551: 'DECODE(msn.lpn_id, NULL, 0,1)';
552:

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

546: '''Ea''';
547:
548: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ONHAND).column_value := 1;
549:
550: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PACKED).column_value :=
551: 'DECODE(msn.lpn_id, NULL, 0,1)';
552:
553: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.UNPACKED).column_value :=
554: 'DECODE(msn.lpn_id, NULL, 1,0)';

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

549:
550: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PACKED).column_value :=
551: 'DECODE(msn.lpn_id, NULL, 0,1)';
552:
553: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.UNPACKED).column_value :=
554: 'DECODE(msn.lpn_id, NULL, 1,0)';
555:
556: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SECONDARY_UOM_CODE).column_value :=
557: 'NULL';

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

552:
553: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.UNPACKED).column_value :=
554: 'DECODE(msn.lpn_id, NULL, 1,0)';
555:
556: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SECONDARY_UOM_CODE).column_value :=
557: 'NULL';
558:
559: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SECONDARY_PACKED).column_value :=
560: 'NULL';

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

555:
556: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SECONDARY_UOM_CODE).column_value :=
557: 'NULL';
558:
559: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SECONDARY_PACKED).column_value :=
560: 'NULL';
561:
562: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SECONDARY_UNPACKED).column_value :=
563: 'NULL';

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

558:
559: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SECONDARY_PACKED).column_value :=
560: 'NULL';
561:
562: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SECONDARY_UNPACKED).column_value :=
563: 'NULL';
564:
565: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SERIAL).column_value :=
566: 'msn.serial_number';

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

561:
562: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SECONDARY_UNPACKED).column_value :=
563: 'NULL';
564:
565: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SERIAL).column_value :=
566: 'msn.serial_number';
567:
568: inv_mwb_query_manager.add_from_clause('mtl_serial_numbers msn', 'ONHAND');
569:

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

564:
565: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SERIAL).column_value :=
566: 'msn.serial_number';
567:
568: inv_mwb_query_manager.add_from_clause('mtl_serial_numbers msn', 'ONHAND');
569:
570: inv_mwb_query_manager.add_where_clause('msn.current_status = 3', 'ONHAND');
571:
572: WHEN 'MOQD' THEN

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

566: 'msn.serial_number';
567:
568: inv_mwb_query_manager.add_from_clause('mtl_serial_numbers msn', 'ONHAND');
569:
570: inv_mwb_query_manager.add_where_clause('msn.current_status = 3', 'ONHAND');
571:
572: WHEN 'MOQD' THEN
573:
574: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ITEM_ID).column_value :=

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

570: inv_mwb_query_manager.add_where_clause('msn.current_status = 3', 'ONHAND');
571:
572: WHEN 'MOQD' THEN
573:
574: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ITEM_ID).column_value :=
575: 'moqd.inventory_item_id';
576:
577: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ORG_ID).column_value :=
578: 'moqd.organization_id';

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

573:
574: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ITEM_ID).column_value :=
575: 'moqd.inventory_item_id';
576:
577: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ORG_ID).column_value :=
578: 'moqd.organization_id';
579:
580: -- inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PRIMARY_UOM_CODE).column_value :=
581: -- 'moqd.transaction_uom_code';

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

576:
577: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ORG_ID).column_value :=
578: 'moqd.organization_id';
579:
580: -- inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PRIMARY_UOM_CODE).column_value :=
581: -- 'moqd.transaction_uom_code';
582:
583: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ONHAND).column_value :=
584: 'SUM(moqd.primary_transaction_quantity)';

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

579:
580: -- inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PRIMARY_UOM_CODE).column_value :=
581: -- 'moqd.transaction_uom_code';
582:
583: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ONHAND).column_value :=
584: 'SUM(moqd.primary_transaction_quantity)';
585:
586: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PACKED).column_value :=
587: 'SUM(DECODE(moqd.containerized_flag, 1, moqd.primary_transaction_quantity, 0))';

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

582:
583: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ONHAND).column_value :=
584: 'SUM(moqd.primary_transaction_quantity)';
585:
586: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PACKED).column_value :=
587: 'SUM(DECODE(moqd.containerized_flag, 1, moqd.primary_transaction_quantity, 0))';
588:
589: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.UNPACKED).column_value :=
590: 'SUM(DECODE(moqd.containerized_flag, 1, 0, moqd.primary_transaction_quantity))';

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

585:
586: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PACKED).column_value :=
587: 'SUM(DECODE(moqd.containerized_flag, 1, moqd.primary_transaction_quantity, 0))';
588:
589: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.UNPACKED).column_value :=
590: 'SUM(DECODE(moqd.containerized_flag, 1, 0, moqd.primary_transaction_quantity))';
591:
592: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SECONDARY_UOM_CODE).column_value :=
593: 'moqd.secondary_uom_code';

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

588:
589: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.UNPACKED).column_value :=
590: 'SUM(DECODE(moqd.containerized_flag, 1, 0, moqd.primary_transaction_quantity))';
591:
592: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SECONDARY_UOM_CODE).column_value :=
593: 'moqd.secondary_uom_code';
594:
595: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SECONDARY_ONHAND).column_value :=
596: 'SUM(moqd.secondary_transaction_quantity)';

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

591:
592: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SECONDARY_UOM_CODE).column_value :=
593: 'moqd.secondary_uom_code';
594:
595: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SECONDARY_ONHAND).column_value :=
596: 'SUM(moqd.secondary_transaction_quantity)';
597:
598: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SECONDARY_PACKED).column_value :=
599: 'SUM(DECODE(moqd.containerized_flag, 1, moqd.secondary_transaction_quantity, 0))';

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

594:
595: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SECONDARY_ONHAND).column_value :=
596: 'SUM(moqd.secondary_transaction_quantity)';
597:
598: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SECONDARY_PACKED).column_value :=
599: 'SUM(DECODE(moqd.containerized_flag, 1, moqd.secondary_transaction_quantity, 0))';
600:
601: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SECONDARY_UNPACKED).column_value :=
602: 'SUM(DECODE(moqd.containerized_flag, 1, 0, moqd.secondary_transaction_quantity))';

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

597:
598: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SECONDARY_PACKED).column_value :=
599: 'SUM(DECODE(moqd.containerized_flag, 1, moqd.secondary_transaction_quantity, 0))';
600:
601: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SECONDARY_UNPACKED).column_value :=
602: 'SUM(DECODE(moqd.containerized_flag, 1, 0, moqd.secondary_transaction_quantity))';
603:
604: inv_mwb_query_manager.add_from_clause('mtl_onhand_quantities_detail moqd', 'ONHAND');
605: inv_mwb_query_manager.add_where_clause('moqd.lot_number is not null', 'ONHAND');

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

600:
601: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SECONDARY_UNPACKED).column_value :=
602: 'SUM(DECODE(moqd.containerized_flag, 1, 0, moqd.secondary_transaction_quantity))';
603:
604: inv_mwb_query_manager.add_from_clause('mtl_onhand_quantities_detail moqd', 'ONHAND');
605: inv_mwb_query_manager.add_where_clause('moqd.lot_number is not null', 'ONHAND');
606:
607: inv_mwb_query_manager.add_group_clause('moqd.inventory_item_id', 'ONHAND');
608: inv_mwb_query_manager.add_group_clause('moqd.organization_id', 'ONHAND');

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

601: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SECONDARY_UNPACKED).column_value :=
602: 'SUM(DECODE(moqd.containerized_flag, 1, 0, moqd.secondary_transaction_quantity))';
603:
604: inv_mwb_query_manager.add_from_clause('mtl_onhand_quantities_detail moqd', 'ONHAND');
605: inv_mwb_query_manager.add_where_clause('moqd.lot_number is not null', 'ONHAND');
606:
607: inv_mwb_query_manager.add_group_clause('moqd.inventory_item_id', 'ONHAND');
608: inv_mwb_query_manager.add_group_clause('moqd.organization_id', 'ONHAND');
609: -- inv_mwb_query_manager.add_group_clause('moqd.transaction_uom_code', 'ONHAND');

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

603:
604: inv_mwb_query_manager.add_from_clause('mtl_onhand_quantities_detail moqd', 'ONHAND');
605: inv_mwb_query_manager.add_where_clause('moqd.lot_number is not null', 'ONHAND');
606:
607: inv_mwb_query_manager.add_group_clause('moqd.inventory_item_id', 'ONHAND');
608: inv_mwb_query_manager.add_group_clause('moqd.organization_id', 'ONHAND');
609: -- inv_mwb_query_manager.add_group_clause('moqd.transaction_uom_code', 'ONHAND');
610: inv_mwb_query_manager.add_group_clause('moqd.secondary_uom_code', 'ONHAND');
611:

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

604: inv_mwb_query_manager.add_from_clause('mtl_onhand_quantities_detail moqd', 'ONHAND');
605: inv_mwb_query_manager.add_where_clause('moqd.lot_number is not null', 'ONHAND');
606:
607: inv_mwb_query_manager.add_group_clause('moqd.inventory_item_id', 'ONHAND');
608: inv_mwb_query_manager.add_group_clause('moqd.organization_id', 'ONHAND');
609: -- inv_mwb_query_manager.add_group_clause('moqd.transaction_uom_code', 'ONHAND');
610: inv_mwb_query_manager.add_group_clause('moqd.secondary_uom_code', 'ONHAND');
611:
612: WHEN 'MSN_QUERY' THEN

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

605: inv_mwb_query_manager.add_where_clause('moqd.lot_number is not null', 'ONHAND');
606:
607: inv_mwb_query_manager.add_group_clause('moqd.inventory_item_id', 'ONHAND');
608: inv_mwb_query_manager.add_group_clause('moqd.organization_id', 'ONHAND');
609: -- inv_mwb_query_manager.add_group_clause('moqd.transaction_uom_code', 'ONHAND');
610: inv_mwb_query_manager.add_group_clause('moqd.secondary_uom_code', 'ONHAND');
611:
612: WHEN 'MSN_QUERY' THEN
613: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ITEM_ID).column_value :=

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

606:
607: inv_mwb_query_manager.add_group_clause('moqd.inventory_item_id', 'ONHAND');
608: inv_mwb_query_manager.add_group_clause('moqd.organization_id', 'ONHAND');
609: -- inv_mwb_query_manager.add_group_clause('moqd.transaction_uom_code', 'ONHAND');
610: inv_mwb_query_manager.add_group_clause('moqd.secondary_uom_code', 'ONHAND');
611:
612: WHEN 'MSN_QUERY' THEN
613: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ITEM_ID).column_value :=
614: 'msn.inventory_item_id';

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

609: -- inv_mwb_query_manager.add_group_clause('moqd.transaction_uom_code', 'ONHAND');
610: inv_mwb_query_manager.add_group_clause('moqd.secondary_uom_code', 'ONHAND');
611:
612: WHEN 'MSN_QUERY' THEN
613: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ITEM_ID).column_value :=
614: 'msn.inventory_item_id';
615: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ORG_ID).column_value :=
616: 'msn.current_organization_id';
617: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PRIMARY_UOM_CODE).column_value :=

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

611:
612: WHEN 'MSN_QUERY' THEN
613: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ITEM_ID).column_value :=
614: 'msn.inventory_item_id';
615: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ORG_ID).column_value :=
616: 'msn.current_organization_id';
617: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PRIMARY_UOM_CODE).column_value :=
618: '''Ea''';
619: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ONHAND).column_value :=

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

613: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ITEM_ID).column_value :=
614: 'msn.inventory_item_id';
615: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ORG_ID).column_value :=
616: 'msn.current_organization_id';
617: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PRIMARY_UOM_CODE).column_value :=
618: '''Ea''';
619: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ONHAND).column_value :=
620: 'count(1)';
621: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PACKED).column_value :=

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

615: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ORG_ID).column_value :=
616: 'msn.current_organization_id';
617: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PRIMARY_UOM_CODE).column_value :=
618: '''Ea''';
619: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ONHAND).column_value :=
620: 'count(1)';
621: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PACKED).column_value :=
622: 'sum(decode(msn.lpn_id,NULL,0, 1))';
623: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.UNPACKED).column_value :=

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

617: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PRIMARY_UOM_CODE).column_value :=
618: '''Ea''';
619: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ONHAND).column_value :=
620: 'count(1)';
621: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PACKED).column_value :=
622: 'sum(decode(msn.lpn_id,NULL,0, 1))';
623: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.UNPACKED).column_value :=
624: 'sum(decode(msn.lpn_id,NULL,1, 0))';
625: inv_mwb_query_manager.add_from_clause('mtl_serial_numbers msn' , 'ONHAND');

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

619: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ONHAND).column_value :=
620: 'count(1)';
621: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PACKED).column_value :=
622: 'sum(decode(msn.lpn_id,NULL,0, 1))';
623: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.UNPACKED).column_value :=
624: 'sum(decode(msn.lpn_id,NULL,1, 0))';
625: inv_mwb_query_manager.add_from_clause('mtl_serial_numbers msn' , 'ONHAND');
626: inv_mwb_query_manager.add_where_clause('msn.lot_number is not null' , 'ONHAND');
627: inv_mwb_query_manager.add_group_clause('msn.inventory_item_id' , 'ONHAND');

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

621: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PACKED).column_value :=
622: 'sum(decode(msn.lpn_id,NULL,0, 1))';
623: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.UNPACKED).column_value :=
624: 'sum(decode(msn.lpn_id,NULL,1, 0))';
625: inv_mwb_query_manager.add_from_clause('mtl_serial_numbers msn' , 'ONHAND');
626: inv_mwb_query_manager.add_where_clause('msn.lot_number is not null' , 'ONHAND');
627: inv_mwb_query_manager.add_group_clause('msn.inventory_item_id' , 'ONHAND');
628: inv_mwb_query_manager.add_group_clause('msn.current_organization_id', 'ONHAND');
629: inv_mwb_query_manager.add_group_clause('''Ea''', 'ONHAND');

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

622: 'sum(decode(msn.lpn_id,NULL,0, 1))';
623: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.UNPACKED).column_value :=
624: 'sum(decode(msn.lpn_id,NULL,1, 0))';
625: inv_mwb_query_manager.add_from_clause('mtl_serial_numbers msn' , 'ONHAND');
626: inv_mwb_query_manager.add_where_clause('msn.lot_number is not null' , 'ONHAND');
627: inv_mwb_query_manager.add_group_clause('msn.inventory_item_id' , 'ONHAND');
628: inv_mwb_query_manager.add_group_clause('msn.current_organization_id', 'ONHAND');
629: inv_mwb_query_manager.add_group_clause('''Ea''', 'ONHAND');
630: END CASE; -- p_flag

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

623: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.UNPACKED).column_value :=
624: 'sum(decode(msn.lpn_id,NULL,1, 0))';
625: inv_mwb_query_manager.add_from_clause('mtl_serial_numbers msn' , 'ONHAND');
626: inv_mwb_query_manager.add_where_clause('msn.lot_number is not null' , 'ONHAND');
627: inv_mwb_query_manager.add_group_clause('msn.inventory_item_id' , 'ONHAND');
628: inv_mwb_query_manager.add_group_clause('msn.current_organization_id', 'ONHAND');
629: inv_mwb_query_manager.add_group_clause('''Ea''', 'ONHAND');
630: END CASE; -- p_flag
631:

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

624: 'sum(decode(msn.lpn_id,NULL,1, 0))';
625: inv_mwb_query_manager.add_from_clause('mtl_serial_numbers msn' , 'ONHAND');
626: inv_mwb_query_manager.add_where_clause('msn.lot_number is not null' , 'ONHAND');
627: inv_mwb_query_manager.add_group_clause('msn.inventory_item_id' , 'ONHAND');
628: inv_mwb_query_manager.add_group_clause('msn.current_organization_id', 'ONHAND');
629: inv_mwb_query_manager.add_group_clause('''Ea''', 'ONHAND');
630: END CASE; -- p_flag
631:
632: END make_common_queries;

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

625: inv_mwb_query_manager.add_from_clause('mtl_serial_numbers msn' , 'ONHAND');
626: inv_mwb_query_manager.add_where_clause('msn.lot_number is not null' , 'ONHAND');
627: inv_mwb_query_manager.add_group_clause('msn.inventory_item_id' , 'ONHAND');
628: inv_mwb_query_manager.add_group_clause('msn.current_organization_id', 'ONHAND');
629: inv_mwb_query_manager.add_group_clause('''Ea''', 'ONHAND');
630: END CASE; -- p_flag
631:
632: END make_common_queries;
633: --