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]

VIEW: APPS.QPBV_FORMULA_LINES

Object Details

Object Name:	QPBV_FORMULA_LINES
Object Type:	VIEW
Owner:	APPS
FND Design Data:	QP.QPBV_FORMULA_LINES
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

This gives information about formula lines.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
PRICE_FORMULA_LINE_ID	NUMBER		Yes
PRICE_FORMULA_ID	NUMBER		Yes
PRICE_FORMULA_LINE_TYPE_CODE	VARCHAR2	(30)
PRICE_LIST_LINE_ID	NUMBER
PRICE_MODIFIER_LIST_ID	NUMBER
PRICING_ATTRIBUTE_CONTEXT	VARCHAR2	(30)
PRICING_ATTRIBUTE	VARCHAR2	(30)
START_DATE_ACTIVE	DATE
END_DATE_ACTIVE	DATE
STEP_NUMBER	NUMBER		Yes
NUMERIC_CONSTANT	NUMBER
CREATION_DATE	DATE		Yes
CREATED_BY	NUMBER		Yes
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER		Yes
REQD_FLAG	VARCHAR2	(1)		Flag to indicate if a formula step is mandatory or not.
SEEDED_FLAG	VARCHAR2	(1)		Flag to identify the seeded data

Query Text

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


SELECT PRICE_FORMULA_LINE_ID
,      PRICE_FORMULA_ID
,      PRICE_FORMULA_LINE_TYPE_CODE
,      PRICE_LIST_LINE_ID
,      PRICE_MODIFIER_LIST_ID
,      PRICING_ATTRIBUTE_CONTEXT
,      PRICING_ATTRIBUTE
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      STEP_NUMBER
,      NUMERIC_CONSTANT
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      REQD_FLAG
,      SEEDED_FLAG
FROM APPS.QPBV_FORMULA_LINES;

Dependencies

[top of page]

APPS.QPBV_FORMULA_LINES references the following:

APPS: QP_PRICE_FORMULA_LINES

APPS.QPBV_FORMULA_LINES is not referenced by any database object