[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | OKL_CRITERIA_B |
|---|---|
| Object Type: | TABLE |
| Owner: | OKL |
| FND Design Data: |  OKL.OKL_CRITERIA_B
|
| Subobject Name: | |
| Status: | VALID |
DEFINITION
parameters, the values of which, define the possible CASE in a CASE SET
EXAMPLE
in determining the answer to the question "what is the purchase option amount"
the possible CASE may be described by the possible values of
a) the product
b) the option type
c) the asset category
MISCELLANEOUS
DEFINITION
parameters, the values of which, are limited by a value set
EXAMPLE
the possible values of "product" say
are to be found in another (possibly external) application table
or may be a user defined list of values
MISCELLANEOUS
a criterion for which the user supplies only a jtf object which returns the list of valid values
a criterion which the user supplies a list of valid values
and a jtf object which will return values from the correct list
DEFINITION
parameters, the values of which are not limited by any list of validating values
but are entered directly into the case set criterion value by the user
EXAMPLE
the possible values of "interest rate" say
may be a continuum of numbers
MISCELLANEOUS
| Tablespace: |  APPS_TS_ARCHIVE |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| OKL_CRITERIA_B_U1 | NORMAL | UNIQUE |
APPS_TS_ARCHIVE
|
 ID
|
| CRN_JTOT_FK_I | NORMAL | NONUNIQUE |
APPS_TS_ARCHIVE
|
JTF_OBJECT_CODE
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ID | NUMBER | Yes | Primary key column | |
| DATA_TYPE_CODE | VARCHAR2 | (30) | Data Type | |
| JTF_OBJECT_CODE | VARCHAR2 | (30) | JTF Object | |
| CRN_TYPE | VARCHAR2 | (10) | Yes | Freeform or Lookup |
| OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | Column used for locking records during updates |
| 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 ID
, DATA_TYPE_CODE
, JTF_OBJECT_CODE
, CRN_TYPE
, OBJECT_VERSION_NUMBER
, 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 OKL.OKL_CRITERIA_B;
OKL.OKL_CRITERIA_B does not reference any database object
OKL.OKL_CRITERIA_B is referenced by following:
OKL
OKL_CRITERIA_B#
|
|
|
|