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

VIEW: APPS.OKL_OPV_RULES_V

Object Details
Object Name: OKL_OPV_RULES_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKL.OKL_OPV_RULES_V
Subobject Name:
Status: VALID

View Type

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


DEFINITION
Holds the association of Option Values with Rules
Valid values for the option rule.
EXAMPLE
Option Value Rule
Tax Ownership Lessor LATOWN


[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Row Identifier in the database
ID NUMBER
Yes Primary key column
CONTEXT_INTENT VARCHAR2 (30) Yes Intent for the Option Value Rule. Two possible value B/S indicating Buy/Sell
OBJECT_VERSION_NUMBER NUMBER (9) Yes Column used for locking records during updates
ORL_ID NUMBER
Yes Foreign key to table OKL_OPT_RULES
OVE_ID NUMBER
Yes Foreign key to table OKL_OPT_VALUES
INDIVIDUAL_INSTRUCTIONS VARCHAR2 (1995)
A general description of something
COPY_OR_ENTER_FLAG VARCHAR2 (30) Yes Indicates whether the template is copied directly to contract or is data entry required
CONTEXT_ORG NUMBER

Context Organization
CONTEXT_INV_ORG NUMBER

Context Inventory Organization
CONTEXT_ASSET_BOOK VARCHAR2 (15)
Context Asset Book
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 ROW_ID
,      ID
,      CONTEXT_INTENT
,      OBJECT_VERSION_NUMBER
,      ORL_ID
,      OVE_ID
,      INDIVIDUAL_INSTRUCTIONS
,      COPY_OR_ENTER_FLAG
,      CONTEXT_ORG
,      CONTEXT_INV_ORG
,      CONTEXT_ASSET_BOOK
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM APPS.OKL_OPV_RULES_V;

Dependencies

[top of page]

APPS.OKL_OPV_RULES_V references the following:

SchemaAPPS
SynonymOKL_OPV_RULES
APPS.OKL_OPV_RULES_V is referenced by following:

SchemaAPPS
Package BodyOKL_OPTION_RULES_PVT - show dependent code
PL/SQL PackageOKL_OVD_PVT - show dependent code
Package BodyOKL_OVD_PVT - show dependent code
Package BodyOKL_OVT_PVT - show dependent code
Package BodyOKL_SETUPOPTRULES_PVT - show dependent code
Package BodyOKL_SETUPOPTVALUES_PVT - show dependent code
Package BodyOKL_SETUPOVDTEMPLATES_PVT - show dependent code
Package BodyOKL_SETUPOVERULES_PVT - show dependent code