[Home] [Help] [Dependency Information]
Object Name: | OKL_PDT_OPTS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OKL.OKL_PDT_OPTS_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
DEFINITION
After product is defined a set of options can be assigned to the contracts of that product.These
options may be mandatory or optional depending on required flag.This is an association between Product and Option entity
EXAMPLE
Product Options
----------------------------------------------
USDF Evergreen
Tax Ownership
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 |
OPT_ID | NUMBER | Yes | Foreign key to table OKL_OPTIONS | |
PDT_ID | NUMBER | Yes | Foreign key to table OKL_PRODUCTS | |
FROM_DATE | DATE | Yes | From date | |
TO_DATE | DATE | To date | ||
OPTIONAL_YN | VARCHAR2 | (3) | Yes | Indicates whether an optin is mandatory or optional. |
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
, OPT_ID
, PDT_ID
, FROM_DATE
, TO_DATE
, OPTIONAL_YN
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM APPS.OKL_PDT_OPTS_V;
|
|
|