Product: | IGS - Student System |
---|---|
Description: | This view stores the workload for the faculty. |
Implementation/DBA Data: | APPS.IGS_PS_FAC_WL_V |
SELECT PFW.ROWID ROW_ID
, PFW.FAC_WL_ID
, PFW.PERSON_ID
, PE.PERSON_NUMBER
, NULL
, PE.FULL_NAME
, LKUP1.MEANING SEX_MEANING
, PE.BIRTH_DATE
, PFW.CALENDAR_CAT
, LKUP.MEANING CALENDAR_CAT_MEANING
, PFW.CAL_TYPE
, PFW.CI_SEQUENCE_NUMBER
, CI.ALTERNATE_CODE
, NULL
, PFW.ATTRIBUTE_CATEGORY
, PFW.ATTRIBUTE1
, PFW.ATTRIBUTE2
, PFW.ATTRIBUTE3
, PFW.ATTRIBUTE4
, PFW.ATTRIBUTE5
, PFW.ATTRIBUTE6
, PFW.ATTRIBUTE7
, PFW.ATTRIBUTE8
, PFW.ATTRIBUTE9
, PFW.ATTRIBUTE10
, PFW.ATTRIBUTE11
, PFW.ATTRIBUTE12
, PFW.ATTRIBUTE13
, PFW.ATTRIBUTE14
, PFW.ATTRIBUTE15
, PFW.ATTRIBUTE16
, PFW.ATTRIBUTE17
, PFW.ATTRIBUTE18
, PFW.ATTRIBUTE19
, PFW.ATTRIBUTE20
, PFW.CREATED_BY
, PFW.CREATION_DATE
, PFW.LAST_UPDATED_BY
, PFW.LAST_UPDATE_DATE
, PFW.LAST_UPDATE_LOGIN
FROM IGS_PS_FAC_WL PFW
, IGS_PE_PERSON_BASE_V PE
, IGS_CA_INST CI
, IGS_LOOKUP_VALUES LKUP
, FND_LOOKUP_VALUES LKUP1
WHERE PE.PERSON_ID = PFW.PERSON_ID
AND PE.GENDER= LKUP1.LOOKUP_CODE(+)
AND LKUP1.LOOKUP_TYPE (+) ='HZ_GENDER'
AND LKUP1.VIEW_APPLICATION_ID (+) = 222
AND LKUP1.SECURITY_GROUP_ID (+) = 0
AND LKUP1.LANGUAGE (+) = USERENV('LANG')
AND PFW.CAL_TYPE = CI.CAL_TYPE
AND PFW.CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER
AND LKUP.LOOKUP_CODE = PFW.CALENDAR_CAT
AND LKUP.LOOKUP_TYPE = 'CAL_CAT'