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_RENEW_RELS_V

Object Details

Object Name:	OKI_RENEW_RELS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OKI.OKI_RENEW_RELS_V
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

This view relates a renewed contract to a renewal contract at the header and line level. The renewal contract is considered a renewal if it has either been created as part of a normal renewal or is the target of renewal consolidation (or both). The status of the renewed contract header and lines and the renewal headers and lines are shown.
Renewals that are subsequently canceled are not shown. Renewals in any other status type are shown.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
SOURCE_HEADER_ID	NUMBER		Yes	The internal identifier of the renewed contract.
SOURCE_CHR_STATUS_CODE	VARCHAR2	(30)	Yes	The status code of the renewed contract.
SOURCE_CHR_STATUS_TYPE	VARCHAR2	(30)	Yes	The status type code of the renewed contract.
SOURCE_LINE_ID	NUMBER		Yes	The internal identifier of the renewed line.
SOURCE_CLE_STATUS_CODE	VARCHAR2	(30)	Yes	The status code of the renewed contract.
SOURCE_CLE_STATUS_TYPE	VARCHAR2	(30)	Yes	The status type code of the renewed contract.
TRGT_HEADER_ID	NUMBER		Yes	The internal identifier of the renewing line.
TRGT_CHR_STATUS_CODE	VARCHAR2	(30)	Yes	The status code of the renewing contract.
TRGT_CHR_STATUS_TYPE	VARCHAR2	(30)	Yes	The status type code of the renewing contract.
TRGT_LINE_ID	NUMBER		Yes	The status type code of the renewing line.
TRGT_CLE_STATUS_CODE	VARCHAR2	(30)	Yes	The status code of the renewing line.
TRGT_CLE_STATUS_TYPE	VARCHAR2	(30)	Yes	The status type code of the renewing line.

Query Text

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


SELECT SOURCE_HEADER_ID
,      SOURCE_CHR_STATUS_CODE
,      SOURCE_CHR_STATUS_TYPE
,      SOURCE_LINE_ID
,      SOURCE_CLE_STATUS_CODE
,      SOURCE_CLE_STATUS_TYPE
,      TRGT_HEADER_ID
,      TRGT_CHR_STATUS_CODE
,      TRGT_CHR_STATUS_TYPE
,      TRGT_LINE_ID
,      TRGT_CLE_STATUS_CODE
,      TRGT_CLE_STATUS_TYPE
FROM APPS.OKI_RENEW_RELS_V;

Dependencies

[top of page]

APPS.OKI_RENEW_RELS_V references the following:

APPS: OKC_CLASS_OPERATIONS; OKC_K_HEADERS_B; OKC_K_LINES_B; OKC_OPERATION_INSTANCES; OKC_OPERATION_LINES; OKC_STATUSES_B

APPS.OKI_RENEW_RELS_V is not referenced by any database object