VIEW: APPS.IGSFV_APPL_REVIEW_GROUP_EVALTR

Source

View Text - Preformatted

SELECT are.REVGR_EVALUATOR_ID, are.APPL_REVPROF_REVGR_ID, arg.REVPROF_REVGR_CD, arg.REVPROF_REVGR_NAME, are.PERSON_ID, p.PARTY_NUMBER, pp.PERSON_NAME, are.EVALUATION_SEQUENCE, '_LA:are.PROGRAM_APPROVER_IND:IGS_LOOKUP_VALUES:YES_NO:MEANING', are.CREATED_BY, are.CREATION_DATE, are.LAST_UPDATED_BY, are.LAST_UPDATE_DATE FROM IGS_AD_RVGR_EVALTR are, IGS_AD_APL_RPRF_RGR arg, HZ_PERSON_PROFILES pp, HZ_PARTIES p WHERE are.APPL_REVPROF_REVGR_ID = arg.APPL_REVPROF_REVGR_ID AND are.PERSON_ID = pp.PARTY_ID AND p.PARTY_ID = pp.PARTY_ID AND pp.CONTENT_SOURCE_TYPE (+) = 'USER_ENTERED' AND SYSDATE BETWEEN pp.EFFECTIVE_START_DATE AND NVL(pp.EFFECTIVE_END_DATE,SYSDATE) WITH READ ONLY

View Text - HTML Formatted

SELECT ARE.REVGR_EVALUATOR_ID
, ARE.APPL_REVPROF_REVGR_ID
, ARG.REVPROF_REVGR_CD
, ARG.REVPROF_REVGR_NAME
, ARE.PERSON_ID
, P.PARTY_NUMBER
, PP.PERSON_NAME
, ARE.EVALUATION_SEQUENCE
, '_LA:ARE.PROGRAM_APPROVER_IND:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, ARE.CREATED_BY
, ARE.CREATION_DATE
, ARE.LAST_UPDATED_BY
, ARE.LAST_UPDATE_DATE
FROM IGS_AD_RVGR_EVALTR ARE
, IGS_AD_APL_RPRF_RGR ARG
, HZ_PERSON_PROFILES PP
, HZ_PARTIES P
WHERE ARE.APPL_REVPROF_REVGR_ID = ARG.APPL_REVPROF_REVGR_ID
AND ARE.PERSON_ID = PP.PARTY_ID
AND P.PARTY_ID = PP.PARTY_ID
AND PP.CONTENT_SOURCE_TYPE (+) = 'USER_ENTERED'
AND SYSDATE BETWEEN PP.EFFECTIVE_START_DATE
AND NVL(PP.EFFECTIVE_END_DATE
, SYSDATE) WITH READ ONLY