[Home] [Help]
View: FF_FDI_USAGES_X
Product: | FF - FastFormula |
Description: | Date-effective view. |
Implementation/DBA Data: |
APPS.FF_FDI_USAGES_X
|
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 TRUNC(SYSDATE) BETWEEN EFFECTIVE_START_DATE
AND EFFECTIVE_END_DATE
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 |