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

VIEW: APPS.HR_SUMMARY_RUN_VALUES_X2_V

Object Details
Object Name: HR_SUMMARY_RUN_VALUES_X2_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPER.HR_SUMMARY_RUN_VALUES_X2_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
PROCESS_RUN_NAME VARCHAR2 (240)
The process_run_name from HR_SUMMARY_PROCESS_RUN.
PROCESS_RUN_TYPE VARCHAR2 (240)
The process_type from HR_SUMMARY_PROCESS_RUN.
PROCESS_RUN_ID NUMBER (15)
The process_run_id from HR_SUMMARY_PROCESS_RUN.
SEQUENCE_NUMBER1 NUMBER

SEQUENCE_NUMBER2 NUMBER

The sequence_number from HR_SUMMARY_ITEM_TYPE_USAGE.
ITEM_VALUE_ID NUMBER (15)
The item_value_id from HR_SUMMARY_ITEM_VALUE.
ITEM_USAGE1_ITEM_VALUE1 NUMBER

ITEM_USAGE1_ITEM_VALUE2 NUMBER

ITEM_USAGE2_ITEM_VALUE1 NUMBER

The numvalue1 column from HR_SUMMARY_ITEM_VALUE.
ITEM_USAGE2_ITEM_VALUE2 NUMBER

The numvalue2 column from HR_SUMMARY_ITEM_VALUE.
Query Text

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


SELECT PROCESS_RUN_NAME
,      PROCESS_RUN_TYPE
,      PROCESS_RUN_ID
,      SEQUENCE_NUMBER1
,      SEQUENCE_NUMBER2
,      ITEM_VALUE_ID
,      ITEM_USAGE1_ITEM_VALUE1
,      ITEM_USAGE1_ITEM_VALUE2
,      ITEM_USAGE2_ITEM_VALUE1
,      ITEM_USAGE2_ITEM_VALUE2
FROM APPS.HR_SUMMARY_RUN_VALUES_X2_V;

Dependencies

[top of page]

APPS.HR_SUMMARY_RUN_VALUES_X2_V references the following:

SchemaAPPS
PL/SQL PackageHR_GENERAL - show dependent code
ViewHR_SUMMARY_ITEM_TYPE_USAGE
ViewHR_SUMMARY_ITEM_VALUE
ViewHR_SUMMARY_PROCESS_RUN

APPS.HR_SUMMARY_RUN_VALUES_X2_V is not referenced by any database object