VIEW: GHG.GHG_SOURCE_COMBINATIONS_ALL#

Source

View Text - Preformatted

select SOURCE_COMBINATION_ID SOURCE_COMBINATION_ID, SOURCE_COMBINATION_CODE SOURCE_COMBINATION_CODE, SOURCE_COMBINATION_DESCRIPTION SOURCE_COMBINATION_DESCRIPTION, SOURCE_ID SOURCE_ID, START_DATE START_DATE, END_DATE END_DATE, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CODE_COMBINATION_ID CODE_COMBINATION_ID, SCOPE_LOOKUP_CODE SCOPE_LOOKUP_CODE, METHOD_LOOKUP_CODE METHOD_LOOKUP_CODE, RATE_OVERRIDE_TYPE RATE_OVERRIDE_TYPE, SUPPLIER_ID SUPPLIER_ID, SUPPLIER_SITE_ID SUPPLIER_SITE_ID, ITEM_ID ITEM_ID, METHOD_JUSTIFICATION METHOD_JUSTIFICATION, GHG_ORGANIZATION_ID GHG_ORGANIZATION_ID, SUPPLIER_TYPE SUPPLIER_TYPE, ITEM_TYPE ITEM_TYPE, LOCATION_CODE LOCATION_CODE, TRANSPORT_TYPE_LOOKUP_CODE TRANSPORT_TYPE_LOOKUP_CODE, ORG_ID ORG_ID from "GHG"."GHG_SOURCE_COMBINATIONS_ALL"

View Text - HTML Formatted

SELECT SOURCE_COMBINATION_ID SOURCE_COMBINATION_ID
, SOURCE_COMBINATION_CODE SOURCE_COMBINATION_CODE
, SOURCE_COMBINATION_DESCRIPTION SOURCE_COMBINATION_DESCRIPTION
, SOURCE_ID SOURCE_ID
, START_DATE START_DATE
, END_DATE END_DATE
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CODE_COMBINATION_ID CODE_COMBINATION_ID
, SCOPE_LOOKUP_CODE SCOPE_LOOKUP_CODE
, METHOD_LOOKUP_CODE METHOD_LOOKUP_CODE
, RATE_OVERRIDE_TYPE RATE_OVERRIDE_TYPE
, SUPPLIER_ID SUPPLIER_ID
, SUPPLIER_SITE_ID SUPPLIER_SITE_ID
, ITEM_ID ITEM_ID
, METHOD_JUSTIFICATION METHOD_JUSTIFICATION
, GHG_ORGANIZATION_ID GHG_ORGANIZATION_ID
, SUPPLIER_TYPE SUPPLIER_TYPE
, ITEM_TYPE ITEM_TYPE
, LOCATION_CODE LOCATION_CODE
, TRANSPORT_TYPE_LOOKUP_CODE TRANSPORT_TYPE_LOOKUP_CODE
, ORG_ID ORG_ID
FROM "GHG"."GHG_SOURCE_COMBINATIONS_ALL"