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

VIEW: APPS.OKS_RESOURCES_V

Object Details
Object Name: OKS_RESOURCES_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKS.OKS_RESOURCES_V
Subobject Name:
Status: VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Row Id
ID NUMBER
Yes Primary Key Identifier
OBJECT_VERSION_NUMBER NUMBER (9) Yes Sequential number set at 1 on insert and incremented on update. Used by APIs to ensure current record is passed.
BUS_PROCESS_CLE_ID NUMBER

Foreign key Column to OKC_K_LINES_B.
DNZ_CHR_ID NUMBER
Yes Unique Identifier for Contract Header, denomalized for efficiency.
RESOURCE_ID1 VARCHAR2 (40)
Foreign key to an OKX view identifitied by corresponding JTOT_OBJECT_CODE column. First part of primary key in view.
RESOURCE_ID2 VARCHAR2 (200)
Foreign key to an OKX view identifitied by corresponding JTOT_OBJECT_CODE column. Second part of primary key in view.
RESOURCE_TYPE VARCHAR2 (30) Yes Refers to CRO_CODE in OKC_CONTACTS_V
JTOT_OBJECT1_CODE VARCHAR2 (30)
Refers to JTOT_OBJECT1_CODE in OKC_CONTACTS_V
PRIMARY_YN VARCHAR2 (1)
Primary Yes/No for the contact
RESOURCE_CLASS VARCHAR2 (30)
Resource Class
Query Text

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


SELECT ROW_ID
,      ID
,      OBJECT_VERSION_NUMBER
,      BUS_PROCESS_CLE_ID
,      DNZ_CHR_ID
,      RESOURCE_ID1
,      RESOURCE_ID2
,      RESOURCE_TYPE
,      JTOT_OBJECT1_CODE
,      PRIMARY_YN
,      RESOURCE_CLASS
FROM APPS.OKS_RESOURCES_V;

Dependencies

[top of page]

APPS.OKS_RESOURCES_V references the following:

SchemaAPPS
SynonymOKC_CONTACTS
SynonymOKC_K_PARTY_ROLES_B

APPS.OKS_RESOURCES_V is not referenced by any database object