VIEW: APPS.GHR_MT_ADDRESSES_V

Source

View Text - Preformatted

SELECT INTERFACE_ID GHR_INTERFACE_ID , PROCESS_DATE MT_PROCESS_DATE , SOURCE_NAME MT_SOURCE , DATE_FROM MT_EFFECTIVE_DATE , INFORMATION1 MT_NAME , INFORMATION2 MT_STATUS , INFORMATION3 MT_PERSON_ID , INFORMATION4 MT_TABLE_NAME , INFORMATION5 MT_INFORMATION_TYPE , INFORMATION6 MT_INTER_BG_TRANSFER , INFORMATION7 MT_CONTACT_NAME , INFORMATION8 MT_CONTACT_TYPE , INFORMATION9 ADDRESS_ID , INFORMATION10 BUSINESS_GROUP_ID , INFORMATION11 PERSON_ID , INFORMATION12 DATE_FROM , INFORMATION13 PRIMARY_FLAG , INFORMATION14 STYLE , INFORMATION15 ADDRESS_LINE1 , INFORMATION16 ADDRESS_LINE2 , INFORMATION17 ADDRESS_LINE3 , INFORMATION18 ADDRESS_TYPE , INFORMATION19 COMMENTS , INFORMATION20 COUNTRY , INFORMATION21 DATE_TO , INFORMATION22 POSTAL_CODE , INFORMATION23 REGION_1 , INFORMATION24 REGION_2 , INFORMATION25 REGION_3 , INFORMATION26 TELEPHONE_NUMBER_1 , INFORMATION27 TELEPHONE_NUMBER_2 , INFORMATION28 TELEPHONE_NUMBER_3 , INFORMATION29 TOWN_OR_CITY , INFORMATION30 REQUEST_ID , INFORMATION31 PROGRAM_APPLICATION_ID, INFORMATION32 PROGRAM_ID , INFORMATION33 PROGRAM_UPDATE_DATE , INFORMATION34 ADDR_ATTRIBUTE_CATEGORY , INFORMATION35 ADDR_ATTRIBUTE1 , INFORMATION36 ADDR_ATTRIBUTE2 , INFORMATION37 ADDR_ATTRIBUTE3 , INFORMATION38 ADDR_ATTRIBUTE4 , INFORMATION39 ADDR_ATTRIBUTE5 , INFORMATION40 ADDR_ATTRIBUTE6 , INFORMATION41 ADDR_ATTRIBUTE7 , INFORMATION42 ADDR_ATTRIBUTE8 , INFORMATION43 ADDR_ATTRIBUTE9 , INFORMATION44 ADDR_ATTRIBUTE10 , INFORMATION45 ADDR_ATTRIBUTE11 , INFORMATION46 ADDR_ATTRIBUTE12 , INFORMATION47 ADDR_ATTRIBUTE13 , INFORMATION48 ADDR_ATTRIBUTE14 , INFORMATION49 ADDR_ATTRIBUTE15 , INFORMATION50 ADDR_ATTRIBUTE16 , INFORMATION51 ADDR_ATTRIBUTE17 , INFORMATION52 ADDR_ATTRIBUTE18 , INFORMATION53 ADDR_ATTRIBUTE19 , INFORMATION54 ADDR_ATTRIBUTE20 , INFORMATION55 LAST_UPDATE_DATE , INFORMATION56 LAST_UPDATED_BY , INFORMATION57 LAST_UPDATE_LOGIN , INFORMATION58 CREATED_BY , INFORMATION59 CREATION_DATE , INFORMATION60 OBJECT_VERSION_NUMBER FROM GHR_INTERFACE WHERE INFORMATION4 = 'PER_ADDRESSES'

View Text - HTML Formatted

SELECT INTERFACE_ID GHR_INTERFACE_ID
, PROCESS_DATE MT_PROCESS_DATE
, SOURCE_NAME MT_SOURCE
, DATE_FROM MT_EFFECTIVE_DATE
, INFORMATION1 MT_NAME
, INFORMATION2 MT_STATUS
, INFORMATION3 MT_PERSON_ID
, INFORMATION4 MT_TABLE_NAME
, INFORMATION5 MT_INFORMATION_TYPE
, INFORMATION6 MT_INTER_BG_TRANSFER
, INFORMATION7 MT_CONTACT_NAME
, INFORMATION8 MT_CONTACT_TYPE
, INFORMATION9 ADDRESS_ID
, INFORMATION10 BUSINESS_GROUP_ID
, INFORMATION11 PERSON_ID
, INFORMATION12 DATE_FROM
, INFORMATION13 PRIMARY_FLAG
, INFORMATION14 STYLE
, INFORMATION15 ADDRESS_LINE1
, INFORMATION16 ADDRESS_LINE2
, INFORMATION17 ADDRESS_LINE3
, INFORMATION18 ADDRESS_TYPE
, INFORMATION19 COMMENTS
, INFORMATION20 COUNTRY
, INFORMATION21 DATE_TO
, INFORMATION22 POSTAL_CODE
, INFORMATION23 REGION_1
, INFORMATION24 REGION_2
, INFORMATION25 REGION_3
, INFORMATION26 TELEPHONE_NUMBER_1
, INFORMATION27 TELEPHONE_NUMBER_2
, INFORMATION28 TELEPHONE_NUMBER_3
, INFORMATION29 TOWN_OR_CITY
, INFORMATION30 REQUEST_ID
, INFORMATION31 PROGRAM_APPLICATION_ID
, INFORMATION32 PROGRAM_ID
, INFORMATION33 PROGRAM_UPDATE_DATE
, INFORMATION34 ADDR_ATTRIBUTE_CATEGORY
, INFORMATION35 ADDR_ATTRIBUTE1
, INFORMATION36 ADDR_ATTRIBUTE2
, INFORMATION37 ADDR_ATTRIBUTE3
, INFORMATION38 ADDR_ATTRIBUTE4
, INFORMATION39 ADDR_ATTRIBUTE5
, INFORMATION40 ADDR_ATTRIBUTE6
, INFORMATION41 ADDR_ATTRIBUTE7
, INFORMATION42 ADDR_ATTRIBUTE8
, INFORMATION43 ADDR_ATTRIBUTE9
, INFORMATION44 ADDR_ATTRIBUTE10
, INFORMATION45 ADDR_ATTRIBUTE11
, INFORMATION46 ADDR_ATTRIBUTE12
, INFORMATION47 ADDR_ATTRIBUTE13
, INFORMATION48 ADDR_ATTRIBUTE14
, INFORMATION49 ADDR_ATTRIBUTE15
, INFORMATION50 ADDR_ATTRIBUTE16
, INFORMATION51 ADDR_ATTRIBUTE17
, INFORMATION52 ADDR_ATTRIBUTE18
, INFORMATION53 ADDR_ATTRIBUTE19
, INFORMATION54 ADDR_ATTRIBUTE20
, INFORMATION55 LAST_UPDATE_DATE
, INFORMATION56 LAST_UPDATED_BY
, INFORMATION57 LAST_UPDATE_LOGIN
, INFORMATION58 CREATED_BY
, INFORMATION59 CREATION_DATE
, INFORMATION60 OBJECT_VERSION_NUMBER
FROM GHR_INTERFACE
WHERE INFORMATION4 = 'PER_ADDRESSES'