XML element InstitutionTypeGets the Institution codes for the requested Institution. Base on the institution_cd passed in the XML whereclase.
Implementation/DBA Data:
Not implemented in this database
View Text
SELECT OAI.ORG_ALTERNATE_ID_TYPE , OAI.ORG_ALTERNATE_ID , '' , OAI.ORG_STRUCTURE_ID FROM IGS_OR_ORG_ALT_IDS OAI , IGS_DA_SETUP DS WHERE OAI.ORG_ALTERNATE_ID_TYPE = DS.DEFAULT_INST_ID_TYPE AND OAI.END_DATE IS NULL AND DS.S_CONTROL_NUM = 1 UNION ALL SELECT 'OSS' , HP.PARTY_NUMBER , '' , HP.PARTY_NUMBER FROM HZ_PARTIES HP WHERE NOT EXISTS(SELECT 'X' FROM IGS_OR_ORG_ALT_IDS OAI , IGS_DA_SETUP DS , IGS_PE_HZ_PARTIES IPZ WHERE OAI.ORG_ALTERNATE_ID_TYPE = DS.DEFAULT_INST_ID_TYPE AND OAI.END_DATE IS NULL AND DS.S_CONTROL_NUM = 1 AND OAI.ORG_STRUCTURE_ID = IPZ.OSS_ORG_UNIT_CD AND IPZ.PARTY_ID = HP.PARTY_ID)