[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 |