VIEW: APPS.IGS_PS_USEC_RPT_FMLY_V

Source

View Text - Preformatted

SELECT usrf.rowid row_id, usrf.unit_section_repeat_family_id unit_section_repeat_family_id, usrf.uoo_id uoo_id, usrf.repeat_family_unit_cd repeat_family_unit_cd, usrf.repeat_family_version_number repeat_family_version_number, uv.title title, usrf.created_by created_by, usrf.creation_date creation_date, usrf.last_updated_by last_updated_by, usrf.last_update_date last_update_date, usrf.last_update_login last_update_login FROM igs_ps_unit_ver uv, igs_ps_usec_rpt_fmly usrf WHERE uv.unit_cd = usrf.repeat_family_unit_cd AND uv.version_number = usrf.repeat_family_version_number

View Text - HTML Formatted

SELECT USRF.ROWID ROW_ID
, USRF.UNIT_SECTION_REPEAT_FAMILY_ID UNIT_SECTION_REPEAT_FAMILY_ID
, USRF.UOO_ID UOO_ID
, USRF.REPEAT_FAMILY_UNIT_CD REPEAT_FAMILY_UNIT_CD
, USRF.REPEAT_FAMILY_VERSION_NUMBER REPEAT_FAMILY_VERSION_NUMBER
, UV.TITLE TITLE
, USRF.CREATED_BY CREATED_BY
, USRF.CREATION_DATE CREATION_DATE
, USRF.LAST_UPDATED_BY LAST_UPDATED_BY
, USRF.LAST_UPDATE_DATE LAST_UPDATE_DATE
, USRF.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_PS_UNIT_VER UV
, IGS_PS_USEC_RPT_FMLY USRF
WHERE UV.UNIT_CD = USRF.REPEAT_FAMILY_UNIT_CD
AND UV.VERSION_NUMBER = USRF.REPEAT_FAMILY_VERSION_NUMBER