VIEW: APPS.CE_FC_ASF_DISC_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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