View: IGS_PE_TYP_INSTANCES

Product:	IGS - Student System
Description:
Implementation/DBA Data:	APPS.IGS_PE_TYP_INSTANCES

View Text

SELECT TAB.ROWID ROW_ID
, TAB.ORG_ID ORG_ID
, TAB.TYPE_INSTANCE_ID TYPE_INSTANCE_ID
, TAB.PERSON_TYPE_CODE PERSON_TYPE_CODE
, TAB.PERSON_ID PERSON_ID
, TAB.COURSE_CD COURSE_CD
, TAB.FUNNEL_STATUS FUNNEL_STATUS
, TAB.CC_VERSION_NUMBER CC_VERSION_NUMBER
, TAB.ADMISSION_APPL_NUMBER ADMISSION_APPL_NUMBER
, TAB.NOMINATED_COURSE_CD NOMINATED_COURSE_CD
, TAB.SEQUENCE_NUMBER SEQUENCE_NUMBER
, TAB.NCC_VERSION_NUMBER NCC_VERSION_NUMBER
, TAB.START_DATE START_DATE
, TAB.END_DATE END_DATE
, TAB.CREATE_METHOD CREATE_METHOD
, TAB.ENDED_BY ENDED_BY
, TAB.END_METHOD END_METHOD
, TAB.CREATED_BY CREATED_BY
, TAB.CREATION_DATE CREATION_DATE
, TAB.LAST_UPDATED_BY LAST_UPDATED_BY
, TAB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, TAB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, TYP.SYSTEM_TYPE
FROM IGS_PE_TYP_INSTANCES_ALL TAB
, IGS_PE_PERSON_TYPES TYP
WHERE TAB.PERSON_TYPE_CODE = TYP.PERSON_TYPE_CODE UNION ALL SELECT CHARTOROWID(NULL) ROW_ID
, TO_NUMBER(NULL)
, USG.PERSON_TYPE_USAGE_ID TYPE_INSTANCE_ID
, MAP.PERSON_TYPE_CODE
, PEO.PARTY_ID PERSON_ID
, NULL
, NULL
, TO_NUMBER(NULL)
, NULL
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, USG.EFFECTIVE_START_DATE START_DATE
, USG.EFFECTIVE_END_DATE END_DATE
, NULL
, TO_NUMBER(NULL)
, NULL
, USG.CREATED_BY
, USG.CREATION_DATE
, USG.LAST_UPDATED_BY
, USG.LAST_UPDATE_DATE
, USG.LAST_UPDATE_LOGIN
, MAP.SYSTEM_TYPE
FROM PER_PERSON_TYPE_USAGES_F USG
, PER_ALL_PEOPLE_F PEO
, IGS_PE_PER_TYPE_MAP MAP
WHERE USG.PERSON_ID = PEO.PERSON_ID
AND USG.PERSON_TYPE_ID = MAP.PER_PERSON_TYPE_ID
AND TRUNC(SYSDATE) BETWEEN PEO.EFFECTIVE_START_DATE
AND PEO.EFFECTIVE_END_DATE

Columns