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]

TABLE: OKI.OKI_JTF_TERRITORIES

Object Details

Object Name:	OKI_JTF_TERRITORIES
Object Type:	TABLE
Owner:	OKI
Subobject Name:
Status:	VALID

Table for territory reporting

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OKI_JTF_TERRITORIES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	CUSTOMER_PARTY_ID AUTHORING_ORG_ID
OKI_JTF_TERRITORIES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TERR_ID RESOURCE_ID

Columns

Name	Datatype	Mandatory	Comments
AUTHORING_ORG_ID	NUMBER	Yes	Organization Id
RESOURCE_ID	NUMBER	Yes	Resource Id
TERR_ID	NUMBER	Yes	Territory Id
CUSTOMER_PARTY_ID	NUMBER	Yes	Gives the customer party id
CREATION_DATE	DATE	Yes	Creation date
CREATED_BY	NUMBER	Yes	Created by
LAST_UPDATE_DATE	DATE	Yes	Last update date
LAST_UPDATED_BY	NUMBER	Yes	Last Updated By
LAST_UPDATE_LOGIN	NUMBER		Last update login

Query Text

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


SELECT AUTHORING_ORG_ID
,      RESOURCE_ID
,      TERR_ID
,      CUSTOMER_PARTY_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM OKI.OKI_JTF_TERRITORIES;

Dependencies

[top of page]

OKI.OKI_JTF_TERRITORIES does not reference any database object

OKI.OKI_JTF_TERRITORIES is referenced by following:

APPS: OKI_JTF_TERRITORIES