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 36: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');

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

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

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

Line 41: inv_mwb_query_manager.execute_query;

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

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

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

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

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

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

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
79: make_common_queries('MOQD');
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);

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

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

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

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

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

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

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

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

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

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');
123: ELSE
124: make_common_queries('MOQD');
125: inv_mwb_query_manager.add_where_clause('moqd.cost_group_id = :onh_tree_cost_group_id' ,'ONHAND');
126: inv_mwb_query_manager.add_where_clause('moqd.organization_id = :onh_tree_organization_id' ,'ONHAND');

Line 125: inv_mwb_query_manager.add_where_clause('moqd.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');
123: ELSE
124: make_common_queries('MOQD');
125: inv_mwb_query_manager.add_where_clause('moqd.cost_group_id = :onh_tree_cost_group_id' ,'ONHAND');
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;

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

122: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
123: ELSE
124: make_common_queries('MOQD');
125: inv_mwb_query_manager.add_where_clause('moqd.cost_group_id = :onh_tree_cost_group_id' ,'ONHAND');
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);

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

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

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

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

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

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');
162: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
163: ELSE

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

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');
162: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
163: ELSE
164: make_common_queries('MOQD');

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

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');
162: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
163: ELSE
164: make_common_queries('MOQD');
165: inv_mwb_query_manager.add_where_clause('moqd.cost_group_id = :onh_tree_cost_group_id' ,'ONHAND');

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

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');
162: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
163: ELSE
164: make_common_queries('MOQD');
165: inv_mwb_query_manager.add_where_clause('moqd.cost_group_id = :onh_tree_cost_group_id' ,'ONHAND');
166: inv_mwb_query_manager.add_where_clause('moqd.organization_id = :onh_tree_organization_id' ,'ONHAND');

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

161: inv_mwb_query_manager.add_where_clause('msn.inventory_item_id = :onh_tree_inventory_item_id' ,'ONHAND');
162: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
163: ELSE
164: make_common_queries('MOQD');
165: inv_mwb_query_manager.add_where_clause('moqd.cost_group_id = :onh_tree_cost_group_id' ,'ONHAND');
166: inv_mwb_query_manager.add_where_clause('moqd.organization_id = :onh_tree_organization_id' ,'ONHAND');
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');

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

162: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
163: ELSE
164: make_common_queries('MOQD');
165: inv_mwb_query_manager.add_where_clause('moqd.cost_group_id = :onh_tree_cost_group_id' ,'ONHAND');
166: inv_mwb_query_manager.add_where_clause('moqd.organization_id = :onh_tree_organization_id' ,'ONHAND');
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;

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

163: ELSE
164: make_common_queries('MOQD');
165: inv_mwb_query_manager.add_where_clause('moqd.cost_group_id = :onh_tree_cost_group_id' ,'ONHAND');
166: inv_mwb_query_manager.add_where_clause('moqd.organization_id = :onh_tree_organization_id' ,'ONHAND');
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);

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

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

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

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

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

187:
188: CASE p_flag
189: WHEN 'MOQD' THEN
190:
191: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ITEM_ID).column_value :=
192: 'moqd.inventory_item_id';
193:
194: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ORG_ID).column_value :=
195: 'moqd.organization_id';

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

190:
191: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ITEM_ID).column_value :=
192: 'moqd.inventory_item_id';
193:
194: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ORG_ID).column_value :=
195: 'moqd.organization_id';
196:
197: -- inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PRIMARY_UOM_CODE).column_value :=
198: -- 'moqd.transaction_uom_code';

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

193:
194: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ORG_ID).column_value :=
195: 'moqd.organization_id';
196:
197: -- inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PRIMARY_UOM_CODE).column_value :=
198: -- 'moqd.transaction_uom_code';
199:
200: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ONHAND).column_value :=
201: 'SUM(moqd.primary_transaction_quantity)';

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

196:
197: -- inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PRIMARY_UOM_CODE).column_value :=
198: -- 'moqd.transaction_uom_code';
199:
200: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ONHAND).column_value :=
201: 'SUM(moqd.primary_transaction_quantity)';
202:
203: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PACKED).column_value :=
204: 'SUM(DECODE(moqd.containerized_flag, 1, moqd.primary_transaction_quantity, 0))';

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

199:
200: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ONHAND).column_value :=
201: 'SUM(moqd.primary_transaction_quantity)';
202:
203: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PACKED).column_value :=
204: 'SUM(DECODE(moqd.containerized_flag, 1, moqd.primary_transaction_quantity, 0))';
205:
206: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.UNPACKED).column_value :=
207: 'SUM(DECODE(moqd.containerized_flag, 1, 0, moqd.primary_transaction_quantity))';

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

202:
203: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PACKED).column_value :=
204: 'SUM(DECODE(moqd.containerized_flag, 1, moqd.primary_transaction_quantity, 0))';
205:
206: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.UNPACKED).column_value :=
207: 'SUM(DECODE(moqd.containerized_flag, 1, 0, moqd.primary_transaction_quantity))';
208:
209: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SECONDARY_UOM_CODE).column_value :=
210: 'moqd.secondary_uom_code';

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

205:
206: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.UNPACKED).column_value :=
207: 'SUM(DECODE(moqd.containerized_flag, 1, 0, moqd.primary_transaction_quantity))';
208:
209: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SECONDARY_UOM_CODE).column_value :=
210: 'moqd.secondary_uom_code';
211:
212: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SECONDARY_ONHAND).column_value :=
213: 'SUM(moqd.secondary_transaction_quantity)';

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

208:
209: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SECONDARY_UOM_CODE).column_value :=
210: 'moqd.secondary_uom_code';
211:
212: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SECONDARY_ONHAND).column_value :=
213: 'SUM(moqd.secondary_transaction_quantity)';
214:
215: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SECONDARY_PACKED).column_value :=
216: 'SUM(DECODE(moqd.containerized_flag, 1, moqd.secondary_transaction_quantity, 0))';

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

211:
212: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SECONDARY_ONHAND).column_value :=
213: 'SUM(moqd.secondary_transaction_quantity)';
214:
215: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SECONDARY_PACKED).column_value :=
216: 'SUM(DECODE(moqd.containerized_flag, 1, moqd.secondary_transaction_quantity, 0))';
217:
218: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SECONDARY_UNPACKED).column_value :=
219: 'SUM(DECODE(moqd.containerized_flag, 1, 0, moqd.secondary_transaction_quantity))';

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

214:
215: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SECONDARY_PACKED).column_value :=
216: 'SUM(DECODE(moqd.containerized_flag, 1, moqd.secondary_transaction_quantity, 0))';
217:
218: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SECONDARY_UNPACKED).column_value :=
219: 'SUM(DECODE(moqd.containerized_flag, 1, 0, moqd.secondary_transaction_quantity))';
220:
221: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.CG_ID).column_value :=
222: 'moqd.cost_group_id';

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

217:
218: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SECONDARY_UNPACKED).column_value :=
219: 'SUM(DECODE(moqd.containerized_flag, 1, 0, moqd.secondary_transaction_quantity))';
220:
221: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.CG_ID).column_value :=
222: 'moqd.cost_group_id';
223:
224: inv_mwb_query_manager.add_from_clause('mtl_onhand_quantities_detail moqd', 'ONHAND');
225:

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

220:
221: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.CG_ID).column_value :=
222: 'moqd.cost_group_id';
223:
224: inv_mwb_query_manager.add_from_clause('mtl_onhand_quantities_detail moqd', 'ONHAND');
225:
226: inv_mwb_query_manager.add_group_clause('moqd.inventory_item_id', 'ONHAND');
227: inv_mwb_query_manager.add_group_clause('moqd.organization_id', 'ONHAND');
228: -- inv_mwb_query_manager.add_group_clause('moqd.transaction_uom_code', 'ONHAND');

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

222: 'moqd.cost_group_id';
223:
224: inv_mwb_query_manager.add_from_clause('mtl_onhand_quantities_detail moqd', 'ONHAND');
225:
226: inv_mwb_query_manager.add_group_clause('moqd.inventory_item_id', 'ONHAND');
227: inv_mwb_query_manager.add_group_clause('moqd.organization_id', 'ONHAND');
228: -- inv_mwb_query_manager.add_group_clause('moqd.transaction_uom_code', 'ONHAND');
229: inv_mwb_query_manager.add_group_clause('moqd.secondary_uom_code', 'ONHAND');
230: inv_mwb_query_manager.add_group_clause('moqd.cost_group_id', 'ONHAND');

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

223:
224: inv_mwb_query_manager.add_from_clause('mtl_onhand_quantities_detail moqd', 'ONHAND');
225:
226: inv_mwb_query_manager.add_group_clause('moqd.inventory_item_id', 'ONHAND');
227: inv_mwb_query_manager.add_group_clause('moqd.organization_id', 'ONHAND');
228: -- inv_mwb_query_manager.add_group_clause('moqd.transaction_uom_code', 'ONHAND');
229: inv_mwb_query_manager.add_group_clause('moqd.secondary_uom_code', 'ONHAND');
230: inv_mwb_query_manager.add_group_clause('moqd.cost_group_id', 'ONHAND');
231:

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

224: inv_mwb_query_manager.add_from_clause('mtl_onhand_quantities_detail moqd', 'ONHAND');
225:
226: inv_mwb_query_manager.add_group_clause('moqd.inventory_item_id', 'ONHAND');
227: inv_mwb_query_manager.add_group_clause('moqd.organization_id', 'ONHAND');
228: -- inv_mwb_query_manager.add_group_clause('moqd.transaction_uom_code', 'ONHAND');
229: inv_mwb_query_manager.add_group_clause('moqd.secondary_uom_code', 'ONHAND');
230: inv_mwb_query_manager.add_group_clause('moqd.cost_group_id', 'ONHAND');
231:
232: WHEN 'MSN_QUERY' THEN

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

225:
226: inv_mwb_query_manager.add_group_clause('moqd.inventory_item_id', 'ONHAND');
227: inv_mwb_query_manager.add_group_clause('moqd.organization_id', 'ONHAND');
228: -- inv_mwb_query_manager.add_group_clause('moqd.transaction_uom_code', 'ONHAND');
229: inv_mwb_query_manager.add_group_clause('moqd.secondary_uom_code', 'ONHAND');
230: inv_mwb_query_manager.add_group_clause('moqd.cost_group_id', 'ONHAND');
231:
232: WHEN 'MSN_QUERY' THEN
233: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ITEM_ID).column_value :=

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

226: inv_mwb_query_manager.add_group_clause('moqd.inventory_item_id', 'ONHAND');
227: inv_mwb_query_manager.add_group_clause('moqd.organization_id', 'ONHAND');
228: -- inv_mwb_query_manager.add_group_clause('moqd.transaction_uom_code', 'ONHAND');
229: inv_mwb_query_manager.add_group_clause('moqd.secondary_uom_code', 'ONHAND');
230: inv_mwb_query_manager.add_group_clause('moqd.cost_group_id', 'ONHAND');
231:
232: WHEN 'MSN_QUERY' THEN
233: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ITEM_ID).column_value :=
234: 'msn.inventory_item_id';

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

229: inv_mwb_query_manager.add_group_clause('moqd.secondary_uom_code', 'ONHAND');
230: inv_mwb_query_manager.add_group_clause('moqd.cost_group_id', 'ONHAND');
231:
232: WHEN 'MSN_QUERY' THEN
233: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ITEM_ID).column_value :=
234: 'msn.inventory_item_id';
235:
236: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ORG_ID).column_value :=
237: 'msn.current_organization_id';

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

232: WHEN 'MSN_QUERY' THEN
233: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ITEM_ID).column_value :=
234: 'msn.inventory_item_id';
235:
236: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ORG_ID).column_value :=
237: 'msn.current_organization_id';
238: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PRIMARY_UOM_CODE).column_value :=
239: '''Ea''';
240:

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

234: 'msn.inventory_item_id';
235:
236: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ORG_ID).column_value :=
237: 'msn.current_organization_id';
238: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PRIMARY_UOM_CODE).column_value :=
239: '''Ea''';
240:
241: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ONHAND).column_value :=
242: 'count(1)';

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

237: 'msn.current_organization_id';
238: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PRIMARY_UOM_CODE).column_value :=
239: '''Ea''';
240:
241: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ONHAND).column_value :=
242: 'count(1)';
243: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PACKED).column_value :=
244: 'count(decode(msn.lpn_id,NULL,0, 1))';
245: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.UNPACKED).column_value :=

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

239: '''Ea''';
240:
241: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ONHAND).column_value :=
242: 'count(1)';
243: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PACKED).column_value :=
244: 'count(decode(msn.lpn_id,NULL,0, 1))';
245: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.UNPACKED).column_value :=
246: 'count(decode(msn.lpn_id,NULL,1, 0))';
247: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.COST_GROUP).column_value :=

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

241: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ONHAND).column_value :=
242: 'count(1)';
243: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PACKED).column_value :=
244: 'count(decode(msn.lpn_id,NULL,0, 1))';
245: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.UNPACKED).column_value :=
246: 'count(decode(msn.lpn_id,NULL,1, 0))';
247: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.COST_GROUP).column_value :=
248: 'msn.cost_group_id';
249: inv_mwb_query_manager.add_from_clause('mtl_serial_numbers msn', 'ONHAND');

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

243: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PACKED).column_value :=
244: 'count(decode(msn.lpn_id,NULL,0, 1))';
245: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.UNPACKED).column_value :=
246: 'count(decode(msn.lpn_id,NULL,1, 0))';
247: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.COST_GROUP).column_value :=
248: 'msn.cost_group_id';
249: inv_mwb_query_manager.add_from_clause('mtl_serial_numbers msn', 'ONHAND');
250: inv_mwb_query_manager.add_group_clause('msn.inventory_item_id' , 'ONHAND');
251: inv_mwb_query_manager.add_group_clause('msn.current_organization_id', 'ONHAND');

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

245: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.UNPACKED).column_value :=
246: 'count(decode(msn.lpn_id,NULL,1, 0))';
247: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.COST_GROUP).column_value :=
248: 'msn.cost_group_id';
249: inv_mwb_query_manager.add_from_clause('mtl_serial_numbers msn', 'ONHAND');
250: inv_mwb_query_manager.add_group_clause('msn.inventory_item_id' , 'ONHAND');
251: inv_mwb_query_manager.add_group_clause('msn.current_organization_id', 'ONHAND');
252: inv_mwb_query_manager.add_group_clause('''Ea''', 'ONHAND');
253: inv_mwb_query_manager.add_group_clause('msn.cost_group_id', 'ONHAND');

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

246: 'count(decode(msn.lpn_id,NULL,1, 0))';
247: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.COST_GROUP).column_value :=
248: 'msn.cost_group_id';
249: inv_mwb_query_manager.add_from_clause('mtl_serial_numbers msn', 'ONHAND');
250: inv_mwb_query_manager.add_group_clause('msn.inventory_item_id' , 'ONHAND');
251: inv_mwb_query_manager.add_group_clause('msn.current_organization_id', 'ONHAND');
252: inv_mwb_query_manager.add_group_clause('''Ea''', 'ONHAND');
253: inv_mwb_query_manager.add_group_clause('msn.cost_group_id', 'ONHAND');
254: END CASE; -- p_flag

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

247: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.COST_GROUP).column_value :=
248: 'msn.cost_group_id';
249: inv_mwb_query_manager.add_from_clause('mtl_serial_numbers msn', 'ONHAND');
250: inv_mwb_query_manager.add_group_clause('msn.inventory_item_id' , 'ONHAND');
251: inv_mwb_query_manager.add_group_clause('msn.current_organization_id', 'ONHAND');
252: inv_mwb_query_manager.add_group_clause('''Ea''', 'ONHAND');
253: inv_mwb_query_manager.add_group_clause('msn.cost_group_id', 'ONHAND');
254: END CASE; -- p_flag
255:

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

248: 'msn.cost_group_id';
249: inv_mwb_query_manager.add_from_clause('mtl_serial_numbers msn', 'ONHAND');
250: inv_mwb_query_manager.add_group_clause('msn.inventory_item_id' , 'ONHAND');
251: inv_mwb_query_manager.add_group_clause('msn.current_organization_id', 'ONHAND');
252: inv_mwb_query_manager.add_group_clause('''Ea''', 'ONHAND');
253: inv_mwb_query_manager.add_group_clause('msn.cost_group_id', 'ONHAND');
254: END CASE; -- p_flag
255:
256: END IF; -- End if for onhand

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

249: inv_mwb_query_manager.add_from_clause('mtl_serial_numbers msn', 'ONHAND');
250: inv_mwb_query_manager.add_group_clause('msn.inventory_item_id' , 'ONHAND');
251: inv_mwb_query_manager.add_group_clause('msn.current_organization_id', 'ONHAND');
252: inv_mwb_query_manager.add_group_clause('''Ea''', 'ONHAND');
253: inv_mwb_query_manager.add_group_clause('msn.cost_group_id', 'ONHAND');
254: END CASE; -- p_flag
255:
256: END IF; -- End if for onhand
257: