eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[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