eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.OKE_K_FUND_VERS_SUMMARY_V

Object Details

Object Name:	OKE_K_FUND_VERS_SUMMARY_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OKE.OKE_K_FUND_VERS_SUMMARY_V
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
OBJECT_TYPE	VARCHAR2	(30)	Yes	Internal identifier of the type of object. Currently only valid value is OKE_K_HEADERS
OBJECT_ID	NUMBER		Yes	Contract document unique identifier
MAJOR_VERSION	NUMBER			Major version number of contract document
FUNDING_CURRENCY_CODE	VARCHAR2	(15)	Yes	Funding currency
GROUP_BY1	VARCHAR2	(360)		First group-by column for the summary
GROUP_BY1_CODE	VARCHAR2	(80)		First group-by column identifier for the summary
GROUP_BY2	VARCHAR2	(360)		Second group-by column for the summary
GROUP_BY2_CODE	VARCHAR2	(80)		Second group-by column identifier for the summary
GROUP_BY3	VARCHAR2	(360)		Third group-by column for the summary
GROUP_BY3_CODE	VARCHAR2	(80)		Third group-by column identifier for the summary
F_CURR_INIT_AMOUNT	NUMBER			Initial funding amount
F_CURR_INCR_AMOUNT	NUMBER			Incremental funding amount
F_CURR_AMOUNT	NUMBER			Current funding amount
F_CURR_HARD_LIMIT	NUMBER			Current invoice hard limit amount
F_CURR_REV_HARD_LIMIT	NUMBER			Current revenue hard limit amount
K_CURR_INIT_AMOUNT	NUMBER			Initial funding amount in contract currency
K_CURR_INCR_AMOUNT	NUMBER			Incremental funding amount in contract currency
K_CURR_AMOUNT	NUMBER			Current funding amount in contract currency
K_CURR_HARD_LIMIT	NUMBER			Current invoice hard limit amount in contract currency
K_CURR_REV_HARD_LIMIT	NUMBER			Current revenue hard limit amount in contract currency

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT OBJECT_TYPE
,      OBJECT_ID
,      MAJOR_VERSION
,      FUNDING_CURRENCY_CODE
,      GROUP_BY1
,      GROUP_BY1_CODE
,      GROUP_BY2
,      GROUP_BY2_CODE
,      GROUP_BY3
,      GROUP_BY3_CODE
,      F_CURR_INIT_AMOUNT
,      F_CURR_INCR_AMOUNT
,      F_CURR_AMOUNT
,      F_CURR_HARD_LIMIT
,      F_CURR_REV_HARD_LIMIT
,      K_CURR_INIT_AMOUNT
,      K_CURR_INCR_AMOUNT
,      K_CURR_AMOUNT
,      K_CURR_HARD_LIMIT
,      K_CURR_REV_HARD_LIMIT
FROM APPS.OKE_K_FUND_VERS_SUMMARY_V;

Dependencies

[top of page]

APPS.OKE_K_FUND_VERS_SUMMARY_V references the following:

APPS: FND_LOOKUP_VALUES; OKE_FUNDING_INQUIRY - show dependent code; OKE_K_FUNDING_SOURCES_V; OKE_K_FUND_ALLOCATIONS_HV; OKE_K_FUND_ALLOCATIONS_V; OKE_K_VERS_NUMBERS_V

APPS.OKE_K_FUND_VERS_SUMMARY_V is referenced by following:

APPS: OKE_K_FUNDING_SUMMARY_V