View: IGSBV_ORGANIZATION_UNIT_PARTY

Product:	IGS - Student System
Description:	IGS_PE_HZ_PARTIES describes the attributes of the person
Implementation/DBA Data:	APPS.IGSBV_ORGANIZATION_UNIT_PARTY

View Text

SELECT HP.PARTY_ID
, PHP.OSS_ORG_UNIT_CD ORG_UNIT_CODE
, HP.PARTY_NUMBER TCA_PARTY_NUMBER
, HP.PARTY_NAME
, PHP.INSTITUTION_CD
, PHP.OU_START_DT
, PHP.OU_END_DT
, '_LA:PHP.OU_MEMBER_TYPE:IGS_LOOKUP_VALUES:OR_MEMBER_TYPE:MEANING'
, PHP.OU_ORG_STATUS
, '_LA:PHP.OU_ORG_TYPE:IGS_LOOKUP_VALUES:OR_ORG_TYPE:MEANING'
, PHP.CREATED_BY
, PHP.CREATION_DATE
, PHP.LAST_UPDATED_BY
, PHP.LAST_UPDATE_DATE
, PHP.LAST_UPDATE_LOGIN
FROM IGS_PE_HZ_PARTIES PHP
, HZ_PARTIES HP
WHERE HP.PARTY_ID = PHP.PARTY_ID
AND HP.PARTY_TYPE = 'ORGANIZATION'
AND PHP.INST_ORG_IND = 'O' WITH READ ONLY

Columns