View: OKE_K_FUNDING_SUMMARY_V

Product:	OKE - Project Contracts
Description:	Funding allocation summary view
Implementation/DBA Data:	APPS.OKE_K_FUNDING_SUMMARY_V

View Text

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

Columns