FND Design Data [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: ViewAPPS.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