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


VIEW: APPS.QP_PRICING_ATTR_V

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

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
PRICING_ATTRIBUTE_ID NUMBER
Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
LAST_UPDATE_LOGIN NUMBER

PROGRAM_APPLICATION_ID NUMBER

PROGRAM_ID NUMBER

PROGRAM_UPDATE_DATE DATE

REQUEST_ID NUMBER

LIST_LINE_ID NUMBER
Yes
EXCLUDER_FLAG VARCHAR2 (1) Yes
PRODUCT_ATTRIBUTE_CONTEXT VARCHAR2 (30)
PRODUCT_ATTRIBUTE VARCHAR2 (30)
PRODUCT_ATTR_VALUE VARCHAR2 (240)
PRODUCT_UOM_CODE VARCHAR2 (3)
PRICING_ATTRIBUTE_CONTEXT VARCHAR2 (30)
PRICING_ATTRIBUTE VARCHAR2 (30)
PRICING_ATTR_VALUE_FROM VARCHAR2 (240)
PRICING_ATTR_VALUE_TO VARCHAR2 (240)
ATTRIBUTE_GROUPING_NO NUMBER
Yes
LIST_LINE_TYPE_CODE VARCHAR2 (30) Yes
ARITHMETIC_OPERATOR VARCHAR2 (30)
OPERAND NUMBER

PRICE_BY_FORMULA_ID NUMBER

REBATE_TRANSACTION_TYPE_CODE VARCHAR2 (30)
ESTIM_ACCRUAL_RATE NUMBER

CONTEXT VARCHAR2 (30)
ATTRIBUTE1 VARCHAR2 (240)
ATTRIBUTE2 VARCHAR2 (240)
ATTRIBUTE3 VARCHAR2 (240)
ATTRIBUTE4 VARCHAR2 (240)
ATTRIBUTE5 VARCHAR2 (240)
ATTRIBUTE6 VARCHAR2 (240)
ATTRIBUTE7 VARCHAR2 (240)
ATTRIBUTE8 VARCHAR2 (240)
ATTRIBUTE9 VARCHAR2 (240)
ATTRIBUTE10 VARCHAR2 (240)
ATTRIBUTE11 VARCHAR2 (240)
ATTRIBUTE12 VARCHAR2 (240)
ATTRIBUTE13 VARCHAR2 (240)
ATTRIBUTE14 VARCHAR2 (240)
ATTRIBUTE15 VARCHAR2 (240)
COMPARISON_OPERATOR_CODE VARCHAR2 (30)
LIST_HEADER_ID NUMBER
Yes
PRORATION_TYPE_CODE VARCHAR2 (30)
BENEFIT_QTY NUMBER

BENEFIT_UOM_CODE VARCHAR2 (3)
ACCRUAL_CONVERSION_RATE NUMBER

PARENT_LIST_LINE_ID NUMBER
Yes
RLTD_MODIFIER_GRP_NO NUMBER
Yes
RLTD_MODIFIER_GRP_TYPE VARCHAR2 (30)
RLTD_MODIFIER_ID NUMBER
Yes
TO_RLTD_MODIFIER_ID NUMBER
Yes
PRODUCT_ATTRIBUTE_DATATYPE VARCHAR2 (30)
PRICING_ATTRIBUTE_DATATYPE VARCHAR2 (30)
LIST_LINE_NO VARCHAR2 (30)
PRICING_GROUP_SEQUENCE NUMBER

INCOMPATIBILITY_GRP_CODE VARCHAR2 (30)
PRICING_PHASE_ID NUMBER

AUTOMATIC_FLAG VARCHAR2 (1) Yes
OVERRIDE_FLAG VARCHAR2 (1)
PRINT_ON_INVOICE_FLAG VARCHAR2 (1)
PRICE_BREAK_TYPE_CODE VARCHAR2 (30)
MODIFIER_LEVEL_CODE VARCHAR2 (30) Yes
ACCRUAL_FLAG VARCHAR2 (1)
BENEFIT_LIMIT NUMBER

Query Text

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


SELECT ROW_ID
,      PRICING_ATTRIBUTE_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
,      LIST_LINE_ID
,      EXCLUDER_FLAG
,      PRODUCT_ATTRIBUTE_CONTEXT
,      PRODUCT_ATTRIBUTE
,      PRODUCT_ATTR_VALUE
,      PRODUCT_UOM_CODE
,      PRICING_ATTRIBUTE_CONTEXT
,      PRICING_ATTRIBUTE
,      PRICING_ATTR_VALUE_FROM
,      PRICING_ATTR_VALUE_TO
,      ATTRIBUTE_GROUPING_NO
,      LIST_LINE_TYPE_CODE
,      ARITHMETIC_OPERATOR
,      OPERAND
,      PRICE_BY_FORMULA_ID
,      REBATE_TRANSACTION_TYPE_CODE
,      ESTIM_ACCRUAL_RATE
,      CONTEXT
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      COMPARISON_OPERATOR_CODE
,      LIST_HEADER_ID
,      PRORATION_TYPE_CODE
,      BENEFIT_QTY
,      BENEFIT_UOM_CODE
,      ACCRUAL_CONVERSION_RATE
,      PARENT_LIST_LINE_ID
,      RLTD_MODIFIER_GRP_NO
,      RLTD_MODIFIER_GRP_TYPE
,      RLTD_MODIFIER_ID
,      TO_RLTD_MODIFIER_ID
,      PRODUCT_ATTRIBUTE_DATATYPE
,      PRICING_ATTRIBUTE_DATATYPE
,      LIST_LINE_NO
,      PRICING_GROUP_SEQUENCE
,      INCOMPATIBILITY_GRP_CODE
,      PRICING_PHASE_ID
,      AUTOMATIC_FLAG
,      OVERRIDE_FLAG
,      PRINT_ON_INVOICE_FLAG
,      PRICE_BREAK_TYPE_CODE
,      MODIFIER_LEVEL_CODE
,      ACCRUAL_FLAG
,      BENEFIT_LIMIT
FROM APPS.QP_PRICING_ATTR_V;

Dependencies

[top of page]

APPS.QP_PRICING_ATTR_V references the following:

SchemaAPPS
SynonymQP_LIST_LINES
SynonymQP_PRICING_ATTRIBUTES
SynonymQP_RLTD_MODIFIERS

APPS.QP_PRICING_ATTR_V is not referenced by any database object