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

VIEW: APPS.QP_DEBUG_REQ_PRI_LINE_ATTRS_V

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

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Internal row identifier.
REQUEST_ID NUMBER
Yes Request Id is the sequence number to uniquely identify the Debug Requests.
LINE_INDEX NUMBER
Yes PL/SQL unique identifier for request line.
LINE_DETAIL_INDEX NUMBER

PL/SQL unique identifier. Unique identifier of 'request line detail' in calling application.
LINE_ATTRIBUTE_ID NUMBER
Yes Line Attributet Id is the sequence number to uniquely identify the Debug Line Attributes.
ATTRIBUTE_LEVEL VARCHAR2 (30)
Level of attribute. Allowable values are: Line, Detail, Order.
ATTRIBUTE_TYPE VARCHAR2 (30)
Type of Attribute. Allowable values are: Qualifier, Product, Pricing.
LIST_HEADER_ID NUMBER

Identifies the List Header.
LIST_LINE_ID NUMBER

Identifies the List Line.
CONTEXT VARCHAR2 (30) Yes Context for a product or pricing attribute, for example, Product Hierarchy.
ATTRIBUTE VARCHAR2 (30) Yes Product or pricing attribute, for example, PRICING_ATTRIBUTE11: Customer Item ID.
VALUE_FROM VARCHAR2 (240) Yes Passed in value for product or pricing attribute.
SETUP_VALUE_FROM VARCHAR2 (240)
Setup value for product or pricing attribute.
SETUP_VALUE_TO VARCHAR2 (240)
Setup value for product or pricing attribute.
COMPARISON_OPERATOR_TYPE_CODE VARCHAR2 (30)
The relational operator code used to define how the pricing engine should evaluate the pricing attributes or qualifier attributes, based on lookup type 'COMPARISON_OPERATOR'.
APPLIED_FLAG VARCHAR2 (1)
The lists or list lines that this pricing event or a prior pricing event applied. Allowable values are:* Yes: Applicable when the attribute context is a list or list line, * No: Applicable when the attribute context is a list or list line. During simulation, if the user wants an un-applied or rejected line to be considered by the engine for pricing, user can check this flag and re-price.
PRICING_STATUS_CODE VARCHAR2 (30)
Returned status from the pricing engine.
PRICING_STATUS_TEXT VARCHAR2 (240)
Returned message from Pricing Engine.
DATATYPE VARCHAR2 (30)
Date Type of Attribute Value.
PROCESSED_CODE VARCHAR2 (30)
This is set by the engine and used for selecting lines for calculation. Used for internal engine use. Possible values: N - New, D - Deleted, X - Unchanged.
PRIMARY_UOM_FLAG VARCHAR2 (1)
If set to 'Y' it indicates that if the price cannot be found for a product in the UOM passed from the calling application, the pricing engine will convert the transaction quantity to the primary UOM specified.
Query Text

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


SELECT ROW_ID
,      REQUEST_ID
,      LINE_INDEX
,      LINE_DETAIL_INDEX
,      LINE_ATTRIBUTE_ID
,      ATTRIBUTE_LEVEL
,      ATTRIBUTE_TYPE
,      LIST_HEADER_ID
,      LIST_LINE_ID
,      CONTEXT
,      ATTRIBUTE
,      VALUE_FROM
,      SETUP_VALUE_FROM
,      SETUP_VALUE_TO
,      COMPARISON_OPERATOR_TYPE_CODE
,      APPLIED_FLAG
,      PRICING_STATUS_CODE
,      PRICING_STATUS_TEXT
,      DATATYPE
,      PROCESSED_CODE
,      PRIMARY_UOM_FLAG
FROM APPS.QP_DEBUG_REQ_PRI_LINE_ATTRS_V;

Dependencies

[top of page]

APPS.QP_DEBUG_REQ_PRI_LINE_ATTRS_V references the following:

SchemaAPPS
SynonymQP_DEBUG_REQ_LINE_ATTRS

APPS.QP_DEBUG_REQ_PRI_LINE_ATTRS_V is not referenced by any database object