[Home] [Help]
View: PQH_BUDGET_POOLS_V
View Text
SELECT BPL.POOL_ID
, BPL.NAME
, BPL.BUDGET_VERSION_ID
, BPL.BUDGET_UNIT_ID
, HR_GENERAL.DECODE_AVAILABILITY_STATUS(BPL.BUDGET_UNIT_ID) BUDGET_UNIT
, BPL.OBJECT_VERSION_NUMBER
, BPL.LAST_UPDATE_DATE
, BPL.CREATION_DATE
, BPL.CREATED_BY
, BPL.LAST_UPDATE_LOGIN
, BPL.LAST_UPDATED_BY
FROM PQH_BUDGET_POOLS BPL
Columns
Name |
POOL_ID |
NAME |
BUDGET_VERSION_ID |
BUDGET_UNIT_ID |
BUDGET_UNIT |
OBJECT_VERSION_NUMBER |
LAST_UPDATE_DATE |
CREATION_DATE |
CREATED_BY |
LAST_UPDATE_LOGIN |
LAST_UPDATED_BY |