DBA Data[Home] [Help]

APPS.QP_PRICE_BOOK_PVT dependencies on MTL_UOM_CLASSES

Line 1590: mtl_uom_classes mcl

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
1594: and nvl(muom2.disable_date,

Line 1621: mtl_uom_classes mcl

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
1624: AND mcl.uom_class = muom.uom_class
1625: AND nvl(mcl.disable_date,trunc(a_effective_date)+1) >

Line 1637: mtl_uom_classes mcl

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)
1641: AND a.pricing_attribute_context IS NULL