DBA Data[Home] [Help] [Dependency Information]


TABLE: OKL.OKL_ANSR_CRTRN_VALS

Object Details
Object Name: OKL_ANSR_CRTRN_VALS
Object Type: TABLE
Owner: OKL
FND Design Data: TableOKL.OKL_ANSR_CRTRN_VALS
Subobject Name:
Status: VALID


DEFINITION
a relationship or associative entity
associating a CASE with a particular combination of allowed values of allowed CRITERION
thus in fact defining the CASE
allowance is made in the model for from-to ranges
EXAMPLE
if a CASE SET is defined to have 2 allowed CRITERION
and these are defined to have 2 allowed values each
then each CASE will have a pair of allowed CRITERION VALUE
and there will be 2x2=4 (the cross product, in general n1xn2xn3 ...) possible CASE in the CASE SET
MISCELLANEOUS


Storage Details
Tablespace: TablespaceAPPS_TS_ARCHIVE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
OKL_ANSR_CRTRN_VALS_U1 NORMAL UNIQUE TablespaceAPPS_TS_ARCHIVE ColumnID
OKL_ANSR_CRTRN_VALS_U2 NORMAL UNIQUE TablespaceAPPS_TS_ARCHIVE ColumnAWR_ID
ColumnASR_ID
ACV_ASR_FK_I NORMAL NONUNIQUE TablespaceAPPS_TS_ARCHIVE ColumnASR_ID
ACV_ASV_FK_I NORMAL NONUNIQUE TablespaceAPPS_TS_ARCHIVE ColumnASV_ID
Columns
Name Datatype Length Mandatory Comments
ID NUMBER
Yes Primary key column
AWR_ID NUMBER
Yes Foreign key to table OKL_ANSWERS
ASR_ID NUMBER
Yes Foreign key to table OKL_ANSR_SET_CRTRIA_B
ASV_ID NUMBER
Yes Foreign key to table OKL_ANSR_SET_CN_VLS
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
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ID
,      AWR_ID
,      ASR_ID
,      ASV_ID
,      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_ANSR_CRTRN_VALS;

Dependencies

[top of page]

OKL.OKL_ANSR_CRTRN_VALS does not reference any database object

OKL.OKL_ANSR_CRTRN_VALS is referenced by following:

SchemaOKL
ViewOKL_ANSR_CRTRN_VALS#