[Home] [Help] [Dependency Information]
Object Name: | OKL_OPT_RULE_VALUES_UV |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OKL.OKL_OPT_RULE_VALUES_UV |
Subobject Name: | |
Status: | VALID |
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.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ID | NUMBER | Yes | Primary key column | |
ORL_ID | NUMBER | Yes | Foreign key to view OKL_OPT_RULES_V | |
OVE_ID | NUMBER | Yes | Foreign key to view OKL_OPT_VALUES_V | |
LSE_ID | VARCHAR2 | (0) | ||
LINE_STYLE | VARCHAR2 | (0) | ||
SRD_ID | NUMBER | |||
SUBCLASS | VARCHAR2 | (30) | Yes | |
RULE_GROUP | VARCHAR2 | (30) | Yes | |
RULE | VARCHAR2 | (30) | Yes | |
CONCATENATED_RULE | VARCHAR2 | (92) | ||
INTENT_DESCR | VARCHAR2 | (4000) | ||
CPY_OR_ENT_DESCR | VARCHAR2 | (4000) | ||
MEANING | VARCHAR2 | (4000) | ||
CONTEXT_ORG_NAME | VARCHAR2 | (240) | ||
CONTEXT_INV_ORG_NAME | VARCHAR2 | (240) | ||
OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | Column used for locking records during updates |
CONTEXT_INTENT | VARCHAR2 | (30) | Yes | |
INDIVIDUAL_INSTRUCTIONS | VARCHAR2 | (1995) | ||
COPY_OR_ENTER_FLAG | VARCHAR2 | (30) | Yes | |
CONTEXT_ORG | NUMBER | |||
CONTEXT_INV_ORG | NUMBER | |||
CONTEXT_ASSET_BOOK | VARCHAR2 | (15) | ||
START_DATE | DATE | Yes | Start Date | |
END_DATE | DATE | End Date |
Cut, paste (and edit) the following text to query this object:
SELECT ID
, ORL_ID
, OVE_ID
, LSE_ID
, LINE_STYLE
, SRD_ID
, SUBCLASS
, RULE_GROUP
, RULE
, CONCATENATED_RULE
, INTENT_DESCR
, CPY_OR_ENT_DESCR
, MEANING
, CONTEXT_ORG_NAME
, CONTEXT_INV_ORG_NAME
, OBJECT_VERSION_NUMBER
, CONTEXT_INTENT
, INDIVIDUAL_INSTRUCTIONS
, COPY_OR_ENTER_FLAG
, CONTEXT_ORG
, CONTEXT_INV_ORG
, CONTEXT_ASSET_BOOK
, START_DATE
, END_DATE
FROM APPS.OKL_OPT_RULE_VALUES_UV;
APPS.OKL_OPT_RULE_VALUES_UV is not referenced by any database object
|
|
|