View: IGS_AD_APL_REV_PRF_V

Product:	IGS - Student System
Description:	View where all Application Review Profile related information will be recorded. Here the Application Review Profile IDs will be generated and information like Review Profile Name, Start Date, End Date, whether program approval is required
Implementation/DBA Data:	APPS.IGS_AD_APL_REV_PRF_V

View Text

SELECT RP.ROW_ID
, RP.APPL_REV_PROFILE_ID
, RP.ORG_ID
, RP.REVIEW_PROFILE_NAME
, RP.START_DATE
, RP.END_DATE
, RP.MIN_EVALUATOR
, RP.MAX_EVALUATOR
, RP.PROG_APPROVAL_REQUIRED
, RP.SEQUENTIAL_CONCURRENT_IND
, RP.APPL_REV_PROFILE_GR_CD
, (SELECT MEANING
FROM IGS_LOOKUP_VALUES
WHERE RP.APPL_REV_PROFILE_GR_CD = LOOKUP_CODE
AND LOOKUP_TYPE = 'IGS_APPL_REVIEW_PROFILE_GROUP') ARP_GR_CODE_MEANING
, RP.SITE_USE_CODE
, DECODE (RP.SITE_USE_CODE
, NULL
, NULL
, (SELECT MEANING
FROM FND_LOOKUP_VALUES
WHERE RP.SITE_USE_CODE = LOOKUP_CODE
AND LOOKUP_TYPE = 'PARTY_SITE_USE_CODE'
AND VIEW_APPLICATION_ID = 222
AND SECURITY_GROUP_ID = 0
AND LANGUAGE = USERENV('LANG'))) SITE_USE_CODE_MEANING
, RP.CLOSED_IND
, RP.CREATED_BY
, RP.CREATION_DATE
, RP.LAST_UPDATED_BY
, RP.LAST_UPDATE_DATE
, RP.LAST_UPDATE_LOGIN
FROM IGS_AD_APL_REV_PRF RP

Columns