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


VIEW: APPS.JTF_TERR_SRCH_ESCL_V

Object Details
Object Name: JTF_TERR_SRCH_ESCL_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewJTF.JTF_TERR_SRCH_ESCL_V
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
TERR_ID NUMBER
Yes
NAME VARCHAR2 (2000) Yes
ESCALATION_TERR_NAME VARCHAR2 (2000)
TERR_TYPE_NAME VARCHAR2 (60)
TERR_USAGE VARCHAR2 (240)
RESOURCE_NAME VARCHAR2 (4000)
RESOURCE_TYPE VARCHAR2 (60)
Query Text

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


SELECT TERR_ID
,      NAME
,      ESCALATION_TERR_NAME
,      TERR_TYPE_NAME
,      TERR_USAGE
,      RESOURCE_NAME
,      RESOURCE_TYPE
FROM APPS.JTF_TERR_SRCH_ESCL_V;

Dependencies

[top of page]

APPS.JTF_TERR_SRCH_ESCL_V references the following:

SchemaAPPS
PL/SQL PackageFND_ACCESS_CONTROL_UTIL - show dependent code
PL/SQL PackageJTF_TERRITORY_RESOURCE_PVT - show dependent code
ViewJTF_TERR_OVERVIEW_V
ViewJTF_TERR_RESOURCES_V

APPS.JTF_TERR_SRCH_ESCL_V is not referenced by any database object