[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

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