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


VIEW: APPS.QPFV_FACTOR_ASSO_PRICING_ATTRS

Object Details
Object Name: QPFV_FACTOR_ASSO_PRICING_ATTRS
Object Type: VIEW
Owner: APPS
FND Design Data: ViewQP.QPFV_FACTOR_ASSO_PRICING_ATTRS
Subobject Name:
Status: VALID

View Type

A Business Intelligence System view


This view gives the information of associated pricing attributes of a Factor list.


[View Source]

Columns
Name Datatype Length Mandatory Comments
LIST_LINE_ID NUMBER
Yes
PRICING_ATTRIBUTE_CONTEXT VARCHAR2 (30)
PRICING_ATTRIBUTE VARCHAR2 (4000)
PRICING_ATTR_VALUE_FROM VARCHAR2 (4000)
PRICING_ATTR_VALUE_TO VARCHAR2 (4000)
FACTOR_LIST_ID NUMBER

COMPARISON_OPERATOR_CODE VARCHAR2 (30)
_LA:COMPARISON_OPERATOR_CODE CHAR (70)
PRICING_ATTRIBUTE_ID NUMBER
Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
_DF CHAR (31)
Descriptive Flexfield column values of qp_pricing_attributes table.
ORIG_SYS_HEADER_REF VARCHAR2 (50)
ORIG_SYS_LINE_REF VARCHAR2 (50)
ORIG_SYS_PRICING_ATTR_REF VARCHAR2 (50)
Query Text

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


SELECT LIST_LINE_ID
,      PRICING_ATTRIBUTE_CONTEXT
,      PRICING_ATTRIBUTE
,      PRICING_ATTR_VALUE_FROM
,      PRICING_ATTR_VALUE_TO
,      FACTOR_LIST_ID
,      COMPARISON_OPERATOR_CODE
,      _LA:COMPARISON_OPERATOR_CODE
,      PRICING_ATTRIBUTE_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      _DF
,      ORIG_SYS_HEADER_REF
,      ORIG_SYS_LINE_REF
,      ORIG_SYS_PRICING_ATTR_REF
FROM APPS.QPFV_FACTOR_ASSO_PRICING_ATTRS;

Dependencies

[top of page]

APPS.QPFV_FACTOR_ASSO_PRICING_ATTRS references the following:

SchemaAPPS
SynonymQP_LIST_LINES
SynonymQP_PRICING_ATTRIBUTES
PL/SQL PackageQP_QP_FORM_PRICING_ATTR - show dependent code

APPS.QPFV_FACTOR_ASSO_PRICING_ATTRS is not referenced by any database object