eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.OKI_JTF_TERRITORIES_V

Object Details

Object Name:	OKI_JTF_TERRITORIES_V
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

View for JTF Territories

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
AUTHORING_ORG_ID	NUMBER		Yes	Authoring organization id
CUSTOMER_PARTY_ID	NUMBER		Yes	Customer Party Id
TERR_ID	NUMBER		Yes	Territory id
TERRITORY_NAME	VARCHAR2	(2000)	Yes	Territory name
RESOURCE_ID	NUMBER		Yes	resource id
RESOURCE_NAME	VARCHAR2	(360)		Resource Name
MANAGER_NAME	VARCHAR2	(360)		Manager Name

Query Text

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


SELECT AUTHORING_ORG_ID
,      CUSTOMER_PARTY_ID
,      TERR_ID
,      TERRITORY_NAME
,      RESOURCE_ID
,      RESOURCE_NAME
,      MANAGER_NAME
FROM APPS.OKI_JTF_TERRITORIES_V;

Dependencies

[top of page]

APPS.OKI_JTF_TERRITORIES_V references the following:

APPS: JTF_RS_RESOURCE_EXTNS_VL; JTF_TERR_ALL; OKI_JTF_TERRITORIES

APPS.OKI_JTF_TERRITORIES_V is not referenced by any database object