APPS.INV_MWB_LOT_TREE dependencies on MTL_SYSTEM_ITEMS

Line 229: FROM mtl_system_items

225: SELECT revision_qty_control_code,
226: serial_number_control_code
227: INTO l_rev_control,
228: l_serial_control
229: FROM mtl_system_items
230: WHERE organization_id = inv_mwb_globals.g_tree_organization_id
231: AND inventory_item_id = inv_mwb_globals.g_tree_item_id;
232:
233: IF NVL(l_rev_control, 1) = 1 AND l_serial_control IN (2,5) THEN

Line 365: FROM mtl_system_items

361: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
362:
363: SELECT serial_number_control_code
364: INTO l_serial_control
365: FROM mtl_system_items
366: WHERE organization_id = inv_mwb_globals.g_tree_organization_id
367: AND inventory_item_id = inv_mwb_globals.g_tree_item_id;
368:
369: IF l_serial_control in ( 2,5 ) THEN

Line 470: FROM mtl_system_items

466: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
467:
468: SELECT revision_qty_control_code
469: INTO l_rev_control
470: FROM mtl_system_items
471: WHERE organization_id = inv_mwb_globals.g_tree_organization_id
472: AND inventory_item_id = inv_mwb_globals.g_tree_item_id;
473:
474: make_common_queries('MSN');