DBA Data[Home] [Help]

APPS.INV_MWB_LPN_TREE dependencies on MTL_SYSTEM_ITEMS

Line 580: FROM mtl_system_items

576: serial_number_control_code
577: INTO l_rev_control,
578: l_lot_control,
579: l_serial_control
580: FROM mtl_system_items
581: WHERE inventory_item_id = inv_mwb_globals.g_tree_item_id
582: AND organization_id = inv_mwb_globals.g_organization_id;
583:
584: -- If all material locations are unchecked and the view by is LPN

Line 941: FROM mtl_system_items

937: SELECT lot_control_code,
938: serial_number_control_code
939: INTO l_lot_control,
940: l_serial_control
941: FROM mtl_system_items
942: WHERE inventory_item_id = inv_mwb_globals.g_tree_item_id
943: AND organization_id = inv_mwb_globals.g_organization_id;
944:
945: -- If all material locations are unchecked and the view by is LPN

Line 1258: FROM mtl_system_items

1254: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
1255:
1256: SELECT serial_number_control_code
1257: INTO l_serial_control
1258: FROM mtl_system_items
1259: WHERE inventory_item_id = inv_mwb_globals.g_tree_item_id
1260: AND organization_id = inv_mwb_globals.g_organization_id;
1261:
1262: IF inv_mwb_globals.g_chk_onhand = 0