[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 |