SUS_ACTIVITY_EMISSIONS_V

Details

• Schema: FUSION

• Object owner: SUS

• Object type: VIEW

Columns

Name

ACTIVITY_EMISSION_ID ACTIVITY_ID EMISSION_TYPE_CODE EMISSION_TYPE EMISSION_QTY EMISSION_UOM_CODE EMISSION_UOM MEASURE_TYPE_CODE MEASURE_TYPE GWP_ID GWP_FACTOR EMISSION_FACTOR NUMERATOR_UOM_CODE NUMERATOR_UOM DENOMINATOR_UOM_CODE DENOMINATOR_UOM DENOMINATOR_CURRENCY_CODE DENOMINATOR_CURRENCY DESCRIPTION EMISSION_FACTOR_MAP_ID EMISSION_FACTOR_SOURCE ACTIVITY_MEASURE_ID CO2E_EMISSION_QTY CO2E_UOM_CODE CO2E_UOM CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER

Query

SQL_Statement

SELECT SAE.ACTIVITY_EMISSION_ID ,SAE.ACTIVITY_ID ,SAE.EMISSION_TYPE_CODE ,FLE.MEANING AS "EMISSION_TYPE" ,SAE.EMISSION_QTY ,SAE.EMISSION_UOM_CODE ,EUOM.UNIT_OF_MEASURE AS "EMISSION_UOM" ,SAE.MEASURE_TYPE_CODE ,FLM.MEANING AS "MEASURE_TYPE" ,SAE.GWP_ID ,SAE.GWP_FACTOR ,SAE.EMISSION_FACTOR ,SAE.NUMERATOR_UOM_CODE ,NUOM.UNIT_OF_MEASURE AS "NUMERATOR_UOM" ,SAE.DENOMINATOR_UOM_CODE ,DUOM.UNIT_OF_MEASURE AS "DENOMINATOR_UOM" ,SAE.DENOMINATOR_CURRENCY_CODE ,FCV.NAME AS "DENOMINATOR_CURRENCY" ,SAE.DESCRIPTION ,SAE.EMISSION_FACTOR_MAP_ID ,SAE.EMISSION_FACTOR_SOURCE ,SAE.ACTIVITY_MEASURE_ID ,SAE.CO2E_EMISSION_QTY ,SAE.CO2E_UOM_CODE ,CUOM.UNIT_OF_MEASURE AS "CO2E_UOM" ,SAE.CREATED_BY ,SAE.CREATION_DATE ,SAE.LAST_UPDATED_BY ,SAE.LAST_UPDATE_DATE ,SAE.LAST_UPDATE_LOGIN ,SAE.OBJECT_VERSION_NUMBER FROM SUS_ACTIVITY_EMISSIONS SAE, FND_LOOKUPS FLE, FND_LOOKUPS FLM, INV_UNITS_OF_MEASURE_VL EUOM, INV_UNITS_OF_MEASURE_VL NUOM, INV_UNITS_OF_MEASURE_VL DUOM, FND_CURRENCIES_VL FCV, INV_UNITS_OF_MEASURE_VL CUOM WHERE 1=1 AND SAE.EMISSION_TYPE_CODE = FLE.LOOKUP_CODE AND FLE.LOOKUP_TYPE = 'ORA_SUS_EMISSION_TYPES' AND SAE.MEASURE_TYPE_CODE = FLM.LOOKUP_CODE(+) AND FLM.LOOKUP_TYPE(+) = 'ORA_SUS_MEASURE_TYPES' AND SAE.EMISSION_UOM_CODE = EUOM.UOM_CODE(+) AND SAE.NUMERATOR_UOM_CODE = NUOM.UOM_CODE(+) AND SAE.DENOMINATOR_UOM_CODE = DUOM.UOM_CODE(+) AND SAE.DENOMINATOR_CURRENCY_CODE = FCV.CURRENCY_CODE(+) AND SAE.CO2E_UOM_CODE = CUOM.UOM_CODE(+)