VIEW: APPS.GHG_TRANSACTIONS_V

Source

View Text - Preformatted

SELECT DISTINCT xne.ROWID row_id, xne.txn_type_lookup_code, xne.transaction_id, xne.transaction_batch_id, xne.transaction_source_id, xnes.source_name, xne.emission_scope_lookup_code, xne.location_code, NULL emission_factor, NULL emission_energy, xne.ghg_organization_id, xnf.ghg_organization_code, xne.mapping_id, xne.transaction_type_lookup_code TRANSACTION_TYPE_LOOKUP_CODE, xnlv.meaning TRANSACTION_TYPE_MEANING, Nvl(xne.usage_quantity, 0) usage_quantity, xne.unit_of_measure, xne.uom_conversion, Nvl(xne.emission_quantity, 0) emission_quantity, Nvl(xne.energy_quantity, 0) energy_quantity, xne.transaction_date_from, xne.transaction_date_to, xne.description, xne.org_id, xne.set_of_books_id, xne.invoice_id, ai.invoice_num, xne.transaction_line_number, xne.distribution_line_number, xne.invoice_line_number, xne.vendor_id, pv.vendor_name, xne.vendor_site_id, pvs.vendor_site_code, xne.inventory_item_id, msi.concatenated_segments INVENTORY_ITEM, msi.description INVENTORY_ITEM_DESCRIPTION, xne.ghg_asset_id, xna.asset_number, xna.description ASSET_DESCRIPTION, xna.book_type_code, xne.attribute1, xne.attribute2, xne.attribute3, xne.attribute4, xne.attribute5, xne.attribute6, xne.attribute7, xne.attribute8, xne.attribute9, xne.attribute10, xne.attribute11, xne.attribute12, xne.attribute13, xne.attribute14, xne.attribute15, xne.attribute16, xne.attribute17, xne.attribute18, xne.attribute19, xne.attribute20, xne.attribute_category, xne.created_by, xne.creation_date, xne.last_updated_by, xne.last_update_date, xne.last_update_login, xne.measurement_criteria FROM ghg_transactions xne, ap_invoices_all ai, ghg_sources xnes, ghg_organizations_all xnf, po_vendors pv, po_vendor_sites_all pvs, mtl_system_items_kfv msi, ghg_assets_v xna, fnd_lookup_values xnlv WHERE ai.invoice_id(+) = xne.invoice_id AND xnf.ghg_organization_id = xne.ghg_organization_id AND pv.vendor_id(+) = xne.vendor_id AND pvs.vendor_site_id(+) = xne.vendor_site_id AND msi.inventory_item_id(+) = xne.inventory_item_id AND xna.ghg_asset_id(+) = xne.ghg_asset_id AND Decode(xne.transaction_type_lookup_code, NULL, 'GHG_EMISSION_TYPE', xnlv.lookup_type) = 'GHG_EMISSION_TYPE' AND xnlv.lookup_code(+) = xne.transaction_type_lookup_code AND xne.transaction_source_id = xnes.source_id AND xnlv.LANGUAGE = Userenv('LANG')

View Text - HTML Formatted

