This Technical Reference Manual (TRM) in any form, software or printed matter, contains proprietary information of Oracle ; it is provided under an Oracle agreement containing restrictions on use and disclosure and is also protected by copyright, patent, and other intellectual property law. Restrictions applicable to this TRM include, but are not limited to: (a) exercising either the same degree of care to safeguard the confidentiality of this TRM as you exercise to safeguard the confidentiality of your own most important Confidential Information or a reasonable degree of care, whichever is greater; (b) maintaining agreements with your employees and agents that protect the Confidential Information of third parties such as Oracle and instructing such employees and agents of these requirements for this TRM; (c) restricting disclosure of this TRM to those of your employees who have a 'need to know' consistent with the purposes for which this TRM was disclosed to you; (d) maintaining this TRM at all times on your premises; (e) not removing or destroying any proprietary or confidential legends or markings placed upon this TRM in whatever form, software or printed matter; and (f) not reproducing or transmitting this TRM in any form or by any means, electronic or mechanical, for any purpose, without the express written permission of Oracle. You should not use this TRM in any form, software or printed matter, to create software that performs the same or similar functions as any Oracle products.
The information in this TRM is subject to change without notice. If you find any problems in the TRM in any form, software or printed matter, please report them to us in writing. Oracle does not warrant that this TRM is error free. This TRM is provided to customer 'as is' with no warranty of any kind. This TRM does not constitute Documentation as that term is defined in Oracle's agreements. Reverse engineering of the Programs (software and documentation) associated with this TRM are prohibited. The Programs associated with this TRM are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently dangerous applications. It shall be licensee's responsibility to take all appropriate fail safe, backup, redundancy and other measures to ensure the safe use of such applications if the Programs are used for such purposes, and Oracle disclaims liability for any damages caused by such use of the Programs. Program Documentation is licensed for use solely to support the deployment of the Programs and not for any other any other purpose. Restricted Rights Legend
This TRM and the Programs associated with this TRM delivered subject to the DOD FAR Supplement are 'commercial computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement. Otherwise, this TRM and the Programs associated with this TRM delivered subject to the Federal Acquisition Regulations are 'restricted computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the restrictions in FAR 52.227-14, Rights in Data General, including Alternate III (June 1987). Oracle, 500 Oracle Parkway, Redwood City, CA 94065.
Oracle is a registered trademark. AIM Advantage™, Big Business. Small Business. All Business.™, CDM Advantage™, .comference™, ConText®, Des40®, Easy*Query™, Easy*SQL®, Education Objects™, EMM Advantage™, Enabling the Information Age®, ExpertDetectSM, Express®, FastForwardSM, GEMMS®, Gist™, Hyper*SQL™, instantOracle™, "Internet Business Intelligence - Insight for Everyone"™, iSQL*Plus™, JInitiator™, NLS*Workbench®, Object Marketplace™, ODP Pulse™, ODP Techwire™, OLA™, On Oracle™, Oracle®, Oracle Book®, Oracle Bookbatch®, Oracle BookBuilder®, OracleBRONZE®, Oracle Business OnLine®, OracleDevConnectSM, Oracle® Discoverer™, Oracle® Expert™, Oracle Financials®, OracleGOLDSM, OracleIncidentSM, OracleJSP™, OracleLifeCycleSM, Oracle Media Objects®, OracleMERCURYSM, OracleMetaLinkSM, OraclemetalsSM, OracleMobile™, Oracle Names®, Oracle NetSolutions®, Oracle® One™, Oracle Open Gateways®, Oracle OpenWorld®, OraclePLATINUMSM, Oracle Power Objects®, Oracle Press®, Oracle Procedural Gateway®, Oracle Quality®, Oracle Secure Network Services®, OracleSILVERSM, Oracle® SQL/Services™, Oracle® SQL*TutorSM, OracleSTERLINGSM, Oracle Store®, Oracle Transparent Gateway®, OracleWare®, Oracle8i™, Oracle9i™, PC Express®, Personal Express®, PJM Advantage™, PL/SQL™, Pro*Ada®, Pro*C™, Pro*C/C++™, Pro*COBOL®, Pro*FORTRAN®, Pro*Pascal®, Pro*PL/1®, Pro*REXX®, Profit™, ProREXX™, Report Card™, Secure Access 2.0™, Secure Network Services®, Security Without Compromise™, SellingPoint®, SQL*Plus®, Tutor™ are trademarks or registered trademarks of Oracle. Other names may be trademarks of their respective owners. The absence of a product or service name, slogan, or logo from this list does not constitute a waiver of Oracle's trademark or other intellectual property rights concerning that name, slogan, or logo.
| Description: |
|---|
This table stores asset information
| Index | Type | Tablespace | Column |
|---|---|---|---|
| GHG_ASSETS_U1 | UNIQUE | APPS_TS_TX_IDX | GHG_ASSET_ID |
| GHG_ASSETS_N1 | NONUNIQUE | APPS_TS_TX_IDX | ASSET_ID |
| GHG_ASSETS_N2 | NONUNIQUE | APPS_TS_TX_IDX |
ASSET_NUMBER
BOOK_TYPE_CODE |
| GHG_ASSETS_N3 | NONUNIQUE | APPS_TS_TX_IDX |
VENDOR_ID
VENDOR_SITE_ID |
| GHG_ASSETS_N4 | NONUNIQUE | APPS_TS_TX_IDX | ASSET_TYPE_LOOKUP_CODE |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| GHG_ASSET_ID | NUMBER | (15) | Y | GHG Asset Identifier |
| ASSET_ID | NUMBER | (15) | Asset Identifier | |
| ASSET_TYPE_LOOKUP_CODE | VARCHAR2 | (30) | Y | Asset Type Lookup Code |
| BOOK_TYPE_CODE | VARCHAR2 | (15) | Book Type Code | |
| ASSET_NUMBER | VARCHAR2 | (15) | Y | Asset Number |
| TAG_NUMBER | VARCHAR2 | (15) | Tag Number | |
| SERIAL_NUMBER | VARCHAR2 | (35) | Serial Number | |
| TRANSPORT_TYPE_LOOKUP_CODE | VARCHAR2 | (30) | Y | Transport Type Lookup Code |
| VENDOR_ID | NUMBER | (15) | Vendor Identifier | |
| VENDOR_SITE_ID | NUMBER | (15) | Vendor Site Identifier | |
| START_DATE | DATE | Y | Start Date | |
| END_DATE | DATE | End Date | ||
| CREATED_BY | NUMBER | (15) | Standard Who Column | |
| CREATION_DATE | DATE | Standard Who Column | ||
| LAST_UPDATED_BY | NUMBER | (15) | Y | Standard Who Column |
| LAST_UPDATE_DATE | DATE | Y | Standard Who Column | |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who Column | |
| GHG_ORGANIZATION_ID | NUMBER | GHG Organization Identifier | ||
| DESCRIPTION#1 | VARCHAR2 | (240) | Description for Editioning View |
GHG.GHG_ASSETS does not reference any database object
GHG.GHG_ASSETS is referenced by following:
| Description: |
|---|
This table stores the emission formulas created
| Index | Type | Tablespace | Column |
|---|---|---|---|
| SYS_IL0000521576C00003$$ | UNIQUE | APPS_TS_TX_DATA |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| FORMULA_ID | NUMBER | Y | Formula Identifier | |
| DESCRIPTION | VARCHAR2 | (100) | Description | |
| FORMULA_CONTENT | CLOB | (4000) | Y | Formula Content |
| ORG_ID | NUMBER | Y | Organization Identifier | |
| SECONDARY_FORMULA_ID | NUMBER | Secondary Formula Identifier |
GHG.GHG_EMISSION_FORMULAS_ALL does not reference any database object
GHG.GHG_EMISSION_FORMULAS_ALL is referenced by following:
| Description: |
|---|
This table stores the conversion factor related information
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| SOURCE_COMBINATION_ID | NUMBER | Y | Source Combination Identifier | |
| GAS_TYPE_LOOKUP_CODE | VARCHAR2 | (20) | Y | Gas Type Lookup Code |
| FACTOR_TYPE | VARCHAR2 | (1) | Y | Factor Type |
| FACTOR_VALUE | NUMBER | Y | Factor Value | |
| CREATED_BY | NUMBER | Standard Who Column | ||
| CREATION_DATE | DATE | Standard Who Column | ||
| LAST_UPDATED_BY | NUMBER | Standard Who Column | ||
| LAST_UPDATE_DATE | DATE | Standard Who Column | ||
| LAST_UPDATE_LOGIN | NUMBER | Standard Who Column | ||
| EFFECTIVE_START_DATE | DATE | Effective Start Date | ||
| EFFECTIVE_END_DATE | DATE | Effective End Date | ||
| ORG_ID | NUMBER | (15) | Y | Organization Identifier |
GHG.GHG_FACTORS_ALL does not reference any database object
GHG.GHG_FACTORS_ALL is referenced by following:
| Description: |
|---|
This table stores the customer information
| Index | Type | Tablespace | Column |
|---|---|---|---|
| GHG_INTERESTED_PARTIES_U1 | UNIQUE | APPS_TS_TX_IDX | INTERESTED_PARTY_ID |
| GHG_INTERESTED_PARTIES_N1 | NONUNIQUE | APPS_TS_TX_IDX | GHG_ORGANIZATION_ID |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| INTERESTED_PARTY_ID | NUMBER | (15) | Y | Interested Party Identifier |
| GHG_ORGANIZATION_ID | NUMBER | (15) | Y | GHG Organization Identifier |
| CONTROLLING_ORGANIZATION_ID | VARCHAR2 | (25) | Controlling Organization Identifier | |
| OPERATIONAL_CONTROL | VARCHAR2 | (25) | Y | Operational Control |
| EQUITY_SHARE | VARCHAR2 | (10) | Equity Share | |
| START_DATE | DATE | Y | Start Date | |
| END_DATE | DATE | End Date | ||
| ORG_ID | NUMBER | (15) | Y | Organization Identifier |
| SET_OF_BOOKS_ID | NUMBER | (15) | Y | Set Of Books Identifier |
| CREATED_BY | NUMBER | (15) | Standard Who Column | |
| CREATION_DATE | DATE | Standard Who Column | ||
| LAST_UPDATED_BY | NUMBER | (15) | Y | Standard Who Column |
| LAST_UPDATE_DATE | DATE | Y | Standard Who Column | |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who Column |
GHG.GHG_INTERESTED_PARTIES_ALL does not reference any database object
GHG.GHG_INTERESTED_PARTIES_ALL is referenced by following:
| Description: |
|---|
This table stores the KPI component related information
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| KPI_ID | NUMBER | Y | KPI Identifier | |
| SOURCE_ID | NUMBER | Y | Source Identifier | |
| COMPONENT_TYPE | VARCHAR2 | (1) | Component Type |
GHG.GHG_KPI_COMPONENTS does not reference any database object
GHG.GHG_KPI_COMPONENTS is referenced by following:
| Description: |
|---|
This table stores the KPI definitions
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| KPI_ID | NUMBER | Y | KPI Identifier | |
| KPI_CODE | VARCHAR2 | (60) | Y | KPI Code |
| DESCRIPTION | VARCHAR2 | (255) | Description | |
| NUM_TYPE | VARCHAR2 | (50) | Y | Numerator Type |
| NUM_FUNCTION | VARCHAR2 | (25) | Y | Numerator Function |
| DEN_TYPE | VARCHAR2 | (50) | Y | Denominator Type |
| DEN_FUNCTION | VARCHAR2 | (25) | Y | Denominator Function |
| CREATED_BY | NUMBER | Standard Who Column | ||
| CREATION_DATE | DATE | Standard Who Column | ||
| LAST_UPDATED_BY | NUMBER | Y | Standard Who Column | |
| LAST_UPDATE_DATE | DATE | Y | Standard Who Column | |
| LAST_UPDATE_LOGIN | NUMBER | Standard Who Column | ||
| ORG_ID | NUMBER | Organization Identifier | ||
| NUM_UOM_CLASS_CODE#1 | VARCHAR2 | (100) | Numerator UOM Classification Code | |
| DEN_UOM_CLASS_CODE#1 | VARCHAR2 | (100) | Denominator UOM Classification Code |
GHG.GHG_KPI_DEFINITIONS_ALL does not reference any database object
GHG.GHG_KPI_DEFINITIONS_ALL is referenced by following:
| Description: |
|---|
This table stores the organizations created
| Index | Type | Tablespace | Column |
|---|---|---|---|
| GHG_ORGANIZATIONS_U1 | UNIQUE | APPS_TS_TX_IDX | GHG_ORGANIZATION_ID |
| GHG_ORGANIZATIONS_N1 | NONUNIQUE | APPS_TS_TX_IDX | ORG_ID |
| GHG_ORGANIZATIONS_N2 | NONUNIQUE | APPS_TS_TX_IDX | GHG_ORGANIZATION_CODE#1 |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| GHG_ORGANIZATION_ID | NUMBER | (15) | Y | GHG Organization Identifier |
| DESCRIPTION | VARCHAR2 | (240) | Description | |
| ORGANIZATION_SIZE_LOOKUP_CODE | VARCHAR2 | (15) | Y | Organization Size Lookup Code |
| LOCATION_ID | NUMBER | (15) | Y | Location Identifier |
| START_DATE | DATE | Y | Start Date | |
| END_DATE | DATE | End Date | ||
| 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 | |
| ORG_ID | NUMBER | (15) | Y | Organization Identifier |
| SET_OF_BOOKS_ID | NUMBER | (15) | Y | Set Of Books Identifier |
| CREATED_BY | NUMBER | (15) | Standard Who Column | |
| CREATION_DATE | DATE | Standard Who Column | ||
| LAST_UPDATED_BY | NUMBER | (15) | Y | Standard Who Column |
| LAST_UPDATE_DATE | DATE | Y | Standard Who Column | |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who Column | |
| LONGITUDE | NUMBER | (9) | Longitude | |
| LATITUDE | NUMBER | (9) | Latitude | |
| ORGANIZATION_TYPE | VARCHAR2 | (25) | Organization Type | |
| ALLOW_TRANSACTIONS | VARCHAR2 | (1) | Allow Transactions Flag | |
| CEO_NAME | VARCHAR2 | (150) | CEO Name | |
| COMPANY_IDENTIFIER | VARCHAR2 | (25) | Company Identifier | |
| GHG_ORGANIZATION_CODE#1 | VARCHAR2 | (240) | GHG Organization Code for Editioning View |
GHG.GHG_ORGANIZATIONS_ALL does not reference any database object
GHG.GHG_ORGANIZATIONS_ALL is referenced by following:
| Description: |
|---|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| SOURCE_APPLICATION_CODE | VARCHAR2 | (10) | Y | |
| ORGANIZATION_ID | NUMBER | Y | ||
| ORGANIZATION_EXTERNAL_ID | VARCHAR2 | (240) | Y | |
| ORGANIZATION_CODE | VARCHAR2 | (240) | Y | |
| ORGANIZATION_NAME | VARCHAR2 | (240) | ||
| CEO_NAME | VARCHAR2 | (240) | ||
| COMPANY_IDENTIFIER | VARCHAR2 | (240) | ||
| DATE_EFFECTIVE_FROM | DATE | |||
| DATE_EFFECTIVE_TO | DATE | |||
| SIC_GROUP_CODE | VARCHAR2 | (240) | ||
| SIC_GROUP_DESC | VARCHAR2 | (240) | ||
| SIC_DIVISION_CODE | VARCHAR2 | (240) | ||
| SIC_DIVISION_DESC | VARCHAR2 | (240) | ||
| ORGANIZATION_SIZE | VARCHAR2 | (240) | ||
| ORGANIZATION_TYPE | VARCHAR2 | (240) | ||
| ADDRESS_LINE_1 | VARCHAR2 | (240) | ||
| ADDRESS_LINE_2 | VARCHAR2 | (240) | ||
| ADDRESS_LINE_3 | VARCHAR2 | (240) | ||
| ADDRESS_LINE_4 | VARCHAR2 | (240) | ||
| ADDRESS_SUBURB | VARCHAR2 | (240) | ||
| ADDRESS_STATE | VARCHAR2 | (240) | ||
| ADDRESS_COUNTY | VARCHAR2 | (240) | ||
| ADDRESS_COUNTRY | VARCHAR2 | (240) | ||
| ADDRESS_POSTCODE | VARCHAR2 | (240) | ||
| ADDRESS_LATITUDE | VARCHAR2 | (240) | ||
| ADDRESS_LONGITUDE | VARCHAR2 | (240) | ||
| ADDRESS_LOCATION | VARCHAR2 | (240) | ||
| INFO_CODE_1 | VARCHAR2 | (240) | ||
| INFO_DESCRIPTION_1 | VARCHAR2 | (240) | ||
| INFO_CODE_2 | VARCHAR2 | (240) | ||
| INFO_DESCRIPTION_2 | VARCHAR2 | (240) | ||
| INFO_CODE_3 | VARCHAR2 | (240) | ||
| INFO_DESCRIPTION_3 | VARCHAR2 | (240) | ||
| INFO_CODE_4 | VARCHAR2 | (240) | ||
| INFO_DESCRIPTION_4 | VARCHAR2 | (240) | ||
| INFO_CODE_5 | VARCHAR2 | (240) | ||
| INFO_DESCRIPTION_5 | VARCHAR2 | (240) | ||
| INFO_CODE_6 | VARCHAR2 | (240) | ||
| INFO_DESCRIPTION_6 | VARCHAR2 | (240) | ||
| INFO_CODE_7 | VARCHAR2 | (240) | ||
| INFO_DESCRIPTION_7 | VARCHAR2 | (240) | ||
| INFO_CODE_8 | VARCHAR2 | (240) | ||
| INFO_DESCRIPTION_8 | VARCHAR2 | (240) | ||
| INFO_CODE_9 | VARCHAR2 | (240) | ||
| INFO_DESCRIPTION_9 | VARCHAR2 | (240) | ||
| INFO_CODE_10 | VARCHAR2 | (240) | ||
| INFO_DESCRIPTION_10 | VARCHAR2 | (240) | ||
| INFO_CODE_11 | VARCHAR2 | (240) | ||
| INFO_DESCRIPTION_11 | VARCHAR2 | (240) | ||
| INFO_CODE_12 | VARCHAR2 | (240) | ||
| INFO_DESCRIPTION_12 | VARCHAR2 | (240) | ||
| INFO_CODE_13 | VARCHAR2 | (240) | ||
| INFO_DESCRIPTION_13 | VARCHAR2 | (240) | ||
| INFO_CODE_14 | VARCHAR2 | (240) | ||
| INFO_DESCRIPTION_14 | VARCHAR2 | (240) | ||
| INFO_CODE_15 | VARCHAR2 | (240) | ||
| INFO_DESCRIPTION_15 | VARCHAR2 | (240) | ||
| INFO_CODE_16 | VARCHAR2 | (240) | ||
| INFO_DESCRIPTION_16 | VARCHAR2 | (240) | ||
| INFO_CODE_17 | VARCHAR2 | (240) | ||
| INFO_DESCRIPTION_17 | VARCHAR2 | (240) | ||
| INFO_CODE_18 | VARCHAR2 | (240) | ||
| INFO_DESCRIPTION_18 | VARCHAR2 | (240) | ||
| INFO_CODE_19 | VARCHAR2 | (240) | ||
| INFO_DESCRIPTION_19 | VARCHAR2 | (240) | ||
| INFO_CODE_20 | VARCHAR2 | (240) | ||
| INFO_DESCRIPTION_20 | VARCHAR2 | (240) | ||
| INFO_CODE_21 | VARCHAR2 | (240) | ||
| INFO_DESCRIPTION_21 | VARCHAR2 | (240) | ||
| INFO_CODE_22 | VARCHAR2 | (240) | ||
| INFO_DESCRIPTION_22 | VARCHAR2 | (240) | ||
| INFO_CODE_23 | VARCHAR2 | (240) | ||
| INFO_DESCRIPTION_23 | VARCHAR2 | (240) | ||
| INFO_CODE_24 | VARCHAR2 | (240) | ||
| INFO_DESCRIPTION_24 | VARCHAR2 | (240) | ||
| INFO_CODE_25 | VARCHAR2 | (240) | ||
| INFO_DESCRIPTION_25 | VARCHAR2 | (240) | ||
| INFO_CODE_26 | VARCHAR2 | (240) | ||
| INFO_DESCRIPTION_26 | VARCHAR2 | (240) | ||
| INFO_CODE_27 | VARCHAR2 | (240) | ||
| INFO_DESCRIPTION_27 | VARCHAR2 | (240) | ||
| INFO_CODE_28 | VARCHAR2 | (240) | ||
| INFO_DESCRIPTION_28 | VARCHAR2 | (240) | ||
| INFO_CODE_29 | VARCHAR2 | (240) | ||
| INFO_DESCRIPTION_29 | VARCHAR2 | (240) | ||
| INFO_CODE_30 | VARCHAR2 | (240) | ||
| INFO_DESCRIPTION_30 | VARCHAR2 | (240) |
GHG.GHG_ORGANIZATIONS_D_TMP does not reference any database object
GHG.GHG_ORGANIZATIONS_D_TMP is referenced by following:
| Description: |
|---|
This table stores the org account mapping details
| Index | Type | Tablespace | Column |
|---|---|---|---|
| GHG_ORG_ACCOUNT_MAPPINGS_U1 | UNIQUE | APPS_TS_TX_IDX | ACCOUNT_MAPPING_ID |
| GHG_ORG_ACCOUNT_MAPPINGS_N1 | NONUNIQUE | APPS_TS_TX_IDX |
GHG_ORGANIZATION_ID
ORG_ID |
| GHG_ORG_ACCOUNT_MAPPINGS_N2 | NONUNIQUE | APPS_TS_TX_IDX | ORG_ID |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ACCOUNT_MAPPING_ID | NUMBER | (15) | Y | Accounting Mapping Identifier |
| GHG_ORGANIZATION_ID | NUMBER | (15) | Y | GHG Organization Identifier |
| SEGMENT1_LOW | VARCHAR2 | (25) | Segment 1 Low | |
| SEGMENT1_HIGH | VARCHAR2 | (25) | Segment 1 High | |
| SEGMENT2_LOW | VARCHAR2 | (25) | Segment 2 Low | |
| SEGMENT2_HIGH | VARCHAR2 | (25) | Segment 2 High | |
| SEGMENT3_LOW | VARCHAR2 | (25) | Segment 3 Low | |
| SEGMENT3_HIGH | VARCHAR2 | (25) | Segment 3 High | |
| SEGMENT4_LOW | VARCHAR2 | (25) | Segment 4 Low | |
| SEGMENT4_HIGH | VARCHAR2 | (25) | Segment 4 High | |
| SEGMENT5_LOW | VARCHAR2 | (25) | Segment 5 Low | |
| SEGMENT5_HIGH | VARCHAR2 | (25) | Segment 5 High | |
| SEGMENT6_LOW | VARCHAR2 | (25) | Segment 6 Low | |
| SEGMENT6_HIGH | VARCHAR2 | (25) | Segment 6 High | |
| SEGMENT7_LOW | VARCHAR2 | (25) | Segment 7 Low | |
| SEGMENT7_HIGH | VARCHAR2 | (25) | Segment 7 High | |
| SEGMENT8_LOW | VARCHAR2 | (25) | Segment 8 Low | |
| SEGMENT8_HIGH | VARCHAR2 | (25) | Segment 8 High | |
| SEGMENT9_LOW | VARCHAR2 | (25) | Segment 9 Low | |
| SEGMENT9_HIGH | VARCHAR2 | (25) | Segment 9 High | |
| SEGMENT10_LOW | VARCHAR2 | (25) | Segment 10 Low | |
| SEGMENT10_HIGH | VARCHAR2 | (25) | Segment 10 High | |
| SEGMENT11_LOW | VARCHAR2 | (25) | Segment 11 Low | |
| SEGMENT11_HIGH | VARCHAR2 | (25) | Segment 11 High | |
| SEGMENT12_LOW | VARCHAR2 | (25) | Segment 12 Low | |
| SEGMENT12_HIGH | VARCHAR2 | (25) | Segment 12 High | |
| SEGMENT13_LOW | VARCHAR2 | (25) | Segment 13 Low | |
| SEGMENT13_HIGH | VARCHAR2 | (25) | Segment 13 High | |
| SEGMENT14_LOW | VARCHAR2 | (25) | Segment 14 Low | |
| SEGMENT14_HIGH | VARCHAR2 | (25) | Segment 14 High | |
| SEGMENT15_LOW | VARCHAR2 | (25) | Segment 15 Low | |
| SEGMENT15_HIGH | VARCHAR2 | (25) | Segment 15 High | |
| SEGMENT16_LOW | VARCHAR2 | (25) | Segment 16 Low | |
| SEGMENT16_HIGH | VARCHAR2 | (25) | Segment 16 High | |
| SEGMENT17_LOW | VARCHAR2 | (25) | Segment 17 Low | |
| SEGMENT17_HIGH | VARCHAR2 | (25) | Segment 17 High | |
| SEGMENT18_LOW | VARCHAR2 | (25) | Segment 18 Low | |
| SEGMENT18_HIGH | VARCHAR2 | (25) | Segment 18 High | |
| SEGMENT19_LOW | VARCHAR2 | (25) | Segment 19 Low | |
| SEGMENT19_HIGH | VARCHAR2 | (25) | Segment 19 High | |
| SEGMENT20_LOW | VARCHAR2 | (25) | Segment 20 Low | |
| SEGMENT20_HIGH | VARCHAR2 | (25) | Segment 20 High | |
| SEGMENT21_LOW | VARCHAR2 | (25) | Segment 21 Low | |
| SEGMENT21_HIGH | VARCHAR2 | (25) | Segment 21 High | |
| SEGMENT22_LOW | VARCHAR2 | (25) | Segment 22 Low | |
| SEGMENT22_HIGH | VARCHAR2 | (25) | Segment 22 High | |
| SEGMENT23_LOW | VARCHAR2 | (25) | Segment 23 Low | |
| SEGMENT23_HIGH | VARCHAR2 | (25) | Segment 23 High | |
| SEGMENT24_LOW | VARCHAR2 | (25) | Segment 24 Low | |
| SEGMENT24_HIGH | VARCHAR2 | (25) | Segment 24 High | |
| SEGMENT25_LOW | VARCHAR2 | (25) | Segment 25 Low | |
| SEGMENT25_HIGH | VARCHAR2 | (25) | Segment 25 High | |
| SEGMENT26_LOW | VARCHAR2 | (25) | Segment 26 Low | |
| SEGMENT26_HIGH | VARCHAR2 | (25) | Segment 26 High | |
| SEGMENT27_LOW | VARCHAR2 | (25) | Segment 27 Low | |
| SEGMENT27_HIGH | VARCHAR2 | (25) | Segment 27 High | |
| SEGMENT28_LOW | VARCHAR2 | (25) | Segment 28 Low | |
| SEGMENT28_HIGH | VARCHAR2 | (25) | Segment 28 High | |
| SEGMENT29_LOW | VARCHAR2 | (25) | Segment 29 Low | |
| SEGMENT29_HIGH | VARCHAR2 | (25) | Segment 29 High | |
| SEGMENT30_LOW | VARCHAR2 | (25) | Segment 30 Low | |
| SEGMENT30_HIGH | VARCHAR2 | (25) | Segment 30 High | |
| CHART_OF_ACCOUNTS_ID | NUMBER | (10) | Y | Chart Of Accounts Identifier |
| ORG_ID | NUMBER | (15) | Y | Organization Identifier |
| SET_OF_BOOKS_ID | NUMBER | (15) | Y | Set Of Books Identifier |
| START_DATE | DATE | Y | Start Date | |
| END_DATE | DATE | End Date | ||
| CREATED_BY | NUMBER | (15) | Standard Who Column | |
| CREATION_DATE | DATE | Standard Who Column | ||
| LAST_UPDATED_BY | NUMBER | (15) | Y | Standard Who Column |
| LAST_UPDATE_DATE | DATE | Y | Standard Who Column | |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who Column |
GHG.GHG_ORG_ACCOUNT_MAPPINGS_ALL does not reference any database object
GHG.GHG_ORG_ACCOUNT_MAPPINGS_ALL is referenced by following:
| Description: |
|---|
This table stores the org project mapping details
| Index | Type | Tablespace | Column |
|---|---|---|---|
| GHG_ORG_PROJECT_MAPPINGS_U1 | UNIQUE | APPS_TS_TX_IDX | PROJECT_MAPPING_ID |
| GHG_ORG_PROJECT_MAPPINGS_N1 | NONUNIQUE | APPS_TS_TX_IDX |
FROM_PROJECT_ID
TO_PROJECT_ID |
| GHG_ORG_PROJECT_MAPPINGS_N2 | NONUNIQUE | APPS_TS_TX_IDX |
FROM_TASK_NUMBER
TO_TASK_NUMBER |
| GHG_ORG_PROJECT_MAPPINGS_N3 | NONUNIQUE | APPS_TS_TX_IDX | GHG_ORGANIZATION_ID |
| GHG_ORG_PROJECT_MAPPINGS_N4 | NONUNIQUE | APPS_TS_TX_IDX | ORG_ID |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| PROJECT_MAPPING_ID | NUMBER | (15) | Y | Project Mapping Identifier |
| GHG_ORGANIZATION_ID | NUMBER | (15) | Y | GHG Organization Identifier |
| FROM_PROJECT_ID | NUMBER | (15) | Y | From Project Identifier |
| TO_PROJECT_ID | NUMBER | (15) | Y | To Project Identifier |
| FROM_TASK_NUMBER | VARCHAR2 | (25) | Y | From Task Number |
| TO_TASK_NUMBER | VARCHAR2 | (25) | Y | To Task Number |
| ORG_ID | NUMBER | (15) | Y | Organization Identifier |
| SET_OF_BOOKS_ID | NUMBER | (15) | Y | Set Of Books Identifier |
| START_DATE | DATE | Y | Start Date | |
| END_DATE | DATE | End Date | ||
| CREATED_BY | NUMBER | (15) | Standard Who Column | |
| CREATION_DATE | DATE | Standard Who Column | ||
| LAST_UPDATED_BY | NUMBER | (15) | Y | Standard Who Column |
| LAST_UPDATE_DATE | DATE | Y | Standard Who Column | |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who Column |
GHG.GHG_ORG_PROJECT_MAPPINGS_ALL does not reference any database object
GHG.GHG_ORG_PROJECT_MAPPINGS_ALL is referenced by following:
| Description: |
|---|
This table stores the org sic mapping details
| Index | Type | Tablespace | Column |
|---|---|---|---|
| GHG_ORG_SIC_MAPPINGS_N1 | NONUNIQUE | APPS_TS_TX_IDX | GHG_ORGANIZATION_ID |
| GHG_ORG_SIC_MAPPINGS_N2 | NONUNIQUE | APPS_TS_TX_IDX |
SIC_CODE
ORG_ID |
| GHG_ORG_SIC_MAPPINGS_N3 | NONUNIQUE | APPS_TS_TX_IDX | ORG_ID |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| SIC_MAPPING_ID | NUMBER | (15) | Y | SIC Mapping Identifier |
| GHG_ORGANIZATION_ID | NUMBER | (15) | Y | GHG Organization Identifier |
| SIC_CODE | VARCHAR2 | (25) | Y | SIC Code |
| DIVISION_CODE | VARCHAR2 | (25) | Y | Division Code |
| ORG_ID | NUMBER | (15) | Y | Organization Identifier |
| SET_OF_BOOKS_ID | NUMBER | (15) | Y | Set Of Books Identifier |
| START_DATE | DATE | Y | Start Date | |
| END_DATE | DATE | End Date | ||
| CREATED_BY | NUMBER | (15) | Standard Who Column | |
| CREATION_DATE | DATE | Standard Who Column | ||
| LAST_UPDATED_BY | NUMBER | (15) | Y | Standard Who Column |
| LAST_UPDATE_DATE | DATE | Y | Standard Who Column | |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who Column |
GHG.GHG_ORG_SIC_MAPPINGS_ALL does not reference any database object
GHG.GHG_ORG_SIC_MAPPINGS_ALL is referenced by following:
| Description: |
|---|
This table stores the reporting combinations
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| CODE_COMBINATION_ID | NUMBER | (15) | Y | Code Combination Identifier |
| LAST_UPDATE_DATE | DATE | Y | Standard Who Column | |
| LAST_UPDATED_BY | NUMBER | Y | Standard Who Column | |
| CHART_OF_ACCOUNTS_ID | NUMBER | (15) | Y | Chart Of Accounts Identifier |
| SEGMENT1 | VARCHAR2 | (25) | Segment1 | |
| SEGMENT2 | VARCHAR2 | (25) | Segment2 | |
| SEGMENT3 | VARCHAR2 | (25) | Segment3 | |
| SEGMENT4 | VARCHAR2 | (25) | Segment4 | |
| SEGMENT5 | VARCHAR2 | (25) | Segment5 | |
| SEGMENT6 | VARCHAR2 | (25) | Segment6 | |
| SEGMENT7 | VARCHAR2 | (25) | Segment7 | |
| SEGMENT8 | VARCHAR2 | (25) | Segment8 | |
| SEGMENT9 | VARCHAR2 | (25) | Segment9 | |
| SEGMENT10 | VARCHAR2 | (25) | Segment10 | |
| SEGMENT11 | VARCHAR2 | (25) | Segment11 | |
| SEGMENT12 | VARCHAR2 | (25) | Segment12 | |
| SEGMENT13 | VARCHAR2 | (25) | Segment13 | |
| SEGMENT14 | VARCHAR2 | (25) | Segment14 | |
| SEGMENT15 | VARCHAR2 | (25) | Segment15 | |
| SEGMENT16 | VARCHAR2 | (25) | Segment16 | |
| SEGMENT17 | VARCHAR2 | (25) | Segment17 | |
| SEGMENT18 | VARCHAR2 | (25) | Segment18 | |
| SEGMENT19 | VARCHAR2 | (25) | Segment19 | |
| SEGMENT20 | VARCHAR2 | (25) | Segment20 | |
| SEGMENT21 | VARCHAR2 | (25) | Segment21 | |
| SEGMENT22 | VARCHAR2 | (25) | Segment22 | |
| SEGMENT23 | VARCHAR2 | (25) | Segment23 | |
| SEGMENT24 | VARCHAR2 | (25) | Segment24 | |
| SEGMENT25 | VARCHAR2 | (25) | Segment25 | |
| SEGMENT26 | VARCHAR2 | (25) | Segment26 | |
| SEGMENT27 | VARCHAR2 | (25) | Segment27 | |
| SEGMENT28 | VARCHAR2 | (25) | Segment28 | |
| SEGMENT29 | VARCHAR2 | (25) | Segment29 | |
| SEGMENT30 | VARCHAR2 | (25) | Segment30 | |
| START_DATE_ACTIVE | DATE | Y | Start Date Active | |
| END_DATE_ACTIVE | DATE | End Date Active | ||
| ENABLED_FLAG | VARCHAR2 | (1) | Enabled Flag | |
| SUMMARY_FLAG | VARCHAR2 | (1) | Summary Flag |
GHG.GHG_REPORT_COMBINATIONS does not reference any database object
GHG.GHG_REPORT_COMBINATIONS is referenced by following:
| Description: |
|---|
This table stores the segment mappings
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| MAP_ACCOUNTS_FLAG | VARCHAR2 | (1) | Y | Map Accounts Flag |
| MAP_OPERATING_UNIT_FLAG | VARCHAR2 | (1) | Y | Map Operating Unit Flag |
| MAP_PROJECTS_FLAG | VARCHAR2 | (1) | Y | Map Projects Flag |
| MAP_SEGMENT1_FLAG | VARCHAR2 | (1) | Y | Mapping Segment1 Flag |
| MAP_SEGMENT2_FLAG | VARCHAR2 | (1) | Y | Mapping Segment2 Flag |
| MAP_SEGMENT3_FLAG | VARCHAR2 | (1) | Y | Mapping Segment3 Flag |
| MAP_SEGMENT4_FLAG | VARCHAR2 | (1) | Y | Mapping Segment4 Flag |
| MAP_SEGMENT5_FLAG | VARCHAR2 | (1) | Y | Mapping Segment5 Flag |
| MAP_SEGMENT6_FLAG | VARCHAR2 | (1) | Y | Mapping Segment6 Flag |
| MAP_SEGMENT7_FLAG | VARCHAR2 | (1) | Y | Mapping Segment7 Flag |
| MAP_SEGMENT8_FLAG | VARCHAR2 | (1) | Y | Mapping Segment8 Flag |
| MAP_SEGMENT9_FLAG | VARCHAR2 | (1) | Y | Mapping Segment9 Flag |
| MAP_SEGMENT10_FLAG | VARCHAR2 | (1) | Y | Mapping Segment10 Flag |
| MAP_SEGMENT11_FLAG | VARCHAR2 | (1) | Y | Mapping Segment11 Flag |
| MAP_SEGMENT12_FLAG | VARCHAR2 | (1) | Y | Mapping Segment12 Flag |
| MAP_SEGMENT13_FLAG | VARCHAR2 | (1) | Y | Mapping Segment13 Flag |
| MAP_SEGMENT14_FLAG | VARCHAR2 | (1) | Y | Mapping Segment14 Flag |
| MAP_SEGMENT15_FLAG | VARCHAR2 | (1) | Y | Mapping Segment15 Flag |
| MAP_SEGMENT16_FLAG | VARCHAR2 | (1) | Y | Mapping Segment16 Flag |
| MAP_SEGMENT17_FLAG | VARCHAR2 | (1) | Y | Mapping Segment17 Flag |
| MAP_SEGMENT18_FLAG | VARCHAR2 | (1) | Y | Mapping Segment18 Flag |
| MAP_SEGMENT19_FLAG | VARCHAR2 | (1) | Y | Mapping Segment19 Flag |
| MAP_SEGMENT20_FLAG | VARCHAR2 | (1) | Y | Mapping Segment20 Flag |
| MAP_SEGMENT21_FLAG | VARCHAR2 | (1) | Y | Mapping Segment21 Flag |
| MAP_SEGMENT22_FLAG | VARCHAR2 | (1) | Y | Mapping Segment22 Flag |
| MAP_SEGMENT23_FLAG | VARCHAR2 | (1) | Y | Mapping Segment23 Flag |
| MAP_SEGMENT24_FLAG | VARCHAR2 | (1) | Y | Mapping Segment24 Flag |
| MAP_SEGMENT25_FLAG | VARCHAR2 | (1) | Y | Mapping Segment25 Flag |
| MAP_SEGMENT26_FLAG | VARCHAR2 | (1) | Y | Mapping Segment26 Flag |
| MAP_SEGMENT27_FLAG | VARCHAR2 | (1) | Y | Mapping Segment27 Flag |
| MAP_SEGMENT28_FLAG | VARCHAR2 | (1) | Y | Mapping Segment28 Flag |
| MAP_SEGMENT29_FLAG | VARCHAR2 | (1) | Y | Mapping Segment29 Flag |
| MAP_SEGMENT30_FLAG | VARCHAR2 | (1) | Y | Mapping Segment30 Flag |
| ORG_ID | NUMBER | (15) | Y | Organization Identifier |
| SET_OF_BOOKS_ID | NUMBER | (15) | Y | Set Of Books Identifier |
| CREATED_BY | NUMBER | (15) | Standard Who Column | |
| CREATION_DATE | DATE | Standard Who Column | ||
| LAST_UPDATED_BY | NUMBER | (15) | Y | Standard Who Column |
| LAST_UPDATE_DATE | DATE | Y | Standard Who Column | |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who Column |
GHG.GHG_SEGMENT_MAPPINGS_ALL does not reference any database object
GHG.GHG_SEGMENT_MAPPINGS_ALL is referenced by following:
| Description: |
|---|
This table stores the sources created for GHG
| Index | Type | Tablespace | Column |
|---|---|---|---|
| GHG_SOURCES_U1 | UNIQUE | APPS_TS_TX_IDX |
ORG_ID
SOURCE_NAME |
| GHG_SOURCES_U2 | UNIQUE | APPS_TS_TX_IDX | SOURCE_ID |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| SOURCE_ID | NUMBER | (15) | Y | Source Identifier |
| SOURCE_NAME | VARCHAR2 | (240) | Y | Source Name |
| UNIT_OF_MEASURE | VARCHAR2 | (25) | Y | Unit Of Measure |
| 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) | Y | Standard Who Column |
| LAST_UPDATE_DATE | DATE | Y | Standard Who Column | |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who Column | |
| ORG_ID | NUMBER | Y | Organization Identifier | |
| ENABLED | VARCHAR2 | (1) | Y | Enabled Flag |
| FORMULA_ID | NUMBER | Formula Identifier | ||
| GHG_UOM_CLASS_CODE | VARCHAR2 | (30) | GHG Unit Of Measure Class Code | |
| ENERGY_TYPE | VARCHAR2 | (30) | Energy Type |
GHG.GHG_SOURCES_ALL does not reference any database object
GHG.GHG_SOURCES_ALL is referenced by following:
| Description: |
|---|
This table stores the source combination information
| Index | Type | Tablespace | Column |
|---|---|---|---|
| GHG_SOURCE_COMBINATIONS_U1 | UNIQUE | APPS_TS_TX_IDX | SOURCE_COMBINATION_ID |
| GHG_SOURCE_COMBINATIONS_N1 | NONUNIQUE | APPS_TS_TX_IDX | SOURCE_ID |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| SOURCE_COMBINATION_ID | NUMBER | (15) | Y | Source Combination Identifier |
| SOURCE_COMBINATION_CODE | VARCHAR2 | (10) | Source Combination Code | |
| SOURCE_COMBINATION_DESCRIPTION | VARCHAR2 | (240) | Source Combination Description | |
| SOURCE_ID | NUMBER | (15) | Y | Source Identifier |
| START_DATE | DATE | Y | Start Date | |
| END_DATE | DATE | End Date | ||
| CREATED_BY | NUMBER | (15) | Standard Who Column | |
| CREATION_DATE | DATE | Standard Who Column | ||
| LAST_UPDATED_BY | NUMBER | (15) | Y | Standard Who Column |
| LAST_UPDATE_DATE | DATE | Y | Standard Who Column | |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who Column | |
| CODE_COMBINATION_ID | NUMBER | Code Combination Identifier | ||
| SCOPE_LOOKUP_CODE | VARCHAR2 | (20) | Scope Lookup Code | |
| METHOD_LOOKUP_CODE | VARCHAR2 | (20) | Method Lookup Code | |
| RATE_OVERRIDE_TYPE | VARCHAR2 | (15) | Rate Override Type | |
| SUPPLIER_ID | NUMBER | Supplier Identifier | ||
| SUPPLIER_SITE_ID | NUMBER | Supplier Site Identifier | ||
| ITEM_ID | NUMBER | Item Identifier | ||
| METHOD_JUSTIFICATION | VARCHAR2 | (4000) | Method Justification | |
| GHG_ORGANIZATION_ID | NUMBER | GHG Organization Identifier | ||
| SUPPLIER_TYPE | VARCHAR2 | (15) | Supplier Type | |
| ITEM_TYPE | VARCHAR2 | (15) | Item Type | |
| LOCATION_CODE | VARCHAR2 | (20) | Location Code | |
| TRANSPORT_TYPE_LOOKUP_CODE | VARCHAR2 | (20) | Transport Type Lookup Code | |
| ORG_ID | NUMBER | (15) | Y | Organization Identifier |
GHG.GHG_SOURCE_COMBINATIONS_ALL does not reference any database object
GHG.GHG_SOURCE_COMBINATIONS_ALL is referenced by following:
| Description: |
|---|
This table stores the supplier item details
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| SOURCE_ID | NUMBER | Source Identifier | ||
| INVENTORY_ITEM_ID | NUMBER | Inventory Item Identifier | ||
| SUPPLIER_ID | NUMBER | Supplier Identifier | ||
| SUPPLIER_SITE_ID | NUMBER | Supplier Site Identifier | ||
| SCOPE_LOOKUP_CODE | VARCHAR2 | (20) | Scope Lookup Code | |
| LOCATION_CODE | VARCHAR2 | (20) | Location Code | |
| GROUP_DEFAULT | VARCHAR2 | (1) | Group Default | |
| ORG_ID | NUMBER | Organization Identifier | ||
| START_DATE_ACTIVE | DATE | Y | Start Date Active | |
| END_DATE_ACTIVE | DATE | End Date Active | ||
| CREATED_BY | NUMBER | Standard Who Column | ||
| CREATION_DATE | DATE | Standard Who Column | ||
| LAST_UPDATE_DATE | DATE | Standard Who Column | ||
| LAST_UPDATED_BY | NUMBER | Standard Who Column | ||
| LAST_UPDATE_LOGIN | NUMBER | Standard Who Column |
GHG.GHG_SUPPLIER_ITEMS_ALL does not reference any database object
GHG.GHG_SUPPLIER_ITEMS_ALL is referenced by following:
| Description: |
|---|
This table stores the system parameters
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| PO_MATCH_EMISSION_DATE | VARCHAR2 | (10) | Y | Purchase Order Match Emission Date |
| RECEIPT_MATCH_EMISSION_DATE | VARCHAR2 | (10) | Y | Receipt Match Emission Date |
| ORG_ID | NUMBER | (15) | Y | Organization Identifier |
| SET_OF_BOOKS_ID | NUMBER | (15) | Y | Set Of Books Identifier |
| CREATED_BY | NUMBER | (15) | Standard Who Column | |
| CREATION_DATE | DATE | Standard Who Column | ||
| LAST_UPDATED_BY | NUMBER | (15) | Y | Standard Who Column |
| LAST_UPDATE_DATE | DATE | Y | Standard Who Column | |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who Column | |
| GPS_MANDATORY | VARCHAR2 | (1) | GPS Mandatory Flag | |
| ID_FLEX_ID | NUMBER | ID Flex Identifier |
GHG.GHG_SYSTEM_PARAMETERS_ALL does not reference any database object
GHG.GHG_SYSTEM_PARAMETERS_ALL is referenced by following:
| Description: |
|---|
This table stores the transactions created for GHG
| Index | Type | Tablespace | Column |
|---|---|---|---|
| GHG_TRANSACTIONS_U1 | UNIQUE | APPS_TS_TX_IDX | TRANSACTION_ID |
| GHG_TRANSACTIONS_N1 | NONUNIQUE | APPS_TS_TX_IDX | INVOICE_ID |
| GHG_TRANSACTIONS_N2 | NONUNIQUE | APPS_TS_TX_IDX |
VENDOR_ID
VENDOR_SITE_ID |
| GHG_TRANSACTIONS_N3 | NONUNIQUE | APPS_TS_TX_IDX | GHG_ORGANIZATION_ID |
| GHG_TRANSACTIONS_N4 | NONUNIQUE | APPS_TS_TX_IDX | ORG_ID |
| GHG_TRANSACTIONS_N5 | NONUNIQUE | APPS_TS_TX_IDX | TRANSACTION_BATCH_ID |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| TXN_TYPE_LOOKUP_CODE | VARCHAR2 | (20) | Y | Txn Type Lookup Code |
| TRANSACTION_ID | NUMBER | (15) | Y | Transaction Identifier |
| TRANSACTION_BATCH_ID | NUMBER | (15) | Transaction Batch Identifier | |
| TRANSACTION_SOURCE_ID | NUMBER | (15) | Transaction Source Identifier | |
| GHG_ORGANIZATION_ID | NUMBER | (15) | Y | 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) | Y | Unit Of Measure |
| UOM_CONVERSION | NUMBER | Y | Unit Of Measure Conversion | |
| EMISSION_QUANTITY | NUMBER | Emission Quantity | ||
| ENERGY_QUANTITY | NUMBER | Energy Quantity | ||
| TRANSACTION_DATE_FROM | DATE | Y | Transaction From Date | |
| TRANSACTION_DATE_TO | DATE | Y | Transaction To Date | |
| DESCRIPTION | VARCHAR2 | (240) | Description | |
| ORG_ID | NUMBER | (15) | Y | Organization Identifier |
| SET_OF_BOOKS_ID | NUMBER | (15) | Y | 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) | Y | Standard Who Column |
| LAST_UPDATE_DATE | DATE | Y | 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 |
GHG.GHG_TRANSACTIONS_ALL does not reference any database object
GHG.GHG_TRANSACTIONS_ALL is referenced by following:
| Description: |
|---|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| SOURCE_APPLICATION_CODE | VARCHAR2 | (10) | Y | |
| TRANSACTION_ID | NUMBER | Y | ||
| 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 | Y | ||
| TRANSACTION_VALUE | NUMBER | (22) | ||
| TRANSACTION_CURRENCY_CODE | VARCHAR2 | (30) | ||
| TRANSACTION_CURRENCY_DESC | VARCHAR2 | (100) | ||
| EMISSION_SOURCE_ID | NUMBER | Y | ||
| EMISSION_SOURCE_USAGE_QUANTITY | NUMBER | (22) | Y | |
| EMISSION_SOURCE_USAGE_UOM | VARCHAR2 | (30) | Y | |
| EMISSION_SCOPE_ID | NUMBER | |||
| ENERGY_TYPE | VARCHAR2 | (30) | Y | |
| ENERGY_QUANTITY | NUMBER | (22) | Y | |
| ENERGY_UOM | VARCHAR2 | (30) | Y | |
| CO2_E_QUANTITY | NUMBER | (22) | Y | |
| CO2_E_UOM | VARCHAR2 | (30) | Y | |
| 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) | Y | |
| 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) |
GHG.GHG_TRANSACTIONS_D_TMP does not reference any database object
GHG.GHG_TRANSACTIONS_D_TMP is referenced by following:
| Description: |
|---|
This table stores the transaction history
| Index | Type | Tablespace | Column |
|---|---|---|---|
| GHG_TRANSACTIONS_HISTORY_U1 | UNIQUE | APPS_TS_TX_IDX |
TRANSACTION_ID
TRANSACTION_VERSION |
| GHG_TRANSACTIONS_HISTORY_N1 | NONUNIQUE | APPS_TS_TX_IDX | INVOICE_ID |
| GHG_TRANSACTIONS_HISTORY_N2 | NONUNIQUE | APPS_TS_TX_IDX |
VENDOR_ID
VENDOR_SITE_ID |
| GHG_TRANSACTIONS_HISTORY_N3 | NONUNIQUE | APPS_TS_TX_IDX | GHG_ORGANIZATION_ID |
| GHG_TRANSACTIONS_HISTORY_N4 | NONUNIQUE | APPS_TS_TX_IDX | ORG_ID |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| TXN_TYPE_LOOKUP_CODE | VARCHAR2 | (20) | Y | Txn Type Lookup Code |
| TRANSACTION_ID | NUMBER | (15) | Y | Transaction Identifier |
| TRANSACTION_VERSION | NUMBER | (15) | Y | Transaction Version |
| TRANSACTION_SOURCE_ID | NUMBER | (15) | Transaction Source Identifier | |
| GHG_ORGANIZATION_ID | NUMBER | (15) | Y | GHG Organization Identifier |
| TRANSACTION_TYPE_LOOKUP_CODE | VARCHAR2 | (1) | Transaction Type Lookup Code | |
| USAGE_QUANTITY | NUMBER | Usage Quantity | ||
| UNIT_OF_MEASURE | VARCHAR2 | (25) | Y | Unit Of Measure Code |
| UOM_CONVERSION | NUMBER | Y | Unit Of Measure Conversion | |
| EMISSION_QUANTITY | NUMBER | Emission Quantity | ||
| ENERGY_QUANTITY | NUMBER | Energy Quantity | ||
| TRANSACTION_DATE_FROM | DATE | Y | Transaction From Date | |
| TRANSACTION_DATE_TO | DATE | Y | Transaction To Date | |
| DESCRIPTION | VARCHAR2 | (240) | Description | |
| ORG_ID | NUMBER | (15) | Y | Organization Identifier |
| SET_OF_BOOKS_ID | NUMBER | (15) | Y | 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 | |
| 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) | Y | Standard Who Column |
| LAST_UPDATE_DATE | DATE | Y | Standard Who Column | |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who Column | |
| INVOICE_LINE_NUMBER | NUMBER | Invoice Line Number | ||
| MEASUREMENT_CRITERIA | VARCHAR2 | (15) | Measurement Criteria |
GHG.GHG_TRANSACTIONS_HISTORY_ALL does not reference any database object
GHG.GHG_TRANSACTIONS_HISTORY_ALL is referenced by following:
| Description: |
|---|
This table stores the transaction batch information
| Index | Type | Tablespace | Column |
|---|---|---|---|
| GHG_TRANSACTION_BATCHES_U1 | UNIQUE | APPS_TS_TX_IDX |
TRANSACTION_BATCH_NUMBER
ORG_ID |
| GHG_TRANSACTION_BATCHES_U2 | UNIQUE | APPS_TS_TX_IDX | TRANSACTION_BATCH_ID |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| TRANSACTION_BATCH_ID | NUMBER | (15) | Y | Transaction Batch Identifier |
| TRANSACTION_BATCH_NUMBER | VARCHAR2 | (240) | Y | Transaction Batch Number |
| BATCH_TYPE | VARCHAR2 | (20) | Y | Batch Type |
| BATCH_SUB_TYPE | VARCHAR2 | (15) | Batch Sub Type | |
| VENDOR_ID | NUMBER | (15) | Vendor Identifier | |
| VENDOR_SITE_ID | NUMBER | (15) | Vendor Site Identifier | |
| DESCRIPTION | VARCHAR2 | (240) | Description | |
| STATUS | VARCHAR2 | (1) | Y | Status |
| REVERSAL_DATE | DATE | Reversal Date | ||
| REVERSED_TRANSACTION_BATCH_ID | NUMBER | (15) | Reversed Transaction Batch Identifier | |
| ORG_ID | NUMBER | (15) | Y | Organization Identifier |
| SET_OF_BOOKS_ID | NUMBER | (15) | Y | Set Of Books Identifier |
| CREATED_BY | NUMBER | (15) | Standard Who Column | |
| CREATION_DATE | DATE | Standard Who Column | ||
| LAST_UPDATED_BY | NUMBER | (15) | Y | Standard Who Column |
| LAST_UPDATE_DATE | DATE | Y | Standard Who Column | |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who Column |
GHG.GHG_TRANSACTION_BATCHES_ALL does not reference any database object
GHG.GHG_TRANSACTION_BATCHES_ALL is referenced by following:
| Description: |
|---|
This table stores the transaction details
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| TRANSACTION_ID | NUMBER | Y | Transaction Identifier | |
| TRANSACTION_DATE | DATE | Y | Transaction Date | |
| TRANSACTION_TYPE | VARCHAR2 | (20) | Y | Transaction Type |
| TRANSACTION_COMPONENT_TYPE | VARCHAR2 | (20) | Y | Transaction Component Type |
| TRANSACTION_VALUE | NUMBER | Y | Transaction Value | |
| SOURCE_COMBINATION_ID | VARCHAR2 | (20) | Y | Source Combination Identifier |
| ORG_ID | NUMBER | (15) | Y | Organization Identifier |
| CREATED_BY | NUMBER | Standard Who Column | ||
| CREATION_DATE | DATE | Standard Who Column | ||
| LAST_UPDATED_BY | NUMBER | Standard Who Column | ||
| LAST_UPDATE_DATE | DATE | Standard Who Column | ||
| LAST_UPDATE_LOGIN | NUMBER | Standard Who Column |
GHG.GHG_TRANSACTION_DETAILS_ALL does not reference any database object
GHG.GHG_TRANSACTION_DETAILS_ALL is referenced by following:
| Description: |
|---|
This table stores the unit of measure classes information
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| GHG_UOM_CLASS_CODE | VARCHAR2 | (30) | Y | GHG Unit Of Measure Class Code |
| DESCRIPTION | VARCHAR2 | (255) | Description | |
| STANDARD_UOM | VARCHAR2 | (20) | Y | Standard Unit Of Measure |
| CREATED_BY | NUMBER | Y | Standard Who Column | |
| CREATION_DATE | DATE | Y | Standard Who Column | |
| LAST_UPDATED_BY | NUMBER | Y | Standard Who Column | |
| LAST_UPDATE_DATE | DATE | Y | Standard Who Column | |
| LAST_UPDATE_LOGIN | NUMBER | Standard Who Column | ||
| ORG_ID | NUMBER | Y | Organization Identifier |
GHG.GHG_UOM_CLASSES_ALL does not reference any database object
GHG.GHG_UOM_CLASSES_ALL is referenced by following:
|
|
|
| Copyright (c) 2001 - 2005, Oracle | - Use Restricted by Contract |