VIEW: APPS.GHG_TRANSACTION_BATCHES_V

Source

View Text - Preformatted

SELECT xneb.rowid row_id, xneb.TRANSACTION_BATCH_ID, xneb.TRANSACTION_BATCH_NUMBER, xneb.batch_type, xneb.batch_sub_type, xneb.vendor_id, pv.vendor_name, pv.segment1, xneb.vendor_site_id, pvs.vendor_site_code, xneb.description, xneb.status, xnlv.meaning, xneb.reversal_date, xneb.reversed_transaction_batch_id, xneb.org_id, xneb.set_of_books_id, xneb.created_by, fu.user_name, xneb.creation_date, xneb.last_updated_by, xneb.last_update_date, xneb.last_update_login FROM GHG_TRANSACTION_BATCHES xneb, po_vendors pv, po_vendor_sites pvs, FND_lookup_values xnlv, fnd_user fu WHERE pv.vendor_id(+) = xneb.vendor_id AND pvs.vendor_site_id(+) = xneb.vendor_site_id AND xnlv.lookup_type = 'GHG_EMISSION_BATCH_STATUS' AND xnlv.lookup_code = xneb.status AND fu.user_id = xneb.created_by AND xnlv.LANGUAGE = USERENV('LANG')

View Text - HTML Formatted

SELECT XNEB.ROWID ROW_ID
, XNEB.TRANSACTION_BATCH_ID
, XNEB.TRANSACTION_BATCH_NUMBER
, XNEB.BATCH_TYPE
, XNEB.BATCH_SUB_TYPE
, XNEB.VENDOR_ID
, PV.VENDOR_NAME
, PV.SEGMENT1
, XNEB.VENDOR_SITE_ID
, PVS.VENDOR_SITE_CODE
, XNEB.DESCRIPTION
, XNEB.STATUS
, XNLV.MEANING
, XNEB.REVERSAL_DATE
, XNEB.REVERSED_TRANSACTION_BATCH_ID
, XNEB.ORG_ID
, XNEB.SET_OF_BOOKS_ID
, XNEB.CREATED_BY
, FU.USER_NAME
, XNEB.CREATION_DATE
, XNEB.LAST_UPDATED_BY
, XNEB.LAST_UPDATE_DATE
, XNEB.LAST_UPDATE_LOGIN
FROM GHG_TRANSACTION_BATCHES XNEB
, PO_VENDORS PV
, PO_VENDOR_SITES PVS
, FND_LOOKUP_VALUES XNLV
, FND_USER FU
WHERE PV.VENDOR_ID(+) = XNEB.VENDOR_ID
AND PVS.VENDOR_SITE_ID(+) = XNEB.VENDOR_SITE_ID
AND XNLV.LOOKUP_TYPE = 'GHG_EMISSION_BATCH_STATUS'
AND XNLV.LOOKUP_CODE = XNEB.STATUS
AND FU.USER_ID = XNEB.CREATED_BY
AND XNLV.LANGUAGE = USERENV('LANG')