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_GLOBALS

Line 22: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_EXPANDED' THEN

18: BEGIN
19:
20: l_procedure_name := 'ROOT_NODE_EVENT';
21:
22: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_EXPANDED' THEN
23:
24: inv_mwb_tree1.add_items(
25: x_node_value
26: , x_node_tbl

Line 30: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN

26: , x_node_tbl
27: , x_tbl_index
28: );
29:
30: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
31:
32: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
33: inv_mwb_globals.g_serial_to IS NOT NULL
34: OR inv_mwb_globals.g_status_id IS NOT NULL -- Bug 6060233

Line 32: IF inv_mwb_globals.g_serial_from IS NOT NULL OR

28: );
29:
30: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
31:
32: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
33: inv_mwb_globals.g_serial_to IS NOT NULL
34: OR inv_mwb_globals.g_status_id IS NOT NULL -- Bug 6060233
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

Line 33: inv_mwb_globals.g_serial_to IS NOT NULL

29:
30: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
31:
32: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
33: inv_mwb_globals.g_serial_to IS NOT NULL
34: OR inv_mwb_globals.g_status_id IS NOT NULL -- Bug 6060233
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

Line 34: OR inv_mwb_globals.g_status_id IS NOT NULL -- Bug 6060233

30: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
31:
32: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
33: inv_mwb_globals.g_serial_to IS NOT NULL
34: OR inv_mwb_globals.g_status_id IS NOT NULL -- Bug 6060233
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');

Line 35: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL -- Bug 6429880

31:
32: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
33: inv_mwb_globals.g_serial_to IS NOT NULL
34: OR inv_mwb_globals.g_status_id IS NOT NULL -- Bug 6060233
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');

Line 36: OR inv_mwb_globals.g_unit_number IS NOT NULL -- Bug 9365452

32: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
33: inv_mwb_globals.g_serial_to IS NOT NULL
34: OR inv_mwb_globals.g_status_id IS NOT NULL -- Bug 6060233
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

Line 64: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_EXPANDED' THEN

60: BEGIN
61:
62: l_procedure_name := 'ITEM_NODE_EVENT';
63:
64: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_EXPANDED' THEN
65: inv_mwb_tree1.add_orgs(
66: x_node_value
67: , x_node_tbl
68: , x_tbl_index

Line 70: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN

66: x_node_value
67: , x_node_tbl
68: , x_tbl_index
69: );
70: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
71:
72: IF inv_mwb_globals.g_chk_onhand = 1 THEN
73: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
74: inv_mwb_globals.g_serial_to IS NOT NULL

Line 72: IF inv_mwb_globals.g_chk_onhand = 1 THEN

68: , x_tbl_index
69: );
70: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
71:
72: IF inv_mwb_globals.g_chk_onhand = 1 THEN
73: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
74: inv_mwb_globals.g_serial_to IS NOT NULL
75: OR inv_mwb_globals.g_status_id IS NOT NULL -- Bug 6060233
76: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL -- Bug 6429880

Line 73: IF inv_mwb_globals.g_serial_from IS NOT NULL OR

69: );
70: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
71:
72: IF inv_mwb_globals.g_chk_onhand = 1 THEN
73: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
74: inv_mwb_globals.g_serial_to IS NOT NULL
75: OR inv_mwb_globals.g_status_id IS NOT NULL -- Bug 6060233
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

Line 74: inv_mwb_globals.g_serial_to IS NOT NULL

70: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
71:
72: IF inv_mwb_globals.g_chk_onhand = 1 THEN
73: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
74: inv_mwb_globals.g_serial_to IS NOT NULL
75: OR inv_mwb_globals.g_status_id IS NOT NULL -- Bug 6060233
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

Line 75: OR inv_mwb_globals.g_status_id IS NOT NULL -- Bug 6060233

71:
72: IF inv_mwb_globals.g_chk_onhand = 1 THEN
73: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
74: inv_mwb_globals.g_serial_to IS NOT NULL
75: OR inv_mwb_globals.g_status_id IS NOT NULL -- Bug 6060233
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');

