SELECT FUNIT.ROW_ID, FUNIT.FUNIT_ID, FUNIT.FUND_ID, FUNIT.UNIT_CD, UN.TITLE, FUNIT.VERSION_NUMBER, FUNIT.CREATED_BY, FUNIT.CREATION_DATE, FUNIT.LAST_UPDATED_BY, FUNIT.LAST_UPDATE_DATE, FUNIT.LAST_UPDATE_LOGIN FROM IGF_AW_FUND_UNIT FUNIT, IGS_PS_UNIT_VER UN WHERE FUNIT.UNIT_CD = UN.UNIT_CD AND FUNIT.VERSION_NUMBER = UN.VERSION_NUMBER
SELECT FUNIT.ROW_ID
, FUNIT.FUNIT_ID
, FUNIT.FUND_ID
, FUNIT.UNIT_CD
, UN.TITLE
, FUNIT.VERSION_NUMBER
, FUNIT.CREATED_BY
, FUNIT.CREATION_DATE
, FUNIT.LAST_UPDATED_BY
, FUNIT.LAST_UPDATE_DATE
, FUNIT.LAST_UPDATE_LOGIN
FROM IGF_AW_FUND_UNIT FUNIT
, IGS_PS_UNIT_VER UN
WHERE FUNIT.UNIT_CD = UN.UNIT_CD
AND FUNIT.VERSION_NUMBER = UN.VERSION_NUMBER
|
|
|