====== Изменение DrillDown с видов Связи вида ======

Все данные для этих видов содержаться в таблице базы данных
Изменить DrillDown можно используя следующий SQL.




===== Просмотр существующих DrillDown =====

<code sql>
select *
from S_APPVW_SHRTCUT
where SCREEN_NAME = 'Contacts Screen'
and active_flg ='Y';
</code>

===== Добавление новых DrillDown =====

<code sql>
INSERT INTO S_APPVW_SHRTCUT 
(ROW_ID,
 CREATED,
 CREATED_BY,
 LAST_UPD_BY,
 ACTIVE_FLG,
 APPVIEW_NAME,
 NAME,
 PUBLIC_FLG,
 SCREEN_NAME,
 SEQ_NUM,
 DESC_TEXT)
 values 
(UTIL_PKG.NEXT_ROW_ID,
 SYSDATE,
 '0-1',
 '0-1',
 'Y',
 'My Contacts View',
 'My Contacts',
 'Y',
 'Contacts Screen',
 1,
 'My Contacts');
</code>

===== Изменения DrillDown ор. лиц =====

{{:accounts.png?400|}}

<code sql>
update S_APPVW_SHRTCUT
set APPVIEW_NAME = 'All Accounts View'
where SCREEN_NAME = 'Accounts Screen'
and active_flg ='Y'
and NAME = 'All Accounts';
</code>


===== Изменения DrillDown сделкам =====

<code sql>

update S_APPVW_SHRTCUT
set APPVIEW_NAME = 'All Opportunities View'
where SCREEN_NAME = 'Opportunities Screen'
and active_flg ='Y'
and NAME = 'All Opportunities';
</code>

===== Изменения DrillDown контактам =====

{{:contacts.png?400|}}

<code sql>
update S_APPVW_SHRTCUT
set APPVIEW_NAME = 'All My Contacts View'
where SCREEN_NAME = 'Contacts Screen'
and active_flg ='Y'
and NAME = 'My Contacts';

update S_APPVW_SHRTCUT
set APPVIEW_NAME = 'All Contacts'
where SCREEN_NAME = 'Contacts Screen'
and active_flg ='Y'
and NAME = 'All Contacts';
</code>

===== Изменения DrillDown действиям=====
<code sql>
update S_APPVW_SHRTCUT
set APPVIEW_NAME = 'All Activities View'
where SCREEN_NAME = 'Activities Screen'
and active_flg ='Y'
and NAME = 'All Activities';
</code>