VIEW: APPS.IGS_PS_UNT_REPT_FMLY_V

Source

View Text - Preformatted

SELECT urf.rowid row_id, urf.unit_repeat_family_id unit_repeat_family_id, urf.unit_code unit_code, urf.unit_version_number unit_version_number, urf.repeat_fmly_unit_code repeat_fmly_unit_code, urf.repeat_fmly_unit_version_num repeat_fmly_unit_version_num, uv.title unit_title, urf.created_by created_by, urf.creation_date creation_date, urf.last_updated_by last_updated_by, urf.last_update_date last_update_date, urf.last_update_login last_update_login FROM igs_ps_unt_rept_fmly urf, igs_ps_unit_ver uv WHERE urf.repeat_fmly_unit_code = uv.unit_cd AND urf.repeat_fmly_unit_version_num = uv.version_number

View Text - HTML Formatted

SELECT URF.ROWID ROW_ID
, URF.UNIT_REPEAT_FAMILY_ID UNIT_REPEAT_FAMILY_ID
, URF.UNIT_CODE UNIT_CODE
, URF.UNIT_VERSION_NUMBER UNIT_VERSION_NUMBER
, URF.REPEAT_FMLY_UNIT_CODE REPEAT_FMLY_UNIT_CODE
, URF.REPEAT_FMLY_UNIT_VERSION_NUM REPEAT_FMLY_UNIT_VERSION_NUM
, UV.TITLE UNIT_TITLE
, URF.CREATED_BY CREATED_BY
, URF.CREATION_DATE CREATION_DATE
, URF.LAST_UPDATED_BY LAST_UPDATED_BY
, URF.LAST_UPDATE_DATE LAST_UPDATE_DATE
, URF.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_PS_UNT_REPT_FMLY URF
, IGS_PS_UNIT_VER UV
WHERE URF.REPEAT_FMLY_UNIT_CODE = UV.UNIT_CD
AND URF.REPEAT_FMLY_UNIT_VERSION_NUM = UV.VERSION_NUMBER