VIEW: APPS.IGS_PE_HZ_PARTIES_V

Source

View Text - Preformatted

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(+)

View Text - HTML Formatted

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(+)