Oracle Cross Schema View
CREATE OR REPLACE VIEW WORKMGMT.VIEW_WORKMGMT_USERS(
USER_ID,
USER_VALID_FROM,
USER_VALID_TO,
DEFAULT_UNIT,
LANGUAGE_PREFERENCE)
AS SELECT
SU.ORGANIZATION_USER_ID "USER_ID", TO_TIMESTAMP(TO_CHAR(SU.EFFECTIVE_FROM,'YYYY_MON_DD'),'YYYY-MON-DD HH24:MI:SS') "USER_VALID_FROM", TO_TIMESTAMP(TO_CHAR(SU.EFFECTIVE_TO, 'YYYY_MON_DD'), 'YYYY-MON-DD HH24:MI:SS') "USER_VALID_TO", WM.DEFAULT_UNIT_ID "DEFAULT_UNIT", SA.LANGUAGE_PREFERENCE
FROM
SECEPHS.ORGANIZATION_USER SU, SECEPHS.ACCOUNT_HOLDER SA, WORKMGMT.ORG_USER_WM_PROFILE WM
WHERE
SU.ACCOUNT_HOLDER_ID = SA.ACCOUNT_HOLDER_ID AND SU.ORGANIZATION_USER_ID = WM.ORGANIZATION_USER_ID AND SU.IS_DELETED_IND = '0';
The error occurs on the second table of the SECEPHS schema, no matter the order of the tables. Any advice would be very much appreciated.
Thank-you



