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

VIEW: APPS.OKC_CONDITION_LINES_HV

Object Details
Object Name: OKC_CONDITION_LINES_HV
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKC.OKC_CONDITION_LINES_HV
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


History view for OKC_CONDITION_LINES.


[View Source]

Columns
Name Datatype Length Mandatory Comments
START_AT NUMBER (10)
Start position.
ROW_ID ROWID (10)
The address of the row in the database
ID NUMBER
Yes Primary key column.
MAJOR_VERSION NUMBER (4) Yes The version of the contract for this history record.
OBJECT_VERSION_NUMBER NUMBER (9) Yes Sequential number set at 1 on insert and incremented on update. Used by APIs to ensure current record is passed.
SFWT_FLAG VARCHAR2 (3) Yes Indicates a value was changed in another language. Not fully implemented in 11i
CNH_ID NUMBER
Yes Foreign key to OKC_CONDITION_HEADERS_B.
PDF_ID NUMBER

Foreign key to OKC_PROCESS_DEFS_B.
AAE_ID NUMBER

Foreign key to OKC_ACTION_ATTRIBUTES_B.
LEFT_CTR_MASTER_ID NUMBER (15)
Surrogate key used for primary unique identifiers.
RIGHT_CTR_MASTER_ID NUMBER (15)
Surrogate key used for primary unique identifiers.
LEFT_COUNTER_ID NUMBER (15)
Surrogate key used for primary unique identifiers.
RIGHT_COUNTER_ID NUMBER (15)
Surrogate key used for primary unique identifiers.
DNZ_CHR_ID NUMBER

Contract ID. Denormalized for performance.
SORTSEQ NUMBER (10) Yes Serial Numbers.
CNL_TYPE VARCHAR2 (10) Yes Surrogate key used for primary unique identifiers.
DESCRIPTION VARCHAR2 (1995)
User entered free format text description.
LEFT_PARENTHESIS VARCHAR2 (90)
Left Parenthesis.
RELATIONAL_OPERATOR VARCHAR2 (36)
Relational operator.
RIGHT_PARENTHESIS VARCHAR2 (90)
Right parenthesis.
LOGICAL_OPERATOR VARCHAR2 (9)
Logical operator.
TOLERANCE NUMBER (10)
P or A
RIGHT_OPERAND VARCHAR2 (150)
Right operand.
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.
APPLICATION_ID NUMBER

Application Identifier
SEEDED_FLAG VARCHAR2 (3)
Indicates whether a record is seeded or not.
Query Text

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


SELECT START_AT
,      ROW_ID
,      ID
,      MAJOR_VERSION
,      OBJECT_VERSION_NUMBER
,      SFWT_FLAG
,      CNH_ID
,      PDF_ID
,      AAE_ID
,      LEFT_CTR_MASTER_ID
,      RIGHT_CTR_MASTER_ID
,      LEFT_COUNTER_ID
,      RIGHT_COUNTER_ID
,      DNZ_CHR_ID
,      SORTSEQ
,      CNL_TYPE
,      DESCRIPTION
,      LEFT_PARENTHESIS
,      RELATIONAL_OPERATOR
,      RIGHT_PARENTHESIS
,      LOGICAL_OPERATOR
,      TOLERANCE
,      RIGHT_OPERAND
,      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
,      APPLICATION_ID
,      SEEDED_FLAG
FROM APPS.OKC_CONDITION_LINES_HV;

Dependencies

[top of page]

APPS.OKC_CONDITION_LINES_HV references the following:

SchemaAPPS
SynonymOKC_CONDITION_LINES_BH
SynonymOKC_CONDITION_LINES_TLH
APPS.OKC_CONDITION_LINES_HV is referenced by following:

SchemaAPPS
Package BodyOKC_COPY_CONTRACT_PVT - show dependent code