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

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

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

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

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

Line 44: inv_mwb_query_manager.execute_query;

40: ELSE
41: make_common_queries('MOQD');
42: inv_mwb_query_manager.add_qf_where_onhand('ONHAND');
43: END IF;
44: inv_mwb_query_manager.execute_query;
45:
46: END IF; -- tree event
47:
48: EXCEPTION

Line 80: inv_mwb_query_manager.add_where_clause(

76: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL -- Bug 6429880
77: OR inv_mwb_globals.g_unit_number IS NOT NULL -- Bug 9365452
78: THEN
79: make_common_queries('MSN_QUERY');
80: inv_mwb_query_manager.add_where_clause(
81: 'msn.inventory_item_id = :onh_tree_inventory_item_id' ,
82: 'ONHAND'
83: );
84: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');

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

80: inv_mwb_query_manager.add_where_clause(
81: 'msn.inventory_item_id = :onh_tree_inventory_item_id' ,
82: 'ONHAND'
83: );
84: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
85: ELSE
86: make_common_queries('MOQD');
87: inv_mwb_query_manager.add_where_clause(
88: 'moqd.inventory_item_id = :onh_tree_inventory_item_id' ,

Line 87: inv_mwb_query_manager.add_where_clause(

83: );
84: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
85: ELSE
86: make_common_queries('MOQD');
87: inv_mwb_query_manager.add_where_clause(
88: 'moqd.inventory_item_id = :onh_tree_inventory_item_id' ,
89: 'ONHAND'
90: );
91:

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

88: 'moqd.inventory_item_id = :onh_tree_inventory_item_id' ,
89: 'ONHAND'
90: );
91:
92: inv_mwb_query_manager.add_qf_where_onhand('ONHAND');
93: END IF; -- serial
94: inv_mwb_query_manager.add_bind_variable(
95: 'onh_tree_inventory_item_id',
96: inv_mwb_globals.g_tree_item_id

Line 94: inv_mwb_query_manager.add_bind_variable(

90: );
91:
92: inv_mwb_query_manager.add_qf_where_onhand('ONHAND');
93: END IF; -- serial
94: inv_mwb_query_manager.add_bind_variable(
95: 'onh_tree_inventory_item_id',
96: inv_mwb_globals.g_tree_item_id
97: );
98: inv_mwb_query_manager.execute_query;

Line 98: inv_mwb_query_manager.execute_query;

94: inv_mwb_query_manager.add_bind_variable(
95: 'onh_tree_inventory_item_id',
96: inv_mwb_globals.g_tree_item_id
97: );
98: inv_mwb_query_manager.execute_query;
99: END IF; -- onhand
100:
101: END IF; -- node seleted
102: EXCEPTION

Line 162: inv_mwb_query_manager.add_where_clause(

158: IF NVL(l_rev_control, 1) = 1 AND NVL(l_lot_control, 1) = 1
159: AND l_serial_control IN ( 2,5 ) THEN
160:
161: make_common_queries('MSN');
162: inv_mwb_query_manager.add_where_clause(
163: 'msn.inventory_item_id = :onh_tree_inventory_item_id' ,
164: 'ONHAND'
165: );
166: inv_mwb_query_manager.add_where_clause(

Line 166: inv_mwb_query_manager.add_where_clause(

162: inv_mwb_query_manager.add_where_clause(
163: 'msn.inventory_item_id = :onh_tree_inventory_item_id' ,
164: 'ONHAND'
165: );
166: inv_mwb_query_manager.add_where_clause(
167: 'msn.current_organization_id = :onh_tree_organization_id' ,
168: 'ONHAND'
169: );
170: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');

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

166: inv_mwb_query_manager.add_where_clause(
167: 'msn.current_organization_id = :onh_tree_organization_id' ,
168: 'ONHAND'
169: );
170: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
171: ELSE -- only serial controlled
172: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
173: inv_mwb_globals.g_serial_to IS NOT NULL
174: OR inv_mwb_globals.g_status_id IS NOT NULL -- Bug 6060233

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

176: OR inv_mwb_globals.g_unit_number IS NOT NULL -- Bug 9365452
177: THEN
178: make_common_queries('MSN_QUERY');
179: IF l_rev_control = 2 THEN
180: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.revision).column_value :=
181: 'msn.revision';
182: inv_mwb_query_manager.add_group_clause('msn.revision', 'ONHAND');
183: END IF;
184: IF NVL(l_rev_control, 1) = 1 AND l_lot_control = 2 THEN

Line 182: inv_mwb_query_manager.add_group_clause('msn.revision', 'ONHAND');

178: make_common_queries('MSN_QUERY');
179: IF l_rev_control = 2 THEN
180: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.revision).column_value :=
181: 'msn.revision';
182: inv_mwb_query_manager.add_group_clause('msn.revision', 'ONHAND');
183: END IF;
184: IF NVL(l_rev_control, 1) = 1 AND l_lot_control = 2 THEN
185: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
186: 'msn.lot_number';

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

181: 'msn.revision';
182: inv_mwb_query_manager.add_group_clause('msn.revision', 'ONHAND');
183: END IF;
184: IF NVL(l_rev_control, 1) = 1 AND l_lot_control = 2 THEN
185: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
186: 'msn.lot_number';
187: inv_mwb_query_manager.add_group_clause('msn.lot_number', 'ONHAND');
188: END IF;
189: inv_mwb_query_manager.add_where_clause(

Line 187: inv_mwb_query_manager.add_group_clause('msn.lot_number', 'ONHAND');

183: END IF;
184: IF NVL(l_rev_control, 1) = 1 AND l_lot_control = 2 THEN
185: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
186: 'msn.lot_number';
187: inv_mwb_query_manager.add_group_clause('msn.lot_number', 'ONHAND');
188: END IF;
189: inv_mwb_query_manager.add_where_clause(
190: 'msn.inventory_item_id = :onh_tree_inventory_item_id' ,
191: 'ONHAND'

Line 189: inv_mwb_query_manager.add_where_clause(

185: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
186: 'msn.lot_number';
187: inv_mwb_query_manager.add_group_clause('msn.lot_number', 'ONHAND');
188: END IF;
189: inv_mwb_query_manager.add_where_clause(
190: 'msn.inventory_item_id = :onh_tree_inventory_item_id' ,
191: 'ONHAND'
192: );
193: inv_mwb_query_manager.add_where_clause(

Line 193: inv_mwb_query_manager.add_where_clause(

189: inv_mwb_query_manager.add_where_clause(
190: 'msn.inventory_item_id = :onh_tree_inventory_item_id' ,
191: 'ONHAND'
192: );
193: inv_mwb_query_manager.add_where_clause(
194: 'msn.current_organization_id = :onh_tree_organization_id' ,
195: 'ONHAND'
196: );
197: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');

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

193: inv_mwb_query_manager.add_where_clause(
194: 'msn.current_organization_id = :onh_tree_organization_id' ,
195: 'ONHAND'
196: );
197: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
198: ELSE -- serial entered in qf
199: make_common_queries('MOQD');
200: inv_mwb_query_manager.add_where_clause(
201: 'moqd.inventory_item_id = :onh_tree_inventory_item_id' ,

Line 200: inv_mwb_query_manager.add_where_clause(

196: );
197: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
198: ELSE -- serial entered in qf
199: make_common_queries('MOQD');
200: inv_mwb_query_manager.add_where_clause(
201: 'moqd.inventory_item_id = :onh_tree_inventory_item_id' ,
202: 'ONHAND'
203: );
204: inv_mwb_query_manager.add_where_clause(

Line 204: inv_mwb_query_manager.add_where_clause(

200: inv_mwb_query_manager.add_where_clause(
201: 'moqd.inventory_item_id = :onh_tree_inventory_item_id' ,
202: 'ONHAND'
203: );
204: inv_mwb_query_manager.add_where_clause(
205: 'moqd.organization_id = :onh_tree_organization_id' ,
206: 'ONHAND'
207: );
208: IF l_rev_control = 2 THEN

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

205: 'moqd.organization_id = :onh_tree_organization_id' ,
206: 'ONHAND'
207: );
208: IF l_rev_control = 2 THEN
209: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.revision).column_value :=
210: 'moqd.revision';
211: inv_mwb_query_manager.add_group_clause('moqd.revision', 'ONHAND');
212: END IF;
213: IF NVL(l_rev_control, 1) = 1 AND l_lot_control = 2 THEN

Line 211: inv_mwb_query_manager.add_group_clause('moqd.revision', 'ONHAND');

207: );
208: IF l_rev_control = 2 THEN
209: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.revision).column_value :=
210: 'moqd.revision';
211: inv_mwb_query_manager.add_group_clause('moqd.revision', 'ONHAND');
212: END IF;
213: IF NVL(l_rev_control, 1) = 1 AND l_lot_control = 2 THEN
214: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
215: 'moqd.lot_number';

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

210: 'moqd.revision';
211: inv_mwb_query_manager.add_group_clause('moqd.revision', 'ONHAND');
212: END IF;
213: IF NVL(l_rev_control, 1) = 1 AND l_lot_control = 2 THEN
214: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
215: 'moqd.lot_number';
216: inv_mwb_query_manager.add_group_clause('moqd.lot_number', 'ONHAND');
217: END IF;
218:

Line 216: inv_mwb_query_manager.add_group_clause('moqd.lot_number', 'ONHAND');

212: END IF;
213: IF NVL(l_rev_control, 1) = 1 AND l_lot_control = 2 THEN
214: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
215: 'moqd.lot_number';
216: inv_mwb_query_manager.add_group_clause('moqd.lot_number', 'ONHAND');
217: END IF;
218:
219: inv_mwb_query_manager.add_qf_where_onhand('ONHAND');
220: END IF; -- serial in query find

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

215: 'moqd.lot_number';
216: inv_mwb_query_manager.add_group_clause('moqd.lot_number', 'ONHAND');
217: END IF;
218:
219: inv_mwb_query_manager.add_qf_where_onhand('ONHAND');
220: END IF; -- serial in query find
221: END IF; -- only serial controlled
222: inv_mwb_query_manager.add_bind_variable(
223: 'onh_tree_organization_id',

Line 222: inv_mwb_query_manager.add_bind_variable(

218:
219: inv_mwb_query_manager.add_qf_where_onhand('ONHAND');
220: END IF; -- serial in query find
221: END IF; -- only serial controlled
222: inv_mwb_query_manager.add_bind_variable(
223: 'onh_tree_organization_id',
224: inv_mwb_globals.g_tree_organization_id
225: );
226: inv_mwb_query_manager.add_bind_variable(

Line 226: inv_mwb_query_manager.add_bind_variable(

222: inv_mwb_query_manager.add_bind_variable(
223: 'onh_tree_organization_id',
224: inv_mwb_globals.g_tree_organization_id
225: );
226: inv_mwb_query_manager.add_bind_variable(
227: 'onh_tree_inventory_item_id',
228: inv_mwb_globals.g_tree_item_id
229: );
230: END IF; -- onhand check

Line 231: inv_mwb_query_manager.execute_query;

227: 'onh_tree_inventory_item_id',
228: inv_mwb_globals.g_tree_item_id
229: );
230: END IF; -- onhand check
231: inv_mwb_query_manager.execute_query;
232:
233: END IF; -- tree event
234:
235: EXCEPTION

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

279: IF inv_mwb_globals.g_chk_onhand = 1 THEN
280:
281: IF l_lot_control = 1 AND l_serial_control IN ( 2,5 ) THEN
282: make_common_queries('MSN');
283: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.revision).column_value :=
284: 'msn.revision';
285: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SERIAL).column_value :=
286: 'msn.serial_number';
287: inv_mwb_query_manager.add_where_clause('msn.inventory_item_id = :onh_tree_inventory_item_id' ,'ONHAND');

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

281: IF l_lot_control = 1 AND l_serial_control IN ( 2,5 ) THEN
282: make_common_queries('MSN');
283: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.revision).column_value :=
284: 'msn.revision';
285: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SERIAL).column_value :=
286: 'msn.serial_number';
287: inv_mwb_query_manager.add_where_clause('msn.inventory_item_id = :onh_tree_inventory_item_id' ,'ONHAND');
288: inv_mwb_query_manager.add_where_clause('msn.organization_id = :onh_tree_organization_id' ,'ONHAND');
289: inv_mwb_query_manager.add_where_clause('msn.revision = :onh_tree_revision' ,'ONHAND');

Line 287: inv_mwb_query_manager.add_where_clause('msn.inventory_item_id = :onh_tree_inventory_item_id' ,'ONHAND');

283: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.revision).column_value :=
284: 'msn.revision';
285: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SERIAL).column_value :=
286: 'msn.serial_number';
287: inv_mwb_query_manager.add_where_clause('msn.inventory_item_id = :onh_tree_inventory_item_id' ,'ONHAND');
288: inv_mwb_query_manager.add_where_clause('msn.organization_id = :onh_tree_organization_id' ,'ONHAND');
289: inv_mwb_query_manager.add_where_clause('msn.revision = :onh_tree_revision' ,'ONHAND');
290: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
291: ELSE -- l_serial_control

Line 288: inv_mwb_query_manager.add_where_clause('msn.organization_id = :onh_tree_organization_id' ,'ONHAND');

284: 'msn.revision';
285: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SERIAL).column_value :=
286: 'msn.serial_number';
287: inv_mwb_query_manager.add_where_clause('msn.inventory_item_id = :onh_tree_inventory_item_id' ,'ONHAND');
288: inv_mwb_query_manager.add_where_clause('msn.organization_id = :onh_tree_organization_id' ,'ONHAND');
289: inv_mwb_query_manager.add_where_clause('msn.revision = :onh_tree_revision' ,'ONHAND');
290: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
291: ELSE -- l_serial_control
292: IF inv_mwb_globals.g_serial_from IS NOT NULL OR

Line 289: inv_mwb_query_manager.add_where_clause('msn.revision = :onh_tree_revision' ,'ONHAND');

285: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SERIAL).column_value :=
286: 'msn.serial_number';
287: inv_mwb_query_manager.add_where_clause('msn.inventory_item_id = :onh_tree_inventory_item_id' ,'ONHAND');
288: inv_mwb_query_manager.add_where_clause('msn.organization_id = :onh_tree_organization_id' ,'ONHAND');
289: inv_mwb_query_manager.add_where_clause('msn.revision = :onh_tree_revision' ,'ONHAND');
290: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
291: ELSE -- l_serial_control
292: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
293: inv_mwb_globals.g_serial_to IS NOT NULL

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

286: 'msn.serial_number';
287: inv_mwb_query_manager.add_where_clause('msn.inventory_item_id = :onh_tree_inventory_item_id' ,'ONHAND');
288: inv_mwb_query_manager.add_where_clause('msn.organization_id = :onh_tree_organization_id' ,'ONHAND');
289: inv_mwb_query_manager.add_where_clause('msn.revision = :onh_tree_revision' ,'ONHAND');
290: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
291: ELSE -- l_serial_control
292: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
293: inv_mwb_globals.g_serial_to IS NOT NULL
294: OR inv_mwb_globals.g_status_id IS NOT NULL -- Bug 6060233

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

295: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL -- Bug 6429880
296: OR inv_mwb_globals.g_unit_number IS NOT NULL -- Bug 9365452
297: THEN
298: make_common_queries('MSN_QUERY');
299: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.revision).column_value :=
300: 'msn.revision';
301: inv_mwb_query_manager.add_group_clause('msn.revision', 'ONHAND'); -- Bug 6060233
302: IF l_lot_control = 2 THEN
303: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=

Line 301: inv_mwb_query_manager.add_group_clause('msn.revision', 'ONHAND'); -- Bug 6060233

297: THEN
298: make_common_queries('MSN_QUERY');
299: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.revision).column_value :=
300: 'msn.revision';
301: inv_mwb_query_manager.add_group_clause('msn.revision', 'ONHAND'); -- Bug 6060233
302: IF l_lot_control = 2 THEN
303: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
304: 'msn.lot_number';
305: inv_mwb_query_manager.add_group_clause('msn.lot_number', 'ONHAND');

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

