VIEW: APPS.IGS_PE_HZ_PARTIES_SV

Source

View Text - Preformatted

SELECT PD.PARTY_ID, PD.DECEASED_IND, PD.ARCHIVE_EXCLUSION_IND, PD.ARCHIVE_DT, PD.PURGE_EXCLUSION_IND, PD.PURGE_DT, PD.ORACLE_USERNAME, PD.PROOF_OF_INS, PD.PROOF_OF_IMMU, PD.LEVEL_OF_QUAL, PD.MILITARY_SERVICE_REG, PD.VETERAN, PD.INSTITUTION_CD, PD.OI_LOCAL_INSTITUTION_IND, PD.OI_OS_IND, PD.OI_GOVT_INSTITUTION_CD, PD.OI_INST_CONTROL_TYPE, PD.OI_INSTITUTION_TYPE, PD.OI_INSTITUTION_STATUS, PD.OU_START_DT, PD.OU_END_DT, PD.OU_MEMBER_TYPE, PD.OU_ORG_STATUS, PD.OU_ORG_TYPE, PD.INST_ORG_IND, PD.INST_PRIORITY_CD, PD.INST_EPS_CODE, PD.INST_PHONE_COUNTRY_CODE, PD.INST_PHONE_AREA_CODE, PD.INST_PHONE_NUMBER, PD.ADV_STUDIES_CLASSES, PD.HONORS_CLASSES, PD.CLASS_SIZE, PD.SEC_SCHOOL_LOCATION_ID, PD.PERCENT_PLAN_HIGHER_EDU, PD.FUND_AUTHORIZATION, PD.PE_INFO_VERIFY_TIME, PD.CREATED_BY, PD.CREATION_DATE, PD.LAST_UPDATED_BY, PD.LAST_UPDATE_DATE, PD.LAST_UPDATE_LOGIN, PD.REQUEST_ID, PD.PROGRAM_APPLICATION_ID, PD.PROGRAM_ID, PD.PROGRAM_UPDATE_DATE, PD.BIRTH_CITY, PD.BIRTH_COUNTRY, PD.OSS_ORG_UNIT_CD , PD.FELONY_CONVICTED_FLAG FROM IGS_PE_HZ_PARTIES PD

View Text - HTML Formatted

SELECT PD.PARTY_ID
, PD.DECEASED_IND
, PD.ARCHIVE_EXCLUSION_IND
, PD.ARCHIVE_DT
, PD.PURGE_EXCLUSION_IND
, PD.PURGE_DT
, PD.ORACLE_USERNAME
, PD.PROOF_OF_INS
, PD.PROOF_OF_IMMU
, PD.LEVEL_OF_QUAL
, PD.MILITARY_SERVICE_REG
, PD.VETERAN
, PD.INSTITUTION_CD
, PD.OI_LOCAL_INSTITUTION_IND
, PD.OI_OS_IND
, PD.OI_GOVT_INSTITUTION_CD
, PD.OI_INST_CONTROL_TYPE
, PD.OI_INSTITUTION_TYPE
, PD.OI_INSTITUTION_STATUS
, PD.OU_START_DT
, PD.OU_END_DT
, PD.OU_MEMBER_TYPE
, PD.OU_ORG_STATUS
, PD.OU_ORG_TYPE
, PD.INST_ORG_IND
, PD.INST_PRIORITY_CD
, PD.INST_EPS_CODE
, PD.INST_PHONE_COUNTRY_CODE
, PD.INST_PHONE_AREA_CODE
, PD.INST_PHONE_NUMBER
, PD.ADV_STUDIES_CLASSES
, PD.HONORS_CLASSES
, PD.CLASS_SIZE
, PD.SEC_SCHOOL_LOCATION_ID
, PD.PERCENT_PLAN_HIGHER_EDU
, PD.FUND_AUTHORIZATION
, PD.PE_INFO_VERIFY_TIME
, PD.CREATED_BY
, PD.CREATION_DATE
, PD.LAST_UPDATED_BY
, PD.LAST_UPDATE_DATE
, PD.LAST_UPDATE_LOGIN
, PD.REQUEST_ID
, PD.PROGRAM_APPLICATION_ID
, PD.PROGRAM_ID
, PD.PROGRAM_UPDATE_DATE
, PD.BIRTH_CITY
, PD.BIRTH_COUNTRY
, PD.OSS_ORG_UNIT_CD
, PD.FELONY_CONVICTED_FLAG
FROM IGS_PE_HZ_PARTIES PD