VIEW: APPS.BIL_DIMV_SALES_STAGES

Source

View Text - Preformatted

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

View Text - HTML Formatted

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