299: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.revision).column_value :=
300: 'msn.revision';
301: inv_mwb_query_manager.add_group_clause('msn.revision', 'ONHAND'); -- Bug 6060233
302: IF l_lot_control = 2 THEN
303: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
304: 'msn.lot_number';
305: inv_mwb_query_manager.add_group_clause('msn.lot_number', 'ONHAND');
306: END IF;
307: inv_mwb_query_manager.add_where_clause(

Line 305: inv_mwb_query_manager.add_group_clause('msn.lot_number', 'ONHAND');

301: inv_mwb_query_manager.add_group_clause('msn.revision', 'ONHAND'); -- Bug 6060233
302: IF l_lot_control = 2 THEN
303: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
304: 'msn.lot_number';
305: inv_mwb_query_manager.add_group_clause('msn.lot_number', 'ONHAND');
306: END IF;
307: inv_mwb_query_manager.add_where_clause(
308: 'msn.inventory_item_id = :onh_tree_inventory_item_id' ,
309: 'ONHAND'

Line 307: inv_mwb_query_manager.add_where_clause(

303: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
304: 'msn.lot_number';
305: inv_mwb_query_manager.add_group_clause('msn.lot_number', 'ONHAND');
306: END IF;
307: inv_mwb_query_manager.add_where_clause(
308: 'msn.inventory_item_id = :onh_tree_inventory_item_id' ,
309: 'ONHAND'
310: );
311: inv_mwb_query_manager.add_where_clause(

Line 311: inv_mwb_query_manager.add_where_clause(

307: inv_mwb_query_manager.add_where_clause(
308: 'msn.inventory_item_id = :onh_tree_inventory_item_id' ,
309: 'ONHAND'
310: );
311: inv_mwb_query_manager.add_where_clause(
312: 'msn.current_organization_id = :onh_tree_organization_id' ,
313: 'ONHAND'
314: );
315: inv_mwb_query_manager.add_where_clause(

Line 315: inv_mwb_query_manager.add_where_clause(

311: inv_mwb_query_manager.add_where_clause(
312: 'msn.current_organization_id = :onh_tree_organization_id' ,
313: 'ONHAND'
314: );
315: inv_mwb_query_manager.add_where_clause(
316: 'msn.revision = :onh_tree_revision' ,
317: 'ONHAND'
318: );
319: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');

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

315: inv_mwb_query_manager.add_where_clause(
316: 'msn.revision = :onh_tree_revision' ,
317: 'ONHAND'
318: );
319: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
320: ELSE -- serial entered in qf
321: make_common_queries('MOQD');
322: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.revision).column_value :=
323: 'moqd.revision';

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

318: );
319: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
320: ELSE -- serial entered in qf
321: make_common_queries('MOQD');
322: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.revision).column_value :=
323: 'moqd.revision';
324: inv_mwb_query_manager.add_group_clause('moqd.revision', 'ONHAND');
325: inv_mwb_query_manager.add_where_clause('moqd.inventory_item_id = :onh_tree_inventory_item_id' ,'ONHAND');
326: inv_mwb_query_manager.add_where_clause('moqd.organization_id = :onh_tree_organization_id' ,'ONHAND');

Line 324: inv_mwb_query_manager.add_group_clause('moqd.revision', 'ONHAND');

320: ELSE -- serial entered in qf
321: make_common_queries('MOQD');
322: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.revision).column_value :=
323: 'moqd.revision';
324: inv_mwb_query_manager.add_group_clause('moqd.revision', 'ONHAND');
325: inv_mwb_query_manager.add_where_clause('moqd.inventory_item_id = :onh_tree_inventory_item_id' ,'ONHAND');
326: inv_mwb_query_manager.add_where_clause('moqd.organization_id = :onh_tree_organization_id' ,'ONHAND');
327: inv_mwb_query_manager.add_where_clause('moqd.revision = :onh_tree_revision' ,'ONHAND');
328: IF l_lot_control = 2 THEN

Line 325: inv_mwb_query_manager.add_where_clause('moqd.inventory_item_id = :onh_tree_inventory_item_id' ,'ONHAND');

321: make_common_queries('MOQD');
322: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.revision).column_value :=
323: 'moqd.revision';
324: inv_mwb_query_manager.add_group_clause('moqd.revision', 'ONHAND');
325: inv_mwb_query_manager.add_where_clause('moqd.inventory_item_id = :onh_tree_inventory_item_id' ,'ONHAND');
326: inv_mwb_query_manager.add_where_clause('moqd.organization_id = :onh_tree_organization_id' ,'ONHAND');
327: inv_mwb_query_manager.add_where_clause('moqd.revision = :onh_tree_revision' ,'ONHAND');
328: IF l_lot_control = 2 THEN
329: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=

Line 326: inv_mwb_query_manager.add_where_clause('moqd.organization_id = :onh_tree_organization_id' ,'ONHAND');

322: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.revision).column_value :=
323: 'moqd.revision';
324: inv_mwb_query_manager.add_group_clause('moqd.revision', 'ONHAND');
325: inv_mwb_query_manager.add_where_clause('moqd.inventory_item_id = :onh_tree_inventory_item_id' ,'ONHAND');
326: inv_mwb_query_manager.add_where_clause('moqd.organization_id = :onh_tree_organization_id' ,'ONHAND');
327: inv_mwb_query_manager.add_where_clause('moqd.revision = :onh_tree_revision' ,'ONHAND');
328: IF l_lot_control = 2 THEN
329: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
330: 'moqd.lot_number';

Line 327: inv_mwb_query_manager.add_where_clause('moqd.revision = :onh_tree_revision' ,'ONHAND');

323: 'moqd.revision';
324: inv_mwb_query_manager.add_group_clause('moqd.revision', 'ONHAND');
325: inv_mwb_query_manager.add_where_clause('moqd.inventory_item_id = :onh_tree_inventory_item_id' ,'ONHAND');
326: inv_mwb_query_manager.add_where_clause('moqd.organization_id = :onh_tree_organization_id' ,'ONHAND');
327: inv_mwb_query_manager.add_where_clause('moqd.revision = :onh_tree_revision' ,'ONHAND');
328: IF l_lot_control = 2 THEN
329: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
330: 'moqd.lot_number';
331: inv_mwb_query_manager.add_group_clause('moqd.lot_number', 'ONHAND');

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

325: inv_mwb_query_manager.add_where_clause('moqd.inventory_item_id = :onh_tree_inventory_item_id' ,'ONHAND');
326: inv_mwb_query_manager.add_where_clause('moqd.organization_id = :onh_tree_organization_id' ,'ONHAND');
327: inv_mwb_query_manager.add_where_clause('moqd.revision = :onh_tree_revision' ,'ONHAND');
328: IF l_lot_control = 2 THEN
329: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
330: 'moqd.lot_number';
331: inv_mwb_query_manager.add_group_clause('moqd.lot_number', 'ONHAND');
332: END IF;
333:

Line 331: inv_mwb_query_manager.add_group_clause('moqd.lot_number', 'ONHAND');

327: inv_mwb_query_manager.add_where_clause('moqd.revision = :onh_tree_revision' ,'ONHAND');
328: IF l_lot_control = 2 THEN
329: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
330: 'moqd.lot_number';
331: inv_mwb_query_manager.add_group_clause('moqd.lot_number', 'ONHAND');
332: END IF;
333:
334: inv_mwb_query_manager.add_qf_where_onhand('ONHAND');
335: END IF; -- serial entered in qf

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

330: 'moqd.lot_number';
331: inv_mwb_query_manager.add_group_clause('moqd.lot_number', 'ONHAND');
332: END IF;
333:
334: inv_mwb_query_manager.add_qf_where_onhand('ONHAND');
335: END IF; -- serial entered in qf
336: END IF; -- l_serial_control
337: inv_mwb_query_manager.add_bind_variable(
338: 'onh_tree_organization_id',

Line 337: inv_mwb_query_manager.add_bind_variable(

333:
334: inv_mwb_query_manager.add_qf_where_onhand('ONHAND');
335: END IF; -- serial entered in qf
336: END IF; -- l_serial_control
337: inv_mwb_query_manager.add_bind_variable(
338: 'onh_tree_organization_id',
339: inv_mwb_globals.g_tree_organization_id
340: );
341: inv_mwb_query_manager.add_bind_variable(

Line 341: inv_mwb_query_manager.add_bind_variable(

337: inv_mwb_query_manager.add_bind_variable(
338: 'onh_tree_organization_id',
339: inv_mwb_globals.g_tree_organization_id
340: );
341: inv_mwb_query_manager.add_bind_variable(
342: 'onh_tree_inventory_item_id',
343: inv_mwb_globals.g_tree_item_id
344: );
345: inv_mwb_query_manager.add_bind_variable(

Line 345: inv_mwb_query_manager.add_bind_variable(

341: inv_mwb_query_manager.add_bind_variable(
342: 'onh_tree_inventory_item_id',
343: inv_mwb_globals.g_tree_item_id
344: );
345: inv_mwb_query_manager.add_bind_variable(
346: 'onh_tree_revision',
347: inv_mwb_globals.g_tree_rev
348: );
349: END IF; --chk_onhand

Line 350: inv_mwb_query_manager.execute_query;

346: 'onh_tree_revision',
347: inv_mwb_globals.g_tree_rev
348: );
349: END IF; --chk_onhand
350: inv_mwb_query_manager.execute_query;
351: END IF;
352: EXCEPTION
353: WHEN no_data_found THEN
354: NULL;

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

388: IF inv_mwb_globals.g_chk_onhand = 1 THEN
389:
390: IF l_serial_control IN ( 2,5 ) THEN
391: make_common_queries('MSN');
392: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
393: 'msn.lot_number';
394: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SERIAL).column_value :=
395: 'msn.serial_number';
396: inv_mwb_query_manager.add_where_clause('msn.inventory_item_id = :onh_tree_inventory_item_id' ,'ONHAND');

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

390: IF l_serial_control IN ( 2,5 ) THEN
391: make_common_queries('MSN');
392: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
393: 'msn.lot_number';
394: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SERIAL).column_value :=
395: 'msn.serial_number';
396: inv_mwb_query_manager.add_where_clause('msn.inventory_item_id = :onh_tree_inventory_item_id' ,'ONHAND');
397: inv_mwb_query_manager.add_where_clause('msn.current_organization_id = :onh_tree_organization_id' ,'ONHAND');
398: inv_mwb_query_manager.add_where_clause('msn.lot_number = :onh_tree_lot_number' ,'ONHAND');

Line 396: inv_mwb_query_manager.add_where_clause('msn.inventory_item_id = :onh_tree_inventory_item_id' ,'ONHAND');

392: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
393: 'msn.lot_number';
394: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SERIAL).column_value :=
395: 'msn.serial_number';
396: inv_mwb_query_manager.add_where_clause('msn.inventory_item_id = :onh_tree_inventory_item_id' ,'ONHAND');
397: inv_mwb_query_manager.add_where_clause('msn.current_organization_id = :onh_tree_organization_id' ,'ONHAND');
398: inv_mwb_query_manager.add_where_clause('msn.lot_number = :onh_tree_lot_number' ,'ONHAND');
399: IF l_rev_control = 2 THEN
400: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.revision).column_value :=

Line 397: inv_mwb_query_manager.add_where_clause('msn.current_organization_id = :onh_tree_organization_id' ,'ONHAND');

393: 'msn.lot_number';
394: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SERIAL).column_value :=
395: 'msn.serial_number';
396: inv_mwb_query_manager.add_where_clause('msn.inventory_item_id = :onh_tree_inventory_item_id' ,'ONHAND');
397: inv_mwb_query_manager.add_where_clause('msn.current_organization_id = :onh_tree_organization_id' ,'ONHAND');
398: inv_mwb_query_manager.add_where_clause('msn.lot_number = :onh_tree_lot_number' ,'ONHAND');
399: IF l_rev_control = 2 THEN
400: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.revision).column_value :=
401: 'msn.revision';

Line 398: inv_mwb_query_manager.add_where_clause('msn.lot_number = :onh_tree_lot_number' ,'ONHAND');

394: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SERIAL).column_value :=
395: 'msn.serial_number';
396: inv_mwb_query_manager.add_where_clause('msn.inventory_item_id = :onh_tree_inventory_item_id' ,'ONHAND');
397: inv_mwb_query_manager.add_where_clause('msn.current_organization_id = :onh_tree_organization_id' ,'ONHAND');
398: inv_mwb_query_manager.add_where_clause('msn.lot_number = :onh_tree_lot_number' ,'ONHAND');
399: IF l_rev_control = 2 THEN
400: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.revision).column_value :=
401: 'msn.revision';
402: inv_mwb_query_manager.add_where_clause('msn.revision = :onh_tree_revision' ,'ONHAND');

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

396: inv_mwb_query_manager.add_where_clause('msn.inventory_item_id = :onh_tree_inventory_item_id' ,'ONHAND');
397: inv_mwb_query_manager.add_where_clause('msn.current_organization_id = :onh_tree_organization_id' ,'ONHAND');
398: inv_mwb_query_manager.add_where_clause('msn.lot_number = :onh_tree_lot_number' ,'ONHAND');
399: IF l_rev_control = 2 THEN
400: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.revision).column_value :=
401: 'msn.revision';
402: inv_mwb_query_manager.add_where_clause('msn.revision = :onh_tree_revision' ,'ONHAND');
403: END IF;
404: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');

