Product: | GHR - US Federal Human Resources |
---|---|
Description: | Mapping of GHR_PA_HISTORY columns to PER_ADDRESSES. |
Implementation/DBA Data: | APPS.GHR_ADDRESSES_H_V |
SELECT PA_HISTORY_ID
, PROCESS_DATE
, EFFECTIVE_DATE
, DML_OPERATION
, PRE_VALUES_FLAG
, ALTERED_PA_REQUEST_ID
, PA_REQUEST_ID
, NATURE_OF_ACTION_ID
, GHR_GENERAL.RETURN_NUMBER(INFORMATION1) ADDRESS_ID
, GHR_GENERAL.RETURN_NUMBER(INFORMATION5) PERSON_ID
, FND_DATE.CANONICAL_TO_DATE(INFORMATION6) DATE_FROM
, SUBSTR(INFORMATION7
, 1
, 30) PRIMARY_FLAG
, SUBSTR(INFORMATION8
, 1
, 30) STYLE
, SUBSTR(INFORMATION9
, 1
, 240) ADDRESS_LINE1
, SUBSTR(INFORMATION10
, 1
, 240) ADDRESS_LINE2
, SUBSTR(INFORMATION11
, 1
, 240) ADDRESS_LINE3
, SUBSTR(INFORMATION12
, 1
, 30) ADDRESS_TYPE
, SUBSTR(INFORMATION14
, 1
, 60) COUNTRY
, FND_DATE.CANONICAL_TO_DATE(INFORMATION15) DATE_TO
, SUBSTR(INFORMATION16
, 1
, 30) POSTAL_CODE
, SUBSTR(INFORMATION17
, 1
, 120) REGION_1
, SUBSTR(INFORMATION18
, 1
, 120) REGION_2
, SUBSTR(INFORMATION19
, 1
, 120) REGION_3
, SUBSTR(INFORMATION20
, 1
, 60) TELEPHONE_NUMBER_1
, SUBSTR(INFORMATION21
, 1
, 60) TELEPHONE_NUMBER_2
, SUBSTR(INFORMATION22
, 1
, 60) TELEPHONE_NUMBER_3
, SUBSTR(INFORMATION13
, 1
, 30) TOWN_OR_CITY
, GHR_GENERAL.RETURN_NUMBER(INFORMATION121) REQUEST_ID
, GHR_GENERAL.RETURN_NUMBER(INFORMATION122) PROGRAM_APPLICATION_ID
, GHR_GENERAL.RETURN_NUMBER(INFORMATION123) PROGRAM_ID
, FND_DATE.CANONICAL_TO_DATE(INFORMATION124) PROGRAM_UPDATE_DATE
, SUBSTR(INFORMATION125
, 1
, 30) ADDR_ATTRIBUTE_CATEGORY
, SUBSTR(INFORMATION126
, 1
, 150) ADDR_ATTRIBUTE1
, SUBSTR(INFORMATION127
, 1
, 150) ADDR_ATTRIBUTE2
, SUBSTR(INFORMATION128
, 1
, 150) ADDR_ATTRIBUTE3
, SUBSTR(INFORMATION129
, 1
, 150) ADDR_ATTRIBUTE4
, SUBSTR(INFORMATION130
, 1
, 150) ADDR_ATTRIBUTE5
, SUBSTR(INFORMATION131
, 1
, 150) ADDR_ATTRIBUTE6
, SUBSTR(INFORMATION132
, 1
, 150) ADDR_ATTRIBUTE7
, SUBSTR(INFORMATION133
, 1
, 150) ADDR_ATTRIBUTE8
, SUBSTR(INFORMATION134
, 1
, 150) ADDR_ATTRIBUTE9
, SUBSTR(INFORMATION135
, 1
, 150) ADDR_ATTRIBUTE10
, SUBSTR(INFORMATION136
, 1
, 150) ADDR_ATTRIBUTE11
, SUBSTR(INFORMATION137
, 1
, 150) ADDR_ATTRIBUTE12
, SUBSTR(INFORMATION138
, 1
, 150) ADDR_ATTRIBUTE13
, SUBSTR(INFORMATION139
, 1
, 150) ADDR_ATTRIBUTE14
, SUBSTR(INFORMATION140
, 1
, 150) ADDR_ATTRIBUTE15
, SUBSTR(INFORMATION141
, 1
, 150) ADDR_ATTRIBUTE16
, SUBSTR(INFORMATION142
, 1
, 150) ADDR_ATTRIBUTE17
, SUBSTR(INFORMATION143
, 1
, 150) ADDR_ATTRIBUTE18
, SUBSTR(INFORMATION144
, 1
, 150) ADDR_ATTRIBUTE19
, SUBSTR(INFORMATION145
, 1
, 150) ADDR_ATTRIBUTE20
, GHR_GENERAL.RETURN_NUMBER(INFORMATION152) BUSINESS_GROUP_ID
FROM GHR_PA_HISTORY
WHERE TABLE_NAME = 'PER_ADDRESSES'