APPS.INV_MWB_STATUS_TREE dependencies on INV_MWB_QUERY_MANAGER

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

72: l_procedure_name := 'ONHAND_NODE_EVENT';
73:
74: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
75: make_common_queries('MOQD');
76: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ITEM_ID).column_value :=
77: 'moqd.inventory_item_id';
78: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.REVISION).column_value :=
79: 'moqd.revision';
80: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=

Line 78: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.REVISION).column_value :=

74: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
75: make_common_queries('MOQD');
76: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ITEM_ID).column_value :=
77: 'moqd.inventory_item_id';
78: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.REVISION).column_value :=
79: 'moqd.revision';
80: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=
81: 'moqd.subinventory_code';
82: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=

Line 80: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=

76: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ITEM_ID).column_value :=
77: 'moqd.inventory_item_id';
78: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.REVISION).column_value :=
79: 'moqd.revision';
80: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=
81: 'moqd.subinventory_code';
82: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=
83: 'moqd.locator_id';
84: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=

Line 82: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=

78: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.REVISION).column_value :=
79: 'moqd.revision';
80: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=
81: 'moqd.subinventory_code';
82: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=
83: 'moqd.locator_id';
84: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
85: 'moqd.lot_number';
86: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LPN_ID).column_value :=

Line 84: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=

80: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=
81: 'moqd.subinventory_code';
82: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=
83: 'moqd.locator_id';
84: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
85: 'moqd.lot_number';
86: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LPN_ID).column_value :=
87: 'moqd.lpn_id';
88: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.STATUS_ID).column_value :=

Line 86: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LPN_ID).column_value :=

82: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=
83: 'moqd.locator_id';
84: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
85: 'moqd.lot_number';
86: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LPN_ID).column_value :=
87: 'moqd.lpn_id';
88: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.STATUS_ID).column_value :=
89: 'moqd.status_id';
90:

Line 88: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.STATUS_ID).column_value :=

84: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
85: 'moqd.lot_number';
86: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LPN_ID).column_value :=
87: 'moqd.lpn_id';
88: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.STATUS_ID).column_value :=
89: 'moqd.status_id';
90:
91: inv_mwb_query_manager.add_group_clause('moqd.inventory_item_id', 'ONHAND');
92: inv_mwb_query_manager.add_group_clause('moqd.revision', 'ONHAND');

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

87: 'moqd.lpn_id';
88: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.STATUS_ID).column_value :=
89: 'moqd.status_id';
90:
91: inv_mwb_query_manager.add_group_clause('moqd.inventory_item_id', 'ONHAND');
92: inv_mwb_query_manager.add_group_clause('moqd.revision', 'ONHAND');
93: inv_mwb_query_manager.add_group_clause('moqd.subinventory_code', 'ONHAND');
94: inv_mwb_query_manager.add_group_clause('moqd.locator_id', 'ONHAND');
95: inv_mwb_query_manager.add_group_clause('moqd.lot_number', 'ONHAND');

Line 92: inv_mwb_query_manager.add_group_clause('moqd.revision', 'ONHAND');

88: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.STATUS_ID).column_value :=
89: 'moqd.status_id';
90:
91: inv_mwb_query_manager.add_group_clause('moqd.inventory_item_id', 'ONHAND');
92: inv_mwb_query_manager.add_group_clause('moqd.revision', 'ONHAND');
93: inv_mwb_query_manager.add_group_clause('moqd.subinventory_code', 'ONHAND');
94: inv_mwb_query_manager.add_group_clause('moqd.locator_id', 'ONHAND');
95: inv_mwb_query_manager.add_group_clause('moqd.lot_number', 'ONHAND');
96: inv_mwb_query_manager.add_group_clause('moqd.lpn_id', 'ONHAND');

Line 93: inv_mwb_query_manager.add_group_clause('moqd.subinventory_code', 'ONHAND');

89: 'moqd.status_id';
90:
91: inv_mwb_query_manager.add_group_clause('moqd.inventory_item_id', 'ONHAND');
92: inv_mwb_query_manager.add_group_clause('moqd.revision', 'ONHAND');
93: inv_mwb_query_manager.add_group_clause('moqd.subinventory_code', 'ONHAND');
94: inv_mwb_query_manager.add_group_clause('moqd.locator_id', 'ONHAND');
95: inv_mwb_query_manager.add_group_clause('moqd.lot_number', 'ONHAND');
96: inv_mwb_query_manager.add_group_clause('moqd.lpn_id', 'ONHAND');
97: inv_mwb_query_manager.add_group_clause('moqd.status_id', 'ONHAND');

Line 94: inv_mwb_query_manager.add_group_clause('moqd.locator_id', 'ONHAND');

90:
91: inv_mwb_query_manager.add_group_clause('moqd.inventory_item_id', 'ONHAND');
92: inv_mwb_query_manager.add_group_clause('moqd.revision', 'ONHAND');
93: inv_mwb_query_manager.add_group_clause('moqd.subinventory_code', 'ONHAND');
94: inv_mwb_query_manager.add_group_clause('moqd.locator_id', 'ONHAND');
95: inv_mwb_query_manager.add_group_clause('moqd.lot_number', 'ONHAND');
96: inv_mwb_query_manager.add_group_clause('moqd.lpn_id', 'ONHAND');
97: inv_mwb_query_manager.add_group_clause('moqd.status_id', 'ONHAND');
98:

Line 95: inv_mwb_query_manager.add_group_clause('moqd.lot_number', 'ONHAND');

91: inv_mwb_query_manager.add_group_clause('moqd.inventory_item_id', 'ONHAND');
92: inv_mwb_query_manager.add_group_clause('moqd.revision', 'ONHAND');
93: inv_mwb_query_manager.add_group_clause('moqd.subinventory_code', 'ONHAND');
94: inv_mwb_query_manager.add_group_clause('moqd.locator_id', 'ONHAND');
95: inv_mwb_query_manager.add_group_clause('moqd.lot_number', 'ONHAND');
96: inv_mwb_query_manager.add_group_clause('moqd.lpn_id', 'ONHAND');
97: inv_mwb_query_manager.add_group_clause('moqd.status_id', 'ONHAND');
98:
99: inv_mwb_query_manager.add_qf_where_onhand('ONHAND');

Line 96: inv_mwb_query_manager.add_group_clause('moqd.lpn_id', 'ONHAND');

92: inv_mwb_query_manager.add_group_clause('moqd.revision', 'ONHAND');
93: inv_mwb_query_manager.add_group_clause('moqd.subinventory_code', 'ONHAND');
94: inv_mwb_query_manager.add_group_clause('moqd.locator_id', 'ONHAND');
95: inv_mwb_query_manager.add_group_clause('moqd.lot_number', 'ONHAND');
96: inv_mwb_query_manager.add_group_clause('moqd.lpn_id', 'ONHAND');
97: inv_mwb_query_manager.add_group_clause('moqd.status_id', 'ONHAND');
98:
99: inv_mwb_query_manager.add_qf_where_onhand('ONHAND');
100: inv_mwb_query_manager.add_where_clause(

Line 97: inv_mwb_query_manager.add_group_clause('moqd.status_id', 'ONHAND');

93: inv_mwb_query_manager.add_group_clause('moqd.subinventory_code', 'ONHAND');
94: inv_mwb_query_manager.add_group_clause('moqd.locator_id', 'ONHAND');
95: inv_mwb_query_manager.add_group_clause('moqd.lot_number', 'ONHAND');
96: inv_mwb_query_manager.add_group_clause('moqd.lpn_id', 'ONHAND');
97: inv_mwb_query_manager.add_group_clause('moqd.status_id', 'ONHAND');
98:
99: inv_mwb_query_manager.add_qf_where_onhand('ONHAND');
100: inv_mwb_query_manager.add_where_clause(
101: 'moqd.status_id = :onh_tree_status_id',

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

95: inv_mwb_query_manager.add_group_clause('moqd.lot_number', 'ONHAND');
96: inv_mwb_query_manager.add_group_clause('moqd.lpn_id', 'ONHAND');
97: inv_mwb_query_manager.add_group_clause('moqd.status_id', 'ONHAND');
98:
99: inv_mwb_query_manager.add_qf_where_onhand('ONHAND');
100: inv_mwb_query_manager.add_where_clause(
101: 'moqd.status_id = :onh_tree_status_id',
102: 'ONHAND'
103: );

Line 100: inv_mwb_query_manager.add_where_clause(

96: inv_mwb_query_manager.add_group_clause('moqd.lpn_id', 'ONHAND');
97: inv_mwb_query_manager.add_group_clause('moqd.status_id', 'ONHAND');
98:
99: inv_mwb_query_manager.add_qf_where_onhand('ONHAND');
100: inv_mwb_query_manager.add_where_clause(
101: 'moqd.status_id = :onh_tree_status_id',
102: 'ONHAND'
103: );
104: inv_mwb_query_manager.add_bind_variable(

Line 104: inv_mwb_query_manager.add_bind_variable(

100: inv_mwb_query_manager.add_where_clause(
101: 'moqd.status_id = :onh_tree_status_id',
102: 'ONHAND'
103: );
104: inv_mwb_query_manager.add_bind_variable(
105: 'onh_tree_status_id',
106: inv_mwb_globals.g_tree_st_id
107: );
108: inv_mwb_query_manager.execute_query;

Line 108: inv_mwb_query_manager.execute_query;

104: inv_mwb_query_manager.add_bind_variable(
105: 'onh_tree_status_id',
106: inv_mwb_globals.g_tree_st_id
107: );
108: inv_mwb_query_manager.execute_query;
109:
110: END IF;
111:
112: EXCEPTION

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

219: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL -- Bug 6429880
220: OR inv_mwb_globals.g_unit_number IS NOT NULL -- Bug 9486070
221: THEN
222: make_common_queries('MSN_QUERY');
223: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=
224: 'msn.current_subinventory_code';
225:
226: inv_mwb_query_manager.add_from_clause('mtl_secondary_inventories msi', 'ONHAND');
227: inv_mwb_query_manager.add_where_clause(

Line 226: inv_mwb_query_manager.add_from_clause('mtl_secondary_inventories msi', 'ONHAND');

222: make_common_queries('MSN_QUERY');
223: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=
224: 'msn.current_subinventory_code';
225:
226: inv_mwb_query_manager.add_from_clause('mtl_secondary_inventories msi', 'ONHAND');
227: inv_mwb_query_manager.add_where_clause(
228: 'msi.secondary_inventory_name = msn.current_subinventory_code',
229: 'ONHAND'
230: );

Line 227: inv_mwb_query_manager.add_where_clause(

223: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=
224: 'msn.current_subinventory_code';
225:
226: inv_mwb_query_manager.add_from_clause('mtl_secondary_inventories msi', 'ONHAND');
227: inv_mwb_query_manager.add_where_clause(
228: 'msi.secondary_inventory_name = msn.current_subinventory_code',
229: 'ONHAND'
230: );
231: inv_mwb_query_manager.add_where_clause(

Line 231: inv_mwb_query_manager.add_where_clause(

227: inv_mwb_query_manager.add_where_clause(
228: 'msi.secondary_inventory_name = msn.current_subinventory_code',
229: 'ONHAND'
230: );
231: inv_mwb_query_manager.add_where_clause(
232: 'msi.organization_id = msn.current_organization_id',
233: 'ONHAND'
234: );
235: inv_mwb_query_manager.add_group_clause('msn.current_subinventory_code', 'ONHAND');

Line 235: inv_mwb_query_manager.add_group_clause('msn.current_subinventory_code', 'ONHAND');

231: inv_mwb_query_manager.add_where_clause(
232: 'msi.organization_id = msn.current_organization_id',
233: 'ONHAND'
234: );
235: inv_mwb_query_manager.add_group_clause('msn.current_subinventory_code', 'ONHAND');
236: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
237:
238: ELSE
239: make_common_queries('MOQD');

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

232: 'msi.organization_id = msn.current_organization_id',
233: 'ONHAND'
234: );
235: inv_mwb_query_manager.add_group_clause('msn.current_subinventory_code', 'ONHAND');
236: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
237:
238: ELSE
239: make_common_queries('MOQD');
240: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=

Line 240: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=

236: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
237:
238: ELSE
239: make_common_queries('MOQD');
240: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=
241: 'moqd.subinventory_code';
242: inv_mwb_query_manager.add_from_clause('mtl_secondary_inventories msi', 'ONHAND');
243: inv_mwb_query_manager.add_where_clause(
244: 'msi.secondary_inventory_name = moqd.subinventory_code',

Line 242: inv_mwb_query_manager.add_from_clause('mtl_secondary_inventories msi', 'ONHAND');

238: ELSE
239: make_common_queries('MOQD');
240: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=
241: 'moqd.subinventory_code';
242: inv_mwb_query_manager.add_from_clause('mtl_secondary_inventories msi', 'ONHAND');
243: inv_mwb_query_manager.add_where_clause(
244: 'msi.secondary_inventory_name = moqd.subinventory_code',
245: 'ONHAND'
246: );

Line 243: inv_mwb_query_manager.add_where_clause(

239: make_common_queries('MOQD');
240: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=
241: 'moqd.subinventory_code';
242: inv_mwb_query_manager.add_from_clause('mtl_secondary_inventories msi', 'ONHAND');
243: inv_mwb_query_manager.add_where_clause(
244: 'msi.secondary_inventory_name = moqd.subinventory_code',
245: 'ONHAND'
246: );
247: inv_mwb_query_manager.add_where_clause(

Line 247: inv_mwb_query_manager.add_where_clause(

243: inv_mwb_query_manager.add_where_clause(
244: 'msi.secondary_inventory_name = moqd.subinventory_code',
245: 'ONHAND'
246: );
247: inv_mwb_query_manager.add_where_clause(
248: 'msi.organization_id = moqd.organization_id',
249: 'ONHAND'
250: );
251: inv_mwb_query_manager.add_group_clause('moqd.subinventory_code', 'ONHAND');

Line 251: inv_mwb_query_manager.add_group_clause('moqd.subinventory_code', 'ONHAND');

247: inv_mwb_query_manager.add_where_clause(
248: 'msi.organization_id = moqd.organization_id',
249: 'ONHAND'
250: );
251: inv_mwb_query_manager.add_group_clause('moqd.subinventory_code', 'ONHAND');
252: inv_mwb_query_manager.add_qf_where_onhand('ONHAND');
253:
254: END IF;
255: inv_mwb_query_manager.add_where_clause(

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

248: 'msi.organization_id = moqd.organization_id',
249: 'ONHAND'
250: );
251: inv_mwb_query_manager.add_group_clause('moqd.subinventory_code', 'ONHAND');
252: inv_mwb_query_manager.add_qf_where_onhand('ONHAND');
253:
254: END IF;
255: inv_mwb_query_manager.add_where_clause(
256: 'msi.organization_id = :onh_tree_organization_id',

Line 255: inv_mwb_query_manager.add_where_clause(

251: inv_mwb_query_manager.add_group_clause('moqd.subinventory_code', 'ONHAND');
252: inv_mwb_query_manager.add_qf_where_onhand('ONHAND');
253:
254: END IF;
255: inv_mwb_query_manager.add_where_clause(
256: 'msi.organization_id = :onh_tree_organization_id',
257: 'ONHAND'
258: );
259: inv_mwb_query_manager.add_where_clause(

Line 259: inv_mwb_query_manager.add_where_clause(

255: inv_mwb_query_manager.add_where_clause(
256: 'msi.organization_id = :onh_tree_organization_id',
257: 'ONHAND'
258: );
259: inv_mwb_query_manager.add_where_clause(
260: 'msi.status_id = :onh_tree_status_id',
261: 'ONHAND'
262: );
263: inv_mwb_query_manager.add_bind_variable(

Line 263: inv_mwb_query_manager.add_bind_variable(

259: inv_mwb_query_manager.add_where_clause(
260: 'msi.status_id = :onh_tree_status_id',
261: 'ONHAND'
262: );
263: inv_mwb_query_manager.add_bind_variable(
264: 'onh_tree_status_id',
265: inv_mwb_globals.g_tree_st_id
266: );
267: inv_mwb_query_manager.add_bind_variable(

Line 267: inv_mwb_query_manager.add_bind_variable(

263: inv_mwb_query_manager.add_bind_variable(
264: 'onh_tree_status_id',
265: inv_mwb_globals.g_tree_st_id
266: );
267: inv_mwb_query_manager.add_bind_variable(
268: 'onh_tree_organization_id',
269: inv_mwb_globals.g_tree_organization_id
270: );
271: inv_mwb_query_manager.execute_query;

Line 271: inv_mwb_query_manager.execute_query;

267: inv_mwb_query_manager.add_bind_variable(
268: 'onh_tree_organization_id',
269: inv_mwb_globals.g_tree_organization_id
270: );
271: inv_mwb_query_manager.execute_query;
272:
273: END IF;
274: EXCEPTION
275: WHEN no_data_found THEN

Line 307: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=

303: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL -- Bug 6429880
304: OR inv_mwb_globals.g_unit_number IS NOT NULL -- Bug 9486070
305: THEN
306: make_common_queries('MSN_QUERY');
307: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=
308: 'msn.current_locator_id';
309:
310: inv_mwb_query_manager.add_from_clause('mtl_item_locations mil', 'ONHAND');
311: inv_mwb_query_manager.add_where_clause(

Line 310: inv_mwb_query_manager.add_from_clause('mtl_item_locations mil', 'ONHAND');

306: make_common_queries('MSN_QUERY');
307: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=
308: 'msn.current_locator_id';
309:
310: inv_mwb_query_manager.add_from_clause('mtl_item_locations mil', 'ONHAND');
311: inv_mwb_query_manager.add_where_clause(
312: 'mil.inventory_location_id = msn.current_locator_id',
313: 'ONHAND'
314: );

Line 311: inv_mwb_query_manager.add_where_clause(

307: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=
308: 'msn.current_locator_id';
309:
310: inv_mwb_query_manager.add_from_clause('mtl_item_locations mil', 'ONHAND');
311: inv_mwb_query_manager.add_where_clause(
312: 'mil.inventory_location_id = msn.current_locator_id',
313: 'ONHAND'
314: );
315: inv_mwb_query_manager.add_where_clause(

Line 315: inv_mwb_query_manager.add_where_clause(

311: inv_mwb_query_manager.add_where_clause(
312: 'mil.inventory_location_id = msn.current_locator_id',
313: 'ONHAND'
314: );
315: inv_mwb_query_manager.add_where_clause(
316: 'mil.subinventory_code = msn.current_subinventory_code',
317: 'ONHAND'
318: );
319: inv_mwb_query_manager.add_where_clause(

Line 319: inv_mwb_query_manager.add_where_clause(

315: inv_mwb_query_manager.add_where_clause(
316: 'mil.subinventory_code = msn.current_subinventory_code',
317: 'ONHAND'
318: );
319: inv_mwb_query_manager.add_where_clause(
320: 'mil.organization_id = msn.current_organization_id',
321: 'ONHAND'
322: );
323: inv_mwb_query_manager.add_group_clause('msn.current_locator_id', 'ONHAND');

Line 323: inv_mwb_query_manager.add_group_clause('msn.current_locator_id', 'ONHAND');

319: inv_mwb_query_manager.add_where_clause(
320: 'mil.organization_id = msn.current_organization_id',
321: 'ONHAND'
322: );
323: inv_mwb_query_manager.add_group_clause('msn.current_locator_id', 'ONHAND');
324: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
325:
326: ELSE
327: make_common_queries('MOQD');

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

320: 'mil.organization_id = msn.current_organization_id',
321: 'ONHAND'
322: );
323: inv_mwb_query_manager.add_group_clause('msn.current_locator_id', 'ONHAND');
324: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
325:
326: ELSE
327: make_common_queries('MOQD');
328: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=

Line 328: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=

324: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
325:
326: ELSE
327: make_common_queries('MOQD');
328: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=
329: 'moqd.locator_id';
330: inv_mwb_query_manager.add_from_clause('mtl_item_locations mil', 'ONHAND');
331: inv_mwb_query_manager.add_where_clause(
332: 'mil.inventory_location_id = moqd.locator_id',

Line 330: inv_mwb_query_manager.add_from_clause('mtl_item_locations mil', 'ONHAND');

326: ELSE
327: make_common_queries('MOQD');
328: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=
329: 'moqd.locator_id';
330: inv_mwb_query_manager.add_from_clause('mtl_item_locations mil', 'ONHAND');
331: inv_mwb_query_manager.add_where_clause(
332: 'mil.inventory_location_id = moqd.locator_id',
333: 'ONHAND'
334: );

Line 331: inv_mwb_query_manager.add_where_clause(

327: make_common_queries('MOQD');
328: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=
329: 'moqd.locator_id';
330: inv_mwb_query_manager.add_from_clause('mtl_item_locations mil', 'ONHAND');
331: inv_mwb_query_manager.add_where_clause(
332: 'mil.inventory_location_id = moqd.locator_id',
333: 'ONHAND'
334: );
335: inv_mwb_query_manager.add_where_clause(

Line 335: inv_mwb_query_manager.add_where_clause(

331: inv_mwb_query_manager.add_where_clause(
332: 'mil.inventory_location_id = moqd.locator_id',
333: 'ONHAND'
334: );
335: inv_mwb_query_manager.add_where_clause(
336: 'mil.subinventory_code = moqd.subinventory_code',
337: 'ONHAND'
338: );
339: inv_mwb_query_manager.add_where_clause(

Line 339: inv_mwb_query_manager.add_where_clause(

335: inv_mwb_query_manager.add_where_clause(
336: 'mil.subinventory_code = moqd.subinventory_code',
337: 'ONHAND'
338: );
339: inv_mwb_query_manager.add_where_clause(
340: 'mil.organization_id = moqd.organization_id',
341: 'ONHAND'
342: );
343: inv_mwb_query_manager.add_group_clause('moqd.locator_id', 'ONHAND');

Line 343: inv_mwb_query_manager.add_group_clause('moqd.locator_id', 'ONHAND');

339: inv_mwb_query_manager.add_where_clause(
340: 'mil.organization_id = moqd.organization_id',
341: 'ONHAND'
342: );
343: inv_mwb_query_manager.add_group_clause('moqd.locator_id', 'ONHAND');
344: inv_mwb_query_manager.add_qf_where_onhand('ONHAND');
345:
346: END IF;
347: inv_mwb_query_manager.add_where_clause(

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

340: 'mil.organization_id = moqd.organization_id',
341: 'ONHAND'
342: );
343: inv_mwb_query_manager.add_group_clause('moqd.locator_id', 'ONHAND');
344: inv_mwb_query_manager.add_qf_where_onhand('ONHAND');
345:
346: END IF;
347: inv_mwb_query_manager.add_where_clause(
348: 'mil.organization_id = :onh_tree_organization_id',

Line 347: inv_mwb_query_manager.add_where_clause(

343: inv_mwb_query_manager.add_group_clause('moqd.locator_id', 'ONHAND');
344: inv_mwb_query_manager.add_qf_where_onhand('ONHAND');
345:
346: END IF;
347: inv_mwb_query_manager.add_where_clause(
348: 'mil.organization_id = :onh_tree_organization_id',
349: 'ONHAND'
350: );
351: inv_mwb_query_manager.add_where_clause(

Line 351: inv_mwb_query_manager.add_where_clause(

347: inv_mwb_query_manager.add_where_clause(
348: 'mil.organization_id = :onh_tree_organization_id',
349: 'ONHAND'
350: );
351: inv_mwb_query_manager.add_where_clause(
352: 'mil.status_id = :onh_tree_status_id',
353: 'ONHAND'
354: );
355: inv_mwb_query_manager.add_bind_variable(

Line 355: inv_mwb_query_manager.add_bind_variable(

351: inv_mwb_query_manager.add_where_clause(
352: 'mil.status_id = :onh_tree_status_id',
353: 'ONHAND'
354: );
355: inv_mwb_query_manager.add_bind_variable(
356: 'onh_tree_status_id',
357: inv_mwb_globals.g_tree_st_id
358: );
359: inv_mwb_query_manager.add_bind_variable(

Line 359: inv_mwb_query_manager.add_bind_variable(

355: inv_mwb_query_manager.add_bind_variable(
356: 'onh_tree_status_id',
357: inv_mwb_globals.g_tree_st_id
358: );
359: inv_mwb_query_manager.add_bind_variable(
360: 'onh_tree_organization_id',
361: inv_mwb_globals.g_tree_organization_id
362: );
363: inv_mwb_query_manager.execute_query;

Line 363: inv_mwb_query_manager.execute_query;

359: inv_mwb_query_manager.add_bind_variable(
360: 'onh_tree_organization_id',
361: inv_mwb_globals.g_tree_organization_id
362: );
363: inv_mwb_query_manager.execute_query;
364:
365: END IF;
366:
367: EXCEPTION

Line 398: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=

394: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL -- Bug 6429880
395: OR inv_mwb_globals.g_unit_number IS NOT NULL -- Bug 9486070
396: THEN
397: make_common_queries('MSN_QUERY');
398: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
399: 'msn.lot_number';
400: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ITEM_ID).column_value :=
401: 'msn.inventory_item_id';
402: inv_mwb_query_manager.add_from_clause('mtl_lot_numbers mln', 'ONHAND');

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

396: THEN
397: make_common_queries('MSN_QUERY');
398: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
399: 'msn.lot_number';
400: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ITEM_ID).column_value :=
401: 'msn.inventory_item_id';
402: inv_mwb_query_manager.add_from_clause('mtl_lot_numbers mln', 'ONHAND');
403: inv_mwb_query_manager.add_where_clause(
404: 'mln.lot_number = msn.lot_number',

Line 402: inv_mwb_query_manager.add_from_clause('mtl_lot_numbers mln', 'ONHAND');

398: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
399: 'msn.lot_number';
400: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ITEM_ID).column_value :=
401: 'msn.inventory_item_id';
402: inv_mwb_query_manager.add_from_clause('mtl_lot_numbers mln', 'ONHAND');
403: inv_mwb_query_manager.add_where_clause(
404: 'mln.lot_number = msn.lot_number',
405: 'ONHAND'
406: );

Line 403: inv_mwb_query_manager.add_where_clause(

399: 'msn.lot_number';
400: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ITEM_ID).column_value :=
401: 'msn.inventory_item_id';
402: inv_mwb_query_manager.add_from_clause('mtl_lot_numbers mln', 'ONHAND');
403: inv_mwb_query_manager.add_where_clause(
404: 'mln.lot_number = msn.lot_number',
405: 'ONHAND'
406: );
407: inv_mwb_query_manager.add_where_clause(

Line 407: inv_mwb_query_manager.add_where_clause(

403: inv_mwb_query_manager.add_where_clause(
404: 'mln.lot_number = msn.lot_number',
405: 'ONHAND'
406: );
407: inv_mwb_query_manager.add_where_clause(
408: 'mln.organization_id = msn.current_organization_id',
409: 'ONHAND'
410: );
411: inv_mwb_query_manager.add_where_clause(

Line 411: inv_mwb_query_manager.add_where_clause(

407: inv_mwb_query_manager.add_where_clause(
408: 'mln.organization_id = msn.current_organization_id',
409: 'ONHAND'
410: );
411: inv_mwb_query_manager.add_where_clause(
412: 'mln.inventory_item_id = msn.inventory_item_id',
413: 'ONHAND'
414: );
415: inv_mwb_query_manager.add_group_clause('msn.lot_number', 'ONHAND');

Line 415: inv_mwb_query_manager.add_group_clause('msn.lot_number', 'ONHAND');

411: inv_mwb_query_manager.add_where_clause(
412: 'mln.inventory_item_id = msn.inventory_item_id',
413: 'ONHAND'
414: );
415: inv_mwb_query_manager.add_group_clause('msn.lot_number', 'ONHAND');
416: inv_mwb_query_manager.add_group_clause('msn.inventory_item_id', 'ONHAND');
417: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
418:
419: ELSE

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

412: 'mln.inventory_item_id = msn.inventory_item_id',
413: 'ONHAND'
414: );
415: inv_mwb_query_manager.add_group_clause('msn.lot_number', 'ONHAND');
416: inv_mwb_query_manager.add_group_clause('msn.inventory_item_id', 'ONHAND');
417: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
418:
419: ELSE
420: make_common_queries('MOQD');

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

413: 'ONHAND'
414: );
415: inv_mwb_query_manager.add_group_clause('msn.lot_number', 'ONHAND');
416: inv_mwb_query_manager.add_group_clause('msn.inventory_item_id', 'ONHAND');
417: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
418:
419: ELSE
420: make_common_queries('MOQD');
421: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=

Line 421: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=

417: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
418:
419: ELSE
420: make_common_queries('MOQD');
421: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
422: 'moqd.lot_number';
423: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ITEM_ID).column_value :=
424: 'moqd.inventory_item_id';
425: inv_mwb_query_manager.add_from_clause('mtl_lot_numbers mln', 'ONHAND');

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

419: ELSE
420: make_common_queries('MOQD');
421: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
422: 'moqd.lot_number';
423: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ITEM_ID).column_value :=
424: 'moqd.inventory_item_id';
425: inv_mwb_query_manager.add_from_clause('mtl_lot_numbers mln', 'ONHAND');
426: inv_mwb_query_manager.add_where_clause(
427: 'mln.lot_number = moqd.lot_number',

Line 425: inv_mwb_query_manager.add_from_clause('mtl_lot_numbers mln', 'ONHAND');

421: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
422: 'moqd.lot_number';
423: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ITEM_ID).column_value :=
424: 'moqd.inventory_item_id';
425: inv_mwb_query_manager.add_from_clause('mtl_lot_numbers mln', 'ONHAND');
426: inv_mwb_query_manager.add_where_clause(
427: 'mln.lot_number = moqd.lot_number',
428: 'ONHAND'
429: );

Line 426: inv_mwb_query_manager.add_where_clause(

422: 'moqd.lot_number';
423: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ITEM_ID).column_value :=
424: 'moqd.inventory_item_id';
425: inv_mwb_query_manager.add_from_clause('mtl_lot_numbers mln', 'ONHAND');
426: inv_mwb_query_manager.add_where_clause(
427: 'mln.lot_number = moqd.lot_number',
428: 'ONHAND'
429: );
430: inv_mwb_query_manager.add_where_clause(

Line 430: inv_mwb_query_manager.add_where_clause(

426: inv_mwb_query_manager.add_where_clause(
427: 'mln.lot_number = moqd.lot_number',
428: 'ONHAND'
429: );
430: inv_mwb_query_manager.add_where_clause(
431: 'mln.organization_id = moqd.organization_id',
432: 'ONHAND'
433: );
434: inv_mwb_query_manager.add_where_clause(

Line 434: inv_mwb_query_manager.add_where_clause(

430: inv_mwb_query_manager.add_where_clause(
431: 'mln.organization_id = moqd.organization_id',
432: 'ONHAND'
433: );
434: inv_mwb_query_manager.add_where_clause(
435: 'mln.inventory_item_id = moqd.inventory_item_id',
436: 'ONHAND'
437: );
438:

Line 439: inv_mwb_query_manager.add_group_clause('moqd.lot_number', 'ONHAND');

435: 'mln.inventory_item_id = moqd.inventory_item_id',
436: 'ONHAND'
437: );
438:
439: inv_mwb_query_manager.add_group_clause('moqd.lot_number', 'ONHAND');
440: inv_mwb_query_manager.add_group_clause('moqd.inventory_item_id', 'ONHAND');
441: inv_mwb_query_manager.add_qf_where_onhand('ONHAND');
442:
443: END IF;

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

436: 'ONHAND'
437: );
438:
439: inv_mwb_query_manager.add_group_clause('moqd.lot_number', 'ONHAND');
440: inv_mwb_query_manager.add_group_clause('moqd.inventory_item_id', 'ONHAND');
441: inv_mwb_query_manager.add_qf_where_onhand('ONHAND');
442:
443: END IF;
444: inv_mwb_query_manager.add_where_clause(

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

437: );
438:
439: inv_mwb_query_manager.add_group_clause('moqd.lot_number', 'ONHAND');
440: inv_mwb_query_manager.add_group_clause('moqd.inventory_item_id', 'ONHAND');
441: inv_mwb_query_manager.add_qf_where_onhand('ONHAND');
442:
443: END IF;
444: inv_mwb_query_manager.add_where_clause(
445: 'mln.organization_id = :onh_tree_organization_id',

Line 444: inv_mwb_query_manager.add_where_clause(

440: inv_mwb_query_manager.add_group_clause('moqd.inventory_item_id', 'ONHAND');
441: inv_mwb_query_manager.add_qf_where_onhand('ONHAND');
442:
443: END IF;
444: inv_mwb_query_manager.add_where_clause(
445: 'mln.organization_id = :onh_tree_organization_id',
446: 'ONHAND'
447: );
448: inv_mwb_query_manager.add_where_clause(

Line 448: inv_mwb_query_manager.add_where_clause(

444: inv_mwb_query_manager.add_where_clause(
445: 'mln.organization_id = :onh_tree_organization_id',
446: 'ONHAND'
447: );
448: inv_mwb_query_manager.add_where_clause(
449: 'mln.status_id = :onh_tree_status_id',
450: 'ONHAND'
451: );
452: inv_mwb_query_manager.add_bind_variable(

Line 452: inv_mwb_query_manager.add_bind_variable(

448: inv_mwb_query_manager.add_where_clause(
449: 'mln.status_id = :onh_tree_status_id',
450: 'ONHAND'
451: );
452: inv_mwb_query_manager.add_bind_variable(
453: 'onh_tree_status_id',
454: inv_mwb_globals.g_tree_st_id
455: );
456: inv_mwb_query_manager.add_bind_variable(

Line 456: inv_mwb_query_manager.add_bind_variable(

452: inv_mwb_query_manager.add_bind_variable(
453: 'onh_tree_status_id',
454: inv_mwb_globals.g_tree_st_id
455: );
456: inv_mwb_query_manager.add_bind_variable(
457: 'onh_tree_organization_id',
458: inv_mwb_globals.g_tree_organization_id
459: );
460: inv_mwb_query_manager.execute_query;

Line 460: inv_mwb_query_manager.execute_query;

456: inv_mwb_query_manager.add_bind_variable(
457: 'onh_tree_organization_id',
458: inv_mwb_globals.g_tree_organization_id
459: );
460: inv_mwb_query_manager.execute_query;
461:
462: END IF;
463:
464: EXCEPTION

Line 491: inv_mwb_query_manager.add_where_clause(

487:
488: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
489:
490: make_common_queries('MSN');
491: inv_mwb_query_manager.add_where_clause(
492: 'msn.current_organization_id = :onh_tree_organization_id',
493: 'ONHAND'
494: );
495: inv_mwb_query_manager.add_where_clause(

Line 495: inv_mwb_query_manager.add_where_clause(

491: inv_mwb_query_manager.add_where_clause(
492: 'msn.current_organization_id = :onh_tree_organization_id',
493: 'ONHAND'
494: );
495: inv_mwb_query_manager.add_where_clause(
496: 'msn.status_id = :onh_tree_status_id',
497: 'ONHAND'
498: );
499: inv_mwb_query_manager.add_bind_variable(

Line 499: inv_mwb_query_manager.add_bind_variable(

495: inv_mwb_query_manager.add_where_clause(
496: 'msn.status_id = :onh_tree_status_id',
497: 'ONHAND'
498: );
499: inv_mwb_query_manager.add_bind_variable(
500: 'onh_tree_status_id',
501: inv_mwb_globals.g_tree_st_id
502: );
503: inv_mwb_query_manager.add_bind_variable(

Line 503: inv_mwb_query_manager.add_bind_variable(

499: inv_mwb_query_manager.add_bind_variable(
500: 'onh_tree_status_id',
501: inv_mwb_globals.g_tree_st_id
502: );
503: inv_mwb_query_manager.add_bind_variable(
504: 'onh_tree_organization_id',
505: inv_mwb_globals.g_tree_organization_id
506: );
507: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');

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

503: inv_mwb_query_manager.add_bind_variable(
504: 'onh_tree_organization_id',
505: inv_mwb_globals.g_tree_organization_id
506: );
507: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
508: inv_mwb_query_manager.execute_query;
509:
510: END IF; --tree event
511:

Line 508: inv_mwb_query_manager.execute_query;

504: 'onh_tree_organization_id',
505: inv_mwb_globals.g_tree_organization_id
506: );
507: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
508: inv_mwb_query_manager.execute_query;
509:
510: END IF; --tree event
511:
512: EXCEPTION

Line 538: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=

534: OR inv_mwb_globals.g_unit_number IS NOT NULL -- Bug 9486070
535: THEN
536:
537: make_common_queries('MSN_QUERY');
538: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=
539: 'msn.current_subinventory_code';
540:
541: inv_mwb_query_manager.add_from_clause('mtl_secondary_inventories msi', 'ONHAND');
542: inv_mwb_query_manager.add_where_clause(

Line 541: inv_mwb_query_manager.add_from_clause('mtl_secondary_inventories msi', 'ONHAND');

537: make_common_queries('MSN_QUERY');
538: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=
539: 'msn.current_subinventory_code';
540:
541: inv_mwb_query_manager.add_from_clause('mtl_secondary_inventories msi', 'ONHAND');
542: inv_mwb_query_manager.add_where_clause(
543: 'msi.secondary_inventory_name = msn.current_subinventory_code',
544: 'ONHAND'
545: );

Line 542: inv_mwb_query_manager.add_where_clause(

538: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=
539: 'msn.current_subinventory_code';
540:
541: inv_mwb_query_manager.add_from_clause('mtl_secondary_inventories msi', 'ONHAND');
542: inv_mwb_query_manager.add_where_clause(
543: 'msi.secondary_inventory_name = msn.current_subinventory_code',
544: 'ONHAND'
545: );
546: inv_mwb_query_manager.add_where_clause(

Line 546: inv_mwb_query_manager.add_where_clause(

542: inv_mwb_query_manager.add_where_clause(
543: 'msi.secondary_inventory_name = msn.current_subinventory_code',
544: 'ONHAND'
545: );
546: inv_mwb_query_manager.add_where_clause(
547: 'msi.organization_id = msn.current_organization_id',
548: 'ONHAND'
549: );
550: inv_mwb_query_manager.add_group_clause('msn.current_subinventory_code', 'ONHAND');

Line 550: inv_mwb_query_manager.add_group_clause('msn.current_subinventory_code', 'ONHAND');

546: inv_mwb_query_manager.add_where_clause(
547: 'msi.organization_id = msn.current_organization_id',
548: 'ONHAND'
549: );
550: inv_mwb_query_manager.add_group_clause('msn.current_subinventory_code', 'ONHAND');
551: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
552:
553: ELSE
554: make_common_queries('MOQD');

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

547: 'msi.organization_id = msn.current_organization_id',
548: 'ONHAND'
549: );
550: inv_mwb_query_manager.add_group_clause('msn.current_subinventory_code', 'ONHAND');
551: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
552:
553: ELSE
554: make_common_queries('MOQD');
555: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=

Line 555: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=

551: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
552:
553: ELSE
554: make_common_queries('MOQD');
555: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=
556: 'moqd.subinventory_code';
557: inv_mwb_query_manager.add_from_clause('mtl_secondary_inventories msi', 'ONHAND');
558: inv_mwb_query_manager.add_where_clause(
559: 'msi.secondary_inventory_name = moqd.subinventory_code',

Line 557: inv_mwb_query_manager.add_from_clause('mtl_secondary_inventories msi', 'ONHAND');

553: ELSE
554: make_common_queries('MOQD');
555: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=
556: 'moqd.subinventory_code';
557: inv_mwb_query_manager.add_from_clause('mtl_secondary_inventories msi', 'ONHAND');
558: inv_mwb_query_manager.add_where_clause(
559: 'msi.secondary_inventory_name = moqd.subinventory_code',
560: 'ONHAND'
561: );

Line 558: inv_mwb_query_manager.add_where_clause(

554: make_common_queries('MOQD');
555: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=
556: 'moqd.subinventory_code';
557: inv_mwb_query_manager.add_from_clause('mtl_secondary_inventories msi', 'ONHAND');
558: inv_mwb_query_manager.add_where_clause(
559: 'msi.secondary_inventory_name = moqd.subinventory_code',
560: 'ONHAND'
561: );
562: inv_mwb_query_manager.add_where_clause(

Line 562: inv_mwb_query_manager.add_where_clause(

558: inv_mwb_query_manager.add_where_clause(
559: 'msi.secondary_inventory_name = moqd.subinventory_code',
560: 'ONHAND'
561: );
562: inv_mwb_query_manager.add_where_clause(
563: 'msi.organization_id = moqd.organization_id',
564: 'ONHAND'
565: );
566: inv_mwb_query_manager.add_group_clause('moqd.subinventory_code', 'ONHAND');

Line 566: inv_mwb_query_manager.add_group_clause('moqd.subinventory_code', 'ONHAND');

562: inv_mwb_query_manager.add_where_clause(
563: 'msi.organization_id = moqd.organization_id',
564: 'ONHAND'
565: );
566: inv_mwb_query_manager.add_group_clause('moqd.subinventory_code', 'ONHAND');
567: inv_mwb_query_manager.add_qf_where_onhand('ONHAND');
568:
569: END IF;
570: inv_mwb_query_manager.add_where_clause(

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

563: 'msi.organization_id = moqd.organization_id',
564: 'ONHAND'
565: );
566: inv_mwb_query_manager.add_group_clause('moqd.subinventory_code', 'ONHAND');
567: inv_mwb_query_manager.add_qf_where_onhand('ONHAND');
568:
569: END IF;
570: inv_mwb_query_manager.add_where_clause(
571: 'msi.secondary_inventory_name = :onh_tree_subinventory_code',

Line 570: inv_mwb_query_manager.add_where_clause(

566: inv_mwb_query_manager.add_group_clause('moqd.subinventory_code', 'ONHAND');
567: inv_mwb_query_manager.add_qf_where_onhand('ONHAND');
568:
569: END IF;
570: inv_mwb_query_manager.add_where_clause(
571: 'msi.secondary_inventory_name = :onh_tree_subinventory_code',
572: 'ONHAND'
573: );
574: inv_mwb_query_manager.add_where_clause(

Line 574: inv_mwb_query_manager.add_where_clause(

570: inv_mwb_query_manager.add_where_clause(
571: 'msi.secondary_inventory_name = :onh_tree_subinventory_code',
572: 'ONHAND'
573: );
574: inv_mwb_query_manager.add_where_clause(
575: 'msi.organization_id = :onh_tree_organization_id',
576: 'ONHAND'
577: );
578: inv_mwb_query_manager.add_where_clause(

Line 578: inv_mwb_query_manager.add_where_clause(

574: inv_mwb_query_manager.add_where_clause(
575: 'msi.organization_id = :onh_tree_organization_id',
576: 'ONHAND'
577: );
578: inv_mwb_query_manager.add_where_clause(
579: 'msi.status_id = :onh_tree_status_id',
580: 'ONHAND'
581: );
582: inv_mwb_query_manager.add_bind_variable(

Line 582: inv_mwb_query_manager.add_bind_variable(

578: inv_mwb_query_manager.add_where_clause(
579: 'msi.status_id = :onh_tree_status_id',
580: 'ONHAND'
581: );
582: inv_mwb_query_manager.add_bind_variable(
583: 'onh_tree_status_id',
584: inv_mwb_globals.g_tree_st_id
585: );
586: inv_mwb_query_manager.add_bind_variable(

Line 586: inv_mwb_query_manager.add_bind_variable(

582: inv_mwb_query_manager.add_bind_variable(
583: 'onh_tree_status_id',
584: inv_mwb_globals.g_tree_st_id
585: );
586: inv_mwb_query_manager.add_bind_variable(
587: 'onh_tree_organization_id',
588: inv_mwb_globals.g_tree_organization_id
589: );
590: inv_mwb_query_manager.add_bind_variable(

Line 590: inv_mwb_query_manager.add_bind_variable(

586: inv_mwb_query_manager.add_bind_variable(
587: 'onh_tree_organization_id',
588: inv_mwb_globals.g_tree_organization_id
589: );
590: inv_mwb_query_manager.add_bind_variable(
591: 'onh_tree_subinventory_code',
592: inv_mwb_globals.g_tree_subinventory_code
593: );
594: inv_mwb_query_manager.execute_query;

Line 594: inv_mwb_query_manager.execute_query;

590: inv_mwb_query_manager.add_bind_variable(
591: 'onh_tree_subinventory_code',
592: inv_mwb_globals.g_tree_subinventory_code
593: );
594: inv_mwb_query_manager.execute_query;
595:
596: END IF;
597:
598: EXCEPTION

Line 624: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=

620: OR inv_mwb_globals.g_unit_number IS NOT NULL -- Bug 9486070
621: THEN
622:
623: make_common_queries('MSN_QUERY');
624: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=
625: 'msn.current_locator_id';
626:
627: inv_mwb_query_manager.add_from_clause('mtl_item_locations mil', 'ONHAND');
628: inv_mwb_query_manager.add_where_clause(

Line 627: inv_mwb_query_manager.add_from_clause('mtl_item_locations mil', 'ONHAND');

623: make_common_queries('MSN_QUERY');
624: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=
625: 'msn.current_locator_id';
626:
627: inv_mwb_query_manager.add_from_clause('mtl_item_locations mil', 'ONHAND');
628: inv_mwb_query_manager.add_where_clause(
629: 'mil.inventory_location_id = msn.current_locator_id',
630: 'ONHAND'
631: );

Line 628: inv_mwb_query_manager.add_where_clause(

624: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=
625: 'msn.current_locator_id';
626:
627: inv_mwb_query_manager.add_from_clause('mtl_item_locations mil', 'ONHAND');
628: inv_mwb_query_manager.add_where_clause(
629: 'mil.inventory_location_id = msn.current_locator_id',
630: 'ONHAND'
631: );
632: inv_mwb_query_manager.add_where_clause(

Line 632: inv_mwb_query_manager.add_where_clause(

628: inv_mwb_query_manager.add_where_clause(
629: 'mil.inventory_location_id = msn.current_locator_id',
630: 'ONHAND'
631: );
632: inv_mwb_query_manager.add_where_clause(
633: 'mil.subinventory_code = msn.current_subinventory_code',
634: 'ONHAND'
635: );
636: inv_mwb_query_manager.add_where_clause(

Line 636: inv_mwb_query_manager.add_where_clause(

632: inv_mwb_query_manager.add_where_clause(
633: 'mil.subinventory_code = msn.current_subinventory_code',
634: 'ONHAND'
635: );
636: inv_mwb_query_manager.add_where_clause(
637: 'mil.organization_id = msn.current_organization_id',
638: 'ONHAND'
639: );
640: inv_mwb_query_manager.add_group_clause('msn.current_locator_id', 'ONHAND');

Line 640: inv_mwb_query_manager.add_group_clause('msn.current_locator_id', 'ONHAND');

636: inv_mwb_query_manager.add_where_clause(
637: 'mil.organization_id = msn.current_organization_id',
638: 'ONHAND'
639: );
640: inv_mwb_query_manager.add_group_clause('msn.current_locator_id', 'ONHAND');
641: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
642:
643: ELSE
644: make_common_queries('MOQD');

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

637: 'mil.organization_id = msn.current_organization_id',
638: 'ONHAND'
639: );
640: inv_mwb_query_manager.add_group_clause('msn.current_locator_id', 'ONHAND');
641: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
642:
643: ELSE
644: make_common_queries('MOQD');
645: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=

Line 645: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=

641: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
642:
643: ELSE
644: make_common_queries('MOQD');
645: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=
646: 'moqd.locator_id';
647: inv_mwb_query_manager.add_from_clause('mtl_item_locations mil', 'ONHAND');
648: inv_mwb_query_manager.add_where_clause(
649: 'mil.inventory_location_id = moqd.locator_id',

Line 647: inv_mwb_query_manager.add_from_clause('mtl_item_locations mil', 'ONHAND');

643: ELSE
644: make_common_queries('MOQD');
645: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=
646: 'moqd.locator_id';
647: inv_mwb_query_manager.add_from_clause('mtl_item_locations mil', 'ONHAND');
648: inv_mwb_query_manager.add_where_clause(
649: 'mil.inventory_location_id = moqd.locator_id',
650: 'ONHAND'
651: );

Line 648: inv_mwb_query_manager.add_where_clause(

644: make_common_queries('MOQD');
645: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=
646: 'moqd.locator_id';
647: inv_mwb_query_manager.add_from_clause('mtl_item_locations mil', 'ONHAND');
648: inv_mwb_query_manager.add_where_clause(
649: 'mil.inventory_location_id = moqd.locator_id',
650: 'ONHAND'
651: );
652: inv_mwb_query_manager.add_where_clause(

Line 652: inv_mwb_query_manager.add_where_clause(

648: inv_mwb_query_manager.add_where_clause(
649: 'mil.inventory_location_id = moqd.locator_id',
650: 'ONHAND'
651: );
652: inv_mwb_query_manager.add_where_clause(
653: 'mil.subinventory_code = moqd.subinventory_code',
654: 'ONHAND'
655: );
656: inv_mwb_query_manager.add_where_clause(

Line 656: inv_mwb_query_manager.add_where_clause(

652: inv_mwb_query_manager.add_where_clause(
653: 'mil.subinventory_code = moqd.subinventory_code',
654: 'ONHAND'
655: );
656: inv_mwb_query_manager.add_where_clause(
657: 'mil.organization_id = moqd.organization_id',
658: 'ONHAND'
659: );
660: inv_mwb_query_manager.add_group_clause('moqd.locator_id', 'ONHAND');

Line 660: inv_mwb_query_manager.add_group_clause('moqd.locator_id', 'ONHAND');

656: inv_mwb_query_manager.add_where_clause(
657: 'mil.organization_id = moqd.organization_id',
658: 'ONHAND'
659: );
660: inv_mwb_query_manager.add_group_clause('moqd.locator_id', 'ONHAND');
661: inv_mwb_query_manager.add_qf_where_onhand('ONHAND');
662:
663: END IF;
664: inv_mwb_query_manager.add_where_clause(

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

657: 'mil.organization_id = moqd.organization_id',
658: 'ONHAND'
659: );
660: inv_mwb_query_manager.add_group_clause('moqd.locator_id', 'ONHAND');
661: inv_mwb_query_manager.add_qf_where_onhand('ONHAND');
662:
663: END IF;
664: inv_mwb_query_manager.add_where_clause(
665: 'mil.inventory_location_id = :onh_tree_locator_id',

Line 664: inv_mwb_query_manager.add_where_clause(

660: inv_mwb_query_manager.add_group_clause('moqd.locator_id', 'ONHAND');
661: inv_mwb_query_manager.add_qf_where_onhand('ONHAND');
662:
663: END IF;
664: inv_mwb_query_manager.add_where_clause(
665: 'mil.inventory_location_id = :onh_tree_locator_id',
666: 'ONHAND'
667: );
668: inv_mwb_query_manager.add_where_clause(

Line 668: inv_mwb_query_manager.add_where_clause(

664: inv_mwb_query_manager.add_where_clause(
665: 'mil.inventory_location_id = :onh_tree_locator_id',
666: 'ONHAND'
667: );
668: inv_mwb_query_manager.add_where_clause(
669: 'mil.organization_id = :onh_tree_organization_id',
670: 'ONHAND'
671: );
672: inv_mwb_query_manager.add_where_clause(

Line 672: inv_mwb_query_manager.add_where_clause(

668: inv_mwb_query_manager.add_where_clause(
669: 'mil.organization_id = :onh_tree_organization_id',
670: 'ONHAND'
671: );
672: inv_mwb_query_manager.add_where_clause(
673: 'mil.status_id = :onh_tree_status_id',
674: 'ONHAND'
675: );
676: inv_mwb_query_manager.add_bind_variable(

Line 676: inv_mwb_query_manager.add_bind_variable(

672: inv_mwb_query_manager.add_where_clause(
673: 'mil.status_id = :onh_tree_status_id',
674: 'ONHAND'
675: );
676: inv_mwb_query_manager.add_bind_variable(
677: 'onh_tree_status_id',
678: inv_mwb_globals.g_tree_st_id
679: );
680: inv_mwb_query_manager.add_bind_variable(

Line 680: inv_mwb_query_manager.add_bind_variable(

676: inv_mwb_query_manager.add_bind_variable(
677: 'onh_tree_status_id',
678: inv_mwb_globals.g_tree_st_id
679: );
680: inv_mwb_query_manager.add_bind_variable(
681: 'onh_tree_organization_id',
682: inv_mwb_globals.g_tree_organization_id
683: );
684: inv_mwb_query_manager.add_bind_variable(

Line 684: inv_mwb_query_manager.add_bind_variable(

680: inv_mwb_query_manager.add_bind_variable(
681: 'onh_tree_organization_id',
682: inv_mwb_globals.g_tree_organization_id
683: );
684: inv_mwb_query_manager.add_bind_variable(
685: 'onh_tree_locator_id',
686: inv_mwb_globals.g_tree_loc_id
687: );
688: inv_mwb_query_manager.execute_query;

Line 688: inv_mwb_query_manager.execute_query;

684: inv_mwb_query_manager.add_bind_variable(
685: 'onh_tree_locator_id',
686: inv_mwb_globals.g_tree_loc_id
687: );
688: inv_mwb_query_manager.execute_query;
689:
690: END IF;
691:
692: EXCEPTION

Line 718: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=

714: OR inv_mwb_globals.g_unit_number IS NOT NULL -- Bug 9486070
715: THEN
716:
717: make_common_queries('MSN_QUERY');
718: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
719: 'msn.lot_number';
720: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ITEM_ID).column_value :=
721: 'msn.inventory_item_id';
722:

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

716:
717: make_common_queries('MSN_QUERY');
718: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
719: 'msn.lot_number';
720: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ITEM_ID).column_value :=
721: 'msn.inventory_item_id';
722:
723: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=
724: 'msn.current_subinventory_code';--VARAJAGO

Line 723: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=

719: 'msn.lot_number';
720: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ITEM_ID).column_value :=
721: 'msn.inventory_item_id';
722:
723: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=
724: 'msn.current_subinventory_code';--VARAJAGO
725:
726: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=
727: 'msn.current_locator_id';--VARAJAGO

Line 726: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=

722:
723: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=
724: 'msn.current_subinventory_code';--VARAJAGO
725:
726: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=
727: 'msn.current_locator_id';--VARAJAGO
728:
729: inv_mwb_query_manager.add_from_clause('mtl_lot_numbers mln', 'ONHAND');
730: inv_mwb_query_manager.add_where_clause(

Line 729: inv_mwb_query_manager.add_from_clause('mtl_lot_numbers mln', 'ONHAND');

725:
726: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=
727: 'msn.current_locator_id';--VARAJAGO
728:
729: inv_mwb_query_manager.add_from_clause('mtl_lot_numbers mln', 'ONHAND');
730: inv_mwb_query_manager.add_where_clause(
731: 'mln.lot_number = msn.lot_number',
732: 'ONHAND'
733: );

Line 730: inv_mwb_query_manager.add_where_clause(

726: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=
727: 'msn.current_locator_id';--VARAJAGO
728:
729: inv_mwb_query_manager.add_from_clause('mtl_lot_numbers mln', 'ONHAND');
730: inv_mwb_query_manager.add_where_clause(
731: 'mln.lot_number = msn.lot_number',
732: 'ONHAND'
733: );
734: inv_mwb_query_manager.add_where_clause(

Line 734: inv_mwb_query_manager.add_where_clause(

730: inv_mwb_query_manager.add_where_clause(
731: 'mln.lot_number = msn.lot_number',
732: 'ONHAND'
733: );
734: inv_mwb_query_manager.add_where_clause(
735: 'mln.organization_id = msn.current_organization_id',
736: 'ONHAND'
737: );
738: inv_mwb_query_manager.add_where_clause(

Line 738: inv_mwb_query_manager.add_where_clause(

734: inv_mwb_query_manager.add_where_clause(
735: 'mln.organization_id = msn.current_organization_id',
736: 'ONHAND'
737: );
738: inv_mwb_query_manager.add_where_clause(
739: 'mln.inventory_item_id = msn.inventory_item_id',
740: 'ONHAND'
741: );
742: inv_mwb_query_manager.add_group_clause('msn.lot_number', 'ONHAND');

Line 742: inv_mwb_query_manager.add_group_clause('msn.lot_number', 'ONHAND');

738: inv_mwb_query_manager.add_where_clause(
739: 'mln.inventory_item_id = msn.inventory_item_id',
740: 'ONHAND'
741: );
742: inv_mwb_query_manager.add_group_clause('msn.lot_number', 'ONHAND');
743: inv_mwb_query_manager.add_group_clause('msn.inventory_item_id', 'ONHAND');
744: inv_mwb_query_manager.add_group_clause('msn.current_subinventory_code', 'ONHAND');--VARAJAGO
745: inv_mwb_query_manager.add_group_clause('msn.current_locator_id', 'ONHAND');--VARAJAGO
746:

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

739: 'mln.inventory_item_id = msn.inventory_item_id',
740: 'ONHAND'
741: );
742: inv_mwb_query_manager.add_group_clause('msn.lot_number', 'ONHAND');
743: inv_mwb_query_manager.add_group_clause('msn.inventory_item_id', 'ONHAND');
744: inv_mwb_query_manager.add_group_clause('msn.current_subinventory_code', 'ONHAND');--VARAJAGO
745: inv_mwb_query_manager.add_group_clause('msn.current_locator_id', 'ONHAND');--VARAJAGO
746:
747: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');

Line 744: inv_mwb_query_manager.add_group_clause('msn.current_subinventory_code', 'ONHAND');--VARAJAGO

740: 'ONHAND'
741: );
742: inv_mwb_query_manager.add_group_clause('msn.lot_number', 'ONHAND');
743: inv_mwb_query_manager.add_group_clause('msn.inventory_item_id', 'ONHAND');
744: inv_mwb_query_manager.add_group_clause('msn.current_subinventory_code', 'ONHAND');--VARAJAGO
745: inv_mwb_query_manager.add_group_clause('msn.current_locator_id', 'ONHAND');--VARAJAGO
746:
747: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
748:

Line 745: inv_mwb_query_manager.add_group_clause('msn.current_locator_id', 'ONHAND');--VARAJAGO

741: );
742: inv_mwb_query_manager.add_group_clause('msn.lot_number', 'ONHAND');
743: inv_mwb_query_manager.add_group_clause('msn.inventory_item_id', 'ONHAND');
744: inv_mwb_query_manager.add_group_clause('msn.current_subinventory_code', 'ONHAND');--VARAJAGO
745: inv_mwb_query_manager.add_group_clause('msn.current_locator_id', 'ONHAND');--VARAJAGO
746:
747: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
748:
749: ELSE

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

743: inv_mwb_query_manager.add_group_clause('msn.inventory_item_id', 'ONHAND');
744: inv_mwb_query_manager.add_group_clause('msn.current_subinventory_code', 'ONHAND');--VARAJAGO
745: inv_mwb_query_manager.add_group_clause('msn.current_locator_id', 'ONHAND');--VARAJAGO
746:
747: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
748:
749: ELSE
750: make_common_queries('MOQD');
751: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=

Line 751: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=

747: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
748:
749: ELSE
750: make_common_queries('MOQD');
751: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
752: 'moqd.lot_number';
753: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ITEM_ID).column_value :=
754: 'moqd.inventory_item_id';
755:

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

749: ELSE
750: make_common_queries('MOQD');
751: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
752: 'moqd.lot_number';
753: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ITEM_ID).column_value :=
754: 'moqd.inventory_item_id';
755:
756: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=
757: 'moqd.subinventory_code';--VARAJAGO

Line 756: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=

752: 'moqd.lot_number';
753: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ITEM_ID).column_value :=
754: 'moqd.inventory_item_id';
755:
756: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=
757: 'moqd.subinventory_code';--VARAJAGO
758:
759: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=
760: 'moqd.locator_id';--VARAJAGO

Line 759: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=

755:
756: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=
757: 'moqd.subinventory_code';--VARAJAGO
758:
759: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=
760: 'moqd.locator_id';--VARAJAGO
761:
762:
763: inv_mwb_query_manager.add_from_clause('mtl_lot_numbers mln', 'ONHAND');

Line 763: inv_mwb_query_manager.add_from_clause('mtl_lot_numbers mln', 'ONHAND');

759: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=
760: 'moqd.locator_id';--VARAJAGO
761:
762:
763: inv_mwb_query_manager.add_from_clause('mtl_lot_numbers mln', 'ONHAND');
764: inv_mwb_query_manager.add_where_clause(
765: 'mln.lot_number = moqd.lot_number',
766: 'ONHAND'
767: );

Line 764: inv_mwb_query_manager.add_where_clause(

760: 'moqd.locator_id';--VARAJAGO
761:
762:
763: inv_mwb_query_manager.add_from_clause('mtl_lot_numbers mln', 'ONHAND');
764: inv_mwb_query_manager.add_where_clause(
765: 'mln.lot_number = moqd.lot_number',
766: 'ONHAND'
767: );
768: inv_mwb_query_manager.add_where_clause(

Line 768: inv_mwb_query_manager.add_where_clause(

764: inv_mwb_query_manager.add_where_clause(
765: 'mln.lot_number = moqd.lot_number',
766: 'ONHAND'
767: );
768: inv_mwb_query_manager.add_where_clause(
769: 'mln.organization_id = moqd.organization_id',
770: 'ONHAND'
771: );
772: inv_mwb_query_manager.add_where_clause(

Line 772: inv_mwb_query_manager.add_where_clause(

768: inv_mwb_query_manager.add_where_clause(
769: 'mln.organization_id = moqd.organization_id',
770: 'ONHAND'
771: );
772: inv_mwb_query_manager.add_where_clause(
773: 'mln.inventory_item_id = moqd.inventory_item_id',
774: 'ONHAND'
775: );
776:

Line 777: inv_mwb_query_manager.add_group_clause('moqd.lot_number', 'ONHAND');

773: 'mln.inventory_item_id = moqd.inventory_item_id',
774: 'ONHAND'
775: );
776:
777: inv_mwb_query_manager.add_group_clause('moqd.lot_number', 'ONHAND');
778: inv_mwb_query_manager.add_group_clause('moqd.inventory_item_id', 'ONHAND');
779:
780: inv_mwb_query_manager.add_group_clause('moqd.subinventory_code', 'ONHAND');--VARAJAGO
781: inv_mwb_query_manager.add_group_clause('moqd.locator_id', 'ONHAND');--VARAJAGO

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

774: 'ONHAND'
775: );
776:
777: inv_mwb_query_manager.add_group_clause('moqd.lot_number', 'ONHAND');
778: inv_mwb_query_manager.add_group_clause('moqd.inventory_item_id', 'ONHAND');
779:
780: inv_mwb_query_manager.add_group_clause('moqd.subinventory_code', 'ONHAND');--VARAJAGO
781: inv_mwb_query_manager.add_group_clause('moqd.locator_id', 'ONHAND');--VARAJAGO
782:

Line 780: inv_mwb_query_manager.add_group_clause('moqd.subinventory_code', 'ONHAND');--VARAJAGO

776:
777: inv_mwb_query_manager.add_group_clause('moqd.lot_number', 'ONHAND');
778: inv_mwb_query_manager.add_group_clause('moqd.inventory_item_id', 'ONHAND');
779:
780: inv_mwb_query_manager.add_group_clause('moqd.subinventory_code', 'ONHAND');--VARAJAGO
781: inv_mwb_query_manager.add_group_clause('moqd.locator_id', 'ONHAND');--VARAJAGO
782:
783: inv_mwb_query_manager.add_qf_where_onhand('ONHAND');
784:

Line 781: inv_mwb_query_manager.add_group_clause('moqd.locator_id', 'ONHAND');--VARAJAGO

777: inv_mwb_query_manager.add_group_clause('moqd.lot_number', 'ONHAND');
778: inv_mwb_query_manager.add_group_clause('moqd.inventory_item_id', 'ONHAND');
779:
780: inv_mwb_query_manager.add_group_clause('moqd.subinventory_code', 'ONHAND');--VARAJAGO
781: inv_mwb_query_manager.add_group_clause('moqd.locator_id', 'ONHAND');--VARAJAGO
782:
783: inv_mwb_query_manager.add_qf_where_onhand('ONHAND');
784:
785: END IF;

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

779:
780: inv_mwb_query_manager.add_group_clause('moqd.subinventory_code', 'ONHAND');--VARAJAGO
781: inv_mwb_query_manager.add_group_clause('moqd.locator_id', 'ONHAND');--VARAJAGO
782:
783: inv_mwb_query_manager.add_qf_where_onhand('ONHAND');
784:
785: END IF;
786: inv_mwb_query_manager.add_where_clause(
787: 'mln.lot_number = :onh_tree_lot_number',

Line 786: inv_mwb_query_manager.add_where_clause(

782:
783: inv_mwb_query_manager.add_qf_where_onhand('ONHAND');
784:
785: END IF;
786: inv_mwb_query_manager.add_where_clause(
787: 'mln.lot_number = :onh_tree_lot_number',
788: 'ONHAND'
789: );
790: inv_mwb_query_manager.add_where_clause(

Line 790: inv_mwb_query_manager.add_where_clause(

786: inv_mwb_query_manager.add_where_clause(
787: 'mln.lot_number = :onh_tree_lot_number',
788: 'ONHAND'
789: );
790: inv_mwb_query_manager.add_where_clause(
791: 'mln.organization_id = :onh_tree_organization_id',
792: 'ONHAND'
793: );
794: inv_mwb_query_manager.add_where_clause(

Line 794: inv_mwb_query_manager.add_where_clause(

790: inv_mwb_query_manager.add_where_clause(
791: 'mln.organization_id = :onh_tree_organization_id',
792: 'ONHAND'
793: );
794: inv_mwb_query_manager.add_where_clause(
795: 'mln.status_id = :onh_tree_status_id',
796: 'ONHAND'
797: );
798: inv_mwb_query_manager.add_bind_variable(

Line 798: inv_mwb_query_manager.add_bind_variable(

794: inv_mwb_query_manager.add_where_clause(
795: 'mln.status_id = :onh_tree_status_id',
796: 'ONHAND'
797: );
798: inv_mwb_query_manager.add_bind_variable(
799: 'onh_tree_status_id',
800: inv_mwb_globals.g_tree_st_id
801: );
802: inv_mwb_query_manager.add_bind_variable(

Line 802: inv_mwb_query_manager.add_bind_variable(

798: inv_mwb_query_manager.add_bind_variable(
799: 'onh_tree_status_id',
800: inv_mwb_globals.g_tree_st_id
801: );
802: inv_mwb_query_manager.add_bind_variable(
803: 'onh_tree_organization_id',
804: inv_mwb_globals.g_tree_organization_id
805: );
806: inv_mwb_query_manager.add_bind_variable(

Line 806: inv_mwb_query_manager.add_bind_variable(

802: inv_mwb_query_manager.add_bind_variable(
803: 'onh_tree_organization_id',
804: inv_mwb_globals.g_tree_organization_id
805: );
806: inv_mwb_query_manager.add_bind_variable(
807: 'onh_tree_lot_number',
808: inv_mwb_globals.g_tree_lot_number
809: );
810: inv_mwb_query_manager.execute_query;

Line 810: inv_mwb_query_manager.execute_query;

806: inv_mwb_query_manager.add_bind_variable(
807: 'onh_tree_lot_number',
808: inv_mwb_globals.g_tree_lot_number
809: );
810: inv_mwb_query_manager.execute_query;
811:
812: END IF;
813:
814: EXCEPTION

Line 834: inv_mwb_query_manager.add_where_clause(

830:
831: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
832:
833: make_common_queries('MSN');
834: inv_mwb_query_manager.add_where_clause(
835: 'msn.current_organization_id = :onh_tree_organization_id',
836: 'ONHAND'
837: );
838: inv_mwb_query_manager.add_where_clause(

Line 838: inv_mwb_query_manager.add_where_clause(

834: inv_mwb_query_manager.add_where_clause(
835: 'msn.current_organization_id = :onh_tree_organization_id',
836: 'ONHAND'
837: );
838: inv_mwb_query_manager.add_where_clause(
839: 'msn.status_id = :onh_tree_status_id',
840: 'ONHAND'
841: );
842: inv_mwb_query_manager.add_where_clause(

Line 842: inv_mwb_query_manager.add_where_clause(

838: inv_mwb_query_manager.add_where_clause(
839: 'msn.status_id = :onh_tree_status_id',
840: 'ONHAND'
841: );
842: inv_mwb_query_manager.add_where_clause(
843: 'msn.serial_number = :onh_tree_serial_number',
844: 'ONHAND'
845: );
846: inv_mwb_query_manager.add_bind_variable(

Line 846: inv_mwb_query_manager.add_bind_variable(

842: inv_mwb_query_manager.add_where_clause(
843: 'msn.serial_number = :onh_tree_serial_number',
844: 'ONHAND'
845: );
846: inv_mwb_query_manager.add_bind_variable(
847: 'onh_tree_status_id',
848: inv_mwb_globals.g_tree_st_id
849: );
850: inv_mwb_query_manager.add_bind_variable(

Line 850: inv_mwb_query_manager.add_bind_variable(

846: inv_mwb_query_manager.add_bind_variable(
847: 'onh_tree_status_id',
848: inv_mwb_globals.g_tree_st_id
849: );
850: inv_mwb_query_manager.add_bind_variable(
851: 'onh_tree_organization_id',
852: inv_mwb_globals.g_tree_organization_id
853: );
854: inv_mwb_query_manager.add_bind_variable(

Line 854: inv_mwb_query_manager.add_bind_variable(

850: inv_mwb_query_manager.add_bind_variable(
851: 'onh_tree_organization_id',
852: inv_mwb_globals.g_tree_organization_id
853: );
854: inv_mwb_query_manager.add_bind_variable(
855: 'onh_tree_serial_number',
856: inv_mwb_globals.g_tree_serial_number
857: );
858: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');

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

854: inv_mwb_query_manager.add_bind_variable(
855: 'onh_tree_serial_number',
856: inv_mwb_globals.g_tree_serial_number
857: );
858: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
859: inv_mwb_query_manager.execute_query;
860:
861: END IF;
862:

Line 859: inv_mwb_query_manager.execute_query;

855: 'onh_tree_serial_number',
856: inv_mwb_globals.g_tree_serial_number
857: );
858: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
859: inv_mwb_query_manager.execute_query;
860:
861: END IF;
862:
863: EXCEPTION

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

872:
873: CASE p_flag
874: WHEN 'MOQD' THEN
875:
876: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ORG_ID).column_value :=
877: 'moqd.organization_id';
878:
879: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PRIMARY_UOM_CODE).column_value :=
880: 'moqd.transaction_uom_code';

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

875:
876: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ORG_ID).column_value :=
877: 'moqd.organization_id';
878:
879: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PRIMARY_UOM_CODE).column_value :=
880: 'moqd.transaction_uom_code';
881:
882: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ONHAND).column_value :=
883: 'SUM(moqd.primary_transaction_quantity)';

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

878:
879: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PRIMARY_UOM_CODE).column_value :=
880: 'moqd.transaction_uom_code';
881:
882: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ONHAND).column_value :=
883: 'SUM(moqd.primary_transaction_quantity)';
884:
885: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PACKED).column_value :=
886: 'SUM(DECODE(moqd.containerized_flag, 1, moqd.primary_transaction_quantity, 0))';

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

881:
882: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ONHAND).column_value :=
883: 'SUM(moqd.primary_transaction_quantity)';
884:
885: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PACKED).column_value :=
886: 'SUM(DECODE(moqd.containerized_flag, 1, moqd.primary_transaction_quantity, 0))';
887:
888: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.UNPACKED).column_value :=
889: 'SUM(DECODE(moqd.containerized_flag, 1, 0, moqd.primary_transaction_quantity))';

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

884:
885: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PACKED).column_value :=
886: 'SUM(DECODE(moqd.containerized_flag, 1, moqd.primary_transaction_quantity, 0))';
887:
888: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.UNPACKED).column_value :=
889: 'SUM(DECODE(moqd.containerized_flag, 1, 0, moqd.primary_transaction_quantity))';
890:
891: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SECONDARY_UOM_CODE).column_value :=
892: 'moqd.secondary_uom_code';

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

887:
888: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.UNPACKED).column_value :=
889: 'SUM(DECODE(moqd.containerized_flag, 1, 0, moqd.primary_transaction_quantity))';
890:
891: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SECONDARY_UOM_CODE).column_value :=
892: 'moqd.secondary_uom_code';
893:
894: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SECONDARY_ONHAND).column_value :=
895: 'SUM(moqd.secondary_transaction_quantity)';

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

890:
891: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SECONDARY_UOM_CODE).column_value :=
892: 'moqd.secondary_uom_code';
893:
894: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SECONDARY_ONHAND).column_value :=
895: 'SUM(moqd.secondary_transaction_quantity)';
896:
897: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SECONDARY_PACKED).column_value :=
898: 'SUM(DECODE(moqd.containerized_flag, 1, moqd.secondary_transaction_quantity, 0))';

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

893:
894: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SECONDARY_ONHAND).column_value :=
895: 'SUM(moqd.secondary_transaction_quantity)';
896:
897: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SECONDARY_PACKED).column_value :=
898: 'SUM(DECODE(moqd.containerized_flag, 1, moqd.secondary_transaction_quantity, 0))';
899:
900: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SECONDARY_UNPACKED).column_value :=
901: 'SUM(DECODE(moqd.containerized_flag, 1, 0, moqd.secondary_transaction_quantity))';

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

896:
897: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SECONDARY_PACKED).column_value :=
898: 'SUM(DECODE(moqd.containerized_flag, 1, moqd.secondary_transaction_quantity, 0))';
899:
900: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SECONDARY_UNPACKED).column_value :=
901: 'SUM(DECODE(moqd.containerized_flag, 1, 0, moqd.secondary_transaction_quantity))';
902:
903: inv_mwb_query_manager.add_from_clause('mtl_onhand_quantities_detail moqd', 'ONHAND');
904:

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

899:
900: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SECONDARY_UNPACKED).column_value :=
901: 'SUM(DECODE(moqd.containerized_flag, 1, 0, moqd.secondary_transaction_quantity))';
902:
903: inv_mwb_query_manager.add_from_clause('mtl_onhand_quantities_detail moqd', 'ONHAND');
904:
905: inv_mwb_query_manager.add_group_clause('moqd.organization_id', 'ONHAND');
906: inv_mwb_query_manager.add_group_clause('moqd.transaction_uom_code', 'ONHAND');
907: inv_mwb_query_manager.add_group_clause('moqd.secondary_uom_code', 'ONHAND');

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

901: 'SUM(DECODE(moqd.containerized_flag, 1, 0, moqd.secondary_transaction_quantity))';
902:
903: inv_mwb_query_manager.add_from_clause('mtl_onhand_quantities_detail moqd', 'ONHAND');
904:
905: inv_mwb_query_manager.add_group_clause('moqd.organization_id', 'ONHAND');
906: inv_mwb_query_manager.add_group_clause('moqd.transaction_uom_code', 'ONHAND');
907: inv_mwb_query_manager.add_group_clause('moqd.secondary_uom_code', 'ONHAND');
908:
909: WHEN 'MSN_QUERY' THEN

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

902:
903: inv_mwb_query_manager.add_from_clause('mtl_onhand_quantities_detail moqd', 'ONHAND');
904:
905: inv_mwb_query_manager.add_group_clause('moqd.organization_id', 'ONHAND');
906: inv_mwb_query_manager.add_group_clause('moqd.transaction_uom_code', 'ONHAND');
907: inv_mwb_query_manager.add_group_clause('moqd.secondary_uom_code', 'ONHAND');
908:
909: WHEN 'MSN_QUERY' THEN
910:

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

903: inv_mwb_query_manager.add_from_clause('mtl_onhand_quantities_detail moqd', 'ONHAND');
904:
905: inv_mwb_query_manager.add_group_clause('moqd.organization_id', 'ONHAND');
906: inv_mwb_query_manager.add_group_clause('moqd.transaction_uom_code', 'ONHAND');
907: inv_mwb_query_manager.add_group_clause('moqd.secondary_uom_code', 'ONHAND');
908:
909: WHEN 'MSN_QUERY' THEN
910:
911: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ORG_ID).column_value :=

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

907: inv_mwb_query_manager.add_group_clause('moqd.secondary_uom_code', 'ONHAND');
908:
909: WHEN 'MSN_QUERY' THEN
910:
911: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ORG_ID).column_value :=
912: 'msn.current_organization_id';
913:
914: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PRIMARY_UOM_CODE).column_value :=
915: '''Ea''';

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

910:
911: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ORG_ID).column_value :=
912: 'msn.current_organization_id';
913:
914: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PRIMARY_UOM_CODE).column_value :=
915: '''Ea''';
916:
917: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ONHAND).column_value := 1;
918:

Line 917: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ONHAND).column_value := 1;

913:
914: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PRIMARY_UOM_CODE).column_value :=
915: '''Ea''';
916:
917: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ONHAND).column_value := 1;
918:
919: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PACKED).column_value :=
920: 'SUM(DECODE(msn.lpn_id, NULL, 0,1))';
921:

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

915: '''Ea''';
916:
917: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ONHAND).column_value := 1;
918:
919: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PACKED).column_value :=
920: 'SUM(DECODE(msn.lpn_id, NULL, 0,1))';
921:
922: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.UNPACKED).column_value :=
923: 'SUM(DECODE(msn.lpn_id, NULL, 1,0))';

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

918:
919: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PACKED).column_value :=
920: 'SUM(DECODE(msn.lpn_id, NULL, 0,1))';
921:
922: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.UNPACKED).column_value :=
923: 'SUM(DECODE(msn.lpn_id, NULL, 1,0))';
924:
925: inv_mwb_query_manager.add_from_clause('mtl_serial_numbers msn', 'ONHAND');
926:

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

921:
922: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.UNPACKED).column_value :=
923: 'SUM(DECODE(msn.lpn_id, NULL, 1,0))';
924:
925: inv_mwb_query_manager.add_from_clause('mtl_serial_numbers msn', 'ONHAND');
926:
927: inv_mwb_query_manager.add_group_clause('msn.current_organization_id', 'ONHAND');
928: inv_mwb_query_manager.add_group_clause('''Ea''', 'ONHAND');
929:

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

923: 'SUM(DECODE(msn.lpn_id, NULL, 1,0))';
924:
925: inv_mwb_query_manager.add_from_clause('mtl_serial_numbers msn', 'ONHAND');
926:
927: inv_mwb_query_manager.add_group_clause('msn.current_organization_id', 'ONHAND');
928: inv_mwb_query_manager.add_group_clause('''Ea''', 'ONHAND');
929:
930:
931: WHEN 'MSN' THEN

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

924:
925: inv_mwb_query_manager.add_from_clause('mtl_serial_numbers msn', 'ONHAND');
926:
927: inv_mwb_query_manager.add_group_clause('msn.current_organization_id', 'ONHAND');
928: inv_mwb_query_manager.add_group_clause('''Ea''', 'ONHAND');
929:
930:
931: WHEN 'MSN' THEN
932:

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

929:
930:
931: WHEN 'MSN' THEN
932:
933: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ITEM_ID).column_value :=
934: 'msn.inventory_item_id';
935:
936: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=
937: 'msn.current_subinventory_code'; --VARAJAGO

Line 936: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=

932:
933: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ITEM_ID).column_value :=
934: 'msn.inventory_item_id';
935:
936: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=
937: 'msn.current_subinventory_code'; --VARAJAGO
938:
939: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=
940: 'msn.current_locator_id'; --VARAJAGO

Line 939: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=

935:
936: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=
937: 'msn.current_subinventory_code'; --VARAJAGO
938:
939: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=
940: 'msn.current_locator_id'; --VARAJAGO
941:
942: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ORG_ID).column_value :=
943: 'msn.current_organization_id';

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

938:
939: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=
940: 'msn.current_locator_id'; --VARAJAGO
941:
942: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ORG_ID).column_value :=
943: 'msn.current_organization_id';
944:
945: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PRIMARY_UOM_CODE).column_value :=
946: '''Ea''';

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

941:
942: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ORG_ID).column_value :=
943: 'msn.current_organization_id';
944:
945: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PRIMARY_UOM_CODE).column_value :=
946: '''Ea''';
947:
948: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ONHAND).column_value := 1;
949:

Line 948: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ONHAND).column_value := 1;

944:
945: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PRIMARY_UOM_CODE).column_value :=
946: '''Ea''';
947:
948: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ONHAND).column_value := 1;
949:
950: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PACKED).column_value :=
951: 'DECODE(msn.lpn_id, NULL, 0,1)';
952:

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

946: '''Ea''';
947:
948: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ONHAND).column_value := 1;
949:
950: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PACKED).column_value :=
951: 'DECODE(msn.lpn_id, NULL, 0,1)';
952:
953: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.UNPACKED).column_value :=
954: 'DECODE(msn.lpn_id, NULL, 1,0)';

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

949:
950: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PACKED).column_value :=
951: 'DECODE(msn.lpn_id, NULL, 0,1)';
952:
953: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.UNPACKED).column_value :=
954: 'DECODE(msn.lpn_id, NULL, 1,0)';
955:
956: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SERIAL).column_value :=
957: 'msn.serial_number';

Line 956: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SERIAL).column_value :=

952:
953: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.UNPACKED).column_value :=
954: 'DECODE(msn.lpn_id, NULL, 1,0)';
955:
956: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SERIAL).column_value :=
957: 'msn.serial_number';
958:
959: inv_mwb_query_manager.add_from_clause('mtl_serial_numbers msn', 'ONHAND');
960:

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

955:
956: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SERIAL).column_value :=
957: 'msn.serial_number';
958:
959: inv_mwb_query_manager.add_from_clause('mtl_serial_numbers msn', 'ONHAND');
960:
961: END CASE; -- p_flag
962:
963: END make_common_queries;