View: HXC_LOOKUPS

Product:	HXC - Time and Labor Engine
Description:
Implementation/DBA Data:	APPS.HXC_LOOKUPS

View Text

SELECT T.LOOKUP_TYPE
, V.LOOKUP_CODE
, V.MEANING
, V.DESCRIPTION
, V.ENABLED_FLAG
, V.START_DATE_ACTIVE
, V.END_DATE_ACTIVE
FROM FND_APPLICATION A
, FND_LOOKUP_TYPES T
, FND_LOOKUP_VALUES V
WHERE V.LANGUAGE = USERENV('LANG')
AND V.VIEW_APPLICATION_ID = 3
AND V.SECURITY_GROUP_ID = FND_GLOBAL.LOOKUP_SECURITY_GROUP(T.LOOKUP_TYPE
, V.VIEW_APPLICATION_ID)
AND A.APPLICATION_ID = 809
AND A.APPLICATION_ID = T.APPLICATION_ID
AND T.LOOKUP_TYPE = V.LOOKUP_TYPE

Columns