[Home] [Help]
View: PQH_REALLOC_TXN_DETAILS_V
Product: | PQH - Public Sector HR |
Description: | Donor, Reciever details corresponding to the budget reallocation folder |
Implementation/DBA Data: |
APPS.PQH_REALLOC_TXN_DETAILS_V
|
View Text
SELECT BRE.REALLOCATION_ID
, BRE.POOL_ID
, BRE.TRANSACTION_TYPE
, BRE.BUDGET_DETAIL_ID
, BPL.ENTITY_TYPE
, BRE.ENTITY_ID
, BRE.OBJECT_VERSION_NUMBER
, BRE.LAST_UPDATE_DATE
, BRE.CREATION_DATE
, BRE.CREATED_BY
, BRE.LAST_UPDATE_LOGIN
, BRE.LAST_UPDATED_BY
FROM PQH_BDGT_POOL_REALLOCTIONS BRE
, PQH_BUDGET_POOLS BPL
, PQH_BUDGET_POOLS BPL1
WHERE BRE.TRANSACTION_TYPE IN ('D'
, 'R')
AND BRE.POOL_ID = BPL1.POOL_ID
AND BPL1.PARENT_POOL_ID = BPL.POOL_ID
Columns
Name |
TXN_DETAIL_ID |
TRANSACTION_ID |
TRANSACTION_TYPE |
BUDGET_DETAIL_ID |
ENTITY_TYPE |
ENTITY_ID |
OBJECT_VERSION_NUMBER |
LAST_UPDATE_DATE |
CREATION_DATE |
CREATED_BY |
LAST_UPDATE_LOGIN |
LAST_UPDATED_BY |