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.

VIEW: APPS.FF_DATABASE_ITEMS_VL2

Source

View Text - Preformatted


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

View Text - HTML Formatted

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