eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.GHG_SOURCE_COMB_MEANING_V

Object Details

Object Name:	GHG_SOURCE_COMB_MEANING_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 source combination meaning

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		Row Identifier
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
SUPPLIER_NAME	VARCHAR2	(240)		Supplier Name
SUPPLIER_SITE	VARCHAR2	(15)		Supplier Site
ITEM_NUMBER	VARCHAR2	(40)		Item Number
ITEM_DESCRIPTION	VARCHAR2	(240)		Item Description
SCOPE	VARCHAR2	(80)	Yes	Scope
METHOD	VARCHAR2	(80)	Yes	Method
TRANSPORT_TYPE	VARCHAR2	(80)	Yes	Transport Type
LOCATION	VARCHAR2	(80)	Yes	Location
RATE_OVERRIDE_TYPE_MEANING	VARCHAR2	(80)		Rate Override Type Meaning
ITEM_TYPE_MEANING	VARCHAR2	(80)		Item Meaning
SUPPLIER_TYPE_MEANING	VARCHAR2	(80)		Supplier Type Meaning
GHG_ORGANIZATION_CODE	VARCHAR2	(240)		GHG Organization Code
DESCRIPTION	VARCHAR2	(240)		Description

Query Text

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


SELECT ROW_ID
,      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
,      SUPPLIER_NAME
,      SUPPLIER_SITE
,      ITEM_NUMBER
,      ITEM_DESCRIPTION
,      SCOPE
,      METHOD
,      TRANSPORT_TYPE
,      LOCATION
,      RATE_OVERRIDE_TYPE_MEANING
,      ITEM_TYPE_MEANING
,      SUPPLIER_TYPE_MEANING
,      GHG_ORGANIZATION_CODE
,      DESCRIPTION
FROM APPS.GHG_SOURCE_COMB_MEANING_V;

Dependencies

[top of page]

APPS.GHG_SOURCE_COMB_MEANING_V references the following:

APPS: AP_SUPPLIERS; FND_GLOBAL - show dependent code; FND_LOOKUP_VALUES; GHG_ORGANIZATIONS_ALL; GHG_SOURCE_COMBINATIONS_ALL; HR_GENERAL - show dependent code; HR_SECURITY - show dependent code; MTL_SYSTEM_ITEMS_KFV; MTL_UNITS_OF_MEASURE_VL; ORG_ORGANIZATION_DEFINITIONS; PO_VENDOR_SITES

APPS.GHG_SOURCE_COMB_MEANING_V is not referenced by any database object