VIEW: APPS.IGSBV_PERSON_ROLES

Source

View Text - Preformatted

SELECT HZP.PARTY_NUMBER, PTI.PERSON_TYPE_CODE, PTI.START_DATE, PTI.END_DATE, PTI.COURSE_CD, '_LA:PTI.FUNNEL_STATUS:IGS_LOOKUP_VALUES:PERSON_TYPE_FUNNEL_STATUS:MEANING', PTI.CC_VERSION_NUMBER, PTI.ADMISSION_APPL_NUMBER, PTI.NOMINATED_COURSE_CD, PTI.SEQUENCE_NUMBER, PTI.NCC_VERSION_NUMBER, '_LA:PTI.CREATE_METHOD:IGS_LOOKUP_VALUES:PERSON_TYPE_CREATE_METHOD:MEANING', PTI.ENDED_BY, '_LA:PTI.END_METHOD:IGS_LOOKUP_VALUES:PERSON_TYPE_END_METHOD:MEANING', '_LA:PTI.EMPLMNT_CATEGORY_CODE:IGS_LOOKUP_VALUES:PE_EMP_CATEGORIES:MEANING', PTI.TYPE_INSTANCE_ID, PTI.PERSON_ID, PTI.CREATED_BY, PTI.CREATION_DATE, PTI.LAST_UPDATED_BY, PTI.LAST_UPDATE_DATE FROM IGS_PE_TYP_INSTANCES_ALL PTI, HZ_PARTIES HZP WHERE PTI.PERSON_ID=HZP.PARTY_ID WITH READ ONLY

View Text - HTML Formatted

SELECT HZP.PARTY_NUMBER
, PTI.PERSON_TYPE_CODE
, PTI.START_DATE
, PTI.END_DATE
, PTI.COURSE_CD
, '_LA:PTI.FUNNEL_STATUS:IGS_LOOKUP_VALUES:PERSON_TYPE_FUNNEL_STATUS:MEANING'
, PTI.CC_VERSION_NUMBER
, PTI.ADMISSION_APPL_NUMBER
, PTI.NOMINATED_COURSE_CD
, PTI.SEQUENCE_NUMBER
, PTI.NCC_VERSION_NUMBER
, '_LA:PTI.CREATE_METHOD:IGS_LOOKUP_VALUES:PERSON_TYPE_CREATE_METHOD:MEANING'
, PTI.ENDED_BY
, '_LA:PTI.END_METHOD:IGS_LOOKUP_VALUES:PERSON_TYPE_END_METHOD:MEANING'
, '_LA:PTI.EMPLMNT_CATEGORY_CODE:IGS_LOOKUP_VALUES:PE_EMP_CATEGORIES:MEANING'
, PTI.TYPE_INSTANCE_ID
, PTI.PERSON_ID
, PTI.CREATED_BY
, PTI.CREATION_DATE
, PTI.LAST_UPDATED_BY
, PTI.LAST_UPDATE_DATE
FROM IGS_PE_TYP_INSTANCES_ALL PTI
, HZ_PARTIES HZP
WHERE PTI.PERSON_ID=HZP.PARTY_ID WITH READ ONLY