Line 76: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL -- Bug 6429880

72: IF inv_mwb_globals.g_chk_onhand = 1 THEN
73: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
74: inv_mwb_globals.g_serial_to IS NOT NULL
75: OR inv_mwb_globals.g_status_id IS NOT NULL -- Bug 6060233
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(

Line 77: OR inv_mwb_globals.g_unit_number IS NOT NULL -- Bug 9365452

73: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
74: inv_mwb_globals.g_serial_to IS NOT NULL
75: OR inv_mwb_globals.g_status_id IS NOT NULL -- Bug 6060233
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' ,

Line 96: inv_mwb_globals.g_tree_item_id

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;
99: END IF; -- onhand
100:

Line 121: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_EXPANDED' THEN

117: BEGIN
118:
119: l_procedure_name := 'ORG_NODE_EVENT';
120:
121: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_EXPANDED' THEN
122: inv_mwb_tree1.add_revs(
123: x_node_value
124: , x_node_tbl
125: , x_tbl_index

Line 144: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN

140: );
141: END IF;
142: END IF;
143:
144: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
145:
146: SELECT revision_qty_control_code,
147: lot_control_code,
148: serial_number_control_code

Line 153: WHERE inventory_item_id = inv_mwb_globals.g_tree_item_id

149: INTO l_rev_control,
150: l_lot_control,
151: l_serial_control
152: FROM mtl_system_items
153: WHERE inventory_item_id = inv_mwb_globals.g_tree_item_id
154: AND organization_id = inv_mwb_globals.g_tree_organization_id;
155:
156: IF inv_mwb_globals.g_chk_onhand = 1 THEN
157:

Line 154: AND organization_id = inv_mwb_globals.g_tree_organization_id;

150: l_lot_control,
151: l_serial_control
152: FROM mtl_system_items
153: WHERE inventory_item_id = inv_mwb_globals.g_tree_item_id
154: AND organization_id = inv_mwb_globals.g_tree_organization_id;
155:
156: IF inv_mwb_globals.g_chk_onhand = 1 THEN
157:
158: IF NVL(l_rev_control, 1) = 1 AND NVL(l_lot_control, 1) = 1

Line 156: IF inv_mwb_globals.g_chk_onhand = 1 THEN

152: FROM mtl_system_items
153: WHERE inventory_item_id = inv_mwb_globals.g_tree_item_id
154: AND organization_id = inv_mwb_globals.g_tree_organization_id;
155:
156: IF inv_mwb_globals.g_chk_onhand = 1 THEN
157:
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:

Line 172: IF inv_mwb_globals.g_serial_from IS NOT NULL OR

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
175: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL -- Bug 6429880
176: OR inv_mwb_globals.g_unit_number IS NOT NULL -- Bug 9365452

Line 173: inv_mwb_globals.g_serial_to IS NOT NULL

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
175: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL -- Bug 6429880
176: OR inv_mwb_globals.g_unit_number IS NOT NULL -- Bug 9365452
177: THEN

Line 174: OR inv_mwb_globals.g_status_id IS NOT NULL -- Bug 6060233

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
175: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL -- Bug 6429880
176: OR inv_mwb_globals.g_unit_number IS NOT NULL -- Bug 9365452
177: THEN
178: make_common_queries('MSN_QUERY');

Line 175: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL -- Bug 6429880

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
175: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL -- Bug 6429880
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

Line 176: OR inv_mwb_globals.g_unit_number IS NOT NULL -- Bug 9365452

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
175: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL -- Bug 6429880
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 :=

Line 224: inv_mwb_globals.g_tree_organization_id

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(
227: 'onh_tree_inventory_item_id',
228: inv_mwb_globals.g_tree_item_id

Line 228: inv_mwb_globals.g_tree_item_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
231: inv_mwb_query_manager.execute_query;
232:

Line 253: inv_mwb_globals.print_msg(g_pkg_name, l_procedure_name, 'Entered');

249:
250: BEGIN
251:
252: l_procedure_name := 'REV_NODE_EVENT';
253: inv_mwb_globals.print_msg(g_pkg_name, l_procedure_name, 'Entered');
254: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_EXPANDED' THEN
255: inv_mwb_tree1.add_lots(
256: x_node_value
257: , x_node_tbl

Line 254: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_EXPANDED' THEN

250: BEGIN
251:
252: l_procedure_name := 'REV_NODE_EVENT';
253: inv_mwb_globals.print_msg(g_pkg_name, l_procedure_name, 'Entered');
254: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_EXPANDED' THEN
255: inv_mwb_tree1.add_lots(
256: x_node_value
257: , x_node_tbl
258: , x_tbl_index

Line 269: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN

265: , x_tbl_index
266: );
267: END IF;
268:
269: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
270:
271: SELECT lot_control_code,
272: serial_number_control_code
273: INTO l_lot_control,

Line 276: WHERE inventory_item_id = inv_mwb_globals.g_tree_item_id

272: serial_number_control_code
273: INTO l_lot_control,
274: l_serial_control
275: FROM mtl_system_items
276: WHERE inventory_item_id = inv_mwb_globals.g_tree_item_id
277: AND organization_id = inv_mwb_globals.g_tree_organization_id;
278:
279: IF inv_mwb_globals.g_chk_onhand = 1 THEN
280:

Line 277: AND organization_id = inv_mwb_globals.g_tree_organization_id;

273: INTO l_lot_control,
274: l_serial_control
275: FROM mtl_system_items
276: WHERE inventory_item_id = inv_mwb_globals.g_tree_item_id
277: AND organization_id = inv_mwb_globals.g_tree_organization_id;
278:
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

Line 279: IF inv_mwb_globals.g_chk_onhand = 1 THEN

275: FROM mtl_system_items
276: WHERE inventory_item_id = inv_mwb_globals.g_tree_item_id
277: AND organization_id = inv_mwb_globals.g_tree_organization_id;
278:
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 :=

Line 292: IF inv_mwb_globals.g_serial_from IS NOT NULL OR

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

Line 293: inv_mwb_globals.g_serial_to IS NOT NULL

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

Line 294: OR inv_mwb_globals.g_status_id IS NOT NULL -- Bug 6060233

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

Line 295: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL -- Bug 6429880

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

Line 296: OR inv_mwb_globals.g_unit_number IS NOT NULL -- Bug 9365452

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

Line 339: inv_mwb_globals.g_tree_organization_id

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(
342: 'onh_tree_inventory_item_id',
343: inv_mwb_globals.g_tree_item_id

Line 343: inv_mwb_globals.g_tree_item_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(
346: 'onh_tree_revision',
347: inv_mwb_globals.g_tree_rev

Line 347: inv_mwb_globals.g_tree_rev

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
350: inv_mwb_query_manager.execute_query;
351: END IF;

Line 370: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_EXPANDED' THEN

366: BEGIN
367:
368: l_procedure_name := 'LOT_NODE_EVENT';
369:
370: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_EXPANDED' THEN
371:
372: inv_mwb_tree1.add_serials(
373: x_node_value
374: , x_node_tbl

Line 378: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN

374: , x_node_tbl
375: , x_tbl_index
376: );
377:
378: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
379:
380: SELECT revision_qty_control_code,
381: serial_number_control_code
382: INTO l_rev_control,

Line 385: WHERE organization_id = inv_mwb_globals.g_tree_organization_id

381: serial_number_control_code
382: INTO l_rev_control,
383: l_serial_control
384: FROM mtl_system_items
385: WHERE organization_id = inv_mwb_globals.g_tree_organization_id
386: AND inventory_item_id = inv_mwb_globals.g_tree_item_id;
387:
388: IF inv_mwb_globals.g_chk_onhand = 1 THEN
389:

Line 386: AND inventory_item_id = inv_mwb_globals.g_tree_item_id;

382: INTO l_rev_control,
383: l_serial_control
384: FROM mtl_system_items
385: WHERE organization_id = inv_mwb_globals.g_tree_organization_id
386: AND inventory_item_id = inv_mwb_globals.g_tree_item_id;
387:
388: IF inv_mwb_globals.g_chk_onhand = 1 THEN
389:
390: IF l_serial_control IN ( 2,5 ) THEN

Line 388: IF inv_mwb_globals.g_chk_onhand = 1 THEN

384: FROM mtl_system_items
385: WHERE organization_id = inv_mwb_globals.g_tree_organization_id
386: AND inventory_item_id = inv_mwb_globals.g_tree_item_id;
387:
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 :=

Line 406: IF inv_mwb_globals.g_serial_from IS NOT NULL OR

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
409: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL -- Bug 6429880
410: OR inv_mwb_globals.g_unit_number IS NOT NULL -- Bug 9365452

Line 407: inv_mwb_globals.g_serial_to IS NOT NULL

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
409: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL -- Bug 6429880
410: OR inv_mwb_globals.g_unit_number IS NOT NULL -- Bug 9365452
411: THEN

Line 408: OR inv_mwb_globals.g_status_id IS NOT NULL -- Bug 6060233

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
409: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL -- Bug 6429880
410: OR inv_mwb_globals.g_unit_number IS NOT NULL -- Bug 9365452
411: THEN
412: make_common_queries('MSN_QUERY');

Line 409: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL -- Bug 6429880

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
409: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL -- Bug 6429880
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

Line 410: OR inv_mwb_globals.g_unit_number IS NOT NULL -- Bug 9365452

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
409: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL -- Bug 6429880
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 :=

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 481: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN

477: BEGIN
478:
479: l_procedure_name := 'SERIAL_NODE_EVENT';
480:
481: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
482:
483: SELECT revision_qty_control_code,
484: lot_control_code
485: INTO l_rev_control,

Line 488: WHERE inventory_item_id = inv_mwb_globals.g_tree_item_id

484: lot_control_code
485: INTO l_rev_control,
486: l_lot_control
487: FROM mtl_system_items
488: WHERE inventory_item_id = inv_mwb_globals.g_tree_item_id
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');

Line 489: AND organization_id = inv_mwb_globals.g_tree_organization_id;

485: INTO l_rev_control,
486: l_lot_control
487: FROM mtl_system_items
488: WHERE inventory_item_id = inv_mwb_globals.g_tree_item_id
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');

Line 491: IF inv_mwb_globals.g_chk_onhand = 1 THEN

487: FROM mtl_system_items
488: WHERE inventory_item_id = inv_mwb_globals.g_tree_item_id
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);

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 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 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 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 526: IF(inv_mwb_globals.g_chk_onhand = 1) THEN

522:
523: PROCEDURE make_common_queries(p_flag VARCHAR2) IS
524: BEGIN
525:
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 :=

Line 650: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_EXPANDED' OR

646: BEGIN
647:
648: l_procedure_name := 'EVENT';
649:
650: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_EXPANDED' OR
651: inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
652:
653: CASE inv_mwb_globals.g_tree_node_type
654: WHEN 'APPTREE_OBJECT_TRUNK' THEN

Line 651: inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN

647:
648: l_procedure_name := 'EVENT';
649:
650: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_EXPANDED' OR
651: inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
652:
653: CASE inv_mwb_globals.g_tree_node_type
654: WHEN 'APPTREE_OBJECT_TRUNK' THEN
655: root_node_event (

Line 653: CASE inv_mwb_globals.g_tree_node_type

649:
650: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_EXPANDED' OR
651: inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
652:
653: CASE inv_mwb_globals.g_tree_node_type
654: WHEN 'APPTREE_OBJECT_TRUNK' THEN
655: root_node_event (
656: x_node_value
657: , x_node_tbl