[Home] [Help]
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
Name |
ROW_ID |
S_PERSON_TYPE |
S_PERSON_TYPE_DESC |
RESPONSIBILITY_NAME |
RESPONSIBILITY_KEY |
APPLICATION_SHORT_NAME |
CREATION_DATE |
CREATED_BY |
LAST_UPDATE_LOGIN |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |