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

APPS.INV_MWB_LOT_TREE dependencies on INV_MWB_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: inv_mwb_tree1.add_orgs(
24: x_node_value
25: , x_node_tbl
26: , x_tbl_index

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

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

Line 31: IF inv_mwb_globals.g_serial_from IS NOT NULL OR

27: );
28:
29: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
30:
31: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
32: inv_mwb_globals.g_serial_to IS NOT NULL OR
33: inv_mwb_globals.g_status_id IS NOT NULL -- Bug 6060233
34: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL -- Bug 6429880
35: OR inv_mwb_globals.g_unit_number IS NOT NULL -- Bug 9365452

Line 32: inv_mwb_globals.g_serial_to IS NOT NULL OR

28:
29: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
30:
31: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
32: inv_mwb_globals.g_serial_to IS NOT NULL OR
33: inv_mwb_globals.g_status_id IS NOT NULL -- Bug 6060233
34: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL -- Bug 6429880
35: OR inv_mwb_globals.g_unit_number IS NOT NULL -- Bug 9365452
36: THEN

Line 33: inv_mwb_globals.g_status_id IS NOT NULL -- Bug 6060233

29: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
30:
31: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
32: inv_mwb_globals.g_serial_to IS NOT NULL OR
33: inv_mwb_globals.g_status_id IS NOT NULL -- Bug 6060233
34: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL -- Bug 6429880
35: OR inv_mwb_globals.g_unit_number IS NOT NULL -- Bug 9365452
36: THEN
37: make_common_queries('MSN_QUERY');

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

30:
31: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
32: inv_mwb_globals.g_serial_to IS NOT NULL OR
33: inv_mwb_globals.g_status_id IS NOT NULL -- Bug 6060233
34: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL -- Bug 6429880
35: OR inv_mwb_globals.g_unit_number IS NOT NULL -- Bug 9365452
36: THEN
37: make_common_queries('MSN_QUERY');
38: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');

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

31: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
32: inv_mwb_globals.g_serial_to IS NOT NULL OR
33: inv_mwb_globals.g_status_id IS NOT NULL -- Bug 6060233
34: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL -- Bug 6429880
35: OR inv_mwb_globals.g_unit_number IS NOT NULL -- Bug 9365452
36: THEN
37: make_common_queries('MSN_QUERY');
38: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
39: ELSE

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

58: BEGIN
59:
60: l_procedure_name := 'ORG_NODE_EVENT';
61:
62: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_EXPANDED' THEN
63:
64: inv_mwb_tree1.add_lots(
65: x_node_value
66: , x_node_tbl

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

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

Line 72: IF inv_mwb_globals.g_serial_from IS NOT NULL OR

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

Line 73: inv_mwb_globals.g_serial_to IS NOT NULL

69:
70: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
71:
72: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
73: inv_mwb_globals.g_serial_to IS NOT NULL
74: OR inv_mwb_globals.g_status_id IS NOT NULL -- Bug 6060233
75: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL -- Bug 6429880
76: OR inv_mwb_globals.g_unit_number IS NOT NULL -- Bug 9365452
77: THEN

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

70: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
71:
72: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
73: inv_mwb_globals.g_serial_to IS NOT NULL
74: OR inv_mwb_globals.g_status_id IS NOT NULL -- Bug 6060233
75: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL -- Bug 6429880
76: OR inv_mwb_globals.g_unit_number IS NOT NULL -- Bug 9365452
77: THEN
78: make_common_queries('MSN_QUERY');

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

71:
72: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
73: inv_mwb_globals.g_serial_to IS NOT NULL
74: OR inv_mwb_globals.g_status_id IS NOT NULL -- Bug 6060233
75: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL -- Bug 6429880
76: OR inv_mwb_globals.g_unit_number IS NOT NULL -- Bug 9365452
77: THEN
78: make_common_queries('MSN_QUERY');
79: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=

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

72: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
73: inv_mwb_globals.g_serial_to IS NOT NULL
74: OR inv_mwb_globals.g_status_id IS NOT NULL -- Bug 6060233
75: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL -- Bug 6429880
76: OR inv_mwb_globals.g_unit_number IS NOT NULL -- Bug 9365452
77: THEN
78: make_common_queries('MSN_QUERY');
79: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
80: 'msn.lot_number';

Line 106: inv_mwb_globals.g_tree_organization_id

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

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

124:
125: BEGIN
126:
127: l_procedure_name := 'LOT_NODE_EVENT';
128: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_EXPANDED' THEN
129: inv_mwb_tree1.add_items(
130: x_node_value
131: , x_node_tbl
132: , x_tbl_index

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

131: , x_node_tbl
132: , x_tbl_index
133: );
134:
135: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
136:
137: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
138: inv_mwb_globals.g_serial_to IS NOT NULL
139: OR inv_mwb_globals.g_status_id IS NOT NULL -- Bug 6060233

Line 137: IF inv_mwb_globals.g_serial_from IS NOT NULL OR

133: );
134:
135: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
136:
137: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
138: inv_mwb_globals.g_serial_to IS NOT NULL
139: OR inv_mwb_globals.g_status_id IS NOT NULL -- Bug 6060233
140: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL -- Bug 6429880
141: OR inv_mwb_globals.g_unit_number IS NOT NULL -- Bug 9365452

Line 138: inv_mwb_globals.g_serial_to IS NOT NULL

134:
135: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
136:
137: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
138: inv_mwb_globals.g_serial_to IS NOT NULL
139: OR inv_mwb_globals.g_status_id IS NOT NULL -- Bug 6060233
140: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL -- Bug 6429880
141: OR inv_mwb_globals.g_unit_number IS NOT NULL -- Bug 9365452
142: THEN

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

135: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
136:
137: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
138: inv_mwb_globals.g_serial_to IS NOT NULL
139: OR inv_mwb_globals.g_status_id IS NOT NULL -- Bug 6060233
140: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL -- Bug 6429880
141: OR inv_mwb_globals.g_unit_number IS NOT NULL -- Bug 9365452
142: THEN
143: make_common_queries('MSN_QUERY');

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

136:
137: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
138: inv_mwb_globals.g_serial_to IS NOT NULL
139: OR inv_mwb_globals.g_status_id IS NOT NULL -- Bug 6060233
140: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL -- Bug 6429880
141: OR inv_mwb_globals.g_unit_number IS NOT NULL -- Bug 9365452
142: THEN
143: make_common_queries('MSN_QUERY');
144: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=

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

137: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
138: inv_mwb_globals.g_serial_to IS NOT NULL
139: OR inv_mwb_globals.g_status_id IS NOT NULL -- Bug 6060233
140: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL -- Bug 6429880
141: OR inv_mwb_globals.g_unit_number IS NOT NULL -- Bug 9365452
142: THEN
143: make_common_queries('MSN_QUERY');
144: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
145: 'msn.lot_number';

Line 180: inv_mwb_globals.g_tree_organization_id

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

Line 184: inv_mwb_globals.g_tree_lot_number

180: inv_mwb_globals.g_tree_organization_id
181: );
182: inv_mwb_query_manager.add_bind_variable(
183: 'onh_tree_lot_number',
184: inv_mwb_globals.g_tree_lot_number
185: );
186: inv_mwb_query_manager.execute_query;
187:
188: END IF;

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

204:
205: BEGIN
206:
207: l_procedure_name := 'ITEM_NODE_EVENT';
208: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_EXPANDED' THEN
209: inv_mwb_tree1.add_revs(
210: x_node_value
211: , x_node_tbl
212: , x_tbl_index

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

219: , x_tbl_index
220: );
221: END IF;
222:
223: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
224:
225: SELECT revision_qty_control_code,
226: serial_number_control_code
227: INTO l_rev_control,

Line 230: WHERE organization_id = inv_mwb_globals.g_tree_organization_id

226: serial_number_control_code
227: INTO l_rev_control,
228: l_serial_control
229: FROM mtl_system_items
230: WHERE organization_id = inv_mwb_globals.g_tree_organization_id
231: AND inventory_item_id = inv_mwb_globals.g_tree_item_id;
232:
233: IF NVL(l_rev_control, 1) = 1 AND l_serial_control IN (2,5) THEN
234: make_common_queries('MSN');

Line 231: AND inventory_item_id = inv_mwb_globals.g_tree_item_id;

227: INTO l_rev_control,
228: l_serial_control
229: FROM mtl_system_items
230: WHERE organization_id = inv_mwb_globals.g_tree_organization_id
231: AND inventory_item_id = inv_mwb_globals.g_tree_item_id;
232:
233: IF NVL(l_rev_control, 1) = 1 AND l_serial_control IN (2,5) THEN
234: make_common_queries('MSN');
235: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=

Line 253: IF inv_mwb_globals.g_serial_from IS NOT NULL OR

249: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
250:
251: ELSE -- item is not serial controlled
252:
253: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
254: inv_mwb_globals.g_serial_to IS NOT NULL
255: OR inv_mwb_globals.g_status_id IS NOT NULL -- Bug 6060233
256: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL -- Bug 6429880
257: OR inv_mwb_globals.g_unit_number IS NOT NULL -- Bug 9365452

Line 254: inv_mwb_globals.g_serial_to IS NOT NULL

250:
251: ELSE -- item is not serial controlled
252:
253: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
254: inv_mwb_globals.g_serial_to IS NOT NULL
255: OR inv_mwb_globals.g_status_id IS NOT NULL -- Bug 6060233
256: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL -- Bug 6429880
257: OR inv_mwb_globals.g_unit_number IS NOT NULL -- Bug 9365452
258: THEN

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

251: ELSE -- item is not serial controlled
252:
253: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
254: inv_mwb_globals.g_serial_to IS NOT NULL
255: OR inv_mwb_globals.g_status_id IS NOT NULL -- Bug 6060233
256: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL -- Bug 6429880
257: OR inv_mwb_globals.g_unit_number IS NOT NULL -- Bug 9365452
258: THEN
259: make_common_queries('MSN_QUERY');

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

252:
253: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
254: inv_mwb_globals.g_serial_to IS NOT NULL
255: OR inv_mwb_globals.g_status_id IS NOT NULL -- Bug 6060233
256: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL -- Bug 6429880
257: OR inv_mwb_globals.g_unit_number IS NOT NULL -- Bug 9365452
258: THEN
259: make_common_queries('MSN_QUERY');
260: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=

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

253: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
254: inv_mwb_globals.g_serial_to IS NOT NULL
255: OR inv_mwb_globals.g_status_id IS NOT NULL -- Bug 6060233
256: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL -- Bug 6429880
257: OR inv_mwb_globals.g_unit_number IS NOT NULL -- Bug 9365452
258: THEN
259: make_common_queries('MSN_QUERY');
260: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
261: 'msn.lot_number';

Line 322: inv_mwb_globals.g_tree_organization_id

318:
319: END IF; -- item is not serial controlled
320: inv_mwb_query_manager.add_bind_variable(
321: 'onh_tree_organization_id',
322: inv_mwb_globals.g_tree_organization_id
323: );
324: inv_mwb_query_manager.add_bind_variable(
325: 'onh_tree_lot_number',
326: inv_mwb_globals.g_tree_lot_number

Line 326: inv_mwb_globals.g_tree_lot_number

322: inv_mwb_globals.g_tree_organization_id
323: );
324: inv_mwb_query_manager.add_bind_variable(
325: 'onh_tree_lot_number',
326: inv_mwb_globals.g_tree_lot_number
327: );
328: inv_mwb_query_manager.add_bind_variable(
329: 'onh_tree_inventory_item_id',
330: inv_mwb_globals.g_tree_item_id

Line 330: inv_mwb_globals.g_tree_item_id

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

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

349: BEGIN
350:
351: l_procedure_name := 'REV_NODE_EVENT';
352:
353: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_EXPANDED' THEN
354:
355: inv_mwb_tree1.add_serials(
356: x_node_value
357: , x_node_tbl

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

357: , x_node_tbl
358: , x_tbl_index
359: );
360:
361: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
362:
363: SELECT serial_number_control_code
364: INTO l_serial_control
365: FROM mtl_system_items

Line 366: WHERE organization_id = inv_mwb_globals.g_tree_organization_id

362:
363: SELECT serial_number_control_code
364: INTO l_serial_control
365: FROM mtl_system_items
366: WHERE organization_id = inv_mwb_globals.g_tree_organization_id
367: AND inventory_item_id = inv_mwb_globals.g_tree_item_id;
368:
369: IF l_serial_control in ( 2,5 ) THEN
370: make_common_queries('MSN');

Line 367: AND inventory_item_id = inv_mwb_globals.g_tree_item_id;

363: SELECT serial_number_control_code
364: INTO l_serial_control
365: FROM mtl_system_items
366: WHERE organization_id = inv_mwb_globals.g_tree_organization_id
367: AND inventory_item_id = inv_mwb_globals.g_tree_item_id;
368:
369: IF l_serial_control in ( 2,5 ) THEN
370: make_common_queries('MSN');
371: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=

Line 430: inv_mwb_globals.g_tree_organization_id

426: inv_mwb_query_manager.add_qf_where_onhand('ONHAND');
427: END IF;
428: inv_mwb_query_manager.add_bind_variable(
429: 'onh_tree_organization_id',
430: inv_mwb_globals.g_tree_organization_id
431: );
432: inv_mwb_query_manager.add_bind_variable(
433: 'onh_tree_lot_number',
434: inv_mwb_globals.g_tree_lot_number

Line 434: inv_mwb_globals.g_tree_lot_number

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

Line 438: inv_mwb_globals.g_tree_item_id

434: inv_mwb_globals.g_tree_lot_number
435: );
436: inv_mwb_query_manager.add_bind_variable(
437: 'onh_tree_inventory_item_id',
438: inv_mwb_globals.g_tree_item_id
439: );
440: inv_mwb_query_manager.add_bind_variable(
441: 'onh_tree_revision',
442: inv_mwb_globals.g_tree_rev

Line 442: inv_mwb_globals.g_tree_rev

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

Line 466: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN

462: BEGIN
463:
464: l_procedure_name := 'SERIAL_NODE_EVENT';
465:
466: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
467:
468: SELECT revision_qty_control_code
469: INTO l_rev_control
470: FROM mtl_system_items

Line 471: WHERE organization_id = inv_mwb_globals.g_tree_organization_id

467:
468: SELECT revision_qty_control_code
469: INTO l_rev_control
470: FROM mtl_system_items
471: WHERE organization_id = inv_mwb_globals.g_tree_organization_id
472: AND inventory_item_id = inv_mwb_globals.g_tree_item_id;
473:
474: make_common_queries('MSN');
475: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=

Line 472: AND inventory_item_id = inv_mwb_globals.g_tree_item_id;

468: SELECT revision_qty_control_code
469: INTO l_rev_control
470: FROM mtl_system_items
471: WHERE organization_id = inv_mwb_globals.g_tree_organization_id
472: AND inventory_item_id = inv_mwb_globals.g_tree_item_id;
473:
474: make_common_queries('MSN');
475: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
476: 'msn.lot_number';

Line 488: inv_mwb_globals.g_tree_rev

484: 'ONHAND'
485: );
486: inv_mwb_query_manager.add_bind_variable(
487: 'onh_tree_revision',
488: inv_mwb_globals.g_tree_rev
489: );
490: END IF;
491: inv_mwb_query_manager.add_where_clause(
492: 'msn.current_organization_id = :onh_tree_organization_id' ,

Line 510: inv_mwb_globals.g_tree_organization_id

506: );
507: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
508: inv_mwb_query_manager.add_bind_variable(
509: 'onh_tree_organization_id',
510: inv_mwb_globals.g_tree_organization_id
511: );
512: inv_mwb_query_manager.add_bind_variable(
513: 'onh_tree_lot_number',
514: inv_mwb_globals.g_tree_lot_number

Line 514: inv_mwb_globals.g_tree_lot_number

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

Line 518: inv_mwb_globals.g_tree_item_id

514: inv_mwb_globals.g_tree_lot_number
515: );
516: inv_mwb_query_manager.add_bind_variable(
517: 'onh_tree_inventory_item_id',
518: inv_mwb_globals.g_tree_item_id
519: );
520: inv_mwb_query_manager.add_bind_variable(
521: 'onh_tree_serial_number',
522: inv_mwb_globals.g_tree_serial_number

Line 522: inv_mwb_globals.g_tree_serial_number

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

Line 652: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_EXPANDED'

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

Line 653: OR inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN

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

Line 655: CASE inv_mwb_globals.g_tree_node_type

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