FND Design Data [Home] [Help]

View: ASFV_WIN_PROBABILITIES

Product: AS - Sales Foundation
Description:
Implementation/DBA Data: Not implemented in this database
View Text

SELECT PROB.PROBABILITY_VALUE
, PROB.START_DATE_ACTIVE
, PROB.END_DATE_ACTIVE
, '_LA:PROB.ENABLED_FLAG:AS_LOOKUPS:FLAG:MEANING'
, PROB.MEANING
, '_LA:PROB.LEAD_STATUS_CHANGE_CODE:AS_LOOKUPS:LEAD_STATUS:MEANING'
, '_DF:AS:AS_FORECAST_PROBABILITIES:PROB' -- RESOLVE FK
, PARA.ORGANIZATION_CODE
, ORG.NAME -- ID
, ORG_ID -- WHO
, PROB.LAST_UPDATE_DATE
, PROB.LAST_UPDATED_BY
, PROB.CREATION_DATE
, PROB.CREATED_BY
FROM MTL_PARAMETERS PARA
, HR_ALL_ORGANIZATION_UNITS ORG
, AS_FORECAST_PROB_ALL PROB
WHERE PROB.ORG_ID = PARA.ORGANIZATION_ID (+)
AND PROB.ORG_ID = ORG.ORGANIZATION_ID (+)
AND '_SEC:PROB.ORG_ID' IS NOT NULL WITH READ ONLY

Columns

Name
PROBABILITY_VALUE
START_DATE_ACTIVE
END_DATE_ACTIVE
"_LA:ENABLED"
MEANING
"_LA:LEAD_STATUS_CHANGE"
"_DF"
ORGANIZATION_CODE
ORGANIZATION_NAME
ORG_ID
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATION_DATE
CREATED_BY