31: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
32: inv_mwb_globals.g_serial_to IS NOT NULL
33: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL THEN -- Bug 6429880
34: make_common_queries('MSN_QUERY');
35: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
36: ELSE
37: make_common_queries('MOQD');
38: inv_mwb_query_manager.add_qf_where_onhand('ONHAND');
39: END IF;
34: make_common_queries('MSN_QUERY');
35: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
36: ELSE
37: make_common_queries('MOQD');
38: inv_mwb_query_manager.add_qf_where_onhand('ONHAND');
39: END IF;
40: inv_mwb_query_manager.execute_query;
41: END IF; -- g_tree_event
42:
36: ELSE
37: make_common_queries('MOQD');
38: inv_mwb_query_manager.add_qf_where_onhand('ONHAND');
39: END IF;
40: inv_mwb_query_manager.execute_query;
41: END IF; -- g_tree_event
42:
43: EXCEPTION
44: WHEN no_data_found THEN
71: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
72: inv_mwb_globals.g_serial_to IS NOT NULL
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.add_qf_where_onhand('ONHAND_MSN');
76: ELSE
77: make_common_queries('MOQD');
78: inv_mwb_query_manager.add_qf_where_onhand('ONHAND');
79: END IF;
74: make_common_queries('MSN_QUERY');
75: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
76: ELSE
77: make_common_queries('MOQD');
78: inv_mwb_query_manager.add_qf_where_onhand('ONHAND');
79: END IF;
80: inv_mwb_query_manager.add_where_clause('mln.grade_code = :onh_tree_grade_code ', 'ONHAND');
81: inv_mwb_query_manager.add_bind_variable('onh_tree_grade_code', inv_mwb_globals.g_tree_grade_code);
82: inv_mwb_query_manager.execute_query;
76: ELSE
77: make_common_queries('MOQD');
78: inv_mwb_query_manager.add_qf_where_onhand('ONHAND');
79: END IF;
80: inv_mwb_query_manager.add_where_clause('mln.grade_code = :onh_tree_grade_code ', 'ONHAND');
81: inv_mwb_query_manager.add_bind_variable('onh_tree_grade_code', inv_mwb_globals.g_tree_grade_code);
82: inv_mwb_query_manager.execute_query;
83:
84: END IF;
77: make_common_queries('MOQD');
78: inv_mwb_query_manager.add_qf_where_onhand('ONHAND');
79: END IF;
80: inv_mwb_query_manager.add_where_clause('mln.grade_code = :onh_tree_grade_code ', 'ONHAND');
81: inv_mwb_query_manager.add_bind_variable('onh_tree_grade_code', inv_mwb_globals.g_tree_grade_code);
82: inv_mwb_query_manager.execute_query;
83:
84: END IF;
85:
78: inv_mwb_query_manager.add_qf_where_onhand('ONHAND');
79: END IF;
80: inv_mwb_query_manager.add_where_clause('mln.grade_code = :onh_tree_grade_code ', 'ONHAND');
81: inv_mwb_query_manager.add_bind_variable('onh_tree_grade_code', inv_mwb_globals.g_tree_grade_code);
82: inv_mwb_query_manager.execute_query;
83:
84: END IF;
85:
86: EXCEPTION
115: inv_mwb_globals.g_serial_to IS NOT NULL
116: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL THEN -- Bug 6429880
117: make_common_queries('MSN_QUERY');
118:
119: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ITEM_ID).column_value :=
120: 'msn.inventory_item_id';
121: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PRIMARY_UOM_CODE).column_value :=
122: '''Ea''';
123:
117: make_common_queries('MSN_QUERY');
118:
119: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ITEM_ID).column_value :=
120: 'msn.inventory_item_id';
121: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PRIMARY_UOM_CODE).column_value :=
122: '''Ea''';
123:
124: inv_mwb_query_manager.add_group_clause(
125: 'msn.inventory_item_id',
120: 'msn.inventory_item_id';
121: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PRIMARY_UOM_CODE).column_value :=
122: '''Ea''';
123:
124: inv_mwb_query_manager.add_group_clause(
125: 'msn.inventory_item_id',
126: 'ONHAND'
127: );
128: inv_mwb_query_manager.add_group_clause(
124: inv_mwb_query_manager.add_group_clause(
125: 'msn.inventory_item_id',
126: 'ONHAND'
127: );
128: inv_mwb_query_manager.add_group_clause(
129: '''Ea''',
130: 'ONHAND'
131: );
132:
129: '''Ea''',
130: 'ONHAND'
131: );
132:
133: inv_mwb_query_manager.add_where_clause(
134: 'msn.current_organization_id = :onh_tree_organization_id ',
135: 'ONHAND'
136: );
137: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
133: inv_mwb_query_manager.add_where_clause(
134: 'msn.current_organization_id = :onh_tree_organization_id ',
135: 'ONHAND'
136: );
137: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
138: ELSE
139:
140: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ITEM_ID).column_value :=
141: 'moqd.inventory_item_id';
136: );
137: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
138: ELSE
139:
140: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ITEM_ID).column_value :=
141: 'moqd.inventory_item_id';
142:
143: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PRIMARY_UOM_CODE).column_value :=
144: 'moqd.transaction_uom_code';
139:
140: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ITEM_ID).column_value :=
141: 'moqd.inventory_item_id';
142:
143: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PRIMARY_UOM_CODE).column_value :=
144: 'moqd.transaction_uom_code';
145:
146: inv_mwb_query_manager.add_group_clause(
147: 'moqd.inventory_item_id',
142:
143: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PRIMARY_UOM_CODE).column_value :=
144: 'moqd.transaction_uom_code';
145:
146: inv_mwb_query_manager.add_group_clause(
147: 'moqd.inventory_item_id',
148: 'ONHAND'
149: );
150:
147: 'moqd.inventory_item_id',
148: 'ONHAND'
149: );
150:
151: inv_mwb_query_manager.add_group_clause(
152: 'moqd.transaction_uom_code',
153: 'ONHAND'
154: );
155:
152: 'moqd.transaction_uom_code',
153: 'ONHAND'
154: );
155:
156: inv_mwb_query_manager.add_where_clause(
157: 'moqd.organization_id = :onh_tree_organization_id ',
158: 'ONHAND'
159: );
160:
157: 'moqd.organization_id = :onh_tree_organization_id ',
158: 'ONHAND'
159: );
160:
161: inv_mwb_query_manager.add_qf_where_onhand('ONHAND');
162:
163: make_common_queries('MOQD');
164: END IF;
165:
162:
163: make_common_queries('MOQD');
164: END IF;
165:
166: inv_mwb_query_manager.add_where_clause(
167: 'mln.grade_code = :onh_tree_grade_code ',
168: 'ONHAND'
169: );
170:
167: 'mln.grade_code = :onh_tree_grade_code ',
168: 'ONHAND'
169: );
170:
171: inv_mwb_query_manager.add_bind_variable(
172: 'onh_tree_organization_id',
173: inv_mwb_globals.g_tree_organization_id
174: );
175:
172: 'onh_tree_organization_id',
173: inv_mwb_globals.g_tree_organization_id
174: );
175:
176: inv_mwb_query_manager.add_bind_variable(
177: 'onh_tree_grade_code',
178: inv_mwb_globals.g_tree_grade_code
179: );
180:
177: 'onh_tree_grade_code',
178: inv_mwb_globals.g_tree_grade_code
179: );
180:
181: inv_mwb_query_manager.execute_query;
182:
183: END IF; -- g_tree_event
184:
185: EXCEPTION
214: inv_mwb_globals.g_serial_to IS NOT NULL
215: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL THEN -- Bug 6429880
216: make_common_queries('MSN_QUERY');
217:
218: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
219: 'msn.lot_number';
220: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ITEM_ID).column_value :=
221: 'msn.inventory_item_id';
222: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PRIMARY_UOM_CODE).column_value :=
216: make_common_queries('MSN_QUERY');
217:
218: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
219: 'msn.lot_number';
220: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ITEM_ID).column_value :=
221: 'msn.inventory_item_id';
222: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PRIMARY_UOM_CODE).column_value :=
223: '''Ea''';
224:
218: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
219: 'msn.lot_number';
220: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ITEM_ID).column_value :=
221: 'msn.inventory_item_id';
222: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PRIMARY_UOM_CODE).column_value :=
223: '''Ea''';
224:
225: inv_mwb_query_manager.add_group_clause(
226: 'msn.inventory_item_id',
221: 'msn.inventory_item_id';
222: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PRIMARY_UOM_CODE).column_value :=
223: '''Ea''';
224:
225: inv_mwb_query_manager.add_group_clause(
226: 'msn.inventory_item_id',
227: 'ONHAND'
228: );
229: inv_mwb_query_manager.add_group_clause(
225: inv_mwb_query_manager.add_group_clause(
226: 'msn.inventory_item_id',
227: 'ONHAND'
228: );
229: inv_mwb_query_manager.add_group_clause(
230: '''Ea''',
231: 'ONHAND'
232: );
233: inv_mwb_query_manager.add_group_clause(
229: inv_mwb_query_manager.add_group_clause(
230: '''Ea''',
231: 'ONHAND'
232: );
233: inv_mwb_query_manager.add_group_clause(
234: 'msn.lot_number',
235: 'ONHAND'
236: );
237: inv_mwb_query_manager.add_where_clause(
233: inv_mwb_query_manager.add_group_clause(
234: 'msn.lot_number',
235: 'ONHAND'
236: );
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(
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.inventory_item_id = :onh_tree_inventory_item_id ',
243: 'ONHAND'
244: );
245: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
241: inv_mwb_query_manager.add_where_clause(
242: 'msn.inventory_item_id = :onh_tree_inventory_item_id ',
243: 'ONHAND'
244: );
245: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
246: ELSE
247:
248: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
249: 'moqd.lot_number';
244: );
245: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
246: ELSE
247:
248: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
249: 'moqd.lot_number';
250:
251: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ITEM_ID).column_value :=
252: 'moqd.inventory_item_id';
247:
248: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
249: 'moqd.lot_number';
250:
251: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ITEM_ID).column_value :=
252: 'moqd.inventory_item_id';
253:
254: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PRIMARY_UOM_CODE).column_value :=
255: 'moqd.transaction_uom_code';
250:
251: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ITEM_ID).column_value :=
252: 'moqd.inventory_item_id';
253:
254: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PRIMARY_UOM_CODE).column_value :=
255: 'moqd.transaction_uom_code';
256:
257: inv_mwb_query_manager.add_group_clause(
258: 'moqd.inventory_item_id',
253:
254: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PRIMARY_UOM_CODE).column_value :=
255: 'moqd.transaction_uom_code';
256:
257: inv_mwb_query_manager.add_group_clause(
258: 'moqd.inventory_item_id',
259: 'ONHAND'
260: );
261:
258: 'moqd.inventory_item_id',
259: 'ONHAND'
260: );
261:
262: inv_mwb_query_manager.add_where_clause(
263: 'moqd.organization_id = :onh_tree_organization_id ',
264: 'ONHAND'
265: );
266: inv_mwb_query_manager.add_where_clause(
262: inv_mwb_query_manager.add_where_clause(
263: 'moqd.organization_id = :onh_tree_organization_id ',
264: 'ONHAND'
265: );
266: inv_mwb_query_manager.add_where_clause(
267: 'moqd.inventory_item_id = :onh_tree_inventory_item_id ',
268: 'ONHAND'
269: );
270: inv_mwb_query_manager.add_group_clause(
266: inv_mwb_query_manager.add_where_clause(
267: 'moqd.inventory_item_id = :onh_tree_inventory_item_id ',
268: 'ONHAND'
269: );
270: inv_mwb_query_manager.add_group_clause(
271: 'moqd.transaction_uom_code',
272: 'ONHAND'
273: );
274: inv_mwb_query_manager.add_group_clause(
270: inv_mwb_query_manager.add_group_clause(
271: 'moqd.transaction_uom_code',
272: 'ONHAND'
273: );
274: inv_mwb_query_manager.add_group_clause(
275: 'moqd.lot_number',
276: 'ONHAND'
277: );
278:
276: 'ONHAND'
277: );
278:
279: make_common_queries('MOQD');
280: inv_mwb_query_manager.add_qf_where_onhand('ONHAND');
281: END IF;
282: inv_mwb_query_manager.add_where_clause(
283: 'mln.grade_code = :onh_tree_grade_code ',
284: 'ONHAND'
278:
279: make_common_queries('MOQD');
280: inv_mwb_query_manager.add_qf_where_onhand('ONHAND');
281: END IF;
282: inv_mwb_query_manager.add_where_clause(
283: 'mln.grade_code = :onh_tree_grade_code ',
284: 'ONHAND'
285: );
286:
283: 'mln.grade_code = :onh_tree_grade_code ',
284: 'ONHAND'
285: );
286:
287: inv_mwb_query_manager.add_bind_variable(
288: 'onh_tree_organization_id',
289: inv_mwb_globals.g_tree_organization_id
290: );
291:
288: 'onh_tree_organization_id',
289: inv_mwb_globals.g_tree_organization_id
290: );
291:
292: inv_mwb_query_manager.add_bind_variable(
293: 'onh_tree_inventory_item_id',
294: inv_mwb_globals.g_tree_item_id
295: );
296:
293: 'onh_tree_inventory_item_id',
294: inv_mwb_globals.g_tree_item_id
295: );
296:
297: inv_mwb_query_manager.add_bind_variable(
298: 'onh_tree_grade_code',
299: inv_mwb_globals.g_tree_grade_code
300: );
301:
298: 'onh_tree_grade_code',
299: inv_mwb_globals.g_tree_grade_code
300: );
301:
302: inv_mwb_query_manager.execute_query;
303:
304: END IF; -- g_tree_event
305:
306: EXCEPTION
338: AND organization_id = inv_mwb_globals.g_tree_organization_id;
339:
340: IF l_serial_control IN (2,5) THEN
341: make_common_queries('MSN');
342: inv_mwb_query_manager.add_where_clause(
343: 'msn.current_organization_id = :onh_tree_organization_id ',
344: 'ONHAND'
345: );
346: inv_mwb_query_manager.add_where_clause(
342: inv_mwb_query_manager.add_where_clause(
343: 'msn.current_organization_id = :onh_tree_organization_id ',
344: 'ONHAND'
345: );
346: inv_mwb_query_manager.add_where_clause(
347: 'msn.inventory_item_id = :onh_tree_inventory_item_id ',
348: 'ONHAND'
349: );
350: inv_mwb_query_manager.add_where_clause(
346: inv_mwb_query_manager.add_where_clause(
347: 'msn.inventory_item_id = :onh_tree_inventory_item_id ',
348: 'ONHAND'
349: );
350: inv_mwb_query_manager.add_where_clause(
351: 'msn.lot_number = :onh_tree_lot_number ',
352: 'ONHAND'
353: );
354: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
350: inv_mwb_query_manager.add_where_clause(
351: 'msn.lot_number = :onh_tree_lot_number ',
352: 'ONHAND'
353: );
354: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
355: ELSE -- not serial controlled
356: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
357: inv_mwb_globals.g_serial_to IS NOT NULL
358: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL THEN -- Bug 6429880
357: inv_mwb_globals.g_serial_to IS NOT NULL
358: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL THEN -- Bug 6429880
359: make_common_queries('MSN_QUERY');
360:
361: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
362: 'msn.lot_number';
363: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ITEM_ID).column_value :=
364: 'msn.inventory_item_id';
365: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PRIMARY_UOM_CODE).column_value :=
359: make_common_queries('MSN_QUERY');
360:
361: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
362: 'msn.lot_number';
363: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ITEM_ID).column_value :=
364: 'msn.inventory_item_id';
365: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PRIMARY_UOM_CODE).column_value :=
366: '''Ea''';
367:
361: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
362: 'msn.lot_number';
363: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ITEM_ID).column_value :=
364: 'msn.inventory_item_id';
365: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PRIMARY_UOM_CODE).column_value :=
366: '''Ea''';
367:
368: inv_mwb_query_manager.add_group_clause(
369: 'msn.inventory_item_id',
364: 'msn.inventory_item_id';
365: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PRIMARY_UOM_CODE).column_value :=
366: '''Ea''';
367:
368: inv_mwb_query_manager.add_group_clause(
369: 'msn.inventory_item_id',
370: 'ONHAND'
371: );
372: inv_mwb_query_manager.add_group_clause(
368: inv_mwb_query_manager.add_group_clause(
369: 'msn.inventory_item_id',
370: 'ONHAND'
371: );
372: inv_mwb_query_manager.add_group_clause(
373: '''Ea''',
374: 'ONHAND'
375: );
376: inv_mwb_query_manager.add_group_clause(
372: inv_mwb_query_manager.add_group_clause(
373: '''Ea''',
374: 'ONHAND'
375: );
376: inv_mwb_query_manager.add_group_clause(
377: 'msn.lot_number',
378: 'ONHAND'
379: );
380: inv_mwb_query_manager.add_where_clause(
376: inv_mwb_query_manager.add_group_clause(
377: 'msn.lot_number',
378: 'ONHAND'
379: );
380: inv_mwb_query_manager.add_where_clause(
381: 'msn.current_organization_id = :onh_tree_organization_id ',
382: 'ONHAND'
383: );
384: inv_mwb_query_manager.add_where_clause(
380: inv_mwb_query_manager.add_where_clause(
381: 'msn.current_organization_id = :onh_tree_organization_id ',
382: 'ONHAND'
383: );
384: inv_mwb_query_manager.add_where_clause(
385: 'msn.inventory_item_id = :onh_tree_inventory_item_id ',
386: 'ONHAND'
387: );
388: inv_mwb_query_manager.add_where_clause(
384: inv_mwb_query_manager.add_where_clause(
385: 'msn.inventory_item_id = :onh_tree_inventory_item_id ',
386: 'ONHAND'
387: );
388: inv_mwb_query_manager.add_where_clause(
389: 'msn.lot_number = :onh_tree_lot_number ',
390: 'ONHAND'
391: );
392:
389: 'msn.lot_number = :onh_tree_lot_number ',
390: 'ONHAND'
391: );
392:
393: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
394: ELSE
395: make_common_queries('MOQD');
396:
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: ELSE
395: make_common_queries('MOQD');
396:
397: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
398: 'moqd.lot_number';
399:
400: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ITEM_ID).column_value :=
401: 'moqd.inventory_item_id';
396:
397: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
398: 'moqd.lot_number';
399:
400: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ITEM_ID).column_value :=
401: 'moqd.inventory_item_id';
402:
403: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PRIMARY_UOM_CODE).column_value :=
404: 'moqd.transaction_uom_code';
399:
400: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ITEM_ID).column_value :=
401: 'moqd.inventory_item_id';
402:
403: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PRIMARY_UOM_CODE).column_value :=
404: 'moqd.transaction_uom_code';
405:
406: inv_mwb_query_manager.add_group_clause(
407: 'moqd.inventory_item_id',
402:
403: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PRIMARY_UOM_CODE).column_value :=
404: 'moqd.transaction_uom_code';
405:
406: inv_mwb_query_manager.add_group_clause(
407: 'moqd.inventory_item_id',
408: 'ONHAND'
409: );
410:
407: 'moqd.inventory_item_id',
408: 'ONHAND'
409: );
410:
411: inv_mwb_query_manager.add_where_clause(
412: 'moqd.organization_id = :onh_tree_organization_id ',
413: 'ONHAND'
414: );
415: inv_mwb_query_manager.add_where_clause(
411: inv_mwb_query_manager.add_where_clause(
412: 'moqd.organization_id = :onh_tree_organization_id ',
413: 'ONHAND'
414: );
415: inv_mwb_query_manager.add_where_clause(
416: 'moqd.inventory_item_id = :onh_tree_inventory_item_id ',
417: 'ONHAND'
418: );
419: inv_mwb_query_manager.add_where_clause(
415: inv_mwb_query_manager.add_where_clause(
416: 'moqd.inventory_item_id = :onh_tree_inventory_item_id ',
417: 'ONHAND'
418: );
419: inv_mwb_query_manager.add_where_clause(
420: 'moqd.lot_number = :onh_tree_lot_number ',
421: 'ONHAND'
422: );
423:
420: 'moqd.lot_number = :onh_tree_lot_number ',
421: 'ONHAND'
422: );
423:
424: inv_mwb_query_manager.add_group_clause(
425: 'moqd.transaction_uom_code',
426: 'ONHAND'
427: );
428: inv_mwb_query_manager.add_group_clause(
424: inv_mwb_query_manager.add_group_clause(
425: 'moqd.transaction_uom_code',
426: 'ONHAND'
427: );
428: inv_mwb_query_manager.add_group_clause(
429: 'moqd.secondary_uom_code',
430: 'ONHAND'
431: );
432: inv_mwb_query_manager.add_group_clause(
428: inv_mwb_query_manager.add_group_clause(
429: 'moqd.secondary_uom_code',
430: 'ONHAND'
431: );
432: inv_mwb_query_manager.add_group_clause(
433: 'moqd.lot_number',
434: 'ONHAND'
435: );
436: inv_mwb_query_manager.add_qf_where_onhand('ONHAND');
432: inv_mwb_query_manager.add_group_clause(
433: 'moqd.lot_number',
434: 'ONHAND'
435: );
436: inv_mwb_query_manager.add_qf_where_onhand('ONHAND');
437: END IF;
438:
439: END IF; -- not serial controlled
440: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.GRADE_CODE).column_value :=
436: inv_mwb_query_manager.add_qf_where_onhand('ONHAND');
437: END IF;
438:
439: END IF; -- not serial controlled
440: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.GRADE_CODE).column_value :=
441: 'mln.grade_code';
442: inv_mwb_query_manager.add_where_clause(
443: 'mln.grade_code = :onh_tree_grade_code ',
444: 'ONHAND'
438:
439: END IF; -- not serial controlled
440: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.GRADE_CODE).column_value :=
441: 'mln.grade_code';
442: inv_mwb_query_manager.add_where_clause(
443: 'mln.grade_code = :onh_tree_grade_code ',
444: 'ONHAND'
445: );
446:
443: 'mln.grade_code = :onh_tree_grade_code ',
444: 'ONHAND'
445: );
446:
447: inv_mwb_query_manager.add_bind_variable(
448: 'onh_tree_organization_id',
449: inv_mwb_globals.g_tree_organization_id
450: );
451:
448: 'onh_tree_organization_id',
449: inv_mwb_globals.g_tree_organization_id
450: );
451:
452: inv_mwb_query_manager.add_bind_variable(
453: 'onh_tree_inventory_item_id',
454: inv_mwb_globals.g_tree_item_id
455: );
456:
453: 'onh_tree_inventory_item_id',
454: inv_mwb_globals.g_tree_item_id
455: );
456:
457: inv_mwb_query_manager.add_bind_variable(
458: 'onh_tree_grade_code',
459: inv_mwb_globals.g_tree_grade_code
460: );
461: inv_mwb_query_manager.add_bind_variable(
457: inv_mwb_query_manager.add_bind_variable(
458: 'onh_tree_grade_code',
459: inv_mwb_globals.g_tree_grade_code
460: );
461: inv_mwb_query_manager.add_bind_variable(
462: 'onh_tree_lot_number',
463: inv_mwb_globals.g_tree_lot_number
464: );
465:
462: 'onh_tree_lot_number',
463: inv_mwb_globals.g_tree_lot_number
464: );
465:
466: inv_mwb_query_manager.execute_query;
467: END IF; --g_tree_event
468:
469: EXCEPTION
470: WHEN no_data_found THEN
485: l_procedure_name := 'SERIAL_NODE_EVENT';
486:
487: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
488:
489: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.GRADE_CODE).column_value :=
490: 'mln.grade_code';
491:
492: make_common_queries('MSN');
493: inv_mwb_query_manager.add_where_clause(
489: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.GRADE_CODE).column_value :=
490: 'mln.grade_code';
491:
492: make_common_queries('MSN');
493: inv_mwb_query_manager.add_where_clause(
494: 'msn.current_organization_id = :onh_tree_organization_id ',
495: 'ONHAND'
496: );
497: inv_mwb_query_manager.add_where_clause(
493: inv_mwb_query_manager.add_where_clause(
494: 'msn.current_organization_id = :onh_tree_organization_id ',
495: 'ONHAND'
496: );
497: inv_mwb_query_manager.add_where_clause(
498: 'msn.inventory_item_id = :onh_tree_inventory_item_id ',
499: 'ONHAND'
500: );
501: inv_mwb_query_manager.add_where_clause(
497: inv_mwb_query_manager.add_where_clause(
498: 'msn.inventory_item_id = :onh_tree_inventory_item_id ',
499: 'ONHAND'
500: );
501: inv_mwb_query_manager.add_where_clause(
502: 'msn.lot_number = :onh_tree_lot_number ',
503: 'ONHAND'
504: );
505: inv_mwb_query_manager.add_where_clause(
501: inv_mwb_query_manager.add_where_clause(
502: 'msn.lot_number = :onh_tree_lot_number ',
503: 'ONHAND'
504: );
505: inv_mwb_query_manager.add_where_clause(
506: 'mln.grade_code = :onh_tree_grade_code ',
507: 'ONHAND'
508: );
509: inv_mwb_query_manager.add_where_clause(
505: inv_mwb_query_manager.add_where_clause(
506: 'mln.grade_code = :onh_tree_grade_code ',
507: 'ONHAND'
508: );
509: inv_mwb_query_manager.add_where_clause(
510: 'msn.serial_number = :onh_tree_serial_number ',
511: 'ONHAND'
512: );
513: inv_mwb_query_manager.add_bind_variable(
509: inv_mwb_query_manager.add_where_clause(
510: 'msn.serial_number = :onh_tree_serial_number ',
511: 'ONHAND'
512: );
513: inv_mwb_query_manager.add_bind_variable(
514: 'onh_tree_organization_id',
515: inv_mwb_globals.g_tree_organization_id
516: );
517:
514: 'onh_tree_organization_id',
515: inv_mwb_globals.g_tree_organization_id
516: );
517:
518: inv_mwb_query_manager.add_bind_variable(
519: 'onh_tree_inventory_item_id',
520: inv_mwb_globals.g_tree_item_id
521: );
522:
519: 'onh_tree_inventory_item_id',
520: inv_mwb_globals.g_tree_item_id
521: );
522:
523: inv_mwb_query_manager.add_bind_variable(
524: 'onh_tree_grade_code',
525: inv_mwb_globals.g_tree_grade_code
526: );
527: inv_mwb_query_manager.add_bind_variable(
523: inv_mwb_query_manager.add_bind_variable(
524: 'onh_tree_grade_code',
525: inv_mwb_globals.g_tree_grade_code
526: );
527: inv_mwb_query_manager.add_bind_variable(
528: 'onh_tree_lot_number',
529: inv_mwb_globals.g_tree_lot_number
530: );
531: inv_mwb_query_manager.add_bind_variable(
527: inv_mwb_query_manager.add_bind_variable(
528: 'onh_tree_lot_number',
529: inv_mwb_globals.g_tree_lot_number
530: );
531: inv_mwb_query_manager.add_bind_variable(
532: 'onh_tree_serial_number',
533: inv_mwb_globals.g_tree_serial_number
534: );
535:
532: 'onh_tree_serial_number',
533: inv_mwb_globals.g_tree_serial_number
534: );
535:
536: inv_mwb_query_manager.execute_query;
537:
538:
539:
540: END IF; -- g_tree_event
552:
553: CASE p_flag
554:
555: WHEN 'MSN' THEN
556: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ITEM_ID).column_value :=
557: 'msn.inventory_item_id';
558:
559: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ORG_ID).column_value :=
560: 'msn.current_organization_id';
555: WHEN 'MSN' THEN
556: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ITEM_ID).column_value :=
557: 'msn.inventory_item_id';
558:
559: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ORG_ID).column_value :=
560: 'msn.current_organization_id';
561:
562: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PRIMARY_UOM_CODE).column_value :=
563: '''Ea''';
558:
559: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ORG_ID).column_value :=
560: 'msn.current_organization_id';
561:
562: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PRIMARY_UOM_CODE).column_value :=
563: '''Ea''';
564:
565: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ONHAND).column_value := 1;
566:
561:
562: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PRIMARY_UOM_CODE).column_value :=
563: '''Ea''';
564:
565: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ONHAND).column_value := 1;
566:
567: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PACKED).column_value :=
568: 'SUM(DECODE(msn.lpn_id, NULL, 0,1))';
569:
563: '''Ea''';
564:
565: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ONHAND).column_value := 1;
566:
567: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PACKED).column_value :=
568: 'SUM(DECODE(msn.lpn_id, NULL, 0,1))';
569:
570: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.UNPACKED).column_value :=
571: 'SUM(DECODE(msn.lpn_id, NULL, 1,0))';
566:
567: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PACKED).column_value :=
568: 'SUM(DECODE(msn.lpn_id, NULL, 0,1))';
569:
570: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.UNPACKED).column_value :=
571: 'SUM(DECODE(msn.lpn_id, NULL, 1,0))';
572:
573: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SERIAL).column_value :=
574: 'msn.serial_number';
569:
570: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.UNPACKED).column_value :=
571: 'SUM(DECODE(msn.lpn_id, NULL, 1,0))';
572:
573: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SERIAL).column_value :=
574: 'msn.serial_number';
575:
576: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.owning_organization_id).column_value :=
577: 'msn.owning_organization_id';
572:
573: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SERIAL).column_value :=
574: 'msn.serial_number';
575:
576: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.owning_organization_id).column_value :=
577: 'msn.owning_organization_id';
578:
579: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.planning_organization_id).column_value :=
580: 'msn.planning_organization_id';
575:
576: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.owning_organization_id).column_value :=
577: 'msn.owning_organization_id';
578:
579: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.planning_organization_id).column_value :=
580: 'msn.planning_organization_id';
581:
582: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.owning_tp_type).column_value :=
583: 'msn.owning_tp_type';
578:
579: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.planning_organization_id).column_value :=
580: 'msn.planning_organization_id';
581:
582: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.owning_tp_type).column_value :=
583: 'msn.owning_tp_type';
584:
585: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.planning_tp_type).column_value :=
586: 'msn.planning_tp_type';
581:
582: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.owning_tp_type).column_value :=
583: 'msn.owning_tp_type';
584:
585: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.planning_tp_type).column_value :=
586: 'msn.planning_tp_type';
587:
588: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.GRADE_CODE).column_value :=
589: 'mln.grade_code';
584:
585: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.planning_tp_type).column_value :=
586: 'msn.planning_tp_type';
587:
588: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.GRADE_CODE).column_value :=
589: 'mln.grade_code';
590:
591: inv_mwb_query_manager.add_from_clause('mtl_serial_numbers msn', 'ONHAND');
592: inv_mwb_query_manager.add_from_clause('mtl_lot_numbers mln', 'ONHAND');
587:
588: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.GRADE_CODE).column_value :=
589: 'mln.grade_code';
590:
591: inv_mwb_query_manager.add_from_clause('mtl_serial_numbers msn', 'ONHAND');
592: inv_mwb_query_manager.add_from_clause('mtl_lot_numbers mln', 'ONHAND');
593:
594: inv_mwb_query_manager.add_where_clause('msn.current_status = 3', 'ONHAND');
595: inv_mwb_query_manager.add_where_clause('msn.lot_number = mln.lot_number', 'ONHAND');
588: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.GRADE_CODE).column_value :=
589: 'mln.grade_code';
590:
591: inv_mwb_query_manager.add_from_clause('mtl_serial_numbers msn', 'ONHAND');
592: inv_mwb_query_manager.add_from_clause('mtl_lot_numbers mln', 'ONHAND');
593:
594: inv_mwb_query_manager.add_where_clause('msn.current_status = 3', 'ONHAND');
595: inv_mwb_query_manager.add_where_clause('msn.lot_number = mln.lot_number', 'ONHAND');
596: inv_mwb_query_manager.add_where_clause('mln.grade_code IS NOT NULL', 'ONHAND');
590:
591: inv_mwb_query_manager.add_from_clause('mtl_serial_numbers msn', 'ONHAND');
592: inv_mwb_query_manager.add_from_clause('mtl_lot_numbers mln', 'ONHAND');
593:
594: inv_mwb_query_manager.add_where_clause('msn.current_status = 3', 'ONHAND');
595: inv_mwb_query_manager.add_where_clause('msn.lot_number = mln.lot_number', 'ONHAND');
596: inv_mwb_query_manager.add_where_clause('mln.grade_code IS NOT NULL', 'ONHAND');
597:
598: inv_mwb_query_manager.add_group_clause('msn.serial_number', 'ONHAND');
591: inv_mwb_query_manager.add_from_clause('mtl_serial_numbers msn', 'ONHAND');
592: inv_mwb_query_manager.add_from_clause('mtl_lot_numbers mln', 'ONHAND');
593:
594: inv_mwb_query_manager.add_where_clause('msn.current_status = 3', 'ONHAND');
595: inv_mwb_query_manager.add_where_clause('msn.lot_number = mln.lot_number', 'ONHAND');
596: inv_mwb_query_manager.add_where_clause('mln.grade_code IS NOT NULL', 'ONHAND');
597:
598: inv_mwb_query_manager.add_group_clause('msn.serial_number', 'ONHAND');
599: inv_mwb_query_manager.add_group_clause('msn.current_organization_id', 'ONHAND');
592: inv_mwb_query_manager.add_from_clause('mtl_lot_numbers mln', 'ONHAND');
593:
594: inv_mwb_query_manager.add_where_clause('msn.current_status = 3', 'ONHAND');
595: inv_mwb_query_manager.add_where_clause('msn.lot_number = mln.lot_number', 'ONHAND');
596: inv_mwb_query_manager.add_where_clause('mln.grade_code IS NOT NULL', 'ONHAND');
597:
598: inv_mwb_query_manager.add_group_clause('msn.serial_number', 'ONHAND');
599: inv_mwb_query_manager.add_group_clause('msn.current_organization_id', 'ONHAND');
600: inv_mwb_query_manager.add_group_clause('msn.inventory_item_id', 'ONHAND');
594: inv_mwb_query_manager.add_where_clause('msn.current_status = 3', 'ONHAND');
595: inv_mwb_query_manager.add_where_clause('msn.lot_number = mln.lot_number', 'ONHAND');
596: inv_mwb_query_manager.add_where_clause('mln.grade_code IS NOT NULL', 'ONHAND');
597:
598: inv_mwb_query_manager.add_group_clause('msn.serial_number', 'ONHAND');
599: inv_mwb_query_manager.add_group_clause('msn.current_organization_id', 'ONHAND');
600: inv_mwb_query_manager.add_group_clause('msn.inventory_item_id', 'ONHAND');
601: inv_mwb_query_manager.add_group_clause('msn.planning_organization_id', 'ONHAND');
602: inv_mwb_query_manager.add_group_clause('msn.planning_tp_type', 'ONHAND');
595: inv_mwb_query_manager.add_where_clause('msn.lot_number = mln.lot_number', 'ONHAND');
596: inv_mwb_query_manager.add_where_clause('mln.grade_code IS NOT NULL', 'ONHAND');
597:
598: inv_mwb_query_manager.add_group_clause('msn.serial_number', 'ONHAND');
599: inv_mwb_query_manager.add_group_clause('msn.current_organization_id', 'ONHAND');
600: inv_mwb_query_manager.add_group_clause('msn.inventory_item_id', 'ONHAND');
601: inv_mwb_query_manager.add_group_clause('msn.planning_organization_id', 'ONHAND');
602: inv_mwb_query_manager.add_group_clause('msn.planning_tp_type', 'ONHAND');
603: inv_mwb_query_manager.add_group_clause('msn.owning_organization_id', 'ONHAND');
596: inv_mwb_query_manager.add_where_clause('mln.grade_code IS NOT NULL', 'ONHAND');
597:
598: inv_mwb_query_manager.add_group_clause('msn.serial_number', 'ONHAND');
599: inv_mwb_query_manager.add_group_clause('msn.current_organization_id', 'ONHAND');
600: inv_mwb_query_manager.add_group_clause('msn.inventory_item_id', 'ONHAND');
601: inv_mwb_query_manager.add_group_clause('msn.planning_organization_id', 'ONHAND');
602: inv_mwb_query_manager.add_group_clause('msn.planning_tp_type', 'ONHAND');
603: inv_mwb_query_manager.add_group_clause('msn.owning_organization_id', 'ONHAND');
604: inv_mwb_query_manager.add_group_clause('msn.owning_tp_type', 'ONHAND');
597:
598: inv_mwb_query_manager.add_group_clause('msn.serial_number', 'ONHAND');
599: inv_mwb_query_manager.add_group_clause('msn.current_organization_id', 'ONHAND');
600: inv_mwb_query_manager.add_group_clause('msn.inventory_item_id', 'ONHAND');
601: inv_mwb_query_manager.add_group_clause('msn.planning_organization_id', 'ONHAND');
602: inv_mwb_query_manager.add_group_clause('msn.planning_tp_type', 'ONHAND');
603: inv_mwb_query_manager.add_group_clause('msn.owning_organization_id', 'ONHAND');
604: inv_mwb_query_manager.add_group_clause('msn.owning_tp_type', 'ONHAND');
605: inv_mwb_query_manager.add_group_clause('mln.grade_code', 'ONHAND');
598: inv_mwb_query_manager.add_group_clause('msn.serial_number', 'ONHAND');
599: inv_mwb_query_manager.add_group_clause('msn.current_organization_id', 'ONHAND');
600: inv_mwb_query_manager.add_group_clause('msn.inventory_item_id', 'ONHAND');
601: inv_mwb_query_manager.add_group_clause('msn.planning_organization_id', 'ONHAND');
602: inv_mwb_query_manager.add_group_clause('msn.planning_tp_type', 'ONHAND');
603: inv_mwb_query_manager.add_group_clause('msn.owning_organization_id', 'ONHAND');
604: inv_mwb_query_manager.add_group_clause('msn.owning_tp_type', 'ONHAND');
605: inv_mwb_query_manager.add_group_clause('mln.grade_code', 'ONHAND');
606:
599: inv_mwb_query_manager.add_group_clause('msn.current_organization_id', 'ONHAND');
600: inv_mwb_query_manager.add_group_clause('msn.inventory_item_id', 'ONHAND');
601: inv_mwb_query_manager.add_group_clause('msn.planning_organization_id', 'ONHAND');
602: inv_mwb_query_manager.add_group_clause('msn.planning_tp_type', 'ONHAND');
603: inv_mwb_query_manager.add_group_clause('msn.owning_organization_id', 'ONHAND');
604: inv_mwb_query_manager.add_group_clause('msn.owning_tp_type', 'ONHAND');
605: inv_mwb_query_manager.add_group_clause('mln.grade_code', 'ONHAND');
606:
607:
600: inv_mwb_query_manager.add_group_clause('msn.inventory_item_id', 'ONHAND');
601: inv_mwb_query_manager.add_group_clause('msn.planning_organization_id', 'ONHAND');
602: inv_mwb_query_manager.add_group_clause('msn.planning_tp_type', 'ONHAND');
603: inv_mwb_query_manager.add_group_clause('msn.owning_organization_id', 'ONHAND');
604: inv_mwb_query_manager.add_group_clause('msn.owning_tp_type', 'ONHAND');
605: inv_mwb_query_manager.add_group_clause('mln.grade_code', 'ONHAND');
606:
607:
608:
601: inv_mwb_query_manager.add_group_clause('msn.planning_organization_id', 'ONHAND');
602: inv_mwb_query_manager.add_group_clause('msn.planning_tp_type', 'ONHAND');
603: inv_mwb_query_manager.add_group_clause('msn.owning_organization_id', 'ONHAND');
604: inv_mwb_query_manager.add_group_clause('msn.owning_tp_type', 'ONHAND');
605: inv_mwb_query_manager.add_group_clause('mln.grade_code', 'ONHAND');
606:
607:
608:
609: WHEN 'MOQD' THEN
607:
608:
609: WHEN 'MOQD' THEN
610:
611: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ORG_ID).column_value :=
612: 'moqd.organization_id';
613:
614: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ITEM_ID).column_value :=
615: 'moqd.inventory_item_id';
610:
611: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ORG_ID).column_value :=
612: 'moqd.organization_id';
613:
614: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ITEM_ID).column_value :=
615: 'moqd.inventory_item_id';
616:
617: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.owning_organization_id).column_value :=
618: 'moqd.owning_organization_id';
613:
614: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ITEM_ID).column_value :=
615: 'moqd.inventory_item_id';
616:
617: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.owning_organization_id).column_value :=
618: 'moqd.owning_organization_id';
619:
620: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.planning_organization_id).column_value :=
621: 'moqd.planning_organization_id';
616:
617: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.owning_organization_id).column_value :=
618: 'moqd.owning_organization_id';
619:
620: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.planning_organization_id).column_value :=
621: 'moqd.planning_organization_id';
622:
623: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.owning_tp_type).column_value :=
624: 'moqd.owning_tp_type';
619:
620: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.planning_organization_id).column_value :=
621: 'moqd.planning_organization_id';
622:
623: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.owning_tp_type).column_value :=
624: 'moqd.owning_tp_type';
625:
626: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.planning_tp_type).column_value :=
627: 'moqd.planning_tp_type';
622:
623: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.owning_tp_type).column_value :=
624: 'moqd.owning_tp_type';
625:
626: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.planning_tp_type).column_value :=
627: 'moqd.planning_tp_type';
628:
629: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.GRADE_CODE).column_value :=
630: 'mln.grade_code';
625:
626: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.planning_tp_type).column_value :=
627: 'moqd.planning_tp_type';
628:
629: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.GRADE_CODE).column_value :=
630: 'mln.grade_code';
631:
632: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SECONDARY_UOM_CODE).column_value :=
633: 'moqd.secondary_uom_code';
628:
629: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.GRADE_CODE).column_value :=
630: 'mln.grade_code';
631:
632: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SECONDARY_UOM_CODE).column_value :=
633: 'moqd.secondary_uom_code';
634:
635: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ONHAND).column_value :=
636: 'SUM(moqd.primary_transaction_quantity)';
631:
632: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SECONDARY_UOM_CODE).column_value :=
633: 'moqd.secondary_uom_code';
634:
635: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ONHAND).column_value :=
636: 'SUM(moqd.primary_transaction_quantity)';
637:
638: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PACKED).column_value :=
639: 'SUM(DECODE(moqd.containerized_flag, 1, moqd.primary_transaction_quantity, 0))';
634:
635: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ONHAND).column_value :=
636: 'SUM(moqd.primary_transaction_quantity)';
637:
638: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PACKED).column_value :=
639: 'SUM(DECODE(moqd.containerized_flag, 1, moqd.primary_transaction_quantity, 0))';
640:
641: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.UNPACKED).column_value :=
642: 'SUM(DECODE(moqd.containerized_flag, 1, 0, moqd.primary_transaction_quantity))';
637:
638: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PACKED).column_value :=
639: 'SUM(DECODE(moqd.containerized_flag, 1, moqd.primary_transaction_quantity, 0))';
640:
641: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.UNPACKED).column_value :=
642: 'SUM(DECODE(moqd.containerized_flag, 1, 0, moqd.primary_transaction_quantity))';
643:
644: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SECONDARY_ONHAND).column_value :=
645: 'SUM(moqd.secondary_transaction_quantity)';
640:
641: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.UNPACKED).column_value :=
642: 'SUM(DECODE(moqd.containerized_flag, 1, 0, moqd.primary_transaction_quantity))';
643:
644: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SECONDARY_ONHAND).column_value :=
645: 'SUM(moqd.secondary_transaction_quantity)';
646:
647: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SECONDARY_PACKED).column_value :=
648: 'SUM(DECODE(moqd.containerized_flag, 1, moqd.secondary_transaction_quantity, 0))';
643:
644: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SECONDARY_ONHAND).column_value :=
645: 'SUM(moqd.secondary_transaction_quantity)';
646:
647: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SECONDARY_PACKED).column_value :=
648: 'SUM(DECODE(moqd.containerized_flag, 1, moqd.secondary_transaction_quantity, 0))';
649:
650: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SECONDARY_UNPACKED).column_value :=
651: 'SUM(DECODE(moqd.containerized_flag, 1, 0, moqd.secondary_transaction_quantity))';
646:
647: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SECONDARY_PACKED).column_value :=
648: 'SUM(DECODE(moqd.containerized_flag, 1, moqd.secondary_transaction_quantity, 0))';
649:
650: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SECONDARY_UNPACKED).column_value :=
651: 'SUM(DECODE(moqd.containerized_flag, 1, 0, moqd.secondary_transaction_quantity))';
652:
653: inv_mwb_query_manager.add_from_clause('mtl_onhand_quantities_detail moqd', 'ONHAND');
654: inv_mwb_query_manager.add_from_clause('mtl_lot_numbers mln', 'ONHAND');
649:
650: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SECONDARY_UNPACKED).column_value :=
651: 'SUM(DECODE(moqd.containerized_flag, 1, 0, moqd.secondary_transaction_quantity))';
652:
653: inv_mwb_query_manager.add_from_clause('mtl_onhand_quantities_detail moqd', 'ONHAND');
654: inv_mwb_query_manager.add_from_clause('mtl_lot_numbers mln', 'ONHAND');
655: inv_mwb_query_manager.add_where_clause('moqd.lot_number = mln.lot_number', 'ONHAND');
656: inv_mwb_query_manager.add_where_clause('mln.grade_code IS NOT NULL', 'ONHAND');
657: inv_mwb_query_manager.add_where_clause('moqd.inventory_item_id = mln.inventory_item_id', 'ONHAND');
650: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SECONDARY_UNPACKED).column_value :=
651: 'SUM(DECODE(moqd.containerized_flag, 1, 0, moqd.secondary_transaction_quantity))';
652:
653: inv_mwb_query_manager.add_from_clause('mtl_onhand_quantities_detail moqd', 'ONHAND');
654: inv_mwb_query_manager.add_from_clause('mtl_lot_numbers mln', 'ONHAND');
655: inv_mwb_query_manager.add_where_clause('moqd.lot_number = mln.lot_number', 'ONHAND');
656: inv_mwb_query_manager.add_where_clause('mln.grade_code IS NOT NULL', 'ONHAND');
657: inv_mwb_query_manager.add_where_clause('moqd.inventory_item_id = mln.inventory_item_id', 'ONHAND');
658: inv_mwb_query_manager.add_where_clause('moqd.organization_id = mln.organization_id', 'ONHAND');
651: 'SUM(DECODE(moqd.containerized_flag, 1, 0, moqd.secondary_transaction_quantity))';
652:
653: inv_mwb_query_manager.add_from_clause('mtl_onhand_quantities_detail moqd', 'ONHAND');
654: inv_mwb_query_manager.add_from_clause('mtl_lot_numbers mln', 'ONHAND');
655: inv_mwb_query_manager.add_where_clause('moqd.lot_number = mln.lot_number', 'ONHAND');
656: inv_mwb_query_manager.add_where_clause('mln.grade_code IS NOT NULL', 'ONHAND');
657: inv_mwb_query_manager.add_where_clause('moqd.inventory_item_id = mln.inventory_item_id', 'ONHAND');
658: inv_mwb_query_manager.add_where_clause('moqd.organization_id = mln.organization_id', 'ONHAND');
659:
652:
653: inv_mwb_query_manager.add_from_clause('mtl_onhand_quantities_detail moqd', 'ONHAND');
654: inv_mwb_query_manager.add_from_clause('mtl_lot_numbers mln', 'ONHAND');
655: inv_mwb_query_manager.add_where_clause('moqd.lot_number = mln.lot_number', 'ONHAND');
656: inv_mwb_query_manager.add_where_clause('mln.grade_code IS NOT NULL', 'ONHAND');
657: inv_mwb_query_manager.add_where_clause('moqd.inventory_item_id = mln.inventory_item_id', 'ONHAND');
658: inv_mwb_query_manager.add_where_clause('moqd.organization_id = mln.organization_id', 'ONHAND');
659:
660: inv_mwb_query_manager.add_group_clause('moqd.organization_id', 'ONHAND');
653: inv_mwb_query_manager.add_from_clause('mtl_onhand_quantities_detail moqd', 'ONHAND');
654: inv_mwb_query_manager.add_from_clause('mtl_lot_numbers mln', 'ONHAND');
655: inv_mwb_query_manager.add_where_clause('moqd.lot_number = mln.lot_number', 'ONHAND');
656: inv_mwb_query_manager.add_where_clause('mln.grade_code IS NOT NULL', 'ONHAND');
657: inv_mwb_query_manager.add_where_clause('moqd.inventory_item_id = mln.inventory_item_id', 'ONHAND');
658: inv_mwb_query_manager.add_where_clause('moqd.organization_id = mln.organization_id', 'ONHAND');
659:
660: inv_mwb_query_manager.add_group_clause('moqd.organization_id', 'ONHAND');
661: inv_mwb_query_manager.add_group_clause('moqd.inventory_item_id', 'ONHAND');
654: inv_mwb_query_manager.add_from_clause('mtl_lot_numbers mln', 'ONHAND');
655: inv_mwb_query_manager.add_where_clause('moqd.lot_number = mln.lot_number', 'ONHAND');
656: inv_mwb_query_manager.add_where_clause('mln.grade_code IS NOT NULL', 'ONHAND');
657: inv_mwb_query_manager.add_where_clause('moqd.inventory_item_id = mln.inventory_item_id', 'ONHAND');
658: inv_mwb_query_manager.add_where_clause('moqd.organization_id = mln.organization_id', 'ONHAND');
659:
660: inv_mwb_query_manager.add_group_clause('moqd.organization_id', 'ONHAND');
661: inv_mwb_query_manager.add_group_clause('moqd.inventory_item_id', 'ONHAND');
662: inv_mwb_query_manager.add_group_clause('moqd.planning_organization_id', 'ONHAND');
656: inv_mwb_query_manager.add_where_clause('mln.grade_code IS NOT NULL', 'ONHAND');
657: inv_mwb_query_manager.add_where_clause('moqd.inventory_item_id = mln.inventory_item_id', 'ONHAND');
658: inv_mwb_query_manager.add_where_clause('moqd.organization_id = mln.organization_id', 'ONHAND');
659:
660: inv_mwb_query_manager.add_group_clause('moqd.organization_id', 'ONHAND');
661: inv_mwb_query_manager.add_group_clause('moqd.inventory_item_id', 'ONHAND');
662: inv_mwb_query_manager.add_group_clause('moqd.planning_organization_id', 'ONHAND');
663: inv_mwb_query_manager.add_group_clause('moqd.planning_tp_type', 'ONHAND');
664: inv_mwb_query_manager.add_group_clause('moqd.owning_organization_id', 'ONHAND');
657: inv_mwb_query_manager.add_where_clause('moqd.inventory_item_id = mln.inventory_item_id', 'ONHAND');
658: inv_mwb_query_manager.add_where_clause('moqd.organization_id = mln.organization_id', 'ONHAND');
659:
660: inv_mwb_query_manager.add_group_clause('moqd.organization_id', 'ONHAND');
661: inv_mwb_query_manager.add_group_clause('moqd.inventory_item_id', 'ONHAND');
662: inv_mwb_query_manager.add_group_clause('moqd.planning_organization_id', 'ONHAND');
663: inv_mwb_query_manager.add_group_clause('moqd.planning_tp_type', 'ONHAND');
664: inv_mwb_query_manager.add_group_clause('moqd.owning_organization_id', 'ONHAND');
665: inv_mwb_query_manager.add_group_clause('moqd.owning_tp_type', 'ONHAND');
658: inv_mwb_query_manager.add_where_clause('moqd.organization_id = mln.organization_id', 'ONHAND');
659:
660: inv_mwb_query_manager.add_group_clause('moqd.organization_id', 'ONHAND');
661: inv_mwb_query_manager.add_group_clause('moqd.inventory_item_id', 'ONHAND');
662: inv_mwb_query_manager.add_group_clause('moqd.planning_organization_id', 'ONHAND');
663: inv_mwb_query_manager.add_group_clause('moqd.planning_tp_type', 'ONHAND');
664: inv_mwb_query_manager.add_group_clause('moqd.owning_organization_id', 'ONHAND');
665: inv_mwb_query_manager.add_group_clause('moqd.owning_tp_type', 'ONHAND');
666: inv_mwb_query_manager.add_group_clause('mln.grade_code', 'ONHAND');
659:
660: inv_mwb_query_manager.add_group_clause('moqd.organization_id', 'ONHAND');
661: inv_mwb_query_manager.add_group_clause('moqd.inventory_item_id', 'ONHAND');
662: inv_mwb_query_manager.add_group_clause('moqd.planning_organization_id', 'ONHAND');
663: inv_mwb_query_manager.add_group_clause('moqd.planning_tp_type', 'ONHAND');
664: inv_mwb_query_manager.add_group_clause('moqd.owning_organization_id', 'ONHAND');
665: inv_mwb_query_manager.add_group_clause('moqd.owning_tp_type', 'ONHAND');
666: inv_mwb_query_manager.add_group_clause('mln.grade_code', 'ONHAND');
667: inv_mwb_query_manager.add_group_clause('moqd.secondary_uom_code', 'ONHAND');
660: inv_mwb_query_manager.add_group_clause('moqd.organization_id', 'ONHAND');
661: inv_mwb_query_manager.add_group_clause('moqd.inventory_item_id', 'ONHAND');
662: inv_mwb_query_manager.add_group_clause('moqd.planning_organization_id', 'ONHAND');
663: inv_mwb_query_manager.add_group_clause('moqd.planning_tp_type', 'ONHAND');
664: inv_mwb_query_manager.add_group_clause('moqd.owning_organization_id', 'ONHAND');
665: inv_mwb_query_manager.add_group_clause('moqd.owning_tp_type', 'ONHAND');
666: inv_mwb_query_manager.add_group_clause('mln.grade_code', 'ONHAND');
667: inv_mwb_query_manager.add_group_clause('moqd.secondary_uom_code', 'ONHAND');
668:
661: inv_mwb_query_manager.add_group_clause('moqd.inventory_item_id', 'ONHAND');
662: inv_mwb_query_manager.add_group_clause('moqd.planning_organization_id', 'ONHAND');
663: inv_mwb_query_manager.add_group_clause('moqd.planning_tp_type', 'ONHAND');
664: inv_mwb_query_manager.add_group_clause('moqd.owning_organization_id', 'ONHAND');
665: inv_mwb_query_manager.add_group_clause('moqd.owning_tp_type', 'ONHAND');
666: inv_mwb_query_manager.add_group_clause('mln.grade_code', 'ONHAND');
667: inv_mwb_query_manager.add_group_clause('moqd.secondary_uom_code', 'ONHAND');
668:
669:
662: inv_mwb_query_manager.add_group_clause('moqd.planning_organization_id', 'ONHAND');
663: inv_mwb_query_manager.add_group_clause('moqd.planning_tp_type', 'ONHAND');
664: inv_mwb_query_manager.add_group_clause('moqd.owning_organization_id', 'ONHAND');
665: inv_mwb_query_manager.add_group_clause('moqd.owning_tp_type', 'ONHAND');
666: inv_mwb_query_manager.add_group_clause('mln.grade_code', 'ONHAND');
667: inv_mwb_query_manager.add_group_clause('moqd.secondary_uom_code', 'ONHAND');
668:
669:
670:
663: inv_mwb_query_manager.add_group_clause('moqd.planning_tp_type', 'ONHAND');
664: inv_mwb_query_manager.add_group_clause('moqd.owning_organization_id', 'ONHAND');
665: inv_mwb_query_manager.add_group_clause('moqd.owning_tp_type', 'ONHAND');
666: inv_mwb_query_manager.add_group_clause('mln.grade_code', 'ONHAND');
667: inv_mwb_query_manager.add_group_clause('moqd.secondary_uom_code', 'ONHAND');
668:
669:
670:
671: WHEN 'MSN_QUERY' THEN
670:
671: WHEN 'MSN_QUERY' THEN
672:
673:
674: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ITEM_ID).column_value :=
675: 'msn.inventory_item_id';
676:
677: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ORG_ID).column_value :=
678: 'msn.current_organization_id';
673:
674: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ITEM_ID).column_value :=
675: 'msn.inventory_item_id';
676:
677: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ORG_ID).column_value :=
678: 'msn.current_organization_id';
679:
680: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PRIMARY_UOM_CODE).column_value :=
681: '''Ea''';
676:
677: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ORG_ID).column_value :=
678: 'msn.current_organization_id';
679:
680: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PRIMARY_UOM_CODE).column_value :=
681: '''Ea''';
682:
683: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ONHAND).column_value :=
684: 'count(1)';
679:
680: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PRIMARY_UOM_CODE).column_value :=
681: '''Ea''';
682:
683: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ONHAND).column_value :=
684: 'count(1)';
685:
686: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PACKED).column_value :=
687: 'SUM(DECODE(msn.lpn_id, NULL, 0,1))';
682:
683: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ONHAND).column_value :=
684: 'count(1)';
685:
686: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PACKED).column_value :=
687: 'SUM(DECODE(msn.lpn_id, NULL, 0,1))';
688:
689: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.UNPACKED).column_value :=
690: 'SUM(DECODE(msn.lpn_id, NULL, 1,0))';
685:
686: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PACKED).column_value :=
687: 'SUM(DECODE(msn.lpn_id, NULL, 0,1))';
688:
689: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.UNPACKED).column_value :=
690: 'SUM(DECODE(msn.lpn_id, NULL, 1,0))';
691:
692: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.owning_organization_id).column_value :=
693: 'msn.owning_organization_id';
688:
689: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.UNPACKED).column_value :=
690: 'SUM(DECODE(msn.lpn_id, NULL, 1,0))';
691:
692: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.owning_organization_id).column_value :=
693: 'msn.owning_organization_id';
694:
695: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.planning_organization_id).column_value :=
696: 'msn.planning_organization_id';
691:
692: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.owning_organization_id).column_value :=
693: 'msn.owning_organization_id';
694:
695: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.planning_organization_id).column_value :=
696: 'msn.planning_organization_id';
697:
698: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.owning_tp_type).column_value :=
699: 'msn.owning_tp_type';
694:
695: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.planning_organization_id).column_value :=
696: 'msn.planning_organization_id';
697:
698: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.owning_tp_type).column_value :=
699: 'msn.owning_tp_type';
700:
701: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.planning_tp_type).column_value :=
702: 'msn.planning_tp_type';
697:
698: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.owning_tp_type).column_value :=
699: 'msn.owning_tp_type';
700:
701: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.planning_tp_type).column_value :=
702: 'msn.planning_tp_type';
703:
704: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.GRADE_CODE).column_value :=
705: 'mln.grade_code';
700:
701: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.planning_tp_type).column_value :=
702: 'msn.planning_tp_type';
703:
704: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.GRADE_CODE).column_value :=
705: 'mln.grade_code';
706:
707: inv_mwb_query_manager.add_from_clause('mtl_serial_numbers msn', 'ONHAND');
708: inv_mwb_query_manager.add_from_clause('mtl_lot_numbers mln', 'ONHAND');
703:
704: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.GRADE_CODE).column_value :=
705: 'mln.grade_code';
706:
707: inv_mwb_query_manager.add_from_clause('mtl_serial_numbers msn', 'ONHAND');
708: inv_mwb_query_manager.add_from_clause('mtl_lot_numbers mln', 'ONHAND');
709:
710: inv_mwb_query_manager.add_where_clause('msn.current_status = 3', 'ONHAND');
711: inv_mwb_query_manager.add_where_clause('msn.lot_number = mln.lot_number', 'ONHAND');
704: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.GRADE_CODE).column_value :=
705: 'mln.grade_code';
706:
707: inv_mwb_query_manager.add_from_clause('mtl_serial_numbers msn', 'ONHAND');
708: inv_mwb_query_manager.add_from_clause('mtl_lot_numbers mln', 'ONHAND');
709:
710: inv_mwb_query_manager.add_where_clause('msn.current_status = 3', 'ONHAND');
711: inv_mwb_query_manager.add_where_clause('msn.lot_number = mln.lot_number', 'ONHAND');
712: inv_mwb_query_manager.add_where_clause('mln.grade_code IS NOT NULL', 'ONHAND');
706:
707: inv_mwb_query_manager.add_from_clause('mtl_serial_numbers msn', 'ONHAND');
708: inv_mwb_query_manager.add_from_clause('mtl_lot_numbers mln', 'ONHAND');
709:
710: inv_mwb_query_manager.add_where_clause('msn.current_status = 3', 'ONHAND');
711: inv_mwb_query_manager.add_where_clause('msn.lot_number = mln.lot_number', 'ONHAND');
712: inv_mwb_query_manager.add_where_clause('mln.grade_code IS NOT NULL', 'ONHAND');
713:
714: inv_mwb_query_manager.add_group_clause('msn.current_organization_id', 'ONHAND');
707: inv_mwb_query_manager.add_from_clause('mtl_serial_numbers msn', 'ONHAND');
708: inv_mwb_query_manager.add_from_clause('mtl_lot_numbers mln', 'ONHAND');
709:
710: inv_mwb_query_manager.add_where_clause('msn.current_status = 3', 'ONHAND');
711: inv_mwb_query_manager.add_where_clause('msn.lot_number = mln.lot_number', 'ONHAND');
712: inv_mwb_query_manager.add_where_clause('mln.grade_code IS NOT NULL', 'ONHAND');
713:
714: inv_mwb_query_manager.add_group_clause('msn.current_organization_id', 'ONHAND');
715: inv_mwb_query_manager.add_group_clause('msn.inventory_item_id', 'ONHAND');
708: inv_mwb_query_manager.add_from_clause('mtl_lot_numbers mln', 'ONHAND');
709:
710: inv_mwb_query_manager.add_where_clause('msn.current_status = 3', 'ONHAND');
711: inv_mwb_query_manager.add_where_clause('msn.lot_number = mln.lot_number', 'ONHAND');
712: inv_mwb_query_manager.add_where_clause('mln.grade_code IS NOT NULL', 'ONHAND');
713:
714: inv_mwb_query_manager.add_group_clause('msn.current_organization_id', 'ONHAND');
715: inv_mwb_query_manager.add_group_clause('msn.inventory_item_id', 'ONHAND');
716: inv_mwb_query_manager.add_group_clause('msn.planning_organization_id', 'ONHAND');
710: inv_mwb_query_manager.add_where_clause('msn.current_status = 3', 'ONHAND');
711: inv_mwb_query_manager.add_where_clause('msn.lot_number = mln.lot_number', 'ONHAND');
712: inv_mwb_query_manager.add_where_clause('mln.grade_code IS NOT NULL', 'ONHAND');
713:
714: inv_mwb_query_manager.add_group_clause('msn.current_organization_id', 'ONHAND');
715: inv_mwb_query_manager.add_group_clause('msn.inventory_item_id', 'ONHAND');
716: inv_mwb_query_manager.add_group_clause('msn.planning_organization_id', 'ONHAND');
717: inv_mwb_query_manager.add_group_clause('msn.planning_tp_type', 'ONHAND');
718: inv_mwb_query_manager.add_group_clause('msn.owning_organization_id', 'ONHAND');
711: inv_mwb_query_manager.add_where_clause('msn.lot_number = mln.lot_number', 'ONHAND');
712: inv_mwb_query_manager.add_where_clause('mln.grade_code IS NOT NULL', 'ONHAND');
713:
714: inv_mwb_query_manager.add_group_clause('msn.current_organization_id', 'ONHAND');
715: inv_mwb_query_manager.add_group_clause('msn.inventory_item_id', 'ONHAND');
716: inv_mwb_query_manager.add_group_clause('msn.planning_organization_id', 'ONHAND');
717: inv_mwb_query_manager.add_group_clause('msn.planning_tp_type', 'ONHAND');
718: inv_mwb_query_manager.add_group_clause('msn.owning_organization_id', 'ONHAND');
719: inv_mwb_query_manager.add_group_clause('msn.owning_tp_type', 'ONHAND');
712: inv_mwb_query_manager.add_where_clause('mln.grade_code IS NOT NULL', 'ONHAND');
713:
714: inv_mwb_query_manager.add_group_clause('msn.current_organization_id', 'ONHAND');
715: inv_mwb_query_manager.add_group_clause('msn.inventory_item_id', 'ONHAND');
716: inv_mwb_query_manager.add_group_clause('msn.planning_organization_id', 'ONHAND');
717: inv_mwb_query_manager.add_group_clause('msn.planning_tp_type', 'ONHAND');
718: inv_mwb_query_manager.add_group_clause('msn.owning_organization_id', 'ONHAND');
719: inv_mwb_query_manager.add_group_clause('msn.owning_tp_type', 'ONHAND');
720: inv_mwb_query_manager.add_group_clause('mln.grade_code', 'ONHAND');
713:
714: inv_mwb_query_manager.add_group_clause('msn.current_organization_id', 'ONHAND');
715: inv_mwb_query_manager.add_group_clause('msn.inventory_item_id', 'ONHAND');
716: inv_mwb_query_manager.add_group_clause('msn.planning_organization_id', 'ONHAND');
717: inv_mwb_query_manager.add_group_clause('msn.planning_tp_type', 'ONHAND');
718: inv_mwb_query_manager.add_group_clause('msn.owning_organization_id', 'ONHAND');
719: inv_mwb_query_manager.add_group_clause('msn.owning_tp_type', 'ONHAND');
720: inv_mwb_query_manager.add_group_clause('mln.grade_code', 'ONHAND');
721:
714: inv_mwb_query_manager.add_group_clause('msn.current_organization_id', 'ONHAND');
715: inv_mwb_query_manager.add_group_clause('msn.inventory_item_id', 'ONHAND');
716: inv_mwb_query_manager.add_group_clause('msn.planning_organization_id', 'ONHAND');
717: inv_mwb_query_manager.add_group_clause('msn.planning_tp_type', 'ONHAND');
718: inv_mwb_query_manager.add_group_clause('msn.owning_organization_id', 'ONHAND');
719: inv_mwb_query_manager.add_group_clause('msn.owning_tp_type', 'ONHAND');
720: inv_mwb_query_manager.add_group_clause('mln.grade_code', 'ONHAND');
721:
722:
715: inv_mwb_query_manager.add_group_clause('msn.inventory_item_id', 'ONHAND');
716: inv_mwb_query_manager.add_group_clause('msn.planning_organization_id', 'ONHAND');
717: inv_mwb_query_manager.add_group_clause('msn.planning_tp_type', 'ONHAND');
718: inv_mwb_query_manager.add_group_clause('msn.owning_organization_id', 'ONHAND');
719: inv_mwb_query_manager.add_group_clause('msn.owning_tp_type', 'ONHAND');
720: inv_mwb_query_manager.add_group_clause('mln.grade_code', 'ONHAND');
721:
722:
723: END CASE; -- p_flag
716: inv_mwb_query_manager.add_group_clause('msn.planning_organization_id', 'ONHAND');
717: inv_mwb_query_manager.add_group_clause('msn.planning_tp_type', 'ONHAND');
718: inv_mwb_query_manager.add_group_clause('msn.owning_organization_id', 'ONHAND');
719: inv_mwb_query_manager.add_group_clause('msn.owning_tp_type', 'ONHAND');
720: inv_mwb_query_manager.add_group_clause('mln.grade_code', 'ONHAND');
721:
722:
723: END CASE; -- p_flag
724: