APPS.INV_MWB_SERIAL_TREE dependencies on MTL_SYSTEM_ITEMS

Line 175: FROM mtl_system_items

171: SELECT revision_qty_control_code,
172: lot_control_code
173: INTO l_rev_control,
174: l_lot_control
175: FROM mtl_system_items
176: WHERE organization_id = inv_mwb_globals.g_tree_organization_id
177: AND inventory_item_id = inv_mwb_globals.g_tree_item_id;
178:
179: make_common_queries('MSN');

Line 255: FROM mtl_system_items

251: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
252:
253: SELECT lot_control_code
254: INTO l_lot_control
255: FROM mtl_system_items
256: WHERE organization_id = inv_mwb_globals.g_tree_organization_id
257: AND inventory_item_id = inv_mwb_globals.g_tree_item_id;
258:
259: make_common_queries('MSN');

Line 334: FROM mtl_system_items

330: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
331:
332: SELECT revision_qty_control_code
333: INTO l_rev_control
334: FROM mtl_system_items
335: WHERE organization_id = inv_mwb_globals.g_tree_organization_id
336: AND inventory_item_id = inv_mwb_globals.g_tree_item_id;
337:
338: make_common_queries('MSN');