DBA Data[Home] [Help]

APPS.QP_PRICE_BOOK_PVT dependencies on MTL_UOM_CLASSES

Line 1593: mtl_uom_classes mcl

1589: FROM mtl_system_items msi2,
1590: mtl_units_of_measure muom2,
1591: mtl_uom_conversions mcon,
1592: mtl_units_of_measure muom,
1593: mtl_uom_classes mcl
1594: WHERE muom2.uom_code = msi2.primary_uom_code
1595: and msi2.organization_id = a_organization_id
1596: and msi2.inventory_item_id = a_item_id
1597: and nvl(muom2.disable_date,

Line 1625: mtl_uom_classes mcl

1621: UNION
1622: SELECT a_item_id item_id, muom.uom_code uom_code
1623: FROM mtl_units_of_measure muom,
1624: mtl_uom_conversions mcon,
1625: mtl_uom_classes mcl
1626: WHERE mcon.uom_code = muom.uom_code
1627: AND mcon.inventory_item_id = a_item_id
1628: AND mcl.uom_class = muom.uom_class
1629: AND nvl(mcl.disable_date,trunc(a_effective_date)+1) >