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.

VIEW: APPS.PQH_REALLOC_TXN_DETAILS_V

Source

View Text - Preformatted


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

View Text - HTML Formatted

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