Product: | IGS - Student System (Obsolete) |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT ARD.REVGR_INCL_EXCL_ID
, ARD.APPL_REVPROF_REVGR_ID
, ARG.REVPROF_REVGR_CD
, ARG.REVPROF_REVGR_NAME
, '_LA:ARD.INCL_EXCL_IND:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, ARD.START_VALUE
, ARD.END_VALUE
, ARD.VERSION_NUMBER
, ARD.COUNTRY
, FT.TERRITORY_SHORT_NAME
, '_LA:ARD.POSTAL_INCL_EXCL_IND:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, ARD.POSTAL_START_VALUE
, ARD.POSTAL_END_VALUE
, ARD.CREATED_BY
, ARD.CREATION_DATE
, ARD.LAST_UPDATED_BY
, ARD.LAST_UPDATE_DATE
FROM IGS_AD_RVGR_INC_EXC ARD
, IGS_AD_APL_RPRF_RGR ARG
, FND_TERRITORIES_TL FT
WHERE ARD.COUNTRY = FT.TERRITORY_CODE(+)
AND FT.LANGUAGE = USERENV('LANG')
AND ARD.APPL_REVPROF_REVGR_ID = ARG.APPL_REVPROF_REVGR_ID WITH READ ONLY