VIEW: APPS.IGSFV_AD_ACT_STATS_ACCOMP

Source

View Text - Preformatted

SELECT PEA.PE_PERSON_ID PERSON_IDENTIFIER, ACTST.REPORTING_YEAR REPORTING_YEAR, ACTST.ACT_IDENTIFIER ACT_IDENTIFIER, ACTST.TEST_TYPE TEST_TYPE, ACTST.TEST_DATE_TXT TEST_DATE_TXT, ACTST.STATISTIC_CATEGORY STATISTIC_CATEGORY_CODE, '_LA:ACTST.STATISTIC_CATEGORY:IGS_LOOKUP_VALUES:ACT_STATISTIC_CATEGORY:MEANING' "_LA:STATISTIC_CATEGORY", '_LA:ACTST.STATISTIC_CATEGORY:IGS_LOOKUP_VALUES:ACT_STATISTIC_CATEGORY:DESCRIPTION' "_LA:STATISTIC_CATEGORY_DESC", ACTST.SCORE SCORE, ACTST.CREATED_BY CREATED_BY, ACTST.CREATION_DATE CREATION_DATE, ACTST.LAST_UPDATED_BY LAST_UPDATED_BY, ACTST.LAST_UPDATE_DATE LAST_UPDATE_DATE FROM IGS_AD_ACT_STATISTICS ACTST, IGS_PE_ALT_PERS_ID PEA WHERE ACTST. STATISTIC_TYPE = 'ACCOMPLISHMENT' AND DECODE(SUBSTR(ACTST.ACT_IDENTIFIER,1,1),'-',SUBSTR(ACTST.ACT_IDENTIFIER,2), ACTST.ACT_IDENTIFIER) = PEA.API_PERSON_ID (+) AND PEA.PERSON_ID_TYPE(+) = 'ACTID' WITH READ ONLY

View Text - HTML Formatted

SELECT PEA.PE_PERSON_ID PERSON_IDENTIFIER
, ACTST.REPORTING_YEAR REPORTING_YEAR
, ACTST.ACT_IDENTIFIER ACT_IDENTIFIER
, ACTST.TEST_TYPE TEST_TYPE
, ACTST.TEST_DATE_TXT TEST_DATE_TXT
, ACTST.STATISTIC_CATEGORY STATISTIC_CATEGORY_CODE
, '_LA:ACTST.STATISTIC_CATEGORY:IGS_LOOKUP_VALUES:ACT_STATISTIC_CATEGORY:MEANING' "_LA:STATISTIC_CATEGORY"
, '_LA:ACTST.STATISTIC_CATEGORY:IGS_LOOKUP_VALUES:ACT_STATISTIC_CATEGORY:DESCRIPTION' "_LA:STATISTIC_CATEGORY_DESC"
, ACTST.SCORE SCORE
, ACTST.CREATED_BY CREATED_BY
, ACTST.CREATION_DATE CREATION_DATE
, ACTST.LAST_UPDATED_BY LAST_UPDATED_BY
, ACTST.LAST_UPDATE_DATE LAST_UPDATE_DATE
FROM IGS_AD_ACT_STATISTICS ACTST
, IGS_PE_ALT_PERS_ID PEA
WHERE ACTST. STATISTIC_TYPE = 'ACCOMPLISHMENT'
AND DECODE(SUBSTR(ACTST.ACT_IDENTIFIER
, 1
, 1)
, '-'
, SUBSTR(ACTST.ACT_IDENTIFIER
, 2)
, ACTST.ACT_IDENTIFIER) = PEA.API_PERSON_ID (+)
AND PEA.PERSON_ID_TYPE(+) = 'ACTID' WITH READ ONLY