DBA Data[Home] [Help]

VIEW: APPS.PQH_REALLOC_TXN_PERIODS_V

Source

View Text - Preformatted

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')
View Text - HTML Formatted

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')