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_GRADE_TREE dependencies on INV_MWB_QUERY_MANAGER

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

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;

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

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:

Line 40: inv_mwb_query_manager.execute_query;

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

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

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;

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

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;

Line 80: inv_mwb_query_manager.add_where_clause('mln.grade_code = :onh_tree_grade_code ', 'ONHAND');

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;

Line 81: inv_mwb_query_manager.add_bind_variable('onh_tree_grade_code', inv_mwb_globals.g_tree_grade_code);

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:

Line 82: inv_mwb_query_manager.execute_query;

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

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

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:

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

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',

Line 124: inv_mwb_query_manager.add_group_clause(

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(

Line 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:

Line 133: inv_mwb_query_manager.add_where_clause(

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');

Line 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';

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

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';

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

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',

Line 146: inv_mwb_query_manager.add_group_clause(

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:

Line 151: inv_mwb_query_manager.add_group_clause(

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:

Line 156: inv_mwb_query_manager.add_where_clause(

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:

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

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:

Line 166: inv_mwb_query_manager.add_where_clause(

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:

Line 171: inv_mwb_query_manager.add_bind_variable(

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:

Line 176: inv_mwb_query_manager.add_bind_variable(

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:

Line 181: inv_mwb_query_manager.execute_query;

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

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

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 :=

Line 220: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ITEM_ID).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:

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

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',

Line 225: inv_mwb_query_manager.add_group_clause(

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(

Line 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(

Line 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(

Line 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(

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.inventory_item_id = :onh_tree_inventory_item_id ',
243: 'ONHAND'
244: );
245: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');

Line 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';

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

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';

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

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';

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

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',

Line 257: inv_mwb_query_manager.add_group_clause(

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:

Line 262: inv_mwb_query_manager.add_where_clause(

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(

Line 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(

Line 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(

Line 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:

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

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'

Line 282: inv_mwb_query_manager.add_where_clause(

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:

Line 287: inv_mwb_query_manager.add_bind_variable(

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:

Line 292: inv_mwb_query_manager.add_bind_variable(

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:

Line 297: inv_mwb_query_manager.add_bind_variable(

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:

Line 302: inv_mwb_query_manager.execute_query;

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

Line 342: inv_mwb_query_manager.add_where_clause(

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(

Line 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(

Line 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');

Line 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

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

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 :=

Line 363: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ITEM_ID).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:

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

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',

Line 368: inv_mwb_query_manager.add_group_clause(

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(

Line 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(

Line 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(

Line 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(

Line 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(

Line 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:

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

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 :=

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: 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';

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

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';

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

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',

Line 406: inv_mwb_query_manager.add_group_clause(

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:

Line 411: inv_mwb_query_manager.add_where_clause(

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(

Line 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(

Line 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:

Line 424: inv_mwb_query_manager.add_group_clause(

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(

Line 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(

Line 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');

Line 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 :=

Line 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'

Line 442: inv_mwb_query_manager.add_where_clause(

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:

Line 447: inv_mwb_query_manager.add_bind_variable(

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:

Line 452: inv_mwb_query_manager.add_bind_variable(

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:

Line 457: inv_mwb_query_manager.add_bind_variable(

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(

Line 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:

Line 466: inv_mwb_query_manager.execute_query;

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

Line 489: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.GRADE_CODE).column_value :=

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(

Line 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(

Line 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(

Line 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(

Line 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(

Line 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(

Line 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:

Line 518: inv_mwb_query_manager.add_bind_variable(

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:

Line 523: inv_mwb_query_manager.add_bind_variable(

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(

Line 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(

Line 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:

Line 536: inv_mwb_query_manager.execute_query;

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

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

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';

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

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''';

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

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:

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

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:

Line 567: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PACKED).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:
570: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.UNPACKED).column_value :=
571: 'SUM(DECODE(msn.lpn_id, NULL, 1,0))';

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

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';

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

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';

Line 576: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.owning_organization_id).column_value :=

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';

Line 579: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.planning_organization_id).column_value :=

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';

Line 582: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.owning_tp_type).column_value :=

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';

Line 585: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.planning_tp_type).column_value :=

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';

Line 588: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.GRADE_CODE).column_value :=

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');

Line 591: inv_mwb_query_manager.add_from_clause('mtl_serial_numbers msn', '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');

Line 592: inv_mwb_query_manager.add_from_clause('mtl_lot_numbers mln', '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');

Line 594: inv_mwb_query_manager.add_where_clause('msn.current_status = 3', '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');

Line 595: inv_mwb_query_manager.add_where_clause('msn.lot_number = mln.lot_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');

Line 596: inv_mwb_query_manager.add_where_clause('mln.grade_code IS NOT NULL', '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');

Line 598: inv_mwb_query_manager.add_group_clause('msn.serial_number', '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');

Line 599: inv_mwb_query_manager.add_group_clause('msn.current_organization_id', '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');

Line 600: inv_mwb_query_manager.add_group_clause('msn.inventory_item_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');

Line 601: inv_mwb_query_manager.add_group_clause('msn.planning_organization_id', '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');

Line 602: inv_mwb_query_manager.add_group_clause('msn.planning_tp_type', '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:

Line 603: inv_mwb_query_manager.add_group_clause('msn.owning_organization_id', '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:
607:

Line 604: inv_mwb_query_manager.add_group_clause('msn.owning_tp_type', '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:
608:

Line 605: inv_mwb_query_manager.add_group_clause('mln.grade_code', '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:
609: WHEN 'MOQD' THEN

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

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';

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

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';

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

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';

Line 620: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.planning_organization_id).column_value :=

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';

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

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';

Line 626: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.planning_tp_type).column_value :=

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';

Line 629: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.GRADE_CODE).column_value :=

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';

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

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)';

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

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))';

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

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))';

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

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)';

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

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))';

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

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))';

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

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');

Line 653: inv_mwb_query_manager.add_from_clause('mtl_onhand_quantities_detail moqd', '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');

Line 654: inv_mwb_query_manager.add_from_clause('mtl_lot_numbers mln', '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');

Line 655: inv_mwb_query_manager.add_where_clause('moqd.lot_number = mln.lot_number', '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:

Line 656: inv_mwb_query_manager.add_where_clause('mln.grade_code IS NOT NULL', 'ONHAND');

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');

Line 657: inv_mwb_query_manager.add_where_clause('moqd.inventory_item_id = mln.inventory_item_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');

Line 658: inv_mwb_query_manager.add_where_clause('moqd.organization_id = mln.organization_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');

Line 660: inv_mwb_query_manager.add_group_clause('moqd.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');

Line 661: inv_mwb_query_manager.add_group_clause('moqd.inventory_item_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');

Line 662: inv_mwb_query_manager.add_group_clause('moqd.planning_organization_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');
666: inv_mwb_query_manager.add_group_clause('mln.grade_code', 'ONHAND');

Line 663: inv_mwb_query_manager.add_group_clause('moqd.planning_tp_type', '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');

Line 664: inv_mwb_query_manager.add_group_clause('moqd.owning_organization_id', '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:

Line 665: inv_mwb_query_manager.add_group_clause('moqd.owning_tp_type', '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:
669:

Line 666: inv_mwb_query_manager.add_group_clause('mln.grade_code', '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:
670:

Line 667: inv_mwb_query_manager.add_group_clause('moqd.secondary_uom_code', '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:
671: WHEN 'MSN_QUERY' THEN

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

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';

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

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''';

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

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)';

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

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))';

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

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))';

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

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';

Line 692: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.owning_organization_id).column_value :=

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';

Line 695: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.planning_organization_id).column_value :=

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';

Line 698: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.owning_tp_type).column_value :=

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';

Line 701: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.planning_tp_type).column_value :=

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';

Line 704: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.GRADE_CODE).column_value :=

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');

Line 707: inv_mwb_query_manager.add_from_clause('mtl_serial_numbers msn', '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');

Line 708: inv_mwb_query_manager.add_from_clause('mtl_lot_numbers mln', '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');

Line 710: inv_mwb_query_manager.add_where_clause('msn.current_status = 3', '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');

Line 711: inv_mwb_query_manager.add_where_clause('msn.lot_number = mln.lot_number', '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');

Line 712: inv_mwb_query_manager.add_where_clause('mln.grade_code IS NOT NULL', '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');

Line 714: inv_mwb_query_manager.add_group_clause('msn.current_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');

Line 715: inv_mwb_query_manager.add_group_clause('msn.inventory_item_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');

Line 716: inv_mwb_query_manager.add_group_clause('msn.planning_organization_id', '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');

Line 717: inv_mwb_query_manager.add_group_clause('msn.planning_tp_type', '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:

Line 718: inv_mwb_query_manager.add_group_clause('msn.owning_organization_id', 'ONHAND');

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:

Line 719: inv_mwb_query_manager.add_group_clause('msn.owning_tp_type', '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:
723: END CASE; -- p_flag

Line 720: inv_mwb_query_manager.add_group_clause('mln.grade_code', '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
724: