DBA Data[Home] [Help]

VIEW: APPS.IGS_PS_USEC_CATEGORY_V

Source

View Text - Preformatted

SELECT usct.rowid, usct.usec_cat_id, usct.uoo_id, usct.unit_cat, ucat.description, usct.created_by, usct.creation_date, usct.last_updated_by, usct.last_update_date, usct.last_update_login FROM igs_ps_usec_category usct, igs_ps_unit_cat ucat WHERE usct.unit_cat = ucat.unit_cat
View Text - HTML Formatted

SELECT USCT.ROWID
, USCT.USEC_CAT_ID
, USCT.UOO_ID
, USCT.UNIT_CAT
, UCAT.DESCRIPTION
, USCT.CREATED_BY
, USCT.CREATION_DATE
, USCT.LAST_UPDATED_BY
, USCT.LAST_UPDATE_DATE
, USCT.LAST_UPDATE_LOGIN
FROM IGS_PS_USEC_CATEGORY USCT
, IGS_PS_UNIT_CAT UCAT
WHERE USCT.UNIT_CAT = UCAT.UNIT_CAT