--MENU_CTX_PKG.PRED_ACCOUNT_id - udf, возвращает некое константу - id инстанса

CREATE OR REPLACE VIEW view_dual
AS
SELECT MENU_CTX_PKG.PRED_ACCOUNT_id@link pred_account_id
  FROM dual
;

SELECT v.*, MENU_CTX_PKG.PRED_ACCOUNT_id
  FROM view_dual v
 WHERE v.pred_account_id=MENU_CTX_PKG.PRED_ACCOUNT_id

SELECT v.*, Z_MENU.MENU_CTX_PKG.PRED_ACCOUNT_id
  FROM view_dual v
 WHERE v.pred_account_id=2

-- БД по линку
CREATE OR REPLACE PACKAGE test_pkg
IS
FUNCTION get_id RETURN NUMBER;
END;

CREATE OR REPLACE PACKAGE BODY test_pkg
IS
FUNCTION get_id RETURN NUMBER
IS
BEGIN
    RETURN 1;
END;
END;


-- БД текущая
CREATE OR REPLACE PACKAGE test_pkg
IS
FUNCTION get_id RETURN NUMBER;
END;

CREATE OR REPLACE PACKAGE BODY test_pkg
IS
FUNCTION get_id RETURN NUMBER
IS
BEGIN
    RETURN 2;
END;
END;

-- БД текущая
SELECT TEST_PKG.GET_ID FROM dual UNION ALL
SELECT TEST_PKG.GET_ID@link FROM dual;

-- БД текущая
CREATE OR REPLACE VIEW view_dual
AS
SELECT TEST_PKG.GET_ID@link ID
  FROM dual
;

SELECT v.*, TEST_PKG.GET_ID
  FROM view_dual v
 WHERE v.ID=TEST_PKG.GET_ID

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
PL/SQL Release 11.2.0.4.0 - Production
CORE	11.2.0.4.0	Production
TNS for Linux: Version 11.2.0.4.0 - Production
NLSRTL Version 11.2.0.4.0 - Production