Product: | AS - Sales Foundation |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
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