[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | OKL_PRODUCTS |
|---|---|
| Object Type: | TABLE |
| Owner: | OKL |
| FND Design Data: |  OKL.OKL_PRODUCTS
|
| Subobject Name: | |
| Status: | VALID |
DEFINITION
Products are defined to characterize the basics of a contract. The characteristics for this are defined from the following:
- Assign a product template to inherit basic characteristics
- Assign a value for each of the product qualities assigned to the product template
- Assign accounting template set to define the accounting rules to be used for the contract that uses this product
- Assign the options and also their corresponding valid option values for later assignment during the contract authoring process
EXAMPLE
Operating Lease, Capital Lease - Tax, Capital Lease - Non Tax etc.
MISCELLANEOUS
To reduce the data setup during the contract authoring time, all the static information is grouped and setup one time as Product.
The setup for Product includes the following:
Template Quality and Values
Product Quality and Values
Option and Values
Product Template
Product
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| OKL_PRODUCTS_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 ID
|
| OKL_PRODUCTS_U2 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
NAME
VERSION
|
| PDT_AES_FK_I | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
AES_ID
|
| PDT_PTL_FK_I | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
PTL_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ID | NUMBER | Yes | Primary key column | |
| NAME | VARCHAR2 | (150) | Yes | Primary key column |
| AES_ID | NUMBER | Yes | Foreign key to table OKL_AE_TMPT_SETS | |
| PTL_ID | NUMBER | Foreign key to table OKL_PDT_TEMPLATES | ||
| LEGACY_PRODUCT_YN | VARCHAR2 | (3) | Yes | Specify whether this is the new product or a product due to conversion from another system. |
| VERSION | VARCHAR2 | (24) | Yes | Version |
| OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | Column used for locking records during updates |
| DESCRIPTION | VARCHAR2 | (1995) | User entered description | |
| FROM_DATE | DATE | Yes | From date | |
| TO_DATE | DATE | To date | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | (90) | Descriptive flexfield category column | |
| ATTRIBUTE1 | VARCHAR2 | (450) | Descriptive flexfield column | |
| ATTRIBUTE2 | VARCHAR2 | (450) | Descriptive flexfield column | |
| ATTRIBUTE3 | VARCHAR2 | (450) | Descriptive flexfield column | |
| ATTRIBUTE4 | VARCHAR2 | (450) | Descriptive flexfield column | |
| ATTRIBUTE5 | VARCHAR2 | (450) | Descriptive flexfield column | |
| ATTRIBUTE6 | VARCHAR2 | (450) | Descriptive flexfield column | |
| ATTRIBUTE7 | VARCHAR2 | (450) | Descriptive flexfield column | |
| ATTRIBUTE8 | VARCHAR2 | (450) | Descriptive flexfield column | |
| ATTRIBUTE9 | VARCHAR2 | (450) | Descriptive flexfield column | |
| ATTRIBUTE10 | VARCHAR2 | (450) | Descriptive flexfield column | |
| ATTRIBUTE11 | VARCHAR2 | (450) | Descriptive flexfield column | |
| ATTRIBUTE12 | VARCHAR2 | (450) | Descriptive flexfield column | |
| ATTRIBUTE13 | VARCHAR2 | (450) | Descriptive flexfield column | |
| ATTRIBUTE14 | VARCHAR2 | (450) | Descriptive flexfield column | |
| ATTRIBUTE15 | VARCHAR2 | (450) | Descriptive flexfield column | |
| CREATED_BY | NUMBER | (15) | Yes | Standard who column |
| CREATION_DATE | DATE | Yes | Standard who column | |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column |
| LAST_UPDATE_DATE | DATE | Yes | Standard who column | |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
| REPORTING_PDT_ID | NUMBER | Specifies the reporting product for a given product. | ||
| PRODUCT_STATUS_CODE | VARCHAR2 | (30) | Product status code, that says if the product is valid or not. |
Cut, paste (and edit) the following text to query this object:
SELECT ID
, NAME
, AES_ID
, PTL_ID
, LEGACY_PRODUCT_YN
, VERSION
, OBJECT_VERSION_NUMBER
, DESCRIPTION
, FROM_DATE
, TO_DATE
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, REPORTING_PDT_ID
, PRODUCT_STATUS_CODE
FROM OKL.OKL_PRODUCTS;
OKL.OKL_PRODUCTS does not reference any database object
OKL.OKL_PRODUCTS is referenced by following:
APPS
OKL_PRODUCTS
|
|
|
|