Product: | AS - Sales Foundation |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT STAGE.NAME
, STAGE.MIN_WIN_PROBABILITY
, STAGE.MAX_WIN_PROBABILITY
, '_LA:STAGE.ENABLED_FLAG:AS_LOOKUPS:FLAG:MEANING'
, STAGE.START_DATE_ACTIVE
, STAGE.END_DATE_ACTIVE
, STAGE.DESCRIPTION
, '_DF:AS:AS_SALES_STAGES:STAGE' -- RESOLVE FK
, PROB1.MEANING
, PROB2.MEANING
, PARA.ORGANIZATION_CODE
, ORG.NAME -- ID
, STAGE.SALES_STAGE_ID
, STAGE.ORG_ID -- WHO
, STAGE.LAST_UPDATE_DATE
, STAGE.LAST_UPDATED_BY
, STAGE.CREATION_DATE
, STAGE.CREATED_BY
FROM MTL_PARAMETERS PARA
, HR_ALL_ORGANIZATION_UNITS ORG
, AS_FORECAST_PROB_ALL PROB1
, AS_FORECAST_PROB_ALL PROB2
, AS_SALES_STAGES_ALL STAGE
WHERE STAGE.ORG_ID = PARA.ORGANIZATION_ID (+)
AND STAGE.ORG_ID = ORG.ORGANIZATION_ID (+) AND STAGE.MIN_WIN_PROBABILITY = PROB1.PROBABILITY_VALUE (+) AND STAGE.MIN_WIN_PROBABILITY = PROB2.PROBABILITY_VALUE (+) AND '_SEC:STAGE.ORG_ID' IS NOT NULL WITH READ ONLY