SELECT POOL_ID,NAME,BUDGET_VERSION_ID,BUDGET_UNIT_ID,ENTITY_TYPE,APPROVAL_STATUS,OBJECT_VERSION_NUMBER,CREATION_DATE,CREATED_BY,LAST_UPDATE_LOGIN,LAST_UPDATED_BY FROM PQH_BUDGET_POOLS WHERE parent_pool_id is null
SELECT POOL_ID
, NAME
, BUDGET_VERSION_ID
, BUDGET_UNIT_ID
, ENTITY_TYPE
, APPROVAL_STATUS
, OBJECT_VERSION_NUMBER
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, LAST_UPDATED_BY
FROM PQH_BUDGET_POOLS
WHERE PARENT_POOL_ID IS NULL
|
|
|