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

VIEW: APPS.OKS_RESOURCES_HV

Object Details
Object Name: OKS_RESOURCES_HV
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKS.OKS_RESOURCES_HV
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 Identifier
ID NUMBER
Yes Primary 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.
MAJOR_VERSION NUMBER (4) Yes Tracks the primary version number of a contract.
BUS_PROCESS_CLE_ID NUMBER

Business Process Line Identifier
DNZ_CHR_ID NUMBER
Yes Unique Identifier for Contract Header, denomalized for efficiency.
RESOURCE_ID1 VARCHAR2 (40)
Resource Identifier1
RESOURCE_ID2 VARCHAR2 (200)
DNZ CHR Identifier2
RESOURCE_TYPE VARCHAR2 (30) Yes Resource Type
JTOT_OBJECT1_CODE VARCHAR2 (30)
Object Code
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
,      MAJOR_VERSION
,      BUS_PROCESS_CLE_ID
,      DNZ_CHR_ID
,      RESOURCE_ID1
,      RESOURCE_ID2
,      RESOURCE_TYPE
,      JTOT_OBJECT1_CODE
,      RESOURCE_CLASS
FROM APPS.OKS_RESOURCES_HV;

Dependencies

[top of page]

APPS.OKS_RESOURCES_HV references the following:

SchemaAPPS
PL/SQL PackageFND_GLOBAL - show dependent code
SynonymOKC_CONTACTS_H
ViewOKC_K_PARTY_ROLES_HV

APPS.OKS_RESOURCES_HV is not referenced by any database object