View: UMX_PERSON_PVT_V

Product:	FND - Application Object Library
Description:	Private view used by UMX to secure people stored in TCA
Implementation/DBA Data:	APPS.UMX_PERSON_PVT_V

View Text

SELECT PARTY_ID
, PARTY_NAME
, PARTY_NUMBER
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, WH_UPDATE_DATE
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, PERSON_PRE_NAME_ADJUNCT
, PERSON_FIRST_NAME
, PERSON_MIDDLE_NAME
, PERSON_LAST_NAME
, PERSON_NAME_SUFFIX
, PERSON_TITLE
, PERSON_ACADEMIC_TITLE
, PERSON_PREVIOUS_LAST_NAME
, KNOWN_AS
, TAX_NAME
, PERSON_FIRST_NAME_PHONETIC
, PERSON_LAST_NAME_PHONETIC
, TAX_REFERENCE
, JGZZ_FISCAL_CODE
, PERSON_IDEN_TYPE
, PERSON_IDENTIFIER
, KNOWN_AS2
, KNOWN_AS3
, KNOWN_AS4
, KNOWN_AS5
, STATUS
, OBJECT_VERSION_NUMBER
, CREATED_BY_MODULE
, ORIG_SYSTEM_REFERENCE
, APPLICATION_ID
, COUNTRY
, ADDRESS1
, ADDRESS2
, ADDRESS3
, ADDRESS4
, CITY
, POSTAL_CODE
, STATE
, PROVINCE
, COUNTY
, EMAIL_ADDRESS
FROM HZ_PARTIES
WHERE PARTY_TYPE = 'PERSON'

Columns