FND Design Data [Home] [Help]

View: PA_ALLOC_BUDGET_ENTRY_METHOD_V

Product: PA - Projects
Description:
Implementation/DBA Data: ViewAPPS.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