VIEW: APPS.GHG_SOURCES_V

Source

View Text - Preformatted

SELECT xnes.rowid row_id, xnes.source_id, xnes.SOURCE_NAME, xnes.unit_of_measure, muom.description, xnes.attribute1, xnes.attribute2, xnes.attribute3, xnes.attribute4, xnes.attribute5, xnes.attribute6, xnes.attribute7, xnes.attribute8, xnes.attribute9, xnes.attribute10, xnes.attribute11, xnes.attribute12, xnes.attribute13, xnes.attribute14, xnes.attribute15, xnes.attribute16, xnes.attribute17, xnes.attribute18, xnes.attribute19, xnes.attribute20, xnes.attribute_category, xnes.created_by, xnes.creation_date, xnes.last_updated_by, xnes.last_update_date, xnes.last_update_login, xnes.enabled, xnes.org_id, hro.name operating_unit, fo.description formula_name, fo.formula_id, GHG_UOM_CLASS_CODE, CASE WHEN xnes.energy_type IS NOT NULL THEN (SELECT meaning FROM fnd_lookup_values WHERE lookup_type = 'GHG_ENERGY_TYPE' AND lookup_code = xnes.energy_type AND LANGUAGE = UserEnv('LANG')) ELSE xnes.energy_type END energy_type FROM GHG_SOURCES xnes, mtl_units_of_measure_vl muom, hr_organization_units hro, GHG_EMISSION_FORMULAS fo WHERE muom.unit_of_measure = xnes.unit_of_measure AND hro.organization_id = xnes.org_id AND xnes.formula_id = fo.formula_id AND fo.org_id = xnes.org_id

View Text - HTML Formatted

SELECT XNES.ROWID ROW_ID
, XNES.SOURCE_ID
, XNES.SOURCE_NAME
, XNES.UNIT_OF_MEASURE
, MUOM.DESCRIPTION
, XNES.ATTRIBUTE1
, XNES.ATTRIBUTE2
, XNES.ATTRIBUTE3
, XNES.ATTRIBUTE4
, XNES.ATTRIBUTE5
, XNES.ATTRIBUTE6
, XNES.ATTRIBUTE7
, XNES.ATTRIBUTE8
, XNES.ATTRIBUTE9
, XNES.ATTRIBUTE10
, XNES.ATTRIBUTE11
, XNES.ATTRIBUTE12
, XNES.ATTRIBUTE13
, XNES.ATTRIBUTE14
, XNES.ATTRIBUTE15
, XNES.ATTRIBUTE16
, XNES.ATTRIBUTE17
, XNES.ATTRIBUTE18
, XNES.ATTRIBUTE19
, XNES.ATTRIBUTE20
, XNES.ATTRIBUTE_CATEGORY
, XNES.CREATED_BY
, XNES.CREATION_DATE
, XNES.LAST_UPDATED_BY
, XNES.LAST_UPDATE_DATE
, XNES.LAST_UPDATE_LOGIN
, XNES.ENABLED
, XNES.ORG_ID
, HRO.NAME OPERATING_UNIT
, FO.DESCRIPTION FORMULA_NAME
, FO.FORMULA_ID
, GHG_UOM_CLASS_CODE
, CASE WHEN XNES.ENERGY_TYPE IS NOT NULL THEN (SELECT MEANING
FROM FND_LOOKUP_VALUES
WHERE LOOKUP_TYPE = 'GHG_ENERGY_TYPE'
AND LOOKUP_CODE = XNES.ENERGY_TYPE
AND LANGUAGE = USERENV('LANG')) ELSE XNES.ENERGY_TYPE END ENERGY_TYPE
FROM GHG_SOURCES XNES
, MTL_UNITS_OF_MEASURE_VL MUOM
, HR_ORGANIZATION_UNITS HRO
, GHG_EMISSION_FORMULAS FO
WHERE MUOM.UNIT_OF_MEASURE = XNES.UNIT_OF_MEASURE
AND HRO.ORGANIZATION_ID = XNES.ORG_ID
AND XNES.FORMULA_ID = FO.FORMULA_ID
AND FO.ORG_ID = XNES.ORG_ID