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

Object Details

Object Name:	BIL_DIMV_TERR_HIER
Object Type:	VIEW
Owner:	APPS
FND Design Data:	BIL.BIL_DIMV_TERR_HIER
Subobject Name:
Status:	VALID

View Type

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

BIL_DIMV_TERR_HIER - Dimension view used to relate the levels of the sales territory hierarchy.
.
Source is Oracle CRM Foundation schema.
.
.

[View Source]

Columns

Name	Datatype	Length	Comments
TERR_ID	NUMBER		Territory Unique Identifier
PARENT_TERR_ID	NUMBER		Parent Territory Identifier
IMMEDIATE_PARENT_FLAG	VARCHAR2	(1)	Flag that indicates whether the parent territory identifier is for an immediate parent

Query Text

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


SELECT TERR_ID
,      PARENT_TERR_ID
,      IMMEDIATE_PARENT_FLAG
FROM APPS.BIL_DIMV_TERR_HIER;

Dependencies

[top of page]

APPS.BIL_DIMV_TERR_HIER references the following:

APPS: FND_GLOBAL - show dependent code; FND_LOOKUPS; JTF_TERR_DENORM

APPS.BIL_DIMV_TERR_HIER is not referenced by any database object