[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | OKI_DBI_CLE_B_OLD |
|---|---|
| Object Type: | TABLE |
| Owner: | OKI |
| Subobject Name: | |
| Status: | VALID |
Contract sub-line staging table
| Tablespace: |  APPS_TS_INTERFACE |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| OKI_DBI_CLE_B_OLD_U1 | NORMAL | UNIQUE |
APPS_TS_INTERFACE
|
 CLE_ID
|
| OKI_DBI_CLE_B_OLD_N1 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
WORKER_NUMBER
|
| 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 | |
| CLE_CREATION_DATE | DATE | Yes | Creation date of the renewal sub-line | |
| INV_ORGANIZATION_ID | NUMBER | Inventory organization ID | ||
| AUTHORING_ORG_ID | NUMBER | Yes | Operating unit to which the contract belongs | |
| APPLICATION_ID | NUMBER | Yes | Contract application ID | |
| CUSTOMER_PARTY_ID | NUMBER | Yes | Customer party ID | |
| RESOURCE_GROUP_ID | NUMBER | Internal identifier for the resource group of the original contract. | ||
| RESOURCE_ID | NUMBER | Internal identifier for the salesperson resource of the original contract. | ||
| SALESREP_ID | NUMBER | The internal identifier for the contract salesperson for the original contract | ||
| 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 | ||
| CONTRACT_NUMBER | VARCHAR2 | (120) | Yes | Contract number |
| CONTRACT_NUMBER_MODIFIER | VARCHAR2 | (120) | Contract number modifier | |
| BUY_OR_SELL | VARCHAR2 | (3) | Yes | Buy or sell intent indicator |
| SCS_CODE | VARCHAR2 | (30) | Contract Category Code | |
| STS_CODE | VARCHAR2 | (30) | Status of the original contract line | |
| TRN_CODE | VARCHAR2 | (30) | Termination code of the original contract | |
| ROOT_LTY_CODE | VARCHAR2 | (30) | Line style code | |
| 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 | |
| DATE_SIGNED | DATE | Date the original contract was signed | ||
| DATE_CANCELLED | DATE | Date the original contract was cancelled | ||
| HSTART_DATE | DATE | Yes | Header Start date of the contract | |
| HEND_DATE | DATE | Header End date | ||
| START_DATE | DATE | Yes | Start date of the contract line for the original contract | |
| END_DATE | DATE | Yes | End date of the contract line for the original contract | |
| DATE_TERMINATED | DATE | Date the contract line was terminated | ||
| EFFECTIVE_START_DATE | DATE | Effective start date of the original contract line | ||
| EFFECTIVE_END_DATE | DATE | Effective end date of the contract line | ||
| 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 | ||
| SLE_ID | NUMBER | Internal contract line identifier for the original service line | ||
| SERVICE_ITEM_ID | NUMBER | The item identifier from the item master for the original service item. | ||
| SERVICE_ITEM_CATEGORY_ID | NUMBER | |||
| COVERED_ITEM_ID | NUMBER | The covered item or the covered product identifier from the item master for the original covered item. | ||
| COVERED_ITEM_ORG_ID | NUMBER | Inventory Organization ID for Covered Item | ||
| 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 | |
| PRIMARY_UOM_CODE | VARCHAR2 | (3) | ||
| TRX_MST_UOM_CONV_RATE | NUMBER | |||
| GRACE_END_DATE | DATE | The grace period end date for the original contract | ||
| EXPECTED_CLOSE_DATE | DATE | The expected close date of the orginal contract. | ||
| WIN_PERCENT | NUMBER | The estimated percentage probability that the original contract will be signed. | ||
| UBT_AMT | NUMBER | Unbilled Terminated Amount | ||
| UBT_AMT_F | NUMBER | Unbilled Terminated amount in functional currency | ||
| UBT_AMT_G | NUMBER | Unbilled terminated amount | ||
| UBT_AMT_SG | NUMBER | Unbilled terminated amount | ||
| 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 | ||
| 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 | ||
| 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 | ||
| RENEWAL_TYPE | VARCHAR2 | (30) | Renewal type stored at the line level | |
| TERM_FLAG | NUMBER | Flag - if Termination date is less than start date of line, term_flag= -1 | ||
| CREATED_BY | NUMBER | Yes | Standard Who column | |
| LAST_UPDATE_LOGIN | NUMBER | Standard Who column | ||
| CREATION_DATE | DATE | Yes | Standard Who column | |
| LAST_UPDATED_BY | NUMBER | Standard Who column | ||
| LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
| REQUEST_ID | NUMBER | Standard Who Column | ||
| PROGRAM_LOGIN_ID | NUMBER | Standard Who Column | ||
| PROGRAM_APPLICATION_ID | NUMBER | Standard Who Column | ||
| PROGRAM_ID | NUMBER | Standard Who Column | ||
| SECURITY_GROUP_ID | NUMBER | Used for application hosting. | ||
| R_CHR_ID | NUMBER | Internal idenitifer for the renewal contract | ||
| R_CLE_ID | NUMBER | Internal identifier for the renewal covered line | ||
| R_DATE_SIGNED | DATE | Date the renewal contract was signed | ||
| R_DATE_CANCELLED | DATE | Date the renewal contract was cancelled | ||
| P_CLE_ID | NUMBER | Internal identifier for the previous covered line | ||
| P_CHR_ID | NUMBER | Internal idenitifer for the previous contract | ||
| P_END_DATE | DATE | End date of the contract line for the previous contract | ||
| P_GRACE_END_DATE | DATE | The grace period end date for the original contract | ||
| P_PRICE_NEGOTIATED | NUMBER | Value of the previous covered line in transactional currency | ||
| P_PRICE_NEGOTIATED_F | NUMBER | Value of the previous covered line in functional currency | ||
| P_PRICE_NEGOTIATED_G | NUMBER | Value of the previous covered line in global currency | ||
| P_PRICE_NEGOTIATED_SG | NUMBER | Value of the previous covered line in secondary global currency | ||
| P_UBT_AMT | NUMBER | Unbilled terminated amount on previous side in transactional currency | ||
| P_UBT_AMT_F | NUMBER | Unbilled terminated amount on previous side in functional currency | ||
| P_UBT_AMT_G | NUMBER | Unbilled terminated amount on previous side in global currency | ||
| P_UBT_AMT_SG | NUMBER | Unbilled terminated amount on previous side in secondary global currency | ||
| P_CREDIT_AMT | NUMBER | credit amout for terminated contracts previous side in functional currency | ||
| P_CREDIT_AMT_F | NUMBER | credit amout for terminated contracts previous side in functional currency | ||
| P_CREDIT_AMT_G | NUMBER | credit amout for terminated contracts previous side in global currency | ||
| P_CREDIT_AMT_SG | NUMBER | credit amout for terminated contracts previous side in secondary global currency | ||
| P_OVERRIDE_AMT | NUMBER | Override amount on previous side for terminated contracts in transactional currency | ||
| P_OVERRIDE_AMT_F | NUMBER | Override amount on previous side for terminated contracts in functional currency | ||
| P_OVERRIDE_AMT_G | NUMBER | Override amount on previous side for terminated contracts in global currency | ||
| P_OVERRIDE_AMT_SG | NUMBER | Override amount on previous side for terminated contracts in secondary global currency | ||
| P_SUPP_CREDIT | NUMBER | Suppressed credit on previous side for terminated contracts in transactional currency | ||
| P_SUPP_CREDIT_F | NUMBER | Suppressed credit on previous side for terminated contracts in functional currency | ||
| P_SUPP_CREDIT_G | NUMBER | Suppressed credit on previous side for terminated contracts in global currency | ||
| P_SUPP_CREDIT_SG | NUMBER | Suppressed credit on previous side for terminated contracts in secondary global currency | ||
| P_TERM_FLAG | NUMBER | Previous side term flag - if Termination date is less than start date of line, term_flag= -1 | ||
| PRICE_NEGOTIATED_A | NUMBER | Annualized Value of the original covered line | ||
| UBT_AMT_A | NUMBER | Annualized Unbilled terminated amount on original side | ||
| CREDIT_AMT_A | NUMBER | Annualized credit amout for terminated contracts original side | ||
| OVERRIDE_AMT_A | NUMBER | Annualized Override amount on original side for terminated contracts | ||
| SUPP_CREDIT_A | NUMBER | Annualized Suppressed credit on original side for terminated contracts in transactional currency | ||
| P_PRICE_NEGOTIATED_A | NUMBER | Annualized Value of the previous covered line | ||
| P_UBT_AMT_A | NUMBER | Annualized Unbilled terminated amount on previous side | ||
| P_CREDIT_AMT_A | NUMBER | Annualized credit amout for terminated contracts previous side | ||
| P_OVERRIDE_AMT_A | NUMBER | Annualized Override amount on previous side for terminated contracts | ||
| P_SUPP_CREDIT_A | NUMBER | Annualized Suppressed credit on previous side for terminated contracts in transactional currency | ||
| ANNUALIZATION_FACTOR | NUMBER | Annualization factor is a number when multiplied by contract line amount will give the annualized line amount or in other words the amount of the contract if it were authored for one year | ||
| WORKER_NUMBER | NUMBER | Worker Number | ||
| GSD_FLAG | NUMBER | This flag is used to identify contracts before Global Start date. | ||
| FALSERNWLYN | VARCHAR2 | (1) | Stores Y for false renewals.If falsernwlyn is null, it implies that the contract line is either a true renewal or new business | |
| CURR_CODE | VARCHAR2 | (15) | Transactional Currency Code | |
| CURR_CODE_F | VARCHAR2 | (15) | Functional Currency Code | |
| HDR_ORDER_NUMBER | NUMBER | Order number at the contract header level | ||
| HDR_STS_CODE | VARCHAR2 | (30) | Status Code of Contract Header | |
| HDR_TRN_CODE | VARCHAR2 | (30) | Termination Code of Contract Header | |
| HDR_RENEWAL_TYPE | VARCHAR2 | (30) | Renewal Type of Contract Header | |
| HDR_DATE_APPROVED | DATE | Approval date of the contract header | ||
| HDR_DATE_CANCELLED | DATE | Cancellation date of the contract header | ||
| HDR_DATE_TERMINATED | DATE | Termination date of the contract header | ||
| HDR_CREATION_DATE | DATE | Date the contract header record was created | ||
| HDR_LAST_UPDATE_DATE | DATE | Date the contract header record was last updated | ||
| SERVICE_ITEM_ORG_ID | NUMBER | Organization id of the service item | ||
| SL_LINE_NUMBER | VARCHAR2 | (300) | Line number of the service line | |
| SL_STS_CODE | VARCHAR2 | (30) | Status Code of service line | |
| SL_TRN_CODE | VARCHAR2 | (30) | Termination code of the service line | |
| SL_RENEWAL_TYPE | VARCHAR2 | (30) | Renewal type of the service line | |
| SL_START_DATE | DATE | Start date of the service line | ||
| SL_END_DATE | DATE | End date of the service line | ||
| SL_DATE_CANCELLED | DATE | Cancellation date of the service line | ||
| SL_DATE_TERMINATED | DATE | Termination date of the service line | ||
| SL_CREATION_DATE | DATE | Date the service line record was created | ||
| SL_LAST_UPDATE_DATE | DATE | Date the service line record was last updated | ||
| ORDER_NUMBER | NUMBER | Order number at the contract covered line level | ||
| UNIT_PRICE_PERCENT | NUMBER | Covered Line Unit price percent | ||
| 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 | ||
| 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 | ||
| DURATION_UOM | VARCHAR2 | (3) | Covered Line Unit of measure code | |
| DURATION_QTY | NUMBER | Covered Line Duration Quantity | ||
| CL_LAST_UPDATE_DATE | DATE | Date the contract covered line record was last updated | ||
| COV_PROD_ID | NUMBER | Unique identifier of the covered product | ||
| COV_PROD_SYSTEM_ID | NUMBER | Unique identifier of the covered product system | ||
| LINE_NUMBER | VARCHAR2 | (300) | Line number of covered line | |
| LINE_TYPE | VARCHAR2 | (30) | Line type to indicate if covered line is item, product, customer, system etc. | |
| HDR_BILL_SITE_ID | NUMBER | Account site use identifier used to identify the billing address of the customer account. | ||
| HDR_SHIP_SITE_ID | NUMBER | Account site use identifier used to identify the shipping address of the customer account. | ||
| HDR_ACCT_RULE_ID | NUMBER | Revenue recognition rule identifier for the contract | ||
| EFFECTIVE_TERM_DATE | DATE | The date on which a contract line is terminated. This is either the termination date of the line or the greatest of the termination date and the termination entry date. The contract line amount is deducted from the balance on this date, if the contract line is terminated. | ||
| EFFECTIVE_EXPIRE_DATE | DATE | The date on which a contract line expires. This is either the end date of the line or the greatest of the end date and the signed date. The contract line amount is deducted from the balance on this date, if the contract line is not terminated. | ||
| EFFECTIVE_ACTIVE_DATE | DATE | The date on which a contract line amount is added to the balance. This is either the start date of the line or the greatest of the start date and the signed date | ||
| TERMINATION_ENTRY_DATE | DATE | The date on which the termination of a contract or contract line was entered into the system | ||
| HDR_GRACE_END_DATE | DATE | Header Grace End Date | ||
| HDR_DATE_SIGNED | DATE | Header Signed Date | ||
| HDR_SUBSEQUENT_RENEWAL_TYPE | VARCHAR2 | (30) | Subsequent Renewal Type of Contract Headers | |
| 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. | |
| NEGOTIATION_STATUS | VARCHAR2 | (30) | ||
| REMINDER | VARCHAR2 | (30) | ||
| HDR_TERM_CANCEL_SOURCE | VARCHAR2 | (30) | ||
| SL_TERM_CANCEL_SOURCE | VARCHAR2 | (30) |
Cut, paste (and edit) the following text to query this object:
SELECT CHR_ID
, CLE_ID
, CLE_CREATION_DATE
, INV_ORGANIZATION_ID
, AUTHORING_ORG_ID
, APPLICATION_ID
, CUSTOMER_PARTY_ID
, RESOURCE_GROUP_ID
, RESOURCE_ID
, SALESREP_ID
, PRICE_NEGOTIATED
, PRICE_NEGOTIATED_F
, PRICE_NEGOTIATED_G
, PRICE_NEGOTIATED_SG
, CONTRACT_NUMBER
, CONTRACT_NUMBER_MODIFIER
, BUY_OR_SELL
, SCS_CODE
, STS_CODE
, TRN_CODE
, ROOT_LTY_CODE
, RENEWAL_FLAG
, DATE_SIGNED
, DATE_CANCELLED
, HSTART_DATE
, HEND_DATE
, START_DATE
, END_DATE
, DATE_TERMINATED
, EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
, TRX_FUNC_CURR_RATE
, FUNC_GLOBAL_CURR_RATE
, FUNC_SGLOBAL_CURR_RATE
, SLE_ID
, SERVICE_ITEM_ID
, SERVICE_ITEM_CATEGORY_ID
, COVERED_ITEM_ID
, COVERED_ITEM_ORG_ID
, QUANTITY
, UOM_CODE
, PRIMARY_UOM_CODE
, TRX_MST_UOM_CONV_RATE
, GRACE_END_DATE
, EXPECTED_CLOSE_DATE
, WIN_PERCENT
, UBT_AMT
, UBT_AMT_F
, UBT_AMT_G
, UBT_AMT_SG
, CREDIT_AMT
, CREDIT_AMT_F
, CREDIT_AMT_G
, CREDIT_AMT_SG
, OVERRIDE_AMT
, OVERRIDE_AMT_F
, OVERRIDE_AMT_G
, OVERRIDE_AMT_SG
, SUPP_CREDIT
, SUPP_CREDIT_F
, SUPP_CREDIT_G
, SUPP_CREDIT_SG
, RENEWAL_TYPE
, TERM_FLAG
, CREATED_BY
, LAST_UPDATE_LOGIN
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, REQUEST_ID
, PROGRAM_LOGIN_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, SECURITY_GROUP_ID
, R_CHR_ID
, R_CLE_ID
, R_DATE_SIGNED
, R_DATE_CANCELLED
, P_CLE_ID
, P_CHR_ID
, P_END_DATE
, P_GRACE_END_DATE
, P_PRICE_NEGOTIATED
, P_PRICE_NEGOTIATED_F
, P_PRICE_NEGOTIATED_G
, P_PRICE_NEGOTIATED_SG
, P_UBT_AMT
, P_UBT_AMT_F
, P_UBT_AMT_G
, P_UBT_AMT_SG
, P_CREDIT_AMT
, P_CREDIT_AMT_F
, P_CREDIT_AMT_G
, P_CREDIT_AMT_SG
, P_OVERRIDE_AMT
, P_OVERRIDE_AMT_F
, P_OVERRIDE_AMT_G
, P_OVERRIDE_AMT_SG
, P_SUPP_CREDIT
, P_SUPP_CREDIT_F
, P_SUPP_CREDIT_G
, P_SUPP_CREDIT_SG
, P_TERM_FLAG
, PRICE_NEGOTIATED_A
, UBT_AMT_A
, CREDIT_AMT_A
, OVERRIDE_AMT_A
, SUPP_CREDIT_A
, P_PRICE_NEGOTIATED_A
, P_UBT_AMT_A
, P_CREDIT_AMT_A
, P_OVERRIDE_AMT_A
, P_SUPP_CREDIT_A
, ANNUALIZATION_FACTOR
, WORKER_NUMBER
, GSD_FLAG
, FALSERNWLYN
, CURR_CODE
, CURR_CODE_F
, HDR_ORDER_NUMBER
, HDR_STS_CODE
, HDR_TRN_CODE
, HDR_RENEWAL_TYPE
, HDR_DATE_APPROVED
, HDR_DATE_CANCELLED
, HDR_DATE_TERMINATED
, HDR_CREATION_DATE
, HDR_LAST_UPDATE_DATE
, SERVICE_ITEM_ORG_ID
, SL_LINE_NUMBER
, SL_STS_CODE
, SL_TRN_CODE
, SL_RENEWAL_TYPE
, SL_START_DATE
, SL_END_DATE
, SL_DATE_CANCELLED
, SL_DATE_TERMINATED
, SL_CREATION_DATE
, SL_LAST_UPDATE_DATE
, ORDER_NUMBER
, UNIT_PRICE_PERCENT
, UNIT_PRICE
, UNIT_PRICE_F
, UNIT_PRICE_G
, UNIT_PRICE_SG
, LIST_PRICE
, LIST_PRICE_F
, LIST_PRICE_G
, LIST_PRICE_SG
, DURATION_UOM
, DURATION_QTY
, CL_LAST_UPDATE_DATE
, COV_PROD_ID
, COV_PROD_SYSTEM_ID
, LINE_NUMBER
, LINE_TYPE
, HDR_BILL_SITE_ID
, HDR_SHIP_SITE_ID
, HDR_ACCT_RULE_ID
, EFFECTIVE_TERM_DATE
, EFFECTIVE_EXPIRE_DATE
, EFFECTIVE_ACTIVE_DATE
, TERMINATION_ENTRY_DATE
, HDR_GRACE_END_DATE
, HDR_DATE_SIGNED
, HDR_SUBSEQUENT_RENEWAL_TYPE
, AGREEMENT_TYPE_CODE
, AGREEMENT_NAME
, NEGOTIATION_STATUS
, REMINDER
, HDR_TERM_CANCEL_SOURCE
, SL_TERM_CANCEL_SOURCE
FROM OKI.OKI_DBI_CLE_B_OLD;
OKI.OKI_DBI_CLE_B_OLD does not reference any database object
OKI.OKI_DBI_CLE_B_OLD is referenced by following:
APPS
OKI_DBI_CLE_B_OLD
|
|
|
|