VIEW: HR.PQP_CONFIGURATION_VALUES#

Source

View Text - Preformatted

select CONFIGURATION_VALUE_ID CONFIGURATION_VALUE_ID, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, LEGISLATION_CODE LEGISLATION_CODE, PCV_ATTRIBUTE_CATEGORY PCV_ATTRIBUTE_CATEGORY, PCV_ATTRIBUTE1 PCV_ATTRIBUTE1, PCV_ATTRIBUTE2 PCV_ATTRIBUTE2, PCV_ATTRIBUTE3 PCV_ATTRIBUTE3, PCV_ATTRIBUTE4 PCV_ATTRIBUTE4, PCV_ATTRIBUTE5 PCV_ATTRIBUTE5, PCV_ATTRIBUTE6 PCV_ATTRIBUTE6, PCV_ATTRIBUTE7 PCV_ATTRIBUTE7, PCV_ATTRIBUTE8 PCV_ATTRIBUTE8, PCV_ATTRIBUTE9 PCV_ATTRIBUTE9, PCV_ATTRIBUTE10 PCV_ATTRIBUTE10, PCV_ATTRIBUTE11 PCV_ATTRIBUTE11, PCV_ATTRIBUTE12 PCV_ATTRIBUTE12, PCV_ATTRIBUTE13 PCV_ATTRIBUTE13, PCV_ATTRIBUTE14 PCV_ATTRIBUTE14, PCV_ATTRIBUTE15 PCV_ATTRIBUTE15, PCV_ATTRIBUTE16 PCV_ATTRIBUTE16, PCV_ATTRIBUTE17 PCV_ATTRIBUTE17, PCV_ATTRIBUTE18 PCV_ATTRIBUTE18, PCV_ATTRIBUTE19 PCV_ATTRIBUTE19, PCV_ATTRIBUTE20 PCV_ATTRIBUTE20, PCV_INFORMATION_CATEGORY PCV_INFORMATION_CATEGORY, PCV_INFORMATION1 PCV_INFORMATION1, PCV_INFORMATION2 PCV_INFORMATION2, PCV_INFORMATION3 PCV_INFORMATION3, PCV_INFORMATION4 PCV_INFORMATION4, PCV_INFORMATION5 PCV_INFORMATION5, PCV_INFORMATION6 PCV_INFORMATION6, PCV_INFORMATION7 PCV_INFORMATION7, PCV_INFORMATION8 PCV_INFORMATION8, PCV_INFORMATION9 PCV_INFORMATION9, PCV_INFORMATION10 PCV_INFORMATION10, PCV_INFORMATION11 PCV_INFORMATION11, PCV_INFORMATION12 PCV_INFORMATION12, PCV_INFORMATION13 PCV_INFORMATION13, PCV_INFORMATION14 PCV_INFORMATION14, PCV_INFORMATION15 PCV_INFORMATION15, PCV_INFORMATION16 PCV_INFORMATION16, PCV_INFORMATION17 PCV_INFORMATION17, PCV_INFORMATION18 PCV_INFORMATION18, PCV_INFORMATION19 PCV_INFORMATION19, PCV_INFORMATION20 PCV_INFORMATION20, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, CONFIGURATION_NAME CONFIGURATION_NAME, ZD_EDITION_NAME ZD_EDITION_NAME from "HR"."PQP_CONFIGURATION_VALUES"

View Text - HTML Formatted

SELECT CONFIGURATION_VALUE_ID CONFIGURATION_VALUE_ID
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, LEGISLATION_CODE LEGISLATION_CODE
, PCV_ATTRIBUTE_CATEGORY PCV_ATTRIBUTE_CATEGORY
, PCV_ATTRIBUTE1 PCV_ATTRIBUTE1
, PCV_ATTRIBUTE2 PCV_ATTRIBUTE2
, PCV_ATTRIBUTE3 PCV_ATTRIBUTE3
, PCV_ATTRIBUTE4 PCV_ATTRIBUTE4
, PCV_ATTRIBUTE5 PCV_ATTRIBUTE5
, PCV_ATTRIBUTE6 PCV_ATTRIBUTE6
, PCV_ATTRIBUTE7 PCV_ATTRIBUTE7
, PCV_ATTRIBUTE8 PCV_ATTRIBUTE8
, PCV_ATTRIBUTE9 PCV_ATTRIBUTE9
, PCV_ATTRIBUTE10 PCV_ATTRIBUTE10
, PCV_ATTRIBUTE11 PCV_ATTRIBUTE11
, PCV_ATTRIBUTE12 PCV_ATTRIBUTE12
, PCV_ATTRIBUTE13 PCV_ATTRIBUTE13
, PCV_ATTRIBUTE14 PCV_ATTRIBUTE14
, PCV_ATTRIBUTE15 PCV_ATTRIBUTE15
, PCV_ATTRIBUTE16 PCV_ATTRIBUTE16
, PCV_ATTRIBUTE17 PCV_ATTRIBUTE17
, PCV_ATTRIBUTE18 PCV_ATTRIBUTE18
, PCV_ATTRIBUTE19 PCV_ATTRIBUTE19
, PCV_ATTRIBUTE20 PCV_ATTRIBUTE20
, PCV_INFORMATION_CATEGORY PCV_INFORMATION_CATEGORY
, PCV_INFORMATION1 PCV_INFORMATION1
, PCV_INFORMATION2 PCV_INFORMATION2
, PCV_INFORMATION3 PCV_INFORMATION3
, PCV_INFORMATION4 PCV_INFORMATION4
, PCV_INFORMATION5 PCV_INFORMATION5
, PCV_INFORMATION6 PCV_INFORMATION6
, PCV_INFORMATION7 PCV_INFORMATION7
, PCV_INFORMATION8 PCV_INFORMATION8
, PCV_INFORMATION9 PCV_INFORMATION9
, PCV_INFORMATION10 PCV_INFORMATION10
, PCV_INFORMATION11 PCV_INFORMATION11
, PCV_INFORMATION12 PCV_INFORMATION12
, PCV_INFORMATION13 PCV_INFORMATION13
, PCV_INFORMATION14 PCV_INFORMATION14
, PCV_INFORMATION15 PCV_INFORMATION15
, PCV_INFORMATION16 PCV_INFORMATION16
, PCV_INFORMATION17 PCV_INFORMATION17
, PCV_INFORMATION18 PCV_INFORMATION18
, PCV_INFORMATION19 PCV_INFORMATION19
, PCV_INFORMATION20 PCV_INFORMATION20
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, CONFIGURATION_NAME CONFIGURATION_NAME
, ZD_EDITION_NAME ZD_EDITION_NAME
FROM "HR"."PQP_CONFIGURATION_VALUES"