DBA Data[Home] [Help]

APPS.QP_PRICE_BOOK_PVT dependencies on MTL_UOM_CONVERSIONS

Line 1588: mtl_uom_conversions mcon,

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
1592: and msi2.organization_id = a_organization_id

Line 1620: mtl_uom_conversions mcon,

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
1624: AND mcl.uom_class = muom.uom_class