VIEW: APPS.GHG_SOURCE_COMBINATIONS_V

Source

View Text - Preformatted

SELECT fac.rowid row_id, source_combination_ID, source_combination_CODE, source_combination_DESCRIPTION, SOURCE_ID, START_DATE, END_DATE, fac.CREATED_BY, fac.CREATION_DATE, fac.LAST_UPDATED_BY, fac.LAST_UPDATE_DATE, fac.LAST_UPDATE_LOGIN, cc.CODE_COMBINATION_ID, SCOPE_LOOKUP_CODE EMISSION_SCOPE_LOOKUP_CODE, METHOD_LOOKUP_CODE EMISSION_METHOD_LOOKUP_CODE, RATE_OVERRIDE_TYPE FACTOR_TYPE, SUPPLIER_ID VENDOR_ID, SUPPLIER_SITE_ID VENDOR_SITE_ID, ITEM_ID INVENTORY_ITEM_ID, METHOD_JUSTIFICATION METHOD_SOURCE, GHG_ORGANIZATION_ID , SUPPLIER_TYPE, ITEM_TYPE, cc.segment5 location_code, cc.segment4 TRANSPORT_TYPE_LOOKUP_CODE, rate_override_type, (SELECT SUM(NVL(FACTOR_VALUE,0)) FROM GHG_FACTORS_ALL gas WHERE FACTOR_TYPE = 'E' AND gas.source_combination_id = fac.source_combination_id ) EMISSION_FACTOR, (SELECT SUM(NVL(FACTOR_VALUE,0)) FROM GHG_FACTORS_ALL gas WHERE FACTOR_TYPE = 'N' AND gas.source_combination_id = fac.source_combination_id ) EMISSION_ENERGY FROM GHG_SOURCE_COMBINATIONS_ALL fac , GHG_REPORT_COMBINATIONS cc WHERE fac.CODE_COMBINATION_ID = cc.CODE_COMBINATION_ID

View Text - HTML Formatted

SELECT FAC.ROWID ROW_ID
, SOURCE_COMBINATION_ID
, SOURCE_COMBINATION_CODE
, SOURCE_COMBINATION_DESCRIPTION
, SOURCE_ID
, START_DATE
, END_DATE
, FAC.CREATED_BY
, FAC.CREATION_DATE
, FAC.LAST_UPDATED_BY
, FAC.LAST_UPDATE_DATE
, FAC.LAST_UPDATE_LOGIN
, CC.CODE_COMBINATION_ID
, SCOPE_LOOKUP_CODE EMISSION_SCOPE_LOOKUP_CODE
, METHOD_LOOKUP_CODE EMISSION_METHOD_LOOKUP_CODE
, RATE_OVERRIDE_TYPE FACTOR_TYPE
, SUPPLIER_ID VENDOR_ID
, SUPPLIER_SITE_ID VENDOR_SITE_ID
, ITEM_ID INVENTORY_ITEM_ID
, METHOD_JUSTIFICATION METHOD_SOURCE
, GHG_ORGANIZATION_ID
, SUPPLIER_TYPE
, ITEM_TYPE
, CC.SEGMENT5 LOCATION_CODE
, CC.SEGMENT4 TRANSPORT_TYPE_LOOKUP_CODE
, RATE_OVERRIDE_TYPE
, (SELECT SUM(NVL(FACTOR_VALUE
, 0))
FROM GHG_FACTORS_ALL GAS
WHERE FACTOR_TYPE = 'E'
AND GAS.SOURCE_COMBINATION_ID = FAC.SOURCE_COMBINATION_ID ) EMISSION_FACTOR
, (SELECT SUM(NVL(FACTOR_VALUE
, 0))
FROM GHG_FACTORS_ALL GAS
WHERE FACTOR_TYPE = 'N'
AND GAS.SOURCE_COMBINATION_ID = FAC.SOURCE_COMBINATION_ID ) EMISSION_ENERGY
FROM GHG_SOURCE_COMBINATIONS_ALL FAC
, GHG_REPORT_COMBINATIONS CC
WHERE FAC.CODE_COMBINATION_ID = CC.CODE_COMBINATION_ID