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_STG

Object Details

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

Staging table for JTF Territories table

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OKI_JTF_TERRITORIES_STG_U1	NORMAL	UNIQUE	APPS_TS_INTERFACE	RECORD_ID

Columns

Name	Datatype	Length	Comments
AUTHORING_ORG_ID	NUMBER		Authoring organization id
PARTY_ID	NUMBER		Party id
PARTY_NAME	VARCHAR2	(360)	Party name
COUNTRY_CODE	VARCHAR2	(60)	Country Code
STATE_CODE	VARCHAR2	(120)	State code
WORKER_NUMBER	NUMBER		Worker number
RECORD_ID	NUMBER		Record ID
TERR_ID	NUMBER		Territory Id
RESOURCE_ID	NUMBER		Resource id

Query Text

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


SELECT AUTHORING_ORG_ID
,      PARTY_ID
,      PARTY_NAME
,      COUNTRY_CODE
,      STATE_CODE
,      WORKER_NUMBER
,      RECORD_ID
,      TERR_ID
,      RESOURCE_ID
FROM OKI.OKI_JTF_TERRITORIES_STG;

Dependencies

[top of page]

OKI.OKI_JTF_TERRITORIES_STG does not reference any database object

OKI.OKI_JTF_TERRITORIES_STG is referenced by following:

APPS: OKI_JTF_TERRITORIES_STG