eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: QP.QP_LIST_HEADER_PHASES

Object Details

Object Name:	QP_LIST_HEADER_PHASES
Object Type:	TABLE
Owner:	QP
FND Design Data:	QP.QP_LIST_HEADER_PHASES
Subobject Name:
Status:	VALID

This table stores all the current phases for a list header for Pricing Engine performance

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
QP_LIST_HEADER_PHASES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	PRICING_PHASE_ID LIST_HEADER_ID PRIC_PROD_ATTR_ONLY_FLAG

Columns

Name	Datatype	Length	Mandatory	Comments
LIST_HEADER_ID	NUMBER		Yes	Reference to QP_LIST_HEADERS_B. LIST_HEADER_ID
PRICING_PHASE_ID	NUMBER		Yes	Identifier for the Pricing Phase.
QUALIFIER_FLAG	VARCHAR2	(1)		Indicates whether the LIST_HEADER_ID in this table has line level qualifiers.
CREATION_DATE	DATE			Standard Who Column
CREATED_BY	NUMBER			Standard Who Column
LAST_UPDATE_DATE	DATE			Standard Who Column
LAST_UPDATED_BY	NUMBER			Standard Who Column
LAST_UPDATE_LOGIN	NUMBER			Standard Who Column
PRIC_PROD_ATTR_ONLY_FLAG	VARCHAR2	(1)	Yes

Query Text

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


SELECT LIST_HEADER_ID
,      PRICING_PHASE_ID
,      QUALIFIER_FLAG
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      PRIC_PROD_ATTR_ONLY_FLAG
FROM QP.QP_LIST_HEADER_PHASES;

Dependencies

[top of page]

QP.QP_LIST_HEADER_PHASES does not reference any database object

QP.QP_LIST_HEADER_PHASES is referenced by following:

QP: QP_LIST_HEADER_PHASES#