[Home] [Help] [Dependency Information]
Object Name: | OKL_PRODUCTS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OKL.OKL_PRODUCTS_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
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
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Row Identifier in the database | |
ID | NUMBER | Yes | Primary key column | |
OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | Column used for locking records during updates |
AES_ID | NUMBER | Yes | Foreign key to table OKL_AE_TMPT_SETS | |
PTL_ID | NUMBER | Foreign key to table OKL_PDT_TEMPLATES | ||
NAME | VARCHAR2 | (150) | Yes | Primary key column |
DESCRIPTION | VARCHAR2 | (1995) | User entered description | |
LEGACY_PRODUCT_YN | VARCHAR2 | (3) | Yes | Specify whether this is the new product or a product due to conversion from another system. |
FROM_DATE | DATE | Yes | From date | |
VERSION | VARCHAR2 | (24) | Yes | Version |
TO_DATE | DATE | To date | ||
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. | |
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 |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, ID
, OBJECT_VERSION_NUMBER
, AES_ID
, PTL_ID
, NAME
, DESCRIPTION
, LEGACY_PRODUCT_YN
, FROM_DATE
, VERSION
, TO_DATE
, REPORTING_PDT_ID
, PRODUCT_STATUS_CODE
, 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
FROM APPS.OKL_PRODUCTS_V;
|
|
|