VIEW: APPS.IGSBV_STORED_PLACEMENTS

Source

View Text - Preformatted

SELECT SPLAC.SPLACEMENT_ID, SPLAC.PERSON_ID, SPLAC.COURSE_CD, SPLAC.UOO_ID, SPLAC.START_DATE, SPLAC.END_DATE, SPLAC.INSTITUTION_CODE, SPLAC.TITLE, SPLAC.DESCRIPTION, SPLAC.CATEGORY_CODE, SPLAC.PLACEMENT_TYPE_CODE, SPLAC.SPECIALTY_CODE, SPLAC.COMPENSATION_FLAG, SPLAC.ATTENDANCE_TYPE, SPLAC.LOCATION, SPLAC.NOTES, PE.PARTY_NUMBER, UOO.UNIT_CD, UOO.VERSION_NUMBER, UOO.UNIT_CLASS, UOO.LOCATION_CD, INST.PARTY_NAME, SPLAC.CREATED_BY, SPLAC.CREATION_DATE, SPLAC.LAST_UPDATED_BY, SPLAC.LAST_UPDATE_DATE FROM IGS_EN_SPLACEMENTS SPLAC, HZ_PARTIES PE, HZ_PARTIES INST, IGS_PE_HZ_PARTIES IHP, IGS_PS_UNIT_OFR_OPT_ALL UOO WHERE SPLAC.PERSON_ID = PE.PARTY_ID AND SPLAC.UOO_ID = UOO.UOO_ID AND INST.PARTY_ID = IHP.PARTY_ID AND SPLAC.INSTITUTION_CODE = IHP.OSS_ORG_UNIT_CD WITH READ ONLY

View Text - HTML Formatted

SELECT SPLAC.SPLACEMENT_ID
, SPLAC.PERSON_ID
, SPLAC.COURSE_CD
, SPLAC.UOO_ID
, SPLAC.START_DATE
, SPLAC.END_DATE
, SPLAC.INSTITUTION_CODE
, SPLAC.TITLE
, SPLAC.DESCRIPTION
, SPLAC.CATEGORY_CODE
, SPLAC.PLACEMENT_TYPE_CODE
, SPLAC.SPECIALTY_CODE
, SPLAC.COMPENSATION_FLAG
, SPLAC.ATTENDANCE_TYPE
, SPLAC.LOCATION
, SPLAC.NOTES
, PE.PARTY_NUMBER
, UOO.UNIT_CD
, UOO.VERSION_NUMBER
, UOO.UNIT_CLASS
, UOO.LOCATION_CD
, INST.PARTY_NAME
, SPLAC.CREATED_BY
, SPLAC.CREATION_DATE
, SPLAC.LAST_UPDATED_BY
, SPLAC.LAST_UPDATE_DATE
FROM IGS_EN_SPLACEMENTS SPLAC
, HZ_PARTIES PE
, HZ_PARTIES INST
, IGS_PE_HZ_PARTIES IHP
, IGS_PS_UNIT_OFR_OPT_ALL UOO
WHERE SPLAC.PERSON_ID = PE.PARTY_ID
AND SPLAC.UOO_ID = UOO.UOO_ID
AND INST.PARTY_ID = IHP.PARTY_ID
AND SPLAC.INSTITUTION_CODE = IHP.OSS_ORG_UNIT_CD WITH READ ONLY