[Home] [Help]
View: PA_BUDGET_TYPES_V
Product: | PA - Projects |
Description: | This view displays all the valid budget types which are used for different business purposes - |
Implementation/DBA Data: |
APPS.PA_BUDGET_TYPES_V
|
View Text
SELECT BUDGET_TYPE_CODE
, BUDGET_TYPE
, DESCRIPTION
, BUDGET_AMOUNT_CODE
, PREDEFINED_FLAG
, ACCUMULATION_FLAG
FROM PA_BUDGET_TYPES
WHERE TRUNC(SYSDATE) BETWEEN START_DATE_ACTIVE
AND NVL(END_DATE_ACTIVE
, TRUNC(SYSDATE))
Columns
Name |
CODE |
NAME |
DESCRIPTION |
BUDGET_AMOUNT_CODE |
PREDEFINED_FLAG |
ACCUMULATION_FLAG |