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

VIEW: APPS.GHG_SOURCE_REPORT_COMB_V

Object Details
Object Name: GHG_SOURCE_REPORT_COMB_V
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


This view stores information about sources reporting combination


[View Source]

Columns
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
Query Text

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;

Dependencies

[top of page]

APPS.GHG_SOURCE_REPORT_COMB_V references the following:

SchemaAPPS
SynonymFND_FLEX_VALUES
SynonymFND_FLEX_VALUES_TL
SynonymFND_ID_FLEX_SEGMENTS
SynonymFND_ID_FLEX_SEGMENTS_TL
SynonymGHG_REPORT_COMBINATIONS
SynonymGHG_SOURCES_ALL
SynonymGHG_SOURCE_COMBINATIONS_ALL
SchemaPUBLIC
SynonymDUAL

APPS.GHG_SOURCE_REPORT_COMB_V is not referenced by any database object