APPS.INV_MWB_LOCATION_TREE dependencies on MTL_SYSTEM_ITEMS

Line 916: FROM mtl_system_items

912: serial_number_control_code
913: INTO l_rev_control,
914: l_lot_control,
915: l_serial_control
916: FROM mtl_system_items
917: WHERE inventory_item_id = inv_mwb_globals.g_tree_item_id
918: AND organization_id = inv_mwb_globals.g_tree_organization_id;
919:
920: IF inv_mwb_globals.g_tree_mat_loc_id = 1 THEN

Line 1451: FROM mtl_system_items

1447: SELECT lot_control_code
1448: , serial_number_control_code
1449: INTO l_lot_control
1450: , l_serial_control
1451: FROM mtl_system_items
1452: WHERE inventory_item_id = inv_mwb_globals.g_tree_item_id
1453: AND organization_id = inv_mwb_globals.g_tree_organization_id;
1454:
1455: IF inv_mwb_globals.g_tree_loc_id IS NULL THEN

Line 1876: FROM mtl_system_items

1872:
1873: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
1874: SELECT serial_number_control_code
1875: INTO serial_control
1876: FROM mtl_system_items
1877: WHERE organization_id = inv_mwb_globals.g_tree_organization_id
1878: AND inventory_item_id = inv_mwb_globals.g_tree_item_id;
1879:
1880: IF (inv_mwb_globals.g_tree_mat_loc_id = 1) THEN

Line 3058: FROM mtl_system_items

3054:
3055: IF inv_mwb_globals.g_tree_item_id IS NOT NULL THEN
3056: SELECT lot_control_code
3057: INTO l_lot_control
3058: FROM mtl_system_items
3059: WHERE inventory_item_id = inv_mwb_globals.g_tree_item_id
3060: AND organization_id = inv_mwb_globals.g_tree_organization_id;
3061: END IF;
3062: