Oracle eBusiness Suite Technical Reference

Release 11i - Copyright (c) 2001 - 2005 Oracle

This Technical Reference Manual (TRM) in any form, software or printed matter, contains proprietary information of Oracle ; it is provided under an Oracle agreement containing restrictions on use and disclosure and is also protected by copyright, patent, and other intellectual property law. Restrictions applicable to this TRM include, but are not limited to: (a) exercising either the same degree of care to safeguard the confidentiality of this TRM as you exercise to safeguard the confidentiality of your own most important Confidential Information or a reasonable degree of care, whichever is greater; (b) maintaining agreements with your employees and agents that protect the Confidential Information of third parties such as Oracle and instructing such employees and agents of these requirements for this TRM; (c) restricting disclosure of this TRM to those of your employees who have a 'need to know' consistent with the purposes for which this TRM was disclosed to you; (d) maintaining this TRM at all times on your premises; (e) not removing or destroying any proprietary or confidential legends or markings placed upon this TRM in whatever form, software or printed matter; and (f) not reproducing or transmitting this TRM in any form or by any means, electronic or mechanical, for any purpose, without the express written permission of Oracle. You should not use this TRM in any form, software or printed matter, to create software that performs the same or similar functions as any Oracle products.

The information in this TRM is subject to change without notice. If you find any problems in the TRM in any form, software or printed matter, please report them to us in writing. Oracle does not warrant that this TRM is error free. This TRM is provided to customer 'as is' with no warranty of any kind. This TRM does not constitute Documentation as that term is defined in Oracle's agreements. Reverse engineering of the Programs (software and documentation) associated with this TRM are prohibited. The Programs associated with this TRM are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently dangerous applications. It shall be licensee's responsibility to take all appropriate fail safe, backup, redundancy and other measures to ensure the safe use of such applications if the Programs are used for such purposes, and Oracle disclaims liability for any damages caused by such use of the Programs. Program Documentation is licensed for use solely to support the deployment of the Programs and not for any other any other purpose. Restricted Rights Legend

This TRM and the Programs associated with this TRM delivered subject to the DOD FAR Supplement are 'commercial computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement. Otherwise, this TRM and the Programs associated with this TRM delivered subject to the Federal Acquisition Regulations are 'restricted computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the restrictions in FAR 52.227-14, Rights in Data General, including Alternate III (June 1987). Oracle, 500 Oracle Parkway, Redwood City, CA 94065.

Oracle is a registered trademark. AIM Advantage™, Big Business. Small Business. All Business.™, CDM Advantage™, .comference™, ConText®, Des40®, Easy*Query™, Easy*SQL®, Education Objects™, EMM Advantage™, Enabling the Information Age®, ExpertDetectSM, Express®, FastForwardSM, GEMMS®, Gist™, Hyper*SQL™, instantOracle™, "Internet Business Intelligence - Insight for Everyone"™, iSQL*Plus™, JInitiator™, NLS*Workbench®, Object Marketplace™, ODP Pulse™, ODP Techwire™, OLA™, On Oracle™, Oracle®, Oracle Book®, Oracle Bookbatch®, Oracle BookBuilder®, OracleBRONZE®, Oracle Business OnLine®, OracleDevConnectSM, Oracle® Discoverer™, Oracle® Expert™, Oracle Financials®, OracleGOLDSM, OracleIncidentSM, OracleJSP™, OracleLifeCycleSM, Oracle Media Objects®, OracleMERCURYSM, OracleMetaLinkSM, OraclemetalsSM, OracleMobile™, Oracle Names®, Oracle NetSolutions®, Oracle® One™, Oracle Open Gateways®, Oracle OpenWorld®, OraclePLATINUMSM, Oracle Power Objects®, Oracle Press®, Oracle Procedural Gateway®, Oracle Quality®, Oracle Secure Network Services®, OracleSILVERSM, Oracle® SQL/Services™, Oracle® SQL*TutorSM, OracleSTERLINGSM, Oracle Store®, Oracle Transparent Gateway®, OracleWare®, Oracle8i™, Oracle9i™, PC Express®, Personal Express®, PJM Advantage™, PL/SQL™, Pro*Ada®, Pro*C™, Pro*C/C++™, Pro*COBOL®, Pro*FORTRAN®, Pro*Pascal®, Pro*PL/1®, Pro*REXX®, Profit™, ProREXX™, Report Card™, Secure Access 2.0™, Secure Network Services®, Security Without Compromise™, SellingPoint®, SQL*Plus®, Tutor™ are trademarks or registered trademarks of Oracle. Other names may be trademarks of their respective owners. The absence of a product or service name, slogan, or logo from this list does not constitute a waiver of Oracle's trademark or other intellectual property rights concerning that name, slogan, or logo.

eTRM - OKI Tables and Views

TABLE - OKI.OKI_ADDRESSES
TABLE - OKI.OKI_COV_PRD_LINES
TABLE - OKI.OKI_DAILY_RATES
TABLE - OKI.OKI_EXPIRED_LINES
TABLE - OKI.OKI_EXP_NOT_RENEWED
TABLE - OKI.OKI_FORECAST_BY_ORGS
TABLE - OKI.OKI_K_CONV_RATE
TABLE - OKI.OKI_K_SALESREPS
TABLE - OKI.OKI_PERF_MEASURES
TABLE - OKI.OKI_REFRESHS
TABLE - OKI.OKI_RENEWAL_AGING
TABLE - OKI.OKI_RENEW_BY_STATUSES
TABLE - OKI.OKI_ROLE_MAPS
TABLE - OKI.OKI_RULE_MAPS
TABLE - OKI.OKI_SALES_K_HDRS
TABLE - OKI.OKI_SEQ_GROWTH_RATE
TABLE - OKI.OKI_SOLD_ITM_LINES
TABLE - OKI.OKI_WIP_BY_CUSTOMERS
TABLE - OKI.OKI_YOY_RENEWAL_AMT
VIEW - APPS.OKI_ADDRESSES_V
VIEW - APPS.OKI_BILL_HIST_V
VIEW - APPS.OKI_BILL_TO_ADDRS_V
VIEW - APPS.OKI_CONTACT_POINTS_V
VIEW - APPS.OKI_COV_PROD_LINES_V
VIEW - APPS.OKI_DAILY_RATES_V
VIEW - APPS.OKI_EXPIRED_LINES_V
VIEW - APPS.OKI_EXP_NOT_RENEWED_V
VIEW - APPS.OKI_FORECAST_BY_ORGS_V
VIEW - APPS.OKI_K_CONTACTS_V
VIEW - APPS.OKI_K_PARTIES_V
VIEW - APPS.OKI_K_SALESREP_V
VIEW - APPS.OKI_PERF_MEASURES_V
VIEW - APPS.OKI_RENEWAL_AGING_V
VIEW - APPS.OKI_RENEW_BY_STATUSES_V
VIEW - APPS.OKI_RENEW_RELS_V
VIEW - APPS.OKI_RNW_BY_STS_DTL_V
VIEW - APPS.OKI_ROLE_MAPS_V
VIEW - APPS.OKI_RULE_MAPS_V
VIEW - APPS.OKI_SALES_K_HEADERS_V
VIEW - APPS.OKI_SALES_K_NEW_V
VIEW - APPS.OKI_SALES_K_RENEW_V
VIEW - APPS.OKI_SHIP_TO_ADDRS_V
VIEW - APPS.OKI_SOLD_ITEM_LINES_V
VIEW - APPS.OKI_WIP_BY_CUSTOMERS_V
VIEW - APPS.OKI_YOY_RENEWAL_AMT_V

Table: OKI_ADDRESSES

Description: Contains contract bill-to and ship-to addresses.
Comments

This table stores contract Bill To and Ship To address information. This table is populated by the Load Address, Contracts Intelligence concurrent manager job.

Indexes
Index Type Tablespace Column
OKI_ADDRESSES_N1 NONUNIQUE APPS_TS_TX_IDX CLE_ID
Columns
Name Datatype Length Mandatory Comments
ADDRESS_USE VARCHAR2 (30)
Specifies either a bill-to or ship-to address.
SITE_USE_ID VARCHAR2 (40) Y The internal identifier from HZ_CUST_SITE_USES_ALL
PARTY_SITE_ID NUMBER
Y The internal identifer for the party site referenced by this address.
LOCATION_ID NUMBER
Y The identifier from HZ_LOCATIONS for this location.
RGP_ID NUMBER

The id from OKC_RULE_GROUPS_B for the rule group in which the rule appeared.
RUL_ID NUMBER

The identifier from OKC_RULES_B for the rule that holds this address.
CHR_ID NUMBER
Y The contract header identifier for this address.
CLE_ID NUMBER

The contract line identifier for this address, if at the line level.
CONTRACT_NUMBER VARCHAR2 (120)
The contract number in which this address is used.
CONTRACT_NUMBER_MODIFIER VARCHAR2 (120)
The contract number modifier in which this address is used.
LINE_NUMBER VARCHAR2 (150)
The external contract line number to which the address is associated, if at line level.
NAME VARCHAR2 (40)
The name associated with the address.
COUNTRY VARCHAR2 (60)
The country of the address.
ADDRESS1 VARCHAR2 (240)
The first address line.
ADDRESS2 VARCHAR2 (240)
The second address line.
ADDRESS3 VARCHAR2 (240)
The third address line.
ADDRESS4 VARCHAR2 (240)
The fourth address line.
CITY VARCHAR2 (60)
The address city.
POSTAL_CODE VARCHAR2 (60)
The address postal code.
STATE VARCHAR2 (60)
The address state, if appropriate.
PROVINCE VARCHAR2 (60)
The address province, if appropriate.
COUNTY VARCHAR2 (60)
The address county, if appropriate.
FORMAT_ADDRESS VARCHAR2 (1000)
The address formatted as a string.
SCS_CODE VARCHAR2 (30)
The category (sub-class) code for the contract.
SECURITY_GROUP_ID NUMBER

Used for application hosting.

[top of page]

OKI.OKI_ADDRESSES does not reference any database object

OKI.OKI_ADDRESSES is referenced by following:

APPS
SYNONYM - OKI_ADDRESSES

[top of page]

Table: OKI_COV_PRD_LINES

Description: Information about covered product lines in Contracts for Service.
Primary Key: OKI_COV_PRD_LINES_PK
  1. CLE_ID
Comments

This table holding information about covered product lines in Contracts for Service, and the products covered by those lines. It is maintained by the Load Covered Product Lines, Contracts Intelligence concurrent manager job.

Indexes
Index Type Tablespace Column
OKI_COV_PRD_LINES_U1 UNIQUE APPS_TS_TX_IDX CLE_ID
OKI_COV_PRD_LINES_N1 NONUNIQUE APPS_TS_TX_IDX CHR_ID
OKI_COV_PRD_LINES_N2 NONUNIQUE APPS_TS_TX_IDX CONTRACT_NUMBER
OKI_COV_PRD_LINES_N3 NONUNIQUE APPS_TS_TX_IDX COVERED_PRODUCT_ID
OKI_COV_PRD_LINES_N4 NONUNIQUE APPS_TS_TX_IDX PARENT_CLE_ID
OKI_COV_PRD_LINES_N5 NONUNIQUE APPS_TS_TX_IDX START_DATE
OKI_COV_PRD_LINES_N6 NONUNIQUE APPS_TS_TX_IDX COMPLETE_CONTRACT_NUMBER
OKI_COV_PRD_LINES_N7 NONUNIQUE APPS_TS_TX_IDX SYSTEM_NAME
OKI_COV_PRD_LINES_N8 NONUNIQUE APPS_TS_TX_IDX END_DATE
OKI_COV_PRD_LINES_N9 NONUNIQUE APPS_TS_TX_IDX IS_EXP_NOT_RENEWED_YN
Columns
Name Datatype Length Mandatory Comments
CLE_ID NUMBER
Y Internal contract line identifier.
CHR_ID NUMBER
Y The contract header identifier for the contract in which this line appears.
PARENT_CLE_ID NUMBER

Internal line identifier of the parent top line of the covered product line.
SCS_CODE VARCHAR2 (30)
The category (sub-class) code for the contract.
CONTRACT_NUMBER VARCHAR2 (120)
Contract number for this contract.
CONTRACT_NUMBER_MODIFIER VARCHAR2 (120)
Contract number modifier for this contract.
COMPLETE_CONTRACT_NUMBER VARCHAR2 (241)
Concatenated contract number and modifier.
LINE_NUMBER VARCHAR2 (150)
External line number.
START_DATE DATE

The starting effective date of the line.
END_DATE DATE

The ending effective date of the line.
STS_CODE VARCHAR2 (30)
The code value representing the status type of the line, such as ACTIVE or ENTERED.
TRN_CODE VARCHAR2 (30)
The line termination reason code.
DATE_TERMINATED DATE

Date the line was terminated.
DATE_RENEWED DATE

The date the line was renewed.
NUMBER_OF_ITEMS NUMBER (15)
Number of covered items for the line.
UOM_CODE VARCHAR2 (3)
Unit of measure code for the number of items.
UNIT_PRICE NUMBER

Unit price for the covered product.
UNIT_PRICE_PERCENT NUMBER (6)
Percentage of the covered item price used to price the service, if percentage pricing of service is used.
PRICE_NEGOTIATED NUMBER

The line price as negotiated. The final price of the line.
CURRENCY_CODE VARCHAR2 (15)
The transaction currency code for the line.
PRICE_NEGOTIATED_RENEWED NUMBER

The negotiated price of the line renewed by this line.
CURRENCY_CODE_RENEWED VARCHAR2 (15)
The transaction currency code of the line renewed by this line.
SOB_PRICE_UNIT NUMBER

The unit price converted to the set of books currency.
SOB_PRICE_NEGOTIATED NUMBER

The negotiated price in the set of books currency.
SOB_PRICE_NEGOTIATED_RENEWED NUMBER

The price of the renewed line in the set of books currency.
SOB_CURRENCY_CODE VARCHAR2 (15)
The set of books currency code.
BASE_PRICE_UNIT NUMBER

Unit price for the covered product, in the base currency.
BASE_PRICE_NEGOTIATED NUMBER

The line price as negotiated, in the base currency.
BASE_PRICE_NEGOTIATED_RENEWED NUMBER

The line negotiated price of the line renewed by this line, in the base currency.
BASE_CURRENCY_CODE VARCHAR2 (15)
The currency code of the base currency.
SERVICE_ITEM VARCHAR2 (240)
The description of the service.
COVERED_PRODUCT_ID NUMBER

The internal identifier of the covered product in Install Base.
CUSTOMER_PRODUCT_ITEM_ID NUMBER

The internal identifier of the install base item covered by this line.
COV_PROD_QUANTITY NUMBER

The quantity of the covered product in Install Base.
COV_PROD_UOM VARCHAR2 (25)
The unit of measure of the quantity of the covered product in Install Base.
INSTALLATION_DATE DATE

The date on which the covered product was installed.
COV_PROD_ORDER_DATE DATE

The date of the sales order that shipped the covered product.
COV_PROD_ORDER_NUMBER NUMBER (15)
The order number of the sales order that shipped the covered product.
COV_PROD_ORDER_LINE NUMBER (15)
The line number for this covered product on the sales order.
COV_PROD_NET_AMOUNT NUMBER (28)
The net amount of the purchase/rental of the covered product.
COV_PROD_ORDER_LINE_ID NUMBER

The internal line identifier for this covered product on the sales order.
SYSTEM_ID NUMBER

The internal identifier of the Install Base system referenced by the covered product.
PRODUCT_AGREEMENT_ID NUMBER

The identifier of the sales agreement used when purchasing the product.
COV_PROD_BILL_TO_SITE_ID NUMBER

The covered product (Install Base) bill to address internal identifier
COV_PROD_SHIP_TO_SITE_ID NUMBER

The covered product (Install Base) ship to address internal identifier
COV_PROD_INSTALL_SITE_ID NUMBER

The covered product (Install Base) installed at address internal identifier
COV_PROD_BILL_TO_CONTACT_ID NUMBER (15)
The covered product (Install Base) bill to contact internal identifier
COV_PROD_SHIP_TO_CONTACT_ID NUMBER (15)
The covered product (Install Base) ship to contact internal identifier
AUTHORING_ORG_ID NUMBER

The internal identifier of the operating unit in which the contract was authored.
INVENTORY_ORGANIZATION_ID NUMBER

The internal identifier for the inventory organization.
CREATION_DATE DATE

Standard Who column
LAST_UPDATE_DATE DATE

Standard Who column.
ATTRIBUTE_CATEGORY VARCHAR2 (90)
Descriptive Flexfield structure defining column.
ATTRIBUTE1 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE2 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE3 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE4 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE5 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE6 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE7 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE8 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE9 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE10 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE11 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE12 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE13 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE14 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE15 VARCHAR2 (450)
Descriptive Flexfield segment column.
SECURITY_GROUP_ID NUMBER

Used for application hosting.
DURATION NUMBER

Duration of the line
PERIOD VARCHAR2 (30)
Period code of the duration
STE_CODE VARCHAR2 (30)
Status type code
CONCATENATED_SEGMENTS VARCHAR2 (640)
Item segments
SERIAL_NUMBER VARCHAR2 (30)
Serial number
REFERENCE_NUMBER VARCHAR2 (30)
Reference number
SYSTEM_NAME VARCHAR2 (50)
Install base system name
PRICING_ATTRIBUTE1 VARCHAR2 (30)
Pricing attribute 1
PRICING_ATTRIBUTE2 VARCHAR2 (30)
Pricing attribute 2
PRICING_ATTRIBUTE3 VARCHAR2 (30)
Pricing attribute 3
PRICING_ATTRIBUTE4 VARCHAR2 (30)
Pricing attribute 4
PRICING_ATTRIBUTE5 VARCHAR2 (30)
Pricing attribute 5
PRICING_ATTRIBUTE6 VARCHAR2 (30)
Pricing attribute 6
PRICING_ATTRIBUTE7 VARCHAR2 (30)
Pricing attribute 7
PRICING_ATTRIBUTE8 VARCHAR2 (30)
Pricing attribute 8
PRICING_ATTRIBUTE9 VARCHAR2 (30)
Pricing attribute 9
PRICING_ATTRIBUTE10 VARCHAR2 (30)
Pricing attribute 10
END_PERIOD_NUM NUMBER (15)
The number of the general ledger period in which the line ends.
END_PERIOD_NAME VARCHAR2 (15)
The name of the general ledger period in which the line ends.
END_QUARTER NUMBER (15)
The general legder quarter in qhich the line ends
END_YEAR NUMBER (15)
The general ledger year in which the line ends
IS_EXP_NOT_RENEWED_YN VARCHAR2 (1)
Flag indicating if the line is expired without a renewal

[top of page]

OKI.OKI_COV_PRD_LINES does not reference any database object

OKI.OKI_COV_PRD_LINES is referenced by following:

APPS
SYNONYM - OKI_COV_PRD_LINES

[top of page]

Table: OKI_DAILY_RATES

Description: Holds information about the conversion rates to be used when converting currencies in OKI.
Comments

This table holds the conversion rate data for all the currency combinations for the conversion type specified by the OKI_DEFAULT_CONVERSION_TYPE profile option. This information is used to perform conversions from the transaction currency to the set of books currency and the base currency.
This table is populated from the GL_DAILY_RATES table with the latest conversion rate for that currency combination. This means that there will be only one record for any combination of from currency band to currency.
It is maintained by the Load Daily Rates, Contracts Intelligence concurrent manager job.

Indexes
Index Type Tablespace Column
OKI_DAILY_RATES_N1 NONUNIQUE APPS_TS_TX_IDX FROM_CURRENCY
TO_CURRENCY
CONVERSION_RATE
Columns
Name Datatype Length Mandatory Comments
FROM_CURRENCY VARCHAR2 (15) Y The currency from which one is converting.
TO_CURRENCY VARCHAR2 (15) Y The currency to which one is converting.
CONVERSION_RATE NUMBER
Y The rate to use to convert the currencies.
CONVERSION_DATE DATE
Y The date for the conversion rate.
SECURITY_GROUP_ID NUMBER

Used for application hosting.

[top of page]

OKI.OKI_DAILY_RATES does not reference any database object

OKI.OKI_DAILY_RATES is referenced by following:

APPS
SYNONYM - OKI_DAILY_RATES

[top of page]

Table: OKI_EXPIRED_LINES

Description: Information about contract lines that have expired without renewal.
Primary Key: OKI_EXPIRED_LINES_PK
  1. CLE_ID
Comments

This table holds information about contract lines that have expired without renewal. It is maintained by the Load Expired Lines, Contracts Intelligence concurrent manager job.

Indexes
Index Type Tablespace Column
OKI_EXPIRED_LINES_U1 UNIQUE APPS_TS_TX_IDX CLE_ID
OKI_EXPIRED_LINES_N1 NONUNIQUE APPS_TS_TX_IDX CHR_ID
Columns
Name Datatype Length Mandatory Comments
CLE_ID NUMBER
Y Internal contract line identifier.
CHR_ID NUMBER
Y The contract header identifier for the contract in which this line appears.
CONTRACT_NUMBER VARCHAR2 (120)
Contract number for this contract.
CONTRACT_NUMBER_MODIFIER VARCHAR2 (120)
Contract number modifier for the contract in which this line appears.
COMPLETE_CONTRACT_NUMBER VARCHAR2 (241)
Concatenated contract number and modifier.
SCS_CODE VARCHAR2 (30)
The category (sub-class) code for the contract.
LINE_NUMBER VARCHAR2 (150)
External line number.
START_DATE DATE

The starting effective date of the line.
END_DATE DATE

The ending effective date of the line.
STS_CODE VARCHAR2 (30)
The code value representing the status type of the line, such as ACTIVE or ENTERED.
TRN_CODE VARCHAR2 (30)
The line termination reason code.
DATE_TERMINATED DATE

Date the line was terminated.
DATE_RENEWED DATE

The date the line was renewed.
END_PERIOD_NUM NUMBER (15)
The number of the General Ledger period in which the line ends.
END_PERIOD_NAME VARCHAR2 (15)
The name of the General Ledger period in which the line ends.
END_QUARTER NUMBER (15)
The General Ledger quarter in which the line ends.
END_YEAR NUMBER (15)
The General Ledger year in which the line ends.
UNIT_PRICE NUMBER

Unit price for the line item.
UNIT_PRICE_PERCENT NUMBER (6)
Percentage of the covered item price used to price the service, if percentage pricing of service is used.
PRICE_NEGOTIATED NUMBER

The line price as negotiated. The final price of the line.
CURRENCY_CODE VARCHAR2 (15)
The transaction currency code for the line.
PRICE_NEGOTIATED_RENEWED NUMBER

The negotiated price of the line renewed by this line.
CURRENCY_CODE_RENEWED VARCHAR2 (15)
The transaction currency code of the line renewed by this line.
SOB_PRICE_UNIT NUMBER

The unit price converted to the set of books currency.
SOB_PRICE_NEGOTIATED NUMBER

The negotiated price in the set of books currency.
SOB_PRICE_NEGOTIATED_RENEWED NUMBER

The price of the renewed line in the set of books currency.
SOB_CURRENCY_CODE VARCHAR2 (15)
The set of books currency code.
BASE_PRICE_UNIT NUMBER

Unit price for the line, in the base currency.
BASE_PRICE_NEGOTIATED NUMBER

The line price as negotiated, in the base currency.
BASE_PRICE_NEGOTIATED_RENEWED NUMBER

The line negotiated price of the line renewed by this line, in the base currency.
BASE_CURRENCY_CODE VARCHAR2 (15)
The currency code of the base currency.
AUTHORING_ORG_ID NUMBER

The internal identifier of the operating unit in which the contract was authored.
ORGANIZATION_NAME VARCHAR2 (240)
The name of the operating unit in which the contract was authored.
INVENTORY_ORGANIZATION_ID NUMBER

The internal identifier for the inventory organization.
CREATION_DATE DATE

Standard Who column
LAST_UPDATE_DATE DATE

Standard Who column.
ATTRIBUTE_CATEGORY VARCHAR2 (90)
Descriptive Flexfield structure defining column.
ATTRIBUTE1 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE2 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE3 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE4 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE5 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE6 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE7 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE8 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE9 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE10 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE11 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE12 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE13 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE14 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE15 VARCHAR2 (450)
Descriptive Flexfield segment column.
SECURITY_GROUP_ID NUMBER

Used for application hosting.

[top of page]

OKI.OKI_EXPIRED_LINES does not reference any database object

OKI.OKI_EXPIRED_LINES is referenced by following:

APPS
SYNONYM - OKI_EXPIRED_LINES

[top of page]

Table: OKI_EXP_NOT_RENEWED

Description: Summarized information about contract lines that have expired without being renewed.
Primary Key: OKI_EXP_NOT_RENEWED_PK
  1. ID
Comments

This table holds summarized information about the value and count of contract lines that have expired without being renewed, by several dimensions such as period, operating unit, and customer.

Indexes
Index Type Tablespace Column
OKI_EXP_NOT_RENEWED_U1 UNIQUE APPS_TS_TX_IDX ID
OKI_EXP_NOT_RENEWED_U2 UNIQUE APPS_TS_TX_IDX PERIOD_NAME
PERIOD_SET_NAME
AUTHORING_ORG_ID
CUSTOMER_PARTY_ID
SCS_CODE
CONTACT_ID
Columns
Name Datatype Length Mandatory Comments
ID NUMBER
Y The internal identifier for the row.
PERIOD_NAME VARCHAR2 (15) Y The name from General Ledger for the period of this information.
PERIOD_SET_NAME VARCHAR2 (15) Y The name of the General Ledger period set used to determine valid periods.
PERIOD_TYPE VARCHAR2 (15)
The type of General Ledger period used for this information.
AUTHORING_ORG_ID NUMBER
Y The internal identifier of the operating unit in which the contract was authored.
AUTHORING_ORG_NAME VARCHAR2 (240)
The name of the operating unit in which the contract was authored.
CUSTOMER_PARTY_ID NUMBER
Y The internal party identifier of the contract customer.
CUSTOMER_NAME VARCHAR2 (360)
The name of the customer in the contract.
CONTACT_ID VARCHAR2 (40)
The internal identifier for the contract contact.
SALESREP_NAME VARCHAR2 (240)
The name of the sales representative.
SCS_CODE VARCHAR2 (30)
The category (sub-class) code for the contract.
CONTRACT_COUNT NUMBER

The count of contracts expired and not renewed.
BASE_LOST_AMOUNT NUMBER

The amount lost (not renewed), in the base currency.
REQUEST_ID NUMBER (15)
Concurrent Manager audit column.
PROGRAM_APPLICATION_ID NUMBER (15)
Concurrent Manager audit column.
PROGRAM_ID NUMBER (15)
Concurrent Manager audit column.
PROGRAM_UPDATE_DATE DATE

Concurrent Manager audit column.
SECURITY_GROUP_ID NUMBER

Used for application hosting.

[top of page]

OKI.OKI_EXP_NOT_RENEWED does not reference any database object

OKI.OKI_EXP_NOT_RENEWED is referenced by following:

APPS
SYNONYM - OKI_EXP_NOT_RENEWED

[top of page]

Table: OKI_FORECAST_BY_ORGS

Description: Summarized forecast and booked contract information by operating unit and period.
Primary Key: OKI_FORECAST_BY_ORGS_PK
  1. ID
Comments

This table holds the forecast and booked contract amounts for an organization for any given period.
It is maintained by the Load Forecast By Organizations, Contracts Intelligence concurrent manager job.

Indexes
Index Type Tablespace Column
OKI_FORECAST_BY_ORGS_U1 UNIQUE APPS_TS_TX_IDX PERIOD_NAME
PERIOD_SET_NAME
AUTHORING_ORG_ID
SCS_CODE
OKI_FORECAST_BY_ORGS_U2 UNIQUE APPS_TS_TX_IDX ID
Columns
Name Datatype Length Mandatory Comments
ID NUMBER
Y The internal identifier for the row.
PERIOD_NAME VARCHAR2 (15) Y The name from General Ledger for the period of this information.
PERIOD_SET_NAME VARCHAR2 (15) Y The name of the General Ledger period set used to determine valid periods.
PERIOD_TYPE VARCHAR2 (15)
The type of General Ledger period used for this information.
AUTHORING_ORG_ID NUMBER
Y The internal identifier of the operating unit in which the contract was authored.
AUTHORING_ORG_NAME VARCHAR2 (240)
The name of the operating unit in which the contract was authored.
SCS_CODE VARCHAR2 (30)
The category (sub-class) code for the contract.
BASE_FORECAST_AMOUNT NUMBER

The forecasted amount, in the base currency.
BASE_BOOKED_AMOUNT NUMBER

The sum of booked renewals, in the base currency.
REQUEST_ID NUMBER (15)
Concurrent Manager audit column.
PROGRAM_APPLICATION_ID NUMBER (15)
Concurrent Manager audit column.
PROGRAM_ID NUMBER (15)
Concurrent Manager audit column.
PROGRAM_UPDATE_DATE DATE

Concurrent Manager audit column.
SECURITY_GROUP_ID NUMBER

Used for application hosting.

[top of page]

OKI.OKI_FORECAST_BY_ORGS does not reference any database object

OKI.OKI_FORECAST_BY_ORGS is referenced by following:

APPS
SYNONYM - OKI_FORECAST_BY_ORGS

[top of page]

Table: OKI_K_CONV_RATE

Description:
Primary Key: OKI_K_CONV_RATE_PK
  1. CHR_ID
Comments

This table holds conversion rate data for contracts that have been in an active, terminated, expired, or hold state. The conversion rate data is based on the conversion type specified by the OKI_DEFAULT_CONVERSION_TYPE profile option. The conversion data is stored for the set of books currency and the base currency.
It is maintained by the Load Conversion Rates for Active Contracts, Contracts Intelligence concurrent manager job.

Indexes
Index Type Tablespace Column
OKI_K_CONV_RATE_N1 NONUNIQUE APPS_TS_TX_IDX CHR_ID
BASE_CURRENCY_CONV_RATE
SOB_CURRENCY_CONV_RATE
RENEWED_BASE_CONV_RATE
RENEWED_SOB_CONV_RATE
Columns
Name Datatype Length Mandatory Comments
CHR_ID NUMBER
Y The internal identifier for the contract
BASE_CURRENCY_CONV_RATE NUMBER

Conversion rate from the transactional currency to the base currency
SOB_CURRENCY_CONV_RATE NUMBER

Set of books conversion rate
RENEWED_BASE_CONV_RATE NUMBER

Renewed base conversion rate
RENEWED_SOB_CONV_RATE NUMBER

Renewed set of books conversion rate
CREATION_DATE DATE

Standard Who column
LAST_UPDATE_DATE DATE

Standard Who column.
REQUEST_ID NUMBER (15)
Concurrent Manager audit column.
PROGRAM_APPLICATION_ID NUMBER (15)
Concurrent Manager audit column.
PROGRAM_ID NUMBER (15)
Concurrent Manager audit column.
PROGRAM_UPDATE_DATE DATE

Concurrent Manager audit column.
SECURITY_GROUP_ID NUMBER

Used for application hosting.
T VARCHAR2 (240)
T column

[top of page]

OKI.OKI_K_CONV_RATE does not reference any database object

OKI.OKI_K_CONV_RATE is referenced by following:

APPS
SYNONYM - OKI_K_CONV_RATE

[top of page]

Table: OKI_K_SALESREPS

Description: Holds the salesreps for contracts.
Primary Key: OKI_K_SALESREPS_PK
  1. PARTY_CONTACT_ID
Comments

This table holds the salesreps for contracts.
It is maintained by the Load Contract Salesreps, Contracts Intelligence concurrent manager job.

Indexes
Index Type Tablespace Column
OKI_K_SALESREPS_U1 UNIQUE APPS_TS_TX_IDX PARTY_CONTACT_ID
OKI_K_SALESREPS_N1 NONUNIQUE APPS_TS_TX_IDX CONTRACT_ID
OKI_K_SALESREPS_N2 NONUNIQUE APPS_TS_TX_IDX SALESREP_NAME
OKI_K_SALESREPS_N3 NONUNIQUE APPS_TS_TX_IDX PARTY_ROLE_ID
Columns
Name Datatype Length Mandatory Comments
PARTY_CONTACT_ID NUMBER
Y The internal identifier for the contact.
CONTRACT_ID NUMBER
Y The internal identifier of the contract.
PARTY_ROLE_ID NUMBER

The internal identifier for this party in this role in this contract.
CONTACT_ROLE_CODE VARCHAR2 (30)
The code for the role the contact plays in the contract.
CONTACT_ID VARCHAR2 (40)
The internal identifier for the contract contact.
SALESREP_NAME VARCHAR2 (240)
The name of the sales representative.
CREATION_DATE DATE

Standard Who column
LAST_UPDATE_DATE DATE

Standard Who column.
ATTRIBUTE_CATEGORY VARCHAR2 (90)
Descriptive Flexfield structure defining column.
ATTRIBUTE1 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE2 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE3 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE4 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE5 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE6 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE7 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE8 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE9 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE10 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE11 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE12 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE13 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE14 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE15 VARCHAR2 (450)
Descriptive Flexfield segment column.
SECURITY_GROUP_ID NUMBER

Used for application hosting.

[top of page]

OKI.OKI_K_SALESREPS does not reference any database object

OKI.OKI_K_SALESREPS is referenced by following:

APPS
SYNONYM - OKI_K_SALESREPS

[top of page]

Table: OKI_PERF_MEASURES

Description: Holds the values for the Key Performance Indicators.
Primary Key: OKI_PERF_MEASURES_PK
  1. ID
Comments

This table holds the data for Key Performance Indicator values for any given period.
It is maintained by the Load Performance Measures, Contracts Intelligence concurrent manager job.

Indexes
Index Type Tablespace Column
OKI_PERF_MEASURES_U1 UNIQUE APPS_TS_TX_IDX PERIOD_NAME
PERIOD_SET_NAME
AUTHORING_ORG_ID
KPI_CODE
SCS_CODE
OKI_PERF_MEASURES_U2 UNIQUE APPS_TS_TX_IDX ID
Columns
Name Datatype Length Mandatory Comments
ID NUMBER
Y The internal identifier for the row.
PERIOD_NAME VARCHAR2 (15) Y The name from General Ledger for the period of this information.
PERIOD_SET_NAME VARCHAR2 (15) Y The name of the General Ledger period set used to determine valid periods.
PERIOD_TYPE VARCHAR2 (15)
The type of General Ledger period used for this information.
AUTHORING_ORG_ID NUMBER

The internal identifier of the operating unit in which the contract was authored.
AUTHORING_ORG_NAME VARCHAR2 (240)
The name of the operating unit in which the contract was authored.
KPI_CODE VARCHAR2 (30) Y A code specifying the Key Performance Indicator.
KPI_VALUE NUMBER

The value of the Key Performance Indicator.
SCS_CODE VARCHAR2 (30)
The category (sub-class) code for the contract.
REQUEST_ID NUMBER (15)
Concurrent Manager audit column.
PROGRAM_APPLICATION_ID NUMBER (15)
Concurrent Manager audit column.
PROGRAM_ID NUMBER (15)
Concurrent Manager audit column.
PROGRAM_UPDATE_DATE DATE

Concurrent Manager audit column.
SECURITY_GROUP_ID NUMBER

Used for application hosting.

[top of page]

OKI.OKI_PERF_MEASURES does not reference any database object

OKI.OKI_PERF_MEASURES is referenced by following:

APPS
SYNONYM - OKI_PERF_MEASURES

[top of page]

Table: OKI_REFRESHS

Description: Information about the latest refresh of a summary table.
Comments

This table holds the data about the the latest run of a concurrent manager program which refreshed a table in OKI.
There will be only one row for each table.

Columns
Name Datatype Length Mandatory Comments
OBJECT_NAME VARCHAR2 (60) Y The name of the refreshed object.
MV_YN VARCHAR2 (1) Y Whether or not the refreshed object is a materialized view.
REQUEST_ID NUMBER (15)
Concurrent Manager audit column.
PROGRAM_APPLICATION_ID NUMBER (15)
Concurrent Manager audit column.
PROGRAM_ID NUMBER (15)
Concurrent Manager audit column.
PROGRAM_UPDATE_DATE DATE

Concurrent Manager audit column.
OBJECT_VERSION_NUMBER NUMBER (9) Y A number used to track the version of the row.
CREATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column.
LAST_UPDATE_DATE DATE
Y Standard Who column.
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column.
SECURITY_GROUP_ID NUMBER

Used for application hosting.
JOB_RUN_ID NUMBER

Job run id of the last incremental refresh

[top of page]

OKI.OKI_REFRESHS does not reference any database object

OKI.OKI_REFRESHS is referenced by following:

APPS
PACKAGE - OKI_LOAD_ENR_PVT
PACKAGE - OKI_LOAD_ETR_PVT
PACKAGE - OKI_LOAD_FBO_PVT
PACKAGE - OKI_LOAD_OKV_PVT
PACKAGE - OKI_LOAD_RAG_PVT
PACKAGE - OKI_LOAD_RBK_PVT
PACKAGE - OKI_LOAD_RBS_PVT
PACKAGE - OKI_LOAD_SGR_PVT
PACKAGE - OKI_LOAD_TNK_PVT
PACKAGE - OKI_LOAD_WBC_PVT
PACKAGE - OKI_LOAD_YRA_PVT
SYNONYM - OKI_REFRESHS
PACKAGE - OKI_REFRESH_PVT

[top of page]

Table: OKI_RENEWAL_AGING

Description: Holds the values for the aging of renewals by time period.
Primary Key: OKI_RENEWAL_AGING_PK
  1. ID
Comments

Holds the summary information about the aging of renewals, by period, operating unit, and customer.

Indexes
Index Type Tablespace Column
OKI_RENEWAL_AGING_U1 UNIQUE APPS_TS_TX_IDX ID
OKI_RENEWAL_AGING_U2 UNIQUE APPS_TS_TX_IDX PERIOD_NAME
PERIOD_SET_NAME
AUTHORING_ORG_ID
CUSTOMER_PARTY_ID
SCS_CODE
Columns
Name Datatype Length Mandatory Comments
ID NUMBER
Y The internal identifier for the row.
PERIOD_NAME VARCHAR2 (15) Y The name from General Ledger for the period of this information.
PERIOD_SET_NAME VARCHAR2 (15) Y The name of the General Ledger period set used to determine valid periods.
PERIOD_TYPE VARCHAR2 (15)
The type of General Ledger period used for this information.
AUTHORING_ORG_ID NUMBER
Y The internal identifier of the operating unit in which the contract was authored.
AUTHORING_ORG_NAME VARCHAR2 (240)
The name of the operating unit in which the contract was authored.
CUSTOMER_PARTY_ID NUMBER
Y The internal party identifier of the contract customer.
CUSTOMER_NAME VARCHAR2 (360)
The name of the customer in the contract.
SCS_CODE VARCHAR2 (30)
The category (sub-class) code for the contract.
AGE_GROUP1 NUMBER

The first renewal aging bucket, holds the value of contracts in that bucket.
AGE_GROUP2 NUMBER

The second renewal aging bucket, holds the value of contracts in that bucket.
AGE_GROUP3 NUMBER

The third renewal aging bucket, holds the value of contracts in that bucket.
AGE_GROUP4 NUMBER

The fourth renewal aging bucket, holds the value of contracts in that bucket.
REQUEST_ID NUMBER (15)
Concurrent Manager audit column.
PROGRAM_APPLICATION_ID NUMBER (15)
Concurrent Manager audit column.
PROGRAM_ID NUMBER (15)
Concurrent Manager audit column.
PROGRAM_UPDATE_DATE DATE

Concurrent Manager audit column.
SECURITY_GROUP_ID NUMBER

Used for application hosting.

[top of page]

OKI.OKI_RENEWAL_AGING does not reference any database object

OKI.OKI_RENEWAL_AGING is referenced by following:

APPS
SYNONYM - OKI_RENEWAL_AGING

[top of page]

Table: OKI_RENEW_BY_STATUSES

Description: Holds information about renewal contracts by contract status.
Primary Key: OKI_RENEW_BY_STATUS_PK
  1. ID
Comments

Holds summarized data regarding renewal contracts, organized by status. It is maintained by the Load Renew By Statuses, Contracts Intelligence concurrent manager job.

Indexes
Index Type Tablespace Column
OKI_RENEW_BY_STATUSES_U1 UNIQUE APPS_TS_TX_IDX PERIOD_NAME
PERIOD_SET_NAME
AUTHORING_ORG_ID
STATUS_CODE
SCS_CODE
OKI_RENEW_BY_STATUSES_U2 UNIQUE APPS_TS_TX_IDX ID
Columns
Name Datatype Length Mandatory Comments
ID NUMBER
Y The internal identifier for the row.
PERIOD_NAME VARCHAR2 (15) Y The name from General Ledger for the period of this information.
PERIOD_SET_NAME VARCHAR2 (15) Y The name of the General Ledger period set used to determine valid periods.
PERIOD_TYPE VARCHAR2 (15)
The type of General Ledger period used for this information.
AUTHORING_ORG_ID NUMBER

The internal identifier of the operating unit in which the contract was authored.
AUTHORING_ORG_NAME VARCHAR2 (240)
The name of the operating unit in which the contract was authored.
STATUS_CODE VARCHAR2 (30) Y The code value representing the status of the contract.
SCS_CODE VARCHAR2 (30)
The category (sub-class) code for the contract.
BASE_AMOUNT NUMBER

The sum of renewals in this status, in the base currency.
CONTRACT_COUNT NUMBER

The count of renewals in this status.
REQUEST_ID NUMBER (15)
Concurrent Manager audit column.
PROGRAM_APPLICATION_ID NUMBER (15)
Concurrent Manager audit column.
PROGRAM_ID NUMBER (15)
Concurrent Manager audit column.
PROGRAM_UPDATE_DATE DATE

Concurrent Manager audit column.
SECURITY_GROUP_ID NUMBER

Used for application hosting.

[top of page]

OKI.OKI_RENEW_BY_STATUSES does not reference any database object

OKI.OKI_RENEW_BY_STATUSES is referenced by following:

APPS
SYNONYM - OKI_RENEW_BY_STATUSES

[top of page]

Table: OKI_ROLE_MAPS

Description: Used to map contract and contact roles to specific reporting values.
Primary Key: OKI_ROLE_MAPS_PK
  1. ROLE_USE
  2. SCS_CODE
Comments

ROLE MAP maps a party role or contact role for a category (sub class) to a known role type for reporting purposes. For example, in order to report on the top contract customers, it is necessary to know which party role is considered the customer. This role code will vary across contract categories. Similarly, in order to identify the sales rep in a contract we must first know which party is considered the vendor and then which contact role represents the sales rep.

Indexes
Index Type Tablespace Column
OKI_ROLE_MAPS_U1 UNIQUE APPS_TS_SEED ROLE_USE
SCS_CODE
Columns
Name Datatype Length Mandatory Comments
ROLE_USE VARCHAR2 (10) Y The role use, such as CUSTOMER.
SCS_CODE VARCHAR2 (30) Y The category (sub-class) code for the contract.
RLE_CODE VARCHAR2 (30)
The role code.
CRO_CODE VARCHAR2 (30)
The contact role code.
OBJECT_VERSION_NUMBER NUMBER (9) Y A number used to track the version of the row.
CREATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column.
LAST_UPDATE_DATE DATE
Y Standard Who column.
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column.
SECURITY_GROUP_ID NUMBER

Used for application hosting.

[top of page]

OKI.OKI_ROLE_MAPS does not reference any database object

OKI.OKI_ROLE_MAPS is referenced by following:

APPS
SYNONYM - OKI_ROLE_MAPS

[top of page]

Table: OKI_RULE_MAPS

Description: Used to map rules and rule groups to specific uses for reporting purposes.
Primary Key: OKI_RULE_MAPS_PK
  1. RULE_USE
  2. SCS_CODE
Comments

RULE MAP maps a rule group/rule pair, within a subclass (category) to a specific reporting use.
In general, rule types are shared across contract subclasses, but not always. Rule groups are not always shared. To use the same rule across subclasses it is necessary to know where to find it. When looking for the revenue forecast rule, for example, RULE MAP will supply the correct rule group and rule for each subclass.

Indexes
Index Type Tablespace Column
OKI_RULE_MAPS_U1 UNIQUE APPS_TS_SEED RULE_USE
SCS_CODE
Columns
Name Datatype Length Mandatory Comments
RULE_USE VARCHAR2 (10) Y The use of the rule, such as BILLING or SHIPPING.
SCS_CODE VARCHAR2 (30) Y The category (sub-class) code for the contract.
RGD_CODE VARCHAR2 (30) Y The rule group code.
RDF_CODE VARCHAR2 (30) Y The address province, if appropriate.
OBJECT_VERSION_NUMBER NUMBER (9) Y A number used to track the version of the row.
CREATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column.
LAST_UPDATE_DATE DATE
Y Standard Who column.
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column.
SECURITY_GROUP_ID NUMBER

Used for application hosting.

[top of page]

OKI.OKI_RULE_MAPS does not reference any database object

OKI.OKI_RULE_MAPS is referenced by following:

APPS
SYNONYM - OKI_RULE_MAPS

[top of page]

Table: OKI_SALES_K_HDRS

Description: Information about contracts of the sell intent.
Primary Key: OKI_SALES_K_HDRS_PK
  1. CHR_ID
Comments

Denormalized table for contract headers and related information for contracts of the sell intent. It is maintained by the Load Sales Contract Headers, Contracts Intelligence concurrent manager job. In order to appear in this table, the contract must be of the sell intent and not be a template. Some currency conversion is done when adding a contract to this table, including converting the contract currency to a base currency in order to speed up display in the HTML bins. If no conversion is specified from the contract currency to the base currency, as defined by the profile option OKI_BASE_CURRENCY_CODE, the contract will not appear in this table.

Indexes
Index Type Tablespace Column
OKI_SALES_K_HDRS_U1 UNIQUE APPS_TS_TX_IDX CHR_ID
OKI_SALES_K_HDRS_U2 UNIQUE APPS_TS_TX_IDX CONTRACT_NUMBER
CONTRACT_NUMBER_MODIFIER
OKI_SALES_K_HDRS_N1 NONUNIQUE APPS_TS_TX_IDX IS_NEW_YN
OKI_SALES_K_HDRS_N10 NONUNIQUE APPS_TS_TX_IDX CUSTOMER_NAME
OKI_SALES_K_HDRS_N11 NONUNIQUE APPS_TS_TX_IDX COMPLETE_CONTRACT_NUMBER
OKI_SALES_K_HDRS_N2 NONUNIQUE APPS_TS_TX_IDX CLOSE_DATE
OKI_SALES_K_HDRS_N3 NONUNIQUE APPS_TS_TX_IDX END_DATE
OKI_SALES_K_HDRS_N4 NONUNIQUE APPS_TS_TX_IDX CUSTOMER_PARTY_ID
OKI_SALES_K_HDRS_N5 NONUNIQUE APPS_TS_TX_IDX DATE_CANCELED
OKI_SALES_K_HDRS_N6 NONUNIQUE APPS_TS_TX_IDX START_DATE
OKI_SALES_K_HDRS_N7 NONUNIQUE APPS_TS_TX_IDX DATE_TERMINATED
OKI_SALES_K_HDRS_N8 NONUNIQUE APPS_TS_TX_IDX AUTHORING_ORG_ID
OKI_SALES_K_HDRS_N9 NONUNIQUE APPS_TS_TX_IDX DATE_APPROVED
Columns
Name Datatype Length Mandatory Comments
CHR_ID NUMBER
Y The internal contract header identifier.
CONTRACT_NUMBER VARCHAR2 (120)
Contract number for this contract.
CONTRACT_NUMBER_MODIFIER VARCHAR2 (120)
Contract number modifier for this contract.
COMPLETE_CONTRACT_NUMBER VARCHAR2 (241)
Concatenated contract number and modifier.
AUTHORING_ORG_ID NUMBER

The internal identifier of the operating unit in which the contract was authored.
ORGANIZATION_NAME VARCHAR2 (240)
The name of the operating unit in which the contract was authored.
SCS_CODE VARCHAR2 (30)
The category (sub-class) code for the contract.
STS_CODE VARCHAR2 (30)
The code value representing the status type of the contract, such as ACTIVE or ENTERED.
STE_CODE VARCHAR2 (30)
The code value representing the status type of the contract, such as ACTIVE or ENTERED.
CUSTOMER_PARTY_ID NUMBER

The internal party identifier of the contract customer.
CUSTOMER_NAME VARCHAR2 (360)
The name of the customer in the contract.
CONTRACT_AMOUNT NUMBER

The total amount of the contract, in the contract transaction currency.
CURRENCY_CODE VARCHAR2 (15)
The currency code of the contract transaction currency.
CONTRACT_AMOUNT_RENEWED NUMBER

The amount of the contract renewed by this contract, in the transaction currency.
CURRENCY_CODE_RENEWED VARCHAR2 (15)
The transaction currency code of the contract renewed by this contract.
WIN_PERCENT NUMBER

The estimated percentage probability that the contract will be signed.
FORECAST_AMOUNT NUMBER

The forecasted value of the contract.
SOB_ID NUMBER

The internal identifier for the set of books.
SOB_CONTRACT_AMOUNT NUMBER

The amount of the contract, converted into the set of books currency.
SOB_FORECAST_AMOUNT NUMBER

The forecasted amount of this contract, converted into the set of books currency.
SOB_CONTRACT_AMOUNT_RENEWED NUMBER

The amount of the contract renewed by this contract, converted into the set of books currency.
SOB_CURRENCY_CODE VARCHAR2 (15)
The set of books currency code.
BASE_CONTRACT_AMOUNT NUMBER

The value of the contract, in the base currency.
BASE_FORECAST_AMOUNT NUMBER

The forecasted amount for the contract, in the base currency.
BASE_CONTRACT_AMOUNT_RENEWED NUMBER

The amount of the contract renewed by this contract, in the base currency.
BASE_CURRENCY_CODE VARCHAR2 (15)
The currency code of the base currency.
CLOSE_DATE DATE

The expected renewal close date.
START_DATE DATE

The starting effective date of the contract.
END_DATE DATE

The ending effective date of the contract.
DATE_APPROVED DATE

The date the contract was approved.
DATE_SIGNED DATE

The date the contract was signed.
DATE_RENEWED DATE

The date the contract was renewed.
DATE_CANCELED DATE

The date the contract was canceled.
DATE_TERMINATED DATE

The date the contract was terminated.
START_PERIOD_NUM NUMBER (15)
The number of the General Ledger period in which the contract starts.
START_PERIOD_NAME VARCHAR2 (15)
The name of the General Ledger period in which the contract starts.
START_QUARTER NUMBER (15)
The General Ledger quarter in which the contract starts.
START_YEAR NUMBER (15)
The General Ledger year in which the contract starts.
CLOSE_PERIOD_NUM NUMBER (15)
The General Ledger period nunber in which the contract is expected to close.
CLOSE_PERIOD_NAME VARCHAR2 (15)
The General Ledger period name in which the contract is expected to close.
CLOSE_QUARTER NUMBER (15)
The General Ledger quarter in which the contract is expected to close.
CLOSE_YEAR NUMBER (15)
The General Ledger year in which the contract is expected to close.
TRN_CODE VARCHAR2 (30)
The contract termination reason code.
INVENTORY_ORGANIZATION_ID NUMBER

The internal identifier for the inventory organization.
IS_NEW_YN VARCHAR2 (240)
Indicates if this is a new or renewed contract, where a Y means it is a new contract.
IS_LATEST_YN VARCHAR2 (1)
Indicates if this is the latest renewal for a contract, where 'N' means it is not.
MAJOR_VERSION NUMBER

The major version of the contract header
MINOR_VERSION NUMBER

The minor version of the contract header
APPLICATION_ID NUMBER

The internal identifier of the Oracle Application that created the contract.
CREATION_DATE DATE

Standard Who column
LAST_UPDATE_DATE DATE

Standard Who column.
ATTRIBUTE_CATEGORY VARCHAR2 (90)
Descriptive Flexfield structure defining column.
ATTRIBUTE1 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE2 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE3 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE4 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE5 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE6 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE7 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE8 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE9 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE10 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE11 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE12 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE13 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE14 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE15 VARCHAR2 (450)
Descriptive Flexfield segment column.
SECURITY_GROUP_ID NUMBER

Used for application hosting.
ORDER_NUMBER VARCHAR2 (22)
Order number
CUSTOMER_NUMBER VARCHAR2 (30)
Customer number
DURATION NUMBER

Duration of the contract
PERIOD VARCHAR2 (30)
Period code of the duration
TERMINATED_AMOUNT NUMBER

Terminated amount
SOB_TERMINATED_AMOUNT NUMBER

erminated amount in functional currency
BASE_TERMINATED_AMOUNT NUMBER

Terminated amount in base currency
ORIG_SYSTEM_SOURCE_CODE VARCHAR2 (30)
Original system source code
ORIG_SYSTEM_ID1 NUMBER

Original system id1
ORIG_SYSTEM_REFERENCE1 VARCHAR2 (30)
Original system reference1
CONTRACT_TYPE VARCHAR2 (30)
Contract type
ACCT_RULE_ID NUMBER

Accounting rule ID
INV_RULE_ID NUMBER (15)
Invoicing rule ID
GRACE_DURATION NUMBER

Duration for which the contract line will be kept active even after the end date.
GRACE_PERIOD_CODE VARCHAR2 (30)
Period for which the contract line will be kept active even after the line end date
AGREEMENT_ID NUMBER

Agreement ID
LIST_HEADER_ID NUMBER

Price list ID
PAYMENT_TERM_ID NUMBER (15)
Payment term ID
QUOTE_TO_CONTACT_ID NUMBER

Quote to contact ID
QUOTE_TO_SITE_ID NUMBER

Quote to sIte ID
QUOTE_TO_EMAIL_ID NUMBER

Quote to email ID
QUOTE_TO_PHONE_ID NUMBER

Quote to phone ID
QUOTE_TO_FAX_ID NUMBER

Quote to fax ID
RENEWAL_TYPE_USED VARCHAR2 (10)
Renewal Type Used

[top of page]

OKI.OKI_SALES_K_HDRS does not reference any database object

OKI.OKI_SALES_K_HDRS is referenced by following:

APPS
SYNONYM - OKI_SALES_K_HDRS

[top of page]

Table: OKI_SEQ_GROWTH_RATE

Description:
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes
Index Type Tablespace Column
OKI_SEQ_GROWTH_RATE_U1 UNIQUE APPS_TS_TX_IDX PERIOD_NAME
PERIOD_SET_NAME
PERIOD_TYPE
SUMMARY_BUILD_DATE
AUTHORING_ORG_ID
SEQ_GRW_RATE_CODE
SCS_CODE
CUSTOMER_PARTY_ID
PRODUCT_CATEGORY_CODE
Columns
Name Datatype Length Mandatory Comments
PERIOD_NAME VARCHAR2 (15) Y
PERIOD_SET_NAME VARCHAR2 (15) Y
PERIOD_TYPE VARCHAR2 (15) Y
SUMMARY_BUILD_DATE DATE

AUTHORING_ORG_ID NUMBER
Y
AUTHORING_ORG_NAME VARCHAR2 (240)
CUSTOMER_PARTY_ID NUMBER
Y The internal party identifier of the contract customer.
CUSTOMER_NAME VARCHAR2 (360) Y
SEQ_GRW_RATE_CODE VARCHAR2 (240)
SCS_CODE VARCHAR2 (30)
PRODUCT_CATEGORY_CODE VARCHAR2 (30)
CURR_BASE_CONTRACT_AMOUNT NUMBER

PREV_BASE_CONTRACT_AMOUNT NUMBER

CURR_SOB_CONTRACT_AMOUNT NUMBER

PREV_SOB_CONTRACT_AMOUNT NUMBER

REQUEST_ID NUMBER (15)
PROGRAM_APPLICATION_ID NUMBER (15)
PROGRAM_ID NUMBER (15)
PROGRAM_UPDATE_DATE DATE

SECURITY_GROUP_ID VARCHAR2 (240)
Used for application hosting.

[top of page]

OKI.OKI_SEQ_GROWTH_RATE does not reference any database object

OKI.OKI_SEQ_GROWTH_RATE is referenced by following:

APPS
SYNONYM - OKI_SEQ_GROWTH_RATE

[top of page]

Table: OKI_SOLD_ITM_LINES

Description: Holds information about top lines in a contract of the sell intent.
Primary Key: OKI_SOLD_ITM_LINES_PK
  1. CLE_ID
Comments

A denormalized table holding information about the top lines in a sales contract. It is maintained by the Load Sold Item Lines, Contracts Intelligence concurrent manager job.

Indexes
Index Type Tablespace Column
OKI_SOLD_ITM_LINES_U1 UNIQUE APPS_TS_TX_IDX CLE_ID
OKI_SOLD_ITM_LINES_N1 NONUNIQUE APPS_TS_TX_IDX CHR_ID
OKI_SOLD_ITM_LINES_N2 NONUNIQUE APPS_TS_TX_IDX CONTRACT_NUMBER
OKI_SOLD_ITM_LINES_N3 NONUNIQUE APPS_TS_TX_IDX COMPLETE_CONTRACT_NUMBER
OKI_SOLD_ITM_LINES_N4 NONUNIQUE APPS_TS_TX_IDX ITEM_ID
INVENTORY_ORGANIZATION_ID
Columns
Name Datatype Length Mandatory Comments
CLE_ID NUMBER
Y Internal contract line identifier.
CHR_ID NUMBER
Y The contract header identifier for the contract in which this line appears.
CONTRACT_NUMBER VARCHAR2 (120)
Contract number for the contract in which this line appears.
CONTRACT_NUMBER_MODIFIER VARCHAR2 (120)
Contract number modifier for the contract in which this line appears.
COMPLETE_CONTRACT_NUMBER VARCHAR2 (241)
Concatenated contract number and modifier.
SCS_CODE VARCHAR2 (30)
The category (sub-class) code for the contract.
LINE_NUMBER VARCHAR2 (150)
External line number.
START_DATE DATE

The starting effective date of the line.
END_DATE DATE

The ending effective date of the line.
STS_CODE VARCHAR2 (30)
The code value representing the status type of the line, such as ACTIVE or ENTERED.
TRN_CODE VARCHAR2 (30)
The line termination reason code.
DATE_TERMINATED DATE

Date the line was terminated.
DATE_RENEWED DATE

The date the line was renewed.
NUMBER_OF_ITEMS NUMBER (15)
Number of covered items for the line.
UOM_CODE VARCHAR2 (3)
Unit of measure code for the number of items.
UNIT_PRICE NUMBER

Unit price for the sold item.
UNIT_PRICE_PERCENT NUMBER (6)
Percentage of the covered item price used to price the service, if percentage pricing of service is used.
PRICE_NEGOTIATED NUMBER

The line price as negotiated. The final price of the line.
CURRENCY_CODE VARCHAR2 (15)
The transaction currency code for the line.
PRICE_NEGOTIATED_RENEWED NUMBER

The negotiated price of the line renewed by this line.
CURRENCY_CODE_RENEWED VARCHAR2 (15)
The transaction currency code of the line renewed by this line.
SOB_PRICE_UNIT NUMBER

The unit price converted to the set of books currency.
SOB_PRICE_NEGOTIATED NUMBER

The negotiated price in the set of books currency.
SOB_PRICE_NEGOTIATED_RENEWED NUMBER

The price of the renewed line in the set of books currency.
SOB_CURRENCY_CODE VARCHAR2 (15)
The set of books currency code.
BASE_PRICE_UNIT NUMBER

Unit price for the line, in the base currency.
BASE_PRICE_NEGOTIATED NUMBER

The line price as negotiated, in the base currency.
BASE_PRICE_NEGOTIATED_RENEWED NUMBER

The line negotiated price of the line renewed by this line, in the base currency.
BASE_CURRENCY_CODE VARCHAR2 (15)
The currency code of the base currency.
SOLD_ITEM VARCHAR2 (240)
The description of the sold item.
ITEM_ID NUMBER

The item identifier from the item master for the sold item.
AUTHORING_ORG_ID NUMBER

The internal identifier of the operating unit in which the contract was authored.
INVENTORY_ORGANIZATION_ID NUMBER

The internal identifier for the inventory organization.
CREATION_DATE DATE

Standard Who column
LAST_UPDATE_DATE DATE

Standard Who column.
ATTRIBUTE_CATEGORY VARCHAR2 (90)
Descriptive Flexfield structure defining column.
ATTRIBUTE1 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE2 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE3 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE4 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE5 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE6 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE7 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE8 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE9 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE10 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE11 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE12 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE13 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE14 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE15 VARCHAR2 (450)
Descriptive Flexfield segment column.
SECURITY_GROUP_ID NUMBER

Used for application hosting.
DURATION NUMBER

Duration of the line
PERIOD VARCHAR2 (30)
Period code for the duration
STE_CODE VARCHAR2 (30)
Status type code
CONCATENATED_SEGMENTS VARCHAR2 (240)
Item segments
BILL_TO_SITE_USE_ID NUMBER (15)
The bill to address ID
SHIP_TO_SITE_USE_ID NUMBER (15)
The ship to address ID

[top of page]

OKI.OKI_SOLD_ITM_LINES does not reference any database object

OKI.OKI_SOLD_ITM_LINES is referenced by following:

APPS
SYNONYM - OKI_SOLD_ITM_LINES

[top of page]

Table: OKI_WIP_BY_CUSTOMERS

Description: Holds information about renewals by customer for a given period.
Primary Key: OKI_WIP_BY_CUSTOMERS_PK
  1. ID
Comments

This table holds the forecast, booked contract and lost amounts for a customer for any given period. It is maintained by the Load WIP By Customers, Contracts Intelligence concurrent manager job.

Indexes
Index Type Tablespace Column
OKI_WIP_BY_CUSTOMERS_U1 UNIQUE APPS_TS_TX_IDX PERIOD_NAME
PERIOD_SET_NAME
CUSTOMER_PARTY_ID
AUTHORING_ORG_ID
SCS_CODE
OKI_WIP_BY_CUSTOMERS_U2 UNIQUE APPS_TS_TX_IDX ID
Columns
Name Datatype Length Mandatory Comments
ID NUMBER
Y The internal identifier for the row.
PERIOD_NAME VARCHAR2 (15) Y The name from General Ledger for the period of this information.
PERIOD_SET_NAME VARCHAR2 (15) Y The name of the General Ledger period set used to determine valid periods.
PERIOD_TYPE VARCHAR2 (15)
The type of General Ledger period used for this information.
AUTHORING_ORG_ID NUMBER

The internal identifier of the operating unit in which the contract was authored.
AUTHORING_ORG_NAME VARCHAR2 (240)
The name of the operating unit in which the contract was authored.
CUSTOMER_PARTY_ID NUMBER
Y The internal party identifier of the contract customer.
CUSTOMER_NAME VARCHAR2 (360)
The name of the customer in the contract.
SCS_CODE VARCHAR2 (30)
The category (sub-class) code for the contract.
BASE_FORECAST_AMOUNT NUMBER

The forecasted amount, in the base currency.
BASE_BOOKED_AMOUNT NUMBER

The sum of booked renewals, in the base currency.
BASE_LOST_AMOUNT NUMBER

The amount lost (not renewed), in the base currency.
REQUEST_ID NUMBER (15)
Concurrent Manager audit column.
PROGRAM_APPLICATION_ID NUMBER (15)
Concurrent Manager audit column.
PROGRAM_ID NUMBER (15)
Concurrent Manager audit column.
PROGRAM_UPDATE_DATE DATE

Concurrent Manager audit column.
SECURITY_GROUP_ID NUMBER

Used for application hosting.

[top of page]

OKI.OKI_WIP_BY_CUSTOMERS does not reference any database object

OKI.OKI_WIP_BY_CUSTOMERS is referenced by following:

APPS
SYNONYM - OKI_WIP_BY_CUSTOMERS

[top of page]

Table: OKI_YOY_RENEWAL_AMT

Description: Holds information about the value of renewed contracts on a historical basis.
Primary Key: OKI_YOY_RENEWAL_AMT_PK
  1. ID
Comments

Holds information about the value of renewed contracts on a historical basis.

Indexes
Index Type Tablespace Column
OKI_YOY_RENEWAL_AMT_U1 UNIQUE APPS_TS_TX_IDX ID
OKI_YOY_RENEWAL_AMT_U2 UNIQUE APPS_TS_TX_IDX PERIOD_NAME
PERIOD_SET_NAME
AUTHORING_ORG_ID
SCS_CODE
MONTH
YEAR
Columns
Name Datatype Length Mandatory Comments
ID NUMBER
Y The internal identifier for the row.
PERIOD_NAME VARCHAR2 (15) Y The name from General Ledger for the period of this information.
PERIOD_SET_NAME VARCHAR2 (15) Y The name of the General Ledger period set used to determine valid periods.
PERIOD_TYPE VARCHAR2 (15)
The type of General Ledger period used for this information.
AUTHORING_ORG_ID NUMBER
Y The internal identifier of the operating unit in which the contract was authored.
AUTHORING_ORG_NAME VARCHAR2 (240)
The name of the operating unit in which the contract was authored.
YEAR VARCHAR2 (4) Y The year of the summarization.
MONTH VARCHAR2 (30) Y The month value for the summation.
SCS_CODE VARCHAR2 (30)
The category (sub-class) code for the contract.
BASE_CONTRACT_AMOUNT NUMBER

The contract value, in the base currency.
REQUEST_ID NUMBER (15)
Concurrent Manager audit column.
PROGRAM_APPLICATION_ID NUMBER (15)
Concurrent Manager audit column.
PROGRAM_ID NUMBER (15)
Concurrent Manager audit column.
PROGRAM_UPDATE_DATE DATE

Concurrent Manager audit column.
SECURITY_GROUP_ID NUMBER

Used for application hosting.

[top of page]

OKI.OKI_YOY_RENEWAL_AMT does not reference any database object

OKI.OKI_YOY_RENEWAL_AMT is referenced by following:

APPS
SYNONYM - OKI_YOY_RENEWAL_AMT

[top of page]

View: OKI_ADDRESSES_V

Comments
View Type

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

This view shows all addresses for contracts in OKI_SALES_K_HDRS. There may be multiple addresses for the same contract.

Columns
Name Datatype Length Mandatory Comments
ADDRESS_USE CHAR (7)
Specifies either a bill-to or ship-to address.
SITE_USE_ID NUMBER

The internal identifier from HZ_CUST_SITE_USES_ALL
PARTY_SITE_ID NUMBER (15) Y The internal identifer for the party site referenced by this address.
LOCATION_ID NUMBER (15) Y The identifier from HZ_LOCATIONS for this location.
RGP_ID VARCHAR2 (0)
The id from OKC_RULE_GROUPS_B for the rule group in which the rule appeared.
RUL_ID VARCHAR2 (0)
The identifier from OKC_RULES_B for the rule that holds this address.
CHR_ID NUMBER
Y The contract header identifier for this address.
CLE_ID NUMBER
Y The contract line identifier for this address, if at the line level.
CONTRACT_NUMBER VARCHAR2 (120)
The contract number in which this address is used.
CONTRACT_NUMBER_MODIFIER VARCHAR2 (120)
The contract number modifier in which this address is used.
LINE_NUMBER VARCHAR2 (150)
The external contract line number to which the address is associated, if at line level.
NAME VARCHAR2 (40) Y The name associated with the address.
COUNTRY VARCHAR2 (60) Y The country of the address.
ADDRESS1 VARCHAR2 (240) Y The first address line.
ADDRESS2 VARCHAR2 (240)
The second address line.
ADDRESS3 VARCHAR2 (240)
The third address line.
ADDRESS4 VARCHAR2 (240)
The fourth address line.
CITY VARCHAR2 (60)
The address city.
POSTAL_CODE VARCHAR2 (60)
The address postal code.
STATE VARCHAR2 (60)
The address state, if appropriate.
PROVINCE VARCHAR2 (60)
The address province, if appropriate.
COUNTY VARCHAR2 (60)
The address county, if appropriate.
FORMAT_ADDRESS VARCHAR2 (0)
The address formatted as a string.
SCS_CODE VARCHAR2 (30)
The category (sub-class) code for the contract.

[top of page]

APPS.OKI_ADDRESSES_V references the following:

APPS
PACKAGE - ARP_ADDR_LABEL_PKG
SYNONYM - OKI_SOLD_ITM_LINES
VIEW - OKX_CUST_SITE_USES_V

APPS.OKI_ADDRESSES_V is not referenced by any database object

[top of page]

View: OKI_BILL_HIST_V

Comments
View Type

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

This view shows the billing for a service contract.
A bill will show in this view if it has been interfaced to AR. If AR has not created an invoice, or if the program to fetch invoice numbers from AR has not been run, then the invoice number will show as -99.

Columns
Name Datatype Length Mandatory Comments
CONTRACT_ID NUMBER
Y The contract header identifier for this billing activity.
CONTRACT_LINE_ID NUMBER
Y Internal contract line identifier.
CONTRACT_NUMBER VARCHAR2 (120)
Contract number for this contract.
CONTRACT_NUMBER_MODIFIER VARCHAR2 (120)
Contract number modifier for this contract.
LINE_NUMBER VARCHAR2 (150)
The external idenfitier of the billed line.
INVOICE_DATE DATE

Transaction date.
INVOICE_NUMBER VARCHAR2 (60)
The invoice number.
INVOICE_AMOUNT NUMBER

Transaction amount. Includes any tax amount added by AR.
CURRENCY_CODE VARCHAR2 (45) Y Billing currency code.
INVOICE_CLASS VARCHAR2 (60)
The class of the invoice.
LINE_AMOUNT NUMBER (17)
Resulting monetary amount.
DATE_BILLED_FROM DATE
Y The starting date of the billed period.
DATE_BILLED_TO DATE
Y The ending date of the billed period.
BILL_ACTION VARCHAR2 (9)
Billing action (e.g. 'REG'ular, 'AVE'rage, 'SET'tlle).

[top of page]

APPS.OKI_BILL_HIST_V references the following:

APPS
SYNONYM - OKI_SOLD_ITM_LINES
SYNONYM - OKS_BILL_CONT_LINES
SYNONYM - OKS_BILL_TRANSACTIONS

APPS.OKI_BILL_HIST_V is not referenced by any database object

[top of page]

View: OKI_BILL_TO_ADDRS_V

Comments
View Type

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

This view shows the bill to addresses for contracts in OKI_SALES_K_HDRS. There may be multiple bill to addresses for the same contract.

Columns
Name Datatype Length Mandatory Comments
SITE_USE_ID NUMBER (15)
The internal identifier from HZ_CUST_SITE_USES_ALL
PARTY_SITE_ID NUMBER (15) Y The internal identifer for the party site referenced by this address.
LOCATION_ID NUMBER (15) Y The identifier from HZ_LOCATIONS for this location.
RULE_ID VARCHAR2 (0)
The internal identifier of the rule that holds this address.
CONTRACT_ID NUMBER
Y The contract header identifier for this address.
CONTRACT_LINE_ID NUMBER
Y The contract line identifier for this address, if at the line level.
CONTRACT_NUMBER VARCHAR2 (120)
Contract number for this contract.
CONTRACT_NUMBER_MODIFIER VARCHAR2 (120)
The contract number modifier in which this address is used.
LINE_NUMBER VARCHAR2 (150)
The external contract line number to which the address is associated, if at line level.
NAME VARCHAR2 (40) Y The name associated with the address.
COUNTRY VARCHAR2 (60) Y The country of the address.
ADDRESS1 VARCHAR2 (240) Y The first address line.
ADDRESS2 VARCHAR2 (240)
The second address line.
ADDRESS3 VARCHAR2 (240)
The third address line.
ADDRESS4 VARCHAR2 (240)
The fourth address line.
CITY VARCHAR2 (60)
The address city.
POSTAL_CODE VARCHAR2 (60)
The address postal code.
STATE VARCHAR2 (60)
The address state, if appropriate.
PROVINCE VARCHAR2 (60)
The address province, if appropriate.
COUNTY VARCHAR2 (60)
The address county, if appropriate.
FORMAT_ADDRESS VARCHAR2 (0)
The address formatted as a string.

[top of page]

APPS.OKI_BILL_TO_ADDRS_V references the following:

APPS
PACKAGE - ARP_ADDR_LABEL_PKG
PACKAGE - OKC_UTIL
SYNONYM - OKI_SOLD_ITM_LINES
VIEW - OKX_CUST_SITE_USES_V

APPS.OKI_BILL_TO_ADDRS_V is not referenced by any database object

[top of page]

View: OKI_CONTACT_POINTS_V

Comments
View Type

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

This view shows the contact points defined in TCA for contacts for contracts in OKI_SALES_K_HDRS. Contacts points might be email id, phone number, fax number, etc.

Columns
Name Datatype Length Mandatory Comments
CONTACT_POINT_ID NUMBER (15) Y The internal identifier for the contact point.
CONTRACT_ID NUMBER
Y The internal identifier of the contract for this contact and contact point.
CONTRACT_NUMBER VARCHAR2 (120)
Contract number for this contract.
CONTRACT_NUMBER_MODIFIER VARCHAR2 (120)
Contract number modifier for this contract.
COMPLETE_CONTRACT_NUMBER VARCHAR2 (241)
Concatenated contract number and modifier.
CONTACT_POINT_TYPE VARCHAR2 (30) Y The type of contact point, such as telephone or email.
CONTACT_ID NUMBER (15) Y The internal identifier for the contract contact.
EMAIL_FORMAT VARCHAR2 (30)
The format in which the email address is stored.
EMAIL_ADDRESS VARCHAR2 (2000)
The contact's email address.
PHONE_TYPE VARCHAR2 (30)
The code indicating the type of the phone number.
PHONE_TYPE_MEANING VARCHAR2 (80) Y The external description of the type of phone number.
PHONE_COUNTRY_CODE VARCHAR2 (10)
The country code of the contact's phone.
PHONE_AREA_CODE VARCHAR2 (10)
The area code of the contact's phone.
PHONE_NUMBER VARCHAR2 (40)
The contact's phone number.
PHONE_EXTENSION VARCHAR2 (20)
The extension of the contact's phone.
PRIMARY_FLAG VARCHAR2 (1)
Indicates if this is the primary means for contacting the contact.
CREATION_DATE DATE
Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column.

[top of page]

APPS.OKI_CONTACT_POINTS_V references the following:

APPS
VIEW - AR_LOOKUPS
SYNONYM - HZ_CONTACT_POINTS
SYNONYM - OKC_CONTACTS
SYNONYM - OKI_SALES_K_HDRS

APPS.OKI_CONTACT_POINTS_V is not referenced by any database object

[top of page]

View: OKI_COV_PROD_LINES_V

Comments
View Type

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

A view over OKI_COV_PROD_LINES containing language specific information.

Columns
Name Datatype Length Mandatory Comments
CONTRACT_LINE_ID NUMBER
Y Internal contract line identifier.
CONTRACT_ID NUMBER
Y The internal identifier of the contract for this covered product line.
PARENT_LINE_ID NUMBER

Internal line identifier of the parent top line of the covered product line.
SCS_CODE VARCHAR2 (30)
The category (sub-class) code for the contract.
CONTRACT_NUMBER VARCHAR2 (120)
Contract number for this contract.
CONTRACT_NUMBER_MODIFIER VARCHAR2 (120)
Contract number modifier for this contract.
COMPLETE_CONTRACT_NUMBER VARCHAR2 (241)
Concatenated contract number and modifier.
LINE_NUMBER VARCHAR2 (150)
External line number.
START_DATE DATE

The starting effective date of the line.
END_DATE DATE

The ending effective date of the line.
DURATION NUMBER

Duration of the line
PERIOD VARCHAR2 (30)
Period code for the duration
STS_CODE VARCHAR2 (30)
The code value representing the status type of the line, such as ACTIVE or ENTERED.
STATUS_MEANING VARCHAR2 (90) Y The external description of the status of the contract.
STATUS_TYPE_CODE VARCHAR2 (30)
Status type code
STATUS_TYPE_MEANING VARCHAR2 (80) Y Status type meaning
TRN_CODE VARCHAR2 (30)
The contract termination reason code.
TERMINATION_MEANING VARCHAR2 (80)
The external description of the termination reason.
DATE_TERMINATED DATE

Date the line was terminated.
DATE_RENEWED DATE

The date the line was renewed.
NUMBER_OF_ITEMS NUMBER (15)
Number of covered items for the line.
UOM_CODE VARCHAR2 (3)
Unit of measure code for the number of items.
UNIT_PRICE NUMBER

Unit price for the covered product.
UNIT_PRICE_PERCENT NUMBER (6)
Percentage of the covered item price used to price the service, if percentage pricing of service is used.
PRICE_NEGOTIATED NUMBER

The line price as negotiated. The final price of the line.
CURRENCY_CODE VARCHAR2 (15)
The transaction currency code for the line.
PRICE_NEGOTIATED_RENEWED NUMBER

The negotiated price of the line renewed by this line.
CURRENCY_CODE_RENEWED VARCHAR2 (15)
The transaction currency code of the line renewed by this line.
SOB_PRICE_UNIT NUMBER

The unit price converted to the set of books currency.
SOB_PRICE_NEGOTIATED NUMBER

The negotiated price in the set of books currency.
SOB_PRICE_NEGOTIATED_RENEWED NUMBER

The price of the renewed line in the set of books currency.
SOB_CURRENCY_CODE VARCHAR2 (15)
The set of books currency code.
BASE_PRICE_UNIT NUMBER

Unit price for the covered product, in the base currency.
BASE_PRICE_NEGOTIATED NUMBER

The line price as negotiated, in the base currency.
BASE_PRICE_NEGOTIATED_RENEWED NUMBER

The line negotiated price of the line renewed by this line, in the base currency.
BASE_CURRENCY_CODE VARCHAR2 (15)
The currency code of the base currency.
SERVICE_ITEM VARCHAR2 (240)
The description of the service.
COVERED_PRODUCT_ID NUMBER

The internal identifier of the covered product in Install Base.
COVERED_PRODUCT VARCHAR2 (0)
The description of the covered product.
CONCATENATED_SEGMENTS VARCHAR2 (640)
Item segments
SERIAL_NUMBER VARCHAR2 (30)
Item serial number
REFERENCE_NUMBER VARCHAR2 (30)
Item reference number
COV_PROD_QUANTITY NUMBER

The quantity of the covered product in Install Base.
COV_PROD_UOM VARCHAR2 (25)
The unit of measure of the quantity of the covered product in Install Base.
INSTALLATION_DATE DATE

The date on which the covered product was installed.
COV_PROD_ORDER_DATE DATE

The date of the sales order that shipped the covered product.
COV_PROD_ORDER_NUMBER NUMBER (15)
The order number of the sales order that shipped the covered product.
COV_PROD_ORDER_LINE NUMBER (15)
The line number for this covered product on the sales order.
COV_PROD_NET_AMOUNT NUMBER (28)
The net amount of the purchase/rental of the covered product.
COV_PROD_ORDER_LINE_ID NUMBER

The internal line identifier for this covered product on the sales order.
SYSTEM_ID NUMBER

The internal identifier of the Install Base system referenced by the covered product.
SYSTEM_NAME VARCHAR2 (50)
Install base system name
PRODUCT_AGREEMENT_ID NUMBER

The identifier of the sales agreement used when purchasing the product.
COV_PROD_BILL_TO_SITE_ID NUMBER

The covered product (Install Base) bill to address internal identifier
COV_PROD_SHIP_TO_SITE_ID NUMBER

The covered product (Install Base) ship to address internal identifier
COV_PROD_INSTALL_SITE_ID NUMBER

The covered product (Install Base) installed at address internal identifier
COV_PROD_BILL_TO_CONTACT_ID NUMBER (15)
The covered product (Install Base) bill to contact internal identifier
COV_PROD_SHIP_TO_CONTACT_ID NUMBER (15)
The covered product (Install Base) ship to contact internal identifier
CREATION_DATE DATE

Standard Who column
LAST_UPDATE_DATE DATE

Standard Who column.
ATTRIBUTE_CATEGORY VARCHAR2 (90)
Descriptive Flexfield structure defining column.
ATTRIBUTE1 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE2 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE3 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE4 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE5 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE6 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE7 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE8 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE9 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE10 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE11 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE12 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE13 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE14 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE15 VARCHAR2 (450)
Descriptive Flexfield segment column.
PRICING_ATTRIBUTE1 VARCHAR2 (30)
Pricing attribute 1
PRICING_ATTRIBUTE2 VARCHAR2 (30)
Pricing attribute 2
PRICING_ATTRIBUTE3 VARCHAR2 (30)
Pricing attribute 3
PRICING_ATTRIBUTE4 VARCHAR2 (30)
Pricing attribute 4
PRICING_ATTRIBUTE5 VARCHAR2 (30)
Pricing attribute 5
PRICING_ATTRIBUTE6 VARCHAR2 (30)
Pricing attribute 6
PRICING_ATTRIBUTE7 VARCHAR2 (30)
Pricing attribute 7
PRICING_ATTRIBUTE8 VARCHAR2 (30)
Pricing attribute 8
PRICING_ATTRIBUTE9 VARCHAR2 (30)
Pricing attribute 9
PRICING_ATTRIBUTE10 VARCHAR2 (30)
Pricing attribute 10
CUSTOMER_PRODUCT_ITEM_ID NUMBER

Customer product item id
INVENTORY_ORGANIZATION_ID NUMBER

Inventory organization id

[top of page]

APPS.OKI_COV_PROD_LINES_V references the following:

APPS
SYNONYM - CSI_SYSTEMS_TL
PACKAGE - FND_GLOBAL
VIEW - FND_LOOKUPS
VIEW - OKC_STATUSES_V
PACKAGE - OKC_UTIL
SYNONYM - OKI_COV_PRD_LINES

APPS.OKI_COV_PROD_LINES_V is not referenced by any database object

[top of page]

View: OKI_DAILY_RATES_V

Comments
View Type

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

This View holds the conversion rate data for all the currency combinations for the conversion type specified by the OKI_DEFAULT_CONVERSION_TYPE profile option. This information is used to perform conversions from the transaction currency to the set of books currency and the base currency.
This view isis based on table OKI_DAILY_RATES

Columns
Name Datatype Length Mandatory Comments
FROM_CURRENCY VARCHAR2 (15) Y The currency from which one is converting.
TO_CURRENCY VARCHAR2 (15) Y The currency to which one is converting.
CONVERSION_RATE NUMBER
Y The rate to use to convert the currencies.
CONVERSION_DATE DATE
Y The date for the conversion rate.

[top of page]

APPS.OKI_DAILY_RATES_V references the following:

APPS
SYNONYM - OKI_DAILY_RATES

APPS.OKI_DAILY_RATES_V is not referenced by any database object

[top of page]

View: OKI_EXPIRED_LINES_V

Comments
View Type

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

A view over OKI_EXPIRED_LINES containing language specific information.

Columns
Name Datatype Length Mandatory Comments
CONTRACT_LINE_ID NUMBER
Y Internal contract line identifier.
CONTRACT_ID NUMBER
Y The internal identifier of the contract for this expired line.
CONTRACT_NUMBER VARCHAR2 (120)
Contract number for this contract.
CONTRACT_NUMBER_MODIFIER VARCHAR2 (120)
Contract number modifier for the contract in which this line appears.
COMPLETE_CONTRACT_NUMBER VARCHAR2 (241)
Concatenated contract number and modifier.
SCS_CODE VARCHAR2 (30)
The category (sub-class) code for the contract.
LINE_NUMBER VARCHAR2 (150)
External line number.
START_DATE DATE

The starting effective date of the line.
END_DATE DATE

The ending effective date of the line.
STS_CODE VARCHAR2 (30)
The code value representing the status type of the line, such as ACTIVE or ENTERED.
STATUS_MEANING VARCHAR2 (90) Y The external description of the status of the contract.
TRN_CODE VARCHAR2 (30)
The line termination reason code.
TERMINATION_MEANING VARCHAR2 (80)
The external description of the termination reason.
DATE_TERMINATED DATE

Date the line was terminated.
DATE_RENEWED DATE

The date the line was renewed.
END_PERIOD_NUM NUMBER (15)
The number of the General Ledger period in which the line ends.
END_PERIOD_NAME VARCHAR2 (15)
The name of the General Ledger period in which the line ends.
END_QUARTER NUMBER (15)
The General Ledger quarter in which the line ends.
END_YEAR NUMBER (15)
The General Ledger year in which the line ends.
UNIT_PRICE NUMBER

Unit price for the line item.
UNIT_PRICE_PERCENT NUMBER (6)
Percentage of the covered item price used to price the service, if percentage pricing of service is used.
PRICE_NEGOTIATED NUMBER

The line price as negotiated. The final price of the line.
CURRENCY_CODE VARCHAR2 (15)
The transaction currency code for the line.
PRICE_NEGOTIATED_RENEWED VARCHAR2 (0)
The negotiated price of the line renewed by this line.
CURRENCY_CODE_RENEWED VARCHAR2 (0)
The transaction currency code of the line renewed by this line.
SOB_PRICE_UNIT NUMBER

The unit price converted to the set of books currency.
SOB_PRICE_NEGOTIATED NUMBER

The negotiated price in the set of books currency.
SOB_PRICE_NEGOTIATED_RENEWED VARCHAR2 (0)
The price of the renewed line in the set of books currency.
SOB_CURRENCY_CODE VARCHAR2 (15)
The set of books currency code.
BASE_PRICE_UNIT NUMBER

Unit price for the line, in the base currency.
BASE_PRICE_NEGOTIATED NUMBER

The line price as negotiated, in the base currency.
BASE_PRICE_NEGOTIATED_RENEWED VARCHAR2 (0)
The line negotiated price of the line renewed by this line, in the base currency.
BASE_CURRENCY_CODE VARCHAR2 (15)
The currency code of the base currency.
AUTHORING_ORG_ID NUMBER

The internal identifier of the operating unit in which the contract was authored.
ORGANIZATION_NAME VARCHAR2 (240) Y The name of the operating unit in which the contract was authored.
INVENTORY_ORGANIZATION_ID NUMBER

The internal identifier for the inventory organization.
CREATION_DATE DATE

Standard Who column
LAST_UPDATE_DATE DATE

Standard Who column.
ATTRIBUTE_CATEGORY VARCHAR2 (90)
Descriptive Flexfield structure defining column.
ATTRIBUTE1 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE2 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE3 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE4 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE5 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE6 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE7 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE8 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE9 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE10 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE11 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE12 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE13 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE14 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE15 VARCHAR2 (450)
Descriptive Flexfield segment column.

[top of page]

APPS.OKI_EXPIRED_LINES_V references the following:

APPS
PACKAGE - FND_GLOBAL
VIEW - FND_LOOKUPS
SYNONYM - HR_ALL_ORGANIZATION_UNITS_TL
VIEW - OKC_STATUSES_V
PACKAGE - OKC_UTIL
SYNONYM - OKI_COV_PRD_LINES
APPS.OKI_EXPIRED_LINES_V is referenced by following:

APPS
VIEW - OKI_RNW_BY_STS_DTL_V

[top of page]

View: OKI_EXP_NOT_RENEWED_V

Comments
View Type

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

A view over OKI_EXP_NOT_RENEWED, containing language specific information.

Columns
Name Datatype Length Mandatory Comments
ID NUMBER
Y The internal identifier for the row.
PERIOD_NAME VARCHAR2 (15) Y The name from General Ledger for the period of this information.
PERIOD_SET_NAME VARCHAR2 (15) Y The name of the General Ledger period set used to determine valid periods.
PERIOD_TYPE VARCHAR2 (15)
The type of General Ledger period used for this information.
AUTHORING_ORG_ID NUMBER
Y The internal identifier of the operating unit in which the contract was authored.
AUTHORING_ORG_NAME VARCHAR2 (240)
The name of the operating unit in which the contract was authored.
CUSTOMER_PARTY_ID NUMBER
Y The internal party identifier of the contract customer.
CUSTOMER_NAME VARCHAR2 (360)
The name of the customer in the contract.
CONTACT_ID VARCHAR2 (40)
The internal identifier for the contract contact.
SALESREP_NAME VARCHAR2 (240)
The name of the sales representative.
SCS_CODE VARCHAR2 (30)
The category (sub-class) code for the contract.
CONTRACT_COUNT NUMBER

The count of contracts expired and not renewed.
BASE_LOST_AMOUNT NUMBER

The amount lost (not renewed), in the base currency.
REQUEST_ID NUMBER (15)
Concurrent Manager audit column.
PROGRAM_APPLICATION_ID NUMBER (15)
Concurrent Manager audit column.
PROGRAM_ID NUMBER (15)
Concurrent Manager audit column.
PROGRAM_UPDATE_DATE DATE

Concurrent Manager audit column.

[top of page]

APPS.OKI_EXP_NOT_RENEWED_V references the following:

APPS
SYNONYM - OKI_EXP_NOT_RENEWED

APPS.OKI_EXP_NOT_RENEWED_V is not referenced by any database object

[top of page]

View: OKI_FORECAST_BY_ORGS_V

Comments
View Type

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

This view displays the forecast and booked contract amounts for an organization for any given period.
This view is based on OKI_FORECAST_BY_ORGS table

Columns
Name Datatype Length Mandatory Comments
ID NUMBER
Y The internal identifier for the row.
PERIOD_NAME VARCHAR2 (15) Y The name from General Ledger for the period of this information.
PERIOD_SET_NAME VARCHAR2 (15) Y The name of the General Ledger period set used to determine valid periods.
PERIOD_TYPE VARCHAR2 (15)
The type of General Ledger period used for this information.
AUTHORING_ORG_ID NUMBER
Y The internal identifier of the operating unit in which the contract was authored.
AUTHORING_ORG_NAME VARCHAR2 (240)
The name of the operating unit in which the contract was authored.
SCS_CODE VARCHAR2 (30)
The category (sub-class) code for the contract.
BASE_FORECAST_AMOUNT NUMBER

The forecasted amount, in the base currency.
BASE_BOOKED_AMOUNT NUMBER

The sum of booked renewals, in the base currency.
REQUEST_ID NUMBER (15)
Concurrent Manager audit column.
PROGRAM_APPLICATION_ID NUMBER (15)
Concurrent Manager audit column.
PROGRAM_ID NUMBER (15)
Concurrent Manager audit column.
PROGRAM_UPDATE_DATE DATE

Concurrent Manager audit column.

[top of page]

APPS.OKI_FORECAST_BY_ORGS_V references the following:

APPS
SYNONYM - OKI_FORECAST_BY_ORGS

APPS.OKI_FORECAST_BY_ORGS_V is not referenced by any database object

[top of page]

View: OKI_K_CONTACTS_V

Comments
View Type

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

This view shows all the contacts for contracts in OKI_SALES_K_HDRS, for all parties. It shows the contact role and name.

Columns
Name Datatype Length Mandatory Comments
PARTY_CONTACT_ID NUMBER

The internal identifier for the contact.
CONTRACT_ID NUMBER

The internal identifier of the contract for this contact and role.
CONTRACT_NUMBER VARCHAR2 (120)
Contract number for this contract.
CONTRACT_NUMBER_MODIFIER VARCHAR2 (120)
Contract number modifier for this contract.
COMPLETE_CONTRACT_NUMBER VARCHAR2 (241)
Concatenated contract number and modifier.
PARTY_ROLE_ID NUMBER

The internal identifier for this party in this role in this contract.
CONTACT_ROLE_CODE VARCHAR2 (30)
The code for the role the contact plays in the contract.
CONTACT_ROLE_MEANING VARCHAR2 (80)
The user description for the role the contact plays in the contract.
CONTACT_ID NUMBER

The internal identifier for the contract contact.
CONTACT_NAME VARCHAR2 (360)
The contract contact name.
CREATION_DATE DATE

Standard Who column
LAST_UPDATE_DATE DATE

Standard Who column.
ATTRIBUTE_CATEGORY VARCHAR2 (90)
Descriptive Flexfield structure defining column.
ATTRIBUTE1 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE2 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE3 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE4 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE5 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE6 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE7 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE8 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE9 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE10 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE11 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE12 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE13 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE14 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE15 VARCHAR2 (450)
Descriptive Flexfield segment column.

[top of page]

APPS.OKI_K_CONTACTS_V references the following:

APPS
PACKAGE - FND_GLOBAL
VIEW - FND_LOOKUPS
SYNONYM - OKC_CONTACTS
PACKAGE - OKC_UTIL
SYNONYM - OKI_SALES_K_HDRS
VIEW - OKX_BUYERS_V
VIEW - OKX_CUST_ROLE_RESP_V
VIEW - OKX_PARTY_CONTACTS_V
VIEW - OKX_RESOURCES_V
VIEW - OKX_SALESREPS_V
VIEW - OKX_VENDOR_CONTACTS_V

APPS.OKI_K_CONTACTS_V is not referenced by any database object

[top of page]

View: OKI_K_PARTIES_V

Comments
View Type

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

This view shows all the parties to the contracts in OKI_SALES_K_HDRS, including the party role and name.

Columns
Name Datatype Length Mandatory Comments
PARTY_ROLE_ID NUMBER

The internal identifier for this party in this role in this contract.
CONTRACT_ID NUMBER

The internal identifier of the contract for this party and role.
CONTRACT_NUMBER VARCHAR2 (120)
Contract number for this contract.
CONTRACT_NUMBER_MODIFIER VARCHAR2 (120)
Contract number modifier for this contract.
COMPLETE_CONTRACT_NUMBER VARCHAR2 (241)
Concatenated contract number and modifier.
ROLE_CODE VARCHAR2 (30)
The code for the role the party plays in the contract.
ROLE_MEANING VARCHAR2 (80)
The external description of the role the party plays in the contract.
PARTY_ID NUMBER

The internal identifier for the party.
PARTY_NAME VARCHAR2 (360)
The name of the party.
PARTY_NUMBER VARCHAR2 (30)
Party number
CREATION_DATE DATE

Standard Who column
LAST_UPDATE_DATE DATE

Standard Who column.
ATTRIBUTE_CATEGORY VARCHAR2 (90)
Descriptive Flexfield structure defining column.
ATTRIBUTE1 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE2 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE3 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE4 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE5 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE6 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE7 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE8 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE9 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE10 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE11 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE12 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE13 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE14 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE15 VARCHAR2 (450)
Descriptive Flexfield segment column.

[top of page]

APPS.OKI_K_PARTIES_V references the following:

APPS
PACKAGE - ARP_ADDR_LABEL_PKG
PACKAGE - FND_GLOBAL
VIEW - FND_LOOKUPS
SYNONYM - OKC_K_PARTY_ROLES_B
PACKAGE - OKC_UTIL
SYNONYM - OKI_SALES_K_HDRS
VIEW - OKX_ORGANIZATION_DEFS_V
VIEW - OKX_PARTIES_V

APPS.OKI_K_PARTIES_V is not referenced by any database object

[top of page]

View: OKI_K_SALESREP_V

Comments
View Type

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

A view over OKI_K_SALESREPS, containing language specific information.

Columns
Name Datatype Length Mandatory Comments
PARTY_CONTACT_ID NUMBER
Y The internal identifier for the contact.
CONTRACT_ID NUMBER
Y The internal identifier of the contract.
CONTRACT_NUMBER VARCHAR2 (120)
Contract number for this contract.
CONTRACT_NUMBER_MODIFIER VARCHAR2 (120)
Contract number modifier for this contract.
COMPLETE_CONTRACT_NUMBER VARCHAR2 (241)
Concatenated contract number and modifier.
PARTY_ROLE_ID NUMBER

The internal identifier for this party in this role in this contract.
CONTACT_ROLE_CODE VARCHAR2 (30)
The code for the role the contact plays in the contract.
CONTACT_ROLE_MEANING VARCHAR2 (80) Y The user description for the role the contact plays in the contract.
CONTACT_ID NUMBER

The internal identifier for the contract contact.
SALESREP_NAME VARCHAR2 (240)
The name of the sales representative.
CREATION_DATE DATE

Standard Who column
LAST_UPDATE_DATE DATE

Standard Who column.
ATTRIBUTE_CATEGORY VARCHAR2 (90)
Descriptive Flexfield structure defining column.
ATTRIBUTE1 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE2 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE3 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE4 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE5 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE6 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE7 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE8 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE9 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE10 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE11 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE12 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE13 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE14 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE15 VARCHAR2 (450)
Descriptive Flexfield segment column.

[top of page]

APPS.OKI_K_SALESREP_V references the following:

APPS
PACKAGE - FND_GLOBAL
VIEW - FND_LOOKUPS
SYNONYM - JTF_RS_SALESREPS
PACKAGE - OKC_UTIL
SYNONYM - OKI_K_SALESREPS
SYNONYM - OKI_SALES_K_HDRS

APPS.OKI_K_SALESREP_V is not referenced by any database object

[top of page]

View: OKI_PERF_MEASURES_V

Comments
View Type

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

This view shows the data for Key Performance Indicator values for any given period.
This view is based on OKI_PERF_MEASURES table.

Columns
Name Datatype Length Mandatory Comments
ID NUMBER
Y The internal identifier for the row.
PERIOD_NAME VARCHAR2 (15) Y The name from General Ledger for the period of this information.
PERIOD_SET_NAME VARCHAR2 (15) Y The name of the General Ledger period set used to determine valid periods.
PERIOD_TYPE VARCHAR2 (15)
The type of General Ledger period used for this information.
AUTHORING_ORG_ID NUMBER

The internal identifier of the operating unit in which the contract was authored.
AUTHORING_ORG_NAME VARCHAR2 (240)
The name of the operating unit in which the contract was authored.
KPI_CODE VARCHAR2 (30) Y A code specifying the Key Performance Indicator.
KPI_VALUE NUMBER

The value of the Key Performance Indicator.
SCS_CODE VARCHAR2 (30)
The category (sub-class) code for the contract.
REQUEST_ID NUMBER (15)
Concurrent Manager audit column.
PROGRAM_APPLICATION_ID NUMBER (15)
Concurrent Manager audit column.
PROGRAM_ID NUMBER (15)
Concurrent Manager audit column.
PROGRAM_UPDATE_DATE DATE

Concurrent Manager audit column.

[top of page]

APPS.OKI_PERF_MEASURES_V references the following:

APPS
SYNONYM - OKI_PERF_MEASURES

APPS.OKI_PERF_MEASURES_V is not referenced by any database object

[top of page]

View: OKI_RENEWAL_AGING_V

Comments
View Type

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

A view over OKI_RENEWAL_AGING, containing language specific information.

Columns
Name Datatype Length Mandatory Comments
ID NUMBER
Y The internal identifier for the row.
PERIOD_NAME VARCHAR2 (15) Y The name from General Ledger for the period of this information.
PERIOD_SET_NAME VARCHAR2 (15) Y The name of the General Ledger period set used to determine valid periods.
PERIOD_TYPE VARCHAR2 (15)
The type of General Ledger period used for this information.
AUTHORING_ORG_ID NUMBER
Y The internal identifier of the operating unit in which the contract was authored.
AUTHORING_ORG_NAME VARCHAR2 (240)
The name of the operating unit in which the contract was authored.
CUSTOMER_PARTY_ID NUMBER
Y The internal party identifier of the contract customer.
CUSTOMER_NAME VARCHAR2 (360)
The name of the customer in the contract.
SCS_CODE VARCHAR2 (30)
The category (sub-class) code for the contract.
AGE_GROUP1 NUMBER

The first renewal aging bucket, holds the value of contracts in that bucket.
AGE_GROUP2 NUMBER

The second renewal aging bucket, holds the value of contracts in that bucket.
AGE_GROUP3 NUMBER

The third renewal aging bucket, holds the value of contracts in that bucket.
AGE_GROUP4 NUMBER

The fourth renewal aging bucket, holds the value of contracts in that bucket.
REQUEST_ID NUMBER (15)
Concurrent Manager audit column.
PROGRAM_APPLICATION_ID NUMBER (15)
Concurrent Manager audit column.
PROGRAM_ID NUMBER (15)
Concurrent Manager audit column.
PROGRAM_UPDATE_DATE DATE

Concurrent Manager audit column.

[top of page]

APPS.OKI_RENEWAL_AGING_V references the following:

APPS
SYNONYM - OKI_RENEWAL_AGING

APPS.OKI_RENEWAL_AGING_V is not referenced by any database object

[top of page]

View: OKI_RENEW_BY_STATUSES_V

Comments
View Type

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

A view over OKI_RENEW_BY_STATUSES, containing language specific information.
.

Columns
Name Datatype Length Mandatory Comments
ID NUMBER
Y The internal identifier for the row.
PERIOD_NAME VARCHAR2 (15) Y The name from General Ledger for the period of this information.
PERIOD_SET_NAME VARCHAR2 (15) Y The name of the General Ledger period set used to determine valid periods.
PERIOD_TYPE VARCHAR2 (15)
The type of General Ledger period used for this information.
AUTHORING_ORG_ID NUMBER

The internal identifier of the operating unit in which the contract was authored.
AUTHORING_ORG_NAME VARCHAR2 (240)
The name of the operating unit in which the contract was authored.
STATUS_CODE VARCHAR2 (30) Y The code value representing the status of the contract.
SCS_CODE VARCHAR2 (30)
The category (sub-class) code for the contract.
BASE_AMOUNT NUMBER

The sum of renewals in this status, in the base currency.
CONTRACT_COUNT NUMBER

The count of renewals in this status.
REQUEST_ID NUMBER (15)
Concurrent Manager audit column.
PROGRAM_APPLICATION_ID NUMBER (15)
Concurrent Manager audit column.
PROGRAM_ID NUMBER (15)
Concurrent Manager audit column.
PROGRAM_UPDATE_DATE DATE

Concurrent Manager audit column.

[top of page]

APPS.OKI_RENEW_BY_STATUSES_V references the following:

APPS
SYNONYM - OKI_RENEW_BY_STATUSES

APPS.OKI_RENEW_BY_STATUSES_V is not referenced by any database object

[top of page]

View: OKI_RENEW_RELS_V

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

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

[top of page]

APPS.OKI_RENEW_RELS_V references the following:

APPS
SYNONYM - OKC_CLASS_OPERATIONS
SYNONYM - OKC_K_HEADERS_B
SYNONYM - OKC_K_LINES_B
SYNONYM - OKC_OPERATION_INSTANCES
SYNONYM - OKC_OPERATION_LINES
SYNONYM - OKC_STATUSES_B

APPS.OKI_RENEW_RELS_V is not referenced by any database object

[top of page]

View: OKI_RNW_BY_STS_DTL_V

Comments
View Type

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

Summarized information about renewal contracts, by status and General Ledger period.

Columns
Name Datatype Length Mandatory Comments
PERIOD_SET_NAME VARCHAR2 (15)
The name of the General Ledger period set used to determine valid periods.
PERIOD_TYPE VARCHAR2 (15)
The type of General Ledger period used for this information.
PERIOD_NAME VARCHAR2 (15)
The name from General Ledger for the period of this information.
AUTHORING_ORG_ID NUMBER

The internal identifier of the operating unit in which the contract was authored.
ORGANIZATION_NAME VARCHAR2 (240)
The name of the operating unit in which the contract was authored.
CATEGORY_CODE VARCHAR2 (30)
The code of the contract category.
CATEGORY_MEANING VARCHAR2 (90)
The user description for the contract category.
RENEWAL_PROCESS_CODE VARCHAR2 (8)
The renewal status category code, used to link to the summary.
STATUS_CODE VARCHAR2 (30)
The code value representing the status of the contract.
STATUS_MEANING VARCHAR2 (90)
The external description of the status of the contract.
CONTRACT_COUNT NUMBER

The count of contracts.
BASE_CONTRACT_AMOUNT NUMBER

The contract value, in the base currency.
BASE_CURRENCY_CODE VARCHAR2 (4000)
The currency code of the base currency.

[top of page]

APPS.OKI_RNW_BY_STS_DTL_V references the following:

APPS
PACKAGE - FND_GLOBAL
PACKAGE - FND_PROFILE
SYNONYM - GL_PERIODS
PACKAGE - OKC_UTIL
SYNONYM - OKI_DAILY_RATES
VIEW - OKI_EXPIRED_LINES_V
VIEW - OKI_SALES_K_HEADERS_V
VIEW - OKI_SALES_K_RENEW_V

APPS.OKI_RNW_BY_STS_DTL_V is not referenced by any database object

[top of page]

View: OKI_ROLE_MAPS_V

Comments
View Type

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

A view over OKI_ROLE_MAPS, containing language specific information.

Columns
Name Datatype Length Mandatory Comments
ROLE_USE VARCHAR2 (10) Y The role use, such as CUSTOMER.
SCS_CODE VARCHAR2 (30) Y The category (sub-class) code for the contract.
RLE_CODE VARCHAR2 (30)
The role code.
CRO_CODE VARCHAR2 (30)
The contact role code.
OBJECT_VERSION_NUMBER NUMBER (9) Y A number used to track the version of the row.
CREATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column.
LAST_UPDATE_DATE DATE
Y Standard Who column.
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column.

[top of page]

APPS.OKI_ROLE_MAPS_V references the following:

APPS
SYNONYM - OKI_ROLE_MAPS

APPS.OKI_ROLE_MAPS_V is not referenced by any database object

[top of page]

View: OKI_RULE_MAPS_V

Comments
View Type

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

A view over OKI_RULE_MAPS, containing language specific information.

Columns
Name Datatype Length Mandatory Comments
RULE_USE VARCHAR2 (10) Y The use of the rule, such as BILLING or SHIPPING.
SCS_CODE VARCHAR2 (30) Y The category (sub-class) code for the contract.
RGD_CODE VARCHAR2 (30) Y The rule group code.
RDF_CODE VARCHAR2 (30) Y The address province, if appropriate.
OBJECT_VERSION_NUMBER NUMBER (9) Y A number used to track the version of the row.
CREATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column.
LAST_UPDATE_DATE DATE
Y Standard Who column.
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column.

[top of page]

APPS.OKI_RULE_MAPS_V references the following:

APPS
SYNONYM - OKI_RULE_MAPS

APPS.OKI_RULE_MAPS_V is not referenced by any database object

[top of page]

View: OKI_SALES_K_HEADERS_V

Comments
View Type

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

A view over OKI_SALES_K_HEADERS, containing language specific columns.

Columns
Name Datatype Length Mandatory Comments
CONTRACT_ID NUMBER
Y The internal identifier of the contract.
CONTRACT_NUMBER VARCHAR2 (120)
Contract number for this contract.
CONTRACT_NUMBER_MODIFIER VARCHAR2 (120)
Contract number modifier for this contract.
COMPLETE_CONTRACT_NUMBER VARCHAR2 (241)
Concatenated contract number and modifier.
SHORT_DESCRIPTION VARCHAR2 (600)
Short description of the contract
ORDER_NUMBER VARCHAR2 (22)
Order number
AUTHORING_ORG_ID NUMBER

The internal identifier of the operating unit in which the contract was authored.
ORGANIZATION_NAME VARCHAR2 (240) Y The name of the operating unit in which the contract was authored.
SOB_ID NUMBER

Set of books id
CATEGORY_CODE VARCHAR2 (30)
The code of the contract category.
CATEGORY_MEANING VARCHAR2 (90) Y The user description for the contract category.
STATUS_CODE VARCHAR2 (30)
The code value representing the status of the contract.
STATUS_MEANING VARCHAR2 (90) Y The external description of the status of the contract.
STATUS_TYPE_CODE VARCHAR2 (30) Y The code value representing the status type of the contract, such as ACTIVE or ENTERED.
STATUS_TYPE_MEANING VARCHAR2 (80) Y The external description of the status type of the contract.
IS_NEW_YN VARCHAR2 (240)
Y - New contract N- Renewal contract
IS_LATEST_YN VARCHAR2 (1)
Y - Latest renewal N - not a latest renewal
ORIG_SYSTEM_SOURCE_CODE VARCHAR2 (30)
Original system source source code
ORIG_SYSTEM_ID1 NUMBER

Original system id1
ORIG_SYSTEM_REFERENCE1 VARCHAR2 (30)
Original system reference 1
CONTRACT_TYPE VARCHAR2 (30)
Contract type
CUSTOMER_PARTY_ID NUMBER

The internal party identifier of the contract customer.
CUSTOMER_NAME VARCHAR2 (360) Y The name of the customer in the contract.
CUSTOMER_NUMBER VARCHAR2 (30) Y Customer number
CONTRACT_AMOUNT NUMBER

The total amount of the contract, in the contract transaction currency.
FORECAST_AMOUNT NUMBER

The forecasted value of the contract.
CURRENCY_CODE VARCHAR2 (15)
The currency code of the contract transaction currency.
CONTRACT_AMOUNT_RENEWED VARCHAR2 (0)
The amount of the contract renewed by this contract, in the transaction currency.
CURRENCY_CODE_RENEWED VARCHAR2 (0)
The transaction currency code of the contract renewed by this contract.
SOB_CONTRACT_AMOUNT NUMBER

The amount of the contract, converted into the set of books currency.
SOB_FORECAST_AMOUNT NUMBER

The forecasted amount of this contract, converted into the set of books currency.
SOB_CONTRACT_AMOUNT_RENEWED VARCHAR2 (0)
The amount of the contract renewed by this contract, converted into the set of books currency.
SOB_CURRENCY_CODE VARCHAR2 (15)
The set of books currency code.
BASE_CONTRACT_AMOUNT NUMBER

The value of the contract, in the base currency.
BASE_FORECAST_AMOUNT NUMBER

The forecasted amount for the contract, in the base currency.
BASE_CONTRACT_AMOUNT_RENEWED VARCHAR2 (0)
The amount of the contract renewed by this contract, in the base currency.
BASE_CURRENCY_CODE VARCHAR2 (15)
The currency code of the base currency.
WIN_PERCENT NUMBER

The estimated percentage probability that the contract will be signed.
EXPECTED_CLOSE_DATE DATE

The date on which the contract is expected to be signed.
START_DATE DATE

The starting effective date of the contract.
END_DATE DATE

The ending effective date of the contract.
DURATION NUMBER

Duration
PERIOD VARCHAR2 (30)
Period code for the duration
DATE_APPROVED DATE

The date the contract was approved.
DATE_SIGNED DATE

The date the contract was signed.
DATE_RENEWED DATE

The date the contract was renewed.
DATE_CANCELED DATE

The date the contract was canceled.
DATE_TERMINATED DATE

The date the contract was terminated.
TERMINATED_AMOUNT NUMBER

Terminated amount
SOB_TERMINATED_AMOUNT NUMBER

Terminated amount in functional currency
BASE_TERMINATED_AMOUNT NUMBER

Terminated amount in base currency
START_PERIOD_NUM NUMBER (15)
The number of the General Ledger period in which the contract starts.
START_PERIOD_NAME VARCHAR2 (15)
The name of the General Ledger period in which the contract starts.
START_QUARTER NUMBER (15)
The General Ledger quarter in which the contract starts.
START_YEAR NUMBER (15)
The General Ledger year in which the contract starts.
CLOSE_PERIOD_NUM NUMBER (15)
The General Ledger period nunber in which the contract is expected to close.
CLOSE_PERIOD_NAME VARCHAR2 (15)
The General Ledger period name in which the contract is expected to close.
CLOSE_QUARTER NUMBER (15)
The General Ledger quarter in which the contract is expected to close.
CLOSE_YEAR NUMBER (15)
The General Ledger year in which the contract is expected to close.
TRN_CODE VARCHAR2 (30)
The contract termination reason code.
TERMINATION_MEANING VARCHAR2 (80)
The external description of the termination reason.
INVENTORY_ORGANIZATION_ID NUMBER

The internal identifier for the inventory organization.
APPLICATION_ID NUMBER

The internal identifier of the Oracle Application that created the contract.
CREATION_DATE DATE

Standard Who column
LAST_UPDATE_DATE DATE

Standard Who column.
ATTRIBUTE_CATEGORY VARCHAR2 (90)
Descriptive Flexfield structure defining column.
ATTRIBUTE1 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE2 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE3 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE4 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE5 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE6 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE7 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE8 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE9 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE10 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE11 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE12 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE13 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE14 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE15 VARCHAR2 (450)
Descriptive Flexfield segment column.
RENEWAL_TYPE_USED_CODE VARCHAR2 (10)
Renewal Type Code Used
RENEWAL_TYPES_USED VARCHAR2 (80)
Renewal Type Used Meaning

[top of page]

APPS.OKI_SALES_K_HEADERS_V references the following:

APPS
PACKAGE - FND_GLOBAL
VIEW - FND_LOOKUPS
SYNONYM - HR_ALL_ORGANIZATION_UNITS_TL
SYNONYM - HZ_PARTIES
SYNONYM - OKC_K_HEADERS_TL
VIEW - OKC_STATUSES_V
VIEW - OKC_SUBCLASSES_V
PACKAGE - OKC_UTIL
SYNONYM - OKI_SALES_K_HDRS
APPS.OKI_SALES_K_HEADERS_V is referenced by following:

APPS
VIEW - OKI_RNW_BY_STS_DTL_V

[top of page]

View: OKI_SALES_K_NEW_V

Comments
View Type

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

This view is a subset of the contracts in OKI_SALES_K_HEADERS_V, showing only those contracts that are "new", i.e. they are not renewal contracts.

Columns
Name Datatype Length Mandatory Comments
CONTRACT_ID NUMBER
Y The internal identifier of the contract.
CONTRACT_NUMBER VARCHAR2 (120)
Contract number for this contract.
CONTRACT_NUMBER_MODIFIER VARCHAR2 (120)
Contract number modifier for this contract.
COMPLETE_CONTRACT_NUMBER VARCHAR2 (241)
Concatenated contract number and modifier.
SHORT_DESCRIPTION VARCHAR2 (600)
Short description
ORDER_NUMBER VARCHAR2 (22)
Order number
AUTHORING_ORG_ID NUMBER

The internal identifier of the operating unit in which the contract was authored.
ORGANIZATION_NAME VARCHAR2 (240) Y The name of the operating unit in which the contract was authored.
SOB_ID NUMBER

Set of books id
CATEGORY_CODE VARCHAR2 (30)
The code of the contract category.
CATEGORY_MEANING VARCHAR2 (90) Y The user description for the contract category.
STATUS_CODE VARCHAR2 (30)
The code value representing the status of the contract.
STATUS_MEANING VARCHAR2 (90) Y The external description of the status of the contract.
STATUS_TYPE_CODE VARCHAR2 (30) Y The external description of the status type of the contract.
STATUS_TYPE_MEANING VARCHAR2 (80) Y The external description of the status type of the contract.
IS_NEW_YN VARCHAR2 (240)
Y - New contract N- Renewal contract
IS_LATEST_YN VARCHAR2 (1)
Latest renewal
ORIG_SYSTEM_SOURCE_CODE VARCHAR2 (30)
Original system source code
ORIG_SYSTEM_ID1 NUMBER

Original system id1
ORIG_SYSTEM_REFERENCE1 VARCHAR2 (30)
Original system reference1
CONTRACT_TYPE VARCHAR2 (30)
Contract type
CUSTOMER_PARTY_ID NUMBER

The internal party identifier of the contract customer.
CUSTOMER_NAME VARCHAR2 (360) Y The name of the customer in the contract.
CUSTOMER_NUMBER VARCHAR2 (30) Y Customer number
CONTRACT_AMOUNT NUMBER

The total amount of the contract, in the contract transaction currency.
FORECAST_AMOUNT NUMBER

The forecasted value of the contract.
CURRENCY_CODE VARCHAR2 (15)
The currency code of the contract transaction currency.
CONTRACT_AMOUNT_RENEWED NUMBER

The amount of the contract renewed by this contract, in the transaction currency.
CURRENCY_CODE_RENEWED VARCHAR2 (15)
The transaction currency code of the contract renewed by this contract.
SOB_CONTRACT_AMOUNT NUMBER

The amount of the contract, converted into the set of books currency.
SOB_FORECAST_AMOUNT NUMBER

The forecasted amount of this contract, converted into the set of books currency.
SOB_CONTRACT_AMOUNT_RENEWED NUMBER

The amount of the contract renewed by this contract, converted into the set of books currency.
SOB_CURRENCY_CODE VARCHAR2 (15)
The set of books currency code.
BASE_CONTRACT_AMOUNT NUMBER

The value of the contract, in the base currency.
BASE_FORECAST_AMOUNT NUMBER

The forecasted amount for the contract, in the base currency.
BASE_CONTRACT_AMOUNT_RENEWED NUMBER

The amount of the contract renewed by this contract, in the base currency.
BASE_CURRENCY_CODE VARCHAR2 (15)
The currency code of the base currency.
WIN_PERCENT NUMBER

The estimated percentage probability that the contract will be signed.
EXPECTED_CLOSE_DATE DATE

The date on which the contract is expected to be signed.
START_DATE DATE

The starting effective date of the contract.
END_DATE DATE

The ending effective date of the contract.
DURATION NUMBER

Duration of the contract
PERIOD VARCHAR2 (30)
Period code for the duration
DATE_APPROVED DATE

The date the contract was approved.
DATE_SIGNED DATE

The date the contract was signed.
DATE_RENEWED DATE

The date the contract was renewed.
DATE_CANCELED DATE

The date the contract was canceled.
DATE_TERMINATED DATE

The date the contract was terminated.
TERMINATED_AMOUNT NUMBER

Terminated amount
SOB_TERMINATED_AMOUNT NUMBER

Terminated amount in functional currency
BASE_TERMINATED_AMOUNT NUMBER

Terminated amount in base currency
START_PERIOD_NUM NUMBER (15)
The number of the General Ledger period in which the contract starts.
START_PERIOD_NAME VARCHAR2 (15)
The name of the General Ledger period in which the contract starts.
START_QUARTER NUMBER (15)
The General Ledger quarter in which the contract starts.
START_YEAR NUMBER (15)
The General Ledger year in which the contract starts.
CLOSE_PERIOD_NUM NUMBER (15)
The General Ledger period nunber in which the contract is expected to close.
CLOSE_PERIOD_NAME VARCHAR2 (15)
The General Ledger period name in which the contract is expected to close.
CLOSE_QUARTER NUMBER (15)
The General Ledger quarter in which the contract is expected to close.
CLOSE_YEAR NUMBER (15)
The General Ledger year in which the contract is expected to close.
TRN_CODE VARCHAR2 (30)
The contract termination reason code.
TERMINATION_MEANING VARCHAR2 (80)
The external description of the termination reason.
INVENTORY_ORGANIZATION_ID NUMBER

The internal identifier for the inventory organization.
APPLICATION_ID NUMBER

The internal identifier of the Oracle Application that created the contract.
CREATION_DATE DATE

Standard Who column
LAST_UPDATE_DATE DATE

Standard Who column.
ATTRIBUTE_CATEGORY VARCHAR2 (90)
Descriptive Flexfield structure defining column.
ATTRIBUTE1 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE2 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE3 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE4 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE5 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE6 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE7 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE8 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE9 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE10 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE11 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE12 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE13 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE14 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE15 VARCHAR2 (450)
Descriptive Flexfield segment column.
RENEWAL_TYPE_USED_CODE VARCHAR2 (10)
Renewal Type code used
RENEWAL_TYPES_USED VARCHAR2 (80)
Renewal Type Used Meaning

[top of page]

APPS.OKI_SALES_K_NEW_V references the following:

APPS
PACKAGE - FND_GLOBAL
VIEW - FND_LOOKUPS
SYNONYM - HR_ALL_ORGANIZATION_UNITS_TL
SYNONYM - HZ_PARTIES
SYNONYM - OKC_K_HEADERS_TL
VIEW - OKC_STATUSES_V
VIEW - OKC_SUBCLASSES_V
PACKAGE - OKC_UTIL
SYNONYM - OKI_SALES_K_HDRS

APPS.OKI_SALES_K_NEW_V is not referenced by any database object

[top of page]

View: OKI_SALES_K_RENEW_V

Comments
View Type

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

This view is a subset of OKI_SALES_K_HEADERS_V, showing those contracts that are renewal contracts. A contract is considered a renewal if it is created by the renewal process or it is used as the target of renewal consolidation.

Columns
Name Datatype Length Mandatory Comments
CONTRACT_ID NUMBER
Y The internal identifier of the contract.
CONTRACT_NUMBER VARCHAR2 (120)
Contract number for this contract.
CONTRACT_NUMBER_MODIFIER VARCHAR2 (120)
Contract number modifier for this contract.
COMPLETE_CONTRACT_NUMBER VARCHAR2 (241)
Concatenated contract number and modifier.
SHORT_DESCRIPTION VARCHAR2 (600)
Short description
ORDER_NUMBER VARCHAR2 (22)
Order number
AUTHORING_ORG_ID NUMBER

The internal identifier of the operating unit in which the contract was authored.
ORGANIZATION_NAME VARCHAR2 (240) Y The name of the operating unit in which the contract was authored.
SOB_ID NUMBER

Set of books id
CATEGORY_CODE VARCHAR2 (30)
The code of the contract category.
CATEGORY_MEANING VARCHAR2 (90) Y The user description for the contract category.
STATUS_CODE VARCHAR2 (30)
The code value representing the status of the contract.
STATUS_MEANING VARCHAR2 (90) Y The external description of the status of the contract.
STATUS_TYPE_CODE VARCHAR2 (30) Y The code value representing the status type of the contract, such as ACTIVE or ENTERED.
STATUS_TYPE_MEANING VARCHAR2 (80) Y The external description of the status type of the contract.
IS_NEW_YN VARCHAR2 (240)
Y - new contract N- Renewal contract
IS_LATEST_YN VARCHAR2 (1)
Latest YN flag
ORIG_SYSTEM_SOURCE_CODE VARCHAR2 (30)
Original system source code
ORIG_SYSTEM_ID1 NUMBER

Original system id1
ORIG_SYSTEM_REFERENCE1 VARCHAR2 (30)
Original system reference1
CONTRACT_TYPE VARCHAR2 (30)
Contract type
CUSTOMER_PARTY_ID NUMBER

The internal party identifier of the contract customer.
CUSTOMER_NAME VARCHAR2 (360) Y The name of the customer in the contract.
CUSTOMER_NUMBER VARCHAR2 (30) Y Customer number
CONTRACT_AMOUNT NUMBER

The total amount of the contract, in the contract transaction currency.
FORECAST_AMOUNT NUMBER

The forecasted value of the contract.
CURRENCY_CODE VARCHAR2 (15)
The currency code of the contract transaction currency.
CONTRACT_AMOUNT_RENEWED NUMBER

The amount of the contract renewed by this contract, in the transaction currency.
CURRENCY_CODE_RENEWED VARCHAR2 (15)
The transaction currency code of the contract renewed by this contract.
SOB_CONTRACT_AMOUNT NUMBER

The amount of the contract, converted into the set of books currency.
SOB_FORECAST_AMOUNT NUMBER

The forecasted amount of this contract, converted into the set of books currency.
SOB_CONTRACT_AMOUNT_RENEWED NUMBER

The amount of the contract renewed by this contract, converted into the set of books currency.
SOB_CURRENCY_CODE VARCHAR2 (15)
The set of books currency code.
WIN_PERCENT NUMBER

The estimated percentage probability that the contract will be signed.
EXPECTED_CLOSE_DATE DATE

The date on which the contract is expected to be signed.
BASE_CONTRACT_AMOUNT NUMBER

The value of the contract, in the base currency.
BASE_FORECAST_AMOUNT NUMBER

The forecasted amount for the contract, in the base currency.
BASE_CONTRACT_AMOUNT_RENEWED NUMBER

The amount of the contract renewed by this contract, in the base currency.
BASE_CURRENCY_CODE VARCHAR2 (15)
The currency code of the base currency.
START_DATE DATE

The starting effective date of the contract.
END_DATE DATE

The ending effective date of the contract.
DURATION NUMBER

Duration of the contract
PERIOD VARCHAR2 (30)
Period code for the duration
DATE_APPROVED DATE

The date the contract was approved.
DATE_SIGNED DATE

The date the contract was signed.
DATE_RENEWED DATE

The date the contract was renewed.
DATE_CANCELED DATE

The date the contract was canceled.
DATE_TERMINATED DATE

The date the contract was terminated.
TERMINATED_AMOUNT NUMBER

Terminated amount
SOB_TERMINATED_AMOUNT NUMBER

Terminated amount in functional currency
BASE_TERMINATED_AMOUNT NUMBER

Terminated amount in base currency
START_PERIOD_NUM NUMBER (15)
The number of the General Ledger period in which the contract starts.
START_PERIOD_NAME VARCHAR2 (15)
The name of the General Ledger period in which the contract starts.
START_QUARTER NUMBER (15)
The General Ledger quarter in which the contract starts.
START_YEAR NUMBER (15)
The General Ledger year in which the contract starts.
CLOSER_PERIOD_NUM NUMBER (15)
The General Ledger period nunber in which the contract is expected to close.
CLOSE_PERIOD_NAME VARCHAR2 (15)
The General Ledger period name in which the contract is expected to close.
CLOSE_QUARTER NUMBER (15)
The General Ledger quarter in which the contract is expected to close.
CLOSE_YEAR NUMBER (15)
The General Ledger year in which the contract is expected to close.
TRN_CODE VARCHAR2 (30)
The contract termination reason code.
TERMINATION_MEANING VARCHAR2 (80)
The external description of the termination reason.
INVENTORY_ORGANIZATION_ID NUMBER

The internal identifier for the inventory organization.
APPLICATION_ID NUMBER

The internal identifier of the Oracle Application that created the contract.
CREATION_DATE DATE

Standard Who column
LAST_UPDATE_DATE DATE

Standard Who column.
ATTRIBUTE_CATEGORY VARCHAR2 (90)
Descriptive Flexfield structure defining column.
ATTRIBUTE1 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE2 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE3 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE4 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE5 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE6 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE7 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE8 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE9 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE10 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE11 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE12 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE13 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE14 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE15 VARCHAR2 (450)
Descriptive Flexfield segment column.
RENEWAL_TYPE_USED_CODE VARCHAR2 (10)
Renewal Type Code Used
RENEWAL_TYPES_USED VARCHAR2 (80)
Renewal Type code meaning

[top of page]

APPS.OKI_SALES_K_RENEW_V references the following:

APPS
PACKAGE - FND_GLOBAL
VIEW - FND_LOOKUPS
SYNONYM - HR_ALL_ORGANIZATION_UNITS_TL
SYNONYM - HZ_PARTIES
SYNONYM - OKC_K_HEADERS_TL
VIEW - OKC_STATUSES_V
VIEW - OKC_SUBCLASSES_V
PACKAGE - OKC_UTIL
SYNONYM - OKI_SALES_K_HDRS
APPS.OKI_SALES_K_RENEW_V is referenced by following:

APPS
VIEW - OKI_RNW_BY_STS_DTL_V

[top of page]

View: OKI_SHIP_TO_ADDRS_V

Comments
View Type

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

This view shows the ship to addresses for contracts in OKI_SALES_K_HDRS. There may be multiple ship to addresses for the same contract.

Columns
Name Datatype Length Mandatory Comments
SITE_USE_ID NUMBER (15)
The internal identifier from HZ_CUST_SITE_USES_ALL
PARTY_SITE_ID NUMBER (15) Y The internal identifer for the party site referenced by this address.
LOCATION_ID NUMBER (15) Y The identifier from HZ_LOCATIONS for this location.
RULE_ID VARCHAR2 (0)
The internal identifier of the rule that holds this address.
CONTRACT_ID NUMBER
Y The contract header identifier for this address.
CONTRACT_LINE_ID NUMBER
Y The contract line identifier for this address, if at the line level.
CONTRACT_NUMBER VARCHAR2 (120)
Contract number for this contract.
CONTRACT_NUMBER_MODIFIER VARCHAR2 (120)
The contract number modifier in which this address is used.
LINE_NUMBER VARCHAR2 (150)
The external contract line number to which the address is associated, if at line level.
NAME VARCHAR2 (40) Y The name associated with the address.
COUNTRY VARCHAR2 (60) Y The country of the address.
ADDRESS1 VARCHAR2 (240) Y The first address line.
ADDRESS2 VARCHAR2 (240)
The second address line.
ADDRESS3 VARCHAR2 (240)
The third address line.
ADDRESS4 VARCHAR2 (240)
The fourth address line.
CITY VARCHAR2 (60)
The address city.
POSTAL_CODE VARCHAR2 (60)
The address postal code.
STATE VARCHAR2 (60)
The address state, if appropriate.
PROVINCE VARCHAR2 (60)
The address province, if appropriate.
COUNTY VARCHAR2 (60)
The address county, if appropriate.
FORMAT_ADDRESS VARCHAR2 (0)
The address formatted as a string.

[top of page]

APPS.OKI_SHIP_TO_ADDRS_V references the following:

APPS
PACKAGE - ARP_ADDR_LABEL_PKG
PACKAGE - OKC_UTIL
SYNONYM - OKI_SOLD_ITM_LINES
VIEW - OKX_CUST_SITE_USES_V

APPS.OKI_SHIP_TO_ADDRS_V is not referenced by any database object

[top of page]

View: OKI_SOLD_ITEM_LINES_V

Comments
View Type

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

A view over OKI_SOLD_ITM_LINES, containing language specific information.

Columns
Name Datatype Length Mandatory Comments
CONTRACT_LINE_ID NUMBER
Y Internal contract line identifier.
CONTRACT_ID NUMBER
Y The internal identifier of the contract for this top line.
CONTRACT_NUMBER VARCHAR2 (120)
Contract number for this contract.
CONTRACT_NUMBER_MODIFIER VARCHAR2 (120)
Contract number modifier for the contract in which this line appears.
COMPLETE_CONTRACT_NUMBER VARCHAR2 (241)
Concatenated contract number and modifier.
LINE_NUMBER VARCHAR2 (150)
External line number.
START_DATE DATE

The starting effective date of the line.
END_DATE DATE

The ending effective date of the line.
DURATION NUMBER

Duration of the line
PERIOD VARCHAR2 (30)
Period code for the duration
STS_CODE VARCHAR2 (30)
The code value representing the status type of the line, such as ACTIVE or ENTERED.
STATUS_MEANING VARCHAR2 (90) Y The external description of the status of the contract.
STATUS_TYPE_CODE VARCHAR2 (30)
Status type code
STATUS_TYPE_MEANING VARCHAR2 (80) Y Status type meaning
TRN_CODE VARCHAR2 (30)
The line termination reason code.
TERMINATION_MEANING VARCHAR2 (80)
The external description of the termination reason.
DATE_TERMINATED DATE

Date the line was terminated.
DATE_RENEWED DATE

The date the line was renewed.
NUMBER_OF_ITEMS NUMBER (15)
Number of covered items for the line.
UOM_CODE VARCHAR2 (3)
Unit of measure code for the number of items.
UNIT_PRICE NUMBER

Unit price for the sold item.
UNIT_PRICE_PERCENT NUMBER (6)
Percentage of the covered item price used to price the service, if percentage pricing of service is used.
PRICE_NEGOTIATED NUMBER

The line price as negotiated. The final price of the line.
CURRENCY_CODE VARCHAR2 (15)
The transaction currency code for the line.
PRICE_NEGOTIATED_RENEWED NUMBER

The negotiated price of the line renewed by this line.
CURRENCY_CODE_RENEWED VARCHAR2 (15)
The transaction currency code of the line renewed by this line.
SOB_PRICE_UNIT NUMBER

The unit price converted to the set of books currency.
SOB_PRICE_NEGOTIATED NUMBER

The negotiated price in the set of books currency.
SOB_PRICE_NEGOTIATED_RENEWED NUMBER

The price of the renewed line in the set of books currency.
SOB_CURRENCY_CODE VARCHAR2 (15)
The set of books currency code.
BASE_PRICE_UNIT NUMBER

Unit price for the line, in the base currency.
BASE_PRICE_NEGOTIATED NUMBER

The line price as negotiated, in the base currency.
BASE_PRICE_NEGOTIATED_RENEWED NUMBER

The line negotiated price of the line renewed by this line, in the base currency.
BASE_CURRENCY_CODE VARCHAR2 (15)
The currency code of the base currency.
SOLD_ITEM VARCHAR2 (240)
The description of the sold item.
ITEM_ID NUMBER

The item identifier from the item master for the sold item.
CONCATENATED_SEGMENTS VARCHAR2 (40)
Item segments
INVENTORY_ORGANIZATION_ID NUMBER

The internal identifier for the inventory organization.
CREATION_DATE DATE

Standard Who column
LAST_UPDATE_DATE DATE

Standard Who column.
ATTRIBUTE_CATEGORY VARCHAR2 (90)
Descriptive Flexfield structure defining column.
ATTRIBUTE1 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE2 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE3 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE4 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE5 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE6 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE7 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE8 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE9 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE10 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE11 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE12 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE13 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE14 VARCHAR2 (450)
Descriptive Flexfield segment column.
ATTRIBUTE15 VARCHAR2 (450)
Descriptive Flexfield segment column.

[top of page]

APPS.OKI_SOLD_ITEM_LINES_V references the following:

APPS
PACKAGE - FND_GLOBAL
VIEW - FND_LOOKUPS
VIEW - OKC_STATUSES_V
PACKAGE - OKC_UTIL
SYNONYM - OKI_SOLD_ITM_LINES
VIEW - OKX_SYSTEM_ITEMS_V

APPS.OKI_SOLD_ITEM_LINES_V is not referenced by any database object

[top of page]

View: OKI_WIP_BY_CUSTOMERS_V

Comments
View Type

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

A view over OKI_WIP_BY_CUSTOMERS, containing language specific information.

Columns
Name Datatype Length Mandatory Comments
ID NUMBER
Y The internal identifier for the row.
PERIOD_NAME VARCHAR2 (15) Y The name from General Ledger for the period of this information.
PERIOD_SET_NAME VARCHAR2 (15) Y The name of the General Ledger period set used to determine valid periods.
PERIOD_TYPE VARCHAR2 (15)
The type of General Ledger period used for this information.
AUTHORING_ORG_ID NUMBER

The internal identifier of the operating unit in which the contract was authored.
AUTHORING_ORG_NAME VARCHAR2 (240)
The name of the operating unit in which the contract was authored.
CUSTOMER_PARTY_ID NUMBER
Y The internal party identifier of the contract customer.
CUSTOMER_NAME VARCHAR2 (360)
The name of the customer in the contract.
SCS_CODE VARCHAR2 (30)
The category (sub-class) code for the contract.
BASE_FORECAST_AMOUNT NUMBER

The forecasted amount, in the base currency.
BASE_BOOKED_AMOUNT NUMBER

The sum of booked renewals, in the base currency.
BASE_LOST_AMOUNT NUMBER

The amount lost (not renewed), in the base currency.
REQUEST_ID NUMBER (15)
Concurrent Manager audit column.
PROGRAM_APPLICATION_ID NUMBER (15)
Concurrent Manager audit column.
PROGRAM_ID NUMBER (15)
Concurrent Manager audit column.
PROGRAM_UPDATE_DATE DATE

Concurrent Manager audit column.

[top of page]

APPS.OKI_WIP_BY_CUSTOMERS_V references the following:

APPS
SYNONYM - OKI_WIP_BY_CUSTOMERS

APPS.OKI_WIP_BY_CUSTOMERS_V is not referenced by any database object

[top of page]

View: OKI_YOY_RENEWAL_AMT_V

Comments
View Type

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

A view over OKI_YOY_RENEWAL_AMT, containing language specific information.

Columns
Name Datatype Length Mandatory Comments
ID NUMBER
Y The internal identifier for the row.
PERIOD_NAME VARCHAR2 (15) Y The name from General Ledger for the period of this information.
PERIOD_SET_NAME VARCHAR2 (15) Y The name of the General Ledger period set used to determine valid periods.
PERIOD_TYPE VARCHAR2 (15)
The type of General Ledger period used for this information.
AUTHORING_ORG_ID NUMBER
Y The internal identifier of the operating unit in which the contract was authored.
AUTHORING_ORG_NAME VARCHAR2 (240)
The name of the operating unit in which the contract was authored.
YEAR VARCHAR2 (4) Y The year of the summarization.
MONTH VARCHAR2 (30) Y The month value for the summation.
SCS_CODE VARCHAR2 (30)
The category (sub-class) code for the contract.
BASE_CONTRACT_AMOUNT NUMBER

The contract value, in the base currency.
REQUEST_ID NUMBER (15)
Concurrent Manager audit column.
PROGRAM_APPLICATION_ID NUMBER (15)
Concurrent Manager audit column.
PROGRAM_ID NUMBER (15)
Concurrent Manager audit column.
PROGRAM_UPDATE_DATE DATE

Concurrent Manager audit column.

[top of page]

APPS.OKI_YOY_RENEWAL_AMT_V references the following:

APPS
SYNONYM - OKI_YOY_RENEWAL_AMT

APPS.OKI_YOY_RENEWAL_AMT_V is not referenced by any database object

[top of page]
Copyright (c) 2001 - 2005, Oracle - Use Restricted by Contract