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

VIEW: APPS.JTF_TERR_SRCH_ADV_GEN_V

Object Details
Object Name: JTF_TERR_SRCH_ADV_GEN_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewJTF.JTF_TERR_SRCH_ADV_GEN_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
DESCRIPTION VARCHAR2 (240)
RANK NUMBER

PARENT_TERR_NAME VARCHAR2 (2000) Yes
START_DATE_ACTIVE DATE

END_DATE_ACTIVE DATE

ESCALATION_TERRITORY_FLAG VARCHAR2 (1)
ESCALATION_TERR_NAME VARCHAR2 (2000)
TEMPLATE_TERRITORY_FLAG VARCHAR2 (1)
TEMPLATE_TERR_NAME VARCHAR2 (2000)
TERR_TYPE_NAME VARCHAR2 (60)
TERR_USAGE VARCHAR2 (240) Yes
Query Text

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


SELECT TERR_ID
,      NAME
,      DESCRIPTION
,      RANK
,      PARENT_TERR_NAME
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      ESCALATION_TERRITORY_FLAG
,      ESCALATION_TERR_NAME
,      TEMPLATE_TERRITORY_FLAG
,      TEMPLATE_TERR_NAME
,      TERR_TYPE_NAME
,      TERR_USAGE
FROM APPS.JTF_TERR_SRCH_ADV_GEN_V;

Dependencies

[top of page]

APPS.JTF_TERR_SRCH_ADV_GEN_V references the following:

SchemaAPPS
SynonymJTF_SOURCES_ALL
SynonymJTF_TERR
SynonymJTF_TERR_TYPES
SynonymJTF_TERR_USGS
APPS.JTF_TERR_SRCH_ADV_GEN_V is referenced by following:

SchemaAPPS
Package BodyAMV_MATCH_PVT - show dependent code