[Home] [Help]
View: PSB_BUDGET_YEAR_TYPES_VL
Product: | PSB - Public Sector Budgeting (Obsolete) |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT BYTP.ROWID
, BYTP.BUDGET_YEAR_TYPE_ID
, BTL.NAME
, BTL.DESCRIPTION
, BYTP.YEAR_CATEGORY_TYPE
, BYTP.SEQUENCE_NUMBER
, BYTP.LAST_UPDATE_DATE
, BYTP.LAST_UPDATED_BY
, BYTP.LAST_UPDATE_LOGIN
, BYTP.CREATED_BY
, BYTP.CREATION_DATE
FROM PSB_BUDGET_YEAR_TYPES BYTP
, PSB_BUDGET_YEAR_TYPES_TL BTL
WHERE BYTP.BUDGET_YEAR_TYPE_ID = BTL.BUDGET_YEAR_TYPE_ID
AND BTL.LANGUAGE = USERENV('LANG')
Columns
Name |
ROW_ID |
BUDGET_YEAR_TYPE_ID |
NAME |
DESCRIPTION |
YEAR_CATEGORY_TYPE |
SEQUENCE_NUMBER |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_LOGIN |
CREATED_BY |
CREATION_DATE |