[Home] [Help]
View: PA_ALLOC_BUDGET_ENTRY_METHOD_V
View Text
SELECT BUDGET_ENTRY_METHOD_CODE
, BUDGET_ENTRY_METHOD
, ENTRY_LEVEL_CODE
, CATEGORIZATION_CODE
, COST_QUANTITY_FLAG
, RAW_COST_FLAG
, BURDENED_COST_FLAG
, TIME_PHASED_TYPE_CODE FROM PA_BUDGET_ENTRY_METHODS
WHERE ((COST_QUANTITY_FLAG = 'Y') OR (RAW_COST_FLAG = 'Y') OR (BURDENED_COST_FLAG = 'Y'))
AND TRUNC(SYSDATE) BETWEEN TRUNC(START_DATE_ACTIVE)
AND TRUNC(NVL(END_DATE_ACTIVE
, SYSDATE))
Columns
| Name |
| BUDGET_ENTRY_METHOD_CODE |
| BUDGET_ENTRY_METHOD |
| ENTRY_LEVEL_CODE |
| CATEGORIZATION_CODE |
| COST_QUANTITY_FLAG |
| RAW_COST_FLAG |
| BURDENED_COST_FLAG |
| TIME_PHASED_TYPE_CODE |