DBA Data[Home] [Help]

APPS.INV_MWB_LOT_TREE dependencies on MTL_SYSTEM_ITEMS

Line 223: FROM mtl_system_items

219: SELECT revision_qty_control_code,
220: serial_number_control_code
221: INTO l_rev_control,
222: l_serial_control
223: FROM mtl_system_items
224: WHERE organization_id = inv_mwb_globals.g_tree_organization_id
225: AND inventory_item_id = inv_mwb_globals.g_tree_item_id;
226:
227: IF NVL(l_rev_control, 1) = 1 AND l_serial_control IN (2,5) THEN

Line 357: FROM mtl_system_items

353: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
354:
355: SELECT serial_number_control_code
356: INTO l_serial_control
357: FROM mtl_system_items
358: WHERE organization_id = inv_mwb_globals.g_tree_organization_id
359: AND inventory_item_id = inv_mwb_globals.g_tree_item_id;
360:
361: IF l_serial_control in ( 2,5 ) THEN

Line 462: FROM mtl_system_items

458: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
459:
460: SELECT revision_qty_control_code
461: INTO l_rev_control
462: FROM mtl_system_items
463: WHERE organization_id = inv_mwb_globals.g_tree_organization_id
464: AND inventory_item_id = inv_mwb_globals.g_tree_item_id;
465:
466: make_common_queries('MSN');