VIEW: APPS.HR_DM_EXP_ORG_INFO_V

Source

View Text - Preformatted

SELECT EXP_IMP_ID, TABLE_NAME, PVAL001 ORG_INFORMATION_ID, PVAL002 ORG_INFORMATION_CONTEXT, PVAL003 ORGANIZATION_ID, PVAL004 ORG_INFORMATION1, PVAL005 ORG_INFORMATION10, PVAL006 ORG_INFORMATION11, PVAL007 ORG_INFORMATION12, PVAL008 ORG_INFORMATION13, PVAL009 ORG_INFORMATION14, PVAL010 ORG_INFORMATION15, PVAL011 ORG_INFORMATION16, PVAL012 ORG_INFORMATION17, PVAL013 ORG_INFORMATION18, PVAL014 ORG_INFORMATION19, PVAL015 ORG_INFORMATION2, PVAL016 ORG_INFORMATION20, PVAL017 ORG_INFORMATION3, PVAL018 ORG_INFORMATION4, PVAL019 ORG_INFORMATION5, PVAL020 ORG_INFORMATION6, PVAL021 ORG_INFORMATION7, PVAL022 ORG_INFORMATION8, PVAL023 ORG_INFORMATION9, PVAL024 REQUEST_ID, PVAL025 PROGRAM_APPLICATION_ID, PVAL026 PROGRAM_ID, PVAL027 PROGRAM_UPDATE_DATE, PVAL028 ATTRIBUTE_CATEGORY, PVAL029 ATTRIBUTE1, PVAL030 ATTRIBUTE2, PVAL031 ATTRIBUTE3, PVAL032 ATTRIBUTE4, PVAL033 ATTRIBUTE5, PVAL034 ATTRIBUTE6, PVAL035 ATTRIBUTE7, PVAL036 ATTRIBUTE8, PVAL037 ATTRIBUTE9, PVAL038 ATTRIBUTE10, PVAL039 ATTRIBUTE11, PVAL040 ATTRIBUTE12, PVAL041 ATTRIBUTE13, PVAL042 ATTRIBUTE14, PVAL043 ATTRIBUTE15, PVAL044 ATTRIBUTE16, PVAL045 ATTRIBUTE17, PVAL046 ATTRIBUTE18, PVAL047 ATTRIBUTE19, PVAL048 ATTRIBUTE20, PVAL049 LAST_UPDATE_DATE, PVAL050 LAST_UPDATED_BY, PVAL051 LAST_UPDATE_LOGIN, PVAL052 CREATED_BY, PVAL053 CREATION_DATE FROM hr_dm_exp_imps WHERE table_name = 'HR_ORGANIZATION_INFORMATION'

View Text - HTML Formatted

SELECT EXP_IMP_ID
, TABLE_NAME
, PVAL001 ORG_INFORMATION_ID
, PVAL002 ORG_INFORMATION_CONTEXT
, PVAL003 ORGANIZATION_ID
, PVAL004 ORG_INFORMATION1
, PVAL005 ORG_INFORMATION10
, PVAL006 ORG_INFORMATION11
, PVAL007 ORG_INFORMATION12
, PVAL008 ORG_INFORMATION13
, PVAL009 ORG_INFORMATION14
, PVAL010 ORG_INFORMATION15
, PVAL011 ORG_INFORMATION16
, PVAL012 ORG_INFORMATION17
, PVAL013 ORG_INFORMATION18
, PVAL014 ORG_INFORMATION19
, PVAL015 ORG_INFORMATION2
, PVAL016 ORG_INFORMATION20
, PVAL017 ORG_INFORMATION3
, PVAL018 ORG_INFORMATION4
, PVAL019 ORG_INFORMATION5
, PVAL020 ORG_INFORMATION6
, PVAL021 ORG_INFORMATION7
, PVAL022 ORG_INFORMATION8
, PVAL023 ORG_INFORMATION9
, PVAL024 REQUEST_ID
, PVAL025 PROGRAM_APPLICATION_ID
, PVAL026 PROGRAM_ID
, PVAL027 PROGRAM_UPDATE_DATE
, PVAL028 ATTRIBUTE_CATEGORY
, PVAL029 ATTRIBUTE1
, PVAL030 ATTRIBUTE2
, PVAL031 ATTRIBUTE3
, PVAL032 ATTRIBUTE4
, PVAL033 ATTRIBUTE5
, PVAL034 ATTRIBUTE6
, PVAL035 ATTRIBUTE7
, PVAL036 ATTRIBUTE8
, PVAL037 ATTRIBUTE9
, PVAL038 ATTRIBUTE10
, PVAL039 ATTRIBUTE11
, PVAL040 ATTRIBUTE12
, PVAL041 ATTRIBUTE13
, PVAL042 ATTRIBUTE14
, PVAL043 ATTRIBUTE15
, PVAL044 ATTRIBUTE16
, PVAL045 ATTRIBUTE17
, PVAL046 ATTRIBUTE18
, PVAL047 ATTRIBUTE19
, PVAL048 ATTRIBUTE20
, PVAL049 LAST_UPDATE_DATE
, PVAL050 LAST_UPDATED_BY
, PVAL051 LAST_UPDATE_LOGIN
, PVAL052 CREATED_BY
, PVAL053 CREATION_DATE
FROM HR_DM_EXP_IMPS
WHERE TABLE_NAME = 'HR_ORGANIZATION_INFORMATION'