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.

[Home] [Help]

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

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 -- Bug 6429880
35: OR inv_mwb_globals.g_unit_number IS NOT NULL -- Bug 9365452
36: THEN

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

60: BEGIN
61:
62: l_procedure_name := 'COST_GROUP_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 71: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN

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

Line 73: IF inv_mwb_globals.g_serial_from IS NOT NULL OR

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

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

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

84: inv_mwb_query_manager.add_where_clause('moqd.cost_group_id = :onh_tree_cost_group_id' ,'ONHAND');
85:
86: inv_mwb_query_manager.add_qf_where_onhand('ONHAND');
87: END IF;
88: inv_mwb_query_manager.add_bind_variable('onh_tree_cost_group_id', inv_mwb_globals.g_tree_cg_id);
89: inv_mwb_query_manager.execute_query;
90:
91: END IF; -- event
92:

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

106: BEGIN
107:
108: l_procedure_name := 'ORG_NODE_EVENT';
109:
110: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_EXPANDED' THEN
111: inv_mwb_tree1.add_items(
112: x_node_value
113: , x_node_tbl
114: , x_tbl_index

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

113: , x_node_tbl
114: , x_tbl_index
115: );
116:
117: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
118:
119: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
120: inv_mwb_globals.g_serial_to IS NOT NULL
121: OR inv_mwb_globals.g_status_id IS NOT NULL -- Bug 6060233

Line 119: IF inv_mwb_globals.g_serial_from IS NOT NULL OR

115: );
116:
117: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
118:
119: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
120: inv_mwb_globals.g_serial_to IS NOT NULL
121: OR inv_mwb_globals.g_status_id IS NOT NULL -- Bug 6060233
122: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL -- Bug 6429880
123: OR inv_mwb_globals.g_unit_number IS NOT NULL -- Bug 9365452

Line 120: inv_mwb_globals.g_serial_to IS NOT NULL

116:
117: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
118:
119: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
120: inv_mwb_globals.g_serial_to IS NOT NULL
121: OR inv_mwb_globals.g_status_id IS NOT NULL -- Bug 6060233
122: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL -- Bug 6429880
123: OR inv_mwb_globals.g_unit_number IS NOT NULL -- Bug 9365452
124: THEN

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

117: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
118:
119: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
120: inv_mwb_globals.g_serial_to IS NOT NULL
121: OR inv_mwb_globals.g_status_id IS NOT NULL -- Bug 6060233
122: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL -- Bug 6429880
123: OR inv_mwb_globals.g_unit_number IS NOT NULL -- Bug 9365452
124: THEN
125: make_common_queries('MSN_QUERY');

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

118:
119: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
120: inv_mwb_globals.g_serial_to IS NOT NULL
121: OR inv_mwb_globals.g_status_id IS NOT NULL -- Bug 6060233
122: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL -- Bug 6429880
123: OR inv_mwb_globals.g_unit_number IS NOT NULL -- Bug 9365452
124: THEN
125: make_common_queries('MSN_QUERY');
126: inv_mwb_query_manager.add_where_clause('msn.cost_group_id = :onh_tree_cost_group_id' ,'ONHAND');

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

119: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
120: inv_mwb_globals.g_serial_to IS NOT NULL
121: OR inv_mwb_globals.g_status_id IS NOT NULL -- Bug 6060233
122: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL -- Bug 6429880
123: OR inv_mwb_globals.g_unit_number IS NOT NULL -- Bug 9365452
124: THEN
125: make_common_queries('MSN_QUERY');
126: inv_mwb_query_manager.add_where_clause('msn.cost_group_id = :onh_tree_cost_group_id' ,'ONHAND');
127: inv_mwb_query_manager.add_where_clause('msn.current_organization_id = :onh_tree_organization_id' ,'ONHAND');

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

132: inv_mwb_query_manager.add_where_clause('moqd.organization_id = :onh_tree_organization_id' ,'ONHAND');
133:
134: inv_mwb_query_manager.add_qf_where_onhand('ONHAND');
135: END IF;
136: inv_mwb_query_manager.add_bind_variable('onh_tree_cost_group_id', inv_mwb_globals.g_tree_cg_id);
137: inv_mwb_query_manager.add_bind_variable('onh_tree_organization_id', inv_mwb_globals.g_tree_organization_id);
138: inv_mwb_query_manager.execute_query;
139:
140: END IF; -- tree event

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

133:
134: inv_mwb_query_manager.add_qf_where_onhand('ONHAND');
135: END IF;
136: inv_mwb_query_manager.add_bind_variable('onh_tree_cost_group_id', inv_mwb_globals.g_tree_cg_id);
137: inv_mwb_query_manager.add_bind_variable('onh_tree_organization_id', inv_mwb_globals.g_tree_organization_id);
138: inv_mwb_query_manager.execute_query;
139:
140: END IF; -- tree event
141:

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

154:
155: BEGIN
156:
157: l_procedure_name := 'ITEM_NODE_EVENT';
158: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
159:
160: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
161: inv_mwb_globals.g_serial_to IS NOT NULL
162: OR inv_mwb_globals.g_status_id IS NOT NULL -- Bug 6060233

Line 160: IF inv_mwb_globals.g_serial_from IS NOT NULL OR

156:
157: l_procedure_name := 'ITEM_NODE_EVENT';
158: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
159:
160: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
161: inv_mwb_globals.g_serial_to IS NOT NULL
162: OR inv_mwb_globals.g_status_id IS NOT NULL -- Bug 6060233
163: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL -- Bug 6429880
164: OR inv_mwb_globals.g_unit_number IS NOT NULL -- Bug 9365452

Line 161: inv_mwb_globals.g_serial_to IS NOT NULL

157: l_procedure_name := 'ITEM_NODE_EVENT';
158: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
159:
160: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
161: inv_mwb_globals.g_serial_to IS NOT NULL
162: OR inv_mwb_globals.g_status_id IS NOT NULL -- Bug 6060233
163: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL -- Bug 6429880
164: OR inv_mwb_globals.g_unit_number IS NOT NULL -- Bug 9365452
165: THEN

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

158: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
159:
160: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
161: inv_mwb_globals.g_serial_to IS NOT NULL
162: OR inv_mwb_globals.g_status_id IS NOT NULL -- Bug 6060233
163: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL -- Bug 6429880
164: OR inv_mwb_globals.g_unit_number IS NOT NULL -- Bug 9365452
165: THEN
166: make_common_queries('MSN_QUERY');

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

159:
160: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
161: inv_mwb_globals.g_serial_to IS NOT NULL
162: OR inv_mwb_globals.g_status_id IS NOT NULL -- Bug 6060233
163: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL -- Bug 6429880
164: OR inv_mwb_globals.g_unit_number IS NOT NULL -- Bug 9365452
165: THEN
166: make_common_queries('MSN_QUERY');
167: inv_mwb_query_manager.add_where_clause('msn.cost_group_id = :onh_tree_cost_group_id' ,'ONHAND');

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

160: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
161: inv_mwb_globals.g_serial_to IS NOT NULL
162: OR inv_mwb_globals.g_status_id IS NOT NULL -- Bug 6060233
163: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL -- Bug 6429880
164: OR inv_mwb_globals.g_unit_number IS NOT NULL -- Bug 9365452
165: THEN
166: make_common_queries('MSN_QUERY');
167: inv_mwb_query_manager.add_where_clause('msn.cost_group_id = :onh_tree_cost_group_id' ,'ONHAND');
168: inv_mwb_query_manager.add_where_clause('msn.current_organization_id = :onh_tree_organization_id' ,'ONHAND');

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

175: inv_mwb_query_manager.add_where_clause('moqd.inventory_item_id = :onh_tree_inventory_item_id' ,'ONHAND');
176:
177: inv_mwb_query_manager.add_qf_where_onhand('ONHAND');
178: END IF;
179: inv_mwb_query_manager.add_bind_variable('onh_tree_cost_group_id', inv_mwb_globals.g_tree_cg_id);
180: inv_mwb_query_manager.add_bind_variable('onh_tree_organization_id', inv_mwb_globals.g_tree_organization_id);
181: inv_mwb_query_manager.add_bind_variable('onh_tree_inventory_item_id', inv_mwb_globals.g_tree_item_id);
182: inv_mwb_query_manager.execute_query;
183:

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

176:
177: inv_mwb_query_manager.add_qf_where_onhand('ONHAND');
178: END IF;
179: inv_mwb_query_manager.add_bind_variable('onh_tree_cost_group_id', inv_mwb_globals.g_tree_cg_id);
180: inv_mwb_query_manager.add_bind_variable('onh_tree_organization_id', inv_mwb_globals.g_tree_organization_id);
181: inv_mwb_query_manager.add_bind_variable('onh_tree_inventory_item_id', inv_mwb_globals.g_tree_item_id);
182: inv_mwb_query_manager.execute_query;
183:
184: END IF;

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

177: inv_mwb_query_manager.add_qf_where_onhand('ONHAND');
178: END IF;
179: inv_mwb_query_manager.add_bind_variable('onh_tree_cost_group_id', inv_mwb_globals.g_tree_cg_id);
180: inv_mwb_query_manager.add_bind_variable('onh_tree_organization_id', inv_mwb_globals.g_tree_organization_id);
181: inv_mwb_query_manager.add_bind_variable('onh_tree_inventory_item_id', inv_mwb_globals.g_tree_item_id);
182: inv_mwb_query_manager.execute_query;
183:
184: END IF;
185:

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

190:
191: PROCEDURE make_common_queries(p_flag VARCHAR2) IS
192: BEGIN
193:
194: IF(inv_mwb_globals.g_chk_onhand = 1) THEN
195:
196: CASE p_flag
197: WHEN 'MOQD' THEN
198:

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

281: BEGIN
282:
283: l_procedure_name := 'EVENT';
284:
285: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_EXPANDED' OR
286: inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
287:
288: CASE inv_mwb_globals.g_tree_node_type
289:

Line 286: inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN

282:
283: l_procedure_name := 'EVENT';
284:
285: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_EXPANDED' OR
286: inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
287:
288: CASE inv_mwb_globals.g_tree_node_type
289:
290: WHEN 'APPTREE_OBJECT_TRUNK' THEN

Line 288: CASE inv_mwb_globals.g_tree_node_type

284:
285: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_EXPANDED' OR
286: inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
287:
288: CASE inv_mwb_globals.g_tree_node_type
289:
290: WHEN 'APPTREE_OBJECT_TRUNK' THEN
291: root_node_event (
292: x_node_value