Line 402: inv_mwb_query_manager.add_where_clause('msn.revision = :onh_tree_revision' ,'ONHAND');

398: inv_mwb_query_manager.add_where_clause('msn.lot_number = :onh_tree_lot_number' ,'ONHAND');
399: IF l_rev_control = 2 THEN
400: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.revision).column_value :=
401: 'msn.revision';
402: inv_mwb_query_manager.add_where_clause('msn.revision = :onh_tree_revision' ,'ONHAND');
403: END IF;
404: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
405: ELSE -- l_serial_control
406: IF inv_mwb_globals.g_serial_from IS NOT NULL OR

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

400: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.revision).column_value :=
401: 'msn.revision';
402: inv_mwb_query_manager.add_where_clause('msn.revision = :onh_tree_revision' ,'ONHAND');
403: END IF;
404: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
405: ELSE -- l_serial_control
406: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
407: inv_mwb_globals.g_serial_to IS NOT NULL
408: OR inv_mwb_globals.g_status_id IS NOT NULL -- Bug 6060233

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

410: OR inv_mwb_globals.g_unit_number IS NOT NULL -- Bug 9365452
411: THEN
412: make_common_queries('MSN_QUERY');
413: IF l_rev_control = 2 THEN
414: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.revision).column_value :=
415: 'msn.revision';
416: inv_mwb_query_manager.add_where_clause('msn.revision = :onh_tree_revision' ,'ONHAND');
417: inv_mwb_query_manager.add_group_clause('msn.revision', 'ONHAND');
418: END IF;

