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

VIEW: APPS.OKC_RESOURCE_GROUPS_V

Object Details
Object Name: OKC_RESOURCE_GROUPS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKC.OKC_RESOURCE_GROUPS_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
GROUP_ID NUMBER
Yes Surrogate key used for primary unique identifiers.
GROUP_NUMBER VARCHAR2 (30) Yes JTF group number
NAME VARCHAR2 (60) Yes Name of resource group, must have role 'CONTRACTS'
DESCRIPTION VARCHAR2 (240)
User entered free format text description.
START_DATE_ACTIVE DATE

Active start date
END_DATE_ACTIVE DATE

Active end date
STATUS VARCHAR2 (1)
DELETE_FLAG VARCHAR2 (1)
Query Text

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


SELECT GROUP_ID
,      GROUP_NUMBER
,      NAME
,      DESCRIPTION
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      STATUS
,      DELETE_FLAG
FROM APPS.OKC_RESOURCE_GROUPS_V;

Dependencies

[top of page]

APPS.OKC_RESOURCE_GROUPS_V references the following:

SchemaAPPS
ViewJTF_RS_GROUPS_VL
ViewOKX_RESOURCE_ROLES_V
APPS.OKC_RESOURCE_GROUPS_V is referenced by following:

SchemaAPPS
Package BodyOKC_CAC_PVT - show dependent code