APPS.QP_PRICE_BOOK_PVT dependencies on MTL_UNITS_OF_MEASURE

Line 1578: FROM mtl_system_items msi, mtl_units_of_measure muom

1574: CURSOR item_uom_cur(a_item_id NUMBER, a_organization_id NUMBER,
1575: a_effective_date DATE)
1576: IS
1577: SELECT msi.inventory_item_id item_id, msi.primary_uom_code uom_code
1578: FROM mtl_system_items msi, mtl_units_of_measure muom
1579: WHERE msi.organization_id = a_organization_id
1580: AND msi.inventory_item_id = a_item_id
1581: AND muom.uom_code = msi.primary_uom_code
1582: AND nvl(muom.disable_date, trunc(a_effective_date) + 1) >

Line 1587: mtl_units_of_measure muom2,

1583: trunc(a_effective_date)
1584: UNION
1585: SELECT a_item_id item_id, muom.uom_code uom_code
1586: FROM mtl_system_items msi2,
1587: mtl_units_of_measure muom2,
1588: mtl_uom_conversions mcon,
1589: mtl_units_of_measure muom,
1590: mtl_uom_classes mcl
1591: WHERE muom2.uom_code = msi2.primary_uom_code

Line 1589: mtl_units_of_measure muom,

1585: SELECT a_item_id item_id, muom.uom_code uom_code
1586: FROM mtl_system_items msi2,
1587: mtl_units_of_measure muom2,
1588: mtl_uom_conversions mcon,
1589: mtl_units_of_measure muom,
1590: mtl_uom_classes mcl
1591: WHERE muom2.uom_code = msi2.primary_uom_code
1592: and msi2.organization_id = a_organization_id
1593: and msi2.inventory_item_id = a_item_id

Line 1619: FROM mtl_units_of_measure muom,

1615: AND pa.pricing_phase_id = 1
1616: )
1617: UNION
1618: SELECT a_item_id item_id, muom.uom_code uom_code
1619: FROM mtl_units_of_measure muom,
1620: mtl_uom_conversions mcon,
1621: mtl_uom_classes mcl
1622: WHERE mcon.uom_code = muom.uom_code
1623: AND mcon.inventory_item_id = a_item_id

Line 1636: mtl_units_of_measure muom,

1632: UNION
1633: SELECT a_item_id item_id, a.product_uom_code
1634: FROM qp_list_lines_v a,
1635: mtl_system_items msi,
1636: mtl_units_of_measure muom,
1637: mtl_uom_classes mcl
1638: WHERE a.product_attribute_context = 'ITEM'
1639: and a.product_attribute = 'PRICING_ATTRIBUTE1'
1640: and a.product_attr_value = to_char(a_item_id)