Product: | PMI - Process Manufacturing Intelligence (Obsolete) |
---|---|
Description: | Pricing information for an item broken down by quantity, warehouse, grade, customer, pricelist. |
Implementation/DBA Data: | APPS.PMIFV_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
, WAREHOUSE.WHSE_NAME
, ITEM.ITEM_NO
, /* RESOLVE FOREIGN KEYS */ ITEM.ITEM_DESC1
, ITEM.ITEM_UM
, ITEM.ITEM_UM2
, PRICEMASTER.PRICELIST_CODE
, PRICEMASTER.PRICELIST_DESC1
, PRICEMASTER.PRICESORT_NAME
, PRICEMASTER.COMMENTS
, PRICEMASTER.CURRENCY_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
, OP_PRCE_MST PRICEMASTER
, IC_ITEM_MST ITEM
, IC_WHSE_MST WAREHOUSE
WHERE PRICEITEM.PRICELIST_ID = PRICEMASTER.PRICELIST_ID
AND PRICEITEM.PRICE_ID = PRICEBREAK.PRICE_ID
AND PRICEITEM.ITEM_ID = ITEM.ITEM_ID
AND PRICEITEM.WHSE_CODE = WAREHOUSE.WHSE_CODE(+)
AND (WAREHOUSE.ORGN_CODE IS NULL OR WAREHOUSE.ORGN_CODE IN (SELECT SECORG.ORGN_CODE
FROM SY_ORGN_MST SECORG
WHERE PMI_SECURITY_PKG.SHOW_RECORD(SECORG.ORGN_CODE) = 'TRUE')) WITH READ ONLY