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

TABLE: GHG.GHG_SOURCE_COMBINATIONS_ALL

Object Details
Object Name: GHG_SOURCE_COMBINATIONS_ALL
Object Type: TABLE
Owner: GHG
FND Design Data: TableGHG.GHG_SOURCE_COMBINATIONS_ALL
Subobject Name:
Status: VALID


This table stores the source combination information


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
GHG_SOURCE_COMBINATIONS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnSOURCE_COMBINATION_ID
GHG_SOURCE_COMBINATIONS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSOURCE_ID
Columns
Name Datatype Length Mandatory Comments
SOURCE_COMBINATION_ID NUMBER (15) Yes Source Combination Identifier
SOURCE_COMBINATION_CODE VARCHAR2 (10)
Source Combination Code
SOURCE_COMBINATION_DESCRIPTION VARCHAR2 (240)
Source Combination Description
SOURCE_ID NUMBER (15) Yes Source Identifier
START_DATE DATE
Yes 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) Yes Standard Who Column
LAST_UPDATE_DATE DATE
Yes 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) Yes Organization Identifier
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 does not reference any database object

GHG.GHG_SOURCE_COMBINATIONS_ALL is referenced by following:

SchemaGHG
ViewGHG_SOURCE_COMBINATIONS_ALL#