VIEW: APPS.IGS_PS_USEC_X_GRP_V

Source

View Text - Preformatted

SELECT usxg.rowid row_id, usxg.usec_x_listed_group_id usec_x_listed_group_id, usxg.usec_x_listed_group_name usec_x_listed_group_name, usxg.location_inheritance location_inheritance, usxg.cal_type cal_type, usxg.ci_sequence_number ci_sequence_number, ci.alternate_code alternate_code, ci.start_dt start_dt, ci.end_dt end_dt, usxg.created_by created_by, usxg.creation_date creation_date, usxg.last_updated_by last_updated_by, usxg.last_update_date last_update_date, usxg.last_update_login last_update_login, usxg.max_enr_group, usxg.max_ovr_group FROM igs_ps_usec_x_grp usxg, igs_ca_inst ci WHERE usxg.cal_type = ci.cal_type AND usxg.ci_sequence_number = ci.sequence_number

View Text - HTML Formatted

SELECT USXG.ROWID ROW_ID
, USXG.USEC_X_LISTED_GROUP_ID USEC_X_LISTED_GROUP_ID
, USXG.USEC_X_LISTED_GROUP_NAME USEC_X_LISTED_GROUP_NAME
, USXG.LOCATION_INHERITANCE LOCATION_INHERITANCE
, USXG.CAL_TYPE CAL_TYPE
, USXG.CI_SEQUENCE_NUMBER CI_SEQUENCE_NUMBER
, CI.ALTERNATE_CODE ALTERNATE_CODE
, CI.START_DT START_DT
, CI.END_DT END_DT
, USXG.CREATED_BY CREATED_BY
, USXG.CREATION_DATE CREATION_DATE
, USXG.LAST_UPDATED_BY LAST_UPDATED_BY
, USXG.LAST_UPDATE_DATE LAST_UPDATE_DATE
, USXG.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, USXG.MAX_ENR_GROUP
, USXG.MAX_OVR_GROUP
FROM IGS_PS_USEC_X_GRP USXG
, IGS_CA_INST CI
WHERE USXG.CAL_TYPE = CI.CAL_TYPE
AND USXG.CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER