[Home] [Help]
View: FF_FDI_USAGES
Product: | FF - FastFormula |
Description: | Date-effective view. |
Implementation/DBA Data: |
APPS.FF_FDI_USAGES
|
View Text
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
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'))
Columns
Name |
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 |