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

VIEW: APPS.OKC_TERMS_SECTIONS_V

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

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
The address of the row in the database
ID NUMBER
Yes Surrogate key used for primary unique identifiers
DOCUMENT_TYPE VARCHAR2 (30) Yes Document type. foreign key to okc_bus_doc_types_b
DOCUMENT_ID NUMBER
Yes Business document identifier. Foreign key to various business document header tables
SECTION_SEQUENCE NUMBER

Sequence number of the section
LABEL VARCHAR2 (60)
Section Label
HEADING VARCHAR2 (300)
Section Heading
SCN_ID NUMBER

Surrogate key used for primary unique identifiers
SCN_CODE VARCHAR2 (30)
section identifier
AMENDMENT_DESCRIPTION VARCHAR2 (2000)
Text to capture amendment description at section level
AMENDMENT_OPERATION_CODE VARCHAR2 (30)
Amendment opration performed for the section. Allowed operations are INSERT, CHANGE, DELETE
ORIG_SYSTEM_REFERENCE_CODE VARCHAR2 (30)
This will preserve the code for migrated systems such as FAR, OKCMIGR
ORIG_SYSTEM_REFERENCE_ID1 NUMBER

This will preserve id for migrated systems
ORIG_SYSTEM_REFERENCE_ID2 NUMBER

This will preserve id for migrated systems
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.
PRINT_YN VARCHAR2 (1)
Flag to indicate to print the section
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.
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.
LAST_AMENDED_BY NUMBER

LAST_AMENDMENT_DATE DATE

Query Text

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


SELECT ROW_ID
,      ID
,      DOCUMENT_TYPE
,      DOCUMENT_ID
,      SECTION_SEQUENCE
,      LABEL
,      HEADING
,      SCN_ID
,      SCN_CODE
,      AMENDMENT_DESCRIPTION
,      AMENDMENT_OPERATION_CODE
,      ORIG_SYSTEM_REFERENCE_CODE
,      ORIG_SYSTEM_REFERENCE_ID1
,      ORIG_SYSTEM_REFERENCE_ID2
,      OBJECT_VERSION_NUMBER
,      PRINT_YN
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      LAST_AMENDED_BY
,      LAST_AMENDMENT_DATE
FROM APPS.OKC_TERMS_SECTIONS_V;

Dependencies

[top of page]

APPS.OKC_TERMS_SECTIONS_V references the following:

SchemaAPPS
SynonymOKC_SECTIONS_B

APPS.OKC_TERMS_SECTIONS_V is not referenced by any database object