VIEW: APPS.FF_FDI_USAGES

Source

View Text - Preformatted

SELECT FORMULA_ID , ITEM_NAME , EFFECTIVE_START_DATE , EFFECTIVE_END_DATE , DATA_TYPE , ITEM_GENERATED_NAME , LOAD_WHEN_RUNNING , USAGE , CONTEXT_LEVEL_SUM , INDICATOR_VAR_NAME , GLOBAL_ID , CONTEXT_ID ,ALTERNATIVE_ITEM_NAME ,ROUTE_ID FROM FF_FDI_USAGES_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'))

View Text - HTML Formatted

SELECT FORMULA_ID
, ITEM_NAME
, EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
, DATA_TYPE
, ITEM_GENERATED_NAME
, LOAD_WHEN_RUNNING
, USAGE
, CONTEXT_LEVEL_SUM
, INDICATOR_VAR_NAME
, GLOBAL_ID
, CONTEXT_ID
, ALTERNATIVE_ITEM_NAME
, ROUTE_ID
FROM FF_FDI_USAGES_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'))