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

VIEW: APPS.GHR_ADDRESSES_H_V

Object Details
Object Name: GHR_ADDRESSES_H_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewGHR.GHR_ADDRESSES_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 Personnel Action History ID
PROCESS_DATE DATE
Yes Process Date
EFFECTIVE_DATE DATE
Yes Effective Date of Personnel Action.
DML_OPERATION VARCHAR2 (1)
DML Operation
PRE_VALUES_FLAG VARCHAR2 (1)
Pre Values existed
ALTERED_PA_REQUEST_ID NUMBER (15)
Personnel Action ID for the Original Action
PA_REQUEST_ID NUMBER (15)
Personnel Action ID for the current Action
NATURE_OF_ACTION_ID NUMBER (15)
Nature of Action ID
ADDRESS_ID NUMBER

Address ID
PERSON_ID NUMBER

Person Identifier
DATE_FROM DATE

Start date at the address
PRIMARY_FLAG VARCHAR2 (30)
Primary Flag
STYLE VARCHAR2 (30)
Address Style
ADDRESS_LINE1 VARCHAR2 (240)
The first line of address
ADDRESS_LINE2 VARCHAR2 (240)
The second line of address
ADDRESS_LINE3 VARCHAR2 (240)
The third line of address
ADDRESS_TYPE VARCHAR2 (30)
Type of Address
COUNTRY VARCHAR2 (60)
Country
DATE_TO DATE

End date at the address
POSTAL_CODE VARCHAR2 (30)
Postal Code
REGION_1 VARCHAR2 (120)
Region 1 Info
REGION_2 VARCHAR2 (120)
Region 2 Info
REGION_3 VARCHAR2 (120)
Region 3 Info
TELEPHONE_NUMBER_1 VARCHAR2 (60)
Telephone Number 1
TELEPHONE_NUMBER_2 VARCHAR2 (60)
Telephone Number 2
TELEPHONE_NUMBER_3 VARCHAR2 (60)
Telephone Number 3
TOWN_OR_CITY VARCHAR2 (30)
Town OR City
REQUEST_ID NUMBER

Request ID
PROGRAM_APPLICATION_ID NUMBER

Program Application ID
PROGRAM_ID NUMBER

Program ID
PROGRAM_UPDATE_DATE DATE

Program Update Date
ADDR_ATTRIBUTE_CATEGORY VARCHAR2 (30)
Determines context of the Address Descriptive Flexfield in parameters.
ADDR_ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield
ADDR_ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield
ADDR_ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield
ADDR_ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield
ADDR_ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield
ADDR_ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield
ADDR_ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield
ADDR_ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield
ADDR_ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield
ADDR_ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield
ADDR_ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield
ADDR_ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield
ADDR_ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield
ADDR_ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield
ADDR_ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield
ADDR_ATTRIBUTE16 VARCHAR2 (150)
Descriptive flexfield
ADDR_ATTRIBUTE17 VARCHAR2 (150)
Descriptive flexfield
ADDR_ATTRIBUTE18 VARCHAR2 (150)
Descriptive flexfield
ADDR_ATTRIBUTE19 VARCHAR2 (150)
Descriptive flexfield
ADDR_ATTRIBUTE20 VARCHAR2 (150)
Descriptive flexfield
BUSINESS_GROUP_ID NUMBER

Business Group ID of the Record
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
,      ADDRESS_ID
,      PERSON_ID
,      DATE_FROM
,      PRIMARY_FLAG
,      STYLE
,      ADDRESS_LINE1
,      ADDRESS_LINE2
,      ADDRESS_LINE3
,      ADDRESS_TYPE
,      COUNTRY
,      DATE_TO
,      POSTAL_CODE
,      REGION_1
,      REGION_2
,      REGION_3
,      TELEPHONE_NUMBER_1
,      TELEPHONE_NUMBER_2
,      TELEPHONE_NUMBER_3
,      TOWN_OR_CITY
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ADDR_ATTRIBUTE_CATEGORY
,      ADDR_ATTRIBUTE1
,      ADDR_ATTRIBUTE2
,      ADDR_ATTRIBUTE3
,      ADDR_ATTRIBUTE4
,      ADDR_ATTRIBUTE5
,      ADDR_ATTRIBUTE6
,      ADDR_ATTRIBUTE7
,      ADDR_ATTRIBUTE8
,      ADDR_ATTRIBUTE9
,      ADDR_ATTRIBUTE10
,      ADDR_ATTRIBUTE11
,      ADDR_ATTRIBUTE12
,      ADDR_ATTRIBUTE13
,      ADDR_ATTRIBUTE14
,      ADDR_ATTRIBUTE15
,      ADDR_ATTRIBUTE16
,      ADDR_ATTRIBUTE17
,      ADDR_ATTRIBUTE18
,      ADDR_ATTRIBUTE19
,      ADDR_ATTRIBUTE20
,      BUSINESS_GROUP_ID
FROM APPS.GHR_ADDRESSES_H_V;

Dependencies

[top of page]

APPS.GHR_ADDRESSES_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_ADDRESSES_H_V is referenced by following:

SchemaAPPS
Package BodyGHR_HISTORY_CONV_RG - show dependent code
PL/SQL PackageGHR_HISTORY_CONV_RG - show dependent code
PL/SQL PackageGHR_US_NFC_EXTRACTS - show dependent code
Package BodyGHR_US_NFC_EXTRACTS - show dependent code