eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: FF_DATABASE_ITEMS_VL2

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

View Text

SELECT DI.USER_NAME
, DI.USER_ENTITY_ID
, DI.DATA_TYPE
, DI.DEFINITION_TEXT
, DI.NULL_ALLOWED_FLAG
, DI.DESCRIPTION
FROM FF_DATABASE_ITEMS DI UNION SELECT DBITL.TRANSLATED_USER_NAME USER_NAME
, DI.USER_ENTITY_ID
, DI.DATA_TYPE
, DI.DEFINITION_TEXT
, DI.NULL_ALLOWED_FLAG
, DI.DESCRIPTION
FROM FF_DATABASE_ITEMS_TL DBITL
, FF_DATABASE_ITEMS DI
WHERE DBITL.USER_ENTITY_ID = DI.USER_ENTITY_ID
AND DBITL.USER_NAME = DI.USER_NAME

Columns

Name
USER_NAME
USER_ENTITY_ID
DATA_TYPE
DEFINITION_TEXT
NULL_ALLOWED_FLAG
DESCRIPTION