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

VIEW: APPS.QPFV_FORMULA_LINES

Object Details
Object Name: QPFV_FORMULA_LINES
Object Type: VIEW
Owner: APPS
FND Design Data: ViewQP.QPFV_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_LIST_LINE_ID NUMBER

PRICE_MODIFIER_LIST_ID NUMBER

PRICING_ATTRIBUTE_CONTEXT VARCHAR2 (30)
PRICING_ATTRIBUTE VARCHAR2 (4000)
START_DATE_ACTIVE DATE

END_DATE_ACTIVE DATE

STEP_NUMBER NUMBER
Yes
NUMERIC_CONSTANT NUMBER

PRICE_FORMULA_LINE_TYPE_CODE VARCHAR2 (30)
_LA:FORMULA_LINE_TYPE_CODE CHAR (80)
CREATION_DATE DATE
Yes
CREATED_BY NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
_DF CHAR (52)
Descriptive Flexfield column values of qp_price_formula_lines table.
REQD_FLAG VARCHAR2 (1)
SEEDED_FLAG VARCHAR2 (1)
Query Text

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


SELECT PRICE_FORMULA_LINE_ID
,      PRICE_FORMULA_ID
,      PRICE_LIST_LINE_ID
,      PRICE_MODIFIER_LIST_ID
,      PRICING_ATTRIBUTE_CONTEXT
,      PRICING_ATTRIBUTE
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      STEP_NUMBER
,      NUMERIC_CONSTANT
,      PRICE_FORMULA_LINE_TYPE_CODE
,      _LA:FORMULA_LINE_TYPE_CODE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      _DF
,      REQD_FLAG
,      SEEDED_FLAG
FROM APPS.QPFV_FORMULA_LINES;

Dependencies

[top of page]

APPS.QPFV_FORMULA_LINES references the following:

SchemaAPPS
SynonymQP_PRICE_FORMULA_LINES
PL/SQL PackageQP_QP_FORM_PRICING_ATTR - show dependent code

APPS.QPFV_FORMULA_LINES is not referenced by any database object