APPS.CSI_ITEM_INSTANCE_VLD_PVT dependencies on MTL_OBJECT_GENEALOGY
Line 5926: FROM mtl_object_genealogy mog
5922: l_current_status NUMBER; -- added for 6176621
5923:
5924: CURSOR mog_cur(p_gen_object_id IN number) IS
5925: SELECT 'Y' 5926: FROM mtl_object_genealogy mog 5927: WHERE mog.parent_object_type = 2
5928: AND (mog.object_id = p_gen_object_id OR mog.parent_object_id = p_gen_object_id)
5929: AND mog.object_type = 2
5930: AND sysdate BETWEEN nvl(mog.start_date_active, sysdate-1)