VIEW: APPS.IGS_PS_AWD_HNR_BASE_V

Source

View Text - Preformatted

SELECT AHB.ROWID ROW_ID, AHB. AWD_HNR_BASIS_ID, AHB.AWARD_CD, AHB.UNIT_LEVEL, UL.DESCRIPTION UNIT_LEVEL_DESC, AHB.WEIGHTED_AVERAGE, AHB. STAT_TYPE, AHB.S_STAT_ELEMENT, LKUP.MEANING AS S_STAT_ELE_MEANING, AHB.TIMEFRAME, AHB.CREATED_BY, AHB.CREATION_DATE, AHB.LAST_UPDATED_BY, AHB.LAST_UPDATE_DATE, AHB.LAST_UPDATE_LOGIN FROM IGS_PS_AWD_HNR_BASE AHB, IGS_PS_UNIT_LEVEL_ALL UL, IGS_LOOKUP_VALUES LKUP WHERE AHB.UNIT_LEVEL = UL.UNIT_LEVEL(+) AND AHB.S_STAT_ELEMENT = LKUP.LOOKUP_CODE(+) AND LKUP.LOOKUP_TYPE (+)= 'SYSTEM_STAT_ELEMENT'

View Text - HTML Formatted

SELECT AHB.ROWID ROW_ID
, AHB. AWD_HNR_BASIS_ID
, AHB.AWARD_CD
, AHB.UNIT_LEVEL
, UL.DESCRIPTION UNIT_LEVEL_DESC
, AHB.WEIGHTED_AVERAGE
, AHB. STAT_TYPE
, AHB.S_STAT_ELEMENT
, LKUP.MEANING AS S_STAT_ELE_MEANING
, AHB.TIMEFRAME
, AHB.CREATED_BY
, AHB.CREATION_DATE
, AHB.LAST_UPDATED_BY
, AHB.LAST_UPDATE_DATE
, AHB.LAST_UPDATE_LOGIN
FROM IGS_PS_AWD_HNR_BASE AHB
, IGS_PS_UNIT_LEVEL_ALL UL
, IGS_LOOKUP_VALUES LKUP
WHERE AHB.UNIT_LEVEL = UL.UNIT_LEVEL(+)
AND AHB.S_STAT_ELEMENT = LKUP.LOOKUP_CODE(+)
AND LKUP.LOOKUP_TYPE (+)= 'SYSTEM_STAT_ELEMENT'