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

VIEW: APPS.OKI_TERR_OLTP_V

Object Details
Object Name: OKI_TERR_OLTP_V
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID


Territoreis lookup view --stores ID and name of a territory.


[View Source]

Columns
Name Datatype Length Mandatory Comments
TERR_ID NUMBER
Yes Territory ID. This column is used for join with other tables to get the territory names
NAME VARCHAR2 (2000) Yes Territory Name.
Query Text

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


SELECT TERR_ID
,      NAME
FROM APPS.OKI_TERR_OLTP_V;

Dependencies

[top of page]

APPS.OKI_TERR_OLTP_V references the following:

SchemaAPPS
SynonymJTF_TERR_ALL

APPS.OKI_TERR_OLTP_V is not referenced by any database object