[Home] [Help]
View: PSBBV_BUDGET_YEARS
Product: | PSB - Public Sector Budgeting (Obsolete) |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT BP1.NAME
, BP1.DESCRIPTION
, BP1.START_DATE
, BP1.END_DATE
, '_LA:PERIOD_DISTRIBUTION_TYPE:FND_LOOKUPS:PSB_PERIOD_DISTRIBUTION_TYPES:MEANING'
, '_LA:CALCULATION_PERIOD_TYPE:FND_LOOKUPS:PSB_CALCULATION_PERIOD_TYPES:MEANING'
, BP1.BUDGET_PERIOD_ID
, BP1.BUDGET_YEAR_TYPE_ID
, BP1.LAST_UPDATE_DATE
, BP1.LAST_UPDATED_BY
, BP1.CREATED_BY
, BP1.CREATION_DATE
FROM PSB_BUDGET_PERIODS BP1
WHERE BP1.BUDGET_PERIOD_TYPE = 'Y' WITH READ ONLY
Columns
Name |
BUDGET_YEAR_NAME |
BUDGET_YEAR_DESCRIPTION |
START_EFFECTIVE_DATE |
END_EFFECTIVE_DATE |
"_LA:PERIOD_DISTRIBUTION_TYPE" |
"_LA:CALCULATION_PERIOD_TYPE" |
BUDGET_YEAR_ID |
BUDGET_YEAR_TYPE_ID |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
CREATED_BY |
CREATION_DATE |