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

VIEW: APPS.BIL_DIMV_TERRITORIES

Object Details
Object Name: BIL_DIMV_TERRITORIES
Object Type: VIEW
Owner: APPS
FND Design Data: ViewBIL.BIL_DIMV_TERRITORIES
Subobject Name:
Status: VALID

View Type

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


BIL_DIMV_TERRITORIES - Dimension view used to provide descriptive information related to
sales territories.
.
Source is Oracle CRM Foundation schema.
.
.


[View Source]

Columns
Name Datatype Length Mandatory Comments
TERRITORY_PK NUMBER

Territory unique identifier
NAME VARCHAR2 (2000)
Territory name
TERRITORY_TYPE_ID NUMBER

Territory type unique identifier
START_DATE_ACTIVE DATE

Date when this territory becomes active, if limited
END_DATE_ACTIVE DATE

Date when this territory becomes inactive, if limited
ENABLED_FLAG VARCHAR2 (1)
Indicates whether territory is enabled.
ORG_ID NUMBER

Operating unit which performed this transaction.
ID VARCHAR2 (40)
Territory identifier
VALUE VARCHAR2 (80)
Territory name
Query Text

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


SELECT TERRITORY_PK
,      NAME
,      TERRITORY_TYPE_ID
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      ENABLED_FLAG
,      ORG_ID
,      ID
,      VALUE
FROM APPS.BIL_DIMV_TERRITORIES;

Dependencies

[top of page]

APPS.BIL_DIMV_TERRITORIES references the following:

SchemaAPPS
PL/SQL PackageFND_GLOBAL - show dependent code
ViewFND_LOOKUPS
SynonymJTF_TERR_ALL

APPS.BIL_DIMV_TERRITORIES is not referenced by any database object