1. Tables and Views for SCM
  2. SUS_ACTIVITY_MEASURES_V

SUS_ACTIVITY_MEASURES_V

Details

  • Schema: FUSION

  • Object owner: SUS

  • Object type: VIEW

Columns

Name

ACTIVITY_MEASURE_ID

ACTIVITY_ID

MEASURE_TYPE_CODE

MEASURE_TYPE

MEASURE

UOM_CODE

UOM

CURRENCY_CODE

CURRENCY

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

OBJECT_VERSION_NUMBER

Query

SQL_Statement

SELECT SAM.ACTIVITY_MEASURE_ID,

SAM.ACTIVITY_ID,

SAM.MEASURE_TYPE_CODE,

FLM.MEANING AS "MEASURE_TYPE",

SAM.MEASURE,

SAM.UOM_CODE,

IUOMV.UNIT_OF_MEASURE UOM,

SAM.CURRENCY_CODE,

FCV.NAME CURRENCY,

SAM.CREATED_BY,

SAM.CREATION_DATE,

SAM.LAST_UPDATED_BY,

SAM.LAST_UPDATE_DATE,

SAM.LAST_UPDATE_LOGIN,

SAM.OBJECT_VERSION_NUMBER

FROM

SUS_ACTIVITY_MEASURES SAM,

FND_LOOKUPS FLM,

INV_UNITS_OF_MEASURE_VL IUOMV,

FND_CURRENCIES_VL FCV

WHERE 1=1

AND SAM.MEASURE_TYPE_CODE = FLM.LOOKUP_CODE

AND FLM.LOOKUP_TYPE = 'ORA_SUS_MEASURE_TYPES'

AND SAM.UOM_CODE = IUOMV.UOM_CODE(+)

AND SAM.CURRENCY_CODE = FCV.CURRENCY_CODE(+)