VIEW: APPS.FF_DATABASE_ITEMS_VL1

Source

View Text - Preformatted

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 , 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 UNION SELECT DBITL.TRANSLATED_USER_NAME , DECODE (DI.NULL_ALLOWED_FLAG,'N',UE.NOTFOUND_ALLOWED_FLAG, 'Y') DEFAULT_REQUIRED , LU.MEANING TYPE , DBITL.DESCRIPTION , FR.ROUTE_ID , UE.BUSINESS_GROUP_ID BUSINESS_GROUP_ID , UE.LEGISLATION_CODE FROM HR_LOOKUPS LU, FF_DATABASE_ITEMS_TL DBITL, 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 DBITL.USER_ENTITY_ID = DI.USER_ENTITY_ID AND DBITL.USER_NAME = DI.USER_NAME AND DI.USER_ENTITY_ID = UE.USER_ENTITY_ID AND UE.ROUTE_ID = FR.ROUTE_ID

View Text - HTML Formatted

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
, 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 UNION SELECT DBITL.TRANSLATED_USER_NAME
, DECODE (DI.NULL_ALLOWED_FLAG
, 'N'
, UE.NOTFOUND_ALLOWED_FLAG
, 'Y') DEFAULT_REQUIRED
, LU.MEANING TYPE
, DBITL.DESCRIPTION
, FR.ROUTE_ID
, UE.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, UE.LEGISLATION_CODE
FROM HR_LOOKUPS LU
, FF_DATABASE_ITEMS_TL DBITL
, 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 DBITL.USER_ENTITY_ID = DI.USER_ENTITY_ID
AND DBITL.USER_NAME = DI.USER_NAME
AND DI.USER_ENTITY_ID = UE.USER_ENTITY_ID
AND UE.ROUTE_ID = FR.ROUTE_ID