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


TABLE: GHG.GHG_TRANSACTIONS_ALL

Object Details
Object Name: GHG_TRANSACTIONS_ALL
Object Type: TABLE
Owner: GHG
FND Design Data: TableGHG.GHG_TRANSACTIONS_ALL
Subobject Name:
Status: VALID


This table stores the transactions created for GHG


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
GHG_TRANSACTIONS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnTRANSACTION_ID
GHG_TRANSACTIONS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnINVOICE_ID
GHG_TRANSACTIONS_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnVENDOR_ID
ColumnVENDOR_SITE_ID
GHG_TRANSACTIONS_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnGHG_ORGANIZATION_ID
GHG_TRANSACTIONS_N4 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnORG_ID
GHG_TRANSACTIONS_N5 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnTRANSACTION_BATCH_ID
Columns
Name Datatype Length Mandatory Comments
TXN_TYPE_LOOKUP_CODE VARCHAR2 (20) Yes Txn Type Lookup Code
TRANSACTION_ID NUMBER (15) Yes Transaction Identifier
TRANSACTION_BATCH_ID NUMBER (15)
Transaction Batch Identifier
TRANSACTION_SOURCE_ID NUMBER (15)
Transaction Source Identifier
GHG_ORGANIZATION_ID NUMBER (15) Yes GHG Organization Identifier
MAPPING_ID NUMBER (15)
Mapping Identifier
TRANSACTION_TYPE_LOOKUP_CODE VARCHAR2 (1)
Transaction Type Lookup Code
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
TRANSACTION_LINE_NUMBER NUMBER (15)
Transaction Line Number
DISTRIBUTION_LINE_NUMBER NUMBER (15)
Distribution Line Number
VENDOR_ID NUMBER (15)
Vendor Identifier
VENDOR_SITE_ID NUMBER (15)
Vendor Site Identifier
INVENTORY_ITEM_ID NUMBER (15)
Inventory Item Identifier
GHG_ASSET_ID NUMBER (15)
GHG Asset Identifier
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
INVOICE_LINE_NUMBER NUMBER

Invoice Line Number
LOCATION_CODE VARCHAR2 (20)
Location Code
EMISSION_SCOPE_LOOKUP_CODE VARCHAR2 (20)
Emission Scope Lookup Code
MEASUREMENT_CRITERIA VARCHAR2 (15)
Measurement Criteria
Query Text

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


SELECT TXN_TYPE_LOOKUP_CODE
,      TRANSACTION_ID
,      TRANSACTION_BATCH_ID
,      TRANSACTION_SOURCE_ID
,      GHG_ORGANIZATION_ID
,      MAPPING_ID
,      TRANSACTION_TYPE_LOOKUP_CODE
,      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
,      TRANSACTION_LINE_NUMBER
,      DISTRIBUTION_LINE_NUMBER
,      VENDOR_ID
,      VENDOR_SITE_ID
,      INVENTORY_ITEM_ID
,      GHG_ASSET_ID
,      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
,      INVOICE_LINE_NUMBER
,      LOCATION_CODE
,      EMISSION_SCOPE_LOOKUP_CODE
,      MEASUREMENT_CRITERIA
FROM GHG.GHG_TRANSACTIONS_ALL;

Dependencies

[top of page]

GHG.GHG_TRANSACTIONS_ALL does not reference any database object

GHG.GHG_TRANSACTIONS_ALL is referenced by following:

SchemaGHG
ViewGHG_TRANSACTIONS_ALL#