Product: | PMI - Process Manufacturing Intelligence (Obsolete) |
---|---|
Description: | Pricing information for an item broken down by quantity, warehouse, grade, customer, pricelist. |
Implementation/DBA Data: | APPS.PMIBV_ITEM_PRICE_V |
SELECT PRICEITEM.QC_GRADE
, /* REGULAR ATTRIBUTES */ PRICEITEM.PRICE_UM
, PRICEITEM.BASE_PRICE
, PRICEITEM.FRTBILL_MTHD
, PRICEITEM.LINE_NO
, PRICEITEM.PRICE_TYPE
, PRICEITEM.BREAK_TYPE
, PRICEITEM.PRICELIST_ID
, /*ID*/ PRICEITEM.PRICE_CLASS
, PRICEITEM.PRICE_ID
, PRICEITEM.ITEM_ID
, PRICEITEM.WHSE_CODE
, PRICEBREAK.LINE_NO
, PRICEBREAK.QTY_BREAKPOINT
, PRICEBREAK.VALUE_BREAKPOINT
, PRICEBREAK.BREAKPOINT_FACTOR
, PRICEBREAK.BREAKPOINT_PRICE
, PRICEBREAK.BREAKTYPE_ID
, PRICEITEM.CREATED_BY
, /* WHO */ PRICEITEM.CREATION_DATE
, PRICEITEM.LAST_UPDATE_DATE
, PRICEITEM.LAST_UPDATED_BY
FROM OP_PRCE_ITM PRICEITEM
, OP_PRCE_BRK PRICEBREAK
WHERE PRICEITEM.PRICE_ID = PRICEBREAK.PRICE_ID
AND PRICEBREAK.DELETE_MARK = 0
AND PRICEITEM.DELETE_MARK = 0 WITH READ ONLY