VIEW: APPS.GHG_TRANSACTIONS_HISTORY_V

Source

View Text - Preformatted

SELECT xneh.rowid row_id, xneh.txn_type_lookup_code, xneh.TRANSACTION_ID, xneh.TRANSACTION_VERSION, xnes.source_id, xnes.SOURCE_NAME, NULL, NULL, NULL, NULL, xneh.GHG_ORGANIZATION_ID, xnf.GHG_ORGANIZATION_CODE, xneh.TRANSACTION_TYPE_LOOKUP_CODE, xnlv.meaning, xneh.usage_quantity, xneh.unit_of_measure, xneh.uom_conversion, xneh.emission_quantity, xneh.energy_quantity, xneh.TRANSACTION_DATE_FROM, xneh.TRANSACTION_DATE_TO, xneh.description, xneh.org_id, xneh.set_of_books_id, xneh.invoice_id, ai.invoice_num, xneh.TRANSACTION_LINE_NUMBER, xneh.distribution_line_number, xneh.invoice_line_number, xneh.vendor_id, pv.vendor_name, xneh.vendor_site_id, pvs.vendor_site_code, xneh.attribute1, xneh.attribute2, xneh.attribute3, xneh.attribute4, xneh.attribute5, xneh.attribute6, xneh.attribute7, xneh.attribute8, xneh.attribute9, xneh.attribute10, xneh.attribute11, xneh.attribute12, xneh.attribute13, xneh.attribute14, xneh.attribute15, xneh.attribute16, xneh.attribute17, xneh.attribute18, xneh.attribute19, xneh.attribute20, xneh.attribute_category, xneh.created_by, xneh.creation_date, xneh.last_updated_by, xneh.last_update_date, xneh.last_update_login FROM GHG_TRANSACTIONS_HISTORY xneh, GHG_SOURCES xnes, GHG_ORGANIZATIONS_ALL xnf, po_vendors pv, po_vendor_sites_all pvs, ap_invoices_all ai, FND_lookup_values xnlv WHERE xneh.transaction_source_id = xnes.source_id AND xnf.GHG_ORGANIZATION_ID = xneh.GHG_ORGANIZATION_ID AND pv.vendor_id(+) = xneh.vendor_id AND pvs.vendor_site_id(+) = xneh.vendor_site_id AND ai.invoice_id(+) = xneh.invoice_id AND DECODE(xneh.TRANSACTION_TYPE_LOOKUP_CODE, NULL, 'GHG_EMISSION_TYPE', xnlv.lookup_type) = 'GHG_EMISSION_TYPE' AND xnlv.lookup_code(+) = xneh.TRANSACTION_TYPE_LOOKUP_CODE AND xnlv.LANGUAGE =USERENV('LANG')

View Text - HTML Formatted

SELECT XNEH.ROWID ROW_ID
, XNEH.TXN_TYPE_LOOKUP_CODE
, XNEH.TRANSACTION_ID
, XNEH.TRANSACTION_VERSION
, XNES.SOURCE_ID
, XNES.SOURCE_NAME
, NULL
, NULL
, NULL
, NULL
, XNEH.GHG_ORGANIZATION_ID
, XNF.GHG_ORGANIZATION_CODE
, XNEH.TRANSACTION_TYPE_LOOKUP_CODE
, XNLV.MEANING
, XNEH.USAGE_QUANTITY
, XNEH.UNIT_OF_MEASURE
, XNEH.UOM_CONVERSION
, XNEH.EMISSION_QUANTITY
, XNEH.ENERGY_QUANTITY
, XNEH.TRANSACTION_DATE_FROM
, XNEH.TRANSACTION_DATE_TO
, XNEH.DESCRIPTION
, XNEH.ORG_ID
, XNEH.SET_OF_BOOKS_ID
, XNEH.INVOICE_ID
, AI.INVOICE_NUM
, XNEH.TRANSACTION_LINE_NUMBER
, XNEH.DISTRIBUTION_LINE_NUMBER
, XNEH.INVOICE_LINE_NUMBER
, XNEH.VENDOR_ID
, PV.VENDOR_NAME
, XNEH.VENDOR_SITE_ID
, PVS.VENDOR_SITE_CODE
, XNEH.ATTRIBUTE1
, XNEH.ATTRIBUTE2
, XNEH.ATTRIBUTE3
, XNEH.ATTRIBUTE4
, XNEH.ATTRIBUTE5
, XNEH.ATTRIBUTE6
, XNEH.ATTRIBUTE7
, XNEH.ATTRIBUTE8
, XNEH.ATTRIBUTE9
, XNEH.ATTRIBUTE10
, XNEH.ATTRIBUTE11
, XNEH.ATTRIBUTE12
, XNEH.ATTRIBUTE13
, XNEH.ATTRIBUTE14
, XNEH.ATTRIBUTE15
, XNEH.ATTRIBUTE16
, XNEH.ATTRIBUTE17
, XNEH.ATTRIBUTE18
, XNEH.ATTRIBUTE19
, XNEH.ATTRIBUTE20
, XNEH.ATTRIBUTE_CATEGORY
, XNEH.CREATED_BY
, XNEH.CREATION_DATE
, XNEH.LAST_UPDATED_BY
, XNEH.LAST_UPDATE_DATE
, XNEH.LAST_UPDATE_LOGIN
FROM GHG_TRANSACTIONS_HISTORY XNEH
, GHG_SOURCES XNES
, GHG_ORGANIZATIONS_ALL XNF
, PO_VENDORS PV
, PO_VENDOR_SITES_ALL PVS
, AP_INVOICES_ALL AI
, FND_LOOKUP_VALUES XNLV
WHERE XNEH.TRANSACTION_SOURCE_ID = XNES.SOURCE_ID
AND XNF.GHG_ORGANIZATION_ID = XNEH.GHG_ORGANIZATION_ID
AND PV.VENDOR_ID(+) = XNEH.VENDOR_ID
AND PVS.VENDOR_SITE_ID(+) = XNEH.VENDOR_SITE_ID
AND AI.INVOICE_ID(+) = XNEH.INVOICE_ID
AND DECODE(XNEH.TRANSACTION_TYPE_LOOKUP_CODE
, NULL
, 'GHG_EMISSION_TYPE'
, XNLV.LOOKUP_TYPE) = 'GHG_EMISSION_TYPE'
AND XNLV.LOOKUP_CODE(+) = XNEH.TRANSACTION_TYPE_LOOKUP_CODE
AND XNLV.LANGUAGE =USERENV('LANG')