[Home] [Help] [Dependency Information]
Object Name: | GHG_SOURCE_REPORT_COMB_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
This view stores information about sources reporting combination
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SRC_ORG_ID | NUMBER | Yes | Source Organization Identifier | |
SOURCE_COMBINATION_ID | NUMBER | (15) | Yes | Source Combination Identifier |
SOURCE_COMBINATION_CODE | VARCHAR2 | (10) | Source Combination Code | |
SOURCE_COMB_DESCRIPTION | VARCHAR2 | (240) | Source Combination Description | |
SOURCE_INFO_CODE | NUMBER | (15) | Yes | Source Information Code |
SOURCE_INFO_DESC | VARCHAR2 | (240) | Yes | Source Information Description |
GRANDPARENT_SOURCE_CODE | VARCHAR2 | (25) | Grandparent Source Code | |
GRANDPARENT_SOURCE_DESC | VARCHAR2 | (240) | Grandparent Source Description | |
PARENT_SOURCE_CODE | VARCHAR2 | (25) | Parent Source Code | |
PARENT_SOURCE_DESC | VARCHAR2 | (240) | Parent Source Description | |
SOURCE_TYPE_CODE | VARCHAR2 | (25) | Source Type Code | |
SOURCE_TYPE_DESC | VARCHAR2 | (240) | Source Type Description | |
ENERGY_TYPE | VARCHAR2 | (30) | Energy Type |
Cut, paste (and edit) the following text to query this object:
SELECT SRC_ORG_ID
, SOURCE_COMBINATION_ID
, SOURCE_COMBINATION_CODE
, SOURCE_COMB_DESCRIPTION
, SOURCE_INFO_CODE
, SOURCE_INFO_DESC
, GRANDPARENT_SOURCE_CODE
, GRANDPARENT_SOURCE_DESC
, PARENT_SOURCE_CODE
, PARENT_SOURCE_DESC
, SOURCE_TYPE_CODE
, SOURCE_TYPE_DESC
, ENERGY_TYPE
FROM APPS.GHG_SOURCE_REPORT_COMB_V;
APPS.GHG_SOURCE_REPORT_COMB_V is not referenced by any database object
|
|
|