[Home] [Help] [Dependency Information]
Object Name: | QP_DEBUG_REQ_PROD_LINE_ATTRS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | QP.QP_DEBUG_REQ_PROD_LINE_ATTRS_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
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. | |
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. | |
QUALIFIER_PRECEDENCE | NUMBER | The precedence number, or selectivity of the qualifier attribute in the Qualifier Descriptive Flexfield. It is used by the pricing engine for in-compatability resolution. | ||
DATATYPE | VARCHAR2 | (30) | Date Type of Attribute Value. | |
PROCESSED_CODE | VARCHAR2 | (3) | 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. | |
PRODUCT_UOM_CODE | VARCHAR2 | (30) | unit of measure of the item, product group etc. for which the price or modifier is defined. | |
EXCLUDER_FLAG | VARCHAR2 | (1) | Excluder Flag. | |
GROUP_QUANTITY | NUMBER | Sum of the price of group of lines. Used for internal engine use. | ||
GROUP_AMOUNT | NUMBER | To determine qualification engine sets this flag to indicate that this is unique qualifier. | ||
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. |
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
, APPLIED_FLAG
, PRICING_STATUS_CODE
, PRICING_STATUS_TEXT
, QUALIFIER_PRECEDENCE
, DATATYPE
, PROCESSED_CODE
, PRODUCT_UOM_CODE
, EXCLUDER_FLAG
, GROUP_QUANTITY
, GROUP_AMOUNT
, PRIMARY_UOM_FLAG
FROM APPS.QP_DEBUG_REQ_PROD_LINE_ATTRS_V;
APPS.QP_DEBUG_REQ_PROD_LINE_ATTRS_V is not referenced by any database object
|
|
|