[Home] [Help] [Dependency Information]
Object Name: | GHG_TRANSACTIONS_D_TMP |
---|---|
Object Type: | TABLE |
Owner: | GHG |
FND Design Data: | GHG.GHG_TRANSACTIONS_D_TMP |
Subobject Name: | |
Status: | VALID |
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.
Tablespace: | |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
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) |
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;
GHG.GHG_TRANSACTIONS_D_TMP does not reference any database object
GHG.GHG_TRANSACTIONS_D_TMP is referenced by following:
|
|
|