[Home] [Help]
View: HR_STANDARD_LOOKUPS
Product: | PER - Human Resources |
Description: | HRMS specific view based on FND_LOOKUP_TYPES and FND_LOOKUP_VALUES. |
Implementation/DBA Data: |
APPS.HR_STANDARD_LOOKUPS
|
View Text
SELECT FLT.APPLICATION_ID
, FLV.LOOKUP_TYPE
, FLV.LOOKUP_CODE
, FLV.MEANING
, FLV.LAST_UPDATE_DATE
, FLV.LAST_UPDATED_BY
, FLV.ENABLED_FLAG
, FLV.START_DATE_ACTIVE
, FLV.END_DATE_ACTIVE
, FLV.DESCRIPTION
, FLV.LAST_UPDATE_LOGIN
, FLV.CREATED_BY
, FLV.CREATION_DATE
FROM FND_LOOKUP_VALUES FLV
, FND_LOOKUP_TYPES FLT
WHERE FLV.LOOKUP_TYPE = FLT.LOOKUP_TYPE
AND FLV.SECURITY_GROUP_ID = FLT.SECURITY_GROUP_ID
AND FLV.VIEW_APPLICATION_ID = FLT.VIEW_APPLICATION_ID
AND FLV.LANGUAGE = USERENV('LANG')
AND FLV.VIEW_APPLICATION_ID = 3
AND FLV.SECURITY_GROUP_ID = 0
Columns
Name |
APPLICATION_ID |
LOOKUP_TYPE |
LOOKUP_CODE |
MEANING |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
ENABLED_FLAG |
START_DATE_ACTIVE |
END_DATE_ACTIVE |
DESCRIPTION |
LAST_UPDATE_LOGIN |
CREATED_BY |
CREATION_DATE |