DBA Data[Home] [Help] [Dependency Information]


VIEW: APPS.GHG_TRANSACTIONS_HISTORY_V

Object Details
Object Name: GHG_TRANSACTIONS_HISTORY_V
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


This view stores information about transaction history


[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Row Identifier
TXN_TYPE_LOOKUP_CODE VARCHAR2 (20) Yes Txn Type Lookup Code
TRANSACTION_ID NUMBER (15) Yes Transaction Identifier
TRANSACTION_VERSION NUMBER (15) Yes Transaction Version
SOURCE_ID NUMBER (15) Yes Source Identifier
SOURCE_NAME VARCHAR2 (240) Yes Source Name
EMISSION_SCOPE_LOOKUP_CODE VARCHAR2 (0)
Emission Scope Lookup Code
LOCATION_CODE VARCHAR2 (0)
Location Code
EMISSION_FACTOR VARCHAR2 (0)
Emission Factor
EMISSION_ENERGY VARCHAR2 (0)
Emission Energy
GHG_ORGANIZATION_ID NUMBER (15) Yes GHG Organization Identifier
GHG_ORGANIZATION_CODE VARCHAR2 (240)
GHG Organization Code
TRANSACTION_TYPE_LOOKUP_CODE VARCHAR2 (1)
Transaction Type Lookup Code
EMISSION_TYPE_MEANING VARCHAR2 (80)
Emission Type Meaning
USAGE_QUANTITY NUMBER

Usage Quantity
UNIT_OF_MEASURE VARCHAR2 (25) Yes Unit Of Measure
UOM_CONVERSION NUMBER
Yes Unit Of Measure Conversion
EMISSION_QUANTITY NUMBER

Emission Quantity
ENERGY_QUANTITY NUMBER

Energy Quantity
TRANSACTION_DATE_FROM DATE
Yes Transaction From Date
TRANSACTION_DATE_TO DATE
Yes Transaction To Date
DESCRIPTION VARCHAR2 (240)
Description
ORG_ID NUMBER (15) Yes Organization Identifier
SET_OF_BOOKS_ID NUMBER (15) Yes Set Of Books Identifier
INVOICE_ID NUMBER (15)
Invoice Identifier
INVOICE_NUM VARCHAR2 (50)
Invoice Number
DISTRIBUTION_LINE_NUMBER NUMBER (15)
Distribution Line Number
TRANSACTION_LINE_NUMBER NUMBER (15)
Transaction Line Number
INVOICE_LINE_NUMBER NUMBER

Invoice Line Number
VENDOR_ID NUMBER (15)
Vendor Identifier
VENDOR_NAME VARCHAR2 (240)
Vendor Name
VENDOR_SITE_ID NUMBER (15)
Vendor Site Identifier
VENDOR_SITE_CODE VARCHAR2 (15)
Vendor Site Code
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield Segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield Segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield Segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield Segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield Segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield Segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield Segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield Segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield Segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield Segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield Segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield Segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield Segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield Segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield Segment
ATTRIBUTE16 VARCHAR2 (150)
Descriptive Flexfield Segment
ATTRIBUTE17 VARCHAR2 (150)
Descriptive Flexfield Segment
ATTRIBUTE18 VARCHAR2 (150)
Descriptive Flexfield Segment
ATTRIBUTE19 VARCHAR2 (150)
Descriptive Flexfield Segment
ATTRIBUTE20 VARCHAR2 (150)
Descriptive Flexfield Segment
ATTRIBUTE_CATEGORY VARCHAR2 (150)
Attribute Category
CREATED_BY NUMBER (15)
Standard Who Column
CREATION_DATE DATE

Standard Who Column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who Column
LAST_UPDATE_DATE DATE
Yes Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ROW_ID
,      TXN_TYPE_LOOKUP_CODE
,      TRANSACTION_ID
,      TRANSACTION_VERSION
,      SOURCE_ID
,      SOURCE_NAME
,      EMISSION_SCOPE_LOOKUP_CODE
,      LOCATION_CODE
,      EMISSION_FACTOR
,      EMISSION_ENERGY
,      GHG_ORGANIZATION_ID
,      GHG_ORGANIZATION_CODE
,      TRANSACTION_TYPE_LOOKUP_CODE
,      EMISSION_TYPE_MEANING
,      USAGE_QUANTITY
,      UNIT_OF_MEASURE
,      UOM_CONVERSION
,      EMISSION_QUANTITY
,      ENERGY_QUANTITY
,      TRANSACTION_DATE_FROM
,      TRANSACTION_DATE_TO
,      DESCRIPTION
,      ORG_ID
,      SET_OF_BOOKS_ID
,      INVOICE_ID
,      INVOICE_NUM
,      DISTRIBUTION_LINE_NUMBER
,      TRANSACTION_LINE_NUMBER
,      INVOICE_LINE_NUMBER
,      VENDOR_ID
,      VENDOR_NAME
,      VENDOR_SITE_ID
,      VENDOR_SITE_CODE
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      ATTRIBUTE_CATEGORY
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM APPS.GHG_TRANSACTIONS_HISTORY_V;

Dependencies

[top of page]

APPS.GHG_TRANSACTIONS_HISTORY_V references the following:

SchemaAPPS
SynonymAP_INVOICES_ALL
PL/SQL PackageFND_GLOBAL - show dependent code
SynonymFND_LOOKUP_VALUES
SynonymGHG_ORGANIZATIONS_ALL
SynonymGHG_SOURCES
SynonymGHG_TRANSACTIONS_HISTORY
ViewPO_VENDORS
ViewPO_VENDOR_SITES_ALL
APPS.GHG_TRANSACTIONS_HISTORY_V is referenced by following:

SchemaAPPS
Package BodyGHG_PO_EMISSIONS_PKG - show dependent code