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

VIEW: APPS.OKL_OPT_RULES_V

Object Details
Object Name: OKL_OPT_RULES_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKL.OKL_OPT_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 Rules with Option,this is where we setup all the rules against each option.
Association specifying what set of subclass-rulegroup definition-ruledefinition
EXAMPLE
Options Rule
Tax Ownership LATOWN


[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Row Identifier in the database
ID NUMBER
Yes Primary key column
OBJECT_VERSION_NUMBER NUMBER (9) Yes Column used for locking records during updates
OPT_ID NUMBER
Yes Foreign key to table OKL_OPTIONS
SRD_ID_FOR NUMBER

Foreign Key to OKC_SUBCLASS_RG_DEFS
RGR_RGD_CODE VARCHAR2 (30) Yes Foreign Key to OKC_RG_DEF_RULES
RGR_RDF_CODE VARCHAR2 (30) Yes Foreign Key to OKC_RG_DEF_RULES
LRG_LSE_ID NUMBER

Foreign Key to OKC_LSE_RULE_GROUPS
LRG_SRD_ID NUMBER

Foreign Key to OKC_LSE_RULE_GROUPS
OVERALL_INSTRUCTIONS VARCHAR2 (1995)
A general description
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
,      OBJECT_VERSION_NUMBER
,      OPT_ID
,      SRD_ID_FOR
,      RGR_RGD_CODE
,      RGR_RDF_CODE
,      LRG_LSE_ID
,      LRG_SRD_ID
,      OVERALL_INSTRUCTIONS
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM APPS.OKL_OPT_RULES_V;

Dependencies

[top of page]

APPS.OKL_OPT_RULES_V references the following:

SchemaAPPS
SynonymOKL_OPT_RULES
APPS.OKL_OPT_RULES_V is referenced by following:

SchemaAPPS
PL/SQL PackageOKL_ORL_PVT - show dependent code
Package BodyOKL_ORL_PVT - show dependent code
Package BodyOKL_OVD_PVT - show dependent code
Package BodyOKL_SETUPOPTIONS_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