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.RRS_TRADE_AREA_GROUPS_VL

Object Details

Object Name:	RRS_TRADE_AREA_GROUPS_VL
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

View Type

MultiLingual view (a language resolved view of the data.)

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		ROWID.
GROUP_ID	NUMBER		Yes	System generated number which uniquely identifies the Trade Area Group.
GROUP_TYPE_CODE	VARCHAR2	(30)	Yes	The geometry type of the trade area group.
NUM_OF_TRADE_AREAS	NUMBER		Yes	The number of Trade Areas in this Trade Area Group.
STATUS_CODE	VARCHAR2	(30)	Yes	Indicates the status of the Trade Area Group.
UNIT_OF_MEASURE_CODE	VARCHAR2	(30)	Yes	The Unit Of Measure used while specifying the Trade Area radii.
OBJECT_VERSION_NUMBER	NUMBER			Sequence number for loc.
NAME	VARCHAR2	(150)	Yes	User defined name of the Trade Area Group.
DESCRIPTION	VARCHAR2	(2000)		User entered description for Trade Area Group.
CREATED_BY	NUMBER		Yes	Standard "WHO" columns.
CREATION_DATE	DATE		Yes	Standard "WHO" columns.
LAST_UPDATED_BY	NUMBER		Yes	Standard "WHO" columns.
LAST_UPDATE_DATE	DATE		Yes	Standard "WHO" columns.
LAST_UPDATE_LOGIN	NUMBER			Standard "WHO" columns.
SOURCE_LANG	VARCHAR2	(4)	Yes	For Translation.
LANGUAGE	VARCHAR2	(4)	Yes	For Transalation.

Query Text

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


SELECT ROW_ID
,      GROUP_ID
,      GROUP_TYPE_CODE
,      NUM_OF_TRADE_AREAS
,      STATUS_CODE
,      UNIT_OF_MEASURE_CODE
,      OBJECT_VERSION_NUMBER
,      NAME
,      DESCRIPTION
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      SOURCE_LANG
,      LANGUAGE
FROM APPS.RRS_TRADE_AREA_GROUPS_VL;

Dependencies

[top of page]

APPS.RRS_TRADE_AREA_GROUPS_VL references the following:

APPS: RRS_TRADE_AREA_GROUPS_B; RRS_TRADE_AREA_GROUPS_TL

APPS.RRS_TRADE_AREA_GROUPS_VL is referenced by following:

APPS: RRS_SITE_INFO - show dependent code; RRS_TRADE_AREAS_OCV