Skip to content FND Design Data [Home] [Help]

View: IGS_PE_TYP_INSTANCES_SV

Product: IGS - Student System (Obsolete)
Description: New View for securing select privileges on IGS_PE_TYP_INSTANCES_ALL table.
Implementation/DBA Data: Not implemented in this database
View Text

SELECT TYP.TYPE_INSTANCE_ID
, TYP.PERSON_TYPE_CODE
, TYP.PERSON_ID
, TYP.COURSE_CD
, TYP.CC_VERSION_NUMBER
, TYP.FUNNEL_STATUS
, TYP.ADMISSION_APPL_NUMBER
, TYP.NOMINATED_COURSE_CD
, TYP.NCC_VERSION_NUMBER
, TYP.SEQUENCE_NUMBER
, TYP.START_DATE
, TYP.END_DATE
, TYP.CREATE_METHOD
, TYP.ENDED_BY
, TYP.END_METHOD
, TYP.CREATED_BY
, TYP.CREATION_DATE
, TYP.LAST_UPDATED_BY
, TYP.LAST_UPDATE_DATE
, TYP.LAST_UPDATE_LOGIN
, TYP.ORG_ID
, TYP.EMPLMNT_CATEGORY_CODE
FROM IGS_PE_TYP_INSTANCES_ALL TYP

Columns

Name
TYPE_INSTANCE_ID
PERSON_TYPE_CODE
PERSON_ID
COURSE_CD
CC_VERSION_NUMBER
FUNNEL_STATUS
ADMISSION_APPL_NUMBER
NOMINATED_COURSE_CD
NCC_VERSION_NUMBER
SEQUENCE_NUMBER
START_DATE
END_DATE
CREATE_METHOD
ENDED_BY
END_METHOD
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
ORG_ID
EMPLMNT_CATEGORY_CODE