VIEW: APPS.IGSFV_APPL_REVIEW_GROUP_DETAIL

Source

View Text - Preformatted

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

View Text - HTML Formatted

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