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.OKI_CSOURCE_DTL_V

Object Details

Object Name:	OKI_CSOURCE_DTL_V
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

This view gives the contract covered line sourcing information. For example, if it is a renewal consolidation, it gives the source of the consolidation.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
TARGET_CLE_ID	NUMBER
SOURCE_CLE_ID	NUMBER
SOURCE_OPERATION	VARCHAR2	(90)	Yes
SOURCE_CONTRACT_NUMBER	VARCHAR2	(120)	Yes
SOURCE_CONTRACT_MODIFIER	VARCHAR2	(120)
SOURCE_LINE_NUMBER	VARCHAR2	(301)
SOURCE_CURRENCY_CODE	VARCHAR2	(15)		Source Currency Code
SOURCE_CURR_CODE_F	VARCHAR2	(15)		Source Curr Code F
SOURCE_CURR_CODE_G	VARCHAR2	(15)		Source Curr Code G
SOURCE_CURR_CODE_SG	VARCHAR2	(15)		Source Curr Code Sg
SOURCE_CURR_CODE_A	VARCHAR2	(15)		Source Curr Code A
SOURCE_CONTRACT_LINE_AMOUNT	NUMBER			Source Contract Line Amount
SOURCE_PRICE_NEGOTIATED_F	NUMBER			Source Price Negotiated F
SOURCE_PRICE_NEGOTIATED_G	NUMBER			Source Price Negotiated G
SOURCE_PRICE_NEGOTIATED_SG	NUMBER			Source Price Negotiated Sg
SOURCE_PRICE_NEGOTIATED_A	NUMBER			Source Price Negotiated A
TAR_CONTRACT_NUMBER	VARCHAR2	(120)	Yes	Target Contract Number
TAR_CONTRACT_NUMBER_MODIFIER	VARCHAR2	(120)		Target Contract Modifier
TAR_CURR_CODE	VARCHAR2	(15)		Transactional Currency Code
TAR_CURR_CODE_F	VARCHAR2	(15)		Functional Currency Code
TAR_CURR_CODE_G	VARCHAR2	(15)		Primary Currency Code
TAR_CURR_CODE_SG	VARCHAR2	(15)		Secondary Currency Code
TAR_CURR_CODE_A	VARCHAR2	(15)		Target Annualized Currency Code
TAR_PRICE_NEGOTIATED	NUMBER			Target Negotiated Price in Transactional Currency
TAR_PRICE_NEGOTIATED_F	NUMBER			Target Negotiated Price in Functional Currency
TAR_PRICE_NEGOTIATED_G	NUMBER			Target Negotiated Price in Primary Currency
TAR_PRICE_NEGOTIATED_SG	NUMBER			Target Negotiated Price in Secondary Currency
TAR_PRICE_NEGOTIATED_A	NUMBER			Target Annualized Negotiated Price

Query Text

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


SELECT TARGET_CLE_ID
,      SOURCE_CLE_ID
,      SOURCE_OPERATION
,      SOURCE_CONTRACT_NUMBER
,      SOURCE_CONTRACT_MODIFIER
,      SOURCE_LINE_NUMBER
,      SOURCE_CURRENCY_CODE
,      SOURCE_CURR_CODE_F
,      SOURCE_CURR_CODE_G
,      SOURCE_CURR_CODE_SG
,      SOURCE_CURR_CODE_A
,      SOURCE_CONTRACT_LINE_AMOUNT
,      SOURCE_PRICE_NEGOTIATED_F
,      SOURCE_PRICE_NEGOTIATED_G
,      SOURCE_PRICE_NEGOTIATED_SG
,      SOURCE_PRICE_NEGOTIATED_A
,      TAR_CONTRACT_NUMBER
,      TAR_CONTRACT_NUMBER_MODIFIER
,      TAR_CURR_CODE
,      TAR_CURR_CODE_F
,      TAR_CURR_CODE_G
,      TAR_CURR_CODE_SG
,      TAR_CURR_CODE_A
,      TAR_PRICE_NEGOTIATED
,      TAR_PRICE_NEGOTIATED_F
,      TAR_PRICE_NEGOTIATED_G
,      TAR_PRICE_NEGOTIATED_SG
,      TAR_PRICE_NEGOTIATED_A
FROM APPS.OKI_CSOURCE_DTL_V;

Dependencies

[top of page]

APPS.OKI_CSOURCE_DTL_V references the following:

APPS: BIS_COMMON_PARAMETERS - show dependent code; OKC_CLASS_OPERATIONS; OKC_K_HEADERS_ALL_B; OKC_K_LINES_B; OKC_OPERATIONS_B; OKC_OPERATIONS_TL; OKC_OPERATION_INSTANCES; OKC_OPERATION_LINES; OKI_DBI_CLE_B
PUBLIC: DUAL

APPS.OKI_CSOURCE_DTL_V is not referenced by any database object