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

VIEW: APPS.HR_SUMMARY_KEY_VALUE

Object Details
Object Name: HR_SUMMARY_KEY_VALUE
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPER.HR_SUMMARY_KEY_VALUE
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)
The row_id.
KEY_VALUE_ID NUMBER (15) Yes System-generated primary key column.
BUSINESS_GROUP_ID NUMBER (15) Yes Foreign key to HR_ORGANIZATION_UNITS.
OBJECT_VERSION_NUMBER NUMBER (9)
System-generated version of the row. Increments by one with each update.
KEY_TYPE_ID NUMBER (15)
Identifies the key type.
ITEM_VALUE_ID NUMBER (15)
Identifies the item value.
NAME VARCHAR2 (240)
The key value.
LAST_UPDATE_DATE DATE

Standard Who column.
LAST_UPDATED_BY NUMBER (15)
Standard Who column.
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column.
CREATED_BY NUMBER (15)
Standard Who column.
CREATION_DATE DATE

Standard Who column.
Query Text

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


SELECT ROW_ID
,      KEY_VALUE_ID
,      BUSINESS_GROUP_ID
,      OBJECT_VERSION_NUMBER
,      KEY_TYPE_ID
,      ITEM_VALUE_ID
,      NAME
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
FROM APPS.HR_SUMMARY_KEY_VALUE;

Dependencies

[top of page]

APPS.HR_SUMMARY_KEY_VALUE references the following:

SchemaAPPS
SynonymHR_SUMMARY
APPS.HR_SUMMARY_KEY_VALUE is referenced by following:

SchemaAPPS
Package BodyHRSUMREP - show dependent code
ViewHR_SUMMARY_KEY_VALUES_BAND_V
ViewHR_SUMMARY_KEY_VALUES_ESTAB_V
ViewHR_SUMMARY_KEY_VALUES_LOOKUP_V
ViewHR_SUMMARY_KEY_VALUES_V
Package BodyHR_SUMMARY_UTIL - show dependent code
Package BodyHR_SUM_STORE - show dependent code