VIEW: APPS.GHG_ITEM_FACTORS_V

Source

View Text - Preformatted

SELECT DISTINCT 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.scope_lookup_code, NULL emission_factor, NULL emission_energy, xner.supplier_id vendor_id, xner.supplier_site_id vendor_site_id, xner.item_id inventory_item_id, msi.concatenated_segments, msi.description, xner.item_type, xnlv.meaning, xner.transport_type_lookup_code, 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 org_organization_definitions ood, GHG_SOURCES xnes, GHG_SOURCE_COMBINATIONS_ALL xner, mtl_system_items_kfv msi, FND_lookup_values xnlv WHERE xnes.org_id = ood.operating_unit AND ood.organization_id = msi.organization_id AND xner.rate_override_type = 'ITEM' AND xnes.source_id = xner.source_id AND msi.inventory_item_id = xner.item_id AND xnlv.lookup_type = 'GHG_ITEM_TYPE' AND xnlv.lookup_code = xner.item_type AND xnlv.LANGUAGE =USERENV('LANG') UNION ALL SELECT DISTINCT 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.scope_lookup_code, NULL emission_factor, NULL emission_energy, xner.supplier_id vendor_id, xner.supplier_site_id vendor_site_id, msi.inventory_item_id inventory_item_id, msi.concatenated_segments, msi.description, 'I', NULL, xner.transport_type_lookup_code, 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 org_organization_definitions ood, GHG_SOURCES xnes, GHG_SOURCE_COMBINATIONS_ALL xner, mtl_system_items_kfv msi, GHG_SUPPLIER_ITEMS rd WHERE xnes.org_id = ood.operating_unit AND ood.organization_id = msi.organization_id AND NVL(xner.rate_override_type,'ALL') = 'ALL' AND xnes.source_id = xner.source_id AND msi.inventory_item_id = rd.inventory_item_id AND rd.source_id = xnes.source_id

View Text - HTML Formatted

SELECT DISTINCT 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.SCOPE_LOOKUP_CODE
, NULL EMISSION_FACTOR
, NULL EMISSION_ENERGY
, XNER.SUPPLIER_ID VENDOR_ID
, XNER.SUPPLIER_SITE_ID VENDOR_SITE_ID
, XNER.ITEM_ID INVENTORY_ITEM_ID
, MSI.CONCATENATED_SEGMENTS
, MSI.DESCRIPTION
, XNER.ITEM_TYPE
, XNLV.MEANING
, XNER.TRANSPORT_TYPE_LOOKUP_CODE
, 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 ORG_ORGANIZATION_DEFINITIONS OOD
, GHG_SOURCES XNES
, GHG_SOURCE_COMBINATIONS_ALL XNER
, MTL_SYSTEM_ITEMS_KFV MSI
, FND_LOOKUP_VALUES XNLV
WHERE XNES.ORG_ID = OOD.OPERATING_UNIT
AND OOD.ORGANIZATION_ID = MSI.ORGANIZATION_ID
AND XNER.RATE_OVERRIDE_TYPE = 'ITEM'
AND XNES.SOURCE_ID = XNER.SOURCE_ID
AND MSI.INVENTORY_ITEM_ID = XNER.ITEM_ID
AND XNLV.LOOKUP_TYPE = 'GHG_ITEM_TYPE'
AND XNLV.LOOKUP_CODE = XNER.ITEM_TYPE
AND XNLV.LANGUAGE =USERENV('LANG') UNION ALL SELECT DISTINCT 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.SCOPE_LOOKUP_CODE
, NULL EMISSION_FACTOR
, NULL EMISSION_ENERGY
, XNER.SUPPLIER_ID VENDOR_ID
, XNER.SUPPLIER_SITE_ID VENDOR_SITE_ID
, MSI.INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, MSI.CONCATENATED_SEGMENTS
, MSI.DESCRIPTION
, 'I'
, NULL
, XNER.TRANSPORT_TYPE_LOOKUP_CODE
, 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 ORG_ORGANIZATION_DEFINITIONS OOD
, GHG_SOURCES XNES
, GHG_SOURCE_COMBINATIONS_ALL XNER
, MTL_SYSTEM_ITEMS_KFV MSI
, GHG_SUPPLIER_ITEMS RD
WHERE XNES.ORG_ID = OOD.OPERATING_UNIT
AND OOD.ORGANIZATION_ID = MSI.ORGANIZATION_ID
AND NVL(XNER.RATE_OVERRIDE_TYPE
, 'ALL') = 'ALL'
AND XNES.SOURCE_ID = XNER.SOURCE_ID
AND MSI.INVENTORY_ITEM_ID = RD.INVENTORY_ITEM_ID
AND RD.SOURCE_ID = XNES.SOURCE_ID