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_ARCHIVE_ITEM_CONTEXTS_V

Source

View Text - Preformatted


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

View Text - HTML Formatted

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