eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: GHG.GHG_TRANSACTIONS_D_TMP

Object Details

Object Name:	GHG_TRANSACTIONS_D_TMP
Object Type:	TABLE
Owner:	GHG
FND Design Data:	GHG.GHG_TRANSACTIONS_D_TMP
Subobject Name:
Status:	VALID

Temporary Table Details

GHG.GHG_TRANSACTIONS_D_TMP is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$TRANSACTION. Data is removed at the end of this period.

Storage Details

Tablespace:
PCT Free:	10
PCT Used:	40

Columns

Name	Datatype	Length	Mandatory
SOURCE_APPLICATION_CODE	VARCHAR2	(10)	Yes
TRANSACTION_ID	NUMBER		Yes
TRANSACTION_EXTERNAL_ID	VARCHAR2	(240)
DOCUMENT_TYPE	VARCHAR2	(30)
DOCUMENT_TYPE_DESCRIPTION	VARCHAR2	(100)
DOCUMENT_IDENTIFIER1	VARCHAR2	(100)
DOCUMENT_IDENTIFIER2	VARCHAR2	(100)
DOCUMENT_IDENTIFIER3	VARCHAR2	(100)
DOCUMENT_IDENTIFIER4	VARCHAR2	(100)
DOCUMENT_IDENTIFIER5	VARCHAR2	(100)
DOCUMENT_IDENTIFIER6	VARCHAR2	(100)
TRANSACTION_DATE	DATE		Yes
TRANSACTION_VALUE	NUMBER	(22)
TRANSACTION_CURRENCY_CODE	VARCHAR2	(30)
TRANSACTION_CURRENCY_DESC	VARCHAR2	(100)
EMISSION_SOURCE_ID	NUMBER		Yes
EMISSION_SOURCE_USAGE_QUANTITY	NUMBER	(22)	Yes
EMISSION_SOURCE_USAGE_UOM	VARCHAR2	(30)	Yes
EMISSION_SCOPE_ID	NUMBER
ENERGY_TYPE	VARCHAR2	(30)	Yes
ENERGY_QUANTITY	NUMBER	(22)	Yes
ENERGY_UOM	VARCHAR2	(30)	Yes
CO2_E_QUANTITY	NUMBER	(22)	Yes
CO2_E_UOM	VARCHAR2	(30)	Yes
INFORMATION_LINE1	VARCHAR2	(100)
INFORMATION_LINE2	VARCHAR2	(100)
INFORMATION_LINE3	VARCHAR2	(100)
INFORMATION_LINE4	VARCHAR2	(100)
INFORMATION_LINE5	VARCHAR2	(100)
INFORMATION_LINE6	VARCHAR2	(100)
GHG_ASSET_ID	NUMBER
SUPPLIER_ID	NUMBER
SUBCONTRACTOR_ID	NUMBER
ITEM_ID	NUMBER
ACTUAL_OR_ESTIMATE	VARCHAR2	(2)	Yes
LOCATION_STATE	VARCHAR2	(240)
LOCATION_COUNTY	VARCHAR2	(240)
ORGANIZATION_ID	NUMBER
ORGANIZATION_EXTERNAL_ID	VARCHAR2	(100)
JDE_BUSINESS_UNIT_ORG_ID	NUMBER
BUSINESS_UNIT_CODE	VARCHAR2	(5)
OPERATING_UNIT_CODE	VARCHAR2	(8)
JOURNAL_ID	VARCHAR2	(10)
JOURNAL_LINE	VARCHAR2	(9)
JOURNAL_DATE	DATE
LEDGER_CODE	VARCHAR2	(10)
LEDGER_GROUP	VARCHAR2	(10)
FISCAL_YEAR	NUMBER
ACCOUNTING_PERIOD	NUMBER
DEPARTMENT_ID_CODE	VARCHAR2	(10)
PROJECT_CODE	VARCHAR2	(30)
PROJECT_DESCRIPTION	VARCHAR2	(240)
PRODUCT_CODE	VARCHAR2	(6)
PRODUCTION_DESCRIPTION	VARCHAR2	(100)
JOURNAL_DESCRIPTION	VARCHAR2	(254)
MEASUREMENT_CRITERIA_CODE	VARCHAR2	(30)
MEASUREMENT_CRITERIA_DESC	VARCHAR2	(100)
BUDG_FORE_SCEN_NAME	VARCHAR2	(100)
LEDGER_TYPE_CODE	VARCHAR2	(30)
LEDGER_TYPE_DESC	VARCHAR2	(100)
ENTERED_USAGE_QUANTITY	NUMBER	(22)
ENTERED_USAGE_UOM	VARCHAR2	(30)

Query Text

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


SELECT SOURCE_APPLICATION_CODE
,      TRANSACTION_ID
,      TRANSACTION_EXTERNAL_ID
,      DOCUMENT_TYPE
,      DOCUMENT_TYPE_DESCRIPTION
,      DOCUMENT_IDENTIFIER1
,      DOCUMENT_IDENTIFIER2
,      DOCUMENT_IDENTIFIER3
,      DOCUMENT_IDENTIFIER4
,      DOCUMENT_IDENTIFIER5
,      DOCUMENT_IDENTIFIER6
,      TRANSACTION_DATE
,      TRANSACTION_VALUE
,      TRANSACTION_CURRENCY_CODE
,      TRANSACTION_CURRENCY_DESC
,      EMISSION_SOURCE_ID
,      EMISSION_SOURCE_USAGE_QUANTITY
,      EMISSION_SOURCE_USAGE_UOM
,      EMISSION_SCOPE_ID
,      ENERGY_TYPE
,      ENERGY_QUANTITY
,      ENERGY_UOM
,      CO2_E_QUANTITY
,      CO2_E_UOM
,      INFORMATION_LINE1
,      INFORMATION_LINE2
,      INFORMATION_LINE3
,      INFORMATION_LINE4
,      INFORMATION_LINE5
,      INFORMATION_LINE6
,      GHG_ASSET_ID
,      SUPPLIER_ID
,      SUBCONTRACTOR_ID
,      ITEM_ID
,      ACTUAL_OR_ESTIMATE
,      LOCATION_STATE
,      LOCATION_COUNTY
,      ORGANIZATION_ID
,      ORGANIZATION_EXTERNAL_ID
,      JDE_BUSINESS_UNIT_ORG_ID
,      BUSINESS_UNIT_CODE
,      OPERATING_UNIT_CODE
,      JOURNAL_ID
,      JOURNAL_LINE
,      JOURNAL_DATE
,      LEDGER_CODE
,      LEDGER_GROUP
,      FISCAL_YEAR
,      ACCOUNTING_PERIOD
,      DEPARTMENT_ID_CODE
,      PROJECT_CODE
,      PROJECT_DESCRIPTION
,      PRODUCT_CODE
,      PRODUCTION_DESCRIPTION
,      JOURNAL_DESCRIPTION
,      MEASUREMENT_CRITERIA_CODE
,      MEASUREMENT_CRITERIA_DESC
,      BUDG_FORE_SCEN_NAME
,      LEDGER_TYPE_CODE
,      LEDGER_TYPE_DESC
,      ENTERED_USAGE_QUANTITY
,      ENTERED_USAGE_UOM
FROM GHG.GHG_TRANSACTIONS_D_TMP;

Dependencies

[top of page]

GHG.GHG_TRANSACTIONS_D_TMP does not reference any database object

GHG.GHG_TRANSACTIONS_D_TMP is referenced by following:

APPS: GHG_TRANSACTIONS_D_TMP