Line 416: inv_mwb_query_manager.add_where_clause('msn.revision = :onh_tree_revision' ,'ONHAND');

412: make_common_queries('MSN_QUERY');
413: IF l_rev_control = 2 THEN
414: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.revision).column_value :=
415: 'msn.revision';
416: inv_mwb_query_manager.add_where_clause('msn.revision = :onh_tree_revision' ,'ONHAND');
417: inv_mwb_query_manager.add_group_clause('msn.revision', 'ONHAND');
418: END IF;
419: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
420: 'msn.lot_number';

Line 417: inv_mwb_query_manager.add_group_clause('msn.revision', 'ONHAND');

413: IF l_rev_control = 2 THEN
414: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.revision).column_value :=
415: 'msn.revision';
416: inv_mwb_query_manager.add_where_clause('msn.revision = :onh_tree_revision' ,'ONHAND');
417: inv_mwb_query_manager.add_group_clause('msn.revision', 'ONHAND');
418: END IF;
419: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
420: 'msn.lot_number';
421: inv_mwb_query_manager.add_group_clause('msn.lot_number', 'ONHAND');

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

415: 'msn.revision';
416: inv_mwb_query_manager.add_where_clause('msn.revision = :onh_tree_revision' ,'ONHAND');
417: inv_mwb_query_manager.add_group_clause('msn.revision', 'ONHAND');
418: END IF;
419: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
420: 'msn.lot_number';
421: inv_mwb_query_manager.add_group_clause('msn.lot_number', 'ONHAND');
422: inv_mwb_query_manager.add_where_clause(
423: 'msn.inventory_item_id = :onh_tree_inventory_item_id' ,

Line 421: inv_mwb_query_manager.add_group_clause('msn.lot_number', 'ONHAND');

417: inv_mwb_query_manager.add_group_clause('msn.revision', 'ONHAND');
418: END IF;
419: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
420: 'msn.lot_number';
421: inv_mwb_query_manager.add_group_clause('msn.lot_number', 'ONHAND');
422: inv_mwb_query_manager.add_where_clause(
423: 'msn.inventory_item_id = :onh_tree_inventory_item_id' ,
424: 'ONHAND'
425: );

Line 422: inv_mwb_query_manager.add_where_clause(

418: END IF;
419: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
420: 'msn.lot_number';
421: inv_mwb_query_manager.add_group_clause('msn.lot_number', 'ONHAND');
422: inv_mwb_query_manager.add_where_clause(
423: 'msn.inventory_item_id = :onh_tree_inventory_item_id' ,
424: 'ONHAND'
425: );
426: inv_mwb_query_manager.add_where_clause(

Line 426: inv_mwb_query_manager.add_where_clause(

422: inv_mwb_query_manager.add_where_clause(
423: 'msn.inventory_item_id = :onh_tree_inventory_item_id' ,
424: 'ONHAND'
425: );
426: inv_mwb_query_manager.add_where_clause(
427: 'msn.current_organization_id = :onh_tree_organization_id' ,
428: 'ONHAND'
429: );
430: inv_mwb_query_manager.add_where_clause(

Line 430: inv_mwb_query_manager.add_where_clause(

426: inv_mwb_query_manager.add_where_clause(
427: 'msn.current_organization_id = :onh_tree_organization_id' ,
428: 'ONHAND'
429: );
430: inv_mwb_query_manager.add_where_clause(
431: 'msn.lot_number = :onh_tree_lot_number' ,
432: 'ONHAND'
433: );
434: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');

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

430: inv_mwb_query_manager.add_where_clause(
431: 'msn.lot_number = :onh_tree_lot_number' ,
432: 'ONHAND'
433: );
434: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
435: ELSE -- serial entered in qf
436: make_common_queries('MOQD');
437: IF l_rev_control = 2 THEN
438: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.revision).column_value :=

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

434: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
435: ELSE -- serial entered in qf
436: make_common_queries('MOQD');
437: IF l_rev_control = 2 THEN
438: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.revision).column_value :=
439: 'moqd.revision';
440: inv_mwb_query_manager.add_where_clause('moqd.revision = :onh_tree_revision' ,'ONHAND');
441: inv_mwb_query_manager.add_group_clause('moqd.revision','ONHAND');
442: END IF;

Line 440: inv_mwb_query_manager.add_where_clause('moqd.revision = :onh_tree_revision' ,'ONHAND');

436: make_common_queries('MOQD');
437: IF l_rev_control = 2 THEN
438: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.revision).column_value :=
439: 'moqd.revision';
440: inv_mwb_query_manager.add_where_clause('moqd.revision = :onh_tree_revision' ,'ONHAND');
441: inv_mwb_query_manager.add_group_clause('moqd.revision','ONHAND');
442: END IF;
443: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
444: 'moqd.lot_number';

Line 441: inv_mwb_query_manager.add_group_clause('moqd.revision','ONHAND');

437: IF l_rev_control = 2 THEN
438: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.revision).column_value :=
439: 'moqd.revision';
440: inv_mwb_query_manager.add_where_clause('moqd.revision = :onh_tree_revision' ,'ONHAND');
441: inv_mwb_query_manager.add_group_clause('moqd.revision','ONHAND');
442: END IF;
443: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
444: 'moqd.lot_number';
445: inv_mwb_query_manager.add_group_clause('moqd.lot_number','ONHAND');

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

439: 'moqd.revision';
440: inv_mwb_query_manager.add_where_clause('moqd.revision = :onh_tree_revision' ,'ONHAND');
441: inv_mwb_query_manager.add_group_clause('moqd.revision','ONHAND');
442: END IF;
443: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
444: 'moqd.lot_number';
445: inv_mwb_query_manager.add_group_clause('moqd.lot_number','ONHAND');
446:
447: inv_mwb_query_manager.add_where_clause('moqd.inventory_item_id = :onh_tree_inventory_item_id' ,'ONHAND');

Line 445: inv_mwb_query_manager.add_group_clause('moqd.lot_number','ONHAND');

441: inv_mwb_query_manager.add_group_clause('moqd.revision','ONHAND');
442: END IF;
443: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
444: 'moqd.lot_number';
445: inv_mwb_query_manager.add_group_clause('moqd.lot_number','ONHAND');
446:
447: inv_mwb_query_manager.add_where_clause('moqd.inventory_item_id = :onh_tree_inventory_item_id' ,'ONHAND');
448: inv_mwb_query_manager.add_where_clause('moqd.organization_id = :onh_tree_organization_id' ,'ONHAND');
449: inv_mwb_query_manager.add_where_clause('moqd.lot_number = :onh_tree_lot_number' ,'ONHAND');

Line 447: inv_mwb_query_manager.add_where_clause('moqd.inventory_item_id = :onh_tree_inventory_item_id' ,'ONHAND');

443: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
444: 'moqd.lot_number';
445: inv_mwb_query_manager.add_group_clause('moqd.lot_number','ONHAND');
446:
447: inv_mwb_query_manager.add_where_clause('moqd.inventory_item_id = :onh_tree_inventory_item_id' ,'ONHAND');
448: inv_mwb_query_manager.add_where_clause('moqd.organization_id = :onh_tree_organization_id' ,'ONHAND');
449: inv_mwb_query_manager.add_where_clause('moqd.lot_number = :onh_tree_lot_number' ,'ONHAND');
450:
451: inv_mwb_query_manager.add_qf_where_onhand('ONHAND');

Line 448: inv_mwb_query_manager.add_where_clause('moqd.organization_id = :onh_tree_organization_id' ,'ONHAND');

444: 'moqd.lot_number';
445: inv_mwb_query_manager.add_group_clause('moqd.lot_number','ONHAND');
446:
447: inv_mwb_query_manager.add_where_clause('moqd.inventory_item_id = :onh_tree_inventory_item_id' ,'ONHAND');
448: inv_mwb_query_manager.add_where_clause('moqd.organization_id = :onh_tree_organization_id' ,'ONHAND');
449: inv_mwb_query_manager.add_where_clause('moqd.lot_number = :onh_tree_lot_number' ,'ONHAND');
450:
451: inv_mwb_query_manager.add_qf_where_onhand('ONHAND');
452: END IF; -- serial entered in qf

Line 449: inv_mwb_query_manager.add_where_clause('moqd.lot_number = :onh_tree_lot_number' ,'ONHAND');

445: inv_mwb_query_manager.add_group_clause('moqd.lot_number','ONHAND');
446:
447: inv_mwb_query_manager.add_where_clause('moqd.inventory_item_id = :onh_tree_inventory_item_id' ,'ONHAND');
448: inv_mwb_query_manager.add_where_clause('moqd.organization_id = :onh_tree_organization_id' ,'ONHAND');
449: inv_mwb_query_manager.add_where_clause('moqd.lot_number = :onh_tree_lot_number' ,'ONHAND');
450:
451: inv_mwb_query_manager.add_qf_where_onhand('ONHAND');
452: END IF; -- serial entered in qf
453: END IF; -- l_serial_control

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

447: inv_mwb_query_manager.add_where_clause('moqd.inventory_item_id = :onh_tree_inventory_item_id' ,'ONHAND');
448: inv_mwb_query_manager.add_where_clause('moqd.organization_id = :onh_tree_organization_id' ,'ONHAND');
449: inv_mwb_query_manager.add_where_clause('moqd.lot_number = :onh_tree_lot_number' ,'ONHAND');
450:
451: inv_mwb_query_manager.add_qf_where_onhand('ONHAND');
452: END IF; -- serial entered in qf
453: END IF; -- l_serial_control
454: inv_mwb_query_manager.add_bind_variable('onh_tree_organization_id', inv_mwb_globals.g_tree_organization_id);
455: inv_mwb_query_manager.add_bind_variable('onh_tree_inventory_item_id', inv_mwb_globals.g_tree_item_id);

Line 454: inv_mwb_query_manager.add_bind_variable('onh_tree_organization_id', inv_mwb_globals.g_tree_organization_id);

450:
451: inv_mwb_query_manager.add_qf_where_onhand('ONHAND');
452: END IF; -- serial entered in qf
453: END IF; -- l_serial_control
454: inv_mwb_query_manager.add_bind_variable('onh_tree_organization_id', inv_mwb_globals.g_tree_organization_id);
455: inv_mwb_query_manager.add_bind_variable('onh_tree_inventory_item_id', inv_mwb_globals.g_tree_item_id);
456: inv_mwb_query_manager.add_bind_variable('onh_tree_lot_number', inv_mwb_globals.g_tree_lot_number);
457: IF l_rev_control = 2 THEN
458: inv_mwb_query_manager.add_bind_variable('onh_tree_revision', inv_mwb_globals.g_tree_rev);

Line 455: inv_mwb_query_manager.add_bind_variable('onh_tree_inventory_item_id', inv_mwb_globals.g_tree_item_id);

451: inv_mwb_query_manager.add_qf_where_onhand('ONHAND');
452: END IF; -- serial entered in qf
453: END IF; -- l_serial_control
454: inv_mwb_query_manager.add_bind_variable('onh_tree_organization_id', inv_mwb_globals.g_tree_organization_id);
455: inv_mwb_query_manager.add_bind_variable('onh_tree_inventory_item_id', inv_mwb_globals.g_tree_item_id);
456: inv_mwb_query_manager.add_bind_variable('onh_tree_lot_number', inv_mwb_globals.g_tree_lot_number);
457: IF l_rev_control = 2 THEN
458: inv_mwb_query_manager.add_bind_variable('onh_tree_revision', inv_mwb_globals.g_tree_rev);
459: END IF;

Line 456: inv_mwb_query_manager.add_bind_variable('onh_tree_lot_number', inv_mwb_globals.g_tree_lot_number);

452: END IF; -- serial entered in qf
453: END IF; -- l_serial_control
454: inv_mwb_query_manager.add_bind_variable('onh_tree_organization_id', inv_mwb_globals.g_tree_organization_id);
455: inv_mwb_query_manager.add_bind_variable('onh_tree_inventory_item_id', inv_mwb_globals.g_tree_item_id);
456: inv_mwb_query_manager.add_bind_variable('onh_tree_lot_number', inv_mwb_globals.g_tree_lot_number);
457: IF l_rev_control = 2 THEN
458: inv_mwb_query_manager.add_bind_variable('onh_tree_revision', inv_mwb_globals.g_tree_rev);
459: END IF;
460: END IF; --chk_onhand

Line 458: inv_mwb_query_manager.add_bind_variable('onh_tree_revision', inv_mwb_globals.g_tree_rev);

454: inv_mwb_query_manager.add_bind_variable('onh_tree_organization_id', inv_mwb_globals.g_tree_organization_id);
455: inv_mwb_query_manager.add_bind_variable('onh_tree_inventory_item_id', inv_mwb_globals.g_tree_item_id);
456: inv_mwb_query_manager.add_bind_variable('onh_tree_lot_number', inv_mwb_globals.g_tree_lot_number);
457: IF l_rev_control = 2 THEN
458: inv_mwb_query_manager.add_bind_variable('onh_tree_revision', inv_mwb_globals.g_tree_rev);
459: END IF;
460: END IF; --chk_onhand
461: inv_mwb_query_manager.execute_query;
462:

Line 461: inv_mwb_query_manager.execute_query;

457: IF l_rev_control = 2 THEN
458: inv_mwb_query_manager.add_bind_variable('onh_tree_revision', inv_mwb_globals.g_tree_rev);
459: END IF;
460: END IF; --chk_onhand
461: inv_mwb_query_manager.execute_query;
462:
463: END IF; -- tree event
464: EXCEPTION
465: WHEN no_data_found THEN

Line 493: inv_mwb_query_manager.add_where_clause('msn.inventory_item_id = :onh_tree_inventory_item_id' ,'ONHAND');

489: AND organization_id = inv_mwb_globals.g_tree_organization_id;
490:
491: IF inv_mwb_globals.g_chk_onhand = 1 THEN
492: make_common_queries('MSN');
493: inv_mwb_query_manager.add_where_clause('msn.inventory_item_id = :onh_tree_inventory_item_id' ,'ONHAND');
494: inv_mwb_query_manager.add_where_clause('msn.current_organization_id = :onh_tree_organization_id' ,'ONHAND');
495: inv_mwb_query_manager.add_bind_variable('onh_tree_organization_id', inv_mwb_globals.g_tree_organization_id);
496: inv_mwb_query_manager.add_bind_variable('onh_tree_inventory_item_id', inv_mwb_globals.g_tree_item_id);
497: IF l_rev_control = 2 THEN

Line 494: inv_mwb_query_manager.add_where_clause('msn.current_organization_id = :onh_tree_organization_id' ,'ONHAND');

490:
491: IF inv_mwb_globals.g_chk_onhand = 1 THEN
492: make_common_queries('MSN');
493: inv_mwb_query_manager.add_where_clause('msn.inventory_item_id = :onh_tree_inventory_item_id' ,'ONHAND');
494: inv_mwb_query_manager.add_where_clause('msn.current_organization_id = :onh_tree_organization_id' ,'ONHAND');
495: inv_mwb_query_manager.add_bind_variable('onh_tree_organization_id', inv_mwb_globals.g_tree_organization_id);
496: inv_mwb_query_manager.add_bind_variable('onh_tree_inventory_item_id', inv_mwb_globals.g_tree_item_id);
497: IF l_rev_control = 2 THEN
498: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.revision).column_value :=

Line 495: inv_mwb_query_manager.add_bind_variable('onh_tree_organization_id', inv_mwb_globals.g_tree_organization_id);

491: IF inv_mwb_globals.g_chk_onhand = 1 THEN
492: make_common_queries('MSN');
493: inv_mwb_query_manager.add_where_clause('msn.inventory_item_id = :onh_tree_inventory_item_id' ,'ONHAND');
494: inv_mwb_query_manager.add_where_clause('msn.current_organization_id = :onh_tree_organization_id' ,'ONHAND');
495: inv_mwb_query_manager.add_bind_variable('onh_tree_organization_id', inv_mwb_globals.g_tree_organization_id);
496: inv_mwb_query_manager.add_bind_variable('onh_tree_inventory_item_id', inv_mwb_globals.g_tree_item_id);
497: IF l_rev_control = 2 THEN
498: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.revision).column_value :=
499: 'msn.revision';

