DBA Data[Home] [Help]

APPS.INV_LOT_API_PKG dependencies on MTL_OBJECT_GENEALOGY

Line 2198: FROM mtl_object_genealogy

2194: l_lot_rec c_lot_rec%ROWTYPE ;
2195:
2196: CURSOR c_gen_rec(cp_gen_obj_id NUMBER) IS
2197: SELECT *
2198: FROM mtl_object_genealogy
2199: WHERE object_id = cp_gen_obj_id ;
2200:
2201: l_gen_rec c_gen_rec%ROWTYPE ;
2202: l_gen_obj_id NUMBER ;

Line 2331: DELETE FROM mtl_object_genealogy

2327: OPEN c_gen_rec (l_gen_obj_id) ;
2328: FETCH c_gen_rec INTO l_gen_rec ;
2329:
2330: IF c_gen_rec%FOUND THEN
2331: DELETE FROM mtl_object_genealogy
2332: WHERE object_id = l_gen_obj_id ;
2333: END IF;
2334: CLOSE c_gen_rec ;
2335: