570: serial_number_control_code
571: INTO l_rev_control,
572: l_lot_control,
573: l_serial_control
574: FROM mtl_system_items
575: WHERE inventory_item_id = inv_mwb_globals.g_tree_item_id
576: AND organization_id = inv_mwb_globals.g_organization_id;
577:
578: -- If all material locations are unchecked and the view by is LPN
888: SELECT lot_control_code,
889: serial_number_control_code
890: INTO l_lot_control,
891: l_serial_control
892: FROM mtl_system_items
893: WHERE inventory_item_id = inv_mwb_globals.g_tree_item_id
894: AND organization_id = inv_mwb_globals.g_organization_id;
895:
896: -- If all material locations are unchecked and the view by is LPN
1185: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
1186:
1187: SELECT serial_number_control_code
1188: INTO l_serial_control
1189: FROM mtl_system_items
1190: WHERE inventory_item_id = inv_mwb_globals.g_tree_item_id
1191: AND organization_id = inv_mwb_globals.g_organization_id;
1192:
1193: IF inv_mwb_globals.g_chk_onhand = 0