[Home] [Help]
View: PER_PERSON_TYPES_V
Product: | PER - Human Resources |
Description: | Used to support user interface |
Implementation/DBA Data: |
APPS.PER_PERSON_TYPES_V
|
View Text
SELECT PPT.ROWID
, PPT.PERSON_TYPE_ID
, PPT.BUSINESS_GROUP_ID + 0
, PPT.ACTIVE_FLAG
, PPT.DEFAULT_FLAG
, PPT.SYSTEM_PERSON_TYPE
, HL.MEANING
, PPTTL.USER_PERSON_TYPE
, PPT.LAST_UPDATE_DATE
, PPT.LAST_UPDATED_BY
, PPT.LAST_UPDATE_LOGIN
, PPT.CREATED_BY
, PPT.CREATION_DATE
FROM PER_PERSON_TYPES_TL PPTTL
, PER_PERSON_TYPES PPT
, HR_LOOKUPS HL
WHERE PPT.SYSTEM_PERSON_TYPE = HL.LOOKUP_CODE
AND HL.LOOKUP_TYPE = 'PERSON_TYPE'
AND PPTTL.PERSON_TYPE_ID = PPT.PERSON_TYPE_ID
AND PPTTL.LANGUAGE = USERENV('LANG')
Columns
Name |
ROW_ID |
PERSON_TYPE_ID |
BUSINESS_GROUP_ID |
ACTIVE_FLAG |
DEFAULT_FLAG |
SYSTEM_PERSON_TYPE |
SYSTEM_NAME |
USER_PERSON_TYPE |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_LOGIN |
CREATED_BY |
CREATION_DATE |