Product: | BIL - Sales Intelligence |
---|---|
Description: | Sales Stages view |
Implementation/DBA Data: | APPS.BIL_DIMV_SALES_STAGES |
SELECT B.SALES_STAGE_ID
, T.NAME
, T.DESCRIPTION
, B.MIN_WIN_PROBABILITY
, B.MAX_WIN_PROBABILITY
, B.ENABLED_FLAG
, B.START_DATE_ACTIVE
, B.END_DATE_ACTIVE
, B.ORG_ID
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.CREATION_DATE
, B.CREATED_BY
, B.LAST_UPDATE_LOGIN
FROM AS_SALES_STAGES_ALL_B B
, AS_SALES_STAGES_ALL_TL T
WHERE B.SALES_STAGE_ID = T.SALES_STAGE_ID
AND T.LANGUAGE = USERENV('LANG') UNION ALL (SELECT TO_NUMBER(FL.LOOKUP_CODE) SALES_STAGE_PK
, SUBSTR(FL.MEANING
, 1
, 60) NAME
, FL.DESCRIPTION DESCRIPTION
, TO_NUMBER(FL.LOOKUP_CODE) MIN_WIN_PROBABILITY
, TO_NUMBER(FL.LOOKUP_CODE) MAX_WIN_PROBABILITY
, FL.ENABLED_FLAG ENABLED_FLAG
, FL.START_DATE_ACTIVE START_DATE_ACTIVE
, FL.END_DATE_ACTIVE END_DATE_ACTIVE
, TO_NUMBER(FL.LOOKUP_CODE) ORG_ID
, FL.END_DATE_ACTIVE LAST_UPDATE_DATE
, TO_NUMBER(FL.LOOKUP_CODE) LAST_UPDATED_BY
, FL.END_DATE_ACTIVE CREATION_DATE
, TO_NUMBER(FL.LOOKUP_CODE) CREATED_BY
, TO_NUMBER(FL.LOOKUP_CODE) LAST_UPDATE_LOGIN
FROM FND_LOOKUPS FL
WHERE FL.LOOKUP_TYPE = 'BIL_VALUE_TYPE'
AND FL.LOOKUP_CODE = '-999') WITH READ ONLY