DBA Data[Home] [Help]

VIEW: APPS.IGS_HE_UT_LVL_AWARD_V

Source

View Text - Preformatted

SELECT Hutla.rowid, hutla.Tariff_calc_type_cd, hutla.Tariff_Level_cd, hutla.Award_cd, pa.award_title, hutla.Default_Award_Ind, hutla.Closed_ind, hutla.created_by, hutla.creation_date, hutla.last_updated_by, hutla.last_update_date, hutla.last_update_login FROM igs_he_ut_lvl_award hutla , igs_ps_awd pa WHERE hutla.award_cd = pa.award_cd
View Text - HTML Formatted

SELECT HUTLA.ROWID
, HUTLA.TARIFF_CALC_TYPE_CD
, HUTLA.TARIFF_LEVEL_CD
, HUTLA.AWARD_CD
, PA.AWARD_TITLE
, HUTLA.DEFAULT_AWARD_IND
, HUTLA.CLOSED_IND
, HUTLA.CREATED_BY
, HUTLA.CREATION_DATE
, HUTLA.LAST_UPDATED_BY
, HUTLA.LAST_UPDATE_DATE
, HUTLA.LAST_UPDATE_LOGIN
FROM IGS_HE_UT_LVL_AWARD HUTLA
, IGS_PS_AWD PA
WHERE HUTLA.AWARD_CD = PA.AWARD_CD