APPS.CSI_ITEM_INSTANCE_VLD_PVT dependencies on MTL_OBJECT_GENEALOGY
Line 6210: FROM mtl_object_genealogy mog
6206: l_current_status NUMBER; -- added for 6176621
6207:
6208: CURSOR mog_cur(p_gen_object_id IN number) IS
6209: SELECT 'Y' 6210: FROM mtl_object_genealogy mog 6211: WHERE mog.parent_object_type = 2
6212: AND (mog.object_id = p_gen_object_id OR mog.parent_object_id = p_gen_object_id)
6213: AND mog.object_type = 2
6214: AND sysdate BETWEEN nvl(mog.start_date_active, sysdate-1)