[Home] [Help] [Dependency Information]

VIEW: APPS.JTF_TERR_SRCH_MAIN_V

Object Details

Object Name:	JTF_TERR_SRCH_MAIN_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	JTF.JTF_TERR_SRCH_MAIN_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

Query Text

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

SELECT TERR_ID
,      NAME
,      TEMPLATE_FLAG
,      TEMPLATE_TERR_NAME
,      ESCALATION_TERRITORY_FLAG
,      ESCALATION_TERR_NAME
,      TERR_TYPE_NAME
,      PARENT_TERR_NAME
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      TERR_USAGE
,      RESOURCE_NAME
,      RESOURCE_TYPE
FROM APPS.JTF_TERR_SRCH_MAIN_V;

Dependencies

[top of page]

APPS

FND_ACCESS_CONTROL_UTIL - show dependent code

JTF_TERRITORY_RESOURCE_PVT - show dependent code

JTF_TERR_OVERVIEW_V

JTF_TERR_RESOURCES_V

APPS.JTF_TERR_SRCH_MAIN_V is not referenced by any database object