View: FF_DATABASE_ITEMS_V

Product:	FF - FastFormula
Description:	Used to support user interface
Implementation/DBA Data:	APPS.FF_DATABASE_ITEMS_V

View Text

SELECT DI.USER_NAME
, DECODE (DI.NULL_ALLOWED_FLAG
, 'N'
, UE.NOTFOUND_ALLOWED_FLAG
, 'Y') DEFAULT_REQUIRED
, LU.MEANING TYPE
, DI.DESCRIPTION
, FR.ROUTE_ID
, UE.BUSINESS_GROUP_ID + 0 BUSINESS_GROUP_ID
, UE.LEGISLATION_CODE
FROM HR_LOOKUPS LU
, FF_DATABASE_ITEMS DI
, FF_USER_ENTITIES UE
, FF_ROUTES FR
WHERE LU.LOOKUP_TYPE = 'DATA_TYPE'
AND LU.LOOKUP_CODE = DI.DATA_TYPE
AND DI.USER_ENTITY_ID = UE.USER_ENTITY_ID
AND UE.ROUTE_ID = FR.ROUTE_ID

Columns