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_ARCHIVE_ITEMS_V

Product:	FF - FastFormula
Description:
Implementation/DBA Data:	APPS.FF_ARCHIVE_ITEMS_V

View Text

SELECT FAI.ROWID ROW_ID
, FAI.ARCHIVE_ITEM_ID ARCHIVE_ITEM_ID
, FAI.USER_ENTITY_ID USER_ENTITY_ID
, FAI.CONTEXT1 CONTEXT1
, FAI.VALUE VALUE
, FAI.ARCHIVE_TYPE ARCHIVE_TYPE
, PRFI.UPDATABLE_FLAG UPDATABLE_FLAG
, PRFI.DISPLAY_SEQUENCE DISPLAY_SEQUENCE
, FAI.LAST_UPDATE_DATE LAST_UPDATE_DATE
, FAI.LAST_UPDATED_BY LAST_UPDATED_BY
, FAI.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, FAI.CREATED_BY CREATED_BY
, FAI.CREATION_DATE CREATION_DATE
, FAI.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, FDI.USER_NAME USER_NAME
, FDI.DATA_TYPE DATA_TYPE
FROM FF_ARCHIVE_ITEMS FAI
, PAY_REPORT_FORMAT_ITEMS_F PRFI
, FF_DATABASE_ITEMS FDI
, FND_SESSIONS FND
WHERE FAI.USER_ENTITY_ID = PRFI.USER_ENTITY_ID(+)
AND FAI.USER_ENTITY_ID = FDI.USER_ENTITY_ID
AND FND.SESSION_ID = USERENV('SESSIONID')
AND FND.EFFECTIVE_DATE BETWEEN NVL(PRFI.EFFECTIVE_START_DATE
, FND.EFFECTIVE_DATE)
AND NVL(PRFI.EFFECTIVE_END_DATE
, FND.EFFECTIVE_DATE)

Columns

Name
ROW_ID
ARCHIVE_ITEM_ID
USER_ENTITY_ID
CONTEXT1
VALUE
ARCHIVE_TYPE
UPDATABLE_FLAG
DISPLAY_SEQUENCE
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE
OBJECT_VERSION_NUMBER
USER_NAME
DATA_TYPE