VIEW: APPS.IGSBV_AD_ACT_PROFILES_OOCA

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.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 = 'OOCA' 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.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 = 'OOCA'
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