VIEW: APPS.OKE_K_FUNDING_SUMMARY_V

Source

View Text - Preformatted

SELECT OBJECT_TYPE , OBJECT_ID , MAX(MAJOR_VERSION) , FUNDING_CURRENCY_CODE , GROUP_BY1 , GROUP_BY1_CODE , GROUP_BY2 , GROUP_BY2_CODE , GROUP_BY3 , GROUP_BY3_CODE , SUM(F_CURR_INIT_AMOUNT) , SUM(F_CURR_INCR_AMOUNT) , SUM(F_CURR_AMOUNT) , SUM(F_CURR_HARD_LIMIT) , SUM(F_CURR_REV_HARD_LIMIT) , SUM(K_CURR_INIT_AMOUNT) , SUM(K_CURR_INCR_AMOUNT) , SUM(K_CURR_AMOUNT) , SUM(K_CURR_HARD_LIMIT) , SUM(K_CURR_REV_HARD_LIMIT) FROM OKE_K_FUND_VERS_SUMMARY_V GROUP BY OBJECT_TYPE , OBJECT_ID , FUNDING_CURRENCY_CODE , GROUP_BY1 , GROUP_BY2 , GROUP_BY3 , GROUP_BY1_CODE , GROUP_BY2_CODE , GROUP_BY3_CODE

View Text - HTML Formatted

SELECT OBJECT_TYPE
, OBJECT_ID
, MAX(MAJOR_VERSION)
, FUNDING_CURRENCY_CODE
, GROUP_BY1
, GROUP_BY1_CODE
, GROUP_BY2
, GROUP_BY2_CODE
, GROUP_BY3
, GROUP_BY3_CODE
, SUM(F_CURR_INIT_AMOUNT)
, SUM(F_CURR_INCR_AMOUNT)
, SUM(F_CURR_AMOUNT)
, SUM(F_CURR_HARD_LIMIT)
, SUM(F_CURR_REV_HARD_LIMIT)
, SUM(K_CURR_INIT_AMOUNT)
, SUM(K_CURR_INCR_AMOUNT)
, SUM(K_CURR_AMOUNT)
, SUM(K_CURR_HARD_LIMIT)
, SUM(K_CURR_REV_HARD_LIMIT)
FROM OKE_K_FUND_VERS_SUMMARY_V GROUP BY OBJECT_TYPE
, OBJECT_ID
, FUNDING_CURRENCY_CODE
, GROUP_BY1
, GROUP_BY2
, GROUP_BY3
, GROUP_BY1_CODE
, GROUP_BY2_CODE
, GROUP_BY3_CODE