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

VIEW: GHG.GHG_SOURCE_COMBINATIONS_ALL#

Object Details
Object Name: GHG_SOURCE_COMBINATIONS_ALL#
Object Type: VIEW
Owner: GHG
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
SOURCE_COMBINATION_ID NUMBER (15) Yes
SOURCE_COMBINATION_CODE VARCHAR2 (10)
SOURCE_COMBINATION_DESCRIPTION VARCHAR2 (240)
SOURCE_ID NUMBER (15) Yes
START_DATE DATE
Yes
END_DATE DATE

CREATED_BY NUMBER (15)
CREATION_DATE DATE

LAST_UPDATED_BY NUMBER (15) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER (15)
CODE_COMBINATION_ID NUMBER

SCOPE_LOOKUP_CODE VARCHAR2 (20)
METHOD_LOOKUP_CODE VARCHAR2 (20)
RATE_OVERRIDE_TYPE VARCHAR2 (15)
SUPPLIER_ID NUMBER

SUPPLIER_SITE_ID NUMBER

ITEM_ID NUMBER

METHOD_JUSTIFICATION VARCHAR2 (4000)
GHG_ORGANIZATION_ID NUMBER

SUPPLIER_TYPE VARCHAR2 (15)
ITEM_TYPE VARCHAR2 (15)
LOCATION_CODE VARCHAR2 (20)
TRANSPORT_TYPE_LOOKUP_CODE VARCHAR2 (20)
ORG_ID NUMBER (15) Yes
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT SOURCE_COMBINATION_ID
,      SOURCE_COMBINATION_CODE
,      SOURCE_COMBINATION_DESCRIPTION
,      SOURCE_ID
,      START_DATE
,      END_DATE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      CODE_COMBINATION_ID
,      SCOPE_LOOKUP_CODE
,      METHOD_LOOKUP_CODE
,      RATE_OVERRIDE_TYPE
,      SUPPLIER_ID
,      SUPPLIER_SITE_ID
,      ITEM_ID
,      METHOD_JUSTIFICATION
,      GHG_ORGANIZATION_ID
,      SUPPLIER_TYPE
,      ITEM_TYPE
,      LOCATION_CODE
,      TRANSPORT_TYPE_LOOKUP_CODE
,      ORG_ID
FROM GHG.GHG_SOURCE_COMBINATIONS_ALL#;

Dependencies

[top of page]

GHG.GHG_SOURCE_COMBINATIONS_ALL# references the following:

SchemaGHG
TableGHG_SOURCE_COMBINATIONS_ALL
GHG.GHG_SOURCE_COMBINATIONS_ALL# is referenced by following:

SchemaAPPS
SynonymGHG_SOURCE_COMBINATIONS
SynonymGHG_SOURCE_COMBINATIONS_ALL