[Home] [Help]
[Dependency Information]
| Object Name: | OKL_CTXPRMS_SERCH_UV |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: | OKL.OKL_CTXPRMS_SERCH_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 | |
| NAME | VARCHAR2 | (150) | Yes | Name |
| DESCRIPTION | VARCHAR2 | (1995) | User entered description | |
| CGR_ID | NUMBER | Yes | Foreign key to view OKL_CONTEXT_GROUPS_V | |
| PMR_ID | NUMBER | Yes | Foreign key to view OKL_PARAMETERS_V | |
| DATATYPE | VARCHAR2 | (150) | Yes | The data type of the parameter like CHAR, NUMBER, DATE |
Cut, paste (and edit) the following text to query this object:
SELECT ID
, NAME
, DESCRIPTION
, CGR_ID
, PMR_ID
, DATATYPE
FROM APPS.OKL_CTXPRMS_SERCH_UV;
APPS
OKL_CNTX_GRP_PRMTRS
OKL_CONTEXT_GROUPS_B
OKL_PARAMETERS_B
OKL_PARAMETERS_TL
APPS.OKL_CTXPRMS_SERCH_UV is not referenced by any database object
|
|
|
|