[Home] [Help] [Dependency Information]
Object Name: | OKI_RENEW_RELS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OKI.OKI_RENEW_RELS_V |
Subobject Name: | |
Status: | VALID |
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.
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. |
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;
APPS.OKI_RENEW_RELS_V is not referenced by any database object
|
|
|