[Home] [Help]
View: PQH_REALLOC_TXN_PERIODS_V
Product: | PQH - Public Sector HR |
Description: | Period Details for a folder (receiver/donor) transaction |
Implementation/DBA Data: |
APPS.PQH_REALLOC_TXN_PERIODS_V
|
View Text
SELECT REALLOCATION_ID
, TRANSACTION_TYPE
, BUDGET_PERIOD_ID
, ENTITY_ID
, START_DATE
, END_DATE
, REALLOCATION_AMT
, RESERVED_AMT
, TXN_DETAIL_ID
, OBJECT_VERSION_NUMBER
, LAST_UPDATE_DATE
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, LAST_UPDATED_BY
FROM PQH_BDGT_POOL_REALLOCTIONS
WHERE TRANSACTION_TYPE IN ('DD'
, 'RD')
Columns
Name |
REALLOCATION_PERIOD_ID |
TRANSACTION_TYPE |
BUDGET_PERIOD_ID |
ENTITY_ID |
START_DATE |
END_DATE |
REALLOCATION_AMT |
RESERVED_AMT |
BDGT_TXN_DETAIL_ID |
OBJECT_VERSION_NUMBER |
LAST_UPDATE_DATE |
CREATION_DATE |
CREATED_BY |
LAST_UPDATE_LOGIN |
LAST_UPDATED_BY |