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

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

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

SELECT *
FROM S_APPVW_SHRTCUT
WHERE SCREEN_NAME = 'Contacts Screen'
AND active_flg ='Y';

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

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');

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

UPDATE S_APPVW_SHRTCUT
SET APPVIEW_NAME = 'All Accounts View'
WHERE SCREEN_NAME = 'Accounts Screen'
AND active_flg ='Y'
AND NAME = 'All Accounts';

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

UPDATE S_APPVW_SHRTCUT
SET APPVIEW_NAME = 'All Opportunities View'
WHERE SCREEN_NAME = 'Opportunities Screen'
AND active_flg ='Y'
AND NAME = 'All Opportunities';

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

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';

Изменения DrillDown действиям

UPDATE S_APPVW_SHRTCUT
SET APPVIEW_NAME = 'All Activities View'
WHERE SCREEN_NAME = 'Activities Screen'
AND active_flg ='Y'
AND NAME = 'All Activities';