Skip to content

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

TABLE: QP.QP_UI_QUERIES_TL

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


This table is used to save the query when user saves a query criteria on the Pricing Organizer.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
QUERY_ID NUMBER
Yes The Primary Key for the table
NAME VARCHAR2 (240) Yes Name given to a query while saving on the Pricing Organizer
HEADER_WHERE VARCHAR2 (4000)
Query where clause to be used for view qp_list_summary_vl
LINES_WHERE VARCHAR2 (4000)
Query where clause to be used for view qp_lines_summary_vl
PUBLIC_FLAG VARCHAR2 (1) Yes Flag to indicate whether the saved query is for public folders
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
LANGUAGE VARCHAR2 (4) Yes Translated language (currently same as source_lang)
SOURCE_LANG VARCHAR2 (4) Yes User environment language while saving the query
DELETE_FLAG VARCHAR2 (1)
Flag to indicate whether the saved query has been logically deleted
Query Text

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


SELECT QUERY_ID
,      NAME
,      HEADER_WHERE
,      LINES_WHERE
,      PUBLIC_FLAG
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      LANGUAGE
,      SOURCE_LANG
,      DELETE_FLAG
FROM QP.QP_UI_QUERIES_TL;

Dependencies

[top of page]

QP.QP_UI_QUERIES_TL does not reference any database object

QP.QP_UI_QUERIES_TL is referenced by following:

SchemaQP
ViewQP_UI_QUERIES_TL#