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

TABLE: QP.QP_UI_QUERY_COLUMNS

Object Details
Object Name: QP_UI_QUERY_COLUMNS
Object Type: TABLE
Owner: QP
FND Design Data: TableQP.QP_UI_QUERY_COLUMNS
Subobject Name:
Status: VALID


This table is used to save the name-value pairs for columns (to be binded) being used in the query where clause, stored in master table qp_ui_queries_tl


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
COLUMN_ID NUMBER
Yes primary key for the table
QUERY_ID NUMBER
Yes Foreign key to master table qp_ui_queries_tl
QUERY_COLUMN_INDEX_ID NUMBER

Unique number assigned to a column name in the where clause
COLUMN_NAME VARCHAR2 (240) Yes Name of the column in the where clause to be binded
COLUMN_VALUE VARCHAR2 (2000) Yes Value to be binded for the column name in the where clause
COLUMN_TYPE VARCHAR2 (200) Yes Datatype of the column value, like VARCHAR, DATE, NUMBER etc
CREATION_DATE DATE
Yes Standard WHO Column
CREATED_BY NUMBER
Yes Standard WHO Column
LAST_UPDATE_DATE DATE
Yes Standard WHO Column
LAST_UPDATED_BY NUMBER
Yes Standard WHO Column
LAST_UPDATE_LOGIN NUMBER

Standard WHO Column
Query Text

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


SELECT COLUMN_ID
,      QUERY_ID
,      QUERY_COLUMN_INDEX_ID
,      COLUMN_NAME
,      COLUMN_VALUE
,      COLUMN_TYPE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM QP.QP_UI_QUERY_COLUMNS;

Dependencies

[top of page]

QP.QP_UI_QUERY_COLUMNS does not reference any database object

QP.QP_UI_QUERY_COLUMNS is referenced by following:

SchemaQP
ViewQP_UI_QUERY_COLUMNS#