VIEW: APPS.IGS_AD_APL_REV_PRF_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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