Product: | IGS - Student System (Obsolete) |
---|---|
Description: | View based on the person extension table |
Implementation/DBA Data: | Not implemented in this database |
SELECT PHP.ROWID
, PHP.PARTY_ID
, PHP.BIRTH_CITY
, PHP.BIRTH_COUNTRY
, TER.TERRITORY_SHORT_NAME MEANING
, PHP.CREATED_BY
, PHP.CREATION_DATE
, PHP.CREATED_BY
, PHP.CREATION_DATE
, PHP.LAST_UPDATE_LOGIN
, PHP.DECEASED_IND
, PHP.ARCHIVE_EXCLUSION_IND
, PHP.ARCHIVE_DT
, PHP.PURGE_EXCLUSION_IND
, PHP.PURGE_DT
, PHP.ORACLE_USERNAME
, PHP.PROOF_OF_INS
, PHP.PROOF_OF_IMMU
, PHP.LEVEL_OF_QUAL
, PHP.MILITARY_SERVICE_REG
, PHP.VETERAN
, PHP.INSTITUTION_CD
, PHP.OI_LOCAL_INSTITUTION_IND
, PHP.OI_OS_IND
, PHP.OI_GOVT_INSTITUTION_CD
, PHP.OI_INST_CONTROL_TYPE
, PHP.OI_INSTITUTION_TYPE
, PHP.OI_INSTITUTION_STATUS
, PHP.OU_START_DT
, PHP.OU_END_DT
, PHP.OU_MEMBER_TYPE
, PHP.OU_ORG_STATUS
, PHP.OU_ORG_TYPE
, PHP.INST_ORG_IND
, PHP.INST_EPS_CODE
, PHP.INST_PHONE_COUNTRY_CODE
, PHP.INST_PHONE_AREA_CODE
, PHP.INST_PHONE_NUMBER
, PHP.ADV_STUDIES_CLASSES
, PHP.HONORS_CLASSES
, PHP.CLASS_SIZE
, PHP.SEC_SCHOOL_LOCATION_ID
, PHP.PERCENT_PLAN_HIGHER_EDU
, PHP.FUND_AUTHORIZATION
, PHP.PE_INFO_VERIFY_TIME
, PHP.INST_PRIORITY_CD
, PHP.FELONY_CONVICTED_FLAG
, PHP.OSS_ORG_UNIT_CD
FROM IGS_PE_HZ_PARTIES PHP
, FND_TERRITORIES_VL TER
WHERE PHP.BIRTH_COUNTRY = TER.TERRITORY_CODE(+)