FND Design Data [Home] [Help]

View: FF_COMPILED_INFO

Product: FF - FastFormula
Description: Date-effective view.
Implementation/DBA Data: ViewAPPS.FF_COMPILED_INFO
View Text

SELECT FORMULA_ID
, EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
, FDIU_ENTRY_COUNT
, SELECT_STATEMENT_COUNT
, TEXT_LENGTH
, COMPILED_TEXT
FROM FF_COMPILED_INFO_F
WHERE EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))
AND EFFECTIVE_END_DATE >= (SELECT SE.EFFECTIVE_DATE
FROM FND_SESSIONS SE
WHERE SE.SESSION_ID = USERENV('SESSIONID'))

Columns

Name
FORMULA_ID
EFFECTIVE_START_DATE
EFFECTIVE_END_DATE
FDIU_ENTRY_COUNT
SELECT_STATEMENT_COUNT
TEXT_LENGTH
COMPILED_TEXT