View: IGS_PE_TYP_RSP_DFLT_V

Product:	IGS - Student System
Description:	Contains mapping of System Person Type with Responsibility
Implementation/DBA Data:	APPS.IGS_PE_TYP_RSP_DFLT_V

View Text

SELECT TRD.ROWID
, TRD.S_PERSON_TYPE
, LK.MEANING
, RSPTL.RESPONSIBILITY_NAME
, TRD.RESPONSIBILITY_KEY
, TRD.APPLICATION_SHORT_NAME
, TRD.CREATION_DATE
, TRD.CREATED_BY
, TRD.LAST_UPDATE_LOGIN
, TRD.LAST_UPDATED_BY
, TRD.LAST_UPDATE_DATE
FROM IGS_PE_TYP_RSP_DFLT TRD
, IGS_LOOKUPS_VIEW LK
, FND_APPLICATION APP
, FND_RESPONSIBILITY RSP
, FND_RESPONSIBILITY_TL RSPTL
WHERE TRD.S_PERSON_TYPE = LK.LOOKUP_CODE
AND LK.LOOKUP_TYPE = 'SYSTEM_PERSON_TYPES'
AND TRD.APPLICATION_SHORT_NAME = APP.APPLICATION_SHORT_NAME
AND RSP.APPLICATION_ID = APP.APPLICATION_ID
AND RSP.RESPONSIBILITY_KEY = TRD.RESPONSIBILITY_KEY
AND RSP.RESPONSIBILITY_ID = RSPTL.RESPONSIBILITY_ID
AND RSPTL.APPLICATION_ID = APP.APPLICATION_ID
AND RSPTL.LANGUAGE = USERENV ('LANG')

Columns