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

VIEW: APPS.HR_SUMMARY_ITEM_VALUE

Object Details
Object Name: HR_SUMMARY_ITEM_VALUE
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPER.HR_SUMMARY_ITEM_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.
ITEM_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.
PROCESS_RUN_ID NUMBER (15)
Identifies the process run.
ITEM_TYPE_USAGE_ID NUMBER (15)
Identifies the item type usage.
TEXTVALUE VARCHAR2 (240)
The item value.
NUMVALUE1 NUMBER (22)
The item value.
NUMVALUE2 NUMBER (22)
The item value.
DATEVALUE DATE

The item 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
,      ITEM_VALUE_ID
,      BUSINESS_GROUP_ID
,      OBJECT_VERSION_NUMBER
,      PROCESS_RUN_ID
,      ITEM_TYPE_USAGE_ID
,      TEXTVALUE
,      NUMVALUE1
,      NUMVALUE2
,      DATEVALUE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
FROM APPS.HR_SUMMARY_ITEM_VALUE;

Dependencies

[top of page]

APPS.HR_SUMMARY_ITEM_VALUE references the following:

SchemaAPPS
SynonymHR_SUMMARY
APPS.HR_SUMMARY_ITEM_VALUE is referenced by following:

SchemaAPPS
Package BodyHRSUMREP - show dependent code
ViewHR_SUMMARY_RUN_VALUES_V
ViewHR_SUMMARY_RUN_VALUES_X2_V