View: POS_PER_PEOPLE_X_V

Product:	PO - Purchasing
Description:
Implementation/DBA Data:	APPS.POS_PER_PEOPLE_X_V

View Text

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

Columns