MOO_STG_VL

Details

• Schema: FUSION

• Object owner: MOO

• Object type: VIEW

Columns

Name
STG_ID NAME DESC_TEXT AVG_DAYS_AT_STAGE MAX_DAYS_IN_STAGE PHASE_CD QUOTA_FACTOR RCMND_WIN_PROB SALES_METHOD_ID STAGE_STATUS_CD STG_ORDER CONFLICT_ID CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER USER_LAST_UPDATE_DATE STAGE_NUMBER DELETED_FLAG

Query

SQL_Statement

SELECT B.STG_ID, T.NAME, T.DESC_TEXT, B.AVG_DAYS_AT_STAGE, B.MAX_DAYS_IN_STAGE, B.PHASE_CD, B.QUOTA_FACTOR, B.RCMND_WIN_PROB, B.SALES_METHOD_ID, B.STAGE_STATUS_CD, B.STG_ORDER, B.CONFLICT_ID, B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN, B.OBJECT_VERSION_NUMBER, B.USER_LAST_UPDATE_DATE, B.STAGE_NUMBER, B.DELETED_FLAG FROM MOO_STG_B B, MOO_STG_TL T WHERE B.STG_ID = T.STG_ID AND T.LANGUAGE = USERENV('LANG')