FND Design Data [Home] [Help]

View: PA_PERSON_TYPE_RES_V

Product: PA - Projects
Description:
Implementation/DBA Data: ViewAPPS.PA_PERSON_TYPE_RES_V
View Text

SELECT PER.PERSON_TYPE_ID
, LK.LOOKUP_CODE
, LK.MEANING
FROM PA_LOOKUPS LK
, PER_PERSON_TYPES PER
WHERE LK.LOOKUP_TYPE = 'PA_PERSON_TYPE'
AND PER.SYSTEM_PERSON_TYPE = LK.LOOKUP_CODE
AND PER.BUSINESS_GROUP_ID = 0

Columns

Name
PERSON_TYPE_ID
PERSON_TYPE_CODE
MEANING