[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | PMIBV_ITEM_PRICE_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  PMI.PMIBV_ITEM_PRICE_V
|
| Subobject Name: | |
| Status: | VALID |
A Business Intelligence System view
Pricing information for an item broken down by quantity, warehouse, grade, customer, pricelist.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| QC_GRADE | VARCHAR2 | (4) | QC grade to which these prices apply. Contains a NULL value to denote an "ALL" condition. Only applicable for grade-controlled items. | |
| PRICE_UOM | VARCHAR2 | (4) | Yes | Pricing uom |
| BASE_PRICE | NUMBER | Yes | Base price for the item/item class/whse/qc grade/frtbill_mthd/uom combination. May be zero. | |
| FRIEGHT_BILL_MTHD | VARCHAR2 | (4) | Freight bill method to which these prices apply. Contains a NULL value to denote an "ALL" condition. | |
| PRICEITEM_LINE_NO | NUMBER | (5) | Yes | For use with future or custom pricing when fields, such as attribute columns, are used as part of the key, but are not part of the defined key. Default is zero. |
| PRICE_TYPE | NUMBER | (5) | Yes | Type of prices established as price breaks. Valid values are: 0 ,1,2 & 3 |
| BREAK_TYPE | NUMBER | (5) | Yes | Indicates the type of price breaks defined for this record. Valid values are: 0 = no price breaks defined, 1 = qty breakpoints defined, 2 = value breakpoints defined. |
| PRICELIST_ID | NUMBER | (10) | Yes | Pricelist to which these item prices belong. |
| PRICE_CLASS | VARCHAR2 | (8) | Item price class. May be NULL when ITEM_ID has a valid value. | |
| PRICE_ID | NUMBER | (10) | Yes | Surrogate id to uniquely identify each row. |
| ITEM_ID | NUMBER | (10) | Item to which these prices apply. Contains NULL value when PRICE_CLASS has a valid value. | |
| WAREHOUSE_CODE | VARCHAR2 | (4) | Warehouse code for which these prices apply. Contains a NULL value to denote an "ALL" condition. | |
| PRICEBREAK_LINE_NO | NUMBER | (5) | Yes | Part of primary key to distinguish between unique quantity and value breaks. |
| QTY_BREAKPOINT | NUMBER | Quantity break for price. | ||
| VALUE_BREAKPOINT | NUMBER | Value break for price (item qty * base price). | ||
| BREAKPOINT_FACTOR | NUMBER | Percent which is applied to base price for this price detail to compute the unit price for the break value or qty. | ||
| BREAKPOINT_PRICE | NUMBER | Unit price which applies for this break value/qty. | ||
| BREAKTYPE_ID | NUMBER | (10) | Yes | Surrogate id which uniquely identifies this row. |
| CREATED_BY | NUMBER | (15) | Yes | Standard who column |
| CREATION_DATE | DATE | Yes | Standard who column | |
| LAST_UPDATE_DATE | DATE | Yes | Standard who column | |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column |
Cut, paste (and edit) the following text to query this object:
SELECT QC_GRADE
, PRICE_UOM
, BASE_PRICE
, FRIEGHT_BILL_MTHD
, PRICEITEM_LINE_NO
, PRICE_TYPE
, BREAK_TYPE
, PRICELIST_ID
, PRICE_CLASS
, PRICE_ID
, ITEM_ID
, WAREHOUSE_CODE
, PRICEBREAK_LINE_NO
, QTY_BREAKPOINT
, VALUE_BREAKPOINT
, BREAKPOINT_FACTOR
, BREAKPOINT_PRICE
, BREAKTYPE_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
FROM APPS.PMIBV_ITEM_PRICE_V;
APPS
OP_PRCE_BRK
OP_PRCE_ITM
APPS.PMIBV_ITEM_PRICE_V is not referenced by any database object
|
|
|
|