[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | PMIFV_ITEM_PRICE_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  PMI.PMIFV_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. | |
| WAREHOUSE_DESC | VARCHAR2 | (40) | Name of the warehouse. | |
| ITEM_NUMBER | VARCHAR2 | (32) | Yes | Name of the item. |
| ITEM_DESCRIPTION | VARCHAR2 | (70) | Yes | Short description of the item that is displayed during the item look up. |
| ITEM_UOM | VARCHAR2 | (4) | Yes | Uom of the item by which the inventory balances are maintained. |
| ITEM_UOM2 | VARCHAR2 | (4) | Second UOM for in which inventory balances are maintained, for dual UOM items. | |
| PRICELIST_CODE | VARCHAR2 | (32) | Yes | Unique identifier for a pricelist. Name or code entered by user. |
| PRICELIST_DESC1 | VARCHAR2 | (40) | Yes | Description of price list. |
| PRICESORT_NAME | VARCHAR2 | (20) | Yes | Pricelist sort name. |
| COMMENTS | VARCHAR2 | (80) | Freeform text/comments. | |
| CURRENCY_CODE | VARCHAR2 | (4) | Yes | Currency code for pricelist; FK to gl_curr_mst. |
| 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
, WAREHOUSE_DESC
, ITEM_NUMBER
, ITEM_DESCRIPTION
, ITEM_UOM
, ITEM_UOM2
, PRICELIST_CODE
, PRICELIST_DESC1
, PRICESORT_NAME
, COMMENTS
, CURRENCY_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.PMIFV_ITEM_PRICE_V;
APPS
IC_ITEM_MST
IC_WHSE_MST
OP_PRCE_BRK
OP_PRCE_ITM
OP_PRCE_MST
PMI_SECURITY_PKG
- show dependent code
SY_ORGN_MST
APPS.PMIFV_ITEM_PRICE_V is not referenced by any database object
|
|
|
|