VIEW: APPS.FF_ARCHIVE_ITEMS_V

Source

View Text - Preformatted

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)

View Text - HTML Formatted

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)