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 222: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=

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

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

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

Line 226: inv_mwb_query_manager.add_where_clause(

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

Line 230: inv_mwb_query_manager.add_where_clause(

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

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

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

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

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

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

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

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

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

Line 242: inv_mwb_query_manager.add_where_clause(

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

Line 246: inv_mwb_query_manager.add_where_clause(

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

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

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

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

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

Line 254: inv_mwb_query_manager.add_where_clause(

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

Line 258: inv_mwb_query_manager.add_where_clause(

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

Line 262: inv_mwb_query_manager.add_bind_variable(

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

Line 266: inv_mwb_query_manager.add_bind_variable(

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

Line 270: inv_mwb_query_manager.execute_query;

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

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

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

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

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

Line 309: inv_mwb_query_manager.add_where_clause(

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

Line 313: inv_mwb_query_manager.add_where_clause(

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

Line 317: inv_mwb_query_manager.add_where_clause(

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

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

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

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

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

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

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

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

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

Line 329: inv_mwb_query_manager.add_where_clause(

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

Line 333: inv_mwb_query_manager.add_where_clause(

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

Line 337: inv_mwb_query_manager.add_where_clause(

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

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

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

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

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

Line 345: inv_mwb_query_manager.add_where_clause(

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

Line 349: inv_mwb_query_manager.add_where_clause(

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

Line 353: inv_mwb_query_manager.add_bind_variable(

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

Line 357: inv_mwb_query_manager.add_bind_variable(

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

Line 361: inv_mwb_query_manager.execute_query;

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

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

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

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

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

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

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

Line 400: inv_mwb_query_manager.add_where_clause(

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

Line 404: inv_mwb_query_manager.add_where_clause(

400: inv_mwb_query_manager.add_where_clause(
401: 'mln.lot_number = msn.lot_number',
402: 'ONHAND'
403: );
404: inv_mwb_query_manager.add_where_clause(
405: 'mln.organization_id = msn.current_organization_id',
406: 'ONHAND'
407: );
408: inv_mwb_query_manager.add_where_clause(

Line 408: inv_mwb_query_manager.add_where_clause(

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 423: inv_mwb_query_manager.add_where_clause(

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

Line 427: inv_mwb_query_manager.add_where_clause(

423: inv_mwb_query_manager.add_where_clause(
424: 'mln.lot_number = moqd.lot_number',
425: 'ONHAND'
426: );
427: inv_mwb_query_manager.add_where_clause(
428: 'mln.organization_id = moqd.organization_id',
429: 'ONHAND'
430: );
431: inv_mwb_query_manager.add_where_clause(

Line 431: inv_mwb_query_manager.add_where_clause(

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

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

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

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

433: 'ONHAND'
434: );
435:
436: inv_mwb_query_manager.add_group_clause('moqd.lot_number', 'ONHAND');
437: inv_mwb_query_manager.add_group_clause('moqd.inventory_item_id', 'ONHAND');
438: inv_mwb_query_manager.add_qf_where_onhand('ONHAND');
439:
440: END IF;
441: inv_mwb_query_manager.add_where_clause(

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

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

Line 441: inv_mwb_query_manager.add_where_clause(

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

Line 445: inv_mwb_query_manager.add_where_clause(

441: inv_mwb_query_manager.add_where_clause(
442: 'mln.organization_id = :onh_tree_organization_id',
443: 'ONHAND'
444: );
445: inv_mwb_query_manager.add_where_clause(
446: 'mln.status_id = :onh_tree_status_id',
447: 'ONHAND'
448: );
449: inv_mwb_query_manager.add_bind_variable(

Line 449: inv_mwb_query_manager.add_bind_variable(

445: inv_mwb_query_manager.add_where_clause(
446: 'mln.status_id = :onh_tree_status_id',
447: 'ONHAND'
448: );
449: inv_mwb_query_manager.add_bind_variable(
450: 'onh_tree_status_id',
451: inv_mwb_globals.g_tree_st_id
452: );
453: inv_mwb_query_manager.add_bind_variable(

Line 453: inv_mwb_query_manager.add_bind_variable(

449: inv_mwb_query_manager.add_bind_variable(
450: 'onh_tree_status_id',
451: inv_mwb_globals.g_tree_st_id
452: );
453: inv_mwb_query_manager.add_bind_variable(
454: 'onh_tree_organization_id',
455: inv_mwb_globals.g_tree_organization_id
456: );
457: inv_mwb_query_manager.execute_query;

Line 457: inv_mwb_query_manager.execute_query;

453: inv_mwb_query_manager.add_bind_variable(
454: 'onh_tree_organization_id',
455: inv_mwb_globals.g_tree_organization_id
456: );
457: inv_mwb_query_manager.execute_query;
458:
459: END IF;
460:
461: EXCEPTION

Line 488: inv_mwb_query_manager.add_where_clause(

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

Line 492: inv_mwb_query_manager.add_where_clause(

488: inv_mwb_query_manager.add_where_clause(
489: 'msn.current_organization_id = :onh_tree_organization_id',
490: 'ONHAND'
491: );
492: inv_mwb_query_manager.add_where_clause(
493: 'msn.status_id = :onh_tree_status_id',
494: 'ONHAND'
495: );
496: inv_mwb_query_manager.add_bind_variable(

Line 496: inv_mwb_query_manager.add_bind_variable(

492: inv_mwb_query_manager.add_where_clause(
493: 'msn.status_id = :onh_tree_status_id',
494: 'ONHAND'
495: );
496: inv_mwb_query_manager.add_bind_variable(
497: 'onh_tree_status_id',
498: inv_mwb_globals.g_tree_st_id
499: );
500: inv_mwb_query_manager.add_bind_variable(

Line 500: inv_mwb_query_manager.add_bind_variable(

496: inv_mwb_query_manager.add_bind_variable(
497: 'onh_tree_status_id',
498: inv_mwb_globals.g_tree_st_id
499: );
500: inv_mwb_query_manager.add_bind_variable(
501: 'onh_tree_organization_id',
502: inv_mwb_globals.g_tree_organization_id
503: );
504: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');

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

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

Line 505: inv_mwb_query_manager.execute_query;

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

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

529: inv_mwb_globals.g_serial_to IS NOT NULL )
530: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL THEN -- Bug 6429880
531:
532: make_common_queries('MSN_QUERY');
533: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=
534: 'msn.current_subinventory_code';
535:
536: inv_mwb_query_manager.add_from_clause('mtl_secondary_inventories msi', 'ONHAND');
537: inv_mwb_query_manager.add_where_clause(

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

532: make_common_queries('MSN_QUERY');
533: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=
534: 'msn.current_subinventory_code';
535:
536: inv_mwb_query_manager.add_from_clause('mtl_secondary_inventories msi', 'ONHAND');
537: inv_mwb_query_manager.add_where_clause(
538: 'msi.secondary_inventory_name = msn.current_subinventory_code',
539: 'ONHAND'
540: );

Line 537: inv_mwb_query_manager.add_where_clause(

533: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=
534: 'msn.current_subinventory_code';
535:
536: inv_mwb_query_manager.add_from_clause('mtl_secondary_inventories msi', 'ONHAND');
537: inv_mwb_query_manager.add_where_clause(
538: 'msi.secondary_inventory_name = msn.current_subinventory_code',
539: 'ONHAND'
540: );
541: inv_mwb_query_manager.add_where_clause(

Line 541: inv_mwb_query_manager.add_where_clause(

537: inv_mwb_query_manager.add_where_clause(
538: 'msi.secondary_inventory_name = msn.current_subinventory_code',
539: 'ONHAND'
540: );
541: inv_mwb_query_manager.add_where_clause(
542: 'msi.organization_id = msn.current_organization_id',
543: 'ONHAND'
544: );
545: inv_mwb_query_manager.add_group_clause('msn.current_subinventory_code', 'ONHAND');

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

541: inv_mwb_query_manager.add_where_clause(
542: 'msi.organization_id = msn.current_organization_id',
543: 'ONHAND'
544: );
545: inv_mwb_query_manager.add_group_clause('msn.current_subinventory_code', 'ONHAND');
546: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
547:
548: ELSE
549: make_common_queries('MOQD');

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

542: 'msi.organization_id = msn.current_organization_id',
543: 'ONHAND'
544: );
545: inv_mwb_query_manager.add_group_clause('msn.current_subinventory_code', 'ONHAND');
546: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
547:
548: ELSE
549: make_common_queries('MOQD');
550: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=

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

546: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
547:
548: ELSE
549: make_common_queries('MOQD');
550: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=
551: 'moqd.subinventory_code';
552: inv_mwb_query_manager.add_from_clause('mtl_secondary_inventories msi', 'ONHAND');
553: inv_mwb_query_manager.add_where_clause(
554: 'msi.secondary_inventory_name = moqd.subinventory_code',

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

548: ELSE
549: make_common_queries('MOQD');
550: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=
551: 'moqd.subinventory_code';
552: inv_mwb_query_manager.add_from_clause('mtl_secondary_inventories msi', 'ONHAND');
553: inv_mwb_query_manager.add_where_clause(
554: 'msi.secondary_inventory_name = moqd.subinventory_code',
555: 'ONHAND'
556: );

Line 553: inv_mwb_query_manager.add_where_clause(

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

Line 557: inv_mwb_query_manager.add_where_clause(

553: inv_mwb_query_manager.add_where_clause(
554: 'msi.secondary_inventory_name = moqd.subinventory_code',
555: 'ONHAND'
556: );
557: inv_mwb_query_manager.add_where_clause(
558: 'msi.organization_id = moqd.organization_id',
559: 'ONHAND'
560: );
561: inv_mwb_query_manager.add_group_clause('moqd.subinventory_code', 'ONHAND');

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

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

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

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

Line 565: inv_mwb_query_manager.add_where_clause(

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

Line 569: inv_mwb_query_manager.add_where_clause(

565: inv_mwb_query_manager.add_where_clause(
566: 'msi.secondary_inventory_name = :onh_tree_subinventory_code',
567: 'ONHAND'
568: );
569: inv_mwb_query_manager.add_where_clause(
570: 'msi.organization_id = :onh_tree_organization_id',
571: 'ONHAND'
572: );
573: inv_mwb_query_manager.add_where_clause(

Line 573: inv_mwb_query_manager.add_where_clause(

569: inv_mwb_query_manager.add_where_clause(
570: 'msi.organization_id = :onh_tree_organization_id',
571: 'ONHAND'
572: );
573: inv_mwb_query_manager.add_where_clause(
574: 'msi.status_id = :onh_tree_status_id',
575: 'ONHAND'
576: );
577: inv_mwb_query_manager.add_bind_variable(

Line 577: inv_mwb_query_manager.add_bind_variable(

573: inv_mwb_query_manager.add_where_clause(
574: 'msi.status_id = :onh_tree_status_id',
575: 'ONHAND'
576: );
577: inv_mwb_query_manager.add_bind_variable(
578: 'onh_tree_status_id',
579: inv_mwb_globals.g_tree_st_id
580: );
581: inv_mwb_query_manager.add_bind_variable(

Line 581: inv_mwb_query_manager.add_bind_variable(

577: inv_mwb_query_manager.add_bind_variable(
578: 'onh_tree_status_id',
579: inv_mwb_globals.g_tree_st_id
580: );
581: inv_mwb_query_manager.add_bind_variable(
582: 'onh_tree_organization_id',
583: inv_mwb_globals.g_tree_organization_id
584: );
585: inv_mwb_query_manager.add_bind_variable(

Line 585: inv_mwb_query_manager.add_bind_variable(

581: inv_mwb_query_manager.add_bind_variable(
582: 'onh_tree_organization_id',
583: inv_mwb_globals.g_tree_organization_id
584: );
585: inv_mwb_query_manager.add_bind_variable(
586: 'onh_tree_subinventory_code',
587: inv_mwb_globals.g_tree_subinventory_code
588: );
589: inv_mwb_query_manager.execute_query;

Line 589: inv_mwb_query_manager.execute_query;

585: inv_mwb_query_manager.add_bind_variable(
586: 'onh_tree_subinventory_code',
587: inv_mwb_globals.g_tree_subinventory_code
588: );
589: inv_mwb_query_manager.execute_query;
590:
591: END IF;
592:
593: EXCEPTION

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

613: inv_mwb_globals.g_serial_to IS NOT NULL )
614: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL THEN -- Bug 6429880
615:
616: make_common_queries('MSN_QUERY');
617: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=
618: 'msn.current_locator_id';
619:
620: inv_mwb_query_manager.add_from_clause('mtl_item_locations mil', 'ONHAND');
621: inv_mwb_query_manager.add_where_clause(

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

616: make_common_queries('MSN_QUERY');
617: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=
618: 'msn.current_locator_id';
619:
620: inv_mwb_query_manager.add_from_clause('mtl_item_locations mil', 'ONHAND');
621: inv_mwb_query_manager.add_where_clause(
622: 'mil.inventory_location_id = msn.current_locator_id',
623: 'ONHAND'
624: );

Line 621: inv_mwb_query_manager.add_where_clause(

617: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=
618: 'msn.current_locator_id';
619:
620: inv_mwb_query_manager.add_from_clause('mtl_item_locations mil', 'ONHAND');
621: inv_mwb_query_manager.add_where_clause(
622: 'mil.inventory_location_id = msn.current_locator_id',
623: 'ONHAND'
624: );
625: inv_mwb_query_manager.add_where_clause(

Line 625: inv_mwb_query_manager.add_where_clause(

621: inv_mwb_query_manager.add_where_clause(
622: 'mil.inventory_location_id = msn.current_locator_id',
623: 'ONHAND'
624: );
625: inv_mwb_query_manager.add_where_clause(
626: 'mil.subinventory_code = msn.current_subinventory_code',
627: 'ONHAND'
628: );
629: inv_mwb_query_manager.add_where_clause(

Line 629: inv_mwb_query_manager.add_where_clause(

625: inv_mwb_query_manager.add_where_clause(
626: 'mil.subinventory_code = msn.current_subinventory_code',
627: 'ONHAND'
628: );
629: inv_mwb_query_manager.add_where_clause(
630: 'mil.organization_id = msn.current_organization_id',
631: 'ONHAND'
632: );
633: inv_mwb_query_manager.add_group_clause('msn.current_locator_id', 'ONHAND');

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

629: inv_mwb_query_manager.add_where_clause(
630: 'mil.organization_id = msn.current_organization_id',
631: 'ONHAND'
632: );
633: inv_mwb_query_manager.add_group_clause('msn.current_locator_id', 'ONHAND');
634: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
635:
636: ELSE
637: make_common_queries('MOQD');

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

630: 'mil.organization_id = msn.current_organization_id',
631: 'ONHAND'
632: );
633: inv_mwb_query_manager.add_group_clause('msn.current_locator_id', 'ONHAND');
634: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
635:
636: ELSE
637: make_common_queries('MOQD');
638: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=

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

634: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
635:
636: ELSE
637: make_common_queries('MOQD');
638: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=
639: 'moqd.locator_id';
640: inv_mwb_query_manager.add_from_clause('mtl_item_locations mil', 'ONHAND');
641: inv_mwb_query_manager.add_where_clause(
642: 'mil.inventory_location_id = moqd.locator_id',

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

636: ELSE
637: make_common_queries('MOQD');
638: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=
639: 'moqd.locator_id';
640: inv_mwb_query_manager.add_from_clause('mtl_item_locations mil', 'ONHAND');
641: inv_mwb_query_manager.add_where_clause(
642: 'mil.inventory_location_id = moqd.locator_id',
643: 'ONHAND'
644: );

Line 641: inv_mwb_query_manager.add_where_clause(

637: make_common_queries('MOQD');
638: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=
639: 'moqd.locator_id';
640: inv_mwb_query_manager.add_from_clause('mtl_item_locations mil', 'ONHAND');
641: inv_mwb_query_manager.add_where_clause(
642: 'mil.inventory_location_id = moqd.locator_id',
643: 'ONHAND'
644: );
645: inv_mwb_query_manager.add_where_clause(

Line 645: inv_mwb_query_manager.add_where_clause(

641: inv_mwb_query_manager.add_where_clause(
642: 'mil.inventory_location_id = moqd.locator_id',
643: 'ONHAND'
644: );
645: inv_mwb_query_manager.add_where_clause(
646: 'mil.subinventory_code = moqd.subinventory_code',
647: 'ONHAND'
648: );
649: inv_mwb_query_manager.add_where_clause(

Line 649: inv_mwb_query_manager.add_where_clause(

645: inv_mwb_query_manager.add_where_clause(
646: 'mil.subinventory_code = moqd.subinventory_code',
647: 'ONHAND'
648: );
649: inv_mwb_query_manager.add_where_clause(
650: 'mil.organization_id = moqd.organization_id',
651: 'ONHAND'
652: );
653: inv_mwb_query_manager.add_group_clause('moqd.locator_id', 'ONHAND');

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

649: inv_mwb_query_manager.add_where_clause(
650: 'mil.organization_id = moqd.organization_id',
651: 'ONHAND'
652: );
653: inv_mwb_query_manager.add_group_clause('moqd.locator_id', 'ONHAND');
654: inv_mwb_query_manager.add_qf_where_onhand('ONHAND');
655:
656: END IF;
657: inv_mwb_query_manager.add_where_clause(

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

650: 'mil.organization_id = moqd.organization_id',
651: 'ONHAND'
652: );
653: inv_mwb_query_manager.add_group_clause('moqd.locator_id', 'ONHAND');
654: inv_mwb_query_manager.add_qf_where_onhand('ONHAND');
655:
656: END IF;
657: inv_mwb_query_manager.add_where_clause(
658: 'mil.inventory_location_id = :onh_tree_locator_id',

Line 657: inv_mwb_query_manager.add_where_clause(

653: inv_mwb_query_manager.add_group_clause('moqd.locator_id', 'ONHAND');
654: inv_mwb_query_manager.add_qf_where_onhand('ONHAND');
655:
656: END IF;
657: inv_mwb_query_manager.add_where_clause(
658: 'mil.inventory_location_id = :onh_tree_locator_id',
659: 'ONHAND'
660: );
661: inv_mwb_query_manager.add_where_clause(

Line 661: inv_mwb_query_manager.add_where_clause(

657: inv_mwb_query_manager.add_where_clause(
658: 'mil.inventory_location_id = :onh_tree_locator_id',
659: 'ONHAND'
660: );
661: inv_mwb_query_manager.add_where_clause(
662: 'mil.organization_id = :onh_tree_organization_id',
663: 'ONHAND'
664: );
665: inv_mwb_query_manager.add_where_clause(

Line 665: inv_mwb_query_manager.add_where_clause(

661: inv_mwb_query_manager.add_where_clause(
662: 'mil.organization_id = :onh_tree_organization_id',
663: 'ONHAND'
664: );
665: inv_mwb_query_manager.add_where_clause(
666: 'mil.status_id = :onh_tree_status_id',
667: 'ONHAND'
668: );
669: inv_mwb_query_manager.add_bind_variable(

Line 669: inv_mwb_query_manager.add_bind_variable(

665: inv_mwb_query_manager.add_where_clause(
666: 'mil.status_id = :onh_tree_status_id',
667: 'ONHAND'
668: );
669: inv_mwb_query_manager.add_bind_variable(
670: 'onh_tree_status_id',
671: inv_mwb_globals.g_tree_st_id
672: );
673: inv_mwb_query_manager.add_bind_variable(

Line 673: inv_mwb_query_manager.add_bind_variable(

669: inv_mwb_query_manager.add_bind_variable(
670: 'onh_tree_status_id',
671: inv_mwb_globals.g_tree_st_id
672: );
673: inv_mwb_query_manager.add_bind_variable(
674: 'onh_tree_organization_id',
675: inv_mwb_globals.g_tree_organization_id
676: );
677: inv_mwb_query_manager.add_bind_variable(

Line 677: inv_mwb_query_manager.add_bind_variable(

673: inv_mwb_query_manager.add_bind_variable(
674: 'onh_tree_organization_id',
675: inv_mwb_globals.g_tree_organization_id
676: );
677: inv_mwb_query_manager.add_bind_variable(
678: 'onh_tree_locator_id',
679: inv_mwb_globals.g_tree_loc_id
680: );
681: inv_mwb_query_manager.execute_query;

Line 681: inv_mwb_query_manager.execute_query;

677: inv_mwb_query_manager.add_bind_variable(
678: 'onh_tree_locator_id',
679: inv_mwb_globals.g_tree_loc_id
680: );
681: inv_mwb_query_manager.execute_query;
682:
683: END IF;
684:
685: EXCEPTION

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

705: inv_mwb_globals.g_serial_to IS NOT NULL )
706: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL THEN -- Bug 6429880
707:
708: make_common_queries('MSN_QUERY');
709: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
710: 'msn.lot_number';
711: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ITEM_ID).column_value :=
712: 'msn.inventory_item_id';
713:

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

707:
708: make_common_queries('MSN_QUERY');
709: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
710: 'msn.lot_number';
711: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ITEM_ID).column_value :=
712: 'msn.inventory_item_id';
713:
714: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=
715: 'msn.current_subinventory_code';--VARAJAGO

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

710: 'msn.lot_number';
711: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ITEM_ID).column_value :=
712: 'msn.inventory_item_id';
713:
714: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=
715: 'msn.current_subinventory_code';--VARAJAGO
716:
717: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=
718: 'msn.current_locator_id';--VARAJAGO

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

713:
714: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=
715: 'msn.current_subinventory_code';--VARAJAGO
716:
717: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=
718: 'msn.current_locator_id';--VARAJAGO
719:
720: inv_mwb_query_manager.add_from_clause('mtl_lot_numbers mln', 'ONHAND');
721: inv_mwb_query_manager.add_where_clause(

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

716:
717: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=
718: 'msn.current_locator_id';--VARAJAGO
719:
720: inv_mwb_query_manager.add_from_clause('mtl_lot_numbers mln', 'ONHAND');
721: inv_mwb_query_manager.add_where_clause(
722: 'mln.lot_number = msn.lot_number',
723: 'ONHAND'
724: );

Line 721: inv_mwb_query_manager.add_where_clause(

717: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=
718: 'msn.current_locator_id';--VARAJAGO
719:
720: inv_mwb_query_manager.add_from_clause('mtl_lot_numbers mln', 'ONHAND');
721: inv_mwb_query_manager.add_where_clause(
722: 'mln.lot_number = msn.lot_number',
723: 'ONHAND'
724: );
725: inv_mwb_query_manager.add_where_clause(

Line 725: inv_mwb_query_manager.add_where_clause(

721: inv_mwb_query_manager.add_where_clause(
722: 'mln.lot_number = msn.lot_number',
723: 'ONHAND'
724: );
725: inv_mwb_query_manager.add_where_clause(
726: 'mln.organization_id = msn.current_organization_id',
727: 'ONHAND'
728: );
729: inv_mwb_query_manager.add_where_clause(

Line 729: inv_mwb_query_manager.add_where_clause(

725: inv_mwb_query_manager.add_where_clause(
726: 'mln.organization_id = msn.current_organization_id',
727: 'ONHAND'
728: );
729: inv_mwb_query_manager.add_where_clause(
730: 'mln.inventory_item_id = msn.inventory_item_id',
731: 'ONHAND'
732: );
733: inv_mwb_query_manager.add_group_clause('msn.lot_number', 'ONHAND');

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

729: inv_mwb_query_manager.add_where_clause(
730: 'mln.inventory_item_id = msn.inventory_item_id',
731: 'ONHAND'
732: );
733: inv_mwb_query_manager.add_group_clause('msn.lot_number', 'ONHAND');
734: inv_mwb_query_manager.add_group_clause('msn.inventory_item_id', 'ONHAND');
735: inv_mwb_query_manager.add_group_clause('msn.current_subinventory_code', 'ONHAND');--VARAJAGO
736: inv_mwb_query_manager.add_group_clause('msn.current_locator_id', 'ONHAND');--VARAJAGO
737:

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

730: 'mln.inventory_item_id = msn.inventory_item_id',
731: 'ONHAND'
732: );
733: inv_mwb_query_manager.add_group_clause('msn.lot_number', 'ONHAND');
734: inv_mwb_query_manager.add_group_clause('msn.inventory_item_id', 'ONHAND');
735: inv_mwb_query_manager.add_group_clause('msn.current_subinventory_code', 'ONHAND');--VARAJAGO
736: inv_mwb_query_manager.add_group_clause('msn.current_locator_id', 'ONHAND');--VARAJAGO
737:
738: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');

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

731: 'ONHAND'
732: );
733: inv_mwb_query_manager.add_group_clause('msn.lot_number', 'ONHAND');
734: inv_mwb_query_manager.add_group_clause('msn.inventory_item_id', 'ONHAND');
735: inv_mwb_query_manager.add_group_clause('msn.current_subinventory_code', 'ONHAND');--VARAJAGO
736: inv_mwb_query_manager.add_group_clause('msn.current_locator_id', 'ONHAND');--VARAJAGO
737:
738: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
739:

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

732: );
733: inv_mwb_query_manager.add_group_clause('msn.lot_number', 'ONHAND');
734: inv_mwb_query_manager.add_group_clause('msn.inventory_item_id', 'ONHAND');
735: inv_mwb_query_manager.add_group_clause('msn.current_subinventory_code', 'ONHAND');--VARAJAGO
736: inv_mwb_query_manager.add_group_clause('msn.current_locator_id', 'ONHAND');--VARAJAGO
737:
738: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
739:
740: ELSE

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

734: inv_mwb_query_manager.add_group_clause('msn.inventory_item_id', 'ONHAND');
735: inv_mwb_query_manager.add_group_clause('msn.current_subinventory_code', 'ONHAND');--VARAJAGO
736: inv_mwb_query_manager.add_group_clause('msn.current_locator_id', 'ONHAND');--VARAJAGO
737:
738: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
739:
740: ELSE
741: make_common_queries('MOQD');
742: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=

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

738: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
739:
740: ELSE
741: make_common_queries('MOQD');
742: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
743: 'moqd.lot_number';
744: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ITEM_ID).column_value :=
745: 'moqd.inventory_item_id';
746:

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

740: ELSE
741: make_common_queries('MOQD');
742: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
743: 'moqd.lot_number';
744: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ITEM_ID).column_value :=
745: 'moqd.inventory_item_id';
746:
747: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=
748: 'moqd.subinventory_code';--VARAJAGO

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

743: 'moqd.lot_number';
744: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ITEM_ID).column_value :=
745: 'moqd.inventory_item_id';
746:
747: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=
748: 'moqd.subinventory_code';--VARAJAGO
749:
750: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=
751: 'moqd.locator_id';--VARAJAGO

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

746:
747: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=
748: 'moqd.subinventory_code';--VARAJAGO
749:
750: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=
751: 'moqd.locator_id';--VARAJAGO
752:
753:
754: inv_mwb_query_manager.add_from_clause('mtl_lot_numbers mln', 'ONHAND');

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

750: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=
751: 'moqd.locator_id';--VARAJAGO
752:
753:
754: inv_mwb_query_manager.add_from_clause('mtl_lot_numbers mln', 'ONHAND');
755: inv_mwb_query_manager.add_where_clause(
756: 'mln.lot_number = moqd.lot_number',
757: 'ONHAND'
758: );

Line 755: inv_mwb_query_manager.add_where_clause(

751: 'moqd.locator_id';--VARAJAGO
752:
753:
754: inv_mwb_query_manager.add_from_clause('mtl_lot_numbers mln', 'ONHAND');
755: inv_mwb_query_manager.add_where_clause(
756: 'mln.lot_number = moqd.lot_number',
757: 'ONHAND'
758: );
759: inv_mwb_query_manager.add_where_clause(

Line 759: inv_mwb_query_manager.add_where_clause(

755: inv_mwb_query_manager.add_where_clause(
756: 'mln.lot_number = moqd.lot_number',
757: 'ONHAND'
758: );
759: inv_mwb_query_manager.add_where_clause(
760: 'mln.organization_id = moqd.organization_id',
761: 'ONHAND'
762: );
763: inv_mwb_query_manager.add_where_clause(

Line 763: inv_mwb_query_manager.add_where_clause(

759: inv_mwb_query_manager.add_where_clause(
760: 'mln.organization_id = moqd.organization_id',
761: 'ONHAND'
762: );
763: inv_mwb_query_manager.add_where_clause(
764: 'mln.inventory_item_id = moqd.inventory_item_id',
765: 'ONHAND'
766: );
767:

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

764: 'mln.inventory_item_id = moqd.inventory_item_id',
765: 'ONHAND'
766: );
767:
768: inv_mwb_query_manager.add_group_clause('moqd.lot_number', 'ONHAND');
769: inv_mwb_query_manager.add_group_clause('moqd.inventory_item_id', 'ONHAND');
770:
771: inv_mwb_query_manager.add_group_clause('moqd.subinventory_code', 'ONHAND');--VARAJAGO
772: inv_mwb_query_manager.add_group_clause('moqd.locator_id', 'ONHAND');--VARAJAGO

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

765: 'ONHAND'
766: );
767:
768: inv_mwb_query_manager.add_group_clause('moqd.lot_number', 'ONHAND');
769: inv_mwb_query_manager.add_group_clause('moqd.inventory_item_id', 'ONHAND');
770:
771: inv_mwb_query_manager.add_group_clause('moqd.subinventory_code', 'ONHAND');--VARAJAGO
772: inv_mwb_query_manager.add_group_clause('moqd.locator_id', 'ONHAND');--VARAJAGO
773:

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

767:
768: inv_mwb_query_manager.add_group_clause('moqd.lot_number', 'ONHAND');
769: inv_mwb_query_manager.add_group_clause('moqd.inventory_item_id', 'ONHAND');
770:
771: inv_mwb_query_manager.add_group_clause('moqd.subinventory_code', 'ONHAND');--VARAJAGO
772: inv_mwb_query_manager.add_group_clause('moqd.locator_id', 'ONHAND');--VARAJAGO
773:
774: inv_mwb_query_manager.add_qf_where_onhand('ONHAND');
775:

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

768: inv_mwb_query_manager.add_group_clause('moqd.lot_number', 'ONHAND');
769: inv_mwb_query_manager.add_group_clause('moqd.inventory_item_id', 'ONHAND');
770:
771: inv_mwb_query_manager.add_group_clause('moqd.subinventory_code', 'ONHAND');--VARAJAGO
772: inv_mwb_query_manager.add_group_clause('moqd.locator_id', 'ONHAND');--VARAJAGO
773:
774: inv_mwb_query_manager.add_qf_where_onhand('ONHAND');
775:
776: END IF;

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

770:
771: inv_mwb_query_manager.add_group_clause('moqd.subinventory_code', 'ONHAND');--VARAJAGO
772: inv_mwb_query_manager.add_group_clause('moqd.locator_id', 'ONHAND');--VARAJAGO
773:
774: inv_mwb_query_manager.add_qf_where_onhand('ONHAND');
775:
776: END IF;
777: inv_mwb_query_manager.add_where_clause(
778: 'mln.lot_number = :onh_tree_lot_number',

Line 777: inv_mwb_query_manager.add_where_clause(

773:
774: inv_mwb_query_manager.add_qf_where_onhand('ONHAND');
775:
776: END IF;
777: inv_mwb_query_manager.add_where_clause(
778: 'mln.lot_number = :onh_tree_lot_number',
779: 'ONHAND'
780: );
781: inv_mwb_query_manager.add_where_clause(

Line 781: inv_mwb_query_manager.add_where_clause(

777: inv_mwb_query_manager.add_where_clause(
778: 'mln.lot_number = :onh_tree_lot_number',
779: 'ONHAND'
780: );
781: inv_mwb_query_manager.add_where_clause(
782: 'mln.organization_id = :onh_tree_organization_id',
783: 'ONHAND'
784: );
785: inv_mwb_query_manager.add_where_clause(

Line 785: inv_mwb_query_manager.add_where_clause(

781: inv_mwb_query_manager.add_where_clause(
782: 'mln.organization_id = :onh_tree_organization_id',
783: 'ONHAND'
784: );
785: inv_mwb_query_manager.add_where_clause(
786: 'mln.status_id = :onh_tree_status_id',
787: 'ONHAND'
788: );
789: inv_mwb_query_manager.add_bind_variable(

Line 789: inv_mwb_query_manager.add_bind_variable(

785: inv_mwb_query_manager.add_where_clause(
786: 'mln.status_id = :onh_tree_status_id',
787: 'ONHAND'
788: );
789: inv_mwb_query_manager.add_bind_variable(
790: 'onh_tree_status_id',
791: inv_mwb_globals.g_tree_st_id
792: );
793: inv_mwb_query_manager.add_bind_variable(

Line 793: inv_mwb_query_manager.add_bind_variable(

789: inv_mwb_query_manager.add_bind_variable(
790: 'onh_tree_status_id',
791: inv_mwb_globals.g_tree_st_id
792: );
793: inv_mwb_query_manager.add_bind_variable(
794: 'onh_tree_organization_id',
795: inv_mwb_globals.g_tree_organization_id
796: );
797: inv_mwb_query_manager.add_bind_variable(

Line 797: inv_mwb_query_manager.add_bind_variable(

793: inv_mwb_query_manager.add_bind_variable(
794: 'onh_tree_organization_id',
795: inv_mwb_globals.g_tree_organization_id
796: );
797: inv_mwb_query_manager.add_bind_variable(
798: 'onh_tree_lot_number',
799: inv_mwb_globals.g_tree_lot_number
800: );
801: inv_mwb_query_manager.execute_query;

Line 801: inv_mwb_query_manager.execute_query;

797: inv_mwb_query_manager.add_bind_variable(
798: 'onh_tree_lot_number',
799: inv_mwb_globals.g_tree_lot_number
800: );
801: inv_mwb_query_manager.execute_query;
802:
803: END IF;
804:
805: EXCEPTION

Line 825: inv_mwb_query_manager.add_where_clause(

821:
822: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
823:
824: make_common_queries('MSN');
825: inv_mwb_query_manager.add_where_clause(
826: 'msn.current_organization_id = :onh_tree_organization_id',
827: 'ONHAND'
828: );
829: inv_mwb_query_manager.add_where_clause(

Line 829: inv_mwb_query_manager.add_where_clause(

825: inv_mwb_query_manager.add_where_clause(
826: 'msn.current_organization_id = :onh_tree_organization_id',
827: 'ONHAND'
828: );
829: inv_mwb_query_manager.add_where_clause(
830: 'msn.status_id = :onh_tree_status_id',
831: 'ONHAND'
832: );
833: inv_mwb_query_manager.add_where_clause(

Line 833: inv_mwb_query_manager.add_where_clause(

829: inv_mwb_query_manager.add_where_clause(
830: 'msn.status_id = :onh_tree_status_id',
831: 'ONHAND'
832: );
833: inv_mwb_query_manager.add_where_clause(
834: 'msn.serial_number = :onh_tree_serial_number',
835: 'ONHAND'
836: );
837: inv_mwb_query_manager.add_bind_variable(

Line 837: inv_mwb_query_manager.add_bind_variable(

833: inv_mwb_query_manager.add_where_clause(
834: 'msn.serial_number = :onh_tree_serial_number',
835: 'ONHAND'
836: );
837: inv_mwb_query_manager.add_bind_variable(
838: 'onh_tree_status_id',
839: inv_mwb_globals.g_tree_st_id
840: );
841: inv_mwb_query_manager.add_bind_variable(

Line 841: inv_mwb_query_manager.add_bind_variable(

837: inv_mwb_query_manager.add_bind_variable(
838: 'onh_tree_status_id',
839: inv_mwb_globals.g_tree_st_id
840: );
841: inv_mwb_query_manager.add_bind_variable(
842: 'onh_tree_organization_id',
843: inv_mwb_globals.g_tree_organization_id
844: );
845: inv_mwb_query_manager.add_bind_variable(

Line 845: inv_mwb_query_manager.add_bind_variable(

841: inv_mwb_query_manager.add_bind_variable(
842: 'onh_tree_organization_id',
843: inv_mwb_globals.g_tree_organization_id
844: );
845: inv_mwb_query_manager.add_bind_variable(
846: 'onh_tree_serial_number',
847: inv_mwb_globals.g_tree_serial_number
848: );
849: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');

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

845: inv_mwb_query_manager.add_bind_variable(
846: 'onh_tree_serial_number',
847: inv_mwb_globals.g_tree_serial_number
848: );
849: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
850: inv_mwb_query_manager.execute_query;
851:
852: END IF;
853:

Line 850: inv_mwb_query_manager.execute_query;

846: 'onh_tree_serial_number',
847: inv_mwb_globals.g_tree_serial_number
848: );
849: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
850: inv_mwb_query_manager.execute_query;
851:
852: END IF;
853:
854: EXCEPTION

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

863:
864: CASE p_flag
865: WHEN 'MOQD' THEN
866:
867: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ORG_ID).column_value :=
868: 'moqd.organization_id';
869:
870: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PRIMARY_UOM_CODE).column_value :=
871: 'moqd.transaction_uom_code';

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

866:
867: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ORG_ID).column_value :=
868: 'moqd.organization_id';
869:
870: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PRIMARY_UOM_CODE).column_value :=
871: 'moqd.transaction_uom_code';
872:
873: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ONHAND).column_value :=
874: 'SUM(moqd.primary_transaction_quantity)';

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

869:
870: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PRIMARY_UOM_CODE).column_value :=
871: 'moqd.transaction_uom_code';
872:
873: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ONHAND).column_value :=
874: 'SUM(moqd.primary_transaction_quantity)';
875:
876: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PACKED).column_value :=
877: 'SUM(DECODE(moqd.containerized_flag, 1, moqd.primary_transaction_quantity, 0))';

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

872:
873: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ONHAND).column_value :=
874: 'SUM(moqd.primary_transaction_quantity)';
875:
876: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PACKED).column_value :=
877: 'SUM(DECODE(moqd.containerized_flag, 1, moqd.primary_transaction_quantity, 0))';
878:
879: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.UNPACKED).column_value :=
880: 'SUM(DECODE(moqd.containerized_flag, 1, 0, moqd.primary_transaction_quantity))';

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

875:
876: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PACKED).column_value :=
877: 'SUM(DECODE(moqd.containerized_flag, 1, moqd.primary_transaction_quantity, 0))';
878:
879: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.UNPACKED).column_value :=
880: 'SUM(DECODE(moqd.containerized_flag, 1, 0, moqd.primary_transaction_quantity))';
881:
882: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SECONDARY_UOM_CODE).column_value :=
883: 'moqd.secondary_uom_code';

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

878:
879: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.UNPACKED).column_value :=
880: 'SUM(DECODE(moqd.containerized_flag, 1, 0, moqd.primary_transaction_quantity))';
881:
882: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SECONDARY_UOM_CODE).column_value :=
883: 'moqd.secondary_uom_code';
884:
885: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SECONDARY_ONHAND).column_value :=
886: 'SUM(moqd.secondary_transaction_quantity)';

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

881:
882: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SECONDARY_UOM_CODE).column_value :=
883: 'moqd.secondary_uom_code';
884:
885: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SECONDARY_ONHAND).column_value :=
886: 'SUM(moqd.secondary_transaction_quantity)';
887:
888: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SECONDARY_PACKED).column_value :=
889: 'SUM(DECODE(moqd.containerized_flag, 1, moqd.secondary_transaction_quantity, 0))';

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

884:
885: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SECONDARY_ONHAND).column_value :=
886: 'SUM(moqd.secondary_transaction_quantity)';
887:
888: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SECONDARY_PACKED).column_value :=
889: 'SUM(DECODE(moqd.containerized_flag, 1, moqd.secondary_transaction_quantity, 0))';
890:
891: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SECONDARY_UNPACKED).column_value :=
892: 'SUM(DECODE(moqd.containerized_flag, 1, 0, moqd.secondary_transaction_quantity))';

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

887:
888: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SECONDARY_PACKED).column_value :=
889: 'SUM(DECODE(moqd.containerized_flag, 1, moqd.secondary_transaction_quantity, 0))';
890:
891: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SECONDARY_UNPACKED).column_value :=
892: 'SUM(DECODE(moqd.containerized_flag, 1, 0, moqd.secondary_transaction_quantity))';
893:
894: inv_mwb_query_manager.add_from_clause('mtl_onhand_quantities_detail moqd', 'ONHAND');
895:

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

890:
891: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SECONDARY_UNPACKED).column_value :=
892: 'SUM(DECODE(moqd.containerized_flag, 1, 0, moqd.secondary_transaction_quantity))';
893:
894: inv_mwb_query_manager.add_from_clause('mtl_onhand_quantities_detail moqd', 'ONHAND');
895:
896: inv_mwb_query_manager.add_group_clause('moqd.organization_id', 'ONHAND');
897: inv_mwb_query_manager.add_group_clause('moqd.transaction_uom_code', 'ONHAND');
898: inv_mwb_query_manager.add_group_clause('moqd.secondary_uom_code', 'ONHAND');

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

892: 'SUM(DECODE(moqd.containerized_flag, 1, 0, moqd.secondary_transaction_quantity))';
893:
894: inv_mwb_query_manager.add_from_clause('mtl_onhand_quantities_detail moqd', 'ONHAND');
895:
896: inv_mwb_query_manager.add_group_clause('moqd.organization_id', 'ONHAND');
897: inv_mwb_query_manager.add_group_clause('moqd.transaction_uom_code', 'ONHAND');
898: inv_mwb_query_manager.add_group_clause('moqd.secondary_uom_code', 'ONHAND');
899:
900: WHEN 'MSN_QUERY' THEN

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

893:
894: inv_mwb_query_manager.add_from_clause('mtl_onhand_quantities_detail moqd', 'ONHAND');
895:
896: inv_mwb_query_manager.add_group_clause('moqd.organization_id', 'ONHAND');
897: inv_mwb_query_manager.add_group_clause('moqd.transaction_uom_code', 'ONHAND');
898: inv_mwb_query_manager.add_group_clause('moqd.secondary_uom_code', 'ONHAND');
899:
900: WHEN 'MSN_QUERY' THEN
901:

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

894: inv_mwb_query_manager.add_from_clause('mtl_onhand_quantities_detail moqd', 'ONHAND');
895:
896: inv_mwb_query_manager.add_group_clause('moqd.organization_id', 'ONHAND');
897: inv_mwb_query_manager.add_group_clause('moqd.transaction_uom_code', 'ONHAND');
898: inv_mwb_query_manager.add_group_clause('moqd.secondary_uom_code', 'ONHAND');
899:
900: WHEN 'MSN_QUERY' THEN
901:
902: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ORG_ID).column_value :=

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

898: inv_mwb_query_manager.add_group_clause('moqd.secondary_uom_code', 'ONHAND');
899:
900: WHEN 'MSN_QUERY' THEN
901:
902: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ORG_ID).column_value :=
903: 'msn.current_organization_id';
904:
905: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PRIMARY_UOM_CODE).column_value :=
906: '''Ea''';

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

901:
902: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ORG_ID).column_value :=
903: 'msn.current_organization_id';
904:
905: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PRIMARY_UOM_CODE).column_value :=
906: '''Ea''';
907:
908: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ONHAND).column_value := 1;
909:

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

904:
905: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PRIMARY_UOM_CODE).column_value :=
906: '''Ea''';
907:
908: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ONHAND).column_value := 1;
909:
910: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PACKED).column_value :=
911: 'SUM(DECODE(msn.lpn_id, NULL, 0,1))';
912:

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

906: '''Ea''';
907:
908: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ONHAND).column_value := 1;
909:
910: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PACKED).column_value :=
911: 'SUM(DECODE(msn.lpn_id, NULL, 0,1))';
912:
913: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.UNPACKED).column_value :=
914: 'SUM(DECODE(msn.lpn_id, NULL, 1,0))';

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

909:
910: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PACKED).column_value :=
911: 'SUM(DECODE(msn.lpn_id, NULL, 0,1))';
912:
913: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.UNPACKED).column_value :=
914: 'SUM(DECODE(msn.lpn_id, NULL, 1,0))';
915:
916: inv_mwb_query_manager.add_from_clause('mtl_serial_numbers msn', 'ONHAND');
917:

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

912:
913: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.UNPACKED).column_value :=
914: 'SUM(DECODE(msn.lpn_id, NULL, 1,0))';
915:
916: inv_mwb_query_manager.add_from_clause('mtl_serial_numbers msn', 'ONHAND');
917:
918: inv_mwb_query_manager.add_group_clause('msn.current_organization_id', 'ONHAND');
919: inv_mwb_query_manager.add_group_clause('''Ea''', 'ONHAND');
920:

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

914: 'SUM(DECODE(msn.lpn_id, NULL, 1,0))';
915:
916: inv_mwb_query_manager.add_from_clause('mtl_serial_numbers msn', 'ONHAND');
917:
918: inv_mwb_query_manager.add_group_clause('msn.current_organization_id', 'ONHAND');
919: inv_mwb_query_manager.add_group_clause('''Ea''', 'ONHAND');
920:
921:
922: WHEN 'MSN' THEN

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

915:
916: inv_mwb_query_manager.add_from_clause('mtl_serial_numbers msn', 'ONHAND');
917:
918: inv_mwb_query_manager.add_group_clause('msn.current_organization_id', 'ONHAND');
919: inv_mwb_query_manager.add_group_clause('''Ea''', 'ONHAND');
920:
921:
922: WHEN 'MSN' THEN
923:

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

920:
921:
922: WHEN 'MSN' THEN
923:
924: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ITEM_ID).column_value :=
925: 'msn.inventory_item_id';
926:
927: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=
928: 'msn.current_subinventory_code'; --VARAJAGO

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

923:
924: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ITEM_ID).column_value :=
925: 'msn.inventory_item_id';
926:
927: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=
928: 'msn.current_subinventory_code'; --VARAJAGO
929:
930: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=
931: 'msn.current_locator_id'; --VARAJAGO

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

926:
927: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=
928: 'msn.current_subinventory_code'; --VARAJAGO
929:
930: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=
931: 'msn.current_locator_id'; --VARAJAGO
932:
933: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ORG_ID).column_value :=
934: 'msn.current_organization_id';

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

929:
930: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=
931: 'msn.current_locator_id'; --VARAJAGO
932:
933: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ORG_ID).column_value :=
934: 'msn.current_organization_id';
935:
936: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PRIMARY_UOM_CODE).column_value :=
937: '''Ea''';

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

932:
933: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ORG_ID).column_value :=
934: 'msn.current_organization_id';
935:
936: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PRIMARY_UOM_CODE).column_value :=
937: '''Ea''';
938:
939: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ONHAND).column_value := 1;
940:

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

935:
936: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PRIMARY_UOM_CODE).column_value :=
937: '''Ea''';
938:
939: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ONHAND).column_value := 1;
940:
941: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PACKED).column_value :=
942: 'DECODE(msn.lpn_id, NULL, 0,1)';
943:

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

937: '''Ea''';
938:
939: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ONHAND).column_value := 1;
940:
941: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PACKED).column_value :=
942: 'DECODE(msn.lpn_id, NULL, 0,1)';
943:
944: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.UNPACKED).column_value :=
945: 'DECODE(msn.lpn_id, NULL, 1,0)';

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

940:
941: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PACKED).column_value :=
942: 'DECODE(msn.lpn_id, NULL, 0,1)';
943:
944: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.UNPACKED).column_value :=
945: 'DECODE(msn.lpn_id, NULL, 1,0)';
946:
947: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SERIAL).column_value :=
948: 'msn.serial_number';

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

943:
944: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.UNPACKED).column_value :=
945: 'DECODE(msn.lpn_id, NULL, 1,0)';
946:
947: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SERIAL).column_value :=
948: 'msn.serial_number';
949:
950: inv_mwb_query_manager.add_from_clause('mtl_serial_numbers msn', 'ONHAND');
951:

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

946:
947: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SERIAL).column_value :=
948: 'msn.serial_number';
949:
950: inv_mwb_query_manager.add_from_clause('mtl_serial_numbers msn', 'ONHAND');
951:
952: END CASE; -- p_flag
953:
954: END make_common_queries;