VIEW: APPS.GHG_SUPPLIER_FACTORS_V

Source

View Text - Preformatted

SELECT row_id, xner.source_combination_id, xner.rate_override_type, xnes.source_id, xnes.SOURCE_NAME, xnes.unit_of_measure, xner.source_combination_code, xner.source_combination_description, xner.location_code, xner.emission_scope_lookup_code, xner.emission_factor, xner.emission_energy, xner.vendor_id, xner.vendor_site_id, xner.inventory_item_id, xner.item_type, xner.start_date, xner.end_date, xnes.org_id, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, xner.created_by, xner.creation_date, xner.last_updated_by, xner.last_update_date, xner.last_update_login FROM GHG_SOURCE_COMBINATIONS_V xner, GHG_SOURCES xnes WHERE xner.rate_override_type = 'Supplier' AND xnes.source_id = xner.source_id

View Text - HTML Formatted

SELECT ROW_ID
, XNER.SOURCE_COMBINATION_ID
, XNER.RATE_OVERRIDE_TYPE
, XNES.SOURCE_ID
, XNES.SOURCE_NAME
, XNES.UNIT_OF_MEASURE
, XNER.SOURCE_COMBINATION_CODE
, XNER.SOURCE_COMBINATION_DESCRIPTION
, XNER.LOCATION_CODE
, XNER.EMISSION_SCOPE_LOOKUP_CODE
, XNER.EMISSION_FACTOR
, XNER.EMISSION_ENERGY
, XNER.VENDOR_ID
, XNER.VENDOR_SITE_ID
, XNER.INVENTORY_ITEM_ID
, XNER.ITEM_TYPE
, XNER.START_DATE
, XNER.END_DATE
, XNES.ORG_ID
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, XNER.CREATED_BY
, XNER.CREATION_DATE
, XNER.LAST_UPDATED_BY
, XNER.LAST_UPDATE_DATE
, XNER.LAST_UPDATE_LOGIN
FROM GHG_SOURCE_COMBINATIONS_V XNER
, GHG_SOURCES XNES
WHERE XNER.RATE_OVERRIDE_TYPE = 'SUPPLIER'
AND XNES.SOURCE_ID = XNER.SOURCE_ID