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

TABLE: OKE.OKE_SEARCH_CRITERIA

Object Details
Object Name: OKE_SEARCH_CRITERIA
Object Type: TABLE
Owner: OKE
FND Design Data: TableOKE.OKE_SEARCH_CRITERIA
Subobject Name:
Status: VALID


User defined query criteria are stored and refreshed every time a new search name is defined. Up to five entries will be kept for retrieval.Data refresh follow FIFO rule.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
SEARCH_ID NUMBER
Yes Unique identifier of search criteria
NAME VARCHAR2 (120) Yes Search criteria name
USER_ID NUMBER
Yes Unique identifier of user who owns the record
FORM_ID NUMBER

Unique identifier of form against which this search criteria is saved
WHERE_CLAUSE VARCHAR2 (3900)
SQL where clause representing the current search criteria
CREATED_BY NUMBER
Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER
Yes Standard Who column
LAST_UPDATE_DATE DATE
Yes Standard Who column
Query Text

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


SELECT SEARCH_ID
,      NAME
,      USER_ID
,      FORM_ID
,      WHERE_CLAUSE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
FROM OKE.OKE_SEARCH_CRITERIA;

Dependencies

[top of page]

OKE.OKE_SEARCH_CRITERIA does not reference any database object

OKE.OKE_SEARCH_CRITERIA is referenced by following:

SchemaOKE
ViewOKE_SEARCH_CRITERIA#