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

VIEW: APPS.GHR_POSITION_EXTRA_INFO_H_V

Object Details
Object Name: GHR_POSITION_EXTRA_INFO_H_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewGHR.GHR_POSITION_EXTRA_INFO_H_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
PA_HISTORY_ID NUMBER (15) Yes PA History ID
PROCESS_DATE DATE
Yes Process Date
EFFECTIVE_DATE DATE
Yes Effective Date
DML_OPERATION VARCHAR2 (1)
DML Operation
PRE_VALUES_FLAG VARCHAR2 (1)
Pre Values Flag
ALTERED_PA_REQUEST_ID NUMBER (15)
Personnel Action ID of Original Action
PA_REQUEST_ID NUMBER (15)
Personnel Action ID
NATURE_OF_ACTION_ID NUMBER (15)
Nature of Action ID
POSITION_EXTRA_INFO_ID NUMBER

Position Extra Info ID
POSITION_ID NUMBER

Position ID
INFORMATION_TYPE VARCHAR2 (40)
Information Type
POEI_INFORMATION_CATEGORY VARCHAR2 (30)
Information Category for Developer Descriptive Flexfield columns.
POEI_INFORMATION1 VARCHAR2 (150)
Developer Descriptive Flexfield
POEI_INFORMATION2 VARCHAR2 (150)
Developer Descriptive Flexfield
POEI_INFORMATION3 VARCHAR2 (150)
Developer Descriptive Flexfield
POEI_INFORMATION4 VARCHAR2 (150)
Developer Descriptive Flexfield
POEI_INFORMATION5 VARCHAR2 (150)
Developer Descriptive Flexfield
POEI_INFORMATION6 VARCHAR2 (150)
Developer Descriptive Flexfield
POEI_INFORMATION7 VARCHAR2 (150)
Developer Descriptive Flexfield
POEI_INFORMATION8 VARCHAR2 (150)
Developer Descriptive Flexfield
POEI_INFORMATION9 VARCHAR2 (150)
Developer Descriptive Flexfield
POEI_INFORMATION10 VARCHAR2 (150)
Developer Descriptive Flexfield
POEI_INFORMATION11 VARCHAR2 (150)
Developer Descriptive Flexfield
POEI_INFORMATION12 VARCHAR2 (150)
Developer Descriptive Flexfield
POEI_INFORMATION13 VARCHAR2 (150)
Developer Descriptive Flexfield
POEI_INFORMATION14 VARCHAR2 (150)
Developer Descriptive Flexfield
POEI_INFORMATION15 VARCHAR2 (150)
Developer Descriptive Flexfield
POEI_INFORMATION16 VARCHAR2 (150)
Developer Descriptive Flexfield
POEI_INFORMATION17 VARCHAR2 (150)
Developer Descriptive Flexfield
POEI_INFORMATION18 VARCHAR2 (150)
Developer Descriptive Flexfield
POEI_INFORMATION19 VARCHAR2 (150)
Developer Descriptive Flexfield
POEI_INFORMATION20 VARCHAR2 (150)
Developer Descriptive Flexfield
POEI_INFORMATION21 VARCHAR2 (150)
Developer Descriptive Flexfield
POEI_INFORMATION22 VARCHAR2 (150)
Developer Descriptive Flexfield
POEI_INFORMATION23 VARCHAR2 (150)
Developer Descriptive Flexfield
POEI_INFORMATION24 VARCHAR2 (150)
Developer Descriptive Flexfield
POEI_INFORMATION25 VARCHAR2 (150)
Developer Descriptive Flexfield
POEI_INFORMATION26 VARCHAR2 (150)
Developer Descriptive Flexfield
POEI_INFORMATION27 VARCHAR2 (150)
Developer Descriptive Flexfield
POEI_INFORMATION28 VARCHAR2 (150)
Developer Descriptive Flexfield
POEI_INFORMATION29 VARCHAR2 (150)
Developer Descriptive Flexfield
POEI_INFORMATION30 VARCHAR2 (150)
Developer Descriptive Flexfield
REQUEST_ID NUMBER

Request ID
PROGRAM_APPLICATION_ID NUMBER

Program Application ID
PROGRAM_ID NUMBER

