VIEW: APPS.IGS_PS_USEC_X_USEC_V

Source

View Text - Preformatted

SELECT usxgm_chld.rowid row_id, usxgm_chld.usec_x_listed_group_mem_id unit_sec_cross_unit_sec_id, usxgm.uoo_id parent_uoo_id, usxgm_chld.uoo_id child_uoo_id, uoo.unit_cd child_unit_cd, uoo.version_number child_version_number, uv.title child_title, uoo.cal_type child_cal_type, ci.alternate_code child_alternate_code, ci.start_dt start_dt, ci.end_dt end_dt, uoo.ci_sequence_number child_ci_sequence_number, uoo.unit_class child_unit_class, uc.unit_mode child_unit_mode, uoo.location_cd child_location_cd, loc.description child_location_description, usxgm_chld.created_by created_by, usxgm_chld.creation_date creation_date, usxgm_chld.last_updated_by last_updated_by, usxgm_chld.last_update_date last_update_date, usxgm_chld.last_update_login last_update_login FROM igs_ps_unit_ver uv, igs_ps_usec_x_grpmem usxgm, igs_ps_usec_x_grpmem usxgm_chld, igs_ca_inst ci, igs_as_unit_class uc, igs_ps_unit_ofr_opt uoo, igs_ad_location loc WHERE uoo.uoo_id = usxgm_chld.uoo_id AND uoo.unit_cd = uv.unit_cd AND uoo.version_number = uv.version_number AND uoo.unit_class = uc.unit_class AND uoo.cal_type = ci.cal_type AND uoo.ci_sequence_number = ci.sequence_number AND uoo.location_cd = loc.location_cd AND usxgm.usec_x_listed_group_id = usxgm_chld.usec_x_listed_group_id AND usxgm.parent = 'Y' AND usxgm_chld.parent = 'N'

View Text - HTML Formatted

SELECT USXGM_CHLD.ROWID ROW_ID
, USXGM_CHLD.USEC_X_LISTED_GROUP_MEM_ID UNIT_SEC_CROSS_UNIT_SEC_ID
, USXGM.UOO_ID PARENT_UOO_ID
, USXGM_CHLD.UOO_ID CHILD_UOO_ID
, UOO.UNIT_CD CHILD_UNIT_CD
, UOO.VERSION_NUMBER CHILD_VERSION_NUMBER
, UV.TITLE CHILD_TITLE
, UOO.CAL_TYPE CHILD_CAL_TYPE
, CI.ALTERNATE_CODE CHILD_ALTERNATE_CODE
, CI.START_DT START_DT
, CI.END_DT END_DT
, UOO.CI_SEQUENCE_NUMBER CHILD_CI_SEQUENCE_NUMBER
, UOO.UNIT_CLASS CHILD_UNIT_CLASS
, UC.UNIT_MODE CHILD_UNIT_MODE
, UOO.LOCATION_CD CHILD_LOCATION_CD
, LOC.DESCRIPTION CHILD_LOCATION_DESCRIPTION
, USXGM_CHLD.CREATED_BY CREATED_BY
, USXGM_CHLD.CREATION_DATE CREATION_DATE
, USXGM_CHLD.LAST_UPDATED_BY LAST_UPDATED_BY
, USXGM_CHLD.LAST_UPDATE_DATE LAST_UPDATE_DATE
, USXGM_CHLD.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_PS_UNIT_VER UV
, IGS_PS_USEC_X_GRPMEM USXGM
, IGS_PS_USEC_X_GRPMEM USXGM_CHLD
, IGS_CA_INST CI
, IGS_AS_UNIT_CLASS UC
, IGS_PS_UNIT_OFR_OPT UOO
, IGS_AD_LOCATION LOC
WHERE UOO.UOO_ID = USXGM_CHLD.UOO_ID
AND UOO.UNIT_CD = UV.UNIT_CD
AND UOO.VERSION_NUMBER = UV.VERSION_NUMBER
AND UOO.UNIT_CLASS = UC.UNIT_CLASS
AND UOO.CAL_TYPE = CI.CAL_TYPE
AND UOO.CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER
AND UOO.LOCATION_CD = LOC.LOCATION_CD
AND USXGM.USEC_X_LISTED_GROUP_ID = USXGM_CHLD.USEC_X_LISTED_GROUP_ID
AND USXGM.PARENT = 'Y'
AND USXGM_CHLD.PARENT = 'N'