VIEW: APPS.IGSFV_AD_ACT_PROFILES_SPS

Source

View Text - Preformatted

SELECT PEA.PE_PERSON_ID PERSON_IDENTIFIER, ACTPR.REPORTING_YEAR REPORTING_YEAR, ACTPR.ACT_IDENTIFIER ACT_IDENTIFIER, ACTPR.TEST_TYPE TEST_TYPE, ACTPR.TEST_DATE_TXT TEST_DATE_TXT, ACTPR.PROFILE_CATEGORY PROFILE_CATEGORY_CODE, '_LA:ACTPR.PROFILE_CATEGORY:IGS_LOOKUP_VALUES:ACT_PROFILE_CATEGORY:MEANING' "_LA:PROFILE_CATEGORY", '_LA:ACTPR.PROFILE_CATEGORY:IGS_LOOKUP_VALUES:ACT_PROFILE_CATEGORY:DESCRIPTION' "_LA:PROFILE_CATEGORY_DESC", ACTPR.CODE1 CODE1, ACTPR.CODE2 CODE2, ACTPR.CODE3 CODE3, ACTPR.CODE4 CODE4, ACTPR.CODE5 CODE5, ACTPR.CODE6 CODE6, ACTPR.CODE7 CODE7, ACTPR.CODE8 CODE8, ACTPR.CODE9 CODE9, ACTPR.CODE10 CODE10, ACTPR.CODE11 CODE11, ACTPR.CODE12 CODE12, ACTPR.CODE13 CODE13, ACTPR.CODE14 CODE14, ACTPR.CODE15 CODE15, ACTPR.CODE16 CODE16, ACTPR.CODE17 CODE17, ACTPR.CODE18 CODE18, ACTPR.CODE19 CODE19, ACTPR.CODE20 CODE20, ACTPR.CODE21 CODE21, ACTPR.EDUC_MAJOR EDUC_MAJOR, ACTPR.VOC_CHOICE1 VOC_CHOICE1, ACTPR.VOC_CHOICE2 VOC_CHOICE2, ACTPR.CHOICE1 CHOICE1, ACTPR.CHOICE2 CHOICE2, ACTPR.CHOICE3 CHOICE3, ACTPR.CHOICE4 CHOICE4, ACTPR.CHOICE5 CHOICE5, ACTPR.CREATED_BY CREATED_BY, ACTPR.CREATION_DATE CREATION_DATE, ACTPR.LAST_UPDATED_BY LAST_UPDATED_BY, ACTPR.LAST_UPDATE_DATE LAST_UPDATE_DATE FROM IGS_AD_ACT_PROFILES ACTPR, IGS_PE_ALT_PERS_ID PEA WHERE ACTPR.PROFILE_TYPE = 'SPSQ' AND DECODE(SUBSTR(ACTPR.ACT_IDENTIFIER,1,1),'-',SUBSTR(ACTPR.ACT_IDENTIFIER,2), ACTPR.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
, ACTPR.REPORTING_YEAR REPORTING_YEAR
, ACTPR.ACT_IDENTIFIER ACT_IDENTIFIER
, ACTPR.TEST_TYPE TEST_TYPE
, ACTPR.TEST_DATE_TXT TEST_DATE_TXT
, ACTPR.PROFILE_CATEGORY PROFILE_CATEGORY_CODE
, '_LA:ACTPR.PROFILE_CATEGORY:IGS_LOOKUP_VALUES:ACT_PROFILE_CATEGORY:MEANING' "_LA:PROFILE_CATEGORY"
, '_LA:ACTPR.PROFILE_CATEGORY:IGS_LOOKUP_VALUES:ACT_PROFILE_CATEGORY:DESCRIPTION' "_LA:PROFILE_CATEGORY_DESC"
, ACTPR.CODE1 CODE1
, ACTPR.CODE2 CODE2
, ACTPR.CODE3 CODE3
, ACTPR.CODE4 CODE4
, ACTPR.CODE5 CODE5
, ACTPR.CODE6 CODE6
, ACTPR.CODE7 CODE7
, ACTPR.CODE8 CODE8
, ACTPR.CODE9 CODE9
, ACTPR.CODE10 CODE10
, ACTPR.CODE11 CODE11
, ACTPR.CODE12 CODE12
, ACTPR.CODE13 CODE13
, ACTPR.CODE14 CODE14
, ACTPR.CODE15 CODE15
, ACTPR.CODE16 CODE16
, ACTPR.CODE17 CODE17
, ACTPR.CODE18 CODE18
, ACTPR.CODE19 CODE19
, ACTPR.CODE20 CODE20
, ACTPR.CODE21 CODE21
, ACTPR.EDUC_MAJOR EDUC_MAJOR
, ACTPR.VOC_CHOICE1 VOC_CHOICE1
, ACTPR.VOC_CHOICE2 VOC_CHOICE2
, ACTPR.CHOICE1 CHOICE1
, ACTPR.CHOICE2 CHOICE2
, ACTPR.CHOICE3 CHOICE3
, ACTPR.CHOICE4 CHOICE4
, ACTPR.CHOICE5 CHOICE5
, ACTPR.CREATED_BY CREATED_BY
, ACTPR.CREATION_DATE CREATION_DATE
, ACTPR.LAST_UPDATED_BY LAST_UPDATED_BY
, ACTPR.LAST_UPDATE_DATE LAST_UPDATE_DATE
FROM IGS_AD_ACT_PROFILES ACTPR
, IGS_PE_ALT_PERS_ID PEA
WHERE ACTPR.PROFILE_TYPE = 'SPSQ'
AND DECODE(SUBSTR(ACTPR.ACT_IDENTIFIER
, 1
, 1)
, '-'
, SUBSTR(ACTPR.ACT_IDENTIFIER
, 2)
, ACTPR.ACT_IDENTIFIER) = PEA.API_PERSON_ID (+)
AND PEA.PERSON_ID_TYPE(+) = 'ACTID' WITH READ ONLY