Program ID
PROGRAM_UPDATE_DATE DATE

Program Update Date
POEI_ATTRIBUTE_CATEGORY VARCHAR2 (30)
Attribute Category for Descriptive Flexfield columns
POEI_ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield
POEI_ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield
POEI_ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield
POEI_ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield
POEI_ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield
POEI_ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield
POEI_ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield
POEI_ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield
POEI_ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield
POEI_ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield
POEI_ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield
POEI_ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield
POEI_ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield
POEI_ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield
POEI_ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield
POEI_ATTRIBUTE16 VARCHAR2 (150)
Descriptive Flexfield
POEI_ATTRIBUTE17 VARCHAR2 (150)
Descriptive Flexfield
POEI_ATTRIBUTE18 VARCHAR2 (150)
Descriptive Flexfield
POEI_ATTRIBUTE19 VARCHAR2 (150)
Descriptive Flexfield
POEI_ATTRIBUTE20 VARCHAR2 (150)
Descriptive FlexfieldDescriptive Flexfield
Query Text

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


SELECT PA_HISTORY_ID
,      PROCESS_DATE
,      EFFECTIVE_DATE
,      DML_OPERATION
,      PRE_VALUES_FLAG
,      ALTERED_PA_REQUEST_ID
,      PA_REQUEST_ID
,      NATURE_OF_ACTION_ID
,      POSITION_EXTRA_INFO_ID
,      POSITION_ID
,      INFORMATION_TYPE
,      POEI_INFORMATION_CATEGORY
,      POEI_INFORMATION1
,      POEI_INFORMATION2
,      POEI_INFORMATION3
,      POEI_INFORMATION4
,      POEI_INFORMATION5
,      POEI_INFORMATION6
,      POEI_INFORMATION7
,      POEI_INFORMATION8
,      POEI_INFORMATION9
,      POEI_INFORMATION10
,      POEI_INFORMATION11
,      POEI_INFORMATION12
,      POEI_INFORMATION13
,      POEI_INFORMATION14
,      POEI_INFORMATION15
,      POEI_INFORMATION16
,      POEI_INFORMATION17
,      POEI_INFORMATION18
,      POEI_INFORMATION19
,      POEI_INFORMATION20
,      POEI_INFORMATION21
,      POEI_INFORMATION22
,      POEI_INFORMATION23
,      POEI_INFORMATION24
,      POEI_INFORMATION25
,      POEI_INFORMATION26
,      POEI_INFORMATION27
,      POEI_INFORMATION28
,      POEI_INFORMATION29
,      POEI_INFORMATION30
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      POEI_ATTRIBUTE_CATEGORY
,      POEI_ATTRIBUTE1
,      POEI_ATTRIBUTE2
,      POEI_ATTRIBUTE3
,      POEI_ATTRIBUTE4
,      POEI_ATTRIBUTE5
,      POEI_ATTRIBUTE6
,      POEI_ATTRIBUTE7
,      POEI_ATTRIBUTE8
,      POEI_ATTRIBUTE9
,      POEI_ATTRIBUTE10
,      POEI_ATTRIBUTE11
,      POEI_ATTRIBUTE12
,      POEI_ATTRIBUTE13
,      POEI_ATTRIBUTE14
,      POEI_ATTRIBUTE15
,      POEI_ATTRIBUTE16
,      POEI_ATTRIBUTE17
,      POEI_ATTRIBUTE18
,      POEI_ATTRIBUTE19
,      POEI_ATTRIBUTE20
FROM APPS.GHR_POSITION_EXTRA_INFO_H_V;

Dependencies

[top of page]

APPS.GHR_POSITION_EXTRA_INFO_H_V references the following:

SchemaAPPS
PL/SQL PackageFND_DATE - show dependent code
PL/SQL PackageGHR_GENERAL - show dependent code
SynonymGHR_PA_HISTORY
APPS.GHR_POSITION_EXTRA_INFO_H_V is referenced by following:

SchemaAPPS
Package BodyGHR_HISTORY_CONV_RG - show dependent code
PL/SQL PackageGHR_HISTORY_CONV_RG - show dependent code
Package BodyGHR_HISTORY_FETCH - show dependent code