SELECT TO_CHAR(SRC.REFERENCE_ID) , SRC.LEAD_NUMBER , SRC.AMOUNT , L.MEANING , L2.MEANING , SRC.WIN_PROBABILITY , HR.NAME FROM CE_AS_FC_SALES_FCST_V SRC , FND_LOOKUP_VALUES L , FND_LOOKUP_VALUES L2 , HR_OPERATING_UNITS HR WHERE L.LOOKUP_TYPE = 'SALES_FORECAST_STATUS' AND L.LOOKUP_CODE = SRC.STATUS_CODE AND L.LANGUAGE = USERENV('LANG') AND L2.LOOKUP_TYPE = 'SALES_CHANNEL' AND L2.LOOKUP_CODE(+) = SRC.CHANNEL_CODE AND L2.LANGUAGE = USERENV('LANG') AND HR.ORGANIZATION_ID(+) = SRC.ORG_ID AND (SRC.ORG_ID IS NULL OR EXISTS (SELECT NULL FROM CE_SECURITY_PROFILES_V SEC WHERE SEC.ORGANIZATION_ID = SRC.ORG_ID AND SEC.ORGANIZATION_TYPE = 'OPERATING_UNIT'))