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

VIEW: APPS.OKI_DBI_CLE_V

Object Details
Object Name: OKI_DBI_CLE_V
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID


Covered line fact view. This view is based on the Contract lines fact table


[View Source]

Columns
Name Datatype Length Mandatory Comments
CHR_ID NUMBER
Yes Internal idenitifer for the original contract
CLE_ID NUMBER
Yes Internal identifier for the orginial covered line
COV_PROD_ID NUMBER

Unique identifier of the covered product
COV_PROD_SYSTEM_ID NUMBER

Unique identifier of the covered product system
COVERED_ITEM_ID NUMBER

The covered item or the covered product identifier from the item master for the original covered item
SERVICE_ITEM_ID NUMBER

The item identifier from the item master for the original service item
INV_ORGANIZATION_ID NUMBER

Inventory organization ID
SLE_ID NUMBER

Internal contract line identifier for the original service line
P_CHR_ID NUMBER

Internal idenitifer for the previous contract
P_CLE_ID NUMBER

Internal identifier for the previous covered line
SCS_CODE VARCHAR2 (30)
Header Start date of the contract
CONTRACT_NUMBER VARCHAR2 (120) Yes Contract Number
CONTRACT_NUMBER_MODIFIER VARCHAR2 (120)
Contract Number Modifier
COMPLETE_K_NUMBER VARCHAR2 (241)
Complete Contract Number
LINE_NUMBER VARCHAR2 (300)
Line number of covered line
STS_CODE VARCHAR2 (30)
Status of the original contract line
TRN_CODE VARCHAR2 (30)
Termination code of the original contract
ORDER_NUMBER NUMBER

Order number at the contract covered line level
CLE_CREATION_DATE DATE
Yes Creation date of the renewal sub-line
DATE_CANCELLED DATE

Date the original contract was cancelled
DATE_TERMINATED DATE

Date the contract line was terminated
END_DATE DATE

End date of the contract line for the original contract
START_DATE DATE

Start date of the contract line for the original contract
LAST_UPDATE_DATE DATE

Standard Who column
RENEWAL_FLAG NUMBER
Yes Flag to identify if the contract line is a new line or a renewal line and whether or not the contract line is renewed 0 -new line, not renewed 1 - renewal line, not renewed 2 - new line, renewed 3 - renewal line, renewed
RENEWAL_TYPE_CODE VARCHAR2 (30)
Identifier for Renewal Type
DURATION_QTY NUMBER

Covered Line Duration Quantity
DURATION_UOM VARCHAR2 (3)
Covered Line Unit of measure code
QUANTITY NUMBER

The quantity for the covered item or the covered product
UOM_CODE VARCHAR2 (3)
The unit of measure code for the covered item or covered product
CURR_CODE VARCHAR2 (15)
Transactional Currency Code
CURR_CODE_F VARCHAR2 (15)
Functional Currency Code
CURR_CODE_G VARCHAR2 (15)
Global Currency Code
CURR_CODE_SG VARCHAR2 (15)
Secondary Global Currency Code
CURR_CODE_A VARCHAR2 (15)
Annualized Currency Code
LIST_PRICE NUMBER

Covered Line List price
LIST_PRICE_F NUMBER

Covered Line List price in functional currency
LIST_PRICE_G NUMBER

Covered Line List price in global currency
LIST_PRICE_SG NUMBER

Covered Line List price in secondary global currency
UNIT_PRICE NUMBER

Covered Line Unit price
UNIT_PRICE_F NUMBER

Covered Line Unit price in functional currency
UNIT_PRICE_G NUMBER

Covered Line Unit price in Global currency
UNIT_PRICE_SG NUMBER

Covered Line Unit price in Secondary Global currency
UNIT_PRICE_PERCENT NUMBER

Covered Line Unit price percent
UBT_AMT NUMBER

Unbilled Terminated Amount
UBT_AMT_F NUMBER

Unbilled Terminated amount in functional currency
UBT_AMT_G NUMBER

Unbilled Terminated amount in Global currency
UBT_AMT_SG NUMBER

Unbilled Terminated amount in Secondary Global currency
UBT_AMT_A NUMBER

Annualized Unbilled terminated amount on original side
SUPP_CREDIT NUMBER

Suppressed credit for terminated contracts
SUPP_CREDIT_F NUMBER

Suppressed credit for terminated contracts, functional currency
SUPP_CREDIT_G NUMBER

Suppressed credit for terminated contracts, global currency
SUPP_CREDIT_SG NUMBER

Suppressed credit for terminated contracts, secondary global currency
SUPP_CREDIT_A NUMBER

Annualized Suppressed credit on original side for terminated contracts in transactional currency
CREDIT_AMT NUMBER

Credit Amount for terminated Contracts
CREDIT_AMT_F NUMBER

Credit Amount for terminated Contracts, functional currency
CREDIT_AMT_G NUMBER

Credit Amount for terminated Contracts, global currency
CREDIT_AMT_SG NUMBER

Credit Amount for terminated Contracts, secondary global currency
CREDIT_AMT_A NUMBER

Annualized credit amount for terminated contracts original side
OVERRIDE_AMT NUMBER

Override amount for terminated contracts
OVERRIDE_AMT_F NUMBER

Override Amt for terminated contracts in functional currency
OVERRIDE_AMT_G NUMBER

