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