VIEW: APPS.IGS_PS_SCH_X_USEC_INT

Source

View Text - Preformatted

SELECT tab.rowid row_id, tab.int_usec_x_usec_id int_usec_x_usec_id, tab.int_usec_id int_usec_id, tab.unit_sec_cross_unit_sec_id unit_sec_cross_unit_sec_id, tab.parent_uoo_id parent_uoo_id, tab.child_uoo_id child_uoo_id, tab.child_unit_cd child_unit_cd, tab.child_version_number child_version_number, tab.child_title child_title, tab.child_cal_type child_cal_type, tab.child_alternate_code child_alternate_code, tab.start_dt start_dt, tab.end_dt end_dt, tab.child_ci_sequence_number child_ci_sequence_number, tab.child_unit_class child_unit_class, tab.child_unit_mode child_unit_mode, tab.child_location_cd child_location_cd, tab.child_location_description child_location_description, tab.org_id org_id, tab.cross_list_group_name, tab.class_max_enrollment_number, tab.created_by created_by, tab.creation_date creation_date, tab.last_updated_by last_updated_by, tab.last_update_date last_update_date, tab.last_update_login last_update_login FROM igs_ps_sch_x_usec_int_all tab

View Text - HTML Formatted

SELECT TAB.ROWID ROW_ID
, TAB.INT_USEC_X_USEC_ID INT_USEC_X_USEC_ID
, TAB.INT_USEC_ID INT_USEC_ID
, TAB.UNIT_SEC_CROSS_UNIT_SEC_ID UNIT_SEC_CROSS_UNIT_SEC_ID
, TAB.PARENT_UOO_ID PARENT_UOO_ID
, TAB.CHILD_UOO_ID CHILD_UOO_ID
, TAB.CHILD_UNIT_CD CHILD_UNIT_CD
, TAB.CHILD_VERSION_NUMBER CHILD_VERSION_NUMBER
, TAB.CHILD_TITLE CHILD_TITLE
, TAB.CHILD_CAL_TYPE CHILD_CAL_TYPE
, TAB.CHILD_ALTERNATE_CODE CHILD_ALTERNATE_CODE
, TAB.START_DT START_DT
, TAB.END_DT END_DT
, TAB.CHILD_CI_SEQUENCE_NUMBER CHILD_CI_SEQUENCE_NUMBER
, TAB.CHILD_UNIT_CLASS CHILD_UNIT_CLASS
, TAB.CHILD_UNIT_MODE CHILD_UNIT_MODE
, TAB.CHILD_LOCATION_CD CHILD_LOCATION_CD
, TAB.CHILD_LOCATION_DESCRIPTION CHILD_LOCATION_DESCRIPTION
, TAB.ORG_ID ORG_ID
, TAB.CROSS_LIST_GROUP_NAME
, TAB.CLASS_MAX_ENROLLMENT_NUMBER
, TAB.CREATED_BY CREATED_BY
, TAB.CREATION_DATE CREATION_DATE
, TAB.LAST_UPDATED_BY LAST_UPDATED_BY
, TAB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, TAB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_PS_SCH_X_USEC_INT_ALL TAB