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_COST_GROUP_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_cgs(
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
33: OR 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
33: OR inv_mwb_globals.g_status_id IS NOT NULL -- Bug 6060233
34: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL THEN -- Bug 6429880
35: make_common_queries('MSN_QUERY');

Line 32: inv_mwb_globals.g_serial_to IS NOT NULL

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
33: OR inv_mwb_globals.g_status_id IS NOT NULL -- Bug 6060233
34: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL THEN -- Bug 6429880
35: make_common_queries('MSN_QUERY');
36: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');

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

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

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

58: BEGIN
59:
60: l_procedure_name := 'COST_GROUP_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 69: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN

65: , x_node_tbl
66: , x_tbl_index
67: );
68:
69: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
70:
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

Line 71: IF inv_mwb_globals.g_serial_from IS NOT NULL OR

67: );
68:
69: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
70:
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:
69: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
70:
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('msn.cost_group_id = :onh_tree_cost_group_id' ,'ONHAND');

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

69: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
70:
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('msn.cost_group_id = :onh_tree_cost_group_id' ,'ONHAND');
77: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');

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

70:
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('msn.cost_group_id = :onh_tree_cost_group_id' ,'ONHAND');
77: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
78: ELSE

Line 84: inv_mwb_query_manager.add_bind_variable('onh_tree_cost_group_id', inv_mwb_globals.g_tree_cg_id);

80: inv_mwb_query_manager.add_where_clause('moqd.cost_group_id = :onh_tree_cost_group_id' ,'ONHAND');
81:
82: inv_mwb_query_manager.add_qf_where_onhand('ONHAND');
83: END IF;
84: inv_mwb_query_manager.add_bind_variable('onh_tree_cost_group_id', inv_mwb_globals.g_tree_cg_id);
85: inv_mwb_query_manager.execute_query;
86:
87: END IF; -- event
88:

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

102: BEGIN
103:
104: l_procedure_name := 'ORG_NODE_EVENT';
105:
106: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_EXPANDED' THEN
107: inv_mwb_tree1.add_items(
108: x_node_value
109: , x_node_tbl
110: , x_tbl_index

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

109: , x_node_tbl
110: , x_tbl_index
111: );
112:
113: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
114:
115: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
116: inv_mwb_globals.g_serial_to IS NOT NULL
117: OR inv_mwb_globals.g_status_id IS NOT NULL -- Bug 6060233

Line 115: IF inv_mwb_globals.g_serial_from IS NOT NULL OR

111: );
112:
113: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
114:
115: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
116: inv_mwb_globals.g_serial_to IS NOT NULL
117: OR inv_mwb_globals.g_status_id IS NOT NULL -- Bug 6060233
118: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL THEN -- Bug 6429880
119: make_common_queries('MSN_QUERY');

Line 116: inv_mwb_globals.g_serial_to IS NOT NULL

112:
113: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
114:
115: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
116: inv_mwb_globals.g_serial_to IS NOT NULL
117: OR inv_mwb_globals.g_status_id IS NOT NULL -- Bug 6060233
118: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL THEN -- Bug 6429880
119: make_common_queries('MSN_QUERY');
120: inv_mwb_query_manager.add_where_clause('msn.cost_group_id = :onh_tree_cost_group_id' ,'ONHAND');

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

113: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
114:
115: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
116: inv_mwb_globals.g_serial_to IS NOT NULL
117: OR inv_mwb_globals.g_status_id IS NOT NULL -- Bug 6060233
118: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL THEN -- Bug 6429880
119: make_common_queries('MSN_QUERY');
120: inv_mwb_query_manager.add_where_clause('msn.cost_group_id = :onh_tree_cost_group_id' ,'ONHAND');
121: inv_mwb_query_manager.add_where_clause('msn.current_organization_id = :onh_tree_organization_id' ,'ONHAND');

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

114:
115: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
116: inv_mwb_globals.g_serial_to IS NOT NULL
117: OR inv_mwb_globals.g_status_id IS NOT NULL -- Bug 6060233
118: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL THEN -- Bug 6429880
119: make_common_queries('MSN_QUERY');
120: inv_mwb_query_manager.add_where_clause('msn.cost_group_id = :onh_tree_cost_group_id' ,'ONHAND');
121: inv_mwb_query_manager.add_where_clause('msn.current_organization_id = :onh_tree_organization_id' ,'ONHAND');
122: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');

Line 130: inv_mwb_query_manager.add_bind_variable('onh_tree_cost_group_id', inv_mwb_globals.g_tree_cg_id);

126: inv_mwb_query_manager.add_where_clause('moqd.organization_id = :onh_tree_organization_id' ,'ONHAND');
127:
128: inv_mwb_query_manager.add_qf_where_onhand('ONHAND');
129: END IF;
130: inv_mwb_query_manager.add_bind_variable('onh_tree_cost_group_id', inv_mwb_globals.g_tree_cg_id);
131: inv_mwb_query_manager.add_bind_variable('onh_tree_organization_id', inv_mwb_globals.g_tree_organization_id);
132: inv_mwb_query_manager.execute_query;
133:
134: END IF; -- tree event

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

127:
128: inv_mwb_query_manager.add_qf_where_onhand('ONHAND');
129: END IF;
130: inv_mwb_query_manager.add_bind_variable('onh_tree_cost_group_id', inv_mwb_globals.g_tree_cg_id);
131: inv_mwb_query_manager.add_bind_variable('onh_tree_organization_id', inv_mwb_globals.g_tree_organization_id);
132: inv_mwb_query_manager.execute_query;
133:
134: END IF; -- tree event
135:

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

148:
149: BEGIN
150:
151: l_procedure_name := 'ITEM_NODE_EVENT';
152: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
153:
154: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
155: inv_mwb_globals.g_serial_to IS NOT NULL
156: OR inv_mwb_globals.g_status_id IS NOT NULL -- Bug 6060233

Line 154: IF inv_mwb_globals.g_serial_from IS NOT NULL OR

150:
151: l_procedure_name := 'ITEM_NODE_EVENT';
152: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
153:
154: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
155: inv_mwb_globals.g_serial_to IS NOT NULL
156: OR inv_mwb_globals.g_status_id IS NOT NULL -- Bug 6060233
157: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL THEN -- Bug 6429880
158: make_common_queries('MSN_QUERY');

Line 155: inv_mwb_globals.g_serial_to IS NOT NULL

151: l_procedure_name := 'ITEM_NODE_EVENT';
152: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
153:
154: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
155: inv_mwb_globals.g_serial_to IS NOT NULL
156: OR inv_mwb_globals.g_status_id IS NOT NULL -- Bug 6060233
157: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL THEN -- Bug 6429880
158: make_common_queries('MSN_QUERY');
159: inv_mwb_query_manager.add_where_clause('msn.cost_group_id = :onh_tree_cost_group_id' ,'ONHAND');

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

152: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
153:
154: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
155: inv_mwb_globals.g_serial_to IS NOT NULL
156: OR inv_mwb_globals.g_status_id IS NOT NULL -- Bug 6060233
157: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL THEN -- Bug 6429880
158: make_common_queries('MSN_QUERY');
159: inv_mwb_query_manager.add_where_clause('msn.cost_group_id = :onh_tree_cost_group_id' ,'ONHAND');
160: inv_mwb_query_manager.add_where_clause('msn.current_organization_id = :onh_tree_organization_id' ,'ONHAND');

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

153:
154: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
155: inv_mwb_globals.g_serial_to IS NOT NULL
156: OR inv_mwb_globals.g_status_id IS NOT NULL -- Bug 6060233
157: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL THEN -- Bug 6429880
158: make_common_queries('MSN_QUERY');
159: inv_mwb_query_manager.add_where_clause('msn.cost_group_id = :onh_tree_cost_group_id' ,'ONHAND');
160: inv_mwb_query_manager.add_where_clause('msn.current_organization_id = :onh_tree_organization_id' ,'ONHAND');
161: inv_mwb_query_manager.add_where_clause('msn.inventory_item_id = :onh_tree_inventory_item_id' ,'ONHAND');

Line 171: inv_mwb_query_manager.add_bind_variable('onh_tree_cost_group_id', inv_mwb_globals.g_tree_cg_id);

167: inv_mwb_query_manager.add_where_clause('moqd.inventory_item_id = :onh_tree_inventory_item_id' ,'ONHAND');
168:
169: inv_mwb_query_manager.add_qf_where_onhand('ONHAND');
170: END IF;
171: inv_mwb_query_manager.add_bind_variable('onh_tree_cost_group_id', inv_mwb_globals.g_tree_cg_id);
172: inv_mwb_query_manager.add_bind_variable('onh_tree_organization_id', inv_mwb_globals.g_tree_organization_id);
173: inv_mwb_query_manager.add_bind_variable('onh_tree_inventory_item_id', inv_mwb_globals.g_tree_item_id);
174: inv_mwb_query_manager.execute_query;
175:

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

168:
169: inv_mwb_query_manager.add_qf_where_onhand('ONHAND');
170: END IF;
171: inv_mwb_query_manager.add_bind_variable('onh_tree_cost_group_id', inv_mwb_globals.g_tree_cg_id);
172: inv_mwb_query_manager.add_bind_variable('onh_tree_organization_id', inv_mwb_globals.g_tree_organization_id);
173: inv_mwb_query_manager.add_bind_variable('onh_tree_inventory_item_id', inv_mwb_globals.g_tree_item_id);
174: inv_mwb_query_manager.execute_query;
175:
176: END IF;

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

169: inv_mwb_query_manager.add_qf_where_onhand('ONHAND');
170: END IF;
171: inv_mwb_query_manager.add_bind_variable('onh_tree_cost_group_id', inv_mwb_globals.g_tree_cg_id);
172: inv_mwb_query_manager.add_bind_variable('onh_tree_organization_id', inv_mwb_globals.g_tree_organization_id);
173: inv_mwb_query_manager.add_bind_variable('onh_tree_inventory_item_id', inv_mwb_globals.g_tree_item_id);
174: inv_mwb_query_manager.execute_query;
175:
176: END IF;
177:

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

182:
183: PROCEDURE make_common_queries(p_flag VARCHAR2) IS
184: BEGIN
185:
186: IF(inv_mwb_globals.g_chk_onhand = 1) THEN
187:
188: CASE p_flag
189: WHEN 'MOQD' THEN
190:

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

273: BEGIN
274:
275: l_procedure_name := 'EVENT';
276:
277: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_EXPANDED' OR
278: inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
279:
280: CASE inv_mwb_globals.g_tree_node_type
281:

Line 278: inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN

274:
275: l_procedure_name := 'EVENT';
276:
277: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_EXPANDED' OR
278: inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
279:
280: CASE inv_mwb_globals.g_tree_node_type
281:
282: WHEN 'APPTREE_OBJECT_TRUNK' THEN

Line 280: CASE inv_mwb_globals.g_tree_node_type

276:
277: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_EXPANDED' OR
278: inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
279:
280: CASE inv_mwb_globals.g_tree_node_type
281:
282: WHEN 'APPTREE_OBJECT_TRUNK' THEN
283: root_node_event (
284: x_node_value