VIEW: APPS.IGSBV_APPL_REVIEW_PROFILE

Source

View Text - Preformatted

SELECT aar.APPL_REV_PROFILE_ID, aar.REVIEW_PROFILE_NAME, aar.START_DATE, aar.END_DATE, aar.MIN_EVALUATOR, aar.MAX_EVALUATOR, '_LA:aar.PROG_APPROVAL_REQUIRED:IGS_LOOKUP_VALUES:YES_NO:MEANING', '_LA:aar.SEQUENTIAL_CONCURRENT_IND:IGS_LOOKUP_VALUES:ADM_EVAL_TYPE:MEANING', '_LA:aar.APPL_REV_PROFILE_GR_CD:AR_LOOKUPS:IGS_APPL_REVIEW_PROFILE_GROUP:MEANING', '_LA:aar.SITE_USE_CODE:IGS_LOOKUP_VALUES:PARTY_SITE_USE_CODE:MEANING', '_LA:aar.CLOSED_IND:IGS_LOOKUP_VALUES:YES_NO:MEANING', aar.CREATED_BY, aar.CREATION_DATE, aar.LAST_UPDATED_BY, aar.LAST_UPDATE_DATE FROM IGS_AD_APL_REV_PRF_ALL aar WITH READ ONLY

View Text - HTML Formatted

SELECT AAR.APPL_REV_PROFILE_ID
, AAR.REVIEW_PROFILE_NAME
, AAR.START_DATE
, AAR.END_DATE
, AAR.MIN_EVALUATOR
, AAR.MAX_EVALUATOR
, '_LA:AAR.PROG_APPROVAL_REQUIRED:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, '_LA:AAR.SEQUENTIAL_CONCURRENT_IND:IGS_LOOKUP_VALUES:ADM_EVAL_TYPE:MEANING'
, '_LA:AAR.APPL_REV_PROFILE_GR_CD:AR_LOOKUPS:IGS_APPL_REVIEW_PROFILE_GROUP:MEANING'
, '_LA:AAR.SITE_USE_CODE:IGS_LOOKUP_VALUES:PARTY_SITE_USE_CODE:MEANING'
, '_LA:AAR.CLOSED_IND:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, AAR.CREATED_BY
, AAR.CREATION_DATE
, AAR.LAST_UPDATED_BY
, AAR.LAST_UPDATE_DATE
FROM IGS_AD_APL_REV_PRF_ALL AAR WITH READ ONLY