DBA Data[Home] [Help]

APPS.INV_LOT_API_PKG dependencies on MTL_OBJECT_GENEALOGY

Line 2142: FROM mtl_object_genealogy

2138: l_lot_rec c_lot_rec%ROWTYPE ;
2139:
2140: CURSOR c_gen_rec(cp_gen_obj_id NUMBER) IS
2141: SELECT *
2142: FROM mtl_object_genealogy
2143: WHERE object_id = cp_gen_obj_id ;
2144:
2145: l_gen_rec c_gen_rec%ROWTYPE ;
2146: l_gen_obj_id NUMBER ;

Line 2275: DELETE FROM mtl_object_genealogy

2271: OPEN c_gen_rec (l_gen_obj_id) ;
2272: FETCH c_gen_rec INTO l_gen_rec ;
2273:
2274: IF c_gen_rec%FOUND THEN
2275: DELETE FROM mtl_object_genealogy
2276: WHERE object_id = l_gen_obj_id ;
2277: END IF;
2278: CLOSE c_gen_rec ;
2279: