CE_CP_CASH_POOL_V

Details

• Schema: FUSION

• Object owner: CE

• Object type: VIEW

Columns

Name
CASH_POOL_ID CASH_POOL_NAME PARENT_CASH_POOL_NAME NESTING_LEVEL

Query

SQL_Statement

SELECT cashPool.cash_pool_id , cashPool.cash_pool_name , NVL(SUBSTR(substr('[' || SYS_CONNECT_BY_PATH(cashPool.cash_pool_name,'].[') || ']', 1, INSTR('[' || SYS_CONNECT_BY_PATH(cashPool.cash_pool_name,'].[') || ']','.['||cashPool.cash_pool_name||']')-1), 4), '[NO_PARENT_CASH_POOL_VALUE]') AS parent_cash_pool_name , level-1 AS nesting_level FROM ce_cash_pools cashPool ,ce_cash_pool_members cashPoolMembers ,ce_cash_pools parentCashPool WHERE cashpool.enabled_flag = 'Y' AND cashPool.cash_pool_id = cashPoolMembers.sub_cash_pool_id(+) AND parentCashPool.cash_pool_id(+) = cashPoolMembers.cash_pool_id AND parentCashPool.enabled_flag(+) = 'Y' START WITH parentCashPool.cash_pool_name IS NULL CONNECT BY PRIOR cashPool.cash_pool_name = parentCashPool.cash_pool_name