Line 496: inv_mwb_query_manager.add_bind_variable('onh_tree_inventory_item_id', inv_mwb_globals.g_tree_item_id);

492: make_common_queries('MSN');
493: inv_mwb_query_manager.add_where_clause('msn.inventory_item_id = :onh_tree_inventory_item_id' ,'ONHAND');
494: inv_mwb_query_manager.add_where_clause('msn.current_organization_id = :onh_tree_organization_id' ,'ONHAND');
495: inv_mwb_query_manager.add_bind_variable('onh_tree_organization_id', inv_mwb_globals.g_tree_organization_id);
496: inv_mwb_query_manager.add_bind_variable('onh_tree_inventory_item_id', inv_mwb_globals.g_tree_item_id);
497: IF l_rev_control = 2 THEN
498: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.revision).column_value :=
499: 'msn.revision';
500: inv_mwb_query_manager.add_where_clause('msn.revision = :onh_tree_revision' ,'ONHAND');

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

494: inv_mwb_query_manager.add_where_clause('msn.current_organization_id = :onh_tree_organization_id' ,'ONHAND');
495: inv_mwb_query_manager.add_bind_variable('onh_tree_organization_id', inv_mwb_globals.g_tree_organization_id);
496: inv_mwb_query_manager.add_bind_variable('onh_tree_inventory_item_id', inv_mwb_globals.g_tree_item_id);
497: IF l_rev_control = 2 THEN
498: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.revision).column_value :=
499: 'msn.revision';
500: inv_mwb_query_manager.add_where_clause('msn.revision = :onh_tree_revision' ,'ONHAND');
501: inv_mwb_query_manager.add_bind_variable('onh_tree_revision', inv_mwb_globals.g_tree_rev);
502: END IF;

