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_SERIAL_TREE dependencies on INV_MWB_GLOBALS

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

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

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: make_common_queries('MSN_QUERY');
33: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
34: inv_mwb_query_manager.execute_query;

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

51: BEGIN
52:
53: l_procedure_name := 'ORG_NODE_EVENT';
54:
55: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_EXPANDED' THEN
56: inv_mwb_tree1.add_serials(
57: x_node_value
58: , x_node_tbl
59: , x_tbl_index

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

58: , x_node_tbl
59: , x_tbl_index
60: );
61:
62: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
63:
64: make_common_queries('MSN');
65: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SERIAL).column_value :=
66: 'msn.serial_number';

Line 73: inv_mwb_globals.g_tree_organization_id

69: 'ONHAND'
70: );
71: inv_mwb_query_manager.add_bind_variable(
72: 'onh_tree_organization_id' ,
73: inv_mwb_globals.g_tree_organization_id
74: );
75: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
76: inv_mwb_query_manager.execute_query;
77:

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

93: BEGIN
94:
95: l_procedure_name := 'SERIAL_NODE_EVENT';
96:
97: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_EXPANDED' THEN
98: inv_mwb_tree1.add_items(
99: x_node_value
100: , x_node_tbl
101: , x_tbl_index

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

100: , x_node_tbl
101: , x_tbl_index
102: );
103:
104: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
105:
106: make_common_queries('MSN');
107: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SERIAL).column_value :=
108: 'msn.serial_number';

Line 125: inv_mwb_globals.g_tree_organization_id

121: 'ONHAND'
122: );
123: inv_mwb_query_manager.add_bind_variable(
124: 'onh_tree_organization_id' ,
125: inv_mwb_globals.g_tree_organization_id
126: );
127: inv_mwb_query_manager.add_bind_variable(
128: 'onh_tree_serial_number' ,
129: inv_mwb_globals.g_tree_serial_number

Line 129: inv_mwb_globals.g_tree_serial_number

125: inv_mwb_globals.g_tree_organization_id
126: );
127: inv_mwb_query_manager.add_bind_variable(
128: 'onh_tree_serial_number' ,
129: inv_mwb_globals.g_tree_serial_number
130: );
131: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
132: inv_mwb_query_manager.execute_query;
133:

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

150: BEGIN
151:
152: l_procedure_name := 'ITEM_NODE_EVENT';
153:
154: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_EXPANDED' THEN
155: inv_mwb_tree1.add_revs(
156: x_node_value
157: , x_node_tbl
158: , x_tbl_index

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

165: , x_tbl_index
166: );
167: END IF;
168:
169: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
170:
171: SELECT revision_qty_control_code,
172: lot_control_code
173: INTO l_rev_control,

Line 176: WHERE organization_id = inv_mwb_globals.g_tree_organization_id

172: lot_control_code
173: INTO l_rev_control,
174: l_lot_control
175: FROM mtl_system_items
176: WHERE organization_id = inv_mwb_globals.g_tree_organization_id
177: AND inventory_item_id = inv_mwb_globals.g_tree_item_id;
178:
179: make_common_queries('MSN');
180: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SERIAL).column_value :=

Line 177: AND inventory_item_id = inv_mwb_globals.g_tree_item_id;

173: INTO l_rev_control,
174: l_lot_control
175: FROM mtl_system_items
176: WHERE organization_id = inv_mwb_globals.g_tree_organization_id
177: AND inventory_item_id = inv_mwb_globals.g_tree_item_id;
178:
179: make_common_queries('MSN');
180: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SERIAL).column_value :=
181: 'msn.serial_number';

Line 202: inv_mwb_globals.g_tree_organization_id

198: 'ONHAND'
199: );
200: inv_mwb_query_manager.add_bind_variable(
201: 'onh_tree_organization_id' ,
202: inv_mwb_globals.g_tree_organization_id
203: );
204: inv_mwb_query_manager.add_bind_variable(
205: 'onh_tree_serial_number' ,
206: inv_mwb_globals.g_tree_serial_number

Line 206: inv_mwb_globals.g_tree_serial_number

202: inv_mwb_globals.g_tree_organization_id
203: );
204: inv_mwb_query_manager.add_bind_variable(
205: 'onh_tree_serial_number' ,
206: inv_mwb_globals.g_tree_serial_number
207: );
208: inv_mwb_query_manager.add_bind_variable(
209: 'onh_tree_inventory_item_id' ,
210: inv_mwb_globals.g_tree_item_id

Line 210: inv_mwb_globals.g_tree_item_id

206: inv_mwb_globals.g_tree_serial_number
207: );
208: inv_mwb_query_manager.add_bind_variable(
209: 'onh_tree_inventory_item_id' ,
210: inv_mwb_globals.g_tree_item_id
211: );
212:
213: IF l_rev_control = 1 AND l_lot_control = 2 THEN
214: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=

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

240: BEGIN
241:
242: l_procedure_name := 'REV_NODE_EVENT';
243:
244: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_EXPANDED' THEN
245: inv_mwb_tree1.add_lots(
246: x_node_value
247: , x_node_tbl
248: , x_tbl_index

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

247: , x_node_tbl
248: , x_tbl_index
249: );
250:
251: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
252:
253: SELECT lot_control_code
254: INTO l_lot_control
255: FROM mtl_system_items

Line 256: WHERE organization_id = inv_mwb_globals.g_tree_organization_id

252:
253: SELECT lot_control_code
254: INTO l_lot_control
255: FROM mtl_system_items
256: WHERE organization_id = inv_mwb_globals.g_tree_organization_id
257: AND inventory_item_id = inv_mwb_globals.g_tree_item_id;
258:
259: make_common_queries('MSN');
260: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SERIAL).column_value :=

Line 257: AND inventory_item_id = inv_mwb_globals.g_tree_item_id;

253: SELECT lot_control_code
254: INTO l_lot_control
255: FROM mtl_system_items
256: WHERE organization_id = inv_mwb_globals.g_tree_organization_id
257: AND inventory_item_id = inv_mwb_globals.g_tree_item_id;
258:
259: make_common_queries('MSN');
260: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SERIAL).column_value :=
261: 'msn.serial_number';

Line 288: inv_mwb_globals.g_tree_organization_id

284: 'ONHAND'
285: );
286: inv_mwb_query_manager.add_bind_variable(
287: 'onh_tree_organization_id' ,
288: inv_mwb_globals.g_tree_organization_id
289: );
290: inv_mwb_query_manager.add_bind_variable(
291: 'onh_tree_serial_number' ,
292: inv_mwb_globals.g_tree_serial_number

Line 292: inv_mwb_globals.g_tree_serial_number

288: inv_mwb_globals.g_tree_organization_id
289: );
290: inv_mwb_query_manager.add_bind_variable(
291: 'onh_tree_serial_number' ,
292: inv_mwb_globals.g_tree_serial_number
293: );
294: inv_mwb_query_manager.add_bind_variable(
295: 'onh_tree_inventory_item_id' ,
296: inv_mwb_globals.g_tree_item_id

Line 296: inv_mwb_globals.g_tree_item_id

292: inv_mwb_globals.g_tree_serial_number
293: );
294: inv_mwb_query_manager.add_bind_variable(
295: 'onh_tree_inventory_item_id' ,
296: inv_mwb_globals.g_tree_item_id
297: );
298: inv_mwb_query_manager.add_bind_variable(
299: 'onh_tree_revision' ,
300: inv_mwb_globals.g_tree_rev

Line 300: inv_mwb_globals.g_tree_rev

296: inv_mwb_globals.g_tree_item_id
297: );
298: inv_mwb_query_manager.add_bind_variable(
299: 'onh_tree_revision' ,
300: inv_mwb_globals.g_tree_rev
301: );
302:
303: IF l_lot_control = 2 THEN
304: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=

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

326: BEGIN
327:
328: l_procedure_name := 'LOT_NODE_EVENT';
329:
330: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
331:
332: SELECT revision_qty_control_code
333: INTO l_rev_control
334: FROM mtl_system_items

Line 335: WHERE organization_id = inv_mwb_globals.g_tree_organization_id

331:
332: SELECT revision_qty_control_code
333: INTO l_rev_control
334: FROM mtl_system_items
335: WHERE organization_id = inv_mwb_globals.g_tree_organization_id
336: AND inventory_item_id = inv_mwb_globals.g_tree_item_id;
337:
338: make_common_queries('MSN');
339: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SERIAL).column_value :=

Line 336: AND inventory_item_id = inv_mwb_globals.g_tree_item_id;

332: SELECT revision_qty_control_code
333: INTO l_rev_control
334: FROM mtl_system_items
335: WHERE organization_id = inv_mwb_globals.g_tree_organization_id
336: AND inventory_item_id = inv_mwb_globals.g_tree_item_id;
337:
338: make_common_queries('MSN');
339: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SERIAL).column_value :=
340: 'msn.serial_number';

Line 363: inv_mwb_globals.g_tree_organization_id

359: 'ONHAND'
360: );
361: inv_mwb_query_manager.add_bind_variable(
362: 'onh_tree_organization_id' ,
363: inv_mwb_globals.g_tree_organization_id
364: );
365: inv_mwb_query_manager.add_bind_variable(
366: 'onh_tree_serial_number' ,
367: inv_mwb_globals.g_tree_serial_number

Line 367: inv_mwb_globals.g_tree_serial_number

363: inv_mwb_globals.g_tree_organization_id
364: );
365: inv_mwb_query_manager.add_bind_variable(
366: 'onh_tree_serial_number' ,
367: inv_mwb_globals.g_tree_serial_number
368: );
369: inv_mwb_query_manager.add_bind_variable(
370: 'onh_tree_inventory_item_id' ,
371: inv_mwb_globals.g_tree_item_id

Line 371: inv_mwb_globals.g_tree_item_id

367: inv_mwb_globals.g_tree_serial_number
368: );
369: inv_mwb_query_manager.add_bind_variable(
370: 'onh_tree_inventory_item_id' ,
371: inv_mwb_globals.g_tree_item_id
372: );
373:
374: IF l_rev_control = 2 THEN
375: inv_mwb_query_manager.add_where_clause(

Line 383: inv_mwb_globals.g_tree_rev

379: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.revision).column_value :=
380: 'msn.revision';
381: inv_mwb_query_manager.add_bind_variable(
382: 'onh_tree_revision' ,
383: inv_mwb_globals.g_tree_rev
384: );
385: END IF;
386: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
387: inv_mwb_query_manager.execute_query;

Line 445: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_EXPANDED'

441: BEGIN
442:
443: l_procedure_name := 'EVENT';
444:
445: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_EXPANDED'
446: OR inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
447:
448: CASE inv_mwb_globals.g_tree_node_type
449:

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

442:
443: l_procedure_name := 'EVENT';
444:
445: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_EXPANDED'
446: OR inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
447:
448: CASE inv_mwb_globals.g_tree_node_type
449:
450: WHEN 'APPTREE_OBJECT_TRUNK' THEN

Line 448: CASE inv_mwb_globals.g_tree_node_type

444:
445: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_EXPANDED'
446: OR inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
447:
448: CASE inv_mwb_globals.g_tree_node_type
449:
450: WHEN 'APPTREE_OBJECT_TRUNK' THEN
451: root_node_event (
452: x_node_value