VIEW: APPS.ICX_PER_PEOPLE_X_V

Source

View Text - Preformatted

SELECT "PERSON_ID" , "EFFECTIVE_START_DATE" , "EFFECTIVE_END_DATE" , "BUSINESS_GROUP_ID" , "PERSON_TYPE_ID" , "LAST_NAME" , "START_DATE" , "APPLICANT_NUMBER" , "COMMENT_ID" , "CURRENT_APPLICANT_FLAG" , "CURRENT_EMP_OR_APL_FLAG" , "CURRENT_EMPLOYEE_FLAG" , "DATE_EMPLOYEE_DATA_VERIFIED" , "DATE_OF_BIRTH" , "EMAIL_ADDRESS" , "EMPLOYEE_NUMBER" , "EXPENSE_CHECK_SEND_TO_ADDRESS" , "FIRST_NAME" , "FULL_NAME" , "KNOWN_AS" , "MARITAL_STATUS" , "MIDDLE_NAMES" , "NATIONALITY" , "NATIONAL_IDENTIFIER" , "PREVIOUS_LAST_NAME" , "REGISTERED_DISABLED_FLAG" , "SEX" , "TITLE" , "VENDOR_ID" , "WORK_TELEPHONE" , "REQUEST_ID" , "PROGRAM_APPLICATION_ID" , "PROGRAM_ID" , "PROGRAM_UPDATE_DATE" , "ATTRIBUTE_CATEGORY" , "ATTRIBUTE1" , "ATTRIBUTE2" , "ATTRIBUTE3" , "ATTRIBUTE4" , "ATTRIBUTE5" , "ATTRIBUTE6" , "ATTRIBUTE7" , "ATTRIBUTE8" , "ATTRIBUTE9" , "ATTRIBUTE10" , "ATTRIBUTE11" , "ATTRIBUTE12" , "ATTRIBUTE13" , "ATTRIBUTE14" , "ATTRIBUTE15" , "ATTRIBUTE16" , "ATTRIBUTE17" , "ATTRIBUTE18" , "ATTRIBUTE19" , "ATTRIBUTE20" , "ATTRIBUTE21" , "ATTRIBUTE22" , "ATTRIBUTE23" , "ATTRIBUTE24" , "ATTRIBUTE25" , "ATTRIBUTE26" , "ATTRIBUTE27" , "ATTRIBUTE28" , "ATTRIBUTE29" , "ATTRIBUTE30" , "LAST_UPDATE_DATE" , "LAST_UPDATED_BY" , "LAST_UPDATE_LOGIN" , "CREATED_BY" , "CREATION_DATE" , "PER_INFORMATION_CATEGORY" , "PER_INFORMATION1" , "PER_INFORMATION2" , "PER_INFORMATION3" , "PER_INFORMATION4" , "PER_INFORMATION5" , "PER_INFORMATION6" , "PER_INFORMATION7" , "PER_INFORMATION8" , "PER_INFORMATION9" , "PER_INFORMATION10" , "PER_INFORMATION11" , "PER_INFORMATION12" , "PER_INFORMATION13" , "PER_INFORMATION14" , "PER_INFORMATION15" , "PER_INFORMATION16" , "PER_INFORMATION17" , "PER_INFORMATION18" , "PER_INFORMATION19" , "PER_INFORMATION20" , "OBJECT_VERSION_NUMBER" FROM PER_PEOPLE_X

View Text - HTML Formatted

SELECT "PERSON_ID"
, "EFFECTIVE_START_DATE"
, "EFFECTIVE_END_DATE"
, "BUSINESS_GROUP_ID"
, "PERSON_TYPE_ID"
, "LAST_NAME"
, "START_DATE"
, "APPLICANT_NUMBER"
, "COMMENT_ID"
, "CURRENT_APPLICANT_FLAG"
, "CURRENT_EMP_OR_APL_FLAG"
, "CURRENT_EMPLOYEE_FLAG"
, "DATE_EMPLOYEE_DATA_VERIFIED"
, "DATE_OF_BIRTH"
, "EMAIL_ADDRESS"
, "EMPLOYEE_NUMBER"
, "EXPENSE_CHECK_SEND_TO_ADDRESS"
, "FIRST_NAME"
, "FULL_NAME"
, "KNOWN_AS"
, "MARITAL_STATUS"
, "MIDDLE_NAMES"
, "NATIONALITY"
, "NATIONAL_IDENTIFIER"
, "PREVIOUS_LAST_NAME"
, "REGISTERED_DISABLED_FLAG"
, "SEX"
, "TITLE"
, "VENDOR_ID"
, "WORK_TELEPHONE"
, "REQUEST_ID"
, "PROGRAM_APPLICATION_ID"
, "PROGRAM_ID"
, "PROGRAM_UPDATE_DATE"
, "ATTRIBUTE_CATEGORY"
, "ATTRIBUTE1"
, "ATTRIBUTE2"
, "ATTRIBUTE3"
, "ATTRIBUTE4"
, "ATTRIBUTE5"
, "ATTRIBUTE6"
, "ATTRIBUTE7"
, "ATTRIBUTE8"
, "ATTRIBUTE9"
, "ATTRIBUTE10"
, "ATTRIBUTE11"
, "ATTRIBUTE12"
, "ATTRIBUTE13"
, "ATTRIBUTE14"
, "ATTRIBUTE15"
, "ATTRIBUTE16"
, "ATTRIBUTE17"
, "ATTRIBUTE18"
, "ATTRIBUTE19"
, "ATTRIBUTE20"
, "ATTRIBUTE21"
, "ATTRIBUTE22"
, "ATTRIBUTE23"
, "ATTRIBUTE24"
, "ATTRIBUTE25"
, "ATTRIBUTE26"
, "ATTRIBUTE27"
, "ATTRIBUTE28"
, "ATTRIBUTE29"
, "ATTRIBUTE30"
, "LAST_UPDATE_DATE"
, "LAST_UPDATED_BY"
, "LAST_UPDATE_LOGIN"
, "CREATED_BY"
, "CREATION_DATE"
, "PER_INFORMATION_CATEGORY"
, "PER_INFORMATION1"
, "PER_INFORMATION2"
, "PER_INFORMATION3"
, "PER_INFORMATION4"
, "PER_INFORMATION5"
, "PER_INFORMATION6"
, "PER_INFORMATION7"
, "PER_INFORMATION8"
, "PER_INFORMATION9"
, "PER_INFORMATION10"
, "PER_INFORMATION11"
, "PER_INFORMATION12"
, "PER_INFORMATION13"
, "PER_INFORMATION14"
, "PER_INFORMATION15"
, "PER_INFORMATION16"
, "PER_INFORMATION17"
, "PER_INFORMATION18"
, "PER_INFORMATION19"
, "PER_INFORMATION20"
, "OBJECT_VERSION_NUMBER"
FROM PER_PEOPLE_X