Override Amt for terminated contracts in global currency
OVERRIDE_AMT_SG NUMBER

Override Amt for terminated contracts in secondary global currency
OVERRIDE_AMT_A NUMBER

Annualized Override amount on original side for terminated contracts
PRICE_NEGOTIATED NUMBER

Value of the original covered line in transactional currency
PRICE_NEGOTIATED_F NUMBER

Value of the original covered line in functional currency
PRICE_NEGOTIATED_G NUMBER

Value of the original covered line in global currency
PRICE_NEGOTIATED_SG NUMBER

Value of the original covered line in secondary global currency
PRICE_NEGOTIATED_A NUMBER

Annualized Value of the original covered line
RENEWED_PRICE NUMBER

Renewed Price in Transactional Currency
RENEWED_PRICE_F NUMBER

Renewed Price in Functional Currency
RENEWED_PRICE_G NUMBER

Renewed Price in Global Currency
RENEWED_PRICE_SG NUMBER

Renewed Price in Secondary Global Currency
RENEWED_PRICE_A NUMBER

Renewed Price in Annualized Currency
LINE_TYPE VARCHAR2 (30)
Account site use identifier used to identify the billing address of the customer account.
TRX_FUNC_CURR_RATE NUMBER

Conversion rate from transactional currency to functional currency
FUNC_GLOBAL_CURR_RATE NUMBER

Conversion rate from functional currency to global currency
FUNC_SGLOBAL_CURR_RATE NUMBER

Conversion rate from functional currency to secondary global currency
AGREEMENT_TYPE_CODE VARCHAR2 (80)
Added Agreement_type_code as part of ER 6062516.
AGREEMENT_NAME VARCHAR2 (240)
Added Agreement_Name as part of ER 6062516.
TERM_CANCEL_SOURCE VARCHAR2 (30)
Term Cancel Source
Query Text

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


SELECT CHR_ID
,      CLE_ID
,      COV_PROD_ID
,      COV_PROD_SYSTEM_ID
,      COVERED_ITEM_ID
,      SERVICE_ITEM_ID
,      INV_ORGANIZATION_ID
,      SLE_ID
,      P_CHR_ID
,      P_CLE_ID
,      SCS_CODE
,      CONTRACT_NUMBER
,      CONTRACT_NUMBER_MODIFIER
,      COMPLETE_K_NUMBER
,      LINE_NUMBER
,      STS_CODE
,      TRN_CODE
,      ORDER_NUMBER
,      CLE_CREATION_DATE
,      DATE_CANCELLED
,      DATE_TERMINATED
,      END_DATE
,      START_DATE
,      LAST_UPDATE_DATE
,      RENEWAL_FLAG
,      RENEWAL_TYPE_CODE
,      DURATION_QTY
,      DURATION_UOM
,      QUANTITY
,      UOM_CODE
,      CURR_CODE
,      CURR_CODE_F
,      CURR_CODE_G
,      CURR_CODE_SG
,      CURR_CODE_A
,      LIST_PRICE
,      LIST_PRICE_F
,      LIST_PRICE_G
,      LIST_PRICE_SG
,      UNIT_PRICE
,      UNIT_PRICE_F
,      UNIT_PRICE_G
,      UNIT_PRICE_SG
,      UNIT_PRICE_PERCENT
,      UBT_AMT
,      UBT_AMT_F
,      UBT_AMT_G
,      UBT_AMT_SG
,      UBT_AMT_A
,      SUPP_CREDIT
,      SUPP_CREDIT_F
,      SUPP_CREDIT_G
,      SUPP_CREDIT_SG
,      SUPP_CREDIT_A
,      CREDIT_AMT
,      CREDIT_AMT_F
,      CREDIT_AMT_G
,      CREDIT_AMT_SG
,      CREDIT_AMT_A
,      OVERRIDE_AMT
,      OVERRIDE_AMT_F
,      OVERRIDE_AMT_G
,      OVERRIDE_AMT_SG
,      OVERRIDE_AMT_A
,      PRICE_NEGOTIATED
,      PRICE_NEGOTIATED_F
,      PRICE_NEGOTIATED_G
,      PRICE_NEGOTIATED_SG
,      PRICE_NEGOTIATED_A
,      RENEWED_PRICE
,      RENEWED_PRICE_F
,      RENEWED_PRICE_G
,      RENEWED_PRICE_SG
,      RENEWED_PRICE_A
,      LINE_TYPE
,      TRX_FUNC_CURR_RATE
,      FUNC_GLOBAL_CURR_RATE
,      FUNC_SGLOBAL_CURR_RATE
,      AGREEMENT_TYPE_CODE
,      AGREEMENT_NAME
,      TERM_CANCEL_SOURCE
FROM APPS.OKI_DBI_CLE_V;

Dependencies

[top of page]

APPS.OKI_DBI_CLE_V references the following:

SchemaAPPS
PL/SQL PackageBIS_COMMON_PARAMETERS - show dependent code
PL/SQL PackageOKC_UTIL - show dependent code
SynonymOKI_DBI_CLE_B
SchemaPUBLIC
SynonymDUAL
APPS.OKI_DBI_CLE_V is referenced by following:

SchemaAPPS
ViewOKI_CLICE_DTL_V