SELECT DISTINCT XNE.ROWID ROW_ID
, XNE.TXN_TYPE_LOOKUP_CODE
, XNE.TRANSACTION_ID
, XNE.TRANSACTION_BATCH_ID
, XNE.TRANSACTION_SOURCE_ID
, XNES.SOURCE_NAME
, XNE.EMISSION_SCOPE_LOOKUP_CODE
, XNE.LOCATION_CODE
, NULL EMISSION_FACTOR
, NULL EMISSION_ENERGY
, XNE.GHG_ORGANIZATION_ID
, XNF.GHG_ORGANIZATION_CODE
, XNE.MAPPING_ID
, XNE.TRANSACTION_TYPE_LOOKUP_CODE TRANSACTION_TYPE_LOOKUP_CODE
, XNLV.MEANING TRANSACTION_TYPE_MEANING
, NVL(XNE.USAGE_QUANTITY
, 0) USAGE_QUANTITY
, XNE.UNIT_OF_MEASURE
, XNE.UOM_CONVERSION
, NVL(XNE.EMISSION_QUANTITY
, 0) EMISSION_QUANTITY
, NVL(XNE.ENERGY_QUANTITY
, 0) ENERGY_QUANTITY
, XNE.TRANSACTION_DATE_FROM
, XNE.TRANSACTION_DATE_TO
, XNE.DESCRIPTION
, XNE.ORG_ID
, XNE.SET_OF_BOOKS_ID
, XNE.INVOICE_ID
, AI.INVOICE_NUM
, XNE.TRANSACTION_LINE_NUMBER
, XNE.DISTRIBUTION_LINE_NUMBER
, XNE.INVOICE_LINE_NUMBER
, XNE.VENDOR_ID
, PV.VENDOR_NAME
, XNE.VENDOR_SITE_ID
, PVS.VENDOR_SITE_CODE
, XNE.INVENTORY_ITEM_ID
, MSI.CONCATENATED_SEGMENTS INVENTORY_ITEM
, MSI.DESCRIPTION INVENTORY_ITEM_DESCRIPTION
, XNE.GHG_ASSET_ID
, XNA.ASSET_NUMBER
, XNA.DESCRIPTION ASSET_DESCRIPTION
, XNA.BOOK_TYPE_CODE
, XNE.ATTRIBUTE1
, XNE.ATTRIBUTE2
, XNE.ATTRIBUTE3
, XNE.ATTRIBUTE4
, XNE.ATTRIBUTE5
, XNE.ATTRIBUTE6
, XNE.ATTRIBUTE7
, XNE.ATTRIBUTE8
, XNE.ATTRIBUTE9
, XNE.ATTRIBUTE10
, XNE.ATTRIBUTE11
, XNE.ATTRIBUTE12
, XNE.ATTRIBUTE13
, XNE.ATTRIBUTE14
, XNE.ATTRIBUTE15
, XNE.ATTRIBUTE16
, XNE.ATTRIBUTE17
, XNE.ATTRIBUTE18
, XNE.ATTRIBUTE19
, XNE.ATTRIBUTE20
, XNE.ATTRIBUTE_CATEGORY
, XNE.CREATED_BY
, XNE.CREATION_DATE
, XNE.LAST_UPDATED_BY
, XNE.LAST_UPDATE_DATE
, XNE.LAST_UPDATE_LOGIN
, XNE.MEASUREMENT_CRITERIA
FROM GHG_TRANSACTIONS XNE
, AP_INVOICES_ALL AI
, GHG_SOURCES XNES
, GHG_ORGANIZATIONS_ALL XNF
, PO_VENDORS PV
, PO_VENDOR_SITES_ALL PVS
, MTL_SYSTEM_ITEMS_KFV MSI
, GHG_ASSETS_V XNA
, FND_LOOKUP_VALUES XNLV
WHERE AI.INVOICE_ID(+) = XNE.INVOICE_ID
AND XNF.GHG_ORGANIZATION_ID = XNE.GHG_ORGANIZATION_ID
AND PV.VENDOR_ID(+) = XNE.VENDOR_ID
AND PVS.VENDOR_SITE_ID(+) = XNE.VENDOR_SITE_ID
AND MSI.INVENTORY_ITEM_ID(+) = XNE.INVENTORY_ITEM_ID
AND XNA.GHG_ASSET_ID(+) = XNE.GHG_ASSET_ID
AND DECODE(XNE.TRANSACTION_TYPE_LOOKUP_CODE
, NULL
, 'GHG_EMISSION_TYPE'
, XNLV.LOOKUP_TYPE) = 'GHG_EMISSION_TYPE'
AND XNLV.LOOKUP_CODE(+) = XNE.TRANSACTION_TYPE_LOOKUP_CODE
AND XNE.TRANSACTION_SOURCE_ID = XNES.SOURCE_ID
AND XNLV.LANGUAGE = USERENV('LANG')