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_QUERY_MANAGER

Line 38: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');

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
40: make_common_queries('MOQD');
41: inv_mwb_query_manager.add_qf_where_onhand('ONHAND');
42: END IF;

Line 41: inv_mwb_query_manager.add_qf_where_onhand('ONHAND');

37: make_common_queries('MSN_QUERY');
38: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
39: ELSE
40: make_common_queries('MOQD');
41: inv_mwb_query_manager.add_qf_where_onhand('ONHAND');
42: END IF;
43: inv_mwb_query_manager.execute_query;
44:
45: END IF; -- event

Line 43: inv_mwb_query_manager.execute_query;

39: ELSE
40: make_common_queries('MOQD');
41: inv_mwb_query_manager.add_qf_where_onhand('ONHAND');
42: END IF;
43: inv_mwb_query_manager.execute_query;
44:
45: END IF; -- event
46:
47: EXCEPTION

Line 80: inv_mwb_query_manager.add_where_clause('msn.cost_group_id = :onh_tree_cost_group_id' ,'ONHAND');

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');
82: ELSE
83: make_common_queries('MOQD');
84: inv_mwb_query_manager.add_where_clause('moqd.cost_group_id = :onh_tree_cost_group_id' ,'ONHAND');

Line 81: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');

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');
82: ELSE
83: make_common_queries('MOQD');
84: inv_mwb_query_manager.add_where_clause('moqd.cost_group_id = :onh_tree_cost_group_id' ,'ONHAND');
85:

Line 84: inv_mwb_query_manager.add_where_clause('moqd.cost_group_id = :onh_tree_cost_group_id' ,'ONHAND');

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');
82: ELSE
83: make_common_queries('MOQD');
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);

Line 86: inv_mwb_query_manager.add_qf_where_onhand('ONHAND');

82: ELSE
83: make_common_queries('MOQD');
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:

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 89: inv_mwb_query_manager.execute_query;

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:
93: EXCEPTION

Line 126: inv_mwb_query_manager.add_where_clause('msn.cost_group_id = :onh_tree_cost_group_id' ,'ONHAND');

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');
128: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
129: ELSE
130: make_common_queries('MOQD');

Line 127: inv_mwb_query_manager.add_where_clause('msn.current_organization_id = :onh_tree_organization_id' ,'ONHAND');

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');
128: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
129: ELSE
130: make_common_queries('MOQD');
131: inv_mwb_query_manager.add_where_clause('moqd.cost_group_id = :onh_tree_cost_group_id' ,'ONHAND');

Line 128: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');

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');
128: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
129: ELSE
130: make_common_queries('MOQD');
131: inv_mwb_query_manager.add_where_clause('moqd.cost_group_id = :onh_tree_cost_group_id' ,'ONHAND');
132: inv_mwb_query_manager.add_where_clause('moqd.organization_id = :onh_tree_organization_id' ,'ONHAND');

Line 131: inv_mwb_query_manager.add_where_clause('moqd.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');
128: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
129: ELSE
130: make_common_queries('MOQD');
131: inv_mwb_query_manager.add_where_clause('moqd.cost_group_id = :onh_tree_cost_group_id' ,'ONHAND');
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;

Line 132: inv_mwb_query_manager.add_where_clause('moqd.organization_id = :onh_tree_organization_id' ,'ONHAND');

128: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
129: ELSE
130: make_common_queries('MOQD');
131: inv_mwb_query_manager.add_where_clause('moqd.cost_group_id = :onh_tree_cost_group_id' ,'ONHAND');
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);

Line 134: inv_mwb_query_manager.add_qf_where_onhand('ONHAND');

130: make_common_queries('MOQD');
131: inv_mwb_query_manager.add_where_clause('moqd.cost_group_id = :onh_tree_cost_group_id' ,'ONHAND');
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;

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 138: inv_mwb_query_manager.execute_query;

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:
142: EXCEPTION

Line 167: inv_mwb_query_manager.add_where_clause('msn.cost_group_id = :onh_tree_cost_group_id' ,'ONHAND');

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');
169: inv_mwb_query_manager.add_where_clause('msn.inventory_item_id = :onh_tree_inventory_item_id' ,'ONHAND');
170: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
171: ELSE

Line 168: inv_mwb_query_manager.add_where_clause('msn.current_organization_id = :onh_tree_organization_id' ,'ONHAND');

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');
169: inv_mwb_query_manager.add_where_clause('msn.inventory_item_id = :onh_tree_inventory_item_id' ,'ONHAND');
170: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
171: ELSE
172: make_common_queries('MOQD');

Line 169: inv_mwb_query_manager.add_where_clause('msn.inventory_item_id = :onh_tree_inventory_item_id' ,'ONHAND');

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');
169: inv_mwb_query_manager.add_where_clause('msn.inventory_item_id = :onh_tree_inventory_item_id' ,'ONHAND');
170: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
171: ELSE
172: make_common_queries('MOQD');
173: inv_mwb_query_manager.add_where_clause('moqd.cost_group_id = :onh_tree_cost_group_id' ,'ONHAND');

Line 170: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');

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');
169: inv_mwb_query_manager.add_where_clause('msn.inventory_item_id = :onh_tree_inventory_item_id' ,'ONHAND');
170: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
171: ELSE
172: make_common_queries('MOQD');
173: inv_mwb_query_manager.add_where_clause('moqd.cost_group_id = :onh_tree_cost_group_id' ,'ONHAND');
174: inv_mwb_query_manager.add_where_clause('moqd.organization_id = :onh_tree_organization_id' ,'ONHAND');

Line 173: inv_mwb_query_manager.add_where_clause('moqd.cost_group_id = :onh_tree_cost_group_id' ,'ONHAND');

169: inv_mwb_query_manager.add_where_clause('msn.inventory_item_id = :onh_tree_inventory_item_id' ,'ONHAND');
170: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
171: ELSE
172: make_common_queries('MOQD');
173: inv_mwb_query_manager.add_where_clause('moqd.cost_group_id = :onh_tree_cost_group_id' ,'ONHAND');
174: inv_mwb_query_manager.add_where_clause('moqd.organization_id = :onh_tree_organization_id' ,'ONHAND');
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');

Line 174: inv_mwb_query_manager.add_where_clause('moqd.organization_id = :onh_tree_organization_id' ,'ONHAND');

170: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
171: ELSE
172: make_common_queries('MOQD');
173: inv_mwb_query_manager.add_where_clause('moqd.cost_group_id = :onh_tree_cost_group_id' ,'ONHAND');
174: inv_mwb_query_manager.add_where_clause('moqd.organization_id = :onh_tree_organization_id' ,'ONHAND');
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;

Line 175: inv_mwb_query_manager.add_where_clause('moqd.inventory_item_id = :onh_tree_inventory_item_id' ,'ONHAND');

171: ELSE
172: make_common_queries('MOQD');
173: inv_mwb_query_manager.add_where_clause('moqd.cost_group_id = :onh_tree_cost_group_id' ,'ONHAND');
174: inv_mwb_query_manager.add_where_clause('moqd.organization_id = :onh_tree_organization_id' ,'ONHAND');
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);

Line 177: inv_mwb_query_manager.add_qf_where_onhand('ONHAND');

173: inv_mwb_query_manager.add_where_clause('moqd.cost_group_id = :onh_tree_cost_group_id' ,'ONHAND');
174: inv_mwb_query_manager.add_where_clause('moqd.organization_id = :onh_tree_organization_id' ,'ONHAND');
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);

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 182: inv_mwb_query_manager.execute_query;

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:
186: EXCEPTION

Line 199: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ITEM_ID).column_value :=

195:
196: CASE p_flag
197: WHEN 'MOQD' THEN
198:
199: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ITEM_ID).column_value :=
200: 'moqd.inventory_item_id';
201:
202: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ORG_ID).column_value :=
203: 'moqd.organization_id';

Line 202: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ORG_ID).column_value :=

198:
199: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ITEM_ID).column_value :=
200: 'moqd.inventory_item_id';
201:
202: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ORG_ID).column_value :=
203: 'moqd.organization_id';
204:
205: -- inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PRIMARY_UOM_CODE).column_value :=
206: -- 'moqd.transaction_uom_code';

Line 205: -- inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PRIMARY_UOM_CODE).column_value :=

201:
202: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ORG_ID).column_value :=
203: 'moqd.organization_id';
204:
205: -- inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PRIMARY_UOM_CODE).column_value :=
206: -- 'moqd.transaction_uom_code';
207:
208: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ONHAND).column_value :=
209: 'SUM(moqd.primary_transaction_quantity)';

Line 208: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ONHAND).column_value :=

204:
205: -- inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PRIMARY_UOM_CODE).column_value :=
206: -- 'moqd.transaction_uom_code';
207:
208: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ONHAND).column_value :=
209: 'SUM(moqd.primary_transaction_quantity)';
210:
211: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PACKED).column_value :=
212: 'SUM(DECODE(moqd.containerized_flag, 1, moqd.primary_transaction_quantity, 0))';

Line 211: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PACKED).column_value :=

207:
208: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ONHAND).column_value :=
209: 'SUM(moqd.primary_transaction_quantity)';
210:
211: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PACKED).column_value :=
212: 'SUM(DECODE(moqd.containerized_flag, 1, moqd.primary_transaction_quantity, 0))';
213:
214: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.UNPACKED).column_value :=
215: 'SUM(DECODE(moqd.containerized_flag, 1, 0, moqd.primary_transaction_quantity))';

Line 214: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.UNPACKED).column_value :=

210:
211: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PACKED).column_value :=
212: 'SUM(DECODE(moqd.containerized_flag, 1, moqd.primary_transaction_quantity, 0))';
213:
214: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.UNPACKED).column_value :=
215: 'SUM(DECODE(moqd.containerized_flag, 1, 0, moqd.primary_transaction_quantity))';
216:
217: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SECONDARY_UOM_CODE).column_value :=
218: 'moqd.secondary_uom_code';

Line 217: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SECONDARY_UOM_CODE).column_value :=

213:
214: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.UNPACKED).column_value :=
215: 'SUM(DECODE(moqd.containerized_flag, 1, 0, moqd.primary_transaction_quantity))';
216:
217: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SECONDARY_UOM_CODE).column_value :=
218: 'moqd.secondary_uom_code';
219:
220: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SECONDARY_ONHAND).column_value :=
221: 'SUM(moqd.secondary_transaction_quantity)';

Line 220: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SECONDARY_ONHAND).column_value :=

216:
217: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SECONDARY_UOM_CODE).column_value :=
218: 'moqd.secondary_uom_code';
219:
220: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SECONDARY_ONHAND).column_value :=
221: 'SUM(moqd.secondary_transaction_quantity)';
222:
223: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SECONDARY_PACKED).column_value :=
224: 'SUM(DECODE(moqd.containerized_flag, 1, moqd.secondary_transaction_quantity, 0))';

Line 223: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SECONDARY_PACKED).column_value :=

219:
220: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SECONDARY_ONHAND).column_value :=
221: 'SUM(moqd.secondary_transaction_quantity)';
222:
223: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SECONDARY_PACKED).column_value :=
224: 'SUM(DECODE(moqd.containerized_flag, 1, moqd.secondary_transaction_quantity, 0))';
225:
226: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SECONDARY_UNPACKED).column_value :=
227: 'SUM(DECODE(moqd.containerized_flag, 1, 0, moqd.secondary_transaction_quantity))';

Line 226: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SECONDARY_UNPACKED).column_value :=

222:
223: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SECONDARY_PACKED).column_value :=
224: 'SUM(DECODE(moqd.containerized_flag, 1, moqd.secondary_transaction_quantity, 0))';
225:
226: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SECONDARY_UNPACKED).column_value :=
227: 'SUM(DECODE(moqd.containerized_flag, 1, 0, moqd.secondary_transaction_quantity))';
228:
229: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.CG_ID).column_value :=
230: 'moqd.cost_group_id';

Line 229: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.CG_ID).column_value :=

225:
226: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SECONDARY_UNPACKED).column_value :=
227: 'SUM(DECODE(moqd.containerized_flag, 1, 0, moqd.secondary_transaction_quantity))';
228:
229: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.CG_ID).column_value :=
230: 'moqd.cost_group_id';
231:
232: inv_mwb_query_manager.add_from_clause('mtl_onhand_quantities_detail moqd', 'ONHAND');
233:

Line 232: inv_mwb_query_manager.add_from_clause('mtl_onhand_quantities_detail moqd', 'ONHAND');

228:
229: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.CG_ID).column_value :=
230: 'moqd.cost_group_id';
231:
232: inv_mwb_query_manager.add_from_clause('mtl_onhand_quantities_detail moqd', 'ONHAND');
233:
234: inv_mwb_query_manager.add_group_clause('moqd.inventory_item_id', 'ONHAND');
235: inv_mwb_query_manager.add_group_clause('moqd.organization_id', 'ONHAND');
236: -- inv_mwb_query_manager.add_group_clause('moqd.transaction_uom_code', 'ONHAND');

Line 234: inv_mwb_query_manager.add_group_clause('moqd.inventory_item_id', 'ONHAND');

230: 'moqd.cost_group_id';
231:
232: inv_mwb_query_manager.add_from_clause('mtl_onhand_quantities_detail moqd', 'ONHAND');
233:
234: inv_mwb_query_manager.add_group_clause('moqd.inventory_item_id', 'ONHAND');
235: inv_mwb_query_manager.add_group_clause('moqd.organization_id', 'ONHAND');
236: -- inv_mwb_query_manager.add_group_clause('moqd.transaction_uom_code', 'ONHAND');
237: inv_mwb_query_manager.add_group_clause('moqd.secondary_uom_code', 'ONHAND');
238: inv_mwb_query_manager.add_group_clause('moqd.cost_group_id', 'ONHAND');

Line 235: inv_mwb_query_manager.add_group_clause('moqd.organization_id', 'ONHAND');

231:
232: inv_mwb_query_manager.add_from_clause('mtl_onhand_quantities_detail moqd', 'ONHAND');
233:
234: inv_mwb_query_manager.add_group_clause('moqd.inventory_item_id', 'ONHAND');
235: inv_mwb_query_manager.add_group_clause('moqd.organization_id', 'ONHAND');
236: -- inv_mwb_query_manager.add_group_clause('moqd.transaction_uom_code', 'ONHAND');
237: inv_mwb_query_manager.add_group_clause('moqd.secondary_uom_code', 'ONHAND');
238: inv_mwb_query_manager.add_group_clause('moqd.cost_group_id', 'ONHAND');
239:

Line 236: -- inv_mwb_query_manager.add_group_clause('moqd.transaction_uom_code', 'ONHAND');

232: inv_mwb_query_manager.add_from_clause('mtl_onhand_quantities_detail moqd', 'ONHAND');
233:
234: inv_mwb_query_manager.add_group_clause('moqd.inventory_item_id', 'ONHAND');
235: inv_mwb_query_manager.add_group_clause('moqd.organization_id', 'ONHAND');
236: -- inv_mwb_query_manager.add_group_clause('moqd.transaction_uom_code', 'ONHAND');
237: inv_mwb_query_manager.add_group_clause('moqd.secondary_uom_code', 'ONHAND');
238: inv_mwb_query_manager.add_group_clause('moqd.cost_group_id', 'ONHAND');
239:
240: WHEN 'MSN_QUERY' THEN

Line 237: inv_mwb_query_manager.add_group_clause('moqd.secondary_uom_code', 'ONHAND');

233:
234: inv_mwb_query_manager.add_group_clause('moqd.inventory_item_id', 'ONHAND');
235: inv_mwb_query_manager.add_group_clause('moqd.organization_id', 'ONHAND');
236: -- inv_mwb_query_manager.add_group_clause('moqd.transaction_uom_code', 'ONHAND');
237: inv_mwb_query_manager.add_group_clause('moqd.secondary_uom_code', 'ONHAND');
238: inv_mwb_query_manager.add_group_clause('moqd.cost_group_id', 'ONHAND');
239:
240: WHEN 'MSN_QUERY' THEN
241: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ITEM_ID).column_value :=

Line 238: inv_mwb_query_manager.add_group_clause('moqd.cost_group_id', 'ONHAND');

234: inv_mwb_query_manager.add_group_clause('moqd.inventory_item_id', 'ONHAND');
235: inv_mwb_query_manager.add_group_clause('moqd.organization_id', 'ONHAND');
236: -- inv_mwb_query_manager.add_group_clause('moqd.transaction_uom_code', 'ONHAND');
237: inv_mwb_query_manager.add_group_clause('moqd.secondary_uom_code', 'ONHAND');
238: inv_mwb_query_manager.add_group_clause('moqd.cost_group_id', 'ONHAND');
239:
240: WHEN 'MSN_QUERY' THEN
241: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ITEM_ID).column_value :=
242: 'msn.inventory_item_id';

Line 241: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ITEM_ID).column_value :=

237: inv_mwb_query_manager.add_group_clause('moqd.secondary_uom_code', 'ONHAND');
238: inv_mwb_query_manager.add_group_clause('moqd.cost_group_id', 'ONHAND');
239:
240: WHEN 'MSN_QUERY' THEN
241: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ITEM_ID).column_value :=
242: 'msn.inventory_item_id';
243:
244: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ORG_ID).column_value :=
245: 'msn.current_organization_id';

Line 244: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ORG_ID).column_value :=

240: WHEN 'MSN_QUERY' THEN
241: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ITEM_ID).column_value :=
242: 'msn.inventory_item_id';
243:
244: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ORG_ID).column_value :=
245: 'msn.current_organization_id';
246: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PRIMARY_UOM_CODE).column_value :=
247: '''Ea''';
248:

Line 246: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PRIMARY_UOM_CODE).column_value :=

242: 'msn.inventory_item_id';
243:
244: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ORG_ID).column_value :=
245: 'msn.current_organization_id';
246: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PRIMARY_UOM_CODE).column_value :=
247: '''Ea''';
248:
249: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ONHAND).column_value :=
250: 'count(1)';

Line 249: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ONHAND).column_value :=

245: 'msn.current_organization_id';
246: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PRIMARY_UOM_CODE).column_value :=
247: '''Ea''';
248:
249: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ONHAND).column_value :=
250: 'count(1)';
251: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PACKED).column_value :=
252: 'count(decode(msn.lpn_id,NULL,0, 1))';
253: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.UNPACKED).column_value :=

Line 251: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PACKED).column_value :=

247: '''Ea''';
248:
249: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ONHAND).column_value :=
250: 'count(1)';
251: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PACKED).column_value :=
252: 'count(decode(msn.lpn_id,NULL,0, 1))';
253: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.UNPACKED).column_value :=
254: 'count(decode(msn.lpn_id,NULL,1, 0))';
255: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.COST_GROUP).column_value :=

Line 253: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.UNPACKED).column_value :=

249: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ONHAND).column_value :=
250: 'count(1)';
251: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PACKED).column_value :=
252: 'count(decode(msn.lpn_id,NULL,0, 1))';
253: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.UNPACKED).column_value :=
254: 'count(decode(msn.lpn_id,NULL,1, 0))';
255: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.COST_GROUP).column_value :=
256: 'msn.cost_group_id';
257: inv_mwb_query_manager.add_from_clause('mtl_serial_numbers msn', 'ONHAND');

Line 255: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.COST_GROUP).column_value :=

251: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PACKED).column_value :=
252: 'count(decode(msn.lpn_id,NULL,0, 1))';
253: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.UNPACKED).column_value :=
254: 'count(decode(msn.lpn_id,NULL,1, 0))';
255: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.COST_GROUP).column_value :=
256: 'msn.cost_group_id';
257: inv_mwb_query_manager.add_from_clause('mtl_serial_numbers msn', 'ONHAND');
258: inv_mwb_query_manager.add_group_clause('msn.inventory_item_id' , 'ONHAND');
259: inv_mwb_query_manager.add_group_clause('msn.current_organization_id', 'ONHAND');

Line 257: inv_mwb_query_manager.add_from_clause('mtl_serial_numbers msn', 'ONHAND');

253: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.UNPACKED).column_value :=
254: 'count(decode(msn.lpn_id,NULL,1, 0))';
255: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.COST_GROUP).column_value :=
256: 'msn.cost_group_id';
257: inv_mwb_query_manager.add_from_clause('mtl_serial_numbers msn', 'ONHAND');
258: inv_mwb_query_manager.add_group_clause('msn.inventory_item_id' , 'ONHAND');
259: inv_mwb_query_manager.add_group_clause('msn.current_organization_id', 'ONHAND');
260: inv_mwb_query_manager.add_group_clause('''Ea''', 'ONHAND');
261: inv_mwb_query_manager.add_group_clause('msn.cost_group_id', 'ONHAND');

Line 258: inv_mwb_query_manager.add_group_clause('msn.inventory_item_id' , 'ONHAND');

254: 'count(decode(msn.lpn_id,NULL,1, 0))';
255: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.COST_GROUP).column_value :=
256: 'msn.cost_group_id';
257: inv_mwb_query_manager.add_from_clause('mtl_serial_numbers msn', 'ONHAND');
258: inv_mwb_query_manager.add_group_clause('msn.inventory_item_id' , 'ONHAND');
259: inv_mwb_query_manager.add_group_clause('msn.current_organization_id', 'ONHAND');
260: inv_mwb_query_manager.add_group_clause('''Ea''', 'ONHAND');
261: inv_mwb_query_manager.add_group_clause('msn.cost_group_id', 'ONHAND');
262: END CASE; -- p_flag

Line 259: inv_mwb_query_manager.add_group_clause('msn.current_organization_id', 'ONHAND');

255: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.COST_GROUP).column_value :=
256: 'msn.cost_group_id';
257: inv_mwb_query_manager.add_from_clause('mtl_serial_numbers msn', 'ONHAND');
258: inv_mwb_query_manager.add_group_clause('msn.inventory_item_id' , 'ONHAND');
259: inv_mwb_query_manager.add_group_clause('msn.current_organization_id', 'ONHAND');
260: inv_mwb_query_manager.add_group_clause('''Ea''', 'ONHAND');
261: inv_mwb_query_manager.add_group_clause('msn.cost_group_id', 'ONHAND');
262: END CASE; -- p_flag
263:

Line 260: inv_mwb_query_manager.add_group_clause('''Ea''', 'ONHAND');

256: 'msn.cost_group_id';
257: inv_mwb_query_manager.add_from_clause('mtl_serial_numbers msn', 'ONHAND');
258: inv_mwb_query_manager.add_group_clause('msn.inventory_item_id' , 'ONHAND');
259: inv_mwb_query_manager.add_group_clause('msn.current_organization_id', 'ONHAND');
260: inv_mwb_query_manager.add_group_clause('''Ea''', 'ONHAND');
261: inv_mwb_query_manager.add_group_clause('msn.cost_group_id', 'ONHAND');
262: END CASE; -- p_flag
263:
264: END IF; -- End if for onhand

Line 261: inv_mwb_query_manager.add_group_clause('msn.cost_group_id', 'ONHAND');

257: inv_mwb_query_manager.add_from_clause('mtl_serial_numbers msn', 'ONHAND');
258: inv_mwb_query_manager.add_group_clause('msn.inventory_item_id' , 'ONHAND');
259: inv_mwb_query_manager.add_group_clause('msn.current_organization_id', 'ONHAND');
260: inv_mwb_query_manager.add_group_clause('''Ea''', 'ONHAND');
261: inv_mwb_query_manager.add_group_clause('msn.cost_group_id', 'ONHAND');
262: END CASE; -- p_flag
263:
264: END IF; -- End if for onhand
265: