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

VIEW: APPS.OKI_HTERR_DTL_V

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


This table stores id values to link a customer and the operating unit with territory and the resource assocaited with that territory. Stores only the ID values


[View Source]

Columns
Name Datatype Length Mandatory Comments
AUTHORING_ORG_ID NUMBER
Yes Organization Id
CUSTOMER_PARTY_ID NUMBER
Yes Gives the customer party id
TERR_ID NUMBER
Yes Territory Id
RESOURCE_ID NUMBER
Yes Resource Id
Query Text

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


SELECT AUTHORING_ORG_ID
,      CUSTOMER_PARTY_ID
,      TERR_ID
,      RESOURCE_ID
FROM APPS.OKI_HTERR_DTL_V;

Dependencies

[top of page]

APPS.OKI_HTERR_DTL_V references the following:

SchemaAPPS
SynonymOKI_JTF_TERRITORIES

APPS.OKI_HTERR_DTL_V is not referenced by any database object