Skip to content
[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 |