DBA Data[Home] [Help]

APPS.QP_PRICE_BOOK_PVT dependencies on MTL_UOM_CONVERSIONS

Line 1591: mtl_uom_conversions mcon,

1587: UNION
1588: SELECT a_item_id item_id, muom.uom_code uom_code
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

Line 1624: mtl_uom_conversions mcon,

1620: )
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