VIEW: APPS.POS_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