Line 500: inv_mwb_query_manager.add_where_clause('msn.revision = :onh_tree_revision' ,'ONHAND');

496: inv_mwb_query_manager.add_bind_variable('onh_tree_inventory_item_id', inv_mwb_globals.g_tree_item_id);
497: IF l_rev_control = 2 THEN
498: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.revision).column_value :=
499: 'msn.revision';
500: inv_mwb_query_manager.add_where_clause('msn.revision = :onh_tree_revision' ,'ONHAND');
501: inv_mwb_query_manager.add_bind_variable('onh_tree_revision', inv_mwb_globals.g_tree_rev);
502: END IF;
503: IF l_lot_control = 2 THEN
504: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=

Line 501: inv_mwb_query_manager.add_bind_variable('onh_tree_revision', inv_mwb_globals.g_tree_rev);

497: IF l_rev_control = 2 THEN
498: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.revision).column_value :=
499: 'msn.revision';
500: inv_mwb_query_manager.add_where_clause('msn.revision = :onh_tree_revision' ,'ONHAND');
501: inv_mwb_query_manager.add_bind_variable('onh_tree_revision', inv_mwb_globals.g_tree_rev);
502: END IF;
503: IF l_lot_control = 2 THEN
504: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
505: 'msn.lot_number';

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

500: inv_mwb_query_manager.add_where_clause('msn.revision = :onh_tree_revision' ,'ONHAND');
501: inv_mwb_query_manager.add_bind_variable('onh_tree_revision', inv_mwb_globals.g_tree_rev);
502: END IF;
503: IF l_lot_control = 2 THEN
504: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
505: 'msn.lot_number';
506: inv_mwb_query_manager.add_where_clause('msn.lot_number = :onh_lot_number' ,'ONHAND');
507: inv_mwb_query_manager.add_bind_variable('onh_lot_number', inv_mwb_globals.g_tree_lot_number);
508: END IF;

Line 506: inv_mwb_query_manager.add_where_clause('msn.lot_number = :onh_lot_number' ,'ONHAND');

502: END IF;
503: IF l_lot_control = 2 THEN
504: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
505: 'msn.lot_number';
506: inv_mwb_query_manager.add_where_clause('msn.lot_number = :onh_lot_number' ,'ONHAND');
507: inv_mwb_query_manager.add_bind_variable('onh_lot_number', inv_mwb_globals.g_tree_lot_number);
508: END IF;
509: inv_mwb_query_manager.add_where_clause('msn.serial_number = :onh_serial_number' ,'ONHAND');
510: inv_mwb_query_manager.add_where_clause('msn.current_status = 3' ,'ONHAND');

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

503: IF l_lot_control = 2 THEN
504: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
505: 'msn.lot_number';
506: inv_mwb_query_manager.add_where_clause('msn.lot_number = :onh_lot_number' ,'ONHAND');
507: inv_mwb_query_manager.add_bind_variable('onh_lot_number', inv_mwb_globals.g_tree_lot_number);
508: END IF;
509: inv_mwb_query_manager.add_where_clause('msn.serial_number = :onh_serial_number' ,'ONHAND');
510: inv_mwb_query_manager.add_where_clause('msn.current_status = 3' ,'ONHAND');
511: inv_mwb_query_manager.add_bind_variable('onh_serial_number', inv_mwb_globals.g_tree_serial_number);

Line 509: inv_mwb_query_manager.add_where_clause('msn.serial_number = :onh_serial_number' ,'ONHAND');

505: 'msn.lot_number';
506: inv_mwb_query_manager.add_where_clause('msn.lot_number = :onh_lot_number' ,'ONHAND');
507: inv_mwb_query_manager.add_bind_variable('onh_lot_number', inv_mwb_globals.g_tree_lot_number);
508: END IF;
509: inv_mwb_query_manager.add_where_clause('msn.serial_number = :onh_serial_number' ,'ONHAND');
510: inv_mwb_query_manager.add_where_clause('msn.current_status = 3' ,'ONHAND');
511: inv_mwb_query_manager.add_bind_variable('onh_serial_number', inv_mwb_globals.g_tree_serial_number);
512:
513: END IF;

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

506: inv_mwb_query_manager.add_where_clause('msn.lot_number = :onh_lot_number' ,'ONHAND');
507: inv_mwb_query_manager.add_bind_variable('onh_lot_number', inv_mwb_globals.g_tree_lot_number);
508: END IF;
509: inv_mwb_query_manager.add_where_clause('msn.serial_number = :onh_serial_number' ,'ONHAND');
510: inv_mwb_query_manager.add_where_clause('msn.current_status = 3' ,'ONHAND');
511: inv_mwb_query_manager.add_bind_variable('onh_serial_number', inv_mwb_globals.g_tree_serial_number);
512:
513: END IF;
514: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');

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

507: inv_mwb_query_manager.add_bind_variable('onh_lot_number', inv_mwb_globals.g_tree_lot_number);
508: END IF;
509: inv_mwb_query_manager.add_where_clause('msn.serial_number = :onh_serial_number' ,'ONHAND');
510: inv_mwb_query_manager.add_where_clause('msn.current_status = 3' ,'ONHAND');
511: inv_mwb_query_manager.add_bind_variable('onh_serial_number', inv_mwb_globals.g_tree_serial_number);
512:
513: END IF;
514: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
515: inv_mwb_query_manager.execute_query;

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

510: inv_mwb_query_manager.add_where_clause('msn.current_status = 3' ,'ONHAND');
511: inv_mwb_query_manager.add_bind_variable('onh_serial_number', inv_mwb_globals.g_tree_serial_number);
512:
513: END IF;
514: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
515: inv_mwb_query_manager.execute_query;
516: END IF;
517:
518: EXCEPTION

Line 515: inv_mwb_query_manager.execute_query;

511: inv_mwb_query_manager.add_bind_variable('onh_serial_number', inv_mwb_globals.g_tree_serial_number);
512:
513: END IF;
514: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
515: inv_mwb_query_manager.execute_query;
516: END IF;
517:
518: EXCEPTION
519: WHEN no_data_found THEN

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

591:
592: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SECONDARY_UNPACKED).column_value :=
593: 'SUM(DECODE(moqd.containerized_flag, 1, 0, moqd.secondary_transaction_quantity))';
594:
595: inv_mwb_query_manager.add_from_clause('mtl_onhand_quantities_detail moqd', 'ONHAND');
596:
597: inv_mwb_query_manager.add_group_clause('moqd.inventory_item_id', 'ONHAND');
598: inv_mwb_query_manager.add_group_clause('moqd.organization_id', 'ONHAND');
599: -- inv_mwb_query_manager.add_group_clause('moqd.transaction_uom_code', 'ONHAND');

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

593: 'SUM(DECODE(moqd.containerized_flag, 1, 0, moqd.secondary_transaction_quantity))';
594:
595: inv_mwb_query_manager.add_from_clause('mtl_onhand_quantities_detail moqd', 'ONHAND');
596:
597: inv_mwb_query_manager.add_group_clause('moqd.inventory_item_id', 'ONHAND');
598: inv_mwb_query_manager.add_group_clause('moqd.organization_id', 'ONHAND');
599: -- inv_mwb_query_manager.add_group_clause('moqd.transaction_uom_code', 'ONHAND');
600: inv_mwb_query_manager.add_group_clause('moqd.secondary_uom_code', 'ONHAND');
601:

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

594:
595: inv_mwb_query_manager.add_from_clause('mtl_onhand_quantities_detail moqd', 'ONHAND');
596:
597: inv_mwb_query_manager.add_group_clause('moqd.inventory_item_id', 'ONHAND');
598: inv_mwb_query_manager.add_group_clause('moqd.organization_id', 'ONHAND');
599: -- inv_mwb_query_manager.add_group_clause('moqd.transaction_uom_code', 'ONHAND');
600: inv_mwb_query_manager.add_group_clause('moqd.secondary_uom_code', 'ONHAND');
601:
602: WHEN 'MSN_QUERY' THEN

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

595: inv_mwb_query_manager.add_from_clause('mtl_onhand_quantities_detail moqd', 'ONHAND');
596:
597: inv_mwb_query_manager.add_group_clause('moqd.inventory_item_id', 'ONHAND');
598: inv_mwb_query_manager.add_group_clause('moqd.organization_id', 'ONHAND');
599: -- inv_mwb_query_manager.add_group_clause('moqd.transaction_uom_code', 'ONHAND');
600: inv_mwb_query_manager.add_group_clause('moqd.secondary_uom_code', 'ONHAND');
601:
602: WHEN 'MSN_QUERY' THEN
603: -- Bug 6060233

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

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

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

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

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

603: -- Bug 6060233
604: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ITEM_ID).column_value :=
605: 'msn.inventory_item_id';
606:
607: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ORG_ID).column_value :=
608: 'msn.current_organization_id';
609:
610: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PRIMARY_UOM_CODE).column_value :=
611: '''Ea''';

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

606:
607: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ORG_ID).column_value :=
608: 'msn.current_organization_id';
609:
610: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PRIMARY_UOM_CODE).column_value :=
611: '''Ea''';
612: -- End Bug 6060233
613: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ONHAND).column_value :=
614: 'count(1)';

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

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

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

611: '''Ea''';
612: -- End Bug 6060233
613: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ONHAND).column_value :=
614: 'count(1)';
615: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PACKED).column_value :=
616: 'count(decode(msn.lpn_id,NULL,0, 1))';
617: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.UNPACKED).column_value :=
618: 'count(decode(msn.lpn_id,NULL,1, 0))';
619: inv_mwb_query_manager.add_group_clause('msn.inventory_item_id' , 'ONHAND');

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

613: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ONHAND).column_value :=
614: 'count(1)';
615: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PACKED).column_value :=
616: 'count(decode(msn.lpn_id,NULL,0, 1))';
617: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.UNPACKED).column_value :=
618: 'count(decode(msn.lpn_id,NULL,1, 0))';
619: inv_mwb_query_manager.add_group_clause('msn.inventory_item_id' , 'ONHAND');
620: inv_mwb_query_manager.add_group_clause('msn.current_organization_id', 'ONHAND');
621: inv_mwb_query_manager.add_group_clause('''Ea''', 'ONHAND');

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

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

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

616: 'count(decode(msn.lpn_id,NULL,0, 1))';
617: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.UNPACKED).column_value :=
618: 'count(decode(msn.lpn_id,NULL,1, 0))';
619: inv_mwb_query_manager.add_group_clause('msn.inventory_item_id' , 'ONHAND');
620: inv_mwb_query_manager.add_group_clause('msn.current_organization_id', 'ONHAND');
621: inv_mwb_query_manager.add_group_clause('''Ea''', 'ONHAND');
622:
623: inv_mwb_query_manager.add_from_clause('mtl_serial_numbers msn', 'ONHAND');
624: inv_mwb_query_manager.add_where_clause('msn.current_status = 3', 'ONHAND');

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

617: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.UNPACKED).column_value :=
618: 'count(decode(msn.lpn_id,NULL,1, 0))';
619: inv_mwb_query_manager.add_group_clause('msn.inventory_item_id' , 'ONHAND');
620: inv_mwb_query_manager.add_group_clause('msn.current_organization_id', 'ONHAND');
621: inv_mwb_query_manager.add_group_clause('''Ea''', 'ONHAND');
622:
623: inv_mwb_query_manager.add_from_clause('mtl_serial_numbers msn', 'ONHAND');
624: inv_mwb_query_manager.add_where_clause('msn.current_status = 3', 'ONHAND');
625: END CASE; -- p_flag

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

619: inv_mwb_query_manager.add_group_clause('msn.inventory_item_id' , 'ONHAND');
620: inv_mwb_query_manager.add_group_clause('msn.current_organization_id', 'ONHAND');
621: inv_mwb_query_manager.add_group_clause('''Ea''', 'ONHAND');
622:
623: inv_mwb_query_manager.add_from_clause('mtl_serial_numbers msn', 'ONHAND');
624: inv_mwb_query_manager.add_where_clause('msn.current_status = 3', 'ONHAND');
625: END CASE; -- p_flag
626:
627: END IF; -- End if for onhand

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

620: inv_mwb_query_manager.add_group_clause('msn.current_organization_id', 'ONHAND');
621: inv_mwb_query_manager.add_group_clause('''Ea''', 'ONHAND');
622:
623: inv_mwb_query_manager.add_from_clause('mtl_serial_numbers msn', 'ONHAND');
624: inv_mwb_query_manager.add_where_clause('msn.current_status = 3', 'ONHAND');
625: END CASE; -- p_flag
626:
627: END IF; -- End if for onhand
628: