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 THEN -- Bug 6429880
36: make_common_queries('MSN_QUERY');

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 THEN -- Bug 6429880
36: make_common_queries('MSN_QUERY');
37: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');

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 THEN -- Bug 6429880
36: make_common_queries('MSN_QUERY');
37: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
38: ELSE

Line 35: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL THEN -- 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 THEN -- Bug 6429880
36: make_common_queries('MSN_QUERY');
37: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
38: ELSE
39: make_common_queries('MOQD');

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

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

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

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

Line 70: IF inv_mwb_globals.g_chk_onhand = 1 THEN

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

Line 71: IF inv_mwb_globals.g_serial_from IS NOT NULL OR

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

Line 72: inv_mwb_globals.g_serial_to IS NOT NULL

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

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

69:
70: IF inv_mwb_globals.g_chk_onhand = 1 THEN
71: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
72: inv_mwb_globals.g_serial_to IS NOT NULL
73: OR inv_mwb_globals.g_status_id IS NOT NULL -- Bug 6060233
74: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL THEN -- Bug 6429880
75: make_common_queries('MSN_QUERY');
76: inv_mwb_query_manager.add_where_clause(
77: 'msn.inventory_item_id = :onh_tree_inventory_item_id' ,

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

70: IF inv_mwb_globals.g_chk_onhand = 1 THEN
71: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
72: inv_mwb_globals.g_serial_to IS NOT NULL
73: OR inv_mwb_globals.g_status_id IS NOT NULL -- Bug 6060233
74: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL THEN -- Bug 6429880
75: make_common_queries('MSN_QUERY');
76: inv_mwb_query_manager.add_where_clause(
77: 'msn.inventory_item_id = :onh_tree_inventory_item_id' ,
78: 'ONHAND'

Line 92: inv_mwb_globals.g_tree_item_id

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

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

113: BEGIN
114:
115: l_procedure_name := 'ORG_NODE_EVENT';
116:
117: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_EXPANDED' THEN
118: inv_mwb_tree1.add_revs(
119: x_node_value
120: , x_node_tbl
121: , x_tbl_index

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

136: );
137: END IF;
138: END IF;
139:
140: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
141:
142: SELECT revision_qty_control_code,
143: lot_control_code,
144: serial_number_control_code

Line 149: WHERE inventory_item_id = inv_mwb_globals.g_tree_item_id

145: INTO l_rev_control,
146: l_lot_control,
147: l_serial_control
148: FROM mtl_system_items
149: WHERE inventory_item_id = inv_mwb_globals.g_tree_item_id
150: AND organization_id = inv_mwb_globals.g_tree_organization_id;
151:
152: IF inv_mwb_globals.g_chk_onhand = 1 THEN
153:

Line 150: AND organization_id = inv_mwb_globals.g_tree_organization_id;

146: l_lot_control,
147: l_serial_control
148: FROM mtl_system_items
149: WHERE inventory_item_id = inv_mwb_globals.g_tree_item_id
150: AND organization_id = inv_mwb_globals.g_tree_organization_id;
151:
152: IF inv_mwb_globals.g_chk_onhand = 1 THEN
153:
154: IF NVL(l_rev_control, 1) = 1 AND NVL(l_lot_control, 1) = 1

Line 152: IF inv_mwb_globals.g_chk_onhand = 1 THEN

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

Line 168: IF inv_mwb_globals.g_serial_from IS NOT NULL OR

164: 'ONHAND'
165: );
166: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
167: ELSE -- only serial controlled
168: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
169: inv_mwb_globals.g_serial_to IS NOT NULL
170: OR inv_mwb_globals.g_status_id IS NOT NULL -- Bug 6060233
171: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL THEN -- Bug 6429880
172: make_common_queries('MSN_QUERY');

Line 169: inv_mwb_globals.g_serial_to IS NOT NULL

165: );
166: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
167: ELSE -- only serial controlled
168: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
169: inv_mwb_globals.g_serial_to IS NOT NULL
170: OR inv_mwb_globals.g_status_id IS NOT NULL -- Bug 6060233
171: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL THEN -- Bug 6429880
172: make_common_queries('MSN_QUERY');
173: IF l_rev_control = 2 THEN

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

166: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
167: ELSE -- only serial controlled
168: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
169: inv_mwb_globals.g_serial_to IS NOT NULL
170: OR inv_mwb_globals.g_status_id IS NOT NULL -- Bug 6060233
171: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL THEN -- Bug 6429880
172: make_common_queries('MSN_QUERY');
173: IF l_rev_control = 2 THEN
174: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.revision).column_value :=

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

167: ELSE -- only serial controlled
168: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
169: inv_mwb_globals.g_serial_to IS NOT NULL
170: OR inv_mwb_globals.g_status_id IS NOT NULL -- Bug 6060233
171: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL THEN -- Bug 6429880
172: make_common_queries('MSN_QUERY');
173: IF l_rev_control = 2 THEN
174: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.revision).column_value :=
175: 'msn.revision';

Line 218: inv_mwb_globals.g_tree_organization_id

214: END IF; -- serial in query find
215: END IF; -- only serial controlled
216: inv_mwb_query_manager.add_bind_variable(
217: 'onh_tree_organization_id',
218: inv_mwb_globals.g_tree_organization_id
219: );
220: inv_mwb_query_manager.add_bind_variable(
221: 'onh_tree_inventory_item_id',
222: inv_mwb_globals.g_tree_item_id

Line 222: inv_mwb_globals.g_tree_item_id

218: inv_mwb_globals.g_tree_organization_id
219: );
220: inv_mwb_query_manager.add_bind_variable(
221: 'onh_tree_inventory_item_id',
222: inv_mwb_globals.g_tree_item_id
223: );
224: END IF; -- onhand check
225: inv_mwb_query_manager.execute_query;
226:

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

243:
244: BEGIN
245:
246: l_procedure_name := 'REV_NODE_EVENT';
247: inv_mwb_globals.print_msg(g_pkg_name, l_procedure_name, 'Entered');
248: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_EXPANDED' THEN
249: inv_mwb_tree1.add_lots(
250: x_node_value
251: , x_node_tbl

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

244: BEGIN
245:
246: l_procedure_name := 'REV_NODE_EVENT';
247: inv_mwb_globals.print_msg(g_pkg_name, l_procedure_name, 'Entered');
248: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_EXPANDED' THEN
249: inv_mwb_tree1.add_lots(
250: x_node_value
251: , x_node_tbl
252: , x_tbl_index

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

259: , x_tbl_index
260: );
261: END IF;
262:
263: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
264:
265: SELECT lot_control_code,
266: serial_number_control_code
267: INTO l_lot_control,

Line 270: WHERE inventory_item_id = inv_mwb_globals.g_tree_item_id

266: serial_number_control_code
267: INTO l_lot_control,
268: l_serial_control
269: FROM mtl_system_items
270: WHERE inventory_item_id = inv_mwb_globals.g_tree_item_id
271: AND organization_id = inv_mwb_globals.g_tree_organization_id;
272:
273: IF inv_mwb_globals.g_chk_onhand = 1 THEN
274:

Line 271: AND organization_id = inv_mwb_globals.g_tree_organization_id;

267: INTO l_lot_control,
268: l_serial_control
269: FROM mtl_system_items
270: WHERE inventory_item_id = inv_mwb_globals.g_tree_item_id
271: AND organization_id = inv_mwb_globals.g_tree_organization_id;
272:
273: IF inv_mwb_globals.g_chk_onhand = 1 THEN
274:
275: IF l_lot_control = 1 AND l_serial_control IN ( 2,5 ) THEN

Line 273: IF inv_mwb_globals.g_chk_onhand = 1 THEN

269: FROM mtl_system_items
270: WHERE inventory_item_id = inv_mwb_globals.g_tree_item_id
271: AND organization_id = inv_mwb_globals.g_tree_organization_id;
272:
273: IF inv_mwb_globals.g_chk_onhand = 1 THEN
274:
275: IF l_lot_control = 1 AND l_serial_control IN ( 2,5 ) THEN
276: make_common_queries('MSN');
277: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.revision).column_value :=

Line 286: IF inv_mwb_globals.g_serial_from IS NOT NULL OR

282: inv_mwb_query_manager.add_where_clause('msn.organization_id = :onh_tree_organization_id' ,'ONHAND');
283: inv_mwb_query_manager.add_where_clause('msn.revision = :onh_tree_revision' ,'ONHAND');
284: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
285: ELSE -- l_serial_control
286: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
287: inv_mwb_globals.g_serial_to IS NOT NULL
288: OR inv_mwb_globals.g_status_id IS NOT NULL -- Bug 6060233
289: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL THEN -- Bug 6429880
290: make_common_queries('MSN_QUERY');

Line 287: inv_mwb_globals.g_serial_to IS NOT NULL

283: inv_mwb_query_manager.add_where_clause('msn.revision = :onh_tree_revision' ,'ONHAND');
284: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
285: ELSE -- l_serial_control
286: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
287: inv_mwb_globals.g_serial_to IS NOT NULL
288: OR inv_mwb_globals.g_status_id IS NOT NULL -- Bug 6060233
289: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL THEN -- Bug 6429880
290: make_common_queries('MSN_QUERY');
291: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.revision).column_value :=

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

284: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
285: ELSE -- l_serial_control
286: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
287: inv_mwb_globals.g_serial_to IS NOT NULL
288: OR inv_mwb_globals.g_status_id IS NOT NULL -- Bug 6060233
289: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL THEN -- Bug 6429880
290: make_common_queries('MSN_QUERY');
291: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.revision).column_value :=
292: 'msn.revision';

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

285: ELSE -- l_serial_control
286: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
287: inv_mwb_globals.g_serial_to IS NOT NULL
288: OR inv_mwb_globals.g_status_id IS NOT NULL -- Bug 6060233
289: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL THEN -- Bug 6429880
290: make_common_queries('MSN_QUERY');
291: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.revision).column_value :=
292: 'msn.revision';
293: inv_mwb_query_manager.add_group_clause('msn.revision', 'ONHAND'); -- Bug 6060233

Line 331: inv_mwb_globals.g_tree_organization_id

327: END IF; -- serial entered in qf
328: END IF; -- l_serial_control
329: inv_mwb_query_manager.add_bind_variable(
330: 'onh_tree_organization_id',
331: inv_mwb_globals.g_tree_organization_id
332: );
333: inv_mwb_query_manager.add_bind_variable(
334: 'onh_tree_inventory_item_id',
335: inv_mwb_globals.g_tree_item_id

Line 335: inv_mwb_globals.g_tree_item_id

331: inv_mwb_globals.g_tree_organization_id
332: );
333: inv_mwb_query_manager.add_bind_variable(
334: 'onh_tree_inventory_item_id',
335: inv_mwb_globals.g_tree_item_id
336: );
337: inv_mwb_query_manager.add_bind_variable(
338: 'onh_tree_revision',
339: inv_mwb_globals.g_tree_rev

Line 339: inv_mwb_globals.g_tree_rev

335: inv_mwb_globals.g_tree_item_id
336: );
337: inv_mwb_query_manager.add_bind_variable(
338: 'onh_tree_revision',
339: inv_mwb_globals.g_tree_rev
340: );
341: END IF; --chk_onhand
342: inv_mwb_query_manager.execute_query;
343: END IF;

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

358: BEGIN
359:
360: l_procedure_name := 'LOT_NODE_EVENT';
361:
362: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_EXPANDED' THEN
363:
364: inv_mwb_tree1.add_serials(
365: x_node_value
366: , x_node_tbl

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

366: , x_node_tbl
367: , x_tbl_index
368: );
369:
370: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
371:
372: SELECT revision_qty_control_code,
373: serial_number_control_code
374: INTO l_rev_control,

Line 377: WHERE organization_id = inv_mwb_globals.g_tree_organization_id

373: serial_number_control_code
374: INTO l_rev_control,
375: l_serial_control
376: FROM mtl_system_items
377: WHERE organization_id = inv_mwb_globals.g_tree_organization_id
378: AND inventory_item_id = inv_mwb_globals.g_tree_item_id;
379:
380: IF inv_mwb_globals.g_chk_onhand = 1 THEN
381:

Line 378: AND inventory_item_id = inv_mwb_globals.g_tree_item_id;

374: INTO l_rev_control,
375: l_serial_control
376: FROM mtl_system_items
377: WHERE organization_id = inv_mwb_globals.g_tree_organization_id
378: AND inventory_item_id = inv_mwb_globals.g_tree_item_id;
379:
380: IF inv_mwb_globals.g_chk_onhand = 1 THEN
381:
382: IF l_serial_control IN ( 2,5 ) THEN

Line 380: IF inv_mwb_globals.g_chk_onhand = 1 THEN

376: FROM mtl_system_items
377: WHERE organization_id = inv_mwb_globals.g_tree_organization_id
378: AND inventory_item_id = inv_mwb_globals.g_tree_item_id;
379:
380: IF inv_mwb_globals.g_chk_onhand = 1 THEN
381:
382: IF l_serial_control IN ( 2,5 ) THEN
383: make_common_queries('MSN');
384: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=

Line 398: IF inv_mwb_globals.g_serial_from IS NOT NULL OR

394: inv_mwb_query_manager.add_where_clause('msn.revision = :onh_tree_revision' ,'ONHAND');
395: END IF;
396: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
397: ELSE -- l_serial_control
398: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
399: inv_mwb_globals.g_serial_to IS NOT NULL
400: OR inv_mwb_globals.g_status_id IS NOT NULL -- Bug 6060233
401: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL THEN -- Bug 6429880
402: make_common_queries('MSN_QUERY');

Line 399: inv_mwb_globals.g_serial_to IS NOT NULL

395: END IF;
396: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
397: ELSE -- l_serial_control
398: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
399: inv_mwb_globals.g_serial_to IS NOT NULL
400: OR inv_mwb_globals.g_status_id IS NOT NULL -- Bug 6060233
401: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL THEN -- Bug 6429880
402: make_common_queries('MSN_QUERY');
403: IF l_rev_control = 2 THEN

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

396: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
397: ELSE -- l_serial_control
398: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
399: inv_mwb_globals.g_serial_to IS NOT NULL
400: OR inv_mwb_globals.g_status_id IS NOT NULL -- Bug 6060233
401: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL THEN -- Bug 6429880
402: make_common_queries('MSN_QUERY');
403: IF l_rev_control = 2 THEN
404: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.revision).column_value :=

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

397: ELSE -- l_serial_control
398: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
399: inv_mwb_globals.g_serial_to IS NOT NULL
400: OR inv_mwb_globals.g_status_id IS NOT NULL -- Bug 6060233
401: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL THEN -- Bug 6429880
402: make_common_queries('MSN_QUERY');
403: IF l_rev_control = 2 THEN
404: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.revision).column_value :=
405: 'msn.revision';

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

440:
441: inv_mwb_query_manager.add_qf_where_onhand('ONHAND');
442: END IF; -- serial entered in qf
443: END IF; -- l_serial_control
444: inv_mwb_query_manager.add_bind_variable('onh_tree_organization_id', inv_mwb_globals.g_tree_organization_id);
445: inv_mwb_query_manager.add_bind_variable('onh_tree_inventory_item_id', inv_mwb_globals.g_tree_item_id);
446: inv_mwb_query_manager.add_bind_variable('onh_tree_lot_number', inv_mwb_globals.g_tree_lot_number);
447: IF l_rev_control = 2 THEN
448: inv_mwb_query_manager.add_bind_variable('onh_tree_revision', inv_mwb_globals.g_tree_rev);

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

441: inv_mwb_query_manager.add_qf_where_onhand('ONHAND');
442: END IF; -- serial entered in qf
443: END IF; -- l_serial_control
444: inv_mwb_query_manager.add_bind_variable('onh_tree_organization_id', inv_mwb_globals.g_tree_organization_id);
445: inv_mwb_query_manager.add_bind_variable('onh_tree_inventory_item_id', inv_mwb_globals.g_tree_item_id);
446: inv_mwb_query_manager.add_bind_variable('onh_tree_lot_number', inv_mwb_globals.g_tree_lot_number);
447: IF l_rev_control = 2 THEN
448: inv_mwb_query_manager.add_bind_variable('onh_tree_revision', inv_mwb_globals.g_tree_rev);
449: END IF;

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

442: END IF; -- serial entered in qf
443: END IF; -- l_serial_control
444: inv_mwb_query_manager.add_bind_variable('onh_tree_organization_id', inv_mwb_globals.g_tree_organization_id);
445: inv_mwb_query_manager.add_bind_variable('onh_tree_inventory_item_id', inv_mwb_globals.g_tree_item_id);
446: inv_mwb_query_manager.add_bind_variable('onh_tree_lot_number', inv_mwb_globals.g_tree_lot_number);
447: IF l_rev_control = 2 THEN
448: inv_mwb_query_manager.add_bind_variable('onh_tree_revision', inv_mwb_globals.g_tree_rev);
449: END IF;
450: END IF; --chk_onhand

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

444: inv_mwb_query_manager.add_bind_variable('onh_tree_organization_id', inv_mwb_globals.g_tree_organization_id);
445: inv_mwb_query_manager.add_bind_variable('onh_tree_inventory_item_id', inv_mwb_globals.g_tree_item_id);
446: inv_mwb_query_manager.add_bind_variable('onh_tree_lot_number', inv_mwb_globals.g_tree_lot_number);
447: IF l_rev_control = 2 THEN
448: inv_mwb_query_manager.add_bind_variable('onh_tree_revision', inv_mwb_globals.g_tree_rev);
449: END IF;
450: END IF; --chk_onhand
451: inv_mwb_query_manager.execute_query;
452:

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

467: BEGIN
468:
469: l_procedure_name := 'SERIAL_NODE_EVENT';
470:
471: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
472:
473: SELECT revision_qty_control_code,
474: lot_control_code
475: INTO l_rev_control,

Line 478: WHERE inventory_item_id = inv_mwb_globals.g_tree_item_id

474: lot_control_code
475: INTO l_rev_control,
476: l_lot_control
477: FROM mtl_system_items
478: WHERE inventory_item_id = inv_mwb_globals.g_tree_item_id
479: AND organization_id = inv_mwb_globals.g_tree_organization_id;
480:
481: IF inv_mwb_globals.g_chk_onhand = 1 THEN
482: make_common_queries('MSN');

Line 479: AND organization_id = inv_mwb_globals.g_tree_organization_id;

475: INTO l_rev_control,
476: l_lot_control
477: FROM mtl_system_items
478: WHERE inventory_item_id = inv_mwb_globals.g_tree_item_id
479: AND organization_id = inv_mwb_globals.g_tree_organization_id;
480:
481: IF inv_mwb_globals.g_chk_onhand = 1 THEN
482: make_common_queries('MSN');
483: inv_mwb_query_manager.add_where_clause('msn.inventory_item_id = :onh_tree_inventory_item_id' ,'ONHAND');

Line 481: IF inv_mwb_globals.g_chk_onhand = 1 THEN

477: FROM mtl_system_items
478: WHERE inventory_item_id = inv_mwb_globals.g_tree_item_id
479: AND organization_id = inv_mwb_globals.g_tree_organization_id;
480:
481: IF inv_mwb_globals.g_chk_onhand = 1 THEN
482: make_common_queries('MSN');
483: inv_mwb_query_manager.add_where_clause('msn.inventory_item_id = :onh_tree_inventory_item_id' ,'ONHAND');
484: inv_mwb_query_manager.add_where_clause('msn.current_organization_id = :onh_tree_organization_id' ,'ONHAND');
485: inv_mwb_query_manager.add_bind_variable('onh_tree_organization_id', inv_mwb_globals.g_tree_organization_id);

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

481: IF inv_mwb_globals.g_chk_onhand = 1 THEN
482: make_common_queries('MSN');
483: inv_mwb_query_manager.add_where_clause('msn.inventory_item_id = :onh_tree_inventory_item_id' ,'ONHAND');
484: inv_mwb_query_manager.add_where_clause('msn.current_organization_id = :onh_tree_organization_id' ,'ONHAND');
485: inv_mwb_query_manager.add_bind_variable('onh_tree_organization_id', inv_mwb_globals.g_tree_organization_id);
486: inv_mwb_query_manager.add_bind_variable('onh_tree_inventory_item_id', inv_mwb_globals.g_tree_item_id);
487: IF l_rev_control = 2 THEN
488: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.revision).column_value :=
489: 'msn.revision';

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

482: make_common_queries('MSN');
483: inv_mwb_query_manager.add_where_clause('msn.inventory_item_id = :onh_tree_inventory_item_id' ,'ONHAND');
484: inv_mwb_query_manager.add_where_clause('msn.current_organization_id = :onh_tree_organization_id' ,'ONHAND');
485: inv_mwb_query_manager.add_bind_variable('onh_tree_organization_id', inv_mwb_globals.g_tree_organization_id);
486: inv_mwb_query_manager.add_bind_variable('onh_tree_inventory_item_id', inv_mwb_globals.g_tree_item_id);
487: IF l_rev_control = 2 THEN
488: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.revision).column_value :=
489: 'msn.revision';
490: inv_mwb_query_manager.add_where_clause('msn.revision = :onh_tree_revision' ,'ONHAND');

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

487: IF l_rev_control = 2 THEN
488: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.revision).column_value :=
489: 'msn.revision';
490: inv_mwb_query_manager.add_where_clause('msn.revision = :onh_tree_revision' ,'ONHAND');
491: inv_mwb_query_manager.add_bind_variable('onh_tree_revision', inv_mwb_globals.g_tree_rev);
492: END IF;
493: IF l_lot_control = 2 THEN
494: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
495: 'msn.lot_number';

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

493: IF l_lot_control = 2 THEN
494: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
495: 'msn.lot_number';
496: inv_mwb_query_manager.add_where_clause('msn.lot_number = :onh_lot_number' ,'ONHAND');
497: inv_mwb_query_manager.add_bind_variable('onh_lot_number', inv_mwb_globals.g_tree_lot_number);
498: END IF;
499: inv_mwb_query_manager.add_where_clause('msn.serial_number = :onh_serial_number' ,'ONHAND');
500: inv_mwb_query_manager.add_where_clause('msn.current_status = 3' ,'ONHAND');
501: inv_mwb_query_manager.add_bind_variable('onh_serial_number', inv_mwb_globals.g_tree_serial_number);

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

497: inv_mwb_query_manager.add_bind_variable('onh_lot_number', inv_mwb_globals.g_tree_lot_number);
498: END IF;
499: inv_mwb_query_manager.add_where_clause('msn.serial_number = :onh_serial_number' ,'ONHAND');
500: inv_mwb_query_manager.add_where_clause('msn.current_status = 3' ,'ONHAND');
501: inv_mwb_query_manager.add_bind_variable('onh_serial_number', inv_mwb_globals.g_tree_serial_number);
502:
503: END IF;
504: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
505: inv_mwb_query_manager.execute_query;

Line 516: IF(inv_mwb_globals.g_chk_onhand = 1) THEN

512:
513: PROCEDURE make_common_queries(p_flag VARCHAR2) IS
514: BEGIN
515:
516: IF(inv_mwb_globals.g_chk_onhand = 1) THEN
517:
518: CASE p_flag
519: WHEN 'MSN' THEN
520: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ITEM_ID).column_value :=

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

636: BEGIN
637:
638: l_procedure_name := 'EVENT';
639:
640: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_EXPANDED' OR
641: inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
642:
643: CASE inv_mwb_globals.g_tree_node_type
644: WHEN 'APPTREE_OBJECT_TRUNK' THEN

Line 641: inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN

637:
638: l_procedure_name := 'EVENT';
639:
640: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_EXPANDED' OR
641: inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
642:
643: CASE inv_mwb_globals.g_tree_node_type
644: WHEN 'APPTREE_OBJECT_TRUNK' THEN
645: root_node_event (

Line 643: CASE inv_mwb_globals.g_tree_node_type

639:
640: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_EXPANDED' OR
641: inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
642:
643: CASE inv_mwb_globals.g_tree_node_type
644: WHEN 'APPTREE_OBJECT_TRUNK' THEN
645: root_node_event (
646: x_node_value
647: , x_node_tbl