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_ITEM_CONTEXTS_V

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

View Text

SELECT FAIC.ARCHIVE_ITEM_ID ARCHIVE_ITEM_ID
, FAIC.SEQUENCE_NO SEQUENCE_NO
, FAIC.CONTEXT_ID CONTEXT_ID
, FF_ARCHIVE_UTILS.GET_CONTEXT_VALUE(FF_ARCHIVE_UTILS.GET_LEGISLATION_CODE(FND_PROFILE.VALUE_WNPS('PER_BUSINESS_GROUP_ID'))
, FC.CONTEXT_NAME
, FAIC.CONTEXT) CONTEXT
, FC.CONTEXT_NAME CONTEXT_NAME
, FC.CONTEXT_LEVEL CONTEXT_LEVEL
, FC.DATA_TYPE DATA_TYPE
FROM FF_ARCHIVE_ITEM_CONTEXTS FAIC
, FF_CONTEXTS FC
WHERE FAIC.CONTEXT_ID = FC.CONTEXT_ID

Columns

Name
ARCHIVE_ITEM_ID
SEQUENCE_NO
CONTEXT_ID
CONTEXT
CONTEXT_NAME
CONTEXT_LEVEL